Forums Forums  |  Forums Sitemap

Case Studies

Enterprise Application Migration

Business Challenge

A leading US based Chemical company with multiple offices needed to upgrade some of their core business applications. Their existing applications were based on VB6 and SQL Server 2000, but none of the existing source, documentation or test cases existed. These applications were mission critical applications as they were responsible to carry out all business transactions.

Our Solution

In order to minimize the risk associated with a re-write, we focused on a solution which leveraged the existing database and infrastructure components. This approach would allow us to run both applications in parallel which supported a phased production roll-out and stabilization period.

With the high-level approach determined, the remaining implementation followed the following process:

  • Business Process Discovery - Identify organizational roles and responsibilities and map those roles to main application work flows.
  • Reverse Engineering of Existing Application - Identify and document all application usage scenarios while profiling the database to document event-to-database mappings.
  • Design and Development - Iterative based construction and testing of the new application utilizing the .Net framework. The iterative delivery approach allowed the team to work with organizational SMEs to verify functional equivalence and also accommodate application improvements requested by the business and end-users.
  • Implementation and Post-Production - Phased roll-out of the application to multiple locations. As the client had multiple physical locations, we implemented a "Train the Trainer" strategy at each site. These trainers were also our first line of defense in the event an application issue was perceived.

Benefits Realized

The application was rolled out, as planned, with no major defects encountered and was well received by corporate stakeholders. Some components of the application were based on older, non-supported, COM components and new 3rd party modules needed to be introduced to the application, which increased training and adoption time by end-users, however, within a week of roll-out, no additional training was required and the end-users ultimately saw increased operational performance.