EXPERIENCE SUMMARY:

• Over 30 years of data processing experience.
• More than four (4) years of database experience utilizing IMS DB/DC, COBOL and DB2.
• Experience converting from Mainframe to Client Server environments
• IT Professional with over twenty years of IT experience in roles as Programmer Analyst or Systems Analyst, in environments utilizing IMS DB/DC, COBOL and DB2.
• Applications experience includes Finance / Accounting, Procurement, Data Warehousing, Banking, Retail, Automotive (leasing / warranty / material control / dealer), and Telemarketing.
• Experienced in converting applications from Mainframe to Client Server environments.

SKILLS SUMMARY:

• Languages: COBOL II, SQL, SAS, PL - 1
• Databases: DB2, IMS/DB, CICS, VSAM
• Software / Tools: IMS/DC, JCL, TSO/ISPF, EXPEDITER, ENDEVOR, FILE-AID, PANVALET, MFS, ROSOE, SRI/EDIT, FTP, LOTUS NOTES, DB2 Utilities, Dun & Bradstreet (D&B)
• Hardware - O/S: IBM 30XX, OS/MVS, HONEYWELL, HP 3000, UNISYS A-SERIES

PROFESSIONAL EXPERIENCE

IPS Technology Services,

Confidential,

Responsibilities:

• Responsible for maintenance using Batch COBOL, DB2, and SAS programs. Doing data analysis, system design and build test data for unit testing in the Claims and Membership.

Environment: IBM, COBOLII, DB2, SQL, FILEAIDE, SPUFI, QMF WORD, EXCEL, and Endevor.

Confidential,

Responsibilities:

• Responsible for writing Conceptual Design Documents, Unit Test Cases, Object and Exception spread sheets for large project for Blue Cross Blue Shield of Michigan.

Confidential, Wixom, MI

Responsibilities:

• Responsible for maintenance on programs that are using DB2 and IMS databases. When needed writing Specs for others to write programs using Cobol II, SQL, JCL.

Environment: IBM, COBOLII, DB2, SQL, FILEAIDE, SPUFI, QMF WORD, EXCEL.

Medical Leave

Confidential,

Responsibilities:

• Responsible for analyzing user needs writing specs for programming overseas, also creating binds and maintaining DB2 databases.
• When need writing programs using Cobol II, SQL, JCL.

Environment: IBM, COBOLII, DB2, SQL, FILEAIDE

PROGRAMMER ANALYST,

Confidential, TROY, MI

Responsibilities:

• Performed maintenance of legacy systems programs, primarily Accounts Receivable, during a conversion to a new A/R System. Made necessary changes / enhancements to the legacy system to aid in the conversion process.

Environment: UNISYS A Series, COBOL II, WFL, CANDE, DMS II

Confidential,

Responsibilities:

• Development involving coding, testing and implementation of mainframe applications. Consulted with customers and systems personnel to determine business requirements and system information needs for Procurement Systems. Environment: COBOL II, SQL, DB2, IMS/DC, PANVALET, TSO, JCL, EXPEDITER

PROGRAMMER ANALYST,

Confidential, TROY, MI

Responsibilities:

• Took data from Mainframe, (Membership, Claims, Provider, etc.) created extract flies (COBOL II / IMS / SQL) and use FTP to transport files into a data warehouse, than transferred files into a Client Server environment
• Designed, developed, tested and updated from spec Extract files to go in data warehouse
• Designed extracts, mapped extracts, created data flow diagrams for extracts
• Wrote JCL for the creation of Extract and sent Extract files out-of-state using FTP
• Used EXPEDITER and FILE-AID to debug problems with Extract
• Environment: COBOL II, JCL, IMS/DB, SQL, EXPEDITER, FTP, FILE-AID, Data Warehouse

Confidential

Responsibilities:

