We provide IT Staff Augmentation Services!

Data Quality Lead Resume

SUMMARY:

  • I have over 25 years of significant experience as a data architect, data governance professional and project manager at the division and enterprise level.
  • I have planned technology architecture and integration programs, developed and implemented data governance programs and initiatives and critiqued industry governance approaches versus ‘best practices’.
  • Other skills include: designing and implementing MDM and metadata techniques, dimensional, logical, physical data models, and data migration models, i ntegrating business strategy into an enterprise architecture roadmap, establishing architecture principles and standards and developing quality assurance (QA) standards for data assets, data and dimensional modeling, and metadata repositories.
  • Most of my work experience has been in the capacity of an independent or third - party consultant.

TECHNOLOGY:

Modeling Tools: ERwin 4.1, 7.2, 8.1, System Architect, Rational Rose Enterprise Suite (UML), PowerDesigner 9.1,15.0, MetaStorm BPM Modeler, ERwin BPWin Modeler, Casewise 10.0, Collibra, Tableau

Software: XML, Business Objects, Hyperion, OBIEE, SQL, Cognos

Databases: DB2, UDB, Oracle 10g, MS SQL Server 7.0, Sybase 9.1

Other: MS Office Tool Suite,, CRM (SalesForce Dot Com-‘SFDC’), Confidential AML and Trade Fraud Detection toolsets, ISO and ACORD Insurance Standards, HP-ALM, Mercury Test Director, PVCS version controlMethodologies Zachman Enterprise Development, SDM Project Lifecycle, Business Rules Structure™, Agile

EXPERIENCE:

Data Quality Lead

Confidential

Responsibilities:

  • Developed processes, procedures for rule development and maintenance
  • Created standard templates and artifacts used in financial data governance implementation
  • Established quality assurance and review methods
  • Critiqued existing financial data models in order in corporate them into overall governance program.

Data Quality Lead

Confidential

Responsibilities:

  • Headed up the data quality rules development effort to support IHC CCAR, FR Y9C, Credit Risk, and Liquidity 5G reporting requirements
  • Developed processes, procedures for rule development and maintenance,
  • Established quality assurance and review methods
  • Worked with data stewards to develop data controls, measures, traceability and metadata reporting.

Senior Data Architect

Confidential

Responsibilities:

  • Headed up the Technical Consulting business practice in North America
  • Responsibilities include developing governance and project-centric service offerings and solution management support to a staff of 6
  • Developed dashboard designs based on in-house Collibra data quality/governance tool.

Chief Data Architect

Confidential

Responsibilities:

  • Developed logical and physical data models to support a new Client Profile database
  • Designed transformation rules to load legacy data implemented data governance and continuous data profiling routines to ensure data quality
  • Integrated the client profile data into the firm’s CRM platform (‘SFDC’).

Chief Data Architect

Confidential

Responsibilities:

  • Headed up the design and development of an operational data store supporting Positions, Transactions, Liabilities for the Private Banking group
  • Developed data profiling, business analysis and requirements methodology to support data governance.

Data Governance Implementation Lead

Confidential

Responsibilities:

  • Developed and implemented a data governance program for a large financial services firm including the creation of an implementation roadmap, defining and designing necessary artifacts to support the policies and procedures of the program and standing up a data governance committee to oversee and manage the program in 2 company locations
  • Trained data stewards and analysts in applying the governance initiative to their business areas
  • Developed an RFP to acquire a data governance software tool and managed the vendor selection process.

Data Architect

Confidential

Responsibilities:

  • Led a data governance program proof-of-concept deployment applying data profiling techniques for scalar and non-scalar data supporting implementation of the hedge fund’s data vendor on-boarding processes
  • Developed security master table concordance to support MDM standards and guidelines.

Senior Data Architect

Confidential

Responsibilities:

  • Created a roadmap for implementing a firm-wide data governance practice to cleanse constituent and school-related data sources, using Global Ids as a data profiling tool. This supported the organization’s CRM (‘SFDC’) tool deployment project
  • Co-developed an MDM strategy, business glossary, and data dictionary, with supporting metadata, to be integrated in the data governance enterprise information management effort (EIM).

Data Architect

Confidential

