Java Development - CRM Product

Introduction

Post-sales CRM product provides Manufacturers a way to view and analyze consumer data collected from virtually every department within the organization. The CRM product also offers integrated technology-enabled services such as product registration, consumer surveys, Extended Service Contracts, eCommerce sales channels, Rebate program management, warranty claims processing, warehousing and distribution services, and more. The project migration dealt with the migration of the database being used by CRM product from oracle to postgres (a free source database). The project also involved making changes the way database was being accessed as earlier a middle tier Powertier was used to make calls to the database and there was no know-how about the way Powertier accesses database. It was just a black box to which some parameters are sent as input and it returns the required object as output using a set of inbuilt beans and interfaces. This migration project also involved replacing Powertier with Hibernate and using jdk 1.5 instead of jdk 1.2 which was used earlier when the existing project was developed a few years back. The project also involved migration from Oracle 10G Portal to JBoss Portal.

Challenges

Solution

The application was modified using the following technologies:

Cronjobs are modified to use the following technologies:

Team

14 resources deployed on the project development including Project Manager, Team Leader, DBA, Analyst and developers with expertise in Oracle, Java, hibernate and Postgres SQL.

Benefits

The maintenance and licensing cost was reduced by more than one third. Since client doesn't need to have full time employees for maintenance of the application, major cost reduction is also reflected in the enhancement of the product. The switchover was done with downtime of 6 hours to provide the continuous service to the end user. Performance of the migrated application was up to the mark as expected. The project met the client’s expectations in terms of estimated cost, time and quality.