Senior Data Quality Consultant Resume
3.00/5 (Submit Your Rating)
UsA
OBJECTIVE:
Experienced Data Quality Consultant looking for a position related to Data Analytics and management.
EDUCATION:
MS Accounting Information Systems
BA Finance May
PROFESSIONAL EXPERIENCE:
Confidential, Nov 2006 - Jan 2010
Senior Data Quality Consultant:
- Developed SAS programs, SQL queries and ACL scripts to read in and analyze complex datasets and reports containing millions of records.
- Designed procedures to automatically create business intelligence reports based on raw data using SAS and Advanced Excel features including Macros and Pivot Tables.
- Performed extensive data profiling and data analysis to report inaccurate, invalid and incomplete data in the system.
- Conducted data cleansing procedures including removing duplicates, re-mapping, resolving conflicts, normalization, correlation of tables and efficient organization of data.
- Translated business rules into data requirements and created data validation procedures to assure the integrity of data.
- Extracted data from legacy Mainframe systems to perform analysis and generate reports.
- Performed procedures to understand, test and document business processes at various Fortune 100 clients
- including GM, Dow and P& G.
- Generated customized reports and trending charts from huge sales related data sets including period-to-period
- and unit-to-unit comparisons.
- Developed and performed automated testing procedures for financial audits working with sensitive data and tight
- deadlines.
- Designed queries to validate depreciation and amortization calculation for around 1 Million assets.
- Prepared training manuals and user guides for standard and internally developed technology solutions.
- Conducted Fraud testing based on SAS-99 GAAP requirements for more than 30 private and public clients.
- Participated in financial statement audits for areas including Accounts Receivable, Accounts Payable and
- Construction Work In Process.
Confidential,Dec 2004 Aug 2006
Research Assistant:
- Performed Data analysis, data collection and cleansing procedures for academic research
- purposes working with datasets of millions of records.
- Developed parameters for data quality checks and data Analyses for very high volumes
- of data extracted from various research-focused databases and data warehouses.
- Performed data conversion, data mining and data profiling procedures and prepared easy to read reports.
- Provided statistical analysis and reports for financial and investment related data.
TECHNICAL SKILLS:
Data Quality & Analysis Data Modeling and definition Data Mining
Financial Statements Audit Fraud Testing , SAS 99 Technical documentation
Advanced Excel skills 3 Years of SAS and SQL exp Intermediate ACL
Other tools:
Access, Visio, Outlook, Tableau, JD Edwards, SAP, UML and Oracle