Eric Simmons Email & Phone Number

Los Angeles, CA, US

Chicago, IL, US

Northfield, IL, US

• Developed complex data pipelines, designing and building scalable, automated infrastructure for data extraction, transformation, and distribution, using combinations of SQL and Alteryx to build dashboards that support.
• Led cross-functional teams to deliver end-to-end data visualizations in areas across predictive analytics, top-line reporting, and supply chain optimization using rigorous methods to generate insights that inform.
• Spearheaded initiatives to optimize data systems and enhance financial and accounting processes, positioning the company for strategic growth and future market readiness.

Purchase, New York, US

• Drove global strategic approach to deliver higher data visibility and analytics, building scalable advanced analytics models by leading team of 4 analysts to provide data-driven visualizations and productivity.
• Owned end-to-end strategic initiative, leading global supply chain audits aimed at optimizing operations in order to drive quality and reduce costs for consumers, creating analytic models in Tableau and PowerBI used.
• Coordinated with master data governance to build E2E best-in-class competitive cost models, using Tableau, Excel, and SQL to identify insights and productivity around cost performance, operational efficiency, and waste.

Purchase, New York, US

• Supported FP&A Operations team by delivering 99.5% forecast accuracy for 2020 FY, identifying cost risks and opportunities related to demand planning, warehouse inventory, and operational efficiency.
• Led cross-functional OneWarehouse initiative by creating first OT hours and headcount plan across supply chain, leveraging labor KPIs and improving division cost structure.
• Developed methodology to capture impact of Covid-19 and Winter Storm Uri across Central Division, discovering $564K cost opportunity for supply chain. Resulted in X% improvement in labor performance against plan, and.

Purchase, New York, US

• Developed first method to audit nationwide company savings initiatives, presenting model and insights to PBNA president, finding $6.35MM miss vs. projected savings.
• Created scorecard to track YTD productivity performance against AOP initiatives, pairing with labor performance to find insights based on labor and waste trends.
• Forecasted and monitored $7MM in capital expenditures through balance of the year, by creating new report to drive insights into YTD spend, leading the division to finish fiscal year in line with annual capital budget.

Ann Arbor, Michigan, US

• Launched organization to provide education, career development, and innovation around FinTech at the University of Michigan by coordinating 10+ major events such as technical workshops and networking opportunities.
• Oversaw corporate relations team of 10 students, resulting in company sponsorships with industry leaders such as Facebook, Coinbase, and DRW Venture Capital, raising over $11,000 and launching inaugural Ross School of.

Purchase, New York, US

• Built model for evaluating product ad strategies by optimizing ad combinations with pricing architecture, in order to maximize volume, revenue, and profitability.
• Delivered analysis framework to Finance Directors, focused on ideal ad structures, product combinations, price sensitivity and promotional ROI, informing pricing architecture used in the Quarterly Business Plan.

Washington, District Of Columbia, US

• Oversaw expenditure of $5 million in mock-campaign funds, by breaking down costs of consumer acquisition against return on consumer brand awareness and other KPI’s.
• Analyzed intensity of competition, market growth, and industry trends for clients’ products, in order to develop marketing campaign emphasizing products’ simplicity and nutrition.
• Collected research on college-aged students to address decreasing market growth with Millennials, presenting our pitch-book at National Student Advertising Competition.

Dublin, Ireland, IE

• Built web-scraping program in Python that combed through a search engine for nearby infusion sites, downloaded 11 data fields on each infusion facility & sorted all data within Excel, resulting in creation of database.
• Mined database for trends across market for infusion centers & insights relevant to KRYSTEXXA using Excel pivot tables, presenting insights to KRYSTEXXA senior leadership.
• Created prototype for Sales Team that overlaid database infusion sites on Google Maps, allowing sales reps to filter through infusion centers based on criteria including city, territory, & specialty, prompting senior.

Master Of Science - Ms, Data Science

Bachelor'S Degree, Economics

Education record