Andrew Deininger Email & Phone Number

Accountable for producing on-time, error-free deliverables for a range of responsibilities:- Compiled monthly report for client to target coupon fraud at CPG retailers throughout the USA, resulting in $2.75M identified in coupon fraud for client. ($400K annually)- Generated coupon data for 100+ programs annually; done on-time and error-free. Worked with cross-functional teams to request and provide deliverables. Annually issued 500+ records to 25M+ recipients.- Conducted monthly ISO 9001:2015 internal audits to ensure teams complied with their process maps. Assisted with process map creation in Visio. Passed all annual audits conducted by the external auditor.- Investigated and resolved data integrity issues. Used troubleshooting skills to identify reason for data loading errors. Where applicable, used SQL to extract data for research.

Accountable for designing and performing audience extraction in relational database platform.

Contractor (on-site at ShopLocal):- Data analysis and interpretation in data operations department; built dashboards on website analytics for top retailers via Salesforce

Contractor (on-site at NCSBN, Wm. Wrigley Jr. Company):- Investigated and resolved data integrity issues; communicated with various Member Boards- Engaged in daily contact with Wrigley customers, customer solutions account managers- SAP financial software experience in Accounts Receivable department- Investigated and resolved financial deductions on account payments; met monthly goals

Contractor (on-site at Cigna Insurance, ACE USA Insurance):- Analyzed and tracked high volume of data; presented it to the appropriate specialist for resolution.- Organized current and past policy contracts for mailing or filing.

Accountable for designing and executing test plans:- Worked with project team to develop and execute functional, unit, regression, forced conditions and user acceptance tests.

Accountable for weekly release of Panel Data to Client Services group:- Managed 3 FTEs in the processing and quality analysis of retail scanner data from U.S. grocery, drug, and mass merchandise stores providing panel data.- Responsible for meeting weekly deadlines of loading data to database for client reports.- Performed interviewing and hiring duties to ensure staffing requirements were met.- Provided training and documentation to direct reports on process and analysis procedures.

Accountable for data loading and QC analysis:- Analyzed weekly retailer sales data through data loading QC checks, store-level analysis, and trend analysis for client reporting.- Investigated system issues, job failures and corrupt data.