Senior Solution Analyst | Technical Business Analyst | Sql | Erp | Devops | Apics Cpim
Current- Technical lead/process owner between Supply Chain Functional Process Owners and data and software engineering teams. Supporting team with SQL data requirements to transform data structures to support a multi site supply chain distribution network, and testing support in transition of data warehouse from Managed On / Prem instance to Azure Serverless Instance, and transitioning of ERP from on Prem Dynamics AX 2012 to Oracle Cloud Fusion. - Review existing logic within Dynamics SQL Store Procedure data feeds that drive supply chain planning in legacy Dynamics AX 2012 system and translate these to Oracle Fusion SQL requirements - Provide Synthesized requirements to Data Engineering team to support creation of new Data Warehouse Models and new Store Procedures that achieve business requirements. - Develop Test Scripts and Lead Testing of new data models and stored procedures.