Responsibilities:

  • Brought in to co-develop a data governance practice based on first developing an enterprise data model of the firm’s customer, sales, and marketing subject areas
  • Developed data models to integrate the firm’s customer structures with its CRM (‘SFDC’) implementation.

Data Architect

Confidential

Responsibilities:

  • Led a staff of 3 in the redesign of a payments processing database in order to enhance performance and facilitate query access.
  • The application serviced 30,000 global customers, processing more than 1MM transactions per day
  • Created a data governance ‘Customer Master ‘template in support of this effort.

Lead Analyst

Confidential

Responsibilities:

  • Led the accounting flows process analysis group (3 persons) in support of an annuities product tracking and cashiering management system
  • Tasks included business and data analysis of existing and proposed interfaces, gap analysis, meeting with end-users and IT support to finalize interface designs and appropriate documentation.

Solutions Architect

Confidential

Responsibilities:

  • Managed product implementation of trade fraud detection software at multiple banking client sites
  • Performed data analysis for the firm’s anti-money laundering package, including reconciliation and data mapping for client brokerage and investment banks
  • Modeled and designed ETL scripts and data validation test plans for the packages as well as critiquing threshold handling and scoring mechanisms.

Senior Business Analyst

Confidential

Responsibilities:

  • Jointly led the design of a Business Objects reporting environment, for the Compliance and Risk and Bank Examiners divisions of the investment bank
  • Conducted extensive business interviews and analysis in order to define business processes and appropriate reporting requirements. Work included designing a Security Master sub-table for the reporting data mart
  • Established trade fraud detection parameters for their Confidential fraud detection software tool.

Senior Quality Analyst

Confidential

Responsibilities:

  • Developed a data governance practice leveraging off of “ Confidential ” quality control techniques, targeting securities master and corporate actions data
  • Developed several process flows using Casewise BPM tool for risk, financial and regulatory compliance activities in support of internal surveillance and Sarbanes-Oxley compliance analysis.

Senior Data Analyst

Confidential

Responsibilities:

  • Developed business specifications, modeling standards and designed an inventory tracking system database for the technology assets of the Private Client group. Work included developing data models and class diagrams using Rational Rose in a UDB environment
  • Translated relational data structures to OO classes, components using UML (Rational Rose)
  • Used Cognos BI tool to query technical inventory features.

Senior Data Analyst

Confidential

Responsibilities:

  • Produced specifications for a data warehouse for claims processing of the property and casualty units of the firm.
  • Worked with end users to determine critical data elements for property, casualty and D&O claims
  • Established data governance measures, metrics, and remediation to ensure quality data
  • Produced specifications to satisfy financial reporting requirements to support Cognos BI queries.

Lead Test Designer

Confidential

Responsibilities:

  • Developed and implemented a rules-based test plan methodology for release testing of the ERwin data modeling and BPwin process modeling tools
  • Developed test plan methodology and techniques to automate future QA testing.

Senior Business Analyst

Confidential

Responsibilities:

  • As part of the bank’s merger, managed the Retail Banking department-wide effort to install websites using Lotus Notes QuickPlace to publish departmental procedures, news communications, schedules, etc. to assist the business unit with work function consolidation.
  • Used Six Sigma QA procedures to support these efforts.

Senior Data Analyst

Confidential

Responsibilities:

  • Performed data analysis and design for an integrated medical/drug claims analysis warehouse.
  • Work involved project scoping, developing data requirements from business requirements and estimating implementation costs.
  • Designed a prototype data warehouse as proof of concept.

Senior Business Analyst

Confidential

Responsibilities:

  • As acting VP of Development, managed a 5-person staff to rewrite an asset management/credit derivatives application in VB/Oracle. Project involved designing a pooling and securitizing mechanism for CMO/CLO’s as well as total return and secured loan trust note swaps.
  • Also developed a commercial paper funding (“CP slicer”) mechanism to reduce collateral asset expenses. Implemented a full project lifecycle methodology while enhancing the firm's asset- and mortgage-backed securitization and credit risk systems.
  • Designed both Security and Customer Master table schema to support this work
  • Designed and managed the development of a workflow and risk analysis tool that tracked all financial reporting activities and their associated risk levels to aid auditors in assessing relative risk factors vs benefits and to recommend where to reengineer banking processes and controls.

Hire Now