We provide IT Staff Augmentation Services!

Data Governance Consultant/data Analyst Resume

Dallas, TX

SUMMARY

  • Over 8+ years of work experience in Business Analysis and Data Analysis in Financial industry. Specialized in Implementation of Financial Tools, Data Governance, Data Lineage, Data Quality, Project Financials, Costs, Benefits, Requirements management, user acceptance testing, Change Management, Reporting and SQL
  • Implemented Data Governance using Microsoft Visio, Excel, Collibra and IBM’s IGC (Information Governance Catalog)
  • Data Management - worked with the Data Governance Office (DGO) to evolve data population methods into Collibra (Business Metadata). Worked on designing and developing Collibra workflows.
  • Acted as Collibra Admin (Access, maintain, configure, test) to support the Data Governance office
  • Worked with Data Management/ETL teams to upload documented Data Lineage into IBM’s Information Governance Catalog (IGC)
  • Experience in creating Data Governance Policies, Business Glossary, Data Dictionary, Reference Data, Metadata, Data Lineage, and Data Quality Rules.
  • Extensive experience in Asset and wealth management, Investment Banking and Capital Markets
  • Interviewed Stakeholder’s (Subject Matter Experts) to capture current/future state lineage for Risk Appetite Monitoring Metrics (RAMM) and Key Risk Appetite Metrics (KRAM)
  • Decomposition and documentation of Business Lineage and Technical Lineage.
  • Traced and catalogue data processes, transformation logic and manual adjustments to identify data governance issues.
  • Highlighted Data Quality issues and areas of system control gaps
  • Linked data lineage to data quality and business glossary within the overall data governance program.
  • Experience in Data Lineage using Excel, Collibra. IBM’s IGC and Microsoft Visio.
  • Experience implementing Collibra to automate data governance processes.
  • Experience with data conversion stream of trading platform migration.
  • Extensive experience in creating data mapping specifications and interface documents.
  • Strong in troubleshooting reporting and data issues in identifying the root cause.
  • Experience working with Service Now and supporting the production applications with 24x7 coverage.
  • Extensive experience in implementing metadata, Business Glossary, Data Lineage and data quality.
  • Exposure to implementation and operations of data governance and data management solutions
  • Very Strong experience with order management systems Bloomberg AIM and Blackrock Aladdin
  • Expertise in designing the ETL around Aladdin, Bloomberg AIM and accounting systems.
  • Worked on implementation of Aladdin Green Package and Bloomberg interfaces.
  • Strong with data validation and data feed support.
  • Involved in reviewing business requirements and analyzing data sources from Excel / Oracle / SQL Server for design, development, testing, and production rollover of reporting and analysis projects
  • Extensive experience with SharePoint, Visio, Power Point, MS Project and Microsoft Office tools.
  • Worked on Excel Macros, Data validation, Data Mapping and Crystal Reports.
  • Coordinated with the stakeholders to gather functional and non-functional requirements
  • High proficient with SQL against SQL Server and Oracle databases.
  • Strong in leading meetings, preparing agendas, minutes and status reports.
  • Very strong in using Excel API tools for Bloomberg market and reference data.
  • Good Functional expertise on Trade Life Cycle of Equity, Fixed Income, FX and Cash.

TECHNICAL SKILLS

  • Data Governance
  • Data Lineage
  • Data Quality
  • Collibra
  • Project Management
  • Business Analysis
  • Requirements Management
  • Data Analysis
  • Investment Management
  • Asset Management
  • Microsoft Project Server
  • Data Modelling
  • Data Management & Reporting
  • Change Management
  • Database Development
  • Share Point
  • MS Excel
  • Agile
  • MS Word
  • MS Access
  • HP Quality Centre
  • ALM
  • Clarity
  • Extract
  • ETL
  • Eagle Star
  • Informatica Power Centre
  • Informatica Data Quality
  • Bloomberg
  • Aladdin Blackrock
  • MS Office suite
  • MS Visio
  • Oracle 11g
  • OBIEE 11g Erwin
  • Informatica MDM
  • SQL developer
  • Toad
  • UNIX
  • SSIS
  • SSRS
  • SSAS.

