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