SUMMARY:

Position as Programmer/Analyst where experience and training can be applied effectively, preferably in a business environment where there is opportunity for professional and personal growth.

TECHNICAL SKILLS:

Hardware: IBM 390 series

Operating system: Z/OS 390

Language: COBOL 2, MVS JCL, TSO/ISPF

File Access method: DB2 SQL, SPUFI, PLATINUM, QMF, VSAM, IDCAMS,SAM, GDG,FILEAID

Screen Access method: CICS, BMS

Change control: ENDEVOR, CHANGEMAN

Debugging: XPEDITOR

File transfer method: DB2 CONNECT, FTP, NDM

Job scheduler: CA - 7, ZEKE

Distributed platform: 2010 VS .Net C#, Microfocus COBOL, ACU-COBOL, MS office, Unix, VI text editor.

EXPERIENCES:

Confidential, Dallas, TX

Programmer/Analyst

Responsibilities:

• Created a stored procedure on the iSeries to allow MS SQL server to access to trigger a Cobol program to produce the Alternative Distribution report.
• Use embedded Cobol SQL to produce cancellation report, policy in force report and commission report for Confidential
• Automated the pre-written Notes addition procedure for multiple policies.
• In general gather, analyze, and create new modules and/or modify current in house software to enable the insurance business function.

Technical Environment: V7R1 OS/400, COBOL(subfile), CL, DB2/400, SQL(inner join, exception join, union, insert, delete, update, cursor)

Cobol Developer

Confidential, Atlanta, GA

Responsibilities:

• Create interface to the Spinnaker Confidential Tax which interfaces with Vertex Tax Package.
• Gather, analyze, and create new modules and/or modify current in house software to enable the business function for tax, accounting department.

Technical Environment: OS/400, COBOL, CL, DB2/400, SQL, RPGLE free format.

Confidential, Atlanta, GA

Programmer/Analyst

Responsibilities:

• Modify Confidential Transportation Car Hire Payable software to accommodate new client CSXT class 1 railroad.

Technical Environment: OS/400, COBOL, CL, DB2/400, SQL.

Confidential, FL

Programmer/Analyst

Responsibilities:

• Create a CICS VSAM program to allow inquiry and update to the Distribution check file.
• Automate AP entry from xcel doc using .NET C# and CICS VSAM.
• Develop an AP recovery feed which saved HMA substantial amount of money.
• Create an extract program to produce a file that show the A/P Distribution journal.
• Add three new fields to the employee screen for inquiry, add, change function. Add three new pop up windows for lookup (a) employee ss# by name, (b) position of the employee, and (c) department. Prior to the change, the user must leave the application to look for the ss# to key in the field.
• Set up Confidential deduction feed on biweekly cycle
• Green screen to Web services for Collaborative Care project: modify existing Cobol programs to accommodate IBM HATS Websphere overlay.
• Correct screen scrolling malfunction in many programs in the Collaborative Care module.
• Correct I/O fluid report in the Nurse module.
• Set up HL7 outbound interface PMEDADT.
• Correct Leap Year date routine.
• Create filter program for the HL7 interface. This program decides whether to allow Clinic patient information to be sent to destination.
• Maintain and modify Third Party Billing feed
• Supply Emergency Room daily admission and cause to Florida Department of Health for outbreak disease forecast

Technical Environment: IBM Z/VSE, BIMEDIT, ICCF, VSE JCL, VSAM. OS/400, COBOL, ILE COBOL, DB2/400, SQL, SEU, PARTLIST, SDA, QUERYVISUAL STUDIO 2010 .NET C#.

Confidential, Tampa, FL

Programmer/Analyst

Responsibilities:

• Develop new programs to convert XCEL docs hat contain LIFE, HIP, HAP, CI, CA, DEP, BENE, DENTAL, Confidential STD into flat files to be loaded into DB2.

Technical Environment: IBM OS/390, ISPF, TSO/ISPF, DB2, Endevor, Change Management, MVS, VSAM.

Confidential, Atlanta, GA

Programmer/Analyst 0

Responsibilities:

• Provide progamming service to Confidential for the conversion of the VSAM based Prescription Benefit Management to DB2 based.
• Completed SMAC price list extract process.
• Extract drug price list from drug table and ftp it to Confidential server which allows pharmacist to view it on the Internet
• Conversion of the Confidential vsam file.
• SR3956 - Confidential provider report
• Create a report showing all the transactions for all the provider.
• Add logic to parse Confidential claims and output them to a file for further processing.
• Test data were carried over to production from conversion.
• Create spufi to delete production rows in 4 tables with parent/child relationship.
• Create an interface file to MMIS. This involves capturing daily medical claims for Confidential, accumulate them for the week, process them into one file.
• This file is the driver for extracting prescription claims from the PBMS system using prescribed business logic.
• The interface file is formed, zipped, and ftp-ed to Confidential 's server to feed MMIS.
• Identify missing and inaccurate plan in production. Batch spufi to fix them by updating, inserting and deleting affected rows.

Technical Environment: IBM OS/390, TSO/ISPF, DB2, Endevor, MVS, VSAM, JCL, FTP, NDM, PLATINUM, SPUFI, FILEAID,COBOL,CA7, REXX, EZTRV,Z/OS PKZIP & PKUNZIP.

Confidential, GA

Programmer/Analyst

Responsibilities:

• Assisted co-workers with complex problems and developed workarounds.
• Enhanced the nightly production support to fix GL discrepancy from 2 hours labor to 30 minutes using SQL to modify the production data.
• Participated in designing and developing conversion programs during the application upgrade and transition from the AS400 paltform to the IBM Mainframe.
• Responsible for maintaining interfaces (GL, ACH and Compass) from the Trade finance Application used to market the Bank’s International Letters of Credit on an AS400 platform using COBOL, CLP, DBU, SQL and AS400/QUERY.
• Gathered requirements, wrote technical documentation and program specification to redesign our Commercial Loans (Compass) interface
• Worked closely with Business Analyst to define business needs
• Acted as a liason between clients and the technical group
• Developed enhancement to the Customer Relationship System (CRS) interface
• Provided support (answer questions, trouble shoot and provide resolution) to clients on a daily basis using COBOL, CLP, AS400/Query utility and SQL
• Performed off hours support
• Performed operational duties like backups (system and library), Save and Restore data to and from disk.
• Performed file reorganization on a weekly schedule using a CL program.
• Wrote the installation program to automate the conversion process.
• Wrote many balancing programs to assist in verifying GL accounts before and after conversion using SQL DB2/400 and COBOL.

Technical Environment: OS/400, IBM 640, COBOL DBU, DB2/400, SQL, SEUIBM OS/390, ISPF, TSO/ISPF, DB2, Endevor, Change Management, MVS, VSAM, JCL, FTP, NDM, PLATINUM, SPUFI, FILEAID,COBOL,CA7.