Category Archives: Data Integration

Custom Workflow for Asset Bulk Upload in Information Governance Catalog (IGC)

Client: One of US’ leading health care companies that provide access to quality health care and innovative solutions for members. Business Problem: IBM Information Governance Catalog(IGC) was used as part of the client’s Data Governance effort. In IGC, a steward has to create catalog assets (terms & categories) individually and send for approval. Support for […]

Read More

Data Governance for an Award-winning Private US Bank

Business Problem: As part of the bank’s Data Governance Program for improved Basel Compliance, there was a need to identify and effectively report changes to metadata and monitor data quality, which was not supported out-of-the-box by IBM Information Server. Solution: The bank had implemented various components of IBM InfoSphere Information Server – Business Glossary, Metadata […]

Read More

Data Governance for a Regional Bank in the Midwest US

Business Problem: The client needed data governance to be in place for the bank to handle and manage data effectively and to reduce the risk of exposing sensitive data or a security breach. Our Solution: As part of client’s governance initiative, the bank had implemented IBM InfoSphere Information Server Business Glossary & FastTrack for managing data […]

Read More

Performance Optimization of the Data Integration Platform for a Leading Customer Relationship Marketing Agency

Business Problem: The client was struggling with a non-scalable data integration platform that could not take in the ever increasing data volumes Our Solution:  The work involved performance tuning of data load jobs to load Click-Stream analytics data to support the increased data volumes in the available load window and thereby improve the utilization of the […]

Read More

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