PROFILE:

Confidential is a senior IT professional, possessing development expertise utilizing PACBASE, COBOL, Assembler, and other mainframe technologies and tools. Having more than 12 years of experience as a Senior Programmer Analyst, Confidential is committed to providing clients the highest level of quality development and customer service. He has worked as a consultant for more than ten years and has significant experience in banking and financial services. His skill set includes knowledge in requirements analysis, design, build, review, testing, and implementation.

TECHNICAL SKILLS:

Databases: ORACLE, DB2, IMS, VSAM, Access, AMS, QMF

CASE Products: PACBASE, PACBASE Access Facility, Method/1

Hardware: IBM RS6000, IBM MF, IBM PC/Compatibles

Software: Tandem, SAS, NDM, Quattro Pro

Languages: COBOL, COBOL II, C++, Visual C++, EASYTRIEVE, CICS, MVS/JCL, PL/1

WINDOWS, MS: DOS, UNIX, AIX, VM/CMS, SORT, VSE

TSO/ISPF, File: Aid, XPEDITER, PANVALET, MFC, Infoman, Changeman, COBOL Assembler, KORN, SPUFI, FTP

PROFESSIONAL EXPERIENCE:

Confidential

Programmer/Analyst

Responsibilities:

• Select Production data, per requested samples, DB2 libraries
• Convert the sensitive data to data that is not real person information
• Load the changed data to test libraries
• Ensure the right databases are all selected for a requested DB2 set
• Ensure the PPI data is all changed
• Ensure the production data is not loaded to the test systems
• Ensure that the changed DB2 data sets are all loaded

Confidential

Programmer/Analyst

Responsibilities:

• Local Supervisor programmer
• Convert programs of the Cost subsystem from PACBASE to PL/SQL
• Work to assist non PACBASE programmers to understand the conversion base
• Cause education of the development environment VPD schema for the developers

Environment: Citrix, ABL, PC workstations, target system UNIX and servers, UNIX PACBASE, Oracle SQL, PL/SQL and TOAD on ABL

Confidential

Programmer/Analyst

Responsibilities:

• Maintain the Referring Physician data system screens and modules for changes and features added to the system.
• Update the government data to the system on a monthly basis. The RPD system has CICS bridging to ASF letters and its own screen system TIS/AFT 35 years old written in assembler and the database is DB2 tables.

Environment: IBM - MF, MVS, Assembler, COBOL, DB2, CICS, Data Integrator, Crystal Reporting, File-Manager AMS,, FTP, SORT, IBM PC/Compatibles

Confidential

Programmer/Analyst

Responsibilities:

• Update PACBASE screens and modules for changes and features added to insurance and annuities in the claims system.
• Use ManageNow and Changeman for implementation control. The claims system was CICS and DB2.

Environment: IBM-MF, MVS, PACBASE, COBOL, DB2, CICS, File-Aid, AMS, Xpediter, FTP, SORT, IBM PC/Compatibles

Confidential

Senior Programmer/Analyst

Responsibilities:

• Designed and built PACBASE Screens and program modules for a special license plates order system, new reserve plate assignments, and vehicle registration EPA transactions.
• Migrated the system to a relational database.
• Created the screens and programs detail design using SQL.
• Local Supervisor programmer
• Convert programs of the Cost subsystem from PACBASE generated COBOL to PL/SQL
• Work to assist non PACBASE experienced programmers to understand the conversion base of PACBASE generated COBOL.
• Cause education of the development environment VPD schema for the developers
• Manage the Migrations in Libraries

Environment: Citrix, ABL, PC workstations, target system UNIX and servers, UNIX PACBASE generated COBOL, Oracle SQL, PL/SQL and TOAD on ABL

Confidential

Services Designer

Responsibilities:

• Created the high level design and supported peers through low level design.
• Built a template to ensure the consistency of all future subprograms.
• Designed the detail and test cases for three applications that were part of a single financial picture of client strategies on a daily basis.

Environment: IBM-MF, MVS,, COBOL, DB2, IBM PC/Compatibles

Confidential

Senior Programmer/Analyst

Responsibilities:

• Designed and built COBOL, SAS, and PACBASE modules for agent performance reporting and commission reversals for corporate work site operations in a DB2 system.
• Integrated sources into three test systems.
• Performed program maintenance in between projects.

Environment: IBM-MF, MVS, PACBASE, COBOL, DB2,CICS, SPUFI, File-Aid, SAS, AMS, Xpediter, FTP, NDM, SORT, IBM PC/Compatibles

