SUMMARY:

• Senior Programmer/Analyst skilled in a variety of operating system platforms and computer languages capable of translating complex technical material into concrete and understandable objectives to key business owners and project stakeholders in a cross - platform and cross-functional environment.

TECHNICAL SKILLS:

OperatingSystems/Environments: IBM: VM/SP, DOS/VSE/SP, OS/400, CICS/ICCF, CMS, MUSIC/SP, MVS/XA, MVS/ESA, OS/390, Z/OS 390, AS/400 V5R1, iSeries V5R2, iSeries QSHELL, Z/OS Unix Shell, DEC: TOPS/10.

Databases: dBase IV, Oracle 9I, Oracle 11g, iSeries/i5/OS DB2 UDB, z/OS DB2, NOMAD-DBMS, IMS/VS, Teradata, Netezza

Database Communication: DRDA, DDM, DB2 CONNECT

Communication Software: VTAM, NSH7, RSCS, SNADS, SNA, TCP/IP

Network Monitoring: NCCF and NETVIEW

Spooling Subsystems: VM/RSCS, MVS/JES2, DOS/VSE/POWER

Programming Languages: DOS/VSE/RPGII, OS/VS/COBOL, DOS/VSE/COBOL, COBOL II, 400/COBOL, 400/COBOL ILE, z/OS Enterprise COBOL, 400/RPG III, 400/RPG ILE, COBOL 390 for VM and MVS, REXX, REXX NEATWIND, REXX/SQL, FORTRAN, EXEC 2, SQR, UIM, CL, CLLE, PL/SQL, ICCF PROCEDURAL LANGUAGE, QUICKJOB, EASYTRIEVE,NOMAD, COBOL/CICS COMMAND LEVEL) and BMS ASSEMBLER MACROS

Development Software: Oracle: SQL *FORMS, SQL*PLUS, PL/SQL Developer, iSQL*PLUS, Oracle Forms 6i, Oracle Forms 11g, TOAD

Mainframe(z/OS): IDCAMS, JCL, JES, DITTO, JOBSCAN, PREP, JCLCHECK, FileAid, AbendAid, INTERTEST, XPEDITER, XCHANGE. SDSF, IOF, MIGRATOR, ISPF Dialog Development, Rexx DSNREXX, Rexx QMF DSQCIX

PC Mainframe Software: SPF/PRO, KEDIT, QMF for Windows

CICS: BMS, CECI, CEDF, CEMT, SDF IIAS/400 (iSeries): SDA, PDM, SEU, DFU, PC SUPPORT, CONNECT DIRECT, CONTROL-M, ISQL, QM, OPNQRYF, QUERY 400, CODE, APIs.

Teradata: SQL Assistant, Teradata Studio Express

ETL Software: Pervasive - Data Junction/Data Integrator

Change Management Software: i5/OS: Aldon, Turnover z/OS: Panvalet, Endevor

Email Software: Outlook, Outlook Web Access, Outlook Express, Lotus Notes, Novell GroupWise

PCs: VISIO, PC/DOS, MS/DOS, OS/2, WINDOWS 3.1, WINDOWS 95, WINDOWS 98, WINDOWS NT, WINDOWS XP, EXCEL, WORD, FRONTPAGE, ACCESS, LOTUS 123, AS/400 Client Access, OPS Navigator, iSeries Access, iSeries Navigator

Insurance Application Software: CSC POWER/MHS 4.7 and 5.0, CSC POINT, BCBSA LRSP, Perot Systems DIAMOND 950 (Paradigm), QNXT

VM/SP Software: VMTAPE, VMOPERATOR, VMBACKUP, VMBATCH, VMARCH, VMSECURE, PASSTHRU, ICCF, REXX EXECS, GML, SCRIPT/VS, DCF,XEDIT, BOOKMASTER, CMS, and PROFS. z/OS Software: Control-M, Control-M Desktop for PC, JHS, SDSF. i5/OS: Robot/Alert, Robot/Network, Robot/Reports, Robot/Schedule, Robot/Console, Robot/LPAR, Native i5/OS Scheduler, BRMS, Passthru, Control-M.

QA Software/Mercury: Mercury QC, ClearQuest, HP QC

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Responsibilities:

