SUMMARY:

• Accomplished Senior Programmer Analyst with 29+ years of experience in Mainframes and Client Service Products in the Health Insurance, Mortgage, Banking, Credit Cards, Civil/Criminal, Student Loans, Government and Transportation industries
• Worked on multiple conversions from Mainframes to SAP(DB2, IDMS, IMS DB/DC and VSAM)
• Worked on multiple Front End/Backend Systems
• Worked with CICS Transaction Server to process backend messages from Frontend applications
• Created and modified multiple SAS Reports that utilized the modified Data Warehouse
• Converted Data Warehouse DB2 Tables and SQL Tables in order to convert all the reports maintained by SAS
• Worked on Data Analysis, Data Profiling and Master data management for Private and Public Companies
• Worked on Multiple databases in Mainframe and Client Server (SQL Server, DB2, IMS, VSAM, ISAM)

TECHNICAL SKILLS:

Languages: Cobol, Microfocus COBOL, Easytrieve, Easytrieve Plus, JCL, SQL, RPG, SAS, Quick Jobs, Stored Procedures, Fortran, PASCAL, BASIC, Assembler, PL1

Operating Systems: Z/OS, MVS ESA/XA, OS390 MVS, DOS, System 36/38, Unix, AS400

OLTP: CICS, TSO, Roscoe, Telon, BMS Map Screen Generator, BMS Mapping, Microfocus CICS, Visual Basic, PowerBuilder

Version Control Tools: Changeman, Endevor, Panvalet, Librarian

Databases: DB2, Data Warehouse, SQL Server 2005/2008, ISAM, VSAM, QSAM, IDMS, IMS DB/DC, Microsoft Access

Tools: and Utilities: MQ Series, BIZTALK, SPUFI, QMF, Platinum DB2, Confidential Data Studio, SQL Server, PostgreSql, PG Admin III, Microsoft Access, Eclipse Juno, Erwin Data Modeler, RAPID SQL, SyncSort, IEFBR14, IEBCOPY, IEBGENER, IDCAMS, Confidential Utilities, CA7, CA1, XML, Eclipse Juno, FileAid and FielAid for DB2, FileMaster, Smartest, Intertest, Xpediter, FTP, JODBC, ETL(Extract, Transformation and Load), Client Server Tools and other miscellaneous mainframe tools.

WORK EXPERIENCE:

Confidential, Baltimore, MD

Senior Programmer/Data Analyst

Responsibilities:

• Cloud Services
• VersionOne Agile Scrum Framework
• Master Data Management (MDM) Analysis
• Microsoft Access Database Creation
• Analysis of the CIS/CRS, Child Support Enforcement System, CARES and CHESSIE Systems for State of Maryland
• Project Management
• Data Modeling
• Data Profiling using Confidential Data Studio and PostgreSQL/PG Admin III
• Data Analysis
• Data Retrieval using Confidential Data Studio and PostgreSQL/PG Admin III
• National Information Exchange Model (NIEM)
• Mainframe using TSO

Technical Environment: TSO, CA - Librarian, Microsoft Access, VISIO, PowerPoint, Word, Excel, Confidential Data Studio 4.1.2, SQL, PostgreSQL/PG Admin III, CISCO WebEx Meeting Center, VersionOne Agile Scrum and Erwin Data Modeler.

Confidential, Tampa, FL

Senior Programmer Analyst

Responsibilities:

• Creating and Supporting SQL Stored Procedures in a Mainframe Environment
• Using Confidential Data Studio and Eclipse to execute Stored Procedures and SQL Queries against their different databases.
• Assist or train other employees in using different Database Tools
• Migration/Conversion Activities
• Architectural Tasks for changing system processing flow
• Building Stored Procedures that are executed by Web Service Calls or COBOL Modules and return Cursor Data back to the calling service for display to the Customer and ore End-User.
• Batch Optimization work on speeding up batch processing
• IMS DB/DC and DB2 Production Support Issues for Tickets opened in SBM
• AIMS Responsibilities for Monthly Production Releases

