Category Archives: Case Studies

Integrate New Feed into a Datawarehouse for a popular US-based Nutrition company

Business Problem: The client needed to enhance their Datawarehouse to include additional feeds from a new geography they were expanding into Our Solution:  Integrated new bi-directional data feeds for Customer, Sales & Inventory to the Enterprise Data Warehouse for a new geography. The Company wanted to integrate data from China operations into the Enterprise Data warehouse […]

Read More

Data Integration For A Pioneering North American Mail/Workflow Solution Provider

Business Problem: There was a need to integrate data across various systems as part of the overall Enterprise Application Integration portfolio for the client Our Solution: Develop Data Integration jobs to integrate various systems using the existing Enterprise Application Integration infrastructure. This includes a variety of sources ranging from flat files, Complex Flat files (mainframe), XML, RDBMS, SFDC […]

Read More

Re-Platforming the Datawarehouse And BI Platform For a Global Semiconductor Manufacturer

Business Problem: The existing Datawarehouse and the BI platform was not scaling to the ever increasing data volumes and required to optimized or migrated to a newer platform Our Solution:  The work involved understanding the current data integration framework developed using custom PL-SQL scripts and effectively migrate (re-write as parallel jobs in DataStage). The existing Datawarehouse in Oracle […]

Read More

Data And Reports Consolidation For US-Based Automotive OEM Major

Business Problem: The Sales and Operations business users were unable to get an integrated view of their operations due to lack of consolidated data. Our Solution: A Datawarehouse consolidating data across departments was proposed. The work involved the design, development and implementation of ETL for the Datawarehouse implementation . An understanding of the business work […]

Read More

Master Data Management For A US East Coast Based Large Casino-Cum-Resort Complex

Business Problem: A need to create a centralized repository of the casino’s guests to provide personalized services and do targeted marketing, while also adhering to the compliance requirements of the Directorate of Gaming Enforcement. Solution: The work involved implementation of a business critical real-time MDM and ESB implementation providing users the ability to access, write, […]

Read More