• CCBR is Confidential s application that receives credit information from the Transunion and Confidential credit reporting agencies and then loads the credit information into the Teradata corporate data warehouse for downstream users. CCBR is a mainframe (z/OS) application using BTEQ and TPT to load and unload data to/from Teradata.
• Implemented the Quarterly Attribute Analysis application to identify unused columns in CCBR Teradata tables so the unused columns could be decommissioned. This included:
• Creating MULTISET Attribute Analysis table to store data
• Creating 2 JCL job streams
• Unload/collect data with BTEQ script running complex queries with inner/outer joins and accessing system DBC tables identifying unused columns
• Load data into Attribute Analysis table with TPT
• Implemented monthly DMR (Data Management Repository for Consumer Bank) reporting metrics application which sends CCBR monthly metrics on FAIL/PASS conditions on job execution during batch processing. This included:
• Creating MULTISET DMR mapping table and loading with TPT.
• Creating MULTISET Metrics table.
• Creating 2 JCL job streams.
• Unload/collect data with BTEQ script running complex queries against 23 tables utilizing LOAD WORK tables to make the queries process faster. Some of the tables were very large and were not designed to be joined for metrics reporting
• After monthly data is collected it is stored in monthly metrics table
• Report is run to produce txt pipe delimited file with headers
• Report is squeezed to remove all white space
• Send squeezed monthly metrics report to DMR with NDM and send email to CCBR reporting processing month and record count
• Loaded SBFE (small business financial exchange) data weekly for 2 months until jobs where put into place to automate. This included:
• Setting up 2 JCL job streams
• JCL with PGM=TBUILD using TPT script to load data from PS file into Teradata UAT environment
• JCL with PGM=TBUILD using TPT script to load data from PS file into Teradata ODP environment
• Implemented AFS and LoanIQ data loads into Teradata. This included:
• Setting up JCL job streams
• JCL with PGM=TBUILD using TPT script to load data from PS file into Teradata
• Data is loaded into Teradata in 3 steps
• Raw table
• Stage table
• Model table
• At every load step record counts are checked along with dates and standard deviation
• Implemented Encryption/Decryption of “at rest” mainframe datasets (PCI mandate), 3DES encryption. This is non Teradata. This uses JCL/COBOL and calls encryption/decryption APIs to encrypt/decrypt data
• Tools/Software used:
• JCL/BTEQ/TPT batch
• ISPF/Endevor - source management
• Rexx - macros/programmer utilities/BTEQ interactive
• IBM z/OS Explorer
• Teradata SQL Assistant
• Teradata Visual Studio
• Teradata Visual Explain

Confidential, Portsmouth, NH

Responsibilities:

• Mainframe COBOL/JCL/CICS/DB2/SQL/CICS Web Services (Soap/WSDL,JSON)
• Correcting JIRA tickets reported by analyst/testers in Confidential ’s Internal Billing systems:
• Insight, Oasis, Exceed
• Implemented JSON Web Service Client (request/response) from CICS to Azure .NET (Top-Down approach) for Bank account tokenization project
• Worked with CICS system programmers in defining URIMAP and endpoint, BUNDELS for JSON schemas, CICS Transids, CICS Batch Pipes
• Used Azure .NET JSON objects to create JSON schemas at http://jsonschema.net/ - /
• Imported JSON Schemas into Unix File system and used DFHJS2LS JSON assistant to create JSBINDs and COBOL COPYBOOKs
• Updated existing CICS COBOL program to use JSON instead of SOAP/WSDL. Included CICS commands:
• GET/PUT CONTAINER
• LINK to program DFHJSON
• WEB OPEN/CLOSE
• WEB CONVERSE
• Agile methodologies with daily Scrum meetings reviewing Stories and tasks.
• GUI Development tools used
• Eclipse JAVA IDE
• IBM z/OS CICS Explorer
• IBM z/OS Explorer
• IBM Data Studio

Confidential, Charlotte, NC

Responsibilities:

• Practice Solutions to AFS conversion
• Worked with IBM support to create File Manager templates for VSAM files with segmented data.
• Attended conversion and data mapping meetings.
• Corrected SRs (service requests) and moved into production.
• Used JCL, BATCH, and IBM Debugger to test new program changes.
• Setup ODBC connections for MS Access to SQL Server

Confidential, Charlotte, NC

Responsibilities:

