EXECUTIVE SUMMARY: Mr. Lehrhoff is an EDI and Messaging Applications Specialist with over 30 years of extensive experience. His forte is implementation of new transaction processing systems in many industries, as well as upgrading existing systems. Mr. Lehrhoff is a creative problem solver and systems integrator who understands the corporate vision. He effectively communicates with all levels of management and support personnel while working individually or in a team environment. He is a quality conscious project leader and expert systems engineer who specializes in Electronic Commerce solutions.
Data Mapping: XML, Electronic Data Interchange (EDI) and S.W.I.F.T.
Translators: Mercator (1.4.2,2.0,2.1,2.1.1,5.0,6.5,6.7,7.5.1,8.0), webMethods Trading Networks 6.1, GENTRAN:Server EC Workbench and GENTRAN:Server Workstation (5.x, 6.x) , GENTRAN:NT Server (1.0,2.0,3.0,4.0,4.02) , Supply Tech, Piedmont, Excel, GEIS EDI-PC and Desktop, Fortell, Edi-Able, GENTRAN:Basic, iWay Service Manager,MIDYS
Data Formats: EDI ( X.12, VICS, UCS, HIPAA, Edifact, EANCOM); S.W.I.F.T.; SAP Idocs; XML
Major X12 Transaction sets: 800 (wholesale distribution), 300 (Ocean), 900 (public warehousing), 200 (Freight)
HIPAA transaction sets: 4010A1, 5010
S.W.I.F.T. transaction sets: 540-548 (Trade, Confirmation and Status), 551-557,563,564-568 (Corporate Action)
UCC-128 and UPC labels.
Full integration at Host with existing software packages and extensive Chain Store Partners
Databases: Oracle, DB2 and SAP;
Transports: IBM MQ Series; BMW, CORBA
MS Office Apps (Access-Excel-Project-Visio-Word)
Extensive customer user base support and consulting.
Systems design and analysis: UML – Rational Rose., EDISIM ,Visio and XMLSPY.
Operating systems: TSO, CICS, AIX, Solaris, UNIX V, PICK, REALITY, REALITYX, Primos, Advanced Revelation, Advanced PICK, UNIDATA and DOS.
Inventory Forecasting and Modeling; Cost accounting.
Programming: Pick Basic, COBOL, UNIX shell scripting
iWay Software New York, NY 4/07 to present
Responsible for EDI and Trading Partner implementations of the iWay Integration Solution. Performed integrated product testing and QA. Created and published X12, EDIFACT, VICS, UCS and HIPAA metadata for product. Internal and user testing and consulting.
John Wiley and Sons
Data extraction for custom item catalog data sync. Data repository is located in DB2 on iSeries.
mapping with Unix Gentran Server 5.3 and SAP idocs. Mapped xml purchase orders
to xml idocs with XSLT. New data routing
to replace Atos Origin van services with
Johnson & Johnson
Developed ASN strategy, integrating SAP 4.6c, MARC warehouse system and webMethods 6.1. Designed UCC-128 shipping labels. Developed ongoing EDI strategy for pharmaceutical division of J&J.
EDI Project Manager (Consultant)
EDI Project Manager for new JD Edwards EAI implementation. Designed and implemented webMethods 6.1 Trading Networks to replace Mercator. Led staff of coordinator, two operators and three developers. Wrote EDI system documentation (URS, FDS, SDS and AML). Created and wrote EDI system disaster plan. Designed and documented canonical mappings for JDE interfaces to webMethods and CARS systems. Created full process flow documentation for existing Mercator 6.7.1 Commerce Broker implementation and interface with legacy VAX system. Designed new standalone ASP / .net Trading Partner application and interfaces.
Upgraded Mercator 5.0 to 7.5.1. Redesigned mapping flow to run Mercator within .Net C# mainline, created new generic flow maps for 852 – 846 – 856 – 832 transactions. Added integrated error reporting and checking. Designed new error repair and reprocessing facility. Added 997 and FA reconciliation to flow. Created new 816 – 864 process to load store information to SQL Server database.
eZCom Software Hackensack, NJ 4/04 to 10/04
Data translation mapping in Gentran 5.x, 6.x and 4.0, as well as Mercator 6.7.1, for an EDI outsourcing company. Mapping for wholesale, distribution, supply chain, automotive, and health insurance industries. Inbound and outbound SAP Idoc mapping. X12, Edifact and XML documents. Translator platforms include Windows NT, Windows XP and Solaris. Designed and installed Commerce Broker installation.
The Bank Of
S.W.I.F.T. Data mapping for Series 5 transactions with Mercator under TSO/CICS with MQ for trades, confirmations and status documents. Converted ISO 7775 documents to ISO 15022 for S.W.I.F.T. 2002 and S.W.I.F.T. 2003 conversions. Interfaced with end users in Global, Domestic, Income and Tax groups, as well as their development and support groups, to redesign interfaces to allow Bank of New York to send and receive expanded data sets. Created Test Cases; Unit tested, regression tested, staged and implemented major upgrades and installations. Mapped xml transactions for GSTPA. Interfaced with DBAs to develop direct update of XML messages to DB2, bypassing legacy applications and copybook limitations. Developer/designer for new bank-wide PSS corporate action system. Created all interface transactions – also replacing traditional cobol copybooks – for inbound and outbound transactions. Interface documents allow for multiple data formats – domestic, global custody, income and taxation – within a standard footprint as well as BankFax messaging. MIDYS team member. Support and monitoring for all S.W.I.F.T. traffic entering and leaving the bank. Used FILEAID (MVS) and ULTRAEDIT for testing, Visio for data flows and XMLSPY for schemas.
eB2B / Dynamic Web Fairfield
installed GENTRAN:Server Workbench (GIS) for internal data center use, running
under Solaris. Managed conversion of mapping from GENTRAN For DOS and
Designed and coded EDI flow and mapping for AT&T E.Gateway middleware project. Implemented Mercator under AIX, MQ and CORBA for EDI and non-EDI data translation. E.Gateway links telephone company and other utility billing systems, interfacing proprietary legacy systems with X.12 EDI. Initial implementation between AT&T and SNET consists of 850, 855, 860, and 865 using ATIS EDI standards. Used Rational Rose to generate UML and Visio to document data flows.
EDI Coordinator. Developed and implemented X.12 EDI Strategy for 1.5B
pharmaceutical wholesaler. Installed
Supervised five contract programmers. Developed claims processing software for start-up HMO; integrated custom software with SYSTEM BUILDER and CSC packages, running in UNIVERSE on IBM R/S 6000. Coded and installed EDI (NY UDSS UB-92 and HCFA-1500) between HMO and member hospitals.
IL & Co., Inc.,
Migrated wholesale distributor's system to TITAN system, running in Progress on SCO UNIX. Integrated EDI with GENTRAN for seamless transmission of stocking information, purchase orders and invoices. Fully integrated EDI from Comp-u-card, a catalog sales organization, as well as integrated UPS Maxi-Ship system to ship those orders. Responsible for set-up, daily operations and maintenance of SAI UNIX Platform and 20 user LANTASTIC network.
Image Integration Corp,
COLD and Imaging retrieval systems for Pick, Unix and DOS; EDI integration; PC to PICK interfacing; Customer software support and new installations for users of RESULTS, MDCAR, PaperClip and OPTICOM software, as well as other custom software installations. Hardware installations, upgrades and migrations for Pick, Unix and DOS platforms. Inventory Bar Coding and scanning systems.
Automatic Data Processing,
Design, Programming, and Implementation of Accounts Payable package for MANAGE-2000 and Distribution-2000 systems; Development of Auditing and Balancing policies and procedures; Design of Report Writer User Interfaces; Design and programming of Requisitions system. As Senior Programmer, set standard and procedures for entire programming staff.
Automatic Data Processing,
Support Interactive Accounting package with a specialty in Inventory Control, Purchasing, EDI, Forecasting, Encumbrance Accounting and On-site systems. Supervised small programming staff. Client support for installed user base. Software releases and operating system upgrades. Beta testing Project Leader.
Available upon request