SUMMARY:

• IT Professional with experience in the creation and modification of corporate applications including cash vault, account analysis and payroll.
• Experienced with COBOL, DB2, Easytrieve Plus and CICS.

TECHNICAL SKILLS:

Z/OS, COBOL, Easytrieve Plus, CICS, DB2, JCL, VSAM, Endevor, Changeman, Via Soft Smarttest, Fileaid, IBM development tools, HP Service Center, HP Quality Center, IBM Tivoli Service Management, XPEDITER, SQL, Research, Analysis

PROFESSIONAL EXPERIENCE:

Confidential

Programmer/Analyst

• Involved in the modification of COBOL batch DB2 and CICS DB2 programs for the Confidential
• CBS (Complete Billing System) system which JP Morgan Chase uses for customer billing. Programming changes were made with the BNKEDIT editor found on the VM/CMS system while testing was performed on the Z/OS system. Most of the changes were with the general ledger system where program enhancements were devised by Confidential systems analyst. Made changes to CICS ssfiles for on - line screen changes along with making enhancements to the CICS COBOL programs to use the new screen changes. Followed test scripts designed by an Confidential business analyst to verify the changes were properly made before the final product was released to JP Morgan Chase for their own client acceptance testing. Also wrote easytrieve plus programs to verify general ledger changes. Some of these programs were for scraping general ledger and other pertinent reports and placing the data into files which could be loaded to excel. Used file manager, file manager for DB2 and batch SPUFI to verify changes made to the programs. Also used both batch and CICS versions of Xpediter to debug program changes.
• Also create file manager templates to be used to view flat files and VSAM files found in Confidential 's daily test job. Also created JCL which could be used to backup the flat files and VSAM files for this daily job to flat files with a date and time stamp appended to the end of the backup file name.
• Wrote COBOL procedure copybooks to be used in a mainline DB2 COBOL program which extracted XML data from a DB2 log table and then created a flat file for interface into the Confidential CBS system. Wrote a COBOL program which emulated the mainline DB2 COBOL program but instead this new COBOL program processed a flat file which was created from a batch SPUFI of the DB2 log table. This way there was no need for DB2 restart logic which is found in the mainline DB2 COBOL program.
• Modified programs for JP Morgan Chase which presented a new net tax field. These on-request and monthly programs were changed per the Confidential systems analyst design documents. Again easytreive plus programs were written to scrape the detail data from reports so flat files could be created to load the data into excel. Updated the file manager templates for the Confidential daily test job with new file layouts of the net tax calculation process which was implemented for JP Morgan Chase. Wrote test scripts of how the data was verified for the programming changes.
• Created GDG files for Confidential 's daily test job. Use ICETOOL to backup flat files before they are updated by the various programs found in Confidential 's daily test job. This will provide for a before and after image of the files which would help in testing. Wrote easytrieve plus programs to scrape detail data from additional reports found in Confidential 's CBS system and then created flat files with this data which can be imported to excel. This would help in testing when processing data for an account which may be found in various areas of a report.

Confidential

Programmer/Analyst

