Senior Business Analyst

November 2015 - present

Recruited by COO into newly established eLearning company to develop high-impact solutions strengthen company’s ability to market and grow business across B2C channels. Report directly the COO, VP of Sales, and CFO.

​

• Build, deliver, and maintain monthly, quarterly, and annual financial reports leveraging advanced SQL queries and AWS QuickSight visualization tool.

• Create prediction models to forecast business outcomes. Create fiscal year projections for client retention and renewal.

• Perform ad-hoc analysis to communicate in-month and end-of-month business results to the CFO and executive team.

• Partner with marketing and product development leadership to discuss impact of initiatives to forecasts and results.

Selected Achievements:

• Improved the accuracy and reliability of business data within 6 months of hire, increasing the adoption of reports across the organization. Analyzed, validated, and resolved quality issues across multiple Terabytes of shopping cart, log, and student data within the MySQL database. Provided technical and data definitions for business terms.

• Built the framework for automatically capturing, manipulating, and reporting on critical data across the organization, eliminating the need for the data analysis team.

• Developed portfolio of 60 recurring reports and hundreds of ad-hoc reports that has enabled company to achieve 10% to 40% business growth year-over-year and double revenue within 3 years.

  • Created the Individual Course Report that contributed to increase customer satisfaction by 50% and Net Promoter Score (NPS) from 20 to 30 by providing product and sales teams with a centralized means to track difficulty of courses. Report as evolved as a key source of information for student and client performance at the course level.

  • Produced the Completer Rate Report that increased visibility into the inaccurate reporting metric being leveraged across the company to evaluate performance of courses.

  • Designed portfolio of reports for the Head of Sales that improved awareness of opportunities, leading to growing number of active monthly subscribers from 3,000 to 12,000 and doubling list of schools.

  • Learned company’s Responsys Email Marketing System, and wrote tools to capture and import data from corporate database to the marketing program that enabled continued business growth.

• Identified the need and creating the Rebill Rate Prediction Tool to enable leadership to define goals and expectations for revenue / retention.