We provide IT Staff Augmentation Services!

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

We'd love your feedback!