Customer Service Supply Chain
Resume:
JOHN B. PIPER
**********@***.***
Niles, IL 60714
Cell: 630-***-****
SUMMARY
Senior Applications Developer with over 15 years of design, analysis and
development experience in the transportation, banking and healthcare
industries; with an emphasis on Assembler and Cobol programming using
TSO/ISPF, CICS, DB2, IMS with PL/1 and all related IBM utilities. My career
has resulted in extensive business knowledge of international freight
forwarding and logistics, health care claims processing, banking,
warehousing, order entry and inventory control.
PROFESSIONAL EXPERIENCE
MERCURY PRODUCTS, Schaumburg, IL 8/2010 - 11/2012
IT Consultant
As a systems analyst it was my responsibility to maintain and enhance the
Glovia ERP application operating in a Red Hat Linux environment using
Oracle 10g and Cognos Impromptu reporting modules. Daily duties included
problem solving, database administration tasks, DB error checking and
troubleshooting on Oracle Database installations, tuning, maintenance,
backup and recovery using PL/SQL and PRO IV Superlayer. I played a major
role in the data conversion and migration from the Linux environment to a
Windows Server 2003 using Oracle databases, Cognos reporting, and Glovia
ERP software. I performed system enhancements and product error fixes on
GLOVIA which involved development using PL/SQL and PROIV SuperLayer
programming.
YRC LOGISTICS / US FREIGHTWAYS, Chicago, IL 8/2001 - 7/2010
IT Consultant
This position had a strong emphasis on supply chain management, e-commerce
and warehouse management systems. I was responsible EDI (electronic data
interchange) and other electronic communication, warehouse management
systems, as well as IT support and implementation for YRC Logistics
operations in Latin America.
. Developed new system functionality with both online and batch
programs enhancing an already robust application.
. Instrumental in changing the system configuration, replacing serial
devices with parallel devices and saving the company thousands of dollars
in monthly support costs.
. Mainframe contact for users in both domestic and international
locations, where I solved problems dealing with network
connectivity, functional procedures, and resolving supply chain
bottlenecks.
. HARDWARE / SOFTWARE: HP 3000; HP 9000; HP-UX, MPEi/X, Image
database, and programming in HP COBOL II, Informatica 7.1 and
Cognos PowerHouse (4GL).
Blue Cross/Blue Shield, Chicago, IL 5/2000 - 7/2001
IT Consultant
As a mainframe applications developer, developed an insurance claims edit
system using CICS and COBOL and VSAM data structures.
. Converted and tested all programs to use the generic packbinds and the
new Collection ID's where applicable. This included both batch and
online programs. Interfaced with other teams, departments, and test
coordination to create testing plans and approaches for successful
multi-platform testing.
. Supported Claims Processing production environment for both online and
batch processing
. Tools used MVS/OS, TSO, ISPF, JCL, Eztrieve, COBOL, CICS, VSAM,
System Development Life Cycle, MS Products: ( Word, EXCEL, Access,
Project, SQL, Powerpoint). Endeavor, ISPF, CA-7, SYNCSORT, DB2, lSQL,
and FileAid.
NICOR Gas, Naperville, IL
Sr. Programmer/Analyst 7/1999 - 5/2000
As a mainframe applications developer, supported the Customer Service
application. The application was primarily an online system that provided
customer and service order information for the customer service call
center. The mainframe environ-ment was a UNISYS A16 Clearpath machine using
COBOL programs accessing a DMSII database. The position also required
proficient knowledge of CANDE, WFL, ICD and DMSII Inquiry.
Dominick's / Safeway, Northlake, IL 2/1999 - 6/1999
IT Consultant
This assignment was a data center relocation. Dominick's environment was an
IBM mainframe, a MVS operating system, COBOL application programs and CICS
online processing. The file structures were VSAM and sequential datasets as
well as a DB2 relational database. Purpose of project was to move all
existing applications that were currently running on the Dominick's machine
(Northlake, IL) to the Safeway machine (Salt Lake City, Utah). The Safeway
machine was basically the same setup (i.e. IBM mainframe, MVS/COBL/DB2).
Both of the systems interfaced with other platforms such as the Unix
platform, AS400 and PC platforms. As part of the project, we executed
infrastructure tests as well as ran parallel production tests.
Firstcard/First Chicago NBD, Elgin, IL 4/1996 - 1/1999
IT Consultant
As a member of the new release conversion team, I was responsible for the
development processes to populate DB2 table for upcoming releases. This
often times required joint efforts of the DBA group, business areas and
data architects. A variety of means to access these tables including COBOL
II programs, SPUFI/SQL, QMF and Prism Data Warehousing was required. This
process was used in five major releases.
Boise Cascade Office Products, Itasca, IL 1994 - 1996
Senior Applications Analyst
As a senior member of the acquisitions team, my role was to take all
pertinent data from a recently acquired office products company, and
install it on the BCOP corporate system; a large IBM system using CICS
online processing and IMS DB DL/1 programming and DB2 databases. This data
typically included an acquisitions customer, inventory, contracts and
accounts receivable.
HARDWARE SUMMARY
IBM 30XX Mainframes, HP 3000, HP9000, UNISYS A-Series, Miscellaneous web
and exchange servers, and PC LAN configurations.
SOFTWARE AND OPERATING SYSTEMS
OS/MVS//XA, CICS, EXPEDITER, PANVALET, FILE-AID, EASYTRIEVE, QUIKJOB, QMF,
SQL, COBOL II, PL/1,
Assember, BAL, MICRO-FOCUS COBOL, MPEi/x, COGNOS Powerhouse 4GL (QUIZ, QTP,
QDESIGN),
Informatica 7.1.1, IBM DB2
DATA STRUCTURES
Oracle 10g, IBM DB2, IMS DB/DC using PL/1, MS SQL Server 2000, VSAM, ISAM,
HP IMAGE database
EDUCATION
Loyola University - Chicago; BA in Applied Studies with a concentration in
Finance/Economics.
* References available on request. *
Contact this candidate