Developed the Information Management Project Charter.Completed an Information Management pilot project integrating a business glossary and Tableau using Collibra, managing 3 resources, and partnering with the Chief Data Office.Led the 2021 planning efforts focusing on growing stakeholder engagement and data stewardship delivering a detailed, resource loaded, MS Project plan and high-level road map.Implemented a Business Glossary with Business Terms and related Acronyms and two Logical Data Dictionaries in Collibra.Collaborated with vendors, internal team members and the Chief Data Office to identify solutions to technical challenges.Developed a custom asset model to support Alteryx integration with Collibra.

Defined a high-level SQL Server Analysis Services (SSAS) modeling methodology outlining phases and key deliverables at each phase. Presented to the Project Director for alignment and sign-off.Defined a detailed SQL Server Analysis Services (SSAS) modeling methodology documenting project background, key modeling drivers, software constraints, and modeling rationale to facilitate a standard approach among the modeling team. Trained and coached modeling team members to promote adoption of the modeling standards.Developed Excel based templates to facilitate capture and documentation of requirements. Enhanced the templates with VBA to improve the time to deliver documentation and increase the documentation accuracy. The scope of analysis included 49 SAP Business Objects (BO) Universes, 211 WebI Reports, 335 database tables and 1142 data elements.Defined a detailed set of guidelines for SQL Server view development and a template view creation script to facilitate a standard approach among the modeling team. Trained and coached modeling team members to promote adoption of the development standards.Developed and implemented 200+ SQL Server views.Developed and deployed 9 SQL Server Analysis Services (SSAS) Tabular models in support of Finance (Asset Management, Accounts Payable, Accounts Receivable, General Ledger, Inventory, Procurement, Security, Workflow) and Human Capital Management (Payroll, Job Error Reporting, Benefits and Deductions, Time and Leave) reporting.Developed Visio SSAS Model Diagrams documenting each SSAS model highlighting key design decisions.Provided support and guidance to 2 SSAS Modelers and 7 Report Developers assisting with development or technical issues and problem-solving efforts.Analyzed and documented existing SAP Business Objects (BO) Row Level Security (RLS) implementation and identified potential SSAS equivalents presenting findings to the Project Director and Manager to drive key application architecture decisions.

Designed innovative data warehouse architectures and solutions for 11 SAP BW data warehouse projects and 1 SAP BODS project.Led workshop sessions and collaborated with SAP and Nestlé’s Regional and Global technical teams to identify ETL optimization opportunities. System Availability Service Level Objectives (SLOs) improved from 74% in 2015 to 98% in 2016 through 2018.Led small teams, including international and cross-functional teams, to successfully deliver data warehouse and system interface projects.Represented Reporting in US Market project scoping and planning workshops.Led governance meetings with key stakeholders from the business reviewing projects, enhancements, and break/fix items aligning on priority and delivery dates.Selected to contribute SAP BW operational expertise to a Global SAP ERP 6.x to S4/HANA landscape simplification project impacting the US market. Collaborated with functional and technical teams to identify and resolve issues, align on cutover strategy, and develop detailed cutover plans for Reporting. Business disruption was prevented and 100% of reporting availability and data accuracy SLOs were met after system cutover.Partnered with Nestle Business Units and buyer representatives to understand Transitional Services Agreement (TSA) requirements and assess impacts.Defined production support model through collaboration with functional teams, data warehousing teams, and on/offshore resources documenting end-to-end systems flow, potential points of failure, automated / manual monitoring, incident escalations and roles and responsibilities.Leveraged business and system expertise to identify solutions to high severity issues during the nightly batch processing window that have the potential to impact System Availability Service Level Objectives (SLOs). System Availability SLOs were achieved 98% of the time from 2016 to 2018.