SUMMARY:

• 10+ years of technical experience as a software developer/ business consultant in the supply chain arena. Business focus on demand planning, supply planning, inventory planning, replenishment planning and manufacturing planning (DP/IP/RP/SP/MP). Guided client team projects in the design, testing and implementation phases. Encouraged awareness and steered businesses into industry best practices through all phases of the project lifecycle. Technical focus on automating data (integration) between systems utilizing ETL, SQL, SSIS, batch and PowerShell programming.
• Proven ability to reduce costs, improve operations and deliver effective technology solutions. Excellent problem solving and communication skills. Direct communication with clients and supply chain teams to define business and technical requirements. Development and implementation of advanced IT supply chain planning solutions.

TECHNICAL SKILLS:

SQL: database design, stored procedure development, ETL/SSIS/table/view design, performance tuning, index creation /enhancement

SQL Administration: SQL server deployment/install/configuration, backup and restore strategies, db and server tuning (large data sets) Automation using DOS / batch / power shell scripting/FTP. advanced MS Excel/Access custom application development /VBS/Visual basic

Confidential: DP/IP/RP/SP/MP expert level troubleshooting data and process issues

Network performance tuning: root cause analysis/solution implementation

Redwood, Opalis, Unicenter job schedulers: job design development and support

Oracle/DB2: SQL / Administration / DBA/stored procedure development, table/view design, performance tuning JDA report design / development/JDA Inventory /Manufacturing Planning JavaScript/HTML/CSS/XML/XSL/ ActiveX/ COM/DCOM/ Visual Basic/ VBScript/Visual Studio/C++

Competencies: Supply Chain Consultant, customer focus, effective communications, action oriented, ownership of projects/issues to implementation/resolution. Planning and problem solving.

Most recent experience: Confidential, MS SQL Server Management Studio/TSQL developer/SQL DBA, JDA, SQL Scripting, Batch Scripting, SSIS/DTS, VB/VBS, Oracle DBA

Software packages: Confidential Demand Planning, Supply Planning, Inventory/Replenishment Planning, Manufacturing Planning, Demand Chain Voyager, SAP Operations, Material Management. Lotus Notes, Lotus Domino

PROFESSIONAL EXPERIENCE:

Confidential Technical Architect/SME

Confidential, Lisle IL

• Confidential DP, SP and MP team technical SME - provided level 3 support for Confidential applications.
• One SAP Project - design, development, install, configuration, system tuning, documentation, training/KT.
• Microsoft Azure server: OS, SQL tuning and performance debugging. Performance troubleshooting/solution recommendation and implementation.
• Server sizing recommendations for new environments such as development, QA and production systems.
• Built/stood up new SQL and Confidential environments to support project development work, QA and productions systems utilizing Azure servers. Built SQL database, application, web and FTP servers.
• Conducted knowledge transfer sessions with offshore teams for 7/24 system support including creation of training material.
• System landscape architecture design, and technical system documentation (Visio).
• System design of integration between One SAP and Confidential .
• Performed major upgrade of Confidential software for all environments, migrated client from .
• Business and technical side requirements definition meetings to identify needed customizations to the supply chain system. Provided estimates, development of customizations and implementation of solutions.
• Development of integration between One SAP backend data and Confidential DP, SP and MP.
• SQL script, stored procedure and batch file development integration with Redwood job scheduler.
• Developed automation which interfaced Confidential to numerous systems including One SAP (inbound and outbound), AFS (sales) and Analysis for Office (A4O).
• Software installation and configuration: Installation and configuration of server-side software including SQL, Confidential and other third-party utilities. Performed software upgrades and patches.
• MP Confidential 8.5 to 7.6 project - created interfaces out of a newer version of Confidential SP to interface with an older version of Confidential MP.
• MP 7.5 move off all hardware to new Azure solution (32-bit application running on 64 OS).
• FTP server setup/configuration/FTP script development.
• Development and automation of custom reports using SQL.
• Custom Confidential 7.6 Integration with Confidential 8.5 automation project which integrated the forecast from Confidential 8.5 to a legacy version of Confidential running 7.6.
• Dedicated system support 7/24 on rotation.
• Direct store delivery (DSD for retail business pilot project (Dollar General) encompassed SQL and batch script development. Built and automated EDI interface data inbound and outbound between the DSD High Jump systems and Dollar General for EDI transactions utilizing SQL tools. EDI project utilizing SQL integration with High Jump software. Developed SQL and automation for various inbound and outbound EDI interfaces for Dollar General integration project.

Technical Architect

Confidential, Ontario CA

• Provided implementation support for a large west coast-based bottling company during the implementation and go-live phase of the Confidential software suite including DP, IP, RP, SP and MP. Development of custom scripts and stored procedures which modified the back end Confidential tables to meet the custom business requirements. Data analysis of large data sets to assist the business in making critical decisions regarding forecasting (DP). Assisted with ERP interface development and data clean up. Provided client consulting services including system design, development and customization of Confidential software.

Technical Architect

Confidential, Atlanta GA

• Development of both integration solutions between Confidential modules and ERP systems (JDA, SAP M3, BPICS)
• Consulting, problem definition, detailing of processes, architecture and design
• System redesign and recommendation
• Converting business requirements into technical architecture and design
• Custom application development/SQL/Batch/VB
• Business process scenario and requirements definition
• Technical system design
• Confidential support / troubleshooting
• System administration and integration training

Consultant

Confidential, Lake Forest IL

• Development of tools which automated the process of setting JDA inventory parameters based on business rules
• User training
• Management presentations
• Data validation and UAT

Consultant

Confidential, Naperville, IL

• Implemented Confidential demand and supply planning modules.
• Implemented Opalis job scheduler on various platforms including MS SQL and Oracle.
• Defined business requirements for custom modifications to Confidential including batch processing.
• Built demand planning models and implemented automatic model switching in Confidential .
• Developed custom batch processes to modify Confidential backend SQL data to support the custom business process. This included modifying the backend Confidential SQL tables (time series and root tables) to handle item, location and channel remapping / assignments.
• Built custom SQL and batch processing to import demand signal data and supply data into Confidential .
• Created a business portal website frontend to allow users to access backend SQL data and make data modifications to SQL server data utilizing VBS, HTML and JavaScript.
• Developed and automated multiple custom reports utilizing DTS and SQL programming.
• Developed batch programs to automate interface data loads into Confidential from multiple sources including SAP, Legacy AS/400, SDS and other custom software packages.
• Developed and implemented a website to automate and capture promotional data utilizing VBS, HTML and JavaScript.
• Wrote custom SQL to pull data out of JDA Oracle backend tables for reporting system.
• Implemented and utilized Opalis scheduling software to automate and process custom batch programs and both SQL and Oracle servers.
• Implemented Oracle client on application servers for Opalis Automation.
• Performed SQL Server and Oracle DBA activities to maintain database backups, restores and DTS for custom interfaces between database servers.
• Utilized best practices for change control / implementation
• Provided 7/24 support of all planning applications.