RANDALL S. HOFF
**** ****** **** ***** 614-***-****
Columbus, Ohio 43221 ******@********.**.***
SR. BUSINESS ANALYST/EDI SME/BUSINESS PROCESS ANALYST
An extensive data mapping, support, and development career. This expertise includes:
• •
Manufacturing Applications Design Healthcare Customer Implementations
and Business Analysis in Medical Products Supply-Chain
• •
Sterling GIS/Integrator Mapping and Medical Supply- Chain EDI Support
Administration; GENTRAN Mapping and Business Analysis
• •
ERP EDI Implementations: SAP, Discrete and Continuous
Oracle, and J.D. Edwards Manufacturing System Interfaces
• •
SAP/ECC EDI Support, Analytics FTP, AS2, Industry Exchange, and
major VAN Communications
• •
Regression Testing Pharma Regulatory Systems
PROFESSIONAL EXPERIENCE
CARDINAL HEALTH 2014-Present
Consultant, Business Analyst
• Pharmaceutical Regulatory Reporting (ARCOS & NARCOS)
• Pharmaceutical Anti-Diversion System Support
• Pharmaceutical Recalls System Support
CARDINAL HEALTH 2009-2013
Sr. Analyst, Business Analyst (EDI)
• Performing EDI regression testing and analysis.
• Providing data analysis and trouble-shooting of SAP order processing and Workflow.
• Deploying JIT EDI Healthcare implementations for the medical product supply-chain.
• Coding trading partner configurations & EDPAR maintenance.
• Developing ad hoc SQL reporting and system status metrics.
WORTHINGTON INDUSTRIES INCORPORATED 1988-2008
EDI Analyst II, Systems Analyst, Sr. Programmer Analyst
• Served as the single point of contact and Corporate EDI Coordinator for first 9 years of
WII’s program, while preforming map coding and new implementations.
• Coded nearly 500 EDI maps on Unix, PC, and mainframe platforms
• Authored, co-designed, and tested Oracle (ERP) Phase I Financial Interfaces. (HP Unix)
• Designed and coded the key legacy infrastructure to enable the start-up of electronic data
interchange program at Worthington Steel. (base programs, MSCD records, EDCM
customer profile, and cum totaling)
• Developed the first event-driven EDI advanced ship notice transactions for Steel division.
RANDALL S. HOFF PAGE TWO
• Ramped-up and rolled-out EDI to the first 100 trading partners across WII.
• Reduced costs by $437,000 a year for data entry and error corrections by automating the
raw material receiving process with vendors for Worthington Steel.
• Researched and implemented third party software to support bar-codes and ASN
functionality on time and within budget for Worthington Cylinders. (PC)
• Led the EDI implementation of J.D. Edwards OneWorld for Worthington Cylinders.
(Unix)
• Extracted EDI Metrics.
ASHLAND CHEMICAL COMPANY 1980-1988
Technical Analyst, Sr. Programmer Analyst
• Authored technical and business specifications for major internal project when promoted
to Technical Analyst.
• Developed an online salesman commission application on the S-34 mini network
(COBOL)
• Enhanced lab analysis online system for Research and Development using innovative
screen scrolling features.
• Developed key components of the Plant Level Inventory system in IMS DB/DC, in PL-1,
for the Foundry Products Division. Roll-outs to 3 locations completed.
• Testing of online application modules.
EDUCATION
The Ohio State University
College of Engineering
Bachelors of Science in Computer and Information Science
Co-Op Work-Study Program (2 Quarters) at OCLC, Inc., Dublin, OH
TECHNICAL COURSEWORK AND EXPERIENCE
EDI Technical Team Lead
Business Analyst
Trading Partner Implementations & Setups
ERP Electronic Commerce Implementations
Unix Shell Scripting
Yourdon Dataflow Diagramming
The Dale Carnegie Course
Six Sigma White Belt