Category Archives: Case Studies

Predictive Cash Flow For US -Based Healthcare Providers And Practitioners

Business Problem: The Financial Officers of the Healthcare providers have insufficient information to understand the reasons for unpredictable long revenue cycle. Our Solution: The work done was to predict the cash flow from claim reimbursements  for healthcare providers using  historical data. The predictions made were How much money can be expected? When is the money […]

Read More

Data Discovery/Visualization using Qlikview for US Division of one of the World’s Largest Property Services Firms

Business Problem: Client wanted to present the key metrics on their properties, leases , property maintenance and performance records to the property owners and brokers in a form which is actionable as well as visually appealing. The nature of data for the dashboard presented a challenge , varying from structured databases to CSVs and XML sources. […]

Read More

Data Quality Management for a Federal Ministry

Business Problem: The client needed to implement a Data Quality management system for continuous monitoring of data quality Our Solution: The work involved defining data quality rules and rule sets to profile and check data against defined business logic. The project involved understanding of  the business logic and defining rules to check the data for adherence […]

Read More

Data Quality Management for a Canadian Federal Department

Business Problem: The client needed to identify bad quality data and cleanse data issues during migration from Mainframe to Oracle Our Solution: The work involved developing DataStage jobs with Data Rules Stage to identify & cleanse data issues. Data Rules developed in Information Analyzer were reused in DataStage to identify & cleanse the data issues. Each record […]

Read More

Data Quality Management for one of the Largest and Fastest-growing Coordinated Care plans in the US

Business Problem: The client had to profile membership and claims data in order to assess the quality of data and continuously monitor the quality. Our Solution: The work involved design and development of rules to profile membership and claim data based on business logic. Reviewed existing rules with respect to best practices for performance and maintenance and recommended […]

Read More

Data Quality Dashboard and Data Governance Work for a US–based Non-profit Performing Rights Organization

Business Problem: The client needed a Dashboard to track and monitor the progress of the Data Governance projects with respect to building a Glossary, linking it to Information Assets and measuring Data Quality. Our Solution: : To monitor the progress of the rollout and continually track the effectiveness of their Data Governance Program, a non-profit organization managing music […]

Read More

Data Quality Dashboard for a Top Theater Chain in the US

Business Problem: The client needed a dashboard to measure the quality of the data and review the effectiveness of the quality rules Our Solution: The work involved design of a custom Dashboard that will allow the  Enterprise to measure Data Quality and the effectiveness of the Data Quality Rules. This required profiling of  the data, development […]

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