Erin Apple, Mba Email & Phone Number

Los Angeles, CA, US

• Use dbt to restructure, maintain, and augment the reporting schema
• Conduct analyses of A/B experiments via SQL and Python, using results to advise Product team on key decisions regarding new initiatives, pricing, and default product offerings, generating over $3M in new recurring.
• Successfully integrated Fivetran data for 5 ad spend platforms into the reporting schema on a 2 month timeline following the abrupt sunset of an external tool, leading to an annual cost savings of $100,000
• Identified and investigated bugs in the revenue tracking system, discovering $2M in undercounted refund revenue
• Develop comprehensive project assessment plans and provide strategic recommendations to the leadership team on prioritizing high-impact initiatives for the business
• Serve as the primary liaison to external partners to generate new data streams, correct data discrepancies, and integrate new data into the existing reporting structure and visualizations

Los Angeles, CA, US

Emeryville, CA, US

• Analyzed transactional and financial data using SQL Server and Excel for multi-million-dollar healthcare litigation cases
• Validated large datasets up to 70 million rows to ensure accuracy of data used in analytics
• Built reporting scripts in SQL to monitor monthly KPIs and track statutory compliance for a company under a federally mandated corrective action plan
• Conducted medical bills and life care plan analyses for lawsuits ranging from $25K to $10M
• Managed all aspects of small to medium sized client engagements and segments of larger projects
• Served as liaison between upper management and junior staff on concurrent projects

Emeryville, CA, US

Sydney, NSW, AU

• Managed a portfolio of over 150 companies valued between $25M and $4B and completed quarterly and annual reviews
• Implemented a cloud-based reporting platform, enabling more strategic insights and data capabilities
• Implemented a new data collection process resulting in an 85% increase in data collected
• Maintained weekly dialogue with bankers regarding their credits and key points of concern
• Served on the Community and Wellness Committees and planned company-wide volunteer and educational events

Tallahassee, FL, US

• College of Business Internship Programs Office
• Responsible for grading assignments for over 500 students
• Engaged students through virtual learning and online discussion boards
• Recorded and presented informational videos for students and employers

• Created and executed rebranding strategy, including designing new product website
• Analyzed and interpreted company data using Tableau
• Identified key marketing strategies to reach a wider target audience using data-based insights

Master Of Business Administration - Mba, Business Analytics Concentration

Bachelor'S Degree, Exercise Physiology