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, BlobStorage, Power Automate) for maximum availability, scalability and costefficiency.• 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), and consolidated multiple data source (i.e. IRI POS) with diversedata structure.• 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.• Identify and recommend system/data integration projects to fully harnesssupply chain application’s capabilities (include: designing scalable andsustainable solution. Manage building, testing, deploying, and maintaining ofsuch solutions).• Lead system improvements and best practice to support supply planning andinventory management optimization.• Manage the creation and maintenance of thorough, functional, and technicalsystems documentation and Business Process Documentation (BPD’s) for allStandard Business Processes + Exceptions Processes.

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 and products (that was not transitioned to SAP) to preserve financial reporting integrity.• 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 the visibility to business health without expensive reporting/application licensing cost.• 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 product classification levels. This tool allows manual global or date range overrides at customer/product level, primarily for promotional forecast volumes, and new distribution center transition.• Partnered with 20+ IT infrastructure team of experts in the design to migrate on-premises local server infrastructure to Azure hosted server, in a highly secured SCJ cloud network configuration. Vetted the solution with a comprehensive proof-of-concept exercise.

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 automation, automated greater than truckload order split and Amazon FBA).• 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 Fixed Asset management module.• Enhanced analytical (OLAP) cube reporting with new information from the Syspro upgrade and new integrations.• Designed and implemented a full featured packaging family application to enhance packaging data accuracy (that circulates to all customers via Salsify), and significantly improves workflow efficiency.

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 the main reporting data source/tool used across the organization. • 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 managed website/servers with real-time customer reporting/metrics.• Ensured all server were engineered, configured, and optimized for maximum functionality and availability.