PROFESSIONAL EXPERIENCE

Data Governance Consultant/Data analyst

Confidential, DALLAS, TX

Responsibilities:

  • Worked on Risk Data Aggregation and Risk Reporting (RDARR)
  • Implemented Data Governance using Microsoft Visio, Excel, Collibra and IBM’s IGC (Information Governance Catalog)
  • Worked in the Data Governance Office (DGO) to evolve data population methods into Collibra (Business Metadata)
  • Worked in the Data Governance Office (DGO) to Populate the Technical Metadata into IBM’s Information Governance Catalog (IGC)
  • Implemented Metadata within Data Governance program.
  • Worked in setting up Collibra workflows, policy manager and the dictionary.
  • Acted as Collibra Admin to support the Data Governance office
  • Worked with Data Management/ETL teams to upload documented Data Lineage into IBM’s Information Governance Catalog (IGC)
  • Performed an 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
  • Developed the naming conventions and taxonomy standards in Microsoft Visio that served as a starting point for other subsequent teams standing up a Data Governance program
  • Data Quality-Understanding Risk controls and testing the controls to make sure the process is correct
  • 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 the 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
  • Met with Business Users for Re-Tiering CDE’s

Data Governance Analyst / Data Analyst

Confidential, Raleigh, NC

Responsibilities:

  • Worked on regulatory initiatives for Basel Committee on Banking Supervision (BCBS 239), Intermediary Holding Company (IHC MRA 193)
  • Decomposition and documented of Business Lineage and Technical Lineage.
  • Traced and catalogue data processes, transformation logic and manual adjustments to identify data governance issues.
  • Interview with Stakeholders (Subject Matter Expert) to document the transformation logic
  • Data Quality check with scoring method.
  • Highlighted Data Quality issues and areas of system control gaps
  • Linked data lineage to data quality and business glossary work within the overall data governance.
  • Documented Data Quality controls
  • Implemented Data Governance using Excel and Collibra.
  • Worked on configuration of Collibra for data governance.
  • Experience implementing Collibra to automate data management processes.
  • Performed an end to end Data Lineage assessment and documentation for select CDEs.
  • Gathered requirements by working with the business users on Business Glossary, Data Dictionary, Reference data, and Policy Management.
  • Participated in the Data Governance working group sessions to create Data Governance Policies.
  • Configuration of Communities, Domains, Asset Model, Relations per MS Data Governance Approach & Requirements
  • Worked on Custom extracts, reporting, metrics and dashboards on Collibra
  • Created One-off data loads to Collibra databases
  • Collibra Workflow development and configuration based on Data Governance Requirements
  • Collibra UI customization (e.g. page definition overrides)
  • Worked with Finance, Risk, and Investment Accounting teams to create Data Governance glossary, Data Governance framework and Process flow diagrams.
  • Used Microsoft Visio and Igrafx to draw business process swim lane diagrams.
  • Documented controls points, data enhancement processes, and transformation logic identified during stakeholder interviews
  • Analysed data lineage processes to identify vulnerable data points, control gaps, data quality issues, and overall lack of data governance.
  • Performed Dependency Analysis (by identifying any breaks in lineage), root cause analysis and remediation as part of the data lineage effort.
  • Tracked metrics/KPIs that provide visibility to management into the lineage progress.
  • Provided regular status reports to the management.
  • Designed excel Pivot tables and V-Lookup tables to analyse large data.
  • Reviewed incoming Data Streams for missing data, corrupt data, and tables/fields.
  • Implemented the change management procedures.

Sr. Business analyst & Data analyst

Confidential

