Mobile Landscape Manager

Bartlett hired SharpHat to standardize their workflow and reduce paperwork through a mobile application.

 
1
1
Pillars

Strategy

Design

Development

Overview

Bartlett needed an application that could standardize their selling functions, maintain compliance with state and federal laws, standardize proposal language throughout each branch office, improve sales and customer service, and reduce turnaround time for proposals.

Business Objective

Electronic Landscape Manager (ELM) is a mobile solution that provides the ability to create graphical representations of client properties. Bartlett’s sales force, which consists of 180 arborists, can place various items, such as buildings, decks, ponds and more importantly trees and shrubs, on an electronic diagram using a pen tablet computer. This bird’s-eye view of the customer’s property allows the arborist to quickly analyze an entire property and easily locate items that need work. Users can record detailed information about each tree or shrub, which can be quickly accessed in future visits.

SharpHat Involvement

The implementation of this mobile solution increases the accuracy of proposals and standardizes business procedures to enhance the quality of service offered by Bartlett. ELM also streamlines the entire proposal process by giving arborists the ability to evaluate conditions and generate proposals on site. A searchable database allows reps to access critical information that helps them diagnose insect and disease problems, thus reducing calls to Bartlett’s Tree Research Laboratories and its team of experts in plant pathology, entomology and soil sciences by as much as 60%.

“We want to service our customers in a different way than most arborists do. This solution gives us the necessary tools to accomplish this objective.”
– David Andry • Bartlett Vice President of MIS.

The Results

ELM was written in Visual Basic 6.0 with an Oracle Lite database and was originally deployed on Windows 98 Fujitsu Stylistic tablet computers. Oracle replication was used to synchronize data to and from the server, which runs Oracle 10g.

The ELM application has been in production since 2001 and has had over 95 revisions and upgrades since its initial release. The Windows 98 Fujitsu tablets have been replaced by Windows laptops and tablets. Finding limitations in Oracle replication, SharpHat developed a custom data synchronization tool that was written using the Microsoft .NET Framework version 3.5.

Technologies

  •  Visual Basic 6.0
  • Oracle Lite
  • .Net Framework version 3.5
  • Oracle 10g