Confidential

Senior Programmer/Analyst

Responsibilities:

• Developed, designed, and built SBS PACBASE expansions of account balance and transactional amount fields in 31 IMS DB/DC environments.
• Used PACBASE Access Facility to find the particular elements, screens, and programs within the checking system that changed under the field expansions.
• Created PC Excel spreadsheets and Microsoft Word documents with data extracted from the Mainframe PACBASE repository.
• Used PACBASE selection tools and utilities to create detailed documentation of all PACBASE programs used by offshore development teams.
• Created an Access hierarchical association file of assembler macros to show activation of PACBASE/COBOL programs within the legacy system.

Environment: IBM-MF, IMS SBS Online, MVS, PACBASE, COBOL, Assembler, File-Aid, SORT, AMS, Xpediter, FTP, Easytrieve, Changeman, SORT, IBM PC/Compatibles

Confidential

Senior Programmer/Analyst

Responsibilities:

• Developed, designed, and built many interfaces from the Tandem platform to the MVS platform.
• Selected the data from Tandem and uploaded it with NDM and FTP.
• Added client information with the selection of DB2 and IMS from the legacy databases in PACBASE.
• Stored external fund company and commissions data in DB2 databases.
• Involved in the on-going maintenance and enhancement of money movement, quarterly statements, monthly reporting, and daily activity applications, which were developed in PACBASE and IMS.
• Created an Access dataset to logically track data flows and changes that were made to grouped interfaces and individual printouts.

Environment: s: IBM-MF, Tandem midrange, UNIX, IBM PC/Compatibles, MVS, COBOL QMF, SPUFI, QMF, DB2, PACBASE, FILE-AID, SORT, AMS, XPEDITER, NDM, FTP, SAS

Confidential

Senior Programmer/Analyst

Responsibilities:

• Developed, designed, and built PACBASE features in the accounting systems and converted the European business to Lynx on a UNIX base.
• Worked with systems that communicated with five European languages within the reports and screens for the European business before systems were converted to Lynx.

Environment: IBM-MF, MVS, COBOL, PACBASE, DB2, QMF, DB2, File-Aid, SPUF1, SORT, AMS, Xpediter, NDM, IBM PC/Compatibles

Confidential

Senior Programmer/Analyst

Responsibilities:

• defined, designed, developed, tested, and trained users on a four hierarchical level Quattro Pro workbook that summed multiple types of office information into a centralized annual work plan.

Environment: IBM PC/Compatibles, Windows 95, Quattro Pro

Confidential

Senior Programmer/Analyst

Responsibilities:

• Rewrote a daily billing program from Assembler into PACBASE.
• Wrote date routines in Assembler and searched PACBASE libraries for programs not Y2K compliant with the PACBASE Access Facility.
• Designed a business-trend marketing evaluation reporting scheme using data warehousing, and implemented it with SAS, File-AID, and SORT.
• Designed and implemented an IRA application in PACBASE, SORT, File-AID, and SAS.

Environment: IBM-MF, MVS, COBOL Assembler, COBOL, II, SAS, CICS, VSAM, AMS, IMS, DB2, PACBASE, SORT, Expeditor, File-Aid, JCL

Confidential

Senior Programmer/Analyst

Responsibilities:

• Updated an offshore receiving system to operate with DB2.
• Implemented a BookMaster from IBM on the PC.

Environment: IBM-MF, MVS, COBOL, DB2, JCL, IBM PC Compatibles

Confidential

Programmer/Analyst

Responsibilities:

• Maintained and enhanced telephone-rating programs in Assembler and COBOL.
• Created an online instruction manual using Microsofts Quick Help compiler.
• Wrote other programs using C++ and MFC.
• Worked in administrative and operative maintenance of the proprietary laboratory programmer internal programmer libraries and controls.
• Maintained the code for a rating system and generated an instruction manual.
• Served as project manager of the system test for the library system.
• Supervised four to eight computer science students in testing the RS/6000.
• Oversaw the migration of the VM local library system to the RS/6000 library system, using MKS-RCS-SCCS for the beginning migration.
• Served as project leader for local VM library system, maintaining four releases with four versions, four levels, and one backup (sand box, share, functional, released, and master-1).
• Coordinated the project for implementation of Alpha XA-VM (VM Extended Architecture) under the VM library system.
• Wrote specifications for changing COPICS for customer specifics.
• Implemented a corporate basic records system to support Rochester IBM.
• Wrote the specifications to change IBM DPRS to suite Rochester IBMs requirements.