Technical Environment: Z/OS, Changeman, Confidential Utilities, Quality Center 11.0, Serena Business Manager, Easytrieve Plus, Insync, TSO, Confidential Data Studio 4.1, Eclipse Juno, Web SQL Tool, Native SQL Stored Procedures, Cobol, File Aid, QMF, SPUFI, SQL, Xpediter, and DB2 with associated utilities on the mainframe/Client Server.

Confidential, Raleigh, NC

Senior Programmer Analyst

Responsibilities:

• Read MQ Queues that triggered via CKTI a CICS transaction
• Processed the input queue that contained XML Messages and updated the database files(DB2 and IMS DB/DC), and then returned XML reply messages to an output queue for customer information; This system updated database fields based on a user updating data via an Internet link

Technical Environment: Z/OS JCL, Proc, D2, Confidential Utilities, MQ Series and associated utilities, MQ and MQ Trigger Processing(CKTI), MQ Explorer, Easytrieve, Cobol, CICS,CICS Transaction Server(CTG), CICS Web gateway, FileAid, QMF, SPUFI, SQL, Smartest, Intertest, FTP, VSAM, DB2 and IMS DB/DC with associated utilities on the mainframe

Confidential, Washington, DC

Programmer Analyst

Responsibilities:

• Disconnected, connected and read automated meters (AMI) and final billing for the Confidential customers using COBOL, CICS using BMS GN Screen Painters, Telon and Assembler, MVS OS Z/OS JCL, DB2, SQL, QMF, SPUFI, Trace Master, Expediter, ZEKE, Librarian, TSO, Roscoe, MQ Series and Stored Procedures (Mainframe, and SQL Server)
• Worked on Customer/1 (CIS) Applications in Meter Billing and Meter Cash Systems
• Worked on Production updates and SAP conversion from the mainframe which consisted of sending data from the mainframe to the Client server for purposes of converting to SAP
• Created code to convert data and create adhoc reports that assisted in the conversions processes
• Conversion of Mainframe Data to SAP Data

Technical Environment: RAC, UNIX, SQL Server, SQL Software, Infoshpere Datastage, Metadata Management, SQL Command Center, DB2 Connect, Crystal Reports 2008 & 11, Customer/1, Confidential Data Studio IDE, MQ Visual Brower, F MVS OS Z/OS JCL, Proc, MQ Series, M$ Explorer, Easytrieve, Cobol, CICS, Telon, GN Screen Painters, BMS Maps, Assembler, Stored Procedures, QMF, SPUFI, SQL, ZEKE, SAR, Trace Master, FTP, DB2 on mainframe

Confidential, McLean, VA

Programmer Lead Analyst

Responsibilities:

• Created and modified multiple SAS Reports that utilized the modified Data Warehouse
• Used ETL to Transform extract and Load data for comparative analysis of Data Warehouse for Mortgage Loans that were purchased by FHLMC.

Technical Environment: SAS V9.2 and V9.3m Rapid SQL (Client Server), Infosphere Datastage, Metadata Management, Easytrieve, Cobol, JCL, Procs, Stored Procedures (Client Server), Compare tables in CDW - Corporate Data Warehouse (Legacy vs. Integrated), FileAid, Lotus Notes, DB2, IMS, IDMS, SAS V9.2 and V9.3, Rapid SQL (Client Server)

Confidential, Atlanta, GA

Programmer Lead Analyst

Responsibilities:

• Took documents and metadata(Data Warehouse) from Trans Union and stored in mainframe Image Plus Imaging DB2 and IMS DB/DC Systems using COBOL, CICS using BMS GN Screen Painters and Telon and Assembler, JCL, IMS DB/DC, DB2, SQL, MQ Series, FileNet, Java, Confidential Debugger, TSO, and Endeavor

Technical Environment: MVS OS Z/OS JCL, Proc, MQ Series, Cobol, CICS, Stored Procedures, Easytrieve, QMF, SPUFI, SQL, Endeavor, IWPM, ImagePlus Infosphere Datastage, Metadata Management, DB2 and IMS DB/DC on mainframe, SQL Server, SQL Software, IWPM, RACF, FileNet. ECC

Confidential, Washington, DC

Programmer Analyst

Responsibilities:

