Will Frahm

About Will Frahm

I lead teams to develop actionable business insights and analytics solutions. I earned a master\'s degree in Information Systems from the Kelley School of Business at Indiana University. I have worked in several industries (primarily Technology, Health Plans, and Pharmaceutical)I have delivered and driven large scale implementations in Data Engineering, Marketing Analytics, IT Architecture, User Interface Design, and Project Management. Data Engineering: I have designed and built intricate data pipelines that fed calculations and dashboards by using SQL, Teradata, MS SQL Server, UNIX, Informatica PowerCenter, and other proprietary workflow/dashboard tools.Marketing Analytics: I have delivered several high-value data insights to growth, product, customer, referral, and central marketing business leaders in the technology industry by using Google Cloud Platform infrastructure, SQL, Python, and proprietary workflow scheduling and dashboarding tools.IT Architecture: I have designed complex systems and data pipelines to calculate KPIs for marketing executives in the technology industry as well as finance executives in the healthcare industry.User Interface Design: I have designed a custom analytics system for a health insurance company to better manage their providers by using HTML/CSS/jQuery, MS Visio, ASP.NET, Google’s Materialize Framework.Project Management: I started my career performing the project management day-to-day activities of a 200-person project and I continue to take on more responsibilities with each new project. I mentor, guide, and manage my teams to achieve ambitious goals and efficiently deliver high quality insights for our clients. I have experience managing analytics projects using both agile and waterfall methodologies.What I Enjoy:I thrive in diverse, global workplaces and in 2017 worked and lived in India. I enjoy working in teams as well as independently with the autonomy to tackle problems on my own. I\'m a big believer in servant leadership and strive to give my teams the tools they need to be successful. I often identify and create strategies to improve and automate routine processes in order to deliver project and business outcomes more efficiently. I regularly identify and resolve difficult, time-sensitive, and complex challenges with a pragmatic and positive attitude.

Experience

1. Business Intelligence Engineering (Bie) Manager

   Amazon

   May 2021 — Present

   Hired and managed a high-performing team of 10 data analysts and BI engineers in planning optimization; prioritized & successfully completed 1,400+ analytics projects by evaluating strategic alignment, ROI, and business criticality· Revealed $170MM+ cost savings via 10+ tech launches through analysis & developing business reporting; fostered cross-functional partnerships with operations, product, and engineering teams to drive executive-level decisions· Engineered route planning workflow pipeline processing 48B+ records; delivered first-ever comprehensive planning session source of truth while reducing computational costs by 50%+· Launched AWS QuickSight platform for engineers; built AWS (Lambda Python functions, Cloudtrail, etc.) automated solution, establishing a self-service model and comprehensive documentation hub· Enabled productization of analytical capabilities by driving early adoption of CI/CD framework for analytics and evangelizing its adoption across the enterprise; increased code quality, reduced deployment errors, and accelerated rollbacks from hours to minutes· Architected enterprise-wide data model consolidating 4 fragmented reporting systems to enable faster, more accurate insights; eliminated redundant code, standardized metrics, and reduced processing time; implemented 9 data warehouse tables powering 4+ reporting pipelines and 5 self-service dashboards, enhancing decision-making velocity· Defined a scalable data architecture to surface actionable data insights by driving cross-functional alignment between research/applied science, software engineering, and product teams· Built Fire TV’s first-ever aggregated view across hundreds of experiments, driving data-informed product decisions and unlocking leadership visibility into customer behavior patterns· Uncovered 10k+ Fire TV returns by surfacing data in a new Tableau dashboard; translated complex data into actionable insights, saving $280k+ of operational costs by avoiding 1k+ re

Education

• Indiana University - Kelley School of Business

  Bachelor's Degree, Information & Process Management

  2011 — 2014

• Indiana University - Kelley School of Business

  Master of Science (M.S.), Information Systems

  2014 — 2015

Skills

• Windows
• Teamwork
• Time Management
• Data Analysis
• Critical Thinking
• Sap
• @Risk
• Microsoft Office
• Sales
• Research
• Microsoft Word
• Vba
• Microsoft Excel
• Powerpoint
• Customer Service
• Vb.net
• Access
• Xml Standards
• Public Speaking
• Social Networking
• Social Media
• Leadership
• Retail