Data Quality Analyst Resume
4.00/5 (Submit Your Rating)
CA
Programmer Analyst
- Over 10 years experience in business applications development and support with ETL/data warehouse, ERP, financial, and web metrics applications
- Over 4 years experience with SQL and UNIX
- Experience with Perl
- Used data analysis and problem solving skills to resolve data and code issues
- Improved existing processes, enhancing functionality and increasing staff productivity
- Committed professional called “one of the most responsive and proactive” by a recent customer
LANGUAGES: SQLPlus; UNIX/bash shell scripting and commands; Perl; HTML
DATABASES: Oracle; Sybase; Progress
APPLICATIONS: Oracle 11i; MfgPro; installation-specific applications
TOOLS: MS Office; Netezza; SQL Navigator; SQL Developer; Autosys; Shareplex
PLATFORMS: Windows; Mac; Solaris
PROFESSIONAL EXPERIENCE
Confidential, CA
Data Quality Analyst Aug 2011 Oct 2011
- Performed root cause analysis of data quality issues and partnered with contract manufacturers to provide accurate and timely manufacturing data to client datamart applications.
- Developed and tested SQL and bash scripts that provided status data on critical product line manufacturing processes.
- Created Excel charts and pivot tables that provided management with critical manufacturing line status information
Confidential, Sunnyvale, CA
SQL Data Analyst Jan 2011 Aug 2011
- Developed and tested over 20 SQL scripts that identified data and business process status, enabling quicker resolution of problems and increasing customer satisfaction.
- Created scripts that reported statistical confidence intervals across a variety of data, allowing client statisticians to discover trends in critical customer data.
Confidential, Santa Clara, CA
Sr. Programmer Analyst May 2005 Jul 2009
- Collaborated with local and offshore peers, IT support teams, management, and customers to resolve numerous application production process and data issues, restoring application functionality and data integrity in a timely manner.
- Resolved multiple 6-figure data warehouse application billing, booking, backlog, and shipping data discrepancies using SQL and UNIX to retrieve data from relational databases and flat files. Analyzed this data and implemented solution that corrected the discrepancies, restoring data integrity and user confidence in application.
- Eliminated duplicate invoice records, sometimes totaling over $100,000 monthly, by implementing necessary corrections to application PL/SQL code.
- Saved over 12 hours per month of developer time and improved data warehouse application performance and availability by creating UNIX/SQL scripts that automated a monthly Oracle database partitioning exercise.
- Ensured data accuracy across application interfaces by documenting ETL job process flow and communicating necessary application recovery procedures to team members and members of interfacing IT staffs.
- Brought application databases into compliance with client\'s SOX standards by analyzing databases, discovering data exposures, and working with client\'s SOX Program Office, business partners, and database administrators to effect the necessary changes.
- Documented problem resolution procedures, reducing future problem-solving time and contributing to staff knowledge base.
Confidential, Santa Clara, CA
Software Engineer Jul 1996 Apr 2005
- Provided critical web-usage information by designing, developing, testing, implementing, and documenting Perl programs that translated numeric weblog URL information into readable English.
- Created UNIX scripts that extracted data from web usage log files, resulting in increased volume and greater variety of web metrics information for business users while meeting existing service level agreements.
- Contributed to timely and cost-effective ERP application transition by extracting and providing critical legacy-application data to business partners.
EDUCATION
- AA Data Processing/Business
- Technical Writing and Communications Certificate