Responsibilities:

  • Worked on Treasury transformation project in migration of trading system from Bloomberg to Blackrock Aladdin.
  • Gathered Requirements and business use cases for Reloading the Rejected Feeds into CAMRA.
  • Worked on Bloomberg AIM to Retrieve the market data using BDP functions.
  • Worked on Aladdin view and Aladdin security master to check the security data.
  • Worked with the data feed requirements from Aladdin to CAMRA accounting system.
  • Created the current state and future state diagrams using Microsoft Visio.
  • Supported Bloomberg admin functions: Account / Group setup, Broker codes / commission setup, Access / Privileges.
  • Worked with the data steward and data owners in creating metadata, Lineage, Data Quality rules and guidelines.
  • Created data governance templates and standards for the data governance organization.
  • Worked on UAT and parallel Testing on transferring feeds from Aladdin to CAMRA.
  • Maintained metrics for the feeds processing into CMARA Accounting system.
  • Developed Crystal reports for Operations team to run the daily reports.
  • Managed and lead the implementation of data governance using Microsoft project, Visio, Power Point, SharePoint tools and multiple training programs.
  • Worked on Excel Macros to transform and Automate the security master Reports.
  • Extensive experience in using CAMRA views, Rex reports and uploading feeds into CAMRA.
  • Worked on Comerica Automation process to process Comerica feeds to Aladdin.
  • Worked on Data Mapping and Data Validation to transform the feeds from Aladdin to Camra Accounting System.
  • Used sql server for validating the data using sql query's.
  • Worked on Error logs to identify the errors in daily processed feeds.

Environment: JIRA, Aladdin Blackrock, Eagle, Share Point, MS Excel, Agile, MS Word, MS Access, HP Quality Centre, UML, ETL, Informatica Power Centre 9.X, Informatica Data Quality 9.X, Informatica MDM, Oracle 11g, Erwin, OBIEE 11g, Bloomberg, MS Office suite, MS Visio

Sr. Business analyst/Project coordinator

Confidential

Responsibilities:

  • Worked Wealth Management business process and application simplification initiative to coordinate multiple projects.
  • Gathered requirements of PPC by working with the project portfolio managers.
  • Participated in the Portfolio Governance and Data Governance working group sessions to create policies.
  • Followed up monthly status on 80 programs to report it to the management.
  • Documented the reporting requirements to implement new PPM tool.
  • Conducted training sessions on governance policies and procedures.
  • Used SQL to analyze data on Oracle database
  • Created Source to target mapping Documents, business rules, and workflows
  • Designed excel Pivot tables and V-Lookup tables to analyze large data.
  • Used SQL to analyze data from PPM databases.
  • Tested the applications along with the Quality Assurance testing teams.
  • Used Microsoft Visio to draw business process swim lane diagrams.
  • Crated estimates on the assigned project work streams.
  • Provided regular status reports to the management.
  • Managed the issues on HP Quality center (ALM).
  • Used JIRA to plan and allocate resources
  • Implemented the change management procedures.

Environment: Vestek, Extract PPM, Clarity PPM, Reference data, Eagle, Inbound/outbound interfaces, SQL, .Net, JIRA, SQL Server, PL/SQL, Informatica Power Centre, Informatica Data Quality, Microsoft Access, Visio, Share Point, HP Quality Centre

Sr. Business Analyst

Confidential, Denver, CO

Responsibilities:

  • Worked on upgradation of Eagle STAR.
  • Gathered requirements by working with the portfolio managers, traders, investment operations, investment accounting users on trade life cycle.
  • Authored the Business Requirements (BRD), User Requirements and Functional Requirements (FRD).
  • Used Microsoft Visio to draw business process swim lane diagrams and involved in various phases of data modelling process.
  • Gathered securities data from various data providers for writing requirements document.
  • Facilitated meetings with business users to create source to target data mappings, business rules and data definitions.
  • Worked with Data analyst to analyze data elements, data flow and performed data mapping between the existing system and new system to be developed.
  • Worked extensively on Eagle environment (UNIX, SQL, PL SQL…etc.,)
  • Used Autosys scheduler for scheduling jobs.
  • Developed database objects like queries and stored procedures on Eagle environment.
  • Worked on designing the Data Warehouse model and the physical structure.
  • Experienced in applying the ETL transformations.
  • Prepared detailed reports and presentations using SQL and MS Access.
  • Involved in the build process and code deployment from development to production.
  • Provided regular status reports to the management.
  • Tested the applications along with the Quality Assurance testing teams.

Hire Now