SUMMARY:

• 28 years extensive experience as an application programmer/analyst with the banking, insurance, brokerage, healthcare, energy and retail industries.
• Responsibilities include analyzing, designing, developing, testing, enhancing, maintaining and implementing programs for various financial, healthcare and government applications
• Worked in all or parts of the System Development Life Cycle (SDLC) for the following application domains:

TECHNICAL SKILLS:

• IBM mainframe z/OS series, z/VSE series, 390 series, PC AND COMPATIBLES z/OS, MVS/ESA, DOS/VSE, VM/CMS, MS - DOS, WINDOWS 10, UNIX, LINUX
• COBOL II, CICS, JCL, CSP, C++, C, JAVA, JAVASCRIPT, VISUAL BASICASSEMBLER, SQL, XHTML, REXX, CLIST, FOCUS, XML, R Language, PythonMicro Focus COBOL, EASYTRIEVE+, MQ-SERIES, NDM, FTP, Cyberfusion
• DB2 RELATIONAL DATABASE, DB2 stored procedures and triggers, SPUFI, DB2 QMF, DB2, IMS, DL/1, ACCESS, VSAM, ORACLE 11g, PL/SQL, Data Warehousing, DATACOM, Dataquery, MySQL, XML, JSON
• Confidential Web sphere MQ series explorer
• LOAD AND UNLOAD, EXPLAIN & OTHER UTILITES, PLATINUM, INSYCH
• TOAD, SQL DEVELOPER, ETL (Extract, Transform and Load)
• TEST, EXPEDITER, ABENDAID, COMPAREX, DUMPMASTER
• 11 RMS, ENDEVOR, SDSF
• PANVALET,ISPF, FILEAID, FILEAID DB2, FILEAID RDX, File Manager DB2, TSO, IDCAMS
• SDF II, MAPAID
• Common Services
• SYNCSORT, IEBGENER, IEBCOPY, IEBDG
• MS WORD, EXCEL, POWERPOINT, SHAREPOINT, COMMUNICATOR
• Confidential LOTUS NOTES, SAMETIME
• EDI Healthcare Transactions

WORK EXPERIENCE:

Confidential, Lake Mary, FL

Sr. Programmer/Analyst-Developer

Responsibilities:

• New code development is thus kept to a minimum and in most cases limited to writing new input and output interfaces between the kernels of each system and the integrated Prime environment.
• Part of the team responsible for the functional and technical analysis and requirements gathering in connection with the modernized migration of Confidential licensees’ Inter-plan Teleprocessing Systems (ITS) to one architectural platform.
• ITS enables members enrolled in one Confidential health plan to avail of services in another Confidential health plan that may be located in another state.

Technology used: Enterprise COBOL, Micro Focus COBOL, CICS, Web Sphere MQ-series, IMS, DB2, JCL, VSAM, Endeavor, Changeman, FTP, NDM, Confidential Utilities, File Manager, Control-M, CA-7

Confidential

Sr. Programmer/Analyst-Developer, Spring Valley, NY

Responsibilities:

• Part of the team that developed the AMI interface between Orange and Rockland Utilities’ Customer Information Management System ( Confidential ) and Confidential ’s Meter Management System (MAMS). Developed programs written in COBOL/DB2/Web sphere MQ to pass Confidential AMI real time and batch meter requests to MAMS.
• AMI meter requests include install, remove, exchange and inquire. AMI meter transactions are sent and received by Confidential via MQ series/BizTalk middleware objects.
• Coordinated with both the DB2 and MQ database administrators to ensure that tables, M -queues and other related objects were correctly defined to the specifications set by technical and business requirements.
• Performed unit, system and integration testing of the AMI interface between Confidential and Confidential ’s MAM System. Ensured that all Confidential AMI-related data stores are in-synch with the corresponding data stores in the MAMS system. Also made sure that all information needed by MAMS from Confidential and vice versa were sent/received the format expected by both systems.
• Developed, maintained, unit tested several Customer Information System ( Confidential ) billing programs such as COBOL/DB2 programs that control billing inserts that determines what inserts to include in a customer’s bill.
• Developed, maintained and unit tested several New Construction (NUC) COBOL/DB2 programs that handle contact information for construction project stakeholders such contractors, suppliers and vendors for completed and active construction projects.

Technology used: Enterprise COBOL, CICS, Web Sphere MQ-series, DB2, BizTalk, JCL, VSAM, Endeavor, FTP, Confidential Utilities, File Manager for DB2

Confidential

Sr. Programmer/Analyst

Confidential, Little Rock, AR

Responsibilities:

• Part of the team that provided technical support to the Arkansas Medicaid Management Information System.
• Monitored and ensured proper completion of production jobs that verify eligibility of beneficiaries, adjudicate and reimburse Medicaid claims from health care providers and produce regulatory reports required by the Confidential .
• Maintained Medicaid Management Information System subsystems such Eligibility, Provider, and Claims Processing Subsystem to comply with business and technical requirements set by state and federal agencies.

