Programmer/analyst Resume
Charles, MO
SUMMARY:
- 25+ years of experience in Mainframe with strong knowledge of COBOL, CICS, DB2, SQL, VSAM IBM Utilities, TSO/ISPF, COBOL Stored Procedures, XPEDITER, JCL, RDX, File-Aid/CS and other important mainframe tools,
- Solid experience in all phases of the system development life cycle in the Mainframe environment.
- Highly motivated and enthusiastic IT professional with proven experience and outstanding analysis, programming and debugging capabilities.
- Consistently commended for ability to work as a team member or independently while achieving critical deadlines. Strong team player.
- Recognized for performance and project contributions. Consistently achieve highest rating in annual evaluations for top 5% of total company personnel.
- Extensive experience in automotive, banking, chemical and retail industries.
TECHNICAL SKILLS:
- Hardware: Amdahl 5890, IBM Mainframes Systems (3081, 3090, 390 and zSeries), IBM PC Compatibles (e.g., Compaq, Dell, IBM, et. al.).
- COBOL stored procedures, DB2, MQSeries, SQL, UNIX, Oracle, Geac/Infor M: series Financial applications including HR.
- Mainframe: Abend-Aid, ADW (Application Development Workbench), BMS, ChangeMan, CICS, CLIST, COBOL, COBOL II, CTG, dBUG-Aid, DB2, DCCS,Easytrieve, Endevor, Ford Shell, Hummingbird, IDCAMS, IMS DB/DC, ISPF, Librarian, IBM Operating Systems (MVS/XA, MVS/ESA, OS/390 and z/OS), MQSeries, Panvalet, PGP, PVCS, QMF, RMCOBOL, SAS, SDF, SDF II, SDM (Solution Delivery Methodology), SPUFI, TSO, VSAM and XPEDITER.
- Other: Lotus 1-2-3, Lotus Notes, Microsoft Products (Access, Excel, FrontPage, MS-DOS, Visio and Word), Microsoft Windows (3.1,'95, 2000 and XP).
EDUCATION:
BACHELOR OF SCIENCES IN MATH & STATISTICS
MASTER IN COMPUTER SCIENCES
WORK EXPERIENCE
Confidential, December 2009 to Present
Sr. Programmer/Analyst
IBM Mainframe, COBOL II, CICS, JCL, MVS, DB2, VSAM, EASYTRIEVE,
VISIO, IMS/DB, Assembler, SAS.
Maintaining existing Cobol programs both Bath & Online. Designed new process in regards to
outsource application. Analyzed current distribution systems and applied changes to several CICS
programs.
Confidential, (Springfield IL) July 2008 - April 2009
Team Leader
IBM Mainframe, COBOL II, CICS, JCL, MVS, DB2, VSAM, EASYTRIEVE,
VISIO, ACCESS. TELON, Assembler:
Created Medicare D claims DB2 tables. Wrote new programs to populate Medicare D
claims tables from accepted Claims spreadsheets.
Assisted all team members with designs & codes
Modified the cash application process, Cash report process programs to accommodate
payments, and credits on Part D. Modified. Modified online screens to allow for FC
94 accounts using COBOL II , CICS & DB2. Wrote new programs to make zero
payments from rejected claims Spreadsheets using COBOL II & EASYTRIEVE .
Tested all new CICS programs before QA testing.
Confidential, (St Louis MO) March 2007 to June 2008
Team Leader
IBM mainframe, COBOL II, DB2,CICS, Assembler, EDI MAPPING, ORACLE,
IDOC files, JCL, SAP. GLOBE Project:
Conversion from Legacy applications (Order Management, Pricing & Invoices) into EDI: IDOC
process, DB2 repository tables & SAP.
Designed & coded several programs to create an inbound process with all IDOC, FLAT & RAW files
into DB2 repository tables for SAP.
Assisted all team members with designs & codes
An outbound process from SAP into DB2 repository tables creating EDI IDOC transaction files for
updates & corrections. Changed several
Pro-Cobol Oracle programs using new pricing tables. Tested all batch & online programs before QA
test.
Confidential, (Philadelphia PA) January 2005 to February 2007
Team Leader:
INFOR HR:M Field Expansion 12.00.54, 12.00.55 & 12.51.56 & 12.50.57. Solution Fixes.
Installed and implemented INFOR HR:M: and Millennium 3.50.50.
PDL, SDT, CICS, COBOL II, ASSEMBLER, PCLINK, Mainframe IBM, VSAM, LE370, JCL,
MS PROJET, VISIO
Wrote several conversion programs using COBOL II, DB2, to change SSN# to Employee #, and in
house batch & online CICS. Downloaded all installation files, Batch and Online Solution files from
INFOR Answerlink, and applied to the respective Programs and CFX fixes. Changed several user
defined PDL Programs. Changed all customized Cobol Programs to comply with the Expansion
Release fields changes. Converted all User Defined Facts files. Ran parallel Payroll for two months,
before installing the Expansion Release: 12.50.57 into Production. Installed and implemented the
Cross Database Queries solutions. Used MS project & Visio to design the Conversion process of the
project. Major conversion for their Child support & Garnishment sub-system. Tested new screens
using CICS & PDL. Run SAS programs to retrieve Multi-mill DBID for changes
Assisted all team members with designs & codes
Confidential, (ALTON, IL) October 2004 to January 2005
Team Leader:
INFOR MILLENNIUM 3.01.00 INFOR Financials GL: M 3.12, FA: M 6.12.00, PDL, SDT, CICS,
COBOL II, IBM Mainframe, VSAM, LE370, JCL, DYL280.
Conversion from INFOR to SAP: BW.
Wrote several Programs to extract Data from FA:M Segments, and GL:M Control File, Master
File, Journal Entry File and Year End Summary File and loaded them into a Repository for SAP:BW
Designed new Reports for SAP:BW support team. Assisted the End Users to define the Conversion
Fields requirements for both FA:M & GL:M. Tested all conversion programs before implementation.
Assisted all team members with designs & codes
Confidential, (MILWAUKEE, WI) February 2004 to October 2004
Team Leader:
INFOR MILLENNIUM 3.50.00 INFOR Financial application ACCOUNT Payable: AP; M
5.15, PDL, SDT, CICS, COBOL II, Assembler and PCLINK. IBM Mainframe, VSAM, LE370,
JCL, DYL280.
Installed Millennium 3.50 and AP: M 5.15. Working on One Check per Vendor, by tagging &
deleting redundant Group-Corps and Duplicated Sub-Corps, before converting AP: M 5.12 data into
AP: M 5.15.
Developed SAS programs to generate statistic for Millennium control data bases. Tested all Batch &
Online programs before QA test. . Staged all modules into Changement.
Assisted all team members with designs & codes.
Confidential, (LOS ANGELES, CA) August 2003 to February 2004
Team Leader:
INFOR Financial applications FA:M 6.12.00 , GL:M 3.12, AP:M 5.12, AR:M 3.12,
Millennium 3.00.01. PDL, SDT, CICS, COBOL II, ASSEMBLER, PCLINK, Mainframe IBM,
VSAM, LE370, JCL DB2, DYL280.
Created new conversion programs for September 11, and May 05 Depreciation. Applied changes to
several PDL Programs and also some Batch Programs. Generated Reports with the new and old
Regulations. Account Payable 1099 & Year end process General Support for the FA, GL, AP & AR
applications. Tested all CICS & PDL changed screens before implementation. . Staged all modules
into Endevor.
Assisted all team members with designs & codes.
Confidential, (ST LOUIS, MO) April 2002 to July 2003
Team Leader:
INFOR HR: M Bulletin Upgrade 11.12.49, 11.12.50, Field Expansion 12.00.49, 12.00.50 &
12.00.51 Solution Fixes. Millennium 3.00.03.
PDL, SDT, CICS, COBOL II, ASSEMBLER, PCLINK, Mainframe IBM, VSAM, LE370, JCL,
CHANGEMENT, MS PROJECT, VISIO.
Compiled Liked all supplied Programs (Batch, Assembler, online) using the supplied JCL, & also
Changement. Used MS project and VISIO to design different phases, and Tasks of the project.
Installed and Implemented INFOR M: SERIES: Millennium 3.00.03, Bulletin Upgrade HR: M
11.12.49, 11.12.50, Field Expansion HR: M 12.00.49 and all 12.00.50 & 1200.51 solutions.
Downloaded all installation files, Batch & Online Solution files from INFOR Answerlink, and applied
them the respective Programs and CFX fixes. Created a Test Environment for the Bulletin 11.12.49.
Changed several user defined PDL Programs
Load the HR Data & Control Files, run the Payroll, and all In house Batch & Report Program
Work closely with two Managers for Production Implementation.
Converted the HR: M 11.12.49 Data into the Expansion Release 12.00.49, also all user defined screens
(CDD, CSV, PDL PROGRAMS), and all Report writer Programs. Changed all customized Cobol
Programs to comply with the Expansion Release fields changes. Converted all User Defined Facts
files.
Run parallel Payroll for two months, before installing the Expansion Release: 12.00.49 into Production.
Installed & implemented the Cross Database Queries solutions. Major conversion for their Child
Support & Garnishment sub-system. Tested all batch & online programs before implementation.
Staged all modules into changement..
Assisted all team members with designs & codes.
Confidential, (Tampa, FL) April 2000 - March 2002
Team Leader/Project Manager
INFOR Millennium Financial application GL: M 3.12 with DB2, EXEL, ACCESS, COBOL II,
ASSEMBLER, Mainframe IBM, VSAM.
Overseeing the Transition of Millennium GL from New York to Tampa. Analyzing, Designing, and
Developing the Users request for Modifications & enhancement of the GL system. Helped the daily
production problems with AP: M 5.12 (Account Payable).
Used MS PROJECT and VISIO to develop Systems Design & Analysis for the daily maintenance &
new Project developments.
Used MS ACCESS to extract Data from ORACLE Tables.
The maintenance of the Applications is performed using COBOL II, DB2, PDL, SDT, CICS, VSAM.
Run SAS programs to retrieve Millennium Control data info. Tested all DB2 CICS & PDL changes.
Staged all modules into Changement..
Assisted all team members with designs & codes.
Confidential, (St. Louis, MO) October 1999 - April 2000
Team Leader.
TESSERACT HR System: DB2, COBOL II, CICS, FILE-AID, EXPEDITER, LOTUS NOTES,
ORACLE, ORACLE FINANCIALS (GL, AP, AR), ACCESS, MICROFOCUS. TELON.
Maintaining batch & online programs in Payroll & Benefits. Also modifying some Focus
Programs.
Wrote scripts to FTP files from Oracle Tables on UNIX to the Mainframe. Updated some Stored
Procedures Programs.
Used ACCESS to extract & update Data from ORACLE Tables.
Wrote new interface scripts between AP and GL. Tested all DB2, PL/SQL programs after
development. Assisted all team members with designs & codes.
Confidential, (Florida) June 1999 to September 1999
Sr. Programmer/Analyst:
INFOR HR: 11.38, PDL, CICS, COBOL II, VIEWPRINT Mainframe IBM, VSAM, JCL,
ASSEMBLER, DYL260.
Wrote some PDL Programs for the Fruit System using SDT, created Viewprint Report both in
Online & batch. Modified some HR: M (Payroll, Taxes, Benefits, Personnel) PDL Programs & also
Some batch and online Programs. Used Endeavor to stage Programs & Jobs into Production. Use
Of FILE-AID. Tested CICS & PDL screens programs after development. Staged all modules into
Endevor.
Confidential, (Irvine CA) November 1998 to June 1999
INFOR AP: M 5:12 (Account Payable), CP: M (Capital Project), FA: M (Fixed Assets), VSAM, COBOL II, ASEMBLER, JCL, PDL, SDT OS/390, LE/370, CICS.
Team Leader:
INFOR CP: 2.12.00 Y2K implementation. Convert CP: 2.01.00 Data into CP: 2.12.00 for two
companies (KFC & PIZZAHUUT) .The implementation consisted of Unit test, System Test &
Production and two Multi-Mill regions on a new IBM Mainframe. Applied all custom modifications
into PDL, Batch and Online programs. Compile all batch and online COBOL programs using LE370
compiler.. Wrote new PDL programs during the implementations of AP: M 5.12 & FA: M 6.21, and was
consulted for all Millennium problems. Reinstalled Viewprint into Test for users training. Used
Endeavor to stage Programs, Jobs, into Production. Use of FILE-AID. Run SAS programs to display
Millennium control data info. Tested all Batch & Online programs before QA testing. . Staged all
modules into Endevor.
Assisted all team members with designs & codes.
Confidential, (Atlanta) May 1998 to October 1998
Team Leader:
Infor Financial applications Account Payable, General Leger, VSAM, COBOL II,
ASSEMBLER, JCL, PDL, SDT, OS/390, LE/370, Adabase, DYL260.
Implemented INFOR AP: M 5.12 (Account Payable), GL: M 3.12 (GENERAL LEDGER), HR
11.36, (Payroll, Taxes, Benefits, Personnel), DRW. Convert GL 3.10.04 Data into GL 3.12.00 &
AP 5.10.02 Data into AP 5.12.00 during unit test. Applied all custom modifications into PDL, Batch
and Online COBOL programs. Used version merger to compare the two version\'s programs before
applying the changes. Compile all batch and online programs using LE370 compiler. Support
production systems, which consist of INFOR AP 5.10.02, GL 3.10.04. Created a Multi-Mill region
for the Account Payable system test. Developed new DRW reports with the users. Run system
testing including monthly closing for GL 3.12.00. Implemented GL 3.12.00 & AP 5.12.00 into
production. Use of FILE-AID. Applied changes into Benefits & Payroll PDL Programs. Tested all
Batch & online programs before implementation.
Assisted all team members with designs & codes.
Team Leader:
Easytrieve Plus, INFOR "M" Series Financial application FA:M, SDT, MVS, VSAM, COBOL
II, ASSEMBLER, CICS, MS Access, MS Excel, SAP, PRO COBOL, PL/SQL, SQL/PLUS.
Initial responsibility to maintain INFOR M Series Fixed Assets daily and monthly process. Generate
customized reports using Easytrieve Plus. Analyze and design new user requested application
features, upload and download data using PC Link. Responsible for daily production supports.
Defined conversion file structures from INFOR Fixed Asset into SAP table file definition, using Pro
COBOL and PL/SQL...
Project leader in charge of INFOR Fixed Assets system. Define the Fixed Assets modules for year
2000 compliance. Handled all requests from users in Stamford, CT and Dallas, TX regarding update
and deleting assets. Prepared and processed Fixed Assets Tax and Book Year End reporting by
testing job streams and setting up production run sheets for year end closing. Use of FILE-AID.
Used MS PROJECT to develop Project Matrix for the daily maintenance & new Projects
development. Used ACCESS to extract & update data from SAP tables. Run SAS to display
Millennium control data.
Tested all batch & Online programs. Staged all modules into Endevor.
Assisted all team members with designs & codes.
Confidential, (St. Louis, MO) May 1994 to April 1997
Sr. Programmer/Analyst:
Oracle, PL/SQL, SQL plus, DB2, IMS, DL1, TCP/IP, OS/2, Lotus Notes, Windows, FTP, Excel,
ORACLE FINANCIALS (GL, AP, AR). Access, Word, Focus, Impromptu, Pro COBOL II,
TELON, M-QUERIES.
Did the initial Legacy conversion from the Mainframe DB2 & IMS applications into ORACLE 10.0 on
UNIX, using Pro/Cobol & Microfocus. Wrote several Stored Procedures to generate reports and FTP
data into the DB2 Tables on the Mainframe. Wrote new C++ programs to extract data from AR & GL
tables for evaluation and validation. Wrote new interface scripts between AP and GL.
Used ACCESS to extract & update data from ORACLE tables. Tested all programs before QA testing.
Confidential, (Kansas City, MO) June 1993 to March 1994
Sr. Programmer/Analyst:
INFOR Financial applications AR:M(Account Receivable), IC:M(Inventory Control),
FA:M(Fixed Asset), HR:M (Payroll, Taxes, Benefits, Personnel) , AP:M(Account Payable), DB2,
VSAM, COBOL II, CICS, JCL, EXPEDITER, DYL260.
Implemented three companies on INFOR AR: M1.1 into production region. Created new express
delivery reports definition for the new companies. Wrote DB2 batch programs for the in house
billing system.
Supported FA: M, IC: M, AP: M and HR: M (Payroll, Taxes, Benefits, and Personnel) in production.
Created two Multi-Mill Test & Production regions for a new Company on a new Millennium 3.0.
Installed INFOR AR: M2.0 into test region. Implemented AR: M2.0 in test and beta region for all
customers. Production implementation. Created new express delivery reports for all customers on
the new version of AR: M2.0. Implemented new customer on the AR: M1.1 in beta region. Use of
FILE-AID.
Tested all batch & online programs.
Confidential, (Chicago) - February 1993 to June 1993
Team Leader:
DB2, COBOL II, JCL, CICS, IBM: 3090.
Installed INFOR Financial application DB2 GL:M 3.03, implemented the GL:M 3.03 in test, pilot
and production regions, supported all GL\'s tables and created three multi-mill regions in test and
pilot regions, wrote several Viewprint programs using Viewprint MVP: 1.1 DB2 against the GL\'s
tables, used PClink: M to upload data from Lotus to the GL\'s tables, assisted the users during
implementation. Tested all batch programs.
Assisted all team members with designs & codes.
Confidential, (Houston) November 1992 to February 1993
Sr. programmer/Analyst
COBOL II, JCL, CICS, IBM: 3090
INFOR HR: M VSAM 11.29 (Payroll, Taxes, Benefits, Personnel). Created several fact files, designed and wrote the front-end interface program.
Applied changes to some Payroll & benefits PDL programs. Tested all Batch & Online programs.
Confidential, (St. Louis) April 1992 to November 1992
Team Leader:
DB2, COBOL II, JCL, CICS, IBM: 3090, PDL, SDT.
INFOR HR: M DB2 2.0 ( Payroll, Taxes, Benefits, Personnel). Designed special pays UCR and deduction UCR. Coordinated test payroll run jobstream, leader on
the personnel system, designed and coded PDL pre and post programs and report writer programs,
created new monitor tables, encode tables, decode tables. Technical support person for all
applications such as benefit, payroll and personnel, designed new screens. Worked on Child
Support & Garnishment conversion.
Tested all Batch & online programs before QA testing. . Staged all modules into Endevor.
Assisted all team members with designs & codes.
Confidential, (Indianapolis) 1991/1992
Team Leader/Systems Engineer.
DB2, COBOL II, JCL, CICS, IBM: 3090, PDL, SDT, EXCEL, Infor Financial application FA:M.
Designed and detailed corporate accounting and holdings using on INFOR software. Support a
online customer information control systems. Put into production a capital tracking system, installed
and implemented INFOR Viewprint and M: EDIT, designed and coded all CIP\'s report programs
during CIP implementation, installed and implemented INFOR Fixed Assets, installed INFOR SDT
and applied fixes to INFOR GL 2:03 and Millennium programs. Supported HR:M (Payroll, Taxes,
Benefits, Personnel) in Production Created a Multi-Mill production region for Fixed Asset users.
Used APS to generate COBOL codes. Use of FILE-AID.
Used EXCEL to develop Project Matrix for GL month end Process. Tested all batch & online
programs before implementation.
Assisted all team members with designs & codes.
Confidential,(Ohio) 1989 to 1991
Sr. Programmer/Analyst:
VSAM, COBOL II, JCL, CICS, IBM: 3090 INFOR HR:E series conversion to INFOR HR:M
series.
Installed INFOR PC LINK, GL 3.0, Viewprint, M: EDIT, install and implemented INFOR HR:
M 11.22 (Payroll, Taxes, Benefits, Personnel), wrote conversion program from INFOR HR:E to
HR:M, created fact files, wrote UCR program front-end, deductions, special pays, sick and
vacation, wrote PDL programs, designed and implemented order entries and customer systems
using DB2, SQL and CICS, supervised one to five workers. Updated several
Assembler Programs on an IBM MVS Platform. Used APS for the DB2 COBOL Programs.
Created Three Multi-Mill regions for new companies. Tested all batch & online programs.
Confidential, (Toronto, Canada) 1987 to 1989
Sr. P/A- Project Leader
DB2, VSAMCOBOL II, JCL, CICS, IBM: 4300
Infor financial applications: HR:M (Payroll, Taxes, Benefits, Personnel), GL:M(General Ledger),
AP:M(Account Payable), PO:M.(Purchased Order).
Supervised ten employees in installing most INFOR financial applications, designed and wrote
conversion programs, designed new screens, wrote PDL pre and post programs, created fact files
and wrote several batch programs including UCR programs. Also implemented the Account
Payable System into Production. Developed new DRW reports with the users. Tested all batch &
online programs.
Assisted all team members with designs & codes.
Confidential, 1983 to 1986
Sr. P/A
Designed and implemented accounting, financial and inventory systems.
Computer Science Teacher-1975 to 1983
Control Data AB, UWE-Verken, BECO industries and Montreal Gazzette Programmer to
Programmer/Analyst to Senior Programmer/Analyst.