Transitioned from Lead Analyst role into Manager of Revenue AnalyticsOwner of business logic surrounding monthly bookings process, KPIs like win rate, quote rate, customer churn, predicted deal value, monthly earned premiumStrong Partner to Finance, Sales, Client Success, and Insurance Administration leaders. Work hand in hand to help them leverage data in crafting strategy.Transitioning Beam to Self-Service Analytics. This includes continued buildout of a user-friendly data warehouse in Big Query with a Semantic layer in Looker. Includes partnership with Data Engineering, upskilling analysts, managing training for business leaders, building out visualization/dashboard assets, etc.Serve as trusted resource across Beam for the nitty-gritty high impact data problems. Examples: • "How do we recalculate premium adjustments if we need to retroactively change enrollment for mid-month coverage events" • Finding a mid-six-figure $ issue, Liasing with Engineering teams to address, and owning project management to Senior Leadership Team audience.Hiring and Management responsibility for team of 5 analystsTraining and upskilling 5 analysts on DBT, LookML, conceptual data warehouse architecture and semantic analytics designScope, advise, and oversee execution on team's projects: • Annual Territory and incentive design for a multi-tiered 65 headcount sales force • Monthly calculations of variable commissions for ~70 internal employees • Calculate all monthly and/or annual Supplemental payouts for thousands of external brokerage partners (SPIFFs, annual bonuses) • Answer hundreds of Ad-Hoc requests each month (Can you tell me what our market share is in XYZ geography and what our strongest competitive advantage is against the local competitors?) • Build dashboards to provide recurring visibility into the most critical and frequently used metrics across the company • Create focused marketing distribution lists for promos, events, insurance announcements, etc.

Lead Analyst for Revenue Analytics at a mid-size startupLed a redesign of budgetary attribution channel logic that solved an age old problem of 'which distribution channel gets credit for this deal'. Standardized the approach into a no-edge-case set of rules and built this in at the data warehouse layer (DBT models) to guarantee all teams would use the same output from this attribution logic.Uncovered significant financial impact from lack of rigor in deal value estimation approach. Designed new approach ultimately resulting in an ML model to predict insurance plan enrollment and annual premiums at scale. Resulted in deal value estimation accuracy improving by 85%. Business impact was that FP&A teams gained ability to accurately project future new revenues with enough confidence to make hiring and investment decisions.Architected a series of three dashboards (Tableau based) to provide increasing levels of granularity into business performance. Developed the business's first real time view of revenue, member counts, group performance/loss ratios, and sales funnel.As part of a uniquely intertwined Analytics/Data Engineering team, consolidated disparate source systems into a unified Data Warehouse leveraging Fivetran, Google Big Query, DBT. At this time we were using Tableau for front end visualization on top of Big Query.In a capacity often referred to as Analytics Engineering, wrote DBT code to build dozens of clean fact and dimension tables for consumption by Analysts and a few specific strong business stakeholders. Leveraged Jinja where appropriate to parameterize warehouse generation.Gained familiarity with CI/CD concepts through the use of Buildkite pipelines used to test changes made to DBT codebase.Experience also included most modern techniques used in the Data field today - Git version control of all code, DBT based "T" in the ELT stack, Incremental loading where beneficial, Full clone CI/CD dev and test environments.

- Member of global team responsible for analytics at Mettler Toledo- Responsible for the Service functional area analytics- Conceptualize, Design, and Develop changes to the data warehouse (SAP BW4HANA).- Build and maintain data load processes using automated process chains- Build advanced ad-hoc analytics as needed leveraging modern visualization tools- Train employees in Sales, Service, Supply Chain, and Finance on best practices in analytics. Travel to Malaysia, Germany, Poland, and around the US to conduct trainings and deliver seminars on analytics capabilities at Mettler Toledo.- Serve as subject matter expert in data, reporting, and business processes

Engineering Associate in the Initial Career Experience Rotational Program1st Rotation- Marketing Product Manager in US Industrial division- Worked to launch three new products to the US market- Performed competitive analysis, pricing study, prepared launch materials- Built automated reporting tools utilizing SAP data and custom VBA macros 2nd Rotation- Manufacturing Engineer at Worthington, OH final assembly plant.- Project Technical Leader for production line relocation from Ithaca, NY to Columbus, OH- Responsible for schedule, bill of materials, part procurement, training operators, tooling, work cell layout, production approval process3rd Rotation- Mechanical Engineer on Standard Industrial Engineering Team- Designed CAD models for new tamper-resistant fuse holder- Developed PLC system to demonstrate product technology (Allen-Bradley ControlLogix)- Identified and worked with manufacturing partner to produce fuse holder- Prepared drawings for Agency Approval of new fuse holder design- Developed Visual Basic application and HMI for Trade Show demo of Automation Devices

Engineering intern in Shell's Projects and Technology R&D organizationDeveloped new modeling and simulation process for upstream deferment predictionsUtilized VBA programming to implement Monte Carlo simulation techniqueResulted in significantly simplified and streamlined modeling process (decreased process from 40 hours to <8 hours)

Engineering intern in Upstream Americas DeepwaterSupported the new Stones deepwater projectCreated a systematic approach to designing a surveillance plan for FPSO project. Designed monitoring services for topsides process, and identified relevant instrumentation necessary to implement this surveillance.

Engineering Intern in hydraulics and landing gear groups. Worked on redesign of hydraulic hose routing in new midsize jet aircraft. Created engineering drawings and CATIA models of various bracketry, hoses, and miscellaneous geometry for hydraulic system as well as emergency braking system.