Technology used: Enterprise COBOL, CICS, JCL, VSAM, Endeavor, FTP

Sr. Programmer/Analyst-Developer

Confidential, Baltimore, MD

Responsibilities:

• Monitored and provided technical support to mainframe jobs/procedures that select test cases from production databases, sanitize Personally Identifiable Information (such as Social Security Numbers, Recipient Names, Address, etc.), clone existing data, and delete unwanted or obsolete data and other VOB functions.
• As part of the project to identify and eliminate un-indexed (un-registered) VOB Social Security numbers (SSNs), investigated and analyzed all 59 VOB databases and data stores to identify un-indexed SSNs. All production SSNs that were selected for testing by VOB must first be sanitized and registered. Rogue SSNs cannot be part of the validation databases and data stores and need to be either registered or deleted. Used procedural SQL scripts and compare utilities to identify these un-indexed SSNs.
• Decommissioned the obsolete Ticket System Validation Database and ZDSEL processing by identifying all jobs, procedures, ISPF skeletons, tables, and panels, parameter files. Revised ISPF Dialog Manager Code and REXX programs to eliminate processing of the Ticket System.

Technology used: REXX, CLIST, ISPF Dialog Manager, COBOL II, Micro Focus Cobol, JCL, VSAM, Endevor, File-Aid DB2 and RDX, DB2, SQL, Confidential Utilities, Syncsort

Sr. Programmer/Analyst

Confidential, West Sacramento, CA

Responsibilities:

• Part of the team that incorporated the ACA (Affordable Care Act) changes to reports that provided distribution and break-down of federal and state funding information for the myriad of services provided by the of Confidential Medi-Cal (Medicaid) program. These reports allocated funds per service (in-patient medical, optometry, hospice, etc.) to the different service programs (coded by Recipient Aid codes) available to eligible Medi-Cal beneficiaries.
• Part of the team that was involved in the design, development, testing and implementation of some the new Diagnosis Related Group (DRG) pricing methodology requirements to the CAMMIS system. Changes to the system included a provision to allow retroactive change to provider rates for past effective date ranges. DRG is a pricing methodology that provides for a more accurate and efficient pricing assessment of the different Medi-Cal services based on standard pricing for a similar diagnosis set for that geographical location.
• Part of the team that was involved in the design, development and testing of the project to expand Provider Type/Categories of Service as well as Procedure Codes/Categories of Service Tables of the CAMMIS system. Categories of service for these tables had a maximum of 22 services only. Since provider types and procedure codes now have more than 22 categories of service (COS) associated with them, expansion of these tables to allow up to a maximum of 2,178 COS per provider type or procedure code was done. All programs in the system were changed to reflect this new requirement.

Technology used: COBOL II, CICS, JCL, VSAM, Endevor, Expediter

Sr. Programmer/Analyst

Confidential, Cheshire, CT

Responsibilities:

• Participated in infrastructure maintenance of Confidential ’s Cheshire marketing systems.
• Renamed, decommissioned and assigned new naming standards to the different elements of the system (such as programs, procedures, JCLS, maps, FTP parameters, etc.) to comply with company-wide naming standards.
• Wrote test scripts and conducted unit, system and regression testing for all programs and JCLs that were changed.
• Was part of the 2013 MIPS and DASD Reduction Project for the company’s Receiving, Release, Liquidation, Product Definition and Shipping Systems. Decommissioned DATACOM tables and several COBOL and CICS programs from these systems.
• Wrote test scripts and conducted unit, system and regression testing for all programs and JCLs that were changed.

Technology used: COBOL II, CICS, JCL, VSAM (Host Side), Endevor, FTP, DATACOM, IDEAL

Sr. Programmer/Analyst

Confidential, Pittsburg, PA

Responsibilities:

• Developed and maintained the mainframe programs for the company’s Wholesale Banking Data Warehouse (WBDW) application.
• Interacted with business analysts, business users and fellow developers to determine ever-changing business requirements for WBDW.
• Performed data analysis and participated in the design and data warehouse modifications as required by the business
• Wrote technical design specifications in connection with WBDW mainframe application changes
• Made sure source files from various mainframe applications were accurately extracted, transformed, transferred (using the NDM facility) across platforms and loaded to UNIX servers.
• Analyzed WBDW database structure to better understand data warehouse dimensional design and relationships
• Analyzed WBDW PL/SQL Stored Procedures to understand the various methods by which the data warehouse stores historical information (such as Type I and Type II slowly changing fields and fast changing fields such as fact fields).
• Provided technical support and participated with the WBDW team, across various platforms, in analyzing, finding the root cause and resolving production problems.

Technology used: Oracle, COBOL II, CICS, DB2, JCL, VSAM (Host Side), Endeavor, NDM, FTP