Eric Clay Email & Phone Number

Cincinnati, Ohio, Us

• Team Lead building trade feeds for Kroger Specialty Pharmacy. • Pipeline Orchestration and Monitoring of the trade feeds. • Team size of 14(full-time employees + consultants).• Ingests source system tables into Azure for the end state of creating 1) the business's data warehouse and 2) the ability to send out "trade feeds". Trade feeds are contractual reports sent to third parties. Feeds are the culmination of the entire azure architecture.• On a rotational basis for executing/handling production deployments.• On a rotational basis for overnight and weekend support responding to production pipeline failures.• Production data warehouse ~150 TB of data. • Performs performance testing and improvements of the data warehouse (Data Vault) architecture. • Primary Azure Resources: Azure Databricks, Azure Data Lake Storage Gen 2, Azure Synapse Analytics, Azure Data Factory, Azure Event Grid

San Clemente, Ca, Us

•Assigned to IT to support system integration between ICU and Legacy Smith Medical.•Lead Engineer assigned to maintain legacy Smiths Medical Operations Data Warehouse and Azure infrastructure to support operations during integration.•Tasked with building new reports and/or re-purposing existing reports to fall in definition with the merged company.

San Clemente, California, Us

(ICU Medical acquired Smiths Medical Jan-22)•Engineer on team building Azure cloud infrastructure for Smiths Medical across all business units.•Design lead for Supply Chain KPI’s Forecast Accuracy and Production Attainment.•Primary Azure Resources: Azure Data Lake Storage Gen 2, Azure SQL Database, Azure Synapse Analytics, Azure Power BI, Azure Data Factory

San Clemente, California, Us

Analyst in support of Operations. Works directly with Senior Executives, Plant Managers and staff across 13 factories creating tailored analysis for their needs or weekly KPI's to support their business objectives.• Apr-2020 Employee of the month. Created Covid-19 reports for tracking demand vs manufacturing capabilities. • Created EOL (End of Life) analysis that culminated in 3500 Sku’s being identified for obsolescence. This process involved using Python to automate PowerPoint slide decks to show candidates for obsolescence through the company’s product hierarchy.• Created supplier capacity tool for a key product line expansion project in conjunction with Adavanced Manufacturing and Engineering.• Global Operations Award for creating the Manufacturing Scorecard 2019. Publishes benchmark metrics used by the VP of Operations for weekly conferencing.• Global Supply Chain Award for Creation of NPI (New Product Introduction) metric 2018.• Global Supply Chain Award for Inventory Reduction 2017.• Performs analysis using a variety of tools such as jupyter notebook, python idle, excel vba, and excel power query.• Directly supports business unit managers and project managers through daily SQL queries from Oracle, and the Operations Data Warehouse (SQL Server database).

•Contracted in various analyst roles for specialty projects at Cargill and Polaris Industries. •Roles included maintaining rail car fleets, wheat flour daily shipments, and shipment reports.

Arlington, Virginia, Us

• Directed and oversaw transportation requirements of 14,700 soldiers in total: peak density at 3,900 soldiers• Accounted for and supervised all interstate and international movements for relevant operations• Planned and executed transportation movement of 200 Indian Army personnel to Fort Bragg, NC• Lead planner for multi-modal movement of 187 soldiers and equipment to Indonesia from Fort Bragg, NC

Arlington, Virginia, Us

• Rated “Best Lieutenant” in the Battalion: 1st of 13• Hand-selected to transport and track 535 pieces of rolling stock and containers to Afghanistan from Fort Bragg, NC. Produced documentation for senior executives and reported daily movement totals.• Managed logistics for pre-deployment training exercises, ensuring timely interstate movement of 136 pieces via rail

Arlington, Virginia, Us

• Directed logistics for 88 junior personnel of a Forward Support Company in an Airborne Field Artillery Battalion• Responsible for vehicles and equipment valued at $3.5M+• Managed time sensitive resupply of food, fuel, water and equipment for three unique Brigade Airborne Operations

Arlington, Virginia, Us

• Directed the scheduled and unscheduled servicing of 300 vehicles, the management of bench stock and stock supply and the equipment diagnostics and shop safety programs• Established partnerships with two Iraqi Police units and one Iraqi Army unit to advance partnering ops in-theater• Led platoon to a 2nd place finish in the Dept. of the Army competition for the Army Award for Maintenance Excellence

Master'S Degree, Data Science

Bachelor Of Science (B.S.), Construction Management