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.