Programmer Analyst
Resume:
James Guilfoyle
Lyman, SC 29365
g2xaw2@r.postjobfree.com
HARDWARE: IBM 4300, 3090, 3081 MAINFRAMES, BURROUGHS 2900, 3900, 4900, 6900, 7900 MAINFRAMES, NCR 9822 MAINFRAME, RSC 6000 AIX/UNIX MAINFRAME
SOFTWARE: OS/MVS, OS/VS, JCL, TSO, ISPF, SQL, DB2, VSAM, ISAM,QSAM, CICS, XPEDITER,CHANGEMAN, ENDEVOR, LOTUS NOTES, MICROSOFT WORD,EXCEL, INGENIUM, FRONTPAGE, FILEAID, SPUFI,QMF, APS, QUICKEDIT,
ADSO, EZTRIEVE, ASDD, IMS, SYNCSORT, MCPVI, WFL, PRO, IMPULSE, GENPULSE, GEMCOS, PROXY, FORTE,
CANDE, EDITOR, DMSII, NCR/VRX, CAI-NET, IVAN, ICE, LASER, QUEST
LANGUAGES: COBOL, COBOLII, ASSEMBLER
Education:
Chubb Institute, Parsippany, NJ
Computer Science Certificate
Tri-State University, Angola, IN
Worked towards Civil Engineering Degree for 4 full years.
Additional Training:
IDMS CLASS
SQL CLASS
ADSO CLASS
CICS and DB2
CICS Application Programming.
AIX Script Korn Shell Programming, APS, ENDEVOR, EASYTRIEVE, ASDD, QUICKEDIT
Major Accomplishments:
Toys ‘R’ Us – Solely coded their year end inventory system which processed the entire inventory for every store in the world. Consisted of 27 batch and 6 on-line programs. Accomplished in 2 months.
BCBS of NJ – Was responsible for maintaining the integrity of their group membership VSAM database. Consisted of millions of records. Kept major clients databases in sync with BCBS’s by creating audit system which analyzed and updated the BCBS group membership database. Also, created the programs to change the key field using restart logic.
Metromont – Was responsible for installing, testing and debugging their new BMH software for their new Payroll and Human Resource system. Was also responsible for integrating the two systems.
Metlife – Coded all the SQL utility programs which updated there new Ingenium DB2 tables for Term Life Dept. I was also responsible for creating and running audit system which kept their Legacy and new Ingenium DB2 database for Long Term Care in sync for 2 ½ years; until their new Ingenium system had been completed and the Legacy system phased out. Worked extensively with SQL and creating efficient cursors.
Professional History:
Jan 2009 - Present. Looking for contract or full time work. Will relocate at own expense.
Consultant – Collabara Sept 2008 – Jan 2009
Client:
Blue Cross/ Blue Shield of South Carolina Sept 2008 to Jan 2009
Mainframe Cobol/SQL Programmer
Consulted in Columbia. Worked in AMMS Claims.
Was responsible for Library Management, Production Support of Test Claims Systems and generating and mailing of New Business Graphs. Trained in ENDEVOR, APS, EASYTREIVE, QUICKEDIT, ASDD and other software integral to BCBSSC.
Consultant – Tek Systems Jan 1998 - Jan 2007
Client:
Met Life Sept 2000 – Jan 2007
Mainframe Programmer
Responsible for updating year-end claims history purge for Dental. All phases of modification, testing, documentation and implementation of new year-end history purge.
Responsible for all JCL and program modifications for batch year-end run. All programs are COBOLII and read and update VSAM files. All programs call each other and pass info via Linkage Sections.
Responsible for creating and modifying new and existing batch Ingenium DB2 programs and JCL for Voluntary Dental. Responsible for all phases from creating Tech. specs to coding programs and JCL, testing, documenting and implementation of batch jobs.
Responsible for coordinating testing and verifying results of shared jobs between Critical Illness Group and Voluntary Dental Group.
Responsible for setting up new distribution groups in Lotus Notes to receive new and existing reports.
Client:
Met Life Long Term Care July 2004 – Dec 2005
Mainframe Programmer
Responsible for coding DBII conversion programs. These programs created files from the old Legacy system and loaded them to the new Ingenium databases. Coded the production audit systems which would scan the Legacy and Ingenium databases and pull off all new data on each and update it's counterpart. This kept the two databases in sync which was required because the old Legacy system had to be maintained until all releases of the LTC Ingenium install could be completed.
Worked writing SQL for data corrections and coded program enhancements for claims.
Developed reporting programs.
Responsible for all JCL, Pics, Installs etc.
Responsible for all phases of designing, coding, testing and implementing of new Ingenium based applications.
Created HTML pages, P-steps, Flows, Screens and batch and on-line DB2 programs. Worked extensively with Changeman packages, TSO, ISPF and Ingenium based software. Worked for the Term Life group and coded, tested and implemented all of the Business Rules associated with Term Life. Have coded over 300 new production programs and 600 new production copybooks for Met thru the end of this contract period. Was responsible for all JCL associated with all production programs that were created. Some of the tools worked with are Excel, Lotus Notes, Powerpoint and Frontpage.
Client:
Met Life, LTC&ATLAS May 2001 – June 2004
Mainframe Programmer
Responsible for the coding, testing and implementing of all COBOLII DB2 batch and online utility programs used in Metlife's new ATLAS Ingenium system for Group life. Responsible for coding all programs which retrieve data from Metlife's Plan Master DB2 database.
Responsible for coding all Data Bridge DB2 programs that took the data from Met's Long Term Care Legacy database and created flat files that were loaded to the new Ingenium TLC databases. Responsible for keeping the data in both systems in Sync until the new system was completely operational and the old system could be shut down. Was primary on-call for production support 3 times a year for a week and secondary 3 times a year for a week.
Responsible for all phases (specs, coding, testing and implementation) of Metlife's new batch mass salary update system which interfaces with the new Ingenium insurance system database and Metlife's Plan Master database.
All programs were written for batch and online systems. COBOLII, DB2, JCL, Changeman, Xpediter, Lotus Notes, Excel and Microsoft Word are heavily used.
Client:
Met Life GUL Sept 2000 –Nov 2000
Mainframe Programmer
Responsible for creating new COBOLII programs to build and analyze the new MET and
KVI Life To Date Portable Charge Master Files.
Coding the new programs to process the monthly MET and KVI Portable Charge Detail files by matching against these master files and creating a METFACS Interface file of any NET changes and a report of all dropped records or records in error.
Creating the MET JCL to run under GURU and making any changes to it in order to spawn off this job. Creating the KVI JCL to run on Request. Also, responsible for all phases of testing and learning CHANGEMAN used in implementing all procs, programs, link decks, copy files etc. needed for each job.
Using LOTUS notes to keep all analysts involved in this project updated on the current status and progress of this project.
Client:
Clemson University/State of SC Feb 2000 – Aug 2000
Mainframe Programmer/QA
Quality Assurance Team at Clemson (CAT)
Worked for a quality assurance team at Clemson University 's Center for Applied Technology regarding the new S.C. state medicare system.
Responsibilities include the analysis of program and system logic for standards and specifications set by DHHS.
Responsible for the analysis of JCL, batch and online (IMS) COBOLII programs and screens using SQL, IDMS and ADS logic.
Responsible for creating test cases, test data and execution of new systems and programs
and insuring through Data Base analysis that all facets of the system and program logic are performed successfully.
Client:
United Health Care Oct 1998 – Oct 1999
Mainframe Programmer
Developed programs from SPECS. Developed and tested PROCS for corresponding programs.
Wrote banking report system in COBOLII and DB2.
Enhanced all CICS programs to be more efficient with DB2.
Client:
Milliken Jan 1998 – Sept 1998
Mainframe Programmer
Member of Milliken's Year 2000 compliance team. Responsible for the systems; includes IMS batch, real-time programs and all JCL. Tools include file-aid and data-ager.
Progress Lighting Nov 1996 – Dec 1997
Programmer/Analyst
Programmer / Analyst on RSC 6000 AIX UNIX operating system. Languages include microFocus COBOLII, CICS, and DB2. Job entails conversion from IBM Mainframe to RSC 6000 platform. Responsible for all phases of development, coding, testing, debugging, maintenance and implementation of COBOLII, CICS, VSAM, and DB2 programs and JCL.
Metromont Materials Feb 1989 – Feb 1993
Systems/Analyst/Programmer
Solely responsible for the implementation, testing, analysis and modifications of new
Payroll, Human Resources, Fixed Assets General Ledger, Accounts Payable and Receivable financial applications packages. Other responsibilities include the conversion of corresponding databases and the support for these systems. In addition to these responsibilities, successfully implemented the Payroll and Human Resource systems that interface with each other and the new
General Ledger package. Also, the General Ledger, Accounts Payable and Fixed Assets databases have been converted to indexed files for use in user inquiry systems that I developed.
Blue Cross/Blue Shield of NJ Sept 1986- Nov 1988
Systems/Analyst
Duties and responsibilities included the development, programming and implementation of a group audit system as well as the analysis and development of new insurance coverage packages. Also maintained the group enrollment database. In conjunction with above, have significant interfacing with all levels of management. Classes: IBM Advanced JCL and VSAM.
Rhone Poulenc July 1985 – Sept 1986
Programmer/Analyst
Responsible for all phases of research, analysis, development, testing, implementation and documentation of new financial programs and systems. Duties include maintaining and debugging an on line order entry system, and the payroll and budget systems, as well as the new design and development of GENPULSE generated financial applications.
Toys R Us April 1984 – July 1985
Programmer/Analyst
Responsible for analysis, development, testing, implementation and documentation of new financial programs and systems with user interface. Specific responsibilities included all phases
of development and packaging of new year-end inventory and vendor analysis systems, Also responsible for year-end initialization of financial databases. Other duties included maintaining and debugging accounts payable on-line systems with extensive use of DMSII.
Porex Industries Dec 1982 - April 1984
Programmer
Responsible for development and maintenance of manufacturing, general ledger and accrual systems. Duties included design, code, test, debug and Implementation of programs with extensive use of databases.
Contact this candidate