• Exporting /importing data from/to z/OS Teradata DataWarehouse and updating of CTDM ( Corporate Treasury Datamart) loans data in a Linux Netezza DW environment.
• Included verifying data sent to CTDM ( Corporate Treasury Datamart) with queries using Aginity Workbench.
• Included coding in Oracle SQL/Netezza SQL
• Implementation of FSR (Financial Systems Roadmap)…switching legacy Ledger to new eLedger SAP
• Included coding in a z/OS COBOL/JCL/VSAM
• Unit/Dev/SIT/UAT with full regression testing and using HP Quality Center
• Conversion of Teradata legacy utilities TPUMP, MLOAD, Xport to Teradata TPT (Teradata Parallel Transporter) scripts, included DEV/SIT/UAT and regression testing.
• SIT/UAT testing of for Teradata TTU upgrade from 1 .10.
• Implemented several ISPF/Rexx programmer utilities for SIT/UAT testing and development work.

Confidential, Charlotte, NC

Responsibilities:

• DB2/CICS and DB2/Batch CUSTOMER/1 - Anderson Consulting custom software model and INSTALL/1 - Anderson Consulting custom technical architecture for development support and execution time components
• Created DB2 Stored Procedures, called by Web Services to replace VB6 screen scrapers
• Created DB2 Stored Procedures, called by Web Services, called by IVR. This also included, creating unit test case scenarios and uploading into HP Quality Center for QA testing
• Updated CICS screens and unit tested for Automate Deposit Review project. Included using Intertest debug for unit testing.
• Created and used Rexx/DB2 DSNREXX, QMF API DSQCIX, ISPF Dialog (panels, execs, etc)
• Also, because of lack of staff, used as a QA tester for Automate Deposit Review project
• 122 Test cases in HP Quality Center
• Run queries to obtain data for S1 test environment from production data
• Load data into S1 test environment
• Execute batch jobs and run new JCL/program changes and Billing cycle
• Run queries and execute HP Quality Center Test Cases

Confidential, Charlotte, NC

Responsibilities:

• Extracting data from Teradata and flat files in a z/OS environment and updating of Corporate Treasury Data Mart deposits/loans datasets and sending to Unix/Oracle and Linux/Netezza environments with NDM. Used Teradata SQL Assistant and included regression and parallel run testing.
• Used BTEQ unload utilityto extract data from tables in Teradata into mainframe flat files. This was done withJCL and parameter file setup withTeradata SQL queriesand Teradata BTEQ session control commands and Collect Statistics. The Teradata SQL(SELECTs) alsoused attribute functions to translate the column data from Teradata todifferent formats for the flat files that theCOBOL could READ. This data was later translated into pure CHAR format and sent to either Oracle/Unix or Netezza/Linux.
• Unix/Oracle environment using:
• PL/SQL
• PL/SQL Developer
• TOAD
• Shell scripts and CTL files with SQL Loader loading Oracle tables
• Linux/Netezza environment using Aginity Netezza Workbench, WinSCP, Putty and verifying data once loaded in Netezza tables.
• All sending of data to Oracle/Netezza included mapping of mainframe data to Oracle/Netezza table columns. z/OS/Mainframe environment using COBOL, JCL, SDSF, Rexx, ISPF Dialog Development, ISPF C/S and WSA, VSAM, NDM, SORT, ICETOOL, CA-7, SAR, DFSMShsm, PODS
• Worked with Changeman administrator and help test new compile procedure for IBM Debug
• Worked with z/OS support tools group and tested new IBM tools: IBM Debug, File Manager, and Fault Analyzer
• Developed several utilities with ISPF C/S and WSA, ISPF Dialog Manager, Rexx, DFSMShsm, and File Manager

Confidential, Glen Allen, VA

Responsibilities:

