Data Governance Specialists - "Doing it right MATTERS!!!" Over 2 decades of expertise
Case Studies #1
A Leading Telecom Company
Business Challenge
Maintained Critical Data Issues in Excel Spreadsheet and has no experience in Data Governance program or practice. Always overwrote the analysis of others thus losing crucial time to redo the task all over again from start.
What’s Smart?
Implemented Data Governance using Collibra DGC
Smarter Business Outcome
- One-stop shop to manage Terms, Reference Data, Data Issues, Data Quality, Data Access and Data Sharing across the Enterprise and with External Stakeholders
- Manage Glossary, Reference data and complex integration with Oracle DRM Master Data, SAP HANA, SAP ECC/SCM, Peoplesoft CRM, Teradata Warehouse, Informatica IDQ, Jira/Confluence, and Cognos Reports
- Manage Data Issues, remediation and escalation, Change Request workflow
- Custom Dashboard for Issues, Tasks, Resolution, Performance Metrics, KPI
Case Studies #2
A Leading Automobile Company
Business Challenge
Maintained Critical Data in Sharepoint and Access database and were new to Data Governance program or practice
What’s Smart?
- Implemented Data Governance using Collibra DGC.
- Migrate Business Glossary from IBM IGC, ACCESS Database, Sharepoint and Excel Spreadsheets.
Smarter Business Outcome
- Manage Terms, Reference Data, Data Issues, Data Quality, Data Access and Data Sharing across the Enterprise and with External Stakeholders Develop complex groupings, hierarchy and crosswalks for terms, code values, code sets
- Manage complex integration with Mulesoft and Collibra Connect for sources SAP S4, GVIT, HANA, Oracle DRM, SAP HANA,
- Manage Custom Change Request workflow using Activiti for all Assets
- Custom Dashboard for terms, reference data, Issues, Tasks, Resolution, Metrics, KPI
- Manage RACI activities and custom roles to support workflow process for each custom community/domain
Case Studies #3
A Leading Financial Investment Company
Business Challenge
Previous moderately built Data Governance Programs lacked many functionalities that did not perform optimally to meet their growing regulatory, compliance and management demands.
What’s Smart?
Implemented Data Governance with robust strategy across 11 Global Domains and complex workflow process. Tool: IBM IGC
Smarter Business Outcome
§With Critical data, PII and legal aspects of access to data, applications and its storage requirements, a robust EDGP was developed with custom attributes tied to Business Glossary Terms and custom Integration on multiple levels to various sources to support stakeholders with multi-level complex stewardship Process and custom Dashboard reporting.
Case Studies #4
A Leading Financial Lending Company
Business Challenge
Compelled to act on accuracy and reporting standards, CIT adopted the Metadata Management Strategy
What is Smart?
AVS Implemented Metadata Management and leveraged IBM Tool IGC, RDBMS, Data Models, DataStage ETL, Data Warehouse, MDM, disparate systems, SAP Business Objects and hundreds of Excel mapping converted to FastTrack.
Smarter Business Outcome
- Report on Business Lineage and Data Lineage
- Gain valuable Insights into ETL design metadata, transformation, and reuse.
- Eliminate manual discovery and data-flows.
- Promote efficiency in staff, increased governance and visibility
