Data Quality analyst Resume

SUMMARY

Banking VP with over 25 years of securities industry experience combines deep business insight with data management and meta - data skills to deliver data environments that integrate multiple sources into a business process aligned model to support applications, reporting, self-directed user access and feeds to critical downstream functions, particularly risk management and capital regulatory reporting.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Data Quality analyst

Responsibilities:

Design and develop Ab Initio (the data quality tool) configurations and rules for ongoing monitoring reports.
Analyze source data for relationships and data quality patterns subject to validation.
Update enterprise Meta Data store for source and Data Quality models.
Design Data Quality configurations for Apache HIVE DB.

Confidential

Data Quality and Governance analyst

Responsibilities:

Designed test cases for ongoing data quality monitoring reports.
Detailed analysis of data issues affecting the Risk Weighted Asset (RWA) application.
Management of Key Business Element meta-data and mapping of sources into the application data store.
Detailed analysis and comparison of new sourcing application in support of adoption project for Derivative (CDS, Options, Swaps, Swaptions, Equity Swaps / Options, FX and Commodities) and Repo / Securities Lending products.

Confidential

Business Systems Analyst

Responsibilities:

Supported implementation of Master Data Management application Siebel UCM.
Coordinated initial load of data from spoke systems into MDM central distribution database.
System Integration and User Acceptance testing of UCM integration with other Salesforce, Oracle EBS and Siebel CRM
Managed initial load of employee data into Siebel CRM for hierarchy and position assignment.
Designed and specified Customer Lifecycle Management data capture and enrichment within the CRM.
Optimized integration with Dun & Bradstreet to enrich customer data and assign account hierarchy.
Account hierarchy automation, cleansing and maintenance.

Confidential

Business Analyst / Data Architect

Responsibilities:

Designed and specified integration of BofA fixed income back office systems with Confidential, compliance, regulatory reporting and accounting systems.
Implemented data integration with the strategic source for securities reference data -PME.
Specified data feeds into Risk management systems for fixed income trades and positions.
Specified data feeds into Middle office P&L reporting system.
Designed and implemented unified Affiliate Position reporting combining positions from both BofA and Merrill legacy Systems of Record and strategic instrument reference data.
Specified customer and product identifier master data integration.
Supported fixed income inclusion in Data Linage tracking application.
Products supported: Fixed Income, Mortgage backed, TBAs, Short term paper, Repo and financing.

Confidential

Business Analyst / Data Architect

Responsibilities:

Designed database and real time source feeds to incorporate inputs from multiple systems to track the life cycle of trades from execution to settlement.
Responsible for data architecture, data base design and interface specifications for data provisioned to Global Risk management in support of the Basel II initiative and CCAR projects. Basel II categories supported included Repo-Style, Fixed Income Forwards and Cash Securities Positions.
Developed detailed data mapping specifications using a standard template designed by our group. Integrated mapping specifications into preliminary Meta data store intended to support data lineage analysis.
Products Supported: Equity, Listed Options, Fixed Income, Financing transactions, Stock Loan and derivatives.

Confidential - San Francisco, CA

Data Warehouse Manager

Responsibilities:

Data support for major back office integration project to consolidate the system of record for BAS onto one platform.
Developed a common data model to hold transaction, position and reference data from multiple sources to support back office applications and user self-service MIS.
Collected and displayed rudimentary, business function aligned Meta data for the shared environment.
Created the conceptual account and party sub-model for the warehouse.
Formed MS SQL data marts to enhance usability of data for a broad user community that were consumers of output from the new back office system.
Products Supported: Equity, Listed Options, Fixed Income, Financing transactions.