Resume of Brian Lehrhoff, EA

       Fair Lawn, NJ 07410

201-796-4342

 

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.

 

SKILLS SUMMARY:

 

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

Networks: S.W.I.F.T., Sterling Commerce, Ordernet, GEIS, Advantis, MCI, ICCnet

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; SQL, MS-SQL, SQL Server

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

 

RELEVANT EXPERIENCE:

 

iWay Software                     New York, NY                                                                                      4/07 to present

Product Manager

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          Somerset, NJ                                                                                         1/07 to 4/07

EDI Consultant

Data extraction for custom item catalog data sync.  Data repository is located in DB2 on iSeries.

 

Philips Lighting                     Somerset, NJ                                                                                         6/06 to 1/07

Philips Norelco                     Stamford, CT

EDI Consultant

Data 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 LENA.  Data mapping 211/214/240 transactions with Gentran Server 4.02.

 

Johnson & Johnson             Bridgewater, NJ                                                                                    4/06 to 6/06

EDI Consultant

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.

 

Organon Pharmaceutical   Roseland, NJ                                                                                        1/05 to 11/05

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.

 

 

 

 

Edifice Corporation            Riverdale, NJ                                                                                        10/04 to 1/05

Consultant

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

Mapping Consultant

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 New York         West Paterson NJ                                                                                    4/01 to 3/04

Project Leader

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 NJ / NY, NY                                                                            3/98 to 4/01

EDI Implementation Director

Selected and installed GENTRAN:Server Workbench (GIS) for internal data center use, running under Solaris. Managed conversion of mapping from GENTRAN For DOS and SmartMapper to Mentor and Mercator, creating over 800 Mentor and 150 Mercator maps. Trained and supervised six  programmer/analysts; managed four consultants. Onsite consultant for Sterling and TSI products at Toys R Us, Russ Berrie and Nabisco (Kraft). Year 2000 testing and implementation of Sterling at Nabisco.  SAP – EDI mapping at Nabisco, Russ Berie and various outsourced clients.  Data architect and lead  mapper for B2B portal project for sporting goods and golf industries.  Data architect for eTerm Ocean Terminal system (300 series) and Port Jersey public warehousing system (200 series).   Documented system flows with Visio and created user documentation with EDISIM.  Oversaw Mercator proof-of-concept for Standard and Poors.

 

DMR Trecom                          Jersey City, NJ                                                                                        9/97 to 3/98

Consultant

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.

 

Neuman Distributors               Ridgefield Park, NJ                                                                                 11/95 to 9/97

Project Manager

Supervised EDI Coordinator. Developed and implemented X.12 EDI Strategy for 1.5B pharmaceutical wholesaler. Installed STERLING: Mentor and STERLING: Server on AIX. Designed all mapping. Coordinated conversion from NWDA standard to X.12 for vendor documents. Redesigned customer data streams for Neustar 2000 remote ordering system, using 850, 855, 832 and 810 transaction sets. Project Manager for remote order entry interface with Singer Marketing. Documented system flows with Visio.

 

 

 

 

HealthFirst, Inc.,                     New York, NY                                                                                       05/95 to 11/95

Senior Programmer Analyst

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.,                         Maplewood, N.J.                                                                                    08/94 to 05/95

Project Manager

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,          Lyndhurst, N.J.                                                                                       01/91 to 08/94

Senior Programmer Analyst

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,    Roseland, N.J.                                                                                         07/86 to 11/90

Senior System Analyst

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,    Clifton, N.J.                                                                                            01/80 to 07/86

Senior Programmer Analyst

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.

 

 

EDUCATION:

 

George Washington University, B.B.A (Accounting)

Northfield Mount Hermon School

 

REFERENCES:

 

Available upon request