TECHNICAL SKILLS

Languages: COBOL, CA GEN, JCL, SQL, CICS, EASYTRIEVE, SYNC SORT

Platforms: TSO/MVS, UNIX, Confidential /Tandem NSK

Databases: DB2, ORACLE

Software: Win SQL, GUARDIEN, CSE Access, Access Gen, SharePoint, QMF, MS Office, ENDEVOR, Microsoft Teams, Visio, Service Now, Oracle SQL Developer

PROFESSIONAL EXPERIENCE

Confidential

Technology Lead

Responsibilities:

• Conducted Knowledge Transfer in the areas of Finance and Product Distribution. Service Now to track and fix production problems. Provided IT Support for Warehousing, Inventory, Accounts Receivable and Tax Reporting. Project manager: Lavanyasree Somaraju.
• Conducted an analysis of the many mainframe jobs to be decommissioned for the shutdown of the Buena Park Warehouse. Analyzed job schedules, programs and JCL to assure a smooth shutdown. Project manager: Venkatakrishnan Rajagopalan.
• Participated in the aggressive hiring campaign for the newly acquired Confidential Maintenance contract. Conducted technical interviews to select appropriate candidates. Worked with Sukhwinder Bhullar.

Confidential

Senior Programmer Analyst

Responsibilities:

• Enhance the Payment Manager and Billing Systems for all types of Insurance policies (Life, Auto, Mortgage, Umbrella, etc.) using CA Gen r8.5 and DB2.
• Design and write new COBOL/DB2 interface programs to handle returned bank items. Skills employed: CA Gen 8.5, DB2, CICS, Win SQL, “Move for DB2 (OPTIM)”, ENDEVOR, CE - Access.

Confidential

Senior Programmer Analyst

Responsibilities:

• My job was to provide analysis and development of an interface to the International Design Patent Application System used by the rest of the world. Developed specifications for an interface that could also be used by the Java team that was working to replace the PALM system. I modified the Pre-Exam system to validate and process the interface file.
• I have detailed experience working at PTO in 2014 with the Patent Pre-Exam system that does the preliminary validation of patent applications. It is written using CA Gen 6.5 and uses Oracle 9 and UNIX. The tools used were SQL Developer, Putty, Access Gen and Win-SCP.

Confidential

Senior Programmer Analyst

Responsibilities:

• Migrated the Merchant Application Oracle database to a new database structure.
• Skills employed: CA Gen 8.0, Oracle 11g, UNIX, Oracle SQL Developer, Putty, and Win-SCP.
• Responsible for converting 21 tables to the structure needed by the new Merchant system. Applications and were tested in UNIX using Diagram Trace Utility.

Confidential

Senior Programmer Analyst

Responsibilities:

• Duties included maintenance in the Membership and Claims areas. Skills employed: CA Gen 8.0, GUARDIEN, Report Composer, DB2, Oracle, Windows NT, UNIX, and TSO. Ed was responsible for supporting patches to METAVANCE Base Release 2.10. Applications were tested in the Windows NT using CMD files, in MVS using JCL and UNIX using UNIX scripts.

Confidential

Senior Programmer Analyst

Responsibilities:

• The project was to migrate existing applications from Gen 7.6 to Gen 8.0 and then to develop a new Third Party Insurance billing system. Skills employed: All Fusion Gen 8.0, GUARDIEN, Tandem NSK, SQL, and Report Composer 8.0. All three phases of the project were implemented successfully. Other assignments involved enhancements to the existing systems.

Confidential

Senior Programmer Analyst

Responsibilities:

• Duties include both new development and maintenance in the Locomotive Maintenance Control System.
• Skills employed: All Fusion Gen 7.6, GuardIEn, Oracle, UNIX, TSO and IMS with DB2.
• Ed is responsible for maintaining and developing batch and client/server procedures.
• He developed an XML interface file addition. Ed converted an older IMS/DC application in from DB2 version 7 to DB2 version 8.

Confidential

Senior Programmer Analyst

Responsibilities:

• Duties included both new development and maintenance in the Finance, Membership, and Billing areas.
• Skills employed: All Fusion Gen 7.5, GuardiEn, Report Composer, DB2, Oracle, Windows NT, UNIX, and TSO.
• Responsible for writing specifications as well as developing new action blocks and supporting previous releases.
• Applications were tested in the Windows NT using CMD files, in MVS using JCL and UNIX scripts.

Confidential

Senior Programmer Analyst

Responsibilities:

• Provided analysis, coding and testing of Cool Gen action blocks, developed reports using Report Composer with Crystal Reports in a Client/Server Windows environment with CSE using Oracle.
• Provided analysis, coding and testing of Cool Gen action blocks enabling Message Queue processing for the Supply Chain. Designed, coded and tested DB2 triggers for message queues.

Confidential

Project Leader

Responsibilities:

• Data archiving project as well as mentoring in Advantage Gen. Provided project leadership, data analysis, business area analysis, application design and long range planning.
• Major enhancements were made to the Operational Customer Data Base that supports the Core Computer Reservation System and Customer Loyalty System. Advantage Gen 6.5 Client Server GUI was used. SQL Server database.