Ahmed Ullah
New York,NY
Summary
Results-oriented Data Governance Analyst with expertise in data quality, regulatory reporting, Collibra, UAT testing, stakeholder engagement, and data quality controls. Proven track record in designing and implementing data governance strategies to ensure data integrity, compliance, and regulatory requirements. Skilled in analyzing data quality issues, implementing data cleansing methodologies, and establishing effective data quality controls. Experienced in leveraging Collibra Data Governance Platform to streamline data governance processes, manage metadata, and enhance data stewardship. Strong ability to conduct UAT testing, ensuring accurate and reliable data for reporting purposes. Adept at engaging stakeholders across the organization to drive data governance initiatives and foster a culture of data-driven decision-making. Committed to delivering high-quality data governance solutions that support business objectives and regulatory compliance.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Governance/Regulatory Reporting Analyst
MUFG UNION BANK
01.2021 - Current
- Worked on Data Governance for Asset & wealth management data, Basel Committee on Banking
- Supervision (BCBS 239) and IHC Regulatory projects
- Collecting evidence of control adherence for centralized repository storage
- Data governance controls & general regulatory & risk reporting
- Monitoring data controls and tracking controls that are implemented and documented
- Reporting to Director of RSS Project Shared Services Group and Business Analyst Center of Excellence
- Focused on Data evidence, data controls and data management for regulatory reporting and audit reviews and audit processes
- 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
- Reporting to Director of RSS Project Shared Services Group and Business Analyst Center of Excellence
- Rules
- Reporting to Director of RSS Project Shared Services Group and Business Analyst Center of Excellence of management
- Worked with both waterfall and agile methodologies
- Documented data lineage as technical and business assets
- Responsible for Documenting Lineage of Corporate Risk Metrics cross functional areas including Liquidity Risk, Compliance Risk, Operational Risk, Credit Risk, Capital Risk and Market Risk
- Assisted with data governance policies and implemented same by working with data owners and data stewards
- Linked data lineage to data quality and business glossary work within overall data governance
- Interviewed various business and technical users to trace business and technical lineage and documented using Excel and Visio
- Created business glossary for various data domains
- Documented data quality rules by working with data stewards and custodians
- Worked on Data Mapping and data validation of various data domains
- Performed data profiling on source systems that are required by Subject matter experts
- Worked on implementing data governance framework, data lineage and data quality setup
- Worked with business partners to elicit high level requirements and capture business needs to define issues and primary objectives of new projects.
Data Governance Consultant, Lead
CHARLES SCHWAB
12.2019 - 12.2021
- Part Of Corporate Risk Management team within firm
- Responsible for implementing Data Governance across corporate risk management’s
- Worked on Risk Data Aggregation and Risk Reporting (RDARR)
- Implemented Data Governance using Microsoft Visio, Excel, Collibra and IBM’s IG (Information Governance Catalog)
- Worked in Data Governance Office (DGO) to evolve data population methods into Collibra (Business Metadata)
- Implemented Metadata within Data Governance program
- Led Kick off session meeting for all Business/IT SMEs to educate Data Governance
- Worked in setting up Collibra workflows, policy manager and dictionary
- Acted as Collibra Admin to support Data Governance office
- Worked with Data Management/ETL teams to upload documented Data Lineage into IBM’s Information Governance Catalog (IGC)
- Performed end to end Data Lineage assessment and documentation for Metric’s
- Interviewed Stakeholder’s (Subject Matter Experts) to capture current/future state lineage for Risk Appetite Monitoring Metrics (RAMM) and Key Risk Appetite Metrics (KRAM)
- Responsible for Documenting Lineage of Corporate Risk Metrics cross functional areas including Liquidity Risk, Compliance Risk, Operational Risk, Credit Risk, Capital Risk and Market Risk
- Documented Data Lineage in Microsoft Visio to get visual representations of Process and Work/Dataflow
- Created Data Quality reports/scores Dashboard using Tableau
- Developed naming conventions and taxonomy standards in Microsoft Visio that served as starting point for other subsequent teams standing up Data Governance program
- Monitoring of Data Quality in Informatica
- Edited Data Quality rules for issues
- Data Quality-Understanding Risk controls and testing controls to make sure process is correct
- Determined root cause of Data Quality errors and recommended long-term solutions
- Identifying issues of Data Quality and remediating issues
- Documentation of Data Quality Controls and created Data Quality Rules
- Project Management Executed with JIRA, within Kanban environment
- Lead meetings to socialize organization’s premiere Data Governance program that incorporates automation in response to Federal Reserve’s Matter Requiring Attention (MRA) to increase Transparency, Accuracy, and Accessibility
- Worked with Data Engineering team to develop automation and connect over 20 internal systems
- Monitoring and reporting governed data on firms Aggregate Risk report
- Ensuring there is data remediation plan if in case there are any gaps in Data that is being reported.
- Coached team members in techniques necessary to complete job tasks.
Database Analyst/Domain Analyst
Russell Investments
01.2019 - 12.2019
- Worked with application owner in bringing applications under compliance according to regulatory report
- Assisted in bringing these applications under compliance with Enterprise Data governance policy in place
- Assisted in creating Data Dictionaries by working with Application business data owners and technical data managers
- Assisted in finding Core data elements which are critical for business
- Ensuring Core data elements have Data quality controls around them
- Performed Data Quality checks and wrote Data Quality rules
- Applied Preventative and Detective data quality controls around critical data elements to ensure quality of data
- Interviewed several stakeholders in gathering all information required to comply with Data governance policies
- Gathering requirements from Governance team ensuring compliance activities are in
- Place
- Worked extensively with MS Excel, Microsoft Visio and MS Word
- Managed changes and updates in application business data owner changes in Collibra.
Data Governance/Regulatory Analyst
Janus Capital
09.2016 - 12.2018
- Assisted Data Governance Office in designing policies for different data domains
- Assisted in designing data quality rules working with data stewards
- Used SQL to analyze data on SQL Server and Oracle data bases to identify CDEs and related KPIs
- Analyzed various Tableau reports, crystal reports to understand data usage and related business rules
- Documented data lineage by technical and business domains
- Assisted with data governance policies and implemented same by working with data owners and data stewards
- Interviewed various business and technical users to trace business and technical lineage and documented using Excel and Visio
- Created business glossary for various data domains
- Documented data quality rules by working with data stewards and custodians
- Used SQL to join data from multiple database sources and create 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
- Worked with Collibra to automate data governance artifacts
- Did end to end data assessment and documentation for CDEs
- Used various methods to shortlist and finalize CDEs
- Performed data profiling on source systems that are required by Subject matter experts
- Worked on implementing data governance framework, data lineage and data quality setup.
Sr. Data Analyst
CITI BANK
08.2014 - 08.2016
- Extensively analyzed data for exceptions between legacy systems and new systems
- Analyzed investment reference data, Security Master, Positions, Trades, and Pricing data
- Extracted and analyzed data from Bloomberg terminal using excel formulas
- Worked on migrating trading platform from Bloomberg AIM to Blackrock Aladdin
- Worked on implementing reconciliation framework to compare positions between trading, accounting, and custodian systems
- Worked with data quality teams to resolve data quality issues
- Documented data quality controls
- Implemented business process to integrate data from Investment accounting systems to custodial banks like Wells Fargo
- Worked with multiple investment asset classes like Equity, Fixed Income, FX, and Derivatives
- Worked on data of various asset classes from data vendors like Factset, markit s&p,moody’s, point etc
- Participated in business process review meetings
- Created data requirements for feeds between Trading, Accounting, performance, and data warehouse systems
- Worked with ETL developers to successful implementation of Transformation logics
- Documented, clarified, and communicated change requests and coordinated with development and testing team
- Supported Eagle Pace data management (data upload, data export, best data), Datamart and stored procedures
- Coordinated with business users to understand BI requirements and translated them into Visual Graphs
- Written project assessment (scope) documents for Client approval
- Interacted with Managers and Architects and provided efficient approach for various solutions
- Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines
- Conducted requirements gathering meetings to elicit requirements
- Worked with Technical Analyst to translate functional requirements into technical specifications and documented using Software Requirement Specification (SRS)
- Derived Use Cases from developed matrix where necessary
- Designed Concept diagrams, Workflow diagrams, Use Case diagrams, Activity diagram using UML modeling tool Visio
- Worked with testing team to create test cases during UAT and Parallel testing
- Hands on exposure on SharePoint for Tracking Requirement Documents, Status Reports, Implementation Guide and Support Documentation
- Implemented and supported Tableau, SSRS and crystal reports against Eagle Data marts
- Worked on Wealth management Data warehouse and reference data enhancements initiative
- Created data interface specifications for performance and risk management business teams
- Lead Data Conversion activities working with various data consumers
- Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets
- Adjusted and maintained SQL script and perform further data analysis and data aggregation
- Involved in analyzing SQL, Database views, stored procedures, and custom SQL queries to import data from SQL server to Tableau
- Created Tableau worksheet which involves Schema Import, Implementing business logic by customization
- Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards
- Tableau Logs - Reviewing Server logs for any errors or security issues that are unexpected
- Worked on accounts, entitlements, security master and pricing data
- Performance Logs - Reviewing performance metrics to determine if baseline exceeded or for slow points during day that need to be reviewed
- Assisting in Creating Business Process Review (BPR), Business Requirement Document and User Requirement document
- Work on various requirements around KYC, account onboarding and Digital Platform
- Created Test Strategy Planning and assisted testing team to implement test plans during UAT
- Kickoff.
Sr. Business Data Analyst/Systems Analyst
Brandywine GLOBAL
03.2013 - 07.2014
- Created swim lane process flow diagrams for Bloomberg AIM Order management system (Fixed Income) and Charles River Trading (Equity)
- Used Data Governance Policies and procedures in documenting data management operating procedures
- Used Informatica data quality to configure data rules
- Gathered requirements by working with portfolio managers, traders, investment operations, investment accounting users on trade life cycle
- Documented requirements for mutual fund accounting systems PAS and mutual fund performance returns calculations and financial reporting processing
- Used Bloomberg API and Bloomberg Data License server to gather securities data
- Used SQL to analyze data on data bases
- Wrote Microsoft Excel Macros
- Worked with share Point sites
- Supported Eagle Pace data management importers, exporters, events and stored procedures
- Created and maintained Eagle trade log and reconciliation reports
- Managed issues with various feeds from custodians, sub-advisors into Bloomberg AIM
- Used Confluence Unity to calculate and publish mutual fund performance
- Supported investment data quality team by trouble shooting and identifying root cause issues
- Supported Sarbanes Oxley and CCAR regulations
- Created Tableau report specifications for complete asset management analytics.
Education
Bachelor of Science - Computer Science And Programming
SRM UNIVERSITY
India03.2012
Skills
- Skills/ Areas of Expertise
- Data Governance, Data Lineage, Data Quality, Collibra, IBM Information Governance Catalog, Informatica Data Quality,
- Metadata Enhancements
- Performance Metrics Evaluation
- Reporting Efficiency and Accuracy
- Regulatory Reporting Requirements
- Data Maintenance Processes
- Data Profiling, Project Management, Business Analysis, Requirements Management, Data Analysis, Investment Management, Asset Management, Microsoft Project Server, Data Modelling, Data Management & Reporting, Share Point, MS Excel, Agile, MS Word, MS Access, MS Office suite, MS Visio
Certification
- Foundation of Data Governance Learning Path Collibra University
- Data Steward Learning Path Collibra University
Timeline
Governance/Regulatory Reporting Analyst
MUFG UNION BANK
01.2021 - Current
Data Governance Consultant, Lead
CHARLES SCHWAB
12.2019 - 12.2021
Database Analyst/Domain Analyst
Russell Investments
01.2019 - 12.2019
Data Governance/Regulatory Analyst
Janus Capital
09.2016 - 12.2018
Sr. Data Analyst
CITI BANK
08.2014 - 08.2016
Sr. Business Data Analyst/Systems Analyst
Brandywine GLOBAL
03.2013 - 07.2014
Bachelor of Science - Computer Science And Programming
SRM UNIVERSITY