• Attending Networking Events• Researching Industry Leaders• Tracking Industry Trends• Participating in Industry Discussions

CONSULTANT PROGRAMMER ANALYST, Fahrenheit IT Inc., Indianapolis, IN, office, 11/14 – 12/15Utilized IBM MAINFRAME, IBM PC, COBOLII, JCL, VSAM, DB2, ENDEVOR, InterTest Batch, InterTest for CICS, Optim ACCESS, and MS OFFICE (Word and Excel), to complete projects onsite at client, Navient (formerly Sallie Mae), Reston, VA.• Produced the original lender state code file for the monthly post default inventory. The data was not in data warehouse so it was provided from the mainframe. Described the process and streamlined it from 2 days originally to under 4 hours.• Interrogation Report was designed to identify potential SSN/customer mismatches across servicing platforms. The report was producing numerous false positives, as it looks for exact match of first name/last name. Logic modifications were required to eliminate unnecessary volume. Working with the user the logic became SSN + 1, 1st character of first name without case differences, and date of birth. Date of birth had to be added to borrower extract files in CLASS and ED to allow its use in report matching. With the changes the ‘ACCOUNTS WITH BORROWER NAME DIFFERENCES’ were reduced from approximately 1460 pages to 36 pages.

Utilized IBM Mainframe, IBM PC, COBOLII, JCL, DB2, CICS, ENDEVOR, EXPEDITER/CICS, FILE-AID, and MS OFFICE (Word and Excel) to complete projects for Centers for Medicare and Medicaid Services (CMS).• Modified CICS/DB2 and batch programs to process up to 30 periods of Beneficiary Medicare Advantage Reduction Data, ending the discrepancy with Social Security Administration.• Enhanced CICS program EDBOTABM and map to indicate archived data. This maintained existing functionality while improving processing time.• Developed Interface Control Documents for Fanout process to improve Capability Maturity Model Integration (CMMI).

Utilized IBM Mainframe, IBM PC, COBOLII, JCL, DB2, CICS, ENDEVOR, EXPEDITER/CICS, FILE-AID for DB2, and MS OFFICE (Word and Excel) to complete Labor Management System projects onsite at client, AMTRAK, Washington, DC.• Enhanced online annulment and abolishment CICS/DB2 programs plus their corresponding back-out programs for the Hours of Service Project. New regulations required limiting hours worked, based upon time of day worked, rest time, and hours worked since rest. For annulment and abolishment, table rows were deleted for projected work hours. Table rows were reinserted if reversed before the nightly batch cycle. • Modified Paperless Time Ticket System holiday pay approval logic to prevent deletion of holiday pay which caused incorrect pay and corrective work. I worked with the user to define the process, obtain current examples and identify the cause. I modified stored procedure PTS01M26 correcting holiday pay.

Utilized IBM MAINFRAME, IBM PC, COBOLII, JCL, VSAM, DB2, ENDEVOR, InterTest Batch, InterTest for CICS, Optim ACCESS, and MS OFFICE (Word and Excel), to complete projects relevant to Sallie Mae’s student loan operations and related financial services.• Developed, tested, installed and maintained the mainframe interface to Loan Selection Tool System (LST). The mainframe side of LST is a COBOLII/DB2 system automating the final loan sale. LST created a streamlined loan acquisition and securitization process that allowed increasing loan sales and tracking the funding for individual loans. LST provided the basis to secure loan funding through the recent credit crisis.• Enhanced existing CICS/DB2 online and COBOLII/DB2 batch programs to capture all potential Private Credit Loss events. The captured events were used by a data warehouse for management reporting and predictive modeling and analytics. The objective was to reduce over $600 million in currently reported potential losses.• Removed collection, returned item, legal and forbearance fees required by Department of Education (DOE) to be excluded from their loans. Corrected transfer process to write off fees and ensure the fees were zero.

Utilized IBM MAINFRAME, IBM PC, COBOLII, JCL, VSAM, DB2, ENDEVOR, Optim ACCESS, and MS OFFICE (Word and Excel), to complete a variety of projects onsite at financial services client, Sallie Mae, Inc., Reston, VA. (I was placed with Princeton’s client, Sallie Mae, on a contract to hire. I became a permanent employee with Sallie Mae, as a Senior Programmer Analyst, in July 2006.)

Utilized IBM MAINFRAME, IBM PC, COBOLII, CICS, ISPF, TSO, JCL, VSAM, DB2, ENDEVOR, FileAID, XPEDITER/CICS, SPUFI, QMF, Lotus Notes, VISIO, FINALIST, and MS OFFICE (Word and Excel), to complete a variety of projects onsite at client, Newport News Holdings Corporation, Newport News, VA.• Enhanced online CICS/DB2 and batch programs using XPEDITER to analyze current processing and verify modifications during unit testing for the “Cross-company Selling Project.” Communicated with various levels of information systems staff to analyze, develop and implement the enhancements. This project allowed multiple companies to sell a product while only one company maintained the product in inventory.• Standardized approximately 60,000 addresses in the existing VSAM Fraud File using Finalist, which was called through a COBOLII program that I wrote. Also, I loaded the standardized fraud addresses into new DB2 tables using a COBOLII/DB2 program. These changes increased the accurate identification of fraudulent addresses, thereby increasing profit. While testing the standardization program, I found existing fraud addresses that had been changed by Finalist. I determined that all customer addresses would need to be periodically updated with Finalist in order to keep existing addresses current.• Responsible for the setup and running of the initial “Daily Job Flow Test” at the new onsite processing center. Copied files and DB2 tables; ran mass binds; modified the JCL and PROC Libraries for testing; and, added modifications for the “Kit and Component Project.” This enabled testing and installation of the modifications for this project, a major system enhancement that included high profit sales.• Member of the project team responsible for all aspects of designing a gift card program scheduled for installation around mid to late October 2005.

