Richard All Email & Phone Number

Marysville, Ohio, Us

 OTC / EDI Lead for Scotts eCommerce Magento 2 Project OTC / EDI Lead for Magento 1 Decouple Project  OTC / EDI Lead for Seamless Control SAP Implementation Direct To Consumer – Virtual Bundle Configuration OTC / EDI Lead – ScottsDirect.com (Big Bags Mulch Pilot) Led all OTC SAP config, ABAP and EDI development to meet all requirements for the Mexico CFDI v3.3 upgrade project for invoicing Held Orders Report Design / Development – Functional Lead Led the SAP Archiving Project, and found ways to streamline and simplify the process to help avoid so much manual intervention for future archiving initiatives EDI Lead development role for Project Yellow Ribbon (SCJ Fulfillment Model Change) EDI Lead development role for Home Depot 180 Project – Mobile app for handling Home Project Skybridge – Migrating Sterling Integrator from ATOS to AWS ensuring no disruptions to customer, vendor, and TMS / Bank AS2 / EDI connectivity and processing Led EDI development for lockbox and payment transactions with Wells Fargo Bank for Hawthorne Hydroponics SAP implementation Led EDI / OTC testing and config changes required for SAP EHP 8 Upgrade project Mentored the EDI Team through upgrading Sterling Integrator to version 5.2.6.3 Edgenet PIM Implementation – Mentored EDI team in completing integration map / process

Marysville, Ohio, Us

 Development Lead for implementing integration points for CentreSuite – new AP utility for managing PCard transactions with Scotia Bank Project Manager / Integration Development Lead for Lansa PIM implementation Project Manager / Development Lead for project to upgrade Sterling B2B Integrator to version 5.2.5 and migrate the application from Sun Solaris UNIX to SuSE Linux OS, and migrated the SBI database from Oracle 11g to Oracle 12c Project Manager and EDI Lead for SAP Implementation project for Scotts de Mexico EDI Technical Lead – Amazon.com Direct To Consumer implementation EDI Technical Lead on SAP implementation project for Scotts Australia business  Migrated all EDI / Integration processes from Gentran legacy EDI system to Sterling B2B Integrator Designed and developed new EDI solution in Sterling B2B Integrator that allows for quick and easy implementation of new trading partner transactions, greatly improving speed to market and project costs. Designed and developed multiple integrations between mobile app / web ordering applications and SAP Completed the Scotts Leadership Development Program (BTU)  Developed integration (map, XSLT, and BPML) between GXS Product Information Management (PIM) Supplier and Retailer applications for new integration with SC Johnson Support GXS PIM (Product Information Management) applications Continual performance tuning and monitoring of Sterling B2B Integrator and Gentran applications Create and modify Unix Shell, Perl, and AWK scripts when needed for reporting and data formatting Maintain effective and respectful working relationships with fellow EDI analysts and business team members Take ownership of issues and mentor fellow team members professionally and provide training to improve technical skills Proven ability to deliver solutions and provide timely support to the business under tight deadlines, budget constraints, and stressful situations

Marysville, Ohio, Us

- Developed and supported EDI interfaces for hundreds of trading partners world wide using Sterling Gentran and Sterling B2B Integrator.- EDI technical lead for SAP implementation in Scotts - Australia.- Upgrade of Sterling B2B Integrator to version 5.2.4.1- Developed generic EDI solution in Sterling B2B Integrator for future implementations and migration from Gentran

Columbus, Ohio, Us

 Design, develop, and support integration systems which have included the use of the following technologies…- Sterling B2B Integrator / GXS mapping tools- UNIX Shell scripts and Perl scripts- GIS business processes (BPML)- XSLT- EDI, XML, positional, and delimited files- Asynch and managed file transfer routing tables- MQ, Connect:Direct (for Windows and UNIX), Sterling Control Center, SFTP, FTP, SCP, GPG/PGP- PL/SQL Developed and supported EDI / ETL maps and business processes using Sterling B2B Integrator suite Provided support and development for EDI processes using GXS AI / Workbench application Migrated EDI processing from the GXS VAN to the Sterling Commerce VAN Developed all new EDI maps and BPMLs within the Sterling B2B Integrator suite, migrating all EDI related processing from the GXS integration suite Played a key role in the design and development of several integration projects including…- e-Commerce integrations for DSW.com including order data sent from the ATG web application and Yantra order management application, online catalog data sent to 3rd party online shopping applications, and credit card authorizations to service providers- Retail supply chain integrations between merchandising / ERP and Retek / Manhattan warehouse management systems.- JDBC adapter calls within BPMLs- Several integrations involving Lawson / Kronos employee timeclock and payroll data- Developed generic BPMLs for all processes that follow repeating steps (i.e. pull data from a DB, split and translate to target format, send target files to destination server / path.)  Served as the project lead for our current initiatives to redesign integrations involving DSW retail systems. These new integration processes will provide the enterprise with more accurate and timely data across all retail / warehouse management systems Primary resource for creating / modifying PL/SQL queries and processes

Columbus, Ohio, Us

Client/Server Development – Fulfill a key role in all aspects of the system development life cycle Client/Server Application development using PowerBuilder 9.0, VB, MS SQL Server 2000/2005, DTS, OLAP, stored procedures Development of powerful, user friendly applications for increasing productivity and improving business analysis and decision making capabilities Report writing against both production and data warehouse databases Perform complete systems analysis ensuring completeness and accuracy of all data and application processes Major Projects:- Worked on a team developing an electronic health enrollment application which made use of biometric scanners for secure sign on- Played a key role in redesigning the entire human resources system. This involved a new data model and new client side applications- Designed and developed applications for electronic submission and review of federal I-9 and W-4 forms.- Developed new communication server for handling all inbound and outbound files. This included sales, transaction, and punch clock detail files from each of the 350+ restaurants, order files coming from regional offices, and files going to and coming from outside businessesEDI / ETL Development – Developed an EDI system for the accounts payable department using Ascential DataStage TX map and type tree designer, and MS SQL Server; saving the accounts payable department hundreds, and potentially thousands of labor hours annually Primary contact for EDI related issues in all White Castle functional areas Developed and updated translation maps for extracting EDI data to SQL Server database and flat files using Mercator and IBM – Websphere (Ascential) DataStage TX map and type tree designer Managed all EDI integrated applications including Cleo Lexicom AS2 server, Trading Partner, and our in-house scheduling application Configured AS2 host connections in Cleo Lexicom AS2 server application

 Managed all departments and areas of the store including the repair / rental center and power equipment repair center Managed the company health plan, payroll, general ledger, and contracts with banking institutions Moved company to a new health plan saving over $200,000 per year while maintaining quality health care for the employees Organized a new gift card program which significantly increased sales Worked closely with accountants to ensure accuracy of all book keeping matters, and provided necessary documentation to company ESOP attorneys and accountants for the purpose of valuating employee stocks

Bachelor Of Science, Computer Information Systems

Business Administration