Andrew Hedden Email & Phone Number

Murray, Utah, United States

Draper, Utah, United States

* Partner with various business units and stakeholders to design and maintain data models and visual dashboards within Power BI that enable key stakeholders to review sales history, product attachment rates, inventory health, and marketplace website traffic. * Conduct trainings to increase the adoption of new Power BI functionality among key stakeholders.* Work with cross functional teams to understand and fulfill ad hoc data requests by querying the ERP database using Spark SQL and modeling results within Excel or Power BI.* Troubleshoot data connection errors within orphaned reports and re-design reports where applicable.* Migrated Excel reporting library with direct database connections to query against the enterprise data lake using Spark SQL.* Organize and conduct the semiannual process of re-calculating standard costs for 150 active SKUs, while collaborating with multiple teams across the organization.* Consolidate and report to Senior Leadership open vendor liability that is not captured within the ERP.* Support the Supply Chain team with dispositioning and actioning the resale of excess materials totaling $1.8M.* Update and present the monthly inventory outlook to key business leaders.

* Executed the supply plan for 9 warehouses through converting purchase requisitions to purchase orders.* Collaborated with cross functional teams to plan for new products and communicate raw material shortages.* Evaluated and maintained planning master data to improve the supply plan generated within SAP.

Sugar Land, Texas, United States

* Collaborated with cross functional teams to analyze supply planning master data gaps and establish clean up and governance processes. * Led a team of 5 key stakeholders from Supply Planning, Demand Planning, and S&OP teams to identify and update key process and training documentation.* Created a global supply chain document library (SharePoint) and established governance procedures for maintaining documentation.

Houston, Texas Area

* Analyzed PFD’s, permits, water sample data, and other documents to prepare proposals and reports for water treatment projects, primarily regarding desalination, produced water management, and experimental treatment methods.* Performed a safety analysis evaluating potential methods for the transportation of compressed refrigerants.* Researched and evaluated the feasibility of using bacteria to produce marketable by-products from treating acidic mine drainage.* Analyzed and compared methods of handling produced water to minimize costs and impact to the environment.