• Develop and maintain programs using OPM COBOL, ILE COBOL, ILE COBOL/SQL in an i5/OS environment.
• Create custom enhancements to i5/OS ASI software: screens and programs.
• Backup i5/OS operations: tape, printing, and user support.
• Migration of Oracle Forms 6i to 11g (Oracle).
• Included updating PL/SQL in forms
• Included writing/testing/implementing new PL/SQL Procedures
• Crystal Report 9 reports (Oracle)
• .Net Excel Viewer reports (Oracle)
• Gathering project requirements from users and updating and designing technical specifications or make suggestions for alternative solutions.
• Software Used:
• DB2 UDB V5R4
• SQL, ISQL, Query Manager, RUNSQLSTM, iSeries Navigator, Squirrel, ILE Debugger, Stored Procedures, iDate
• Separate LPAR with iCluster for capturing data changes with journaling
• I5/OS Web Access
• DDL for Oracle and DDS for i5/OS
• Turnover
• DB relational modeling of i5/OS files to Oracle tables or materialized views
• Oracle Gateway 9i and 11g
• Oracle PL/SQL Developer and TOAD
• IFS using CPYTOIMPF, CPYFRMIMPF, CPYTOSTMF and CPYFRMSTMF
• IFS using Windows NetServer Commands thru command STRPCCMD

Confidential, Boston, MA

Responsibilities:

• Maintained and created programs using Enterprise COBOL/DB2/SQL, DB2 stored procedures in Batch and CICS environments for PWI Brokerage Systems.
• Designed TSD and developed new jobs, procs, COBOL/SQL, for FDIC Max project using Waterfall and Agile methodology.
• Old and new programs unit tested and QA SIT and UAT tested in different regions and LPARs.
• Converted business requirements into high level and technical design specifications and created and maintained technical systems documentation.
• Created and maintained ISPF programmer utilities using Rexx, ISPF Services, ISPF C/S WSA, DB2 DSNREXX, QMF DSQCIX, and DSNESC01 FUNC(SPUFI).
• Executed QMF and SPUFI queries against DB2 to identify patterns of data.
• Created Test Plan and executed Test Cases using Mercury Quality Center (QC). Tracked QA defects using Clear Quest.
• DB relational modeling of z/OS DB2 tables

Confidential, Southfield, Missouri

Responsibilities:

• EDI X12 HIPPA transactions to front end systems
• Mainframe LRSP to QNXT/QITS conversion project, data mining, data mapping, data analysis, data conversion.
• Converted in-house programs for ITS releases 9.3, 9.4 and 10.0. This included VSAM to DB2 conversion for ITS REL 10.0 which included coding, unit, regression and parallel testing.
• Created and maintained in house conversion utilities using ISPF Dialog and Rexx
• Converted in-house programs for NPI and LDLA. This included coding, unit, regression and parallel testing.
• Consultation on ALIM (Aid Line Item Manager), Host Integration Server (HIS), LU6.2 Mainframe CICS Connection
• Converted business requirements into high level and technical design specifications and created and maintained technical systems documentation.
• Provided 24/7oncall support and researched/resolved system problems and user questions.
• AS/400 and OS/390 cross platform development using COBOL/DB2/SQL/CL, DB2 Stored procedures.
• Software Used:
• DB2 OS/390 and AS/400
• IBM Migration Utility - COBOL II to Enterprise COBOL
• SQL, COBOL/SQL ILE, ISQL, Query Manager, RUNSQLSTM, Ops Navigator, ILE Debugger
• DDS for i5/OS
• Aldon
• IFS

Confidential, Bedford, Texas

Responsibilities:

• Mainframe LRSP to Perot Systems DIAMOND 950 conversion project using HIPPA compliance.
• Data mining, Data Mapping, data analysis, data conversion, programming/development.
• Analysis of JCL job streams, VSAM files, SQL Stored procedures, COBOL and Easytrieve source code. Also used Fileaid to examine data files.
• Developed packages, procedures, and functions using PL/SQL and PL/SQL Developer in a Oracle 9i environment.
• Developed Business and System requirement document for data conversion process which included Acceptance Testing requirements for System Test and Corrections, DIAMNOD 950 Test and Corrections, Integration Test and Corrections, and UAT Test and corrections. Worked with QA/UAT team in developing Test Strategy/Test Plan. This included structured data test strategy, notifications of bugs, and incident determination process.
• LRSP data was extracted from IMS and populated into an Oracle ODS (Operational Data Store) environment. The ODS data was then used for conversion into the (Oracle) DIAMOND 950 environment. Responsible for Premium Billing and Authorization conversions.
• Introduced to and used ETL software - Pervasive Software - Data Junction/Data Integrator (VB script oriented).
• Extracted data from Oracle to MS Access and MS Excel for queries and ad-hoc reporting.

