SUMMARY

• More than 22 years programming and application development experience.

TECHNICAL SKILLS

Proficient in: COBOL, CICS, COBOL II, IDMS/ADSO, BASIC, RPG II & III, MVS/JCL (& PROC’s), Easytreive Plus 6.2, DB2, QMF, IDEAL, VMS, MAPC, Data Junction, XML.

Familiar with: TSO/ISPF, Xpediter, Endevor, CA7, Fileaid, Oracle SQL Developer, SoapUI, Ultra - Edit 32, CA Panvalet.

Database: Microsoft SQL Server, Datacom DB, Oracle 11g & 10g, RDBMS, ADABAS and Microsoft Access

Platforms: IBM Mainframe 3370 & 3390, PDP 11/44, VAX 11-750, AS/400, Microsoft Windows® 98, Microsoft Windows XP, Microsoft NT, Isolutions.

PROFESSIONAL EXPERIENCE

Sr. Programmer Analyst

Confidential, NY

Responsibilities:

• Created extract programs (COBOL) to load data into PeopleSoft.
• Created QMF queries to validate program totals (reconciliation totals).
• Validation of recon-totals from extract file loads.
• Preformed code modification per load report errors.
• Performed data mapping for extract files.
• Perform analysis from load error reports to modify extract programs.

Sr. Programmer Analyst

Confidential, Schenectady, NY

Responsibilities:

• Validating code changes and test all parts before install.
• CICS program modifications, adding fields to the screens.
• Responsible for of all modifications to the label and scanning systems
• Validating code changes and test all parts before install.
• All systems the source code was Easytrieve.
• Validated data for online program using DB2 SQL queries.

Programmer Analyst

Confidential, Glenmont, NY

Responsibilities:

• Migration project, validating code changes and test all parts before install.
• Validating software changes (Isolutions).
• Enhancements to CICS programs along with BMS maps.
• Performing parallel testing to validate changes.
• Creating test plans, documentation of process flow.
• On call rotation.

Programmer Analyst SR

Confidential, Bentonville, AR

Responsibilities:

• Lead resource for New Mobility Tablet project: reviewed all code before install.
• Designed a load and unload process for Teradata (which includes creation of the tables).
• Developed file layouts, Cobol program and formatted the file for several processes (Journal Sweeping, Daily Balance Recon, CICS Web Services).
• Designed the program specifications for Cash Rewards project.
• Designed a CICS Web Service program for missing purchases for club members (Used WSDL’s).
• Design process for FTP data from Mainframe to Cassandra (repository for data - tables).
• Performed maintenance patches on the Autorenew process.
• Designed a CICS Web Service to update, remove or add membership information (Used WSDL’s).
• Created the documentation for turning jobs over to the support team.
• On call rotation.

Programmer Analyst

Confidential, Schenectady, NY

Responsibilities:

• Documentation of the PPR & PPA system.
• Data conversion.
• Created Java specifications from PowerBuilder Code.
• Created Java specifications from COBOL programs.
• Analyzing the COBOL/CICS code and all DB2 functions.
• Data Mapping documents for PPR & PPA system.

Programmer Analyst

Confidential, Albany, NY

Responsibilities:

• Developed online and batch test plans.
• Data conversion.
• Resync project when multiple enhancements for the same program, but have different implementation dates.
• Modified PA Paper process - copybooks, database tables, programs, and VSAM file, per new lines on the PA Paper form.
• Developed queries and updated the database using SQL.
• Provided technical support between teams when programmers would work on projects for other teams.
• Modified and tested Data Junction enhancements (interface that translates the transaction).
• Programming and implementation support to the Health Care System, written in COBOL and DB2.
• Designed a file for HL7 request for Patient Medical History information (90 days worth of data), XML file format.
• Modified and tested the Paper Form Process using COBOL and DB2.
• Performed system enhancements and maintain existing programs.
• Developed and maintained programs using COBOL/COBOLII, CICS, Easytreive Plus 6.2 and DB2.
• VSAM file processing
• Used INTERTEST debugging tool for the CICS programs.
• On call rotation.

Programmer Analyst

Confidential, Springfield, MA

Responsibilities:

• Developed and tested the new process to determine the top ten Brokerage Directors, using Easytreive.
• Developed queries and updated the database using SQL & QMF.
• Modified the MEC System when a policy change happens (PC01, PC03, PC06 or 708 transactions) within 90 days of issue, using COBOL and DB2.
• Modified the COA Letter (removing specific sentences) process, using COBOL and DB2.
• Prepared test plans and data for the Quota Buster system.
• Developed the requirements and documentation for a Schedule A Project, adding comp type to the PSS text file, which was uploaded to the client’s database. Designed the FTP process to accomplish this task.
• Modified the file extraction process for writing agent’s W-2 error with the state information on the extract tax form.
• Developed a process to prevent FTP’d files from getting overlaid when the client did not rename the files before the next time the file was created.
• Researched the retired contract agents not paying persistency fees. Found out that retired agents over 10 years are still generating policies and need to be paid premiums for those policies.
• Modified the FTP process to prevent files from getting overlaid when a client submits a new file.
• Modified the process to consolidate DASD space, reallocated space from cylinders, changed the way of archiving of files.
• Prepared documentation for all systems.
• Developed and maintained online transaction programs.
• Developed and maintained programs using COBOL/COBOLII, CICS and DB2.
• VSAM file processing.
• Used INTERTEST debugging tool for the CICS programs.