EXPERIENCE

Angie’s List

Business Analyst

June 2016 – June 2017

  • Created executive-level dashboard in Power BI used by COO to manage the overall health of the company.
  • Designed detailed reports to gain insight into company’s $300M+ revenue, 6M+ members, and 10M+ reviews.
  • Constructed a financial model to price partnership contracts to increase revenue by over $1M.
  • Performed ad hoc financial modeling and SQL reporting for many business units.
  • Delivered presentations to convey reporting insights to top executives including CEO and founder Angie Hicks.

Streamline Health

Financial Analyst Intern                                                                                                                           

June 2015 – August 2015

  • Improved financial reporting production time by 50% by creating dashboards and reports in Salesforce.
  • Leveraged Salesforce to automate recurring tasks such as updating revenue and generating expense reports.
  • Replaced old contract management system by creating a Salesforce object to manage company’s client contracts.
  • Prepared and updated internal company financials, such as budgeting and profit & loss reports.

DoubleMap

Business Development Intern

 Jan 2015 – May 2015                                                        

  • Developed financial models for client profitability analysis facilitating a 10% to 15% profitability increase from clients.
  • Worked closely with executive management on presentations and due diligence for investor visits.
  • Created product cost proposal in response to a Request for Proposal (RFP) for a $1M deal.

DePauw University

Data Analyst Intern

Sept 2014 – Dec 2014                                                     

  • Created regression analysis models using R.
  • Prepared a student user manual on performing regression analysis in R.