• Disconnected, connected, and read automated meters (AMI) and final billing the Confidential customers using COBOL, CICS using BMS GN Screen Painters, Telon, Assembler, JCL, DB2, SQL, QMF, SPUFI, Trace Master, Expediter, ZEKE, Librarian, TSO, Roscoe, MQ Series and Stored Procedures (Mainframe, and SQL Server)
• Completed major conversion from Non-Automated Meters to Automated (over-the-air) meters
• Worked on Customer/1 (CIS) Applications in Meter Billing and Meter Cash Systems
• Sent the request to UIQ via XML data to disconnect/connect/read the meters and then accepted the response back from UIQ via a stored procedure
• Sent error data from UIQ to a Navigator Queue (XML Data) using FTP Job for research by the analyst
• Conversion of Mainframe Data to SAP Data(IDMS and DB2 Data)

Technical Environment: MVS OS Z/OS JCL, Proc, MQ Series, Cobol, CICS, CICS using BMS GN Screen Painters, CICS Transaction Server(CTG), CICS Web Gateway, Telon, Easytrieve, Assembler, Stored Procedures, QMF, SPUFI, SQL, ZEKE, SAR, RACF, Trace Master, FTP, RACF, DB2 on mainframe, Microsoft SQL Server, SQL Software, SQL Command Center, Crystal Reports 2008 & 11, Customer/1, Infosphere, Infosphere Datastage, Metadata Management, Confidential Data Studio IDE, MQ Visual Browser, Stored Procedures

Confidential, Reston, VA

Programmer Analyst

Responsibilities:

• Researched Banking systems on mainframe and Client server to enhance system
• Created a system document that defined the system
• Modified and tested code for implementation on both mainframe and client server using debugging tools Strobe, Smartest, Intertest.

Technical Environment: MVS OS Z/OS JCL, Cobol, Confidential and Hogan Mainframes, CICS using BMS GN Screen Painters, CICS Transaction Server(CTG), CICS Web gateway, Telon, Easytrieve, Assembler, Stored Procedures, QMF, SPUFI, CA7, DB2, IMS DB/DC on mainframe, SQL Server, ODBC Software, Stored Procedures

Confidential, Washington, DC

FQA Senior Systems Analyst

Responsibilities:

• Researched Amtrak Systems on Mainframe to redevelop system in SAP
• Worked with Booz Allen to create a system document that defined Amtrak’s System for purposes of converting to SAP System.

Technical Environment: MVS OS Z/OS JCL, Cobol, Easytrieve, CICS, CICS Transaction Server(CTG), CICS Web gateway, Telon, Screen Painter, BMS, Stored Procedures UMS DB/DC and DB2 on mainframe

Confidential, Herndon, VA

Programmer Analyst (Subcontractor)

Responsibilities:

• Developed new billing application in .Net, Visual Basic and SQL Server
• Built and implemented an application that could extract data from the AS400 and convert data using .Net for storage in a SQL Server Database.
• Used tools to pull data from their accounting Data Warehouse

Technical Environment: MVS OS Z/OS JCL, Unix, AS400, RPG, Cobol, Easytrieve, JCL, SQL Server

Confidential, Washington, DC

Programmer Analyst (Subcontractor)

Responsibilities:

• Completed major conversion from the EDA Copy Manager to the SQL Server database which consisted of downloading mainframe data via XCOM and/or FTP down to a temporary work table in the SQL Server Database
• Used SQL, Data Transformation Services, and Stored Procedures to manipulate the data and write to final destination table for view by users in the software package BRIO
• Provided daily 24-hour on-call support for production support related issues, and corrected any problems related to production support for SQL Server and Mainframe applications
• Created and modified Human Resource and Payroll Software, and built a SAP/LMS Interface to keep dual systems in sync.
• Project Lead in the conversion of the Mainframe to the SAP System for payroll.

Confidential, Reston, VA

Programmer Analyst

Responsibilities:

• Coded new software and enhancements of current systems for billing and student loan applications
• Designed, analyzed, tested, performed quality assurance, implemented, and provided post production support.
• Utilized a frontend/backend system to create new student loan records. Web was used to retrieve customer data; whereas, the backend system maintained all the databases.
• Maintained Billing system for Student Loan Accounts