Principal Consultant
CurrentResponsibilities:> Provide remote/onsite consulting and training to help companies make better decisions by leveraging their data using the Microsoft Business Intelligence stack (Excel, PowerQuery, PowerPivot, Power BI, and SQL Server Analysis Services Tabular).> Provide expert guidance to companies of all sizes ranging from family-owned businesses to Fortune 500 enterprises in industries such as health care, energy, retail, financial services, manufacturing, and digital marketing.Accomplishments:> Closed more than $1.3m in business> Led project to build Supply Backorder Forecasting tool that gave 20+ stakeholders unprecedented visibility into product backorder and expected ship dates. Prioritized competing requests to deliver three iterations over six months, continually honing into stakeholder needs. $100b+ multinational medical devices manufacturer.> Developed capacity modeling tool to dynamically calculate capacity based on line bottlenecks (Used by 20+ plants at same client as above).> Built a retail analysis reporting package for a ~$10b Fortune 500 company. The original report required 50+ hours of manual work to update and now updates in < 5 seconds.> Implemented an FP&A data model for a $2.5b revenue financial services company. The tool automates financial statements and variance to budget analysis.> Helped improve propane delivery efficiencies by 15-30% for a $2b+ revenue energy services company. Built a comprehensive suite of reports that identify under-performing segments and recommends actions that managers can take to correct.> Developed training modules for courses in Power BI and DAX.> Successfully trained hundreds of students in the Microsoft BI stack.> Gave back to community by publishing articles on P3Adaptive.com, delivering Power BI User Group sessions, and being interviewed by Microsoft for a Power BI Success Story.