National Automotive Reseller | Automobile Industry
This Corporation was established in 1998 to create the largest nationwide source for quality recycled auto parts. We helped them in Automotive Analytics. Throughout the next decade, we expanded into reconditioned, re manufactured, aftermarket, and self-service auto parts. With the Keystone Automotive acquisition in 2007, we became the nation’s largest distributor of alternative collision replacement auto parts. Since then, we have added a heavy truck division and continued to grow our re manufacturing capabilities.
Integrating the data from Multiple ERPs like Project X, Oracle Financials.
Pull the data from Multiple Locations across US and Canada. The Information was at multiple Currencies.
No Integrated Reporting and Analysis System available for Decision Making.
There was lot of Manual work Involved ,which Used to Delay the Decision Making.
Understand the Prelude and Oracle Financials ERP. Document the Process. Design Develop the Data warehouse. ETL using Datamanager. Design and Develop the Cubes Data security for Different Locations.
Automation of the Reporting System. Provided Data Security based on Domain and Management Hierarchy.
Thinklayer Provided Complete BI Solution with Cognos and Datamanager. Developed and Implemented Reports and Cubes across domains like Purchasing, Sales and Finance. Provided the Accurate data from ERP(s) for Analysis which helped in deciding the Commissions Accurately.
Cubes Helped in getting answers to business questions, rather than spending hours reading through volumes of printed report. Developed Consolidated Dashboards with drill downs, which helped to identify bad/Under Performing Customer/Product/Manager/Sales Rep.