Q3 Technologies: SKU Consolidation & Web Application

Q3 Technologies, Gurgaon, developed a solution for SKU Consolidation & Web Application for a Large Auto Parts Retailer.

Business Situation:

A large auto parts retailer wanted to consolidate its inventory details spread across various formats so that it could provide a single interface for searching and sale of items from its inventory.

Solution:

• An n-tier Java/J2EE architecture was developed by Q3 tech that was modular, highly scalable, and easy to maintain.
• A common data model and database schema was defined for parts details using advanced data modeling tools.
• Business Services and Data Layers were created for querying and updating data in the inventory database. All access to the database had to go thru the business and data layers.
• Web Services/WSDL endpoints were created both for external suppliers to send data to the inventory database as well as for internal tools to import data from the existing formats to the common database.
• A Web2.0 style AJAX based Web based application was created that provided the user with a rich user experience.
• Software utilities were created for reading the existing parts information and migrating it to the database using the Web Services described above.
• Shopping and billing modules were created including interfacing with external systems such as payment gateways etc.