Peter H. Email & Phone Number

San Francisco, California, US

• Serve as the lead administrator and integration architect between Kinaxis RapidResponse system and Microsoft Dynamics NAV ERP system.
• Design, develop and implement system data integration between DynamicsNAV and Kinaxis Rapid Response in collaboration with cross functionalpartners, by fully leveraging Azure cloud services (i.e. SQL, Data Factory.
• Maximized Kinaxis Rapid Response functionality by developing acomprehensive data modelling and transformation system to augmentinadequate data/lacking capabilities of the ERP system (i.e. Phantom BOM andsubstitution).
• Design and implemented parametrized data factory pipelines to efficientlyswitch between test and production data source to DEV/QA or ProductionKinaxis Rapid Response instances.
• Configured and implemented DevOps site with Wiki for source code tracking,integration project management and documentation.
• Collaborated closely with cross functional business stakeholder and externalconsultant to design and develop a close-loop connector for MS DynamicsNAV.

San Francisco, CA, US

• Responsible for delivering complex projects to integrate enterprise ERP system (SAP)with multiple business applications over two disjointed networks, while heavilysupporting ongoing business needs.
• Designed and implemented system integration interface that seamlessly connects 6 critical business applications systems, leveraging adaptive data exchange architecture that kept these systems efficiently aligned.
• Successfully delivered system integration based on complex transition plans (4 brands in 2 regions with multiple go-live timeline).
• Consolidated and mapped (legacy) historical sales data from multiple sources to the centralized SAP master data, then combined with the new SAP sales transactional data, while maintaining sales from obsolete customers.
• Created a new powerful analytical reporting cube that further combines sales transactions with 50+ point-in-time forecast snapshot, into an efficient and user-friendly reporting tool. Empowered hundreds of users with.
• Delivered DC Allocation application - an effective and flexible system that automatically allocates forecast to each distribution center (DC). Calculation is based on the availability of historical sales in various.

San Francisco, CA, US

• Responsible for the effective and reliable operation of business applications andreporting systems. Drove technology projects to improve business workflow/processefficiency and accuracy.
• Heavily involved in the design and rollout of SAP (ERP + EDI) and Synapse (WMS) at the new state of the art manufacturing and distribution plant, which was integrated with the then primary Syspro (ERP) system.
• Worked alongside the technology council in assessing and executing business process enhancement projects (i.e. full connectivity between Syspro and Trade Promotion Management system, physical inventory reconciliation.
• Delivered integration with business process enhancing application (Host Analytics – Financial Reporting, Concur – expense management, Kewill/BluJay – Transport Management System, Salsify – Product Management).
• Successfully managed the implementation of a feature rich major Syspro (ERP) version upgrade, through comprehensive review, training, UAT and go-live planning. Expanded Syspro functionality with the implementation of.
• Enhanced analytical (OLAP) cube reporting with new information from the Syspro upgrade and new integrations.

San Francisco, CA, US

• Responsible for the maintenance of Syspro (ERP) system, supported and enhanced userexperience with process and reporting developments. Assisted with John Galt
• Designed and implemented analytical reporting (OLAP) cube to consolidated and organized multiple reporting structures (finance, supply chain, sales and forecast) into one single source of truth, that has quickly become.
• Supported cross functional team in implementing John Galt (Forecasting system) and Arena Product Lifecycle Management (PLM) applications. And linked both system to Syspro’s master and transactional data.
• Partnered with IT infrastructure team to design, implemented ERP disaster recovery runbook, and built segregated (VLAN) network as DEV environment with ability to easily refresh data with VM cloning.
• Served as the ERP service desk manager in delegating issues resolution to various business application vendors (VAR).Forecasting and Arena PLM system implementation.

• Successfully evaluated and implemented Syspro ERP which enabled the company to sustain a double digit growth.
• Managed day to day ERP operations, MS SQL database, management reporting, IT operation (hardware/system maintenance, networking, software development, contingency planning, and technology optimization). Developed and.
• Ensured all server were engineered, configured, and optimized for maximum functionality and availability.