Winnebago, Inc.

• ERP Data Migration in the phased implementation of Microsoft Dynamics. Analysis of Dynamics Data Dictionary, development of Data Factory pipeline to extract Data Lake data to on premise servers. Development of Power BI reporting related to the rollout of MS Dynamics and legacy AX 2012 platforms.
• Supply chain. Development of ETL to pull rolling 52 weeks gross requirements and open orders from MS Dynamics and AX 2012 platforms populating the Data Warehouse Dimensional Model. Development of Power BI reports showing future part requirements, ETL (via SSIS) to output individual vendor requirements to Excel delivered directly to vendors on a weekly basis.
• Financial audit. Development of Data Factory pipeline to pull MS Dynamics data sourcing SSIS packages feeding the Data Warehouse. Reports developed for WIP Reconciliation, Perpetual Inventory Cycle Count and General Ledger Voucher Reconciliation.
• Manufacturing support. Analysis, development of data integration of Mainframe and MS Dynamics General Ledger Journal and Parts data hierarchy via SSIS, populating the Data Warehouse allowing for Power BI reports showing Production Order, Transfer Order and Yield Journal performance.