• Involved in the migration of SunTrust's lockbox system to Xerox Inc. Authored technical design document to define the SunTrust lockbox file inventory of both mainframe and server based files. This technical design document was devised from the pertinent information found in a Xerox Microsoft Access migration database where descriptive data was entered for lock box customers who have mainframe flat files and/or VSOFT image and/or Paperhost image files.
• Created SQL queries to merge the various tables found in the migration database to create Microsoft Excel spreadsheets. The mainframe files will be routed by the Sterling Commerce file gateway connected between the two companies computer systems while the image files will be directly routed from Xerox Inc. SDX system to a SunTrust file box server.
• Authored a technical design document to define the lock box file merge process between Xerox Inc. server files and SunTrust Banks mainframe ACH files.
• The server files are sent through the Sterling Commerce file gateway to the SunTrust Banks mainframe where data is combined and then sent to a Confidential lock box customer. Help test and made coding changes using Endevor to mainframe COBOL programs and JCL which will be used for the file merge process.
• Found existing production issues with current merge process (Visual Basic programs) being performed on SunTrust server system and corrected these issues with the COBOL programs that were written for the file merge process. Created IBM ITSP tickets to move Endevor changes to production environment.
• Created JCL needed to send files from external lock box customers to Sterling Commerce file gateway. Wrote batch COBOL and Easytrieve Plus programs for conversion of Checkfree ARP system used by SunTrust to Symcor ARP system. These programs and JCLs were developed from a technical design document as devised by the SunTrust ARP subject matter expert.
• Converted large Easytrieve conversion programs to COBOL so ARP subject matter expert could better understand the flow of the programs.
• Modified batch COBOL programs to implement file merge of Xerox Inc. lock box created files with SunTrust ACH files. This was necessary to replace the current file merge process performed on a SunTrust windows based server.
• Helped write technical design document of file merge process so that SunTrust operations personnel could understand the process. Wrote the CICS DB2 COBOL interface programs to MQ Broker to process web based entries for a transfer system for an automated clearing house system.
• Help with the creation of the technical design documents and test scripts of the CICS programs which were entered into HP Quality Center. Tested CICS transactions by using GT Software's Ivory product. Wrote Easytrieve Plus programs to provide the before and after images of data entered into the CICS DB2 COBOL programs.
• Also involved in the installation of the CICS programs and providing production support for the programs until the automated transfer system programs were integrated into the ACH production support group. Worked on various phases of the Gainesville Bank and Trust safe box application merger with SunTrust.
• Helped in the data mapping of GB&T's Jack Henry Silverlake safe box software to Checkfree (Fiserv) mainframe safe box system. This data mapping document was used for most of the technical design document which was written by the technical lead/project manager. Wrote Easytrieve Plus programs used to convert Silverlake master and billing files to Checkfree system.
• Wrote Easytrieve Plus programs to test results of the conversion programs and corrected any defects found in the appropriate conversion programs. Also involved in the integrated testing and production dress rehearsal of the necessary steps needed to convert GB&T safe box data to SunTrust system by creating mainframe job requests via HP Service Manager.
• Made modifications to in-house lock box system. Allow for changes to add new repricing logic needed for lock box charge calculations which eventually are used by the Metavante account analysis system. Involved in providing information to team leader which was used for technical design document. Also wrote test scripts needed to test lock box changes.
• Test scripts were added and processed via HP Quality Center. All programming changes were done in COBOL and maintained and moved into production by Endevor and release testing cycles (integrated, production dress rehearsal). Created and updated disaster recovery documents for lock box which will be used in an event of a production mainframe failure. Also created and updated yearly health assessment documents for the mainframe lock box system to allow external auditors to validate the functionality of this system.
• Modified and wrote custom programs for the Metavante account analysis system and its various release upgrades. Also, involved in documenting and unit testing of changes. Also involved in the system testing cycle from integration, client acceptance and production readiness. These changes were made with DB2 COBOL 390 and Easytrieve Plus using Changeman and Endevor. Also use HP Service Manager to create change orders to implement production changes. Also, was on rotational on-call production support.
• Also, helped in-house account analysis users debug Easytrieve Plus and DB2 SPUFI problems. Responsible for the conversion of National Commerce Financial Corporation cash vault system to be used by Confidential after the April 2005 acquisition. This would allow armored car vendors A T Systems, Loomis/Fargo and Pendum to continue their services for the existing NCF customers. Programs were written in Easytrieve Plus and moved into production via Endevor and release testing cycles (integrated testing, client acceptance testing and production ready).
• Used HP Service Manager to create change orders to move changes to production.
• Wrote technical design document for automating the Brinks armored car system to allow it to interface to the the cash vault system inherited from the NCF merger. Also wrote the cash vault posting program to process the I-CASH interface file from Brinks.
• Supervised the changes made by two other team members to make sure the coding changes met the design specifications. All the programs were written in COBOL 390 and Easytrieve Plus using Endevor. Worked with IBM Global Services business analyst to write the various documentation needed for system test and production implementation via the release testing cycle.
• Used Mercury Test Director to track test defects. Also was the primary on-call production support person for cash vault and the lock box mainframe applications. Resolved production issues created by these two systems and update the necessary components of HP Service Manager.
• Research users questions about these two systems by examining programs and system documentation.
• Provided turnover training and documentation for the cash vault system to an IBM Global services developer. Also provided turnover training and documentation for the lockbox mainframe system to Confidential developers. Worked on the Checkfree VSAM safe box system. Research users questions about the system by examining programs and Checkfree documentation.
• Wrote ad-hoc reports using Easytrieve Plus and modify existing Checkfree COBOL programs using Endevor.
• Also was an on-call production support person for this system and resolved production issues and updated the necessary production abend elements of HP Service Manager.

Confidential  

Programmer/Analyst

• Responsible for modifying and writing custom programs for the Integral Systems, Inc. Payroll
• system based on specifications. Modules modified included incentive awards, moving expense, and disability. Additionally made changes to Easytrieve Plus programs to correct Y2K problems. These batch DB2/COBOL II and DB2/Easytrieve Plus programs were modified with
• the use of SCLM. Wrote user test documentation for changes. Provided on-call production support for the system.
• Responsible for modifying and writing DB2/COBOLII, DB2/Easytrieve Plus, JCL and PROCS for the Media One conversion project that would allow this company to migrate from their existing PeopleSoft payroll system to the MVS Integral Systems, Inc Payroll system. The majority of the changes made were in the disability portion of the Integral Payroll System.
• Responsible for writing a Mechanized Dataset Cleanup System that was designed by a systems
• analyst to determine how much it costs to store data sets on disk and tape. This system was written in COBOL II, SAS and Easytrieve Plus. Wrote and modified COBOL II and Easytrieve Plus batch DB2 payroll programs that were mainly used in the W-2 process. One program was for creating a Paytax interface file that reported on federal, state and local wages for all AT&T employees. This file was then sent to a UNIX system for further processing. Another program gathered statistics for retired AT&T employees. Both of these programs were written with Easytrieve Plus using DB2. Used Xpediter and Micro Focus COBOL to debug COBOL II programs.

