David Wagner Email & Phone Number

Minneapolis, Minnesota, United States

•Sole in-house data engineer responsible for connecting, preparing, and modeling company data-lake (300+ DLOs)•Converting current company data workflows into SQL (from Progress 4gl) for easier future data wrangling and querying •Generating scheduled, personalized, multi-user analytics reports from MS SQL-based data model using Infor Birst•Identifying, documenting, and addressing ongoing data gaps to ensure detailed panorama of insight capabilities

Ramsey, Minnesota, United States

-Created predictive models in R and Excel for project costs of low-volume, high-mix projects which cut current predictive inaccuracies by over 83%-Compiled, cleaned, and analyzed using R, VBA, and Excel-Wrote dynamic scripts in VBA to obtain numerical insights for previously unattainable metrics-Created interactive dashboards to assess, display, and predict various performance metrics and KPIs-Reduced workload by 15+ hours weekly by constructing scripts to automate current analytics processes-Spearheaded multiple cross-team presentations to upper management to permanently establish these softwares and processes