• Ensured all D&B programs were Y2K compliant and if needed made necessary changes
• Modified the COBOL II Reporting System and made JCL changes
• Developed a Data Warehouse System in COBOL II
• Wrote test plans to ensure programs run without abends using JCL and XPEDITER
• Wrote SAS programs to pull data from transaction files and put into reports, as well as wrote SAS programs for tabulation and frequency

Environment: COBOL II, JCL, XPEDITER, SAS, VSAM, TSO/ISPF

SYSTEMS ANALYST,

Confidential,

Responsibilities:

• Responsible for financial support handling all degrees of problems from maintenance to new development.

Environment: COBOL II, JCL, ISPF, METACOBOL, VSAM

SYSTEMS ANALYST,

Confidential,

Responsibilities:

• Responsible for part number conversion and date conversion for the year 2000 for the Material Control Department. Responsible for overseas financial systems.

Environment: IMS DB/DC, COBOL II, JCL, ISPF, VSAM, CICS (MAINTENANCE)

PROGRAMMER ANALYST,

Confidential,

Responsibilities:

• Performed work on the Confidential Project. Involved in the conversion of PL-1 programs to COBOL II utilizing IMS and DB2 databases in an OS/MVS environment.

Environment: PL-1, COBOL II, IMS, DB2, OS/MVS

PROGRAMMER ANALYST,

Confidential,

Responsibilities:

• Assigned to the Confidential project, with the system being used for paying monthly obligations without writing checks.
• Automated creation of date cards and was involved in heavy JCL knowledge to write new JCL and to test eliminating the need for date parm cards.
• Changed programs and tested changes. Performed development and enhancements using COBOL, COBOL II, VSAM and JCL.

PROGRAMMER ANALYST,

Confidential,

Responsibilities:

• Wrote, designed and debugged on-line programs for conversion from PC to Mainframe systems. Did screen design and interaction of screens / programs to pass data to other screens and programs.

Environment: Honeywell DPS7, Honeywell DBMS, COBOL, and COBOL II.

PROGRAMMER ANALYST,

Confidential,

Responsibilities:

• Supported and enhanced the Confidential (ACES) for Warranty and Dealer Closing. Performed problem analysis and resolutions for various programs.
• At the request of users, performed special assignments outside of regular projects.
• Maintained and enhanced current systems by performing analysis, debugging, new development, and enhancements.
• Environment: IBM 3390, MVS, COBOL, COBOL II, TSO/ISPF, JCL, IMS DB/DC, MFS, XPEDITER

PROGRAMMER ANALYST,

Responsibilities:

• Provided support of the Worldwide Engineering Release System, as well as debug and develop new programs. Provided technical support for the system for the users who had problems with the system.

Environment: IBM 3390, MVS, COBOL, COBOL II, IMS DB/DC, MFS, XPEDITER, TSO/ISPF, JCL

PROGRAMMER ANALYST,

Confidential,

Responsibilities:

• Worked on converting several systems (Dealer Operations / MSR / Fleet Tracking) from AMC’s Honeywell to Chrysler's IBM platform.
• Performed analysis, debugging, new development, and enhancements for the conversion.

Environment: IBM 3380, OS/MVS, COBOL, TSO/ISPF, JCL, XPEDITOR, PANVALET

Confidential,

Responsibilities:

• For a Telemarketing System, designed, wrote, debugged, and installed the system using a Unisys 4800, SRI/EDIT, CANDE, ISAM, MCP and COBOL.

PROGRAMMER ANALYST,

Confidential,

Responsibilities:

• Helped lead a team to consolidate a Material Control System of an automotive company. Wrote new JCL, and performed analysis /new development using an IBM 3380, OS/MVS, TSO/ISPF and IMS DB/DC.
• Worked with the Vertical Marketing System people on a HP-2832 using VI and RM COBOL for a new software package dealing with franchising.
• Developed new systems for the Commercial Loan Department of a local bank and did maintenance on the current systems using Unisys 4800, SRI/EDIT, CANDE, COBOL, and ISAM.