Confidential

Programmer/Analyst

• Responsible for writing various Easytrieve Plus/DB2 programs. These include a program to report local wages and taxes for employees who live in Oklahoma, Massachusetts, and Ohio. A program to create flat files of payroll data for PeopleSoft H/R package. A program to create flat files of payroll information for Confidential divestiture of employees to General Dynamics and Philips Consumer Products.
• Responsible for assisting in preparation for the year end run of W-2 forms and other various year end processes such as moving expenses, incentive awards, SUTA and other various taxation reports.
• Responsible for converting several COBOL II DB2 programs to Easytrieve Plus DB2 programs to correct W-2 printing and tax reporting which resulted in saving Confidential from paying penalties for improper reporting. Converted several COBOL II DB2 programs to Easytrieve Plus DB2 programs to correct quarterly workman's compensation reports and state unemployment tax reports because of improper reporting.
• Wrote COBOL II DB2 relocation expenses program to take outside vendors’ data, which contains the calculated taxes on the moving expense dollars, incurred by Confidential employees. This program edited the data for proper state and local codes, social security numbers, FICA limits, OASDI limits, etc. and created transaction files that are used to update payroll DB2 data. Also, wrote Easytrieve Plus programs to print transactions reports and accounting error reports.
• Converted COBOL II DB2 programs to Easytrieve Plus DB2 to properly present the retirement file and reports that shows the employee's monthly coverage amounts, which are based upon
• the employee's pay and incentive awards.
• Responsible for rewriting year and gross up program which was used to calculate taxes and
• wages for employees with moving expenses and bonuses so it was more legible and conforms to the Confidential programming standards. Also, this program was modified to handle the split of AT&T and Confidential system by separating the respective company’s employees. This DB2 COBOL II program was tested using Micro Focus COBOL. Wrote Easytrieve Plus programs to print dumps of variable length files used in W-2 processing.
• Was a member of the rotational on-call support for the Integral Systems Payroll system. Corrected production issues and updated COBOL DB2 programs for new enhancements to this system. Also updated system documentation when changes were made to this system.

Confidential

Programmer/Analyst

• Wrote several batch DB2/COBOL programs for the Linehaul Trip Sheet System.
• These programs gathered information to track drivers travel time and distance, tuck loading and unloading times, etc. between Watkins Truck terminals and their respective clients.
• Also, debugged and modified DB2, CICS and batch dock productivity programs.
• Provided on-call support and made modifications for linehaul payroll, pickup and delivery and fuel consumption analysis systems.
• Created several DB2/Easytrieve Plus report programs to replace DB2/QMF report programs which were constraining CPU resources.

Confidential

Programmer/Analyst

• Responsible for modifying invoice print programs to create and EDI transaction file. Modified IDMS batch and CICS invoice and pack slip programs to print disclaimer notes based on export licensed codes per individual inventory item number.
• Wrote IDMS COBOL batch programs that converted existing shipping codes to new codes required by United States Customs. Modified exiting batch and CICS programs to use this new shipping cod logic.
• Modified batch IDMS programs and JCL to handle printing of European invoices in Brussels, Belgium. Wrote VSAM CICS and batch programs to accumulate European sales data for Brussels, Belgium users.
• Modified several batch and CICS IDMS programs for new user enhancements. CICS map changes were made with BMSGT. CICS programs were tested with Intertest. Batch programs
• were debugged with Xpediter.

Confidential

Programmer/Analyst

• Responsible for writing IDMS and VSAM Easytrieve Plus reports that presented data for engineering change notices.
• Modified existing IDMS COBOL batch programs that updated cost data for engineering change notices.
• Also changed a few ADSO programs that allowed entry of the new cost data for engineering change notices.

Confidential

Programmer/Analyst

• Responsible for assisting in the programming of a cross-reference system for accounts receivable. Wrote VSAM, Easytrieve Plus report programs for the cross-reference system and wrote COBOL programs to load cross-reference file from the accounts receivable system.
• Programmed and tested a work-in-progress system designed to track job performance and progress. Wrote and compiled BMS on-line screen maps as well as writing and modification of CICS, COBOL programs.

Confidential

Programmer/Analyst

• Responsible for helping in the breakdown of a CICS IDMS program that contained three functions, order entry, return authorizations and credit/debit memos into three separate CICS programs. This was done to increase CICS response time.
• Participated in the programming and testing of various tracking systems, which included inventory control, contracts and quotations, credit and debit memos, and salesman commissions. Specific responsibilities included writing and testing of both batch and CICS IDMS programs. CICS map changes were made with BMSGT and CICS debugging was done with Intertest.