Utilized IBM MAINFRAME, COBOLII, CICS, DB2, JCL, IMS, VSAM, TSO/E, ISPF, XPEDITER/CICS, File-AID (for DB2); IMS; MVS, CICS Abend-AID/FX to complete a variety of projects requiring extensive communications and complex programming, documentation, and testing within tight timeframes.• Served as a member of a three-person team responsible for troubleshooting and supporting on-line CICS subsystem for ID cards and binders for a national insurance company. Converted the original, system, which used IMS databases; to DB2 for Client and Policy databases.• Completed projects prior team was unsuccessful with, including, writing, improving function and reliability of a 2D Bar Coding Project. Converted name and address from free format to fixed format. Tested the CICS, DB2, VSAM, and COBOLII code commands. Used a top-down testing technique using XPEDITER to walk through the COBOLII commands to verify the results; viewed the data before executing the CICS, DB2, and VSAM commands; viewed the data after executing the commands; and checked the return codes from those commands. Independently analyzed customer requirements and coordinated analysis and design changes with the customer and other software developers; developed design changes to the name and address display for the 2D bar code project to bring the company into compliance with state regulations.• Changed Maryland’s FR-19 form processing from the existing IMS database system to the new DB2 database system. Modified programming logic that was written in COBOLII using structured programming techniques in an IBM mainframe environment. Modified code to increase maximum vehicles allowed to nine. Corrected vehicle coverage and lien holder for vehicles four through nine. Enabled police department to read insurance cards through sophisticated computer technology.

Utilized IBM MAINFRAME, IBM PC, IBM OS/390, COBOLII, ISPF, TSO, LE, JCL, IOF, VSAM, IMS, ENDEVOR, File-AID (for MVS and IMS), CA-PANVALET, Automated Scheduling, and MS OFFICE (Word, Excel) in completing complex IT projects that required frequent communications and complex programming, documentation, testing that had to be completed in limited time frames and providing production support on a rotating basis.• Enhanced and maintained both existing online and batch Payroll systems within a large-scale IBM OS/390 environment for an international oil company. Analyzed customer requirements for adding flexible benefits to an existing IMS employee database and payroll system to determine how to add flexible benefits in accordance with installation standards and procedures. Communicated extensively with users and personnel in DP areas to define, develop, and implement requests. • Added flexible benefits to the IMS employee database. Initialized the database and modified payroll processing to utilize the IMS employee database for input to include dependent data in the data transmission to the insurance company. • Developed design documentation for flexible benefits and dependent medical payment, adding both to the database environment. Independently analyzed customer requirements and coordinated analysis with the customer and other software developers. Modified the medical payment plan to utilize the IMS employee database for input to include dependent data in the data transmission to the insurance company: Coded, tested, and installed changes for the flexible benefits to both the IMS employee database and payroll system. Both systems were written in COBOLII.

Utilized IBM MAINFRAME, IBM PC, IBM MVS/ESA, COBOL/COBOLII, ISPF, TSO, IOF, JCL, CICS, VSAM, DB2, Automated Scheduling, File-AID (for MVS), and CA-INTERTEST to complete a variety of projects requiring extensive communications and complex programming, documentation, and testing within tight timeframes.• Maintained and developed enhancements to and customized Payroll, Personnel, and Insurance systems. • Designed and wrote program specifications and assisted in programming an integrated subsystem using CICS and DB2 in accordance with installation standards and procedures. This subsystem provided online updates for payroll information for a CA payroll and personnel system in an IBM MVS/ESA, COBOL/COBOLII environment. The subsystem provided finance, compensation, and production interfaces with multiple levels of security for a national transportation company.• Independently analyzed customer requirements and interfaced with personnel to design and develop a turnaround document for employees, listing their current enrolled benefits profile under a cafeteria-style benefits plan and requesting employee selection changes. Coordinated analysis with the customer and other software developers, created database, CICS, and output form additions, wrote documentation, and performed software testing.• Wrote customized payroll and savings withdrawal inputs for an InSci Payroll and Personnel system using CICS and VSAM.

Utilized IBM MAINFRAME, IBM MVS/ESA, COBOL, ISPF, TSO, JCL, IOF, VSAM, IMS, CA-PANVALET, and Automated Scheduling to complete a variety of projects requiring extensive communications and complex programming, documentation, testing within restricted time allotments, and providing production support on a rotating basis.• Maintained and enhanced existing payroll systems using mainframe programming. Analyzed the system and designed and wrote program specifications; developed replacement systems. Interfaced with multiple users and personnel in other DP areas.• Analyzed customer requirements for emergency checks and social insurance.• Designed, developed, programmed, documented, tested, installed, maintained, troubleshot, and supported vacation pre-pay system created to provide salary advances and travel expenses or allowances to employees prior to vacations. • Developed design documentation for social insurance.• Independently analyzed customer requirements and coordinated analysis and design changes with the customer and other software developers.• Initiated the rewrite of the emergency check, check reconciliation, and social insurance systems to decrease cost and improve processing and accuracy.

Utilized Honeywell Midrange and COBOL to complete a variety of projects requiring extensive communications and complex programming, documentation, and testing within tight timeframes.• Developed software and performed testing of programs for accounts receivable and claims systems for insurance companies. Coordinated analysis and design changes with the customer and other software developers.• Maintained computer software and hardware for accounts receivable, claims, and payroll systems for a national insurance brokerage. Analyzed customer requirements, wrote program specifications, and developed design documentation. Reviewed programmer output, and designed forms and reports.• Participated in the analysis, design, and programming of reinsurance, claims, and accounts receivable systems for an existing insurance corporation.