Client is a Leading Semiconductor design company in California.
Objective
- Build a Sales Data Mart that consolidates data from the company’s CRM application, ERP application and Point-of-Sales Transaction
- Build a Sales universe on top of the Data Mart that enables cross-functional analysis over opportunities, orders and shipments.
- Provide a mechanism to refresh the data mart on-demand.
Benefits
- 360 view of a sales cycle: Ability to analyze a sales cycle from a lead to a shipment through an integrated framework.
- Integrated Customer Data: Customer Data from three different sources integrated through MDM (master data management) techniques prompting a complete view of the customer.
- Data Quality Enhancement: Implemented Business Rules and quality checks in the ETL layer to take care of discrepancies in the CRM data.
- Optimum Cost Model: With all the development done offshore, there was substantial Value innovation done in terms adding high value at low cost
Solution
Power Integrations chose InfoSTEP Inc. as the implementation partners for the sales universe with most of the development to be done offshore. The technology uses was Business Objects Data Integrator and 6.5
InfoSTEP Inc. conducted a two-week requirements/ source system analysis in order to understand business requirements and helped client define business rules for integrating master data.
- Developed a dimensional data mart with multiple facts and conformed dimensions .
- Provided a CDI (Customer Data Integration) solution by integrating customer data from the CRM, ERP and Point of Sales Applications.
- Built a business friendly, end-user driven Sales Universe for ad-hoc analysis and standard reporting.
Challenges
- High volatility in CRM data.
- Multiple instances of the same customer.
- Standard issues like network speed etc owing the offshore delivery model.
- Frequent updates to the source systems led to frequent changes and in requirements and inability to freeze the environment.
