Mike Lenz

Current

System Analyst / EDI Coordinator / Report Specialist at Professional Medical, Inc.

Past

Crystal Report Developer at Nicor Gas
Senior Programmer Analyst at Follett Higher Education Group
EDI Coordinator at Berry Bearing Company

Programmer Analyst at Scot Lad Foods, Inc
Programmer Analyst at Chicago Mercantile Exchange
Programmer at Andrew Corporation
Computer Operator at Andrew Corporation

see less...

4 more...

Education

Joliet Junior College
Lincoln-Way High School

Recommended

2 people have recommended Mike

Connections

53 connections

Industry

Medical Devices

Websites

Professional Medical, Inc.

Mike Lenz’s Summary

Experienced IT Professional.

Mike Lenz’s Specialties:

EDI, Crystal Reports, SQL Server, Oracle, COBOL, JCL, Easytrieve Plus, VSAM

Mike Lenz’s Experience

System Analyst / EDI Coordinator / Report Specialist

Professional Medical, Inc.

(Privately Held; Hospital & Health Care industry)

November 2007 — Present (2 years 1 month)

•While at ProMed, have developed over 200 Crystal Reports of varying complexity and varying departments for the company using Crystal Reports 10 and SQL Server databases. This entails discussing and documenting requirements with the user community and creating/designing reports to these requirements. This is a high profile position with daily interaction with the CEO, General Manager and other Directors and Managers within the company.
•Using my prior EDI experience, I am the primary EDI Coordinator/Analyst in getting the EDI program up and running at ProMed. This involves interaction with the EDI software vendor, Trading Partners and Trading Partner 3rd party EDI vendors for those that choose to do EDI outside their company.
Crystal Report Developer

Nicor Gas

(Public Company; GAS; Utilities industry)

February 2007 — August 2007 (7 months)

While consulting at Nicor, developed Crystal Reports of varying complexity for the credit department using Crystal Reports and PL/SQL from Oracle databases. This entailed discussing and documenting requirements with the user community and designing reports to these requirements.
Senior Programmer Analyst

Follett Higher Education Group

(Privately Held; Retail industry)

January 1997 — November 2006 (9 years 11 months)

•Main contact between the Accounts Payable and EDI groups for interfacing EDI invoice transmissions, system enhancements and problem solving with the various A/P systems.
•Wrote various conversion and interface programs to support the interfacing and transmission of the company’s financial data across multiple platforms (Mainframe, UNIX, AIX AS/400). These programs were written in SQL, Easytrieve Plus and COBOL.
•Created numerous reports via Crystal Reports for the user community. These reports were written from Oracle tables used in the Lawson packages and home-grown applications.
•Wrote SQL stored procedures for processing and interfacing Lawson data using Oracle database tables.
•Technical lead for the Fixed Asset webpage project. This project created a webpage of current assets for the over 700 Follett stores. This also entailed writing various Crystal Reports for the stores’ review and for auditing purposes in the home office.
EDI Coordinator

Berry Bearing Company

(Dairy industry)

September 1989 — January 1997 (7 years 5 months)

• Primary responsibility was the installation and implementation of the company's EDI systems. This included the installation of EDI translator software by Transettlements, and the conversion from Transettlements software to Gentran Plus software by Sterling Software.
• Communicated with both new and potential EDI trading partners via the phone and in person.
• Responsible for the EDI interfaces (programs, EDI mappings, etc.) to and from existing applications, setting up trading partners both on VANS and within the translation software (including Connect:Mailbox), and following new trading partners and/or transactions through the testing phase and into production.
Programmer Analyst

Scot Lad Foods, Inc

(Food & Beverages industry)

July 1986 — September 1989 (3 years 3 months)

• Worked on planning, coding, and documenting programs in various areas of the company.
• One of two people to implement an "in house" written purchasing system. This system consisted of both batch and on line programs written in CICS and COBOL.
• As a secondary phase to this system, responsible for creating an accrual collection and invoicing module. This module was designed to keep track of rebate money due the company for deals that vendors gave to Scot Lad for purchases made from them.
• Involved in writing COBOL programs used for the conversion of files to set up a new warehouse facility in Indiana.
• Performed maintenance on existing programs coded in COBOL and CICS along with debugging problems that would arise.
Programmer Analyst

Chicago Mercantile Exchange

(Public Company; CME; Financial Services industry)

March 1986 — July 1986 (5 months)

Worked in the clearing section of the MIS department. The clearing section's primary responsibility was to code, maintain and enhance programs that edit, balance, match, and report on the day's transactions. These transactions were submitted to the MIS department via punched cards, diskettes, on line terminals, or magnetic tape from each of the trading firms within the exchange. Programs were coded using both COBOL and Easytrieve Plus with ICCF running on an IBM 4381 under DOS/VSE with VSAM and some ISAM files.
Programmer

Andrew Corporation

(Privately Held; CTV; Telecommunications industry)

January 1984 — March 1986 (2 years 3 months)

• Coded programs in COBOL and Easytrieve Plus for both batch and on line processing on an IBM 3083 using DOS/VSE running under VM with VSAM files. These programs were based on specifications designed by a project team for new development in the manufacturing, financial, and payroll aspects of the business. Also documented these programs for both the end users and the computer operations staff. Responsible for maintenance and enhancements to existing programs. I also worked with PCs using DOS, BASIC, Lotus 1 2 3, Crosstalk, Easywriter, and WordStar.
Computer Operator

Andrew Corporation

(Privately Held; CTV; Telecommunications industry)

April 1978 — January 1984 (5 years 10 months)

Responsibilities included the monitoring of daily CICS activity that included thirteen remote sites, and troubleshooting problems of the on line network, and RJE lines, and running the daily schedule of jobs for the company.

Mike Lenz’s Education

Joliet Junior College

Associate in Arts and Sciences Degree , Major in Accounting, Minor in Information Technology , 1977 — 1979
Lincoln-Way High School

1973 — 1977