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 hundreds of arborists throughout the United States, Canada and the UK, can place various items, such as buildings, decks, ponds and more importantly trees and shrubs, on an electronic diagram. This bird’s-eye view 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 originally 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.

The ELM application has been in production since 2001 and has had many 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 VB.NET.  New screens have been developed using .NET Interop controls.

Technologies

  • Visual Basic
  • VB .NET Interop
  • Oracle Lite
  • .Net Framework
  • Oracle