Confidential, Richmond, Virginia

Responsibilities:

• Rewrite of application that calculates VMI Agent Contingency Bonus Plan, this includes calculating DWP (Direct Written Premium) bonus, profitability bonus, and total contingency bonus.
• Developed Functional, Technical, and Test Plan documents. All testing, end-to-end was done by programmer as no QA testing team existed in company.
• RPG III/ILE and COBOL/DB2/SQL/CL programming languages in an AS/400 environment.
• Adhoc reports for reporting of insurance data; this includes the following:
• Accident results for 2003 - Paid loss/expense, Reserve Loss/expense, total incurred
• Accident results for 2004 1st Qtr - Paid loss/expense, Reserve Loss/expense, total incurred
• Total Losses that exceed $50,000.00 since 1999, Paid loss/expense, Reserve Loss/expense, total incurred
• Extract policy information for glass coverage and build converted/formatted outfile to send to vendor.

Confidential, Wilmington, Delaware

Responsibilities:

• Upgrading insurance application in an AS/400, z/OS 390 environment using HIPPA compliance.
• Tools used include: Endevor, Easytrieve, Fileaid, JCL, VSAM, COBOL, Aldon, OS utilities and FTP.
• Coding interfaces to CSC POWER/MHS and writing adhoc reports using AS/400 COBOL, and COBOL/DB2/SQL and CL.
• Data mining, Data conversions/interfaces between AS/400 and mainframe.
• AS/400 and OS/390 cross platform development using COBOL/DB2/SQL/CL
• Software Used:
• DB2 OS/390 and AS/400
• SQL, COBOL/SQL ILE, ISQL, Query Manager, RUNSQLSTM, Ops Navigator, ILE Debugger
• DDS for i5/OS
• Aldon
• IFS
• Worked with QA in developing Test plan and test cases and validating test results. This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections.

Confidential, Edison, New Jersey

Responsibilities:

• Analysis on Oracle Forms, databases, stored procedures, PL/SQL, etc. for an Oracle to AS/400 DB2 UDB conversion.
• Software Used:
• DB2 AS/400
• Oracle

Confidential, Durham, North Carolina

P/A-Lead Developer

Responsibilities:

• Developed and maintained COBOL programs in an AS/400 DB2 UDB, OS/390 DB2 UDB, IMS DB/DC environment. Programs extracted information from IMS and either updated DB2 table on OS/390 or were sent to AS/400 were DB2 tables on AS/400 were updated. Programs extracted information from AS/400 tables and data was sent to update DB2 tables on OS/390 or update IMS files. Also, used 400/RPG III, 400/RPG ILE and C++ programming languages for exit programs and utilities. Easytrieve and Fileaid were also used.
• Used PL/SQL scripts to extract data from Oracle and send to AS/400 and mainframe applications.
• Lead team in developing and implementing DRDA (distributed relational database architecture, AS/400 DB2 to OS/390 DB2 ) standards between AS/400 and OS/390 platforms for HIPAA. Included connectivity issues from AS/400 to OS/390 and OS/390 to AS/400. As well as, developing/implementing DB2 stored procedures on both AS/400 and OS/390 and database triggers on AS/400.
• Responsible for POWER/MHS EOB prompt pay, ITS EOB letters, premium billing, transfer and reformat for HCFA and UB92 claims, letter correspondence, claim throughput daily, weekly and monthly reports, VRU interface, and HIPAA Confidential Communications. This included developing functional and technical specifications and working with QA in developing test plan and test cases and validating results. . This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections.
• ITS/POWER/MHS batch adjudication and reports, Claims Payment Cycle and reports, posted claims and reports and ITS Home Claims Purge Report. This included developing functional and technical specifications and working with QA in developing test plan and test cases and validating results.
• Created and maintained utilities for programmers. FTP utility using REXX/400. SEU line command utilities.. The SEU line command utilities were also published in Midrange Computing Magazine, May 2001, Techtalk, page 92. Contributed to iSeries Network newsletters - SEU and JCL:
• Developed REXX execs on mainframe using ISPEXEC services, which automated program compiles. The execs allowed programmers to submit compiles directly from an edit session while either in ISPF EDIT or Panvalet. This eliminated having to store separate JCL members for program compiles which standardized the compile process for the team.
• Provided technical support for implementing ALIM across a TCP/IP network using ANYNET. Also, designed and maintained network monitoring screen for the ALIM connection, which updated automatically when a device or controller connection dropped.
• Data mining, Data conversions between AS/400 and mainframe using HIPPA compliance.
• Provided SPM support for AS/400. Included enforcing coding standards for COBOL ILE and CLLE. Also, provided additional AS/400 for team members and technical expertise for DB2 UDB.
• Administered and tested performance enhancements for AS/400 DB2 UDB (Load Testing and Stress testing). This included using the new iSeries database SQL Performance Monitor feature and use of the QAQQINI file.
• Received 3 BCBS Blue Ribbons in recognition for working on projects and recommended for 1 BCBS Blue Star in recognition for providing technical support on new features of iSeries Navigator and received 1 Letter of Recognition for work on the PowerMHS 4.7 implementation.
• Software Used:
• DB2 OS/390 and AS/400
• SQL, COBOL/SQL ILE, ISQL, Query Manager, RUNSQLSTM, Ops Navigator, ILE Debugger
• DDS for i5/OS
• Aldon
• IFS

Confidential, Raleigh, North Carolina

Responsibilities:

• Prepared RF Home Accounting Update and reports.
• Delivered POWER/MHS EOB/EOP messages and letters.
• Worked with QA in developing Test plans and test cases and validating results. This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections.
• Data conversions between AS/400 and mainframe.
• Software Used:
• DB2 OS/390 and As/400
• SQL, COBOL/SQL ILE, ISQL, Query Manager, RUNSQLSTM, Ops Navigator, ILE Debugger
• DDS for i5/OS
• Aldon
• IFS
• Fileaid, Easytrieve, and Visio used in AS/400 mainframe environment.

Confidential, Raleigh, North Carolina

Responsibilities:

• Maintained PARS, dBASE IV - Friday Center, Conferences and Institutes and PARS Personnel Activity Reporting System - Batch applications.
• Converted batch VS COBOL II/VSAM application to COBOL/SQL/Oracle - all VSAM files were converted to Oracle databases, which included data conversions. Oracle was running in the UNIX Shell on an OS/390 mainframe.
• Used PL/SQL for producing reports on converted data.
• Managed DBase IV. Responsible for adding and setting up User IDs for database access. Completed programming requests for new forms, screens and programs.
• Performed maintenance and enhancements to CICS applications, Fileaid, Easytrieve.

Confidential, Cary, North Carolina

Responsibilities:

• Examined and verified all code for date-related issues. Code included: ISPF Clist, COBOL, and JCL.
• Developed Y2K Integrated Test Plan and test cases, tested and validated results of application for compliance on test LPAR (logical partition). This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections. Programmer did all testing, as no QA Testing Team existed in company.
• Fileaid, Easytrieve, Visio used.
• Examined and verified all code for date-related issues. Code included: IMS DB/DC COBOL.
• Developed a Y2K Integrated Test Plan and Test cases, tested and validated results of application for compliance on test LPAR. This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections. Programmer did all testing, as no QA Testing Team existed in company. Mercury testing tool was used for automation of test cases.
• Fileaid, Easytrieve, Visio used.
• Examined and verified all code for date-related issues. Code included: IMS DB/DC COBOL, JCL, QMF Proc, and QMF Query.
• Developed Y2K Integrated Test Plan and test cases, tested and validated results of application for compliance on test LPAR. This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections. All testing was done by programmer as no QA Testing Team existed in company.. Mercury testing tool was used for automation of test cases.
• Fileaid, Easytrieve, Visio used.
• Examined and verified all code for date-related issues. Code included: JCL, QMF Proc, and QMF Query.
• Developed Y2K Integrated Test Plan and test cases, tested and validated results of application for compliance on test LPAR. This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections. Programmer did all testing, as no QA Testing Team existed in company. . Mercury testing tool was used for automation of test cases.
• Fileaid, Easytrieve, Visio used.

Confidential, Raleigh, North Carolina

Responsibilities:

• Transferred all data sets, COBOL & JCL source from a non-Y2K compliant LPAR to an Y2K compliant LPAR. Fileaid, Easytrieve, Visio used.
• All code was not expanded, as only date-related fields on reports were expanded for century.
• Received Millennium and Nortel Top Gun from Nortel.
• Data conversion for date related fields in files, 2 digit to 4 digit
• Worked with QA in developing Test plan and Test Cases and validating test results. This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections.
• Determined all software specific to the ORS Application.
• Created hardware specs for application to run on new compliant LPAR.
• Produced Software Build Document (how to build the system on a new LPAR).
• Worked with QA in developing Test plan and Test Cases and validating test results. This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections.
• Transferred all data sets, COBOL, CICS & JCL source from a non-Y2K compliant LPAR to a Y2K compliant LPAR which included adding to the new CICS region, FCT, PPT and PCT entries. Fileaid, Easytrieve, Visio used.
• Data conversion for date related fields in files, 2 digit to 4 digit
• Expanded all COBOL code and CICS screen fields to accept Y2K data for example: Production weeks (9801 expanded to 199801), PO dates (101598 expanded to 10151998), System Screen Date (10/19/98 expanded to 10/15/1998) .
• Used SDF II to change all map/mapsets.
• Changed QMF procedures to REXX execs and setup menu so business user could run QMF queries directly from ISPF command line without having to start QMF. The REXX execs used the QMF/REXX interface utilizing QRW and DSQCIX. The execs also allocated a print dataset with destination (DEST) on a VM/SP mainframe. This automated the process for the business user eliminating about 4 steps.
• Received Millennium and Nortel Top Gun from Nortel.
• Created flowchart for entire system, which resided on a VM/ESA V2 R2.0, using VISIO.
• Worked with QA in developing Test plan and Test Cases and validating test results. This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections.
• Performed analysis on execs to determine which execs were not Y2K compliant. Execs that were not Y2K compliant were replaced or rewritten in REXX.
• Remediated NOMAD source to make Y2K compliant from within the program.
• Performed windowing, as all date-related fields were not made Y2K compliant due to user request of no changes on the screen.
• Received Millennium and Nortel Top Gun from Nortel.

Confidential, Burlington, North Carolina

Application Support and development

Responsibilities:

• Worked in an MVS/ESA environment supporting a variety of production applications using JCL, COBOL, SQL/DB2, QUICKJOB, Fileaid, Visio, and CICS.
• Managed writing ad hoc reports using QUICKJOB for end-user and business partner requests.
• Worked with QA in developing Test plan and test cases and validating results. This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections.
• Received Letter of Recognition from business partner for outstanding work on a reporting project.

Confidential, Cary, North Carolina

Operations Consultant

Responsibilities:

• Worked in a multiple operating system environment: MVS, VM, AIX and AS/400 monitoring multiple systems and helping support staff resolve operational and network problems.
• Designed and maintained automatic updating network monitoring screens for IBM customer ANSELL, INCHACAPE SHIPPING SERVICES and COASTAL PHYSICIANS GROUP on AS/400.
• Designed and maintained an email system for IBM Customer, Elizabeth Arden using REXX and NEATWIND Windowing Facility on VM/ESA.
• Wrote XEDIT macro screens on VM and used full power of ISREDIT macros and ISPEXEC services on MVS/ISPF.

Confidential, Swannanoa, North Carolina

Computer Programmer & Operator (AS/400)

Responsibilities:

• Responsible for backup of system, batch process, report distribution and EDI transmissions.
• Automated nightly batch process cutting batch run time from 7 hours to 4 hours.
• Designed and maintained report distribution system for Confidential using COBOL/SQL, SDA, UIM, and CL.

Confidential, Greensboro, North Carolina

Consulting Operations Analyst Assistant

Responsibilities:

• Responsible for job scheduling and enforcing JCL standards.
• Combined JCL source members with associated comment members. This was accomplished using REXX and ISPEXEC services.

Confidential, Winston Salem, NC

Responsibilities:

• Changed JCL to use VSAM KSDS files to replace flat sequential files on Student Loan System.
• Changed JOB streams to work with VSAM files; using IDCAM services on Student Loan System

Confidential, Herndon, Virginia

Computer Operator

Responsibilities:

• Back up of system, print distribution and batch processing.
• Writing and documenting operator procedures.
• Wrote execs in VM/REXX to improve operator efficiency.
• Wrote COBOL/SQL programs to run reports against Oracle databases.
• Worked with Oracle/SQL SQL +, SQL *Forms.