Data Governance Analyst Resume
2.00/5 (Submit Your Rating)
Malvern, PA
SUMMARY
- Over 5+ years of work experience in Business Analysis and Data Analysis in investment asset, wealth management and financial services. Specialized in implementation of investment management tools and Data Governance
- Vast experience in creating Policies, Procedures, Standards and Guidelines to govern Data using Collibra DGC
- Created business cases to justify Data Governance for organization through various power point presentations to various Data Stake holders (Including LOB Executives)
- Hands on experience in building Catalogs using Alation, Collibra Catalog and Informatica EDC
- Experience in working with the key components of the Collibra DGC such as Business Glossary, Reference Data Stewardship, Data Dictionary, Data Helpdesk, Policy Manager, Issue Management and Data Catalog
- Good understanding of the Collibra operating model with self - driven capabilities in implementing the use cases with minimal supervision
- Managed accounting metadata in Collibra such as fixed assets, accounts receivables, inventories and built financial statements data sets in Collibra data governance center
- Hands on experience in maintaining technical assets using Ab initio Metadata Hub (MHUB)
- Analyzed data processes and business rules to document data flows, metadata and data lineage
- Build Metadata Lineages (Traceability) in Collibra for a variety of use cases
- Extensively used Collibra Rest APIs to build User Metrics such as Stewardship, Business Assets, Technology Assets and Users/Assets per LOB
- Good Function expertise on Compliance and Risk management, Asset Management, Trade Processing, Portfolio Compliance, and Fund Accounting
- Coordinated and led Data Governance working groups Stakeholders like Data Stewards, Data Custodians, Data Consumers and Data Owners
- Vast experience in generating dashboards to report KPIs and KRIs to senior stakeholders
- Created the business glossary and metadata for various data domains elements by working with SMEs
- Generated dashboards using Tableau and Microsoft excel
- Well versed with GDPR, CCPA, GAAP regulations to address the Data Governance and Privacy needs
- Used Collibra and Excel to document data governance flows, metadata, data quality metrics and data lineage
- Experience in creating data mapping documents between multiple systems
- Strong excel skills like writing complex formulas (using VLOOKUP, INDEX etc.,), creating reports, PIVOTs, and macros
- Ability to understand the existing business process issues and reverse engineer to implement the effective business process
- Creating flow diagrams for critical data elements while implementing Data Lineage
- Experience in Defect Tracking, Requirements Tracking and Change Request implementation
- Setup interview sessions with end users for requirement elicitation
- Worked with internal architects and, assisting in the development of current and target state
- Expertise in various types of software development life cycles like waterfall, agile scrum/kanban/safe
- Extensively involved in Test Plan Creation, reviewing and monitoring progress, risks and resources, schedules
- Strong analytical and problem resolution skills with ability to plan, prioritize, and work efficiently in a multi-tasking environment
TECHNICAL SKILLS
- Collibra, Informatica EDC, Erwin, Ab initio MHUB, Policy Documents, Asset Management, Investment Management
- Retail Banking, Business Analysis, Requirements Gathering, Data Analysis, Project Management, Data Management Reporting
- Change Management, Software Development, Rest API, SQL, SSRS, PL/SQL, Tableau, JIRA, Python
- MS Office suite, MS Visio, Share Point, Agile, UML, HTML, Web Services
PROFESSIONAL EXPERIENCE
Confidential, MALVERN, PA
Data Governance Analyst
Responsibilities:
- Implemented and Administered Collibra Data Governance: Setup Business Glossary, Workflows, Data Governance Assets, Setup users and Created groups
- Set up Collibra Communities, Domains, Types, Attributes, Status, Articulation, Workflow and customize attribution and solution including custom dashboard with metrics, status, workflow initiation and issue management for each Domain specific requirements
- Responsible to work with the business for RACI activities and in corporate them in Collibra
- Configured dashboards and reports based on business requirements
- Exported metrics out of Collibra using Rest Core APIs (Collibra v5.x)
- Gathered and documented metadata requirements using standardized project documentation
- Customized workflows in Collibra based on the Governance model Roles and Responsibilities
- Performed an end to end data lineage assessment and documentation for Critical Metrics
- Provided regular status reports to the management
- Used Lucid Chart to draw business process swim lane diagrams
Confidential
Data Governance Analyst
Responsibilities:
- Performed detailed metadata analysis in a large and complex data environment across a range of technologies including relational database and big data platforms using Collibra
- Responsible to work with Finance SME s to manage and govern accounting data in Collibra under the respective communities and domains
- Worked with business and technical resources and stakeholders, facilitate the creation and capture of business level, technical level, and data lineage metadata
- Defined and documented business and technical metadata; perform analysis and research to harmonize terms and definitions across systems and business areas
- Performed data element classification and mapping to business uses and impacts
- Developed framework and methodology for ongoing capture and maintenance of business and technical metadata
- Worked with metadata tool (Collibra) and development resources to develop strategy and planning for metadata tool use and implementation across the enterprise
Confidential
Business Analyst
Responsibilities:
- Worked on Data Governance for Asset & wealth management data, Basel Committee on Banking Supervision (BCBS 239) and IHC Regulatory projects
- Assisted Data Governance Office in designing policies for different data domains like corporate, security master, KYC, Pricing and holdings data
- Worked with Collibra to automate data governance artifacts, data governance assets and workflows.
- Used Visio to document data flows, system flows and process flows
- Assisted Data Governance manager in preparing working group meeting agendas and meeting minutes
- Did end to end data assessment and documentation for CDEs. Used various methods to shortlist and finalize CDEs
- Assisted in designing data quality rules working with data stewards
- Analyzed various Tableau reports, crystal reports to understand the data usage and related business rules.
- Used SQL to analyze data on SQL Server and Oracle data bases to analyze CDEs and related KPIs
- Used various dashboards using Tableau to report data quality measures and data governance progress to the management
- Documented data lineage as technical and business assets
- Assisted with data governance policies and implemented the same by working with data owners and data stewards
- Interviewed various business and technical users to trace the business and technical lineage and documented using Excel and Visio
- Created the business glossary for various data domains
- Documented data quality rules by working with the data stewards and custodians
- Used SQL to join data from multiple database sources and create a data reconciliation framework
- Worked on Data Mapping and data validation of various data domains
- Worked on Data validation using complex Excel functions like VLOOKUP’s, Power Pivot and VBA Macros
