Senior Data Quality Engineer Resume
Irvine, CA
SUMMARY:
- 14 years of IT experience and technical proficiency in Data Quality, Data Analysis and BI Reporting.
- Exceptional skills in analyzing and validating data in BI/ETL/Data Warehousing environment. Strong knowledge on data modeling concepts (OLAP, OLTP, Star Schema, SnowFlake Schema)
- Skilled in Data Analysis and Data Profiling
- Experience with designing, developing and implementing Test plans, Test Scenarios/Cases and Test Processes
- Experience working in Agile/Scrum environment
- Ability to work independently and as well as part of the team
- Excellent written and verbal communication
TECHNICAL SKILLS:
Databases: Teradata, Oracle, SQL Server, Microsoft Azure
ETL Tools: Informatica Power Center, IBM DataStage, Informatica BDM
Defect Management Tools: HP ALM (Quality Center), JIRA
Programming: UNIX Shell Scripting, R
BI & Reporting Tools: Actuate 8.0, OBIEE 10.1.3.4, Business Object XI, Microstrategy, IBM Cognos 10.2.1Qlikview, Tableau
PROFESSIONAL EXPERIENCE:
Confidential, Irvine, CA
Senior Data Quality Engineer
Responsibilities:
- Marketing Sales and Services (MSS) department data migration to Azure Cloud.
Environment: SQL Server, Oracle, Microsoft Azure SQL Data Warehouse, SSRS, R Studio, Microstrategy, Business Objects, Tableau, JIRA, Toad Data Point 4.2, Microsoft SSMS, Informatica BDM, Beyond Compare, Secure CRT, Secure FX, Notepad++, Microsoft Office
Confidential, San Ramon, CA
Data Operations Engineer
Responsibilities:
- Comprehensive Capital Analysis and Review (CCAR) is an annual exercise by the Federal Reserve to ensure that institutions have robust, forward - looking capital planning processes that account for their unique risks and sufficient capital to continue operations throughout times of economic and financial stress.
Environment: Toad Data point 4.2, OBIEE 12.2, Informatica, XML files, Notepad++, Microsoft Office, Microsoft SharePoint.
Confidential, Cypress, CA
IT Quality Lead
Responsibilities:
- As a part of the Healthcare Reform, the Affordable Care Act (ACA) legislation that requires insurers to administer reinsurance, risk adjustment, and risk corridor programs.
- We need to allocate, calculate, store, and provide information about these programs to an Issuer-owned server (Edge Server).
- The Edge Server will run HHS developed software designed to verify submitted data and execute the Reinsurance (RI) and Risk Adjustment (RA) processes.
Environment: SQL Developer, Toad, Ultra Edit, WinScp, Putty, HP ALM, IBM DataStage 8.5, Microsoft Office, Microsoft SharePoint.
Confidential, New Brunswick, NJ
Integration Test Lead/Business Analyst
Responsibilities:
- Procure to Pay contains data from Purchase Requisition to Invoicing for all of Confidential &J units across different countries.
- This project deals with sourcing data from different ERP systems like JDE, SAP, ARIBA and loading data into Procure to Pay data warehouse.
- BI reports are generated to analyze the spend amount by Confidential &J across various sectors/region/category.
Environment: Teradata 14/13.10, Teradata SQL Assistant 13.10/14, Mercury Quality Center v10.0, Informatica 9.5.0, Cognos 10.1.2/10.2.1 , Tableau 8.0, Microsoft Office, Microsoft Sharepoint
Confidential, New York City, NY
BI QA Lead
Responsibilities:
- Projects focus was to validate user watch analytics captured on Confidential & Confidential application for BI purposes.
Environment: Oracle 10g, Toad 9.7.2.5, JIRA v4.2.4, Informatica 9.1.0, Business Objects XI, Qlikview, Charles Web Debugging Proxy v3.7, Fiddler Web Debugger v2.4, Microsoft Office