Conversion of legacy retail application in collaboration with IT consulting partner About the Client The Client is a Germany-based company providing soft solution for procedure automation of different businesses in the Garments Industry. The Client has a tie-up with internationally branded garments manufacturers such as Greystone, GMV etc. that sells their garment products through their retail chains with retail outlets spread throughout Europe and America. The Business Need The end Client had its data in ERP legacy system that had become stale, corrupt and un-normalized. The Client wanted to upgrade and correct this legacy database by heterogeneous import of ERP data in a new normalized database periodically, as a scheduled job. The end client faced a huge problem while  manually importing data of Inventory Report, Dispatch Advice, Sales Report, Relocations/Returns of stock etc. received as EDI messages  in file format from more than 1500 sales floors, spread across the globe, on daily or periodical basis. Since the data was enormous considerable time was lost to import them to the ERP database, ensure its correctness, and was a threat to data security. These data was of prime importance for generating various reports for efficient management of the business operation.   The end client also faced problem in creating, listing, editing, deleting of main entities like Product Carriers, Product Carrier Clusters, and Sales Floors. They also lacked a mechanism to create, list, edit, delete its Users as well as granting them required roles,  privileges to enforce security of data, role wise functions etc. BrickRed’s client was awarded the project but the issue was the limited budget as well as time frame to cover the development cost.   The Solution The clients after doing thorough research choose BrickRed as its offshore development partner to provide the solution.  In association with the client, BrickRed experts examined the end client’s legacy ERP database and the huge amount of data present. BrickRed followed agile development methodology to reduce costs while close association and regular meetings between development team and client ensured timely faultless product. Our team changed the database schema and normalized it so that the data does not become stale and corrupt. A scheduler was created to fetch data from ERP to update the date in the database. It was ensured that the data takes minimum time to update. Additionally, the heterogeneous nature of the database was taken care and corrupt and stale data were blocked. The existing legacy System was changed to web-based application with proper MVC architecture. Latest tools like hibernate, Struts and J2EE design patterns were used to make it efficient, trouble-free, robust, scalable and maintainable. The application was also made to support to create, list, edit, delete different entities like Product Carriers, Product Carrier Clusters, Sales Floors etc. The huge amount of EDI Messages imports was automated with provision for manual intervention. An error logging mechanism enabled identification of cause of failure in importing EDI Message from a file. The application’s Report module enabled generation of different useful reports to enable a greater control for the administrator to ensure effective management and decision making. Technologies • JDK 1.5 • J2EE 1.4 • Struts • Hibernate Benefits: • The project went into operation without any schedule variance. • The SQA team developed a robust test plan with close eyes on problem tracking report leading to high resolution and interoperability. Testimonial: Outsourcing to BrickRed is working very well for us. We are able to deliver the product to our clients very quickly at lower costs which is helping us to win their trust and generate more business. We are continuously using BrickRed for our other projects as well. - Client’s Project Manager