Andrew Martin

• Utilized Python, SQL, and VBA in QA, Dev, and Prod environments to deploy tooling solutions and scalable data models that feed stakeholder requested products.
• Primarily deployed Amazon QuickSight products to provide detail and summary level data with customizable aggregation. Utilized metrics and KPIs to drive business goals. Noteworthy Impacts: Increases key compliance metric by 48 percentage points. Decreased key program risk metric by 18 percentage points (metric definitions confidential).
• Built GDPR compliant permissions model usable by all relevant data models. Capable of efficiently integrating new product specific use cases. Model output joined to product inputs to restrict product user to role relevant data. Ensures products stay compliant with GDPR law which carries steep penalties.
• Created scalable framework capable of efficiently integrating new metrics from all team data models and data sources. By design keeps database tables slim and efficient. Framework enables use of standardized formula to output accurate calculation for all metrics regardless of calculation requirements. Usable by all with novice+ SQL experience.

• External Driver Training Program Internalization Mechanism - 1.1MM in-year savings with projected 7.2MM-15.6MM annualized savings.
• AMXL-RSR Reimbursement Mechanism - Reduced DSP reimbursement disputes by 55% across the board.
• Received GSF Innovation Award (2021)

• AMXL-RSR Onboarding Platform & Gating Process Launch - Increased DSP participation from 30% to 100%. Increased DA compliance from 5% to 87%. Decreased avg DA onboarding time by 11 days. Saved 3 HC required to run processes manually. Deployed similar platforms for 7 cross-regional programs spanning NA, EU, and CA due to impact of launch success.
• Completed approximately 200 analytics related requests from business stakeholders in total.

Personal Project Impacts:

• PPC Automated Reporting Mechanism - $383k in-year savings, $792k annualized, and $703k forecasted for 2020. Savings logged with finance on first pass.
• Customer Whisper Project - 8.5 years per year of CSA & customer time savings. 280k contacts per year eliminated. $483k per year savings logged with finance on first pass.
• Incorrect Chat Address Project - 20k transfers per year eliminated. $21k per year savings logged with finance on first pass.

Stakeholder Request Impacts:

• RSR Savings Validation - $121k in-year savings logged with finance on first pass.
• LSE Savings Validation - $30k in-year savings logged by finance Education on first pass.
• Invalid Form Savings Forecast - $312k per year forecasted savings. 168k per year forecasted contact elimination. Savings forecast enabled manager to escalate further.
• Blackout Savings Forecast - 45k forecasted contact elimination for 2019. $100k forecasted savings for 2019. Savings forecast enabled manager to escalate further.

• Created real time virtual workspace for NA network by expanding capability of website via tailored permission model integration.
• Received CS org award in innovation for 2018 and named site's most innovative employee.

• 3x Organization Top Performer
• 4x Tour of Champions Presenter (2 CSAs selected per Site)