SUMMARY:

• More than Ten years of Information Technology experience as a Developer, Tester and Systems Analyst using the SDLC Methodology. I Offer Project Management, Requirements Gathering, Systems Design, System Conversion and Third Party Software Customization. Experience with UNIX/AIX commands and shell scripting on the RISC 6000.

TECHNICAL SKILLS:

Hardware: PC (20yrs), IBM yrs)

Operating Systems: MVS/ESA (15yrs), UNIX (3yrs), Windows XP, DEC VAX/VMS (3yrs)

Languages: COBOL (15yrs), COBOLII (15yrs), DB2/SQL (10yrs), CICS (10yrs), APS (4yrs), Easytrieve (15yrs), JCL (15yrs), Teradata (Ed), PL1 (Ed), MQSeries (4yrs)

Development Tools:: Panavalet (9yrs), TSO/ISPF (15yrs), Librarian (7yrs), JobTrac (5yrs), CA - 7 (4yrs), Platinum Products (7yrs), DB2 Edit (3yrs), Online Express (4yrs), Princeton Relational Tool (5yrs), Changeman (2yrs), Endeavor (4yrs), SmartEdit (6mons)

Office Tools: MS-Excel (15yrs), VISIO (4yrs), MS-PowerPoint (4yrs), MS-Project (2yrs)

Databases: VSAM (15yrs), IMS/DLI (9yrs), DB2 (10yrs), CA-DATACOM/DB (2yrs) MS-ACCESS (Ed)

Utilities: File-Aid (15yrs), Xpediter (15yrs), VSAM Utilities (15yrs), FTP (15yrs), SPUFI (10yrs), DB2/Access (4yrs), DBEDIT(2yrs), IBM File Manager (2yrs), QMF, Mainframe Express

Servers: IBM RS/6000

PROFESSIONAL EXPERIENCE:

Confidential, Columbus,Georgia

Mainframe Systems Analyst

Responsibilities:

• Analyzed and ModifiedTS1programsfor FIJI ConversionProject utilizing DB2, CICS, VSAM andCOBOL
• Created Data Maps and Data Flows for programs that were to be modifiedfor the conversion
• Created unit testdata for testing of new programs
• Monitored System andReportsto ensure integrity of system after conversion

Confidential

Mainframe Programmer Analyst

Responsibilities:

• Utilized CICS, MAUI View, COBOL, DB2, MQ-SERIES, SPUFI, JCL, File-Aid, TSO/ISPF, ENDEAVOR, MS-EXCEL, MS-SHAREPOINT for the Client in Common and Group Filtering Project
• Analyzed, created, modified and tested FENS DB2 Online and Batch Alert Programs
• Ensured that Alerts generated from programs were sent to the Distributed Client Group using MQ-Websphere
• Created Technical Specification Documents for Online/Batch Jobs and Programs being created and modified via SharePoint
• Created and documented Test Cases for Alert Distribution testing verification

Confidential

Technical Analyst Consultant

Responsibilities:

• Utilized COBOL, DB2, DB2 LOAD/UNLOADS, SPUFI, JCL, TSO/ISPF, ENDEAVOR, MS-EXCEL,
• MS-SHAREPOINT, UNIX for the Single View Of Customer Project (SVOC)
• Performance Tunned DB2 queries for SVOC applications, as well as created DB2 queries
• Created denormalized DB2 tables to establish testing environments and reports
• Reported the status of projects and tasks to management
• Loaded and Unloaded DB2 tables utilizing DB2 Unload and Load Utility
• Ensured sync of SVOC application data with Teradata and DB2 platforms
• Met with business stake holders to define and discuss requirements

Confidential

EDI Systems Analyst Consultant

Responsibilities:

• Utilized COBOL, DB2, DB2/SQL, SPUFI, CICS, JCL, MQSERIES, EDI X12, EDIFACT, TSO/ISPF, TRACEMASTER, MS-EXCEL, MS-SHAREPOINT, SAP R/3, CHANGEMAN
• Converted Tech Data’s Distribution Control System (DCS) from Application Data Format (ADF) to SAP R/3 (IDOC) for Last Mile Project
• Data Mapped the EDIFACT Transaction Set to the EDI X12 Transaction Set
• Conducted Data Analysis and Data Mapping to ensure that IDOC fields are compatible with ADF fields for Purchase Order Outbound 850
• Created and tested CICS/DB2 Purchase Order 850 Transaction subroutine program to convert SAP R/3 (IDOC) to ADF, so that it can be sent to Data Interchange via Queue
• Created Test Plan for Purchase Order 850

Confidential, Bethesda, Maryland

Sr. Systems Analyst Consultant

Responsibilities:

• Utilized COBOL, DB2, DB2/SQL, SPUFI, JCL, TSO/ISPF, MS-EXCEL, MS-SHAREPOINT, ORACLE SQL TOOL DEVELOPER, ORACLE, FILE MANAGER, CATALOG MANAGER
• Met with business stake holders to define and discuss requirements
• Created DB2/SQL and COBOL program YMAPDHST for One Yield Sales Goals Department to allow Area Account Executives to set Property goals at Area Level instead of Org Level
• Created Stored Procedure to determine and calculate Sellout Capacity for different room categories for Properties of Marriott Hotels. Utilizing DB2/SQL, TEMP TABLES and COBOL.
• Created Stored Procedure to utilize Sellout Capacity to calculate Remaining Supply for properties of Marriott Hotels. The Remaining Supply would be used in the Retail Pricing Optimization algorithm.
• Utilized Oracle SQL Tool Developer and SQL to load Oracle Test Database with data from Source (prod) Database.

Confidential, Mclean, VA

Sr. Programmer Consultant

Responsibilities:

• Utilized CICS, IMS, DB2, DB2/SQL, COBOL, TSO/ISPF, JCL, JOBTRAC, CA-7. SPUFI, MS-EXCEL, MS-SHAREPOINT, FTP
• Met with users to gather requirements for Test Cases and Test Scripts as relates to HAMP LLR Release Project
• Created Test plans, Test Cases and Test Scripts for testing strategy and functionality of Midas Online/Batch Programs, Default Workout Reporting (DWR) and Electronic Default Reporting (EDR)
• Conducted analysis on how program changes would affect system functionality of Default Workout Reporting System
• Developed Default Workout Applications(programs) to interface with the Electronic Default Reporting system
• Coordinated End to End interface testing with LLR Servicing Process

Confidential, Charlotte, NC

Mainframe SME Consultant

Responsibilities:

• Utilized CICS, DB2, DB2/SQL, COBOL, COBOLII, VSAM, FTP, IMS, INTERTEST, JCL, SPUFI, PLATINUM, MQSERIES
• Responsible for the Knowledge and expertise of the Federated Financial Database System (FFD)
• Assisted in the conversions of KTC and AXIOM Systems to FFD Database
• Attended meetings and reported to management the status of conversions/initiatives that affected the Federated Financial Database System (FFD).
• Conducted COBOL, COBOLII, DB2/SQL and CICS code reviews for on-shore programmers of FFD
• Presented proof of concept for joining new and existing databases to FFD.
• Utilized MQ-Series in Load Balancing Program for FFD database application programs
• Data Modeler for FFD, updated share-point documents to reflect change of physical database

Confidential, Duluth, GA

Systems Analyst Consultant

Responsibilities:

• Utilized CICS, DB2/SQL, COBOL, COBOLII, DATACOM, VSAM, IMS, ROSCOE, INTERTEST, JCL, ENDEAVOR, LIBRARIAN, SPUFI, PLATINUM and Fedway Methodology.
• Responsible for the coding, implementation and maintenance of CICS and Batch programs of the EDI850 0utbound system.
• Created and documented Test Cases, Test Case Specifications, Unit Test Plans, Program Specifications and Code Review Process.
• Updated the EVP File Maintenance Online and Batch System applications to capture new data that would control when purchase orders would be transmitted to the vendor.

Confidential, Raleigh, NC

Systems Analyst Consultant

Responsibilities:

• Utilized Endeavor, COBOL, COBOLII, CICS/GTB V7.0, DB2/SQL, JCL, FTP, VSAM, File-AID and Easytrieve
• Coded and Updated main CICS program in HSIS to display and accept a new selection for print of Active Children using COBOLII and DB2/SQL.
• Conducted analysis and resolved the discrepancies on Medicaid-ID’s in the EDI 837(Health Care Claim) and EDI 835(Health Care Claim Payment) file
• Uploaded and ensured update of CPT codes and descriptions in DB2 tables

Confidential, Charleston, WV

Systems Analyst Consultant

Responsibilities:

• Responsible for the Client Notice System, which generates critical letters/notices to the residents of West Virginia for government assistance
• Managed and developed Client Notice System Online and Batch programs utilizing COBOL, COBOLII, DB2/SQL, CICS, JCL, IMS, Mainframe Express, CA-Telon, Platinum and RASU Tools.
• Migrated and tested FormQuest (Third Party Software) into Client Notice System
• Readily update DB2 tables with notices and letters to comply with state policy
• Conducted analysis for requirements to determine scope of development for online and batch programs

Confidential, Raleigh, NC

Systems Analyst Consultant

Responsibilities:

• Designed and implemented the Online Hearing System for the Confidential Department of Transportation
• Utilized CICS, DB2/SQL, COBOL, COBOLII, TSO, JCL, RACF, SPUFI, QMF, VSAM, MS-Office and Endevor for coding programs and implementing Hearing System
• Designed, Created and Coded maps(screens) using CICS/GTB V7.0
• Created Stored Procedure to accept the screen position to obtain data from db2 table to fill up screen
• Developed and maintained CICS, DB2/SQL, COBOLII programs to interface into Hearing System
• Designed programs to create letters to customers that were in non-compliance with the Confidential Emissions and Inspection laws. Utilized DB2/SQL, Cobol, COBOLII and Correspondence System
• Created and conducted test cases for unit and system testing and developed documentation for programs, screens and systems affected

Confidential

Independent Sales Representative - Contract

Responsibilities:

• Responsible for advising, selling and marketing of Western Southern's and CornerStone America's insurance products

Confidential, Wilkesboro, NC

Systems Analyst Consultant

Responsibilities:

• Responsible for documenting, expanding, testing and supporting the Tax Item fields expansion project for Tax, Sales and Account Costing applications using TSO, CICS, DB2/SQL, APS Online/Batch and COBOL, MS-Office, Platinum Utilities, incorporated the Lowe’s Bridge System Methodology

Confidential, Charlotte, NC

Senior Programmer Analyst

Responsibilities:

• Utilized TSO, Panvalet in SDLC methodology, CICS, DB2/SQL, VSAM, IMS, JCL, SPUFI, JCLCK, RACF, Xpediter - online/batch
• Responsible for gathering business requirements, conducting analysis to identify technical specifications, developing programs, as well as the modification, documentation and testing of code, so that a customer could enroll into the payment plan at anytime.
• Developed Stored Procedure to provide Bill Rates for housing developments based on zip-codes
• Readily conveyed technical to business processes to internal customers
• Created program to generate letters to customers for Summer-Off program
• Modified Extended Payment Plan program to display 12 month bill history and forecast settle-up date
• Analyzed and resolved out of balance revenue error for billing cycles

Confidential, Charlotte, NC

Systems Developer V

Responsibilities:

• Utilized CA-7, TSO, Changeman and Librarian in SDLC methodology, EDI X12, CICS, DB2/SQL, VSAM, IMS, JCL, SPUFI, JCLCK, RACF, Xpediter - online/batch, Remedy, MQSERIES
• Utilized Lotus Notes for e-mail, schedule meetings, notate daily s on calendar
• Responsible for support, design, and maintenance of the Telephone Expense Management (TEMS) and Toll Control (TC) systems to ensure telephone call data is charged-back to responsibility centers through the Management Reporting System (MR) interface
• Developed and Modified TEMS and TC programs to map to EDI 811 Transaction Set to capture new or dropped data
• Readily documented and informed internal customers on business rules and technical issues
• Performed analysis and presented data on the impact and timeline of replacing TEMS tape media with Electronic Data Interchange (Bell Atlantic 811 format)
• Lead project that would allow management to print or deactivate reports. If printed they could select at what level they wanted the report to rollup or drill down.
• Enhanced CICS menu screens (maps) and programs to conform to First Unions environment
• Consulted with Comware Systems(vendor) and telephony service providers to ensure TEMS had current release updates and correct telephone data to process calls
• Transferred program modules and datasets across multiple platforms and regions, using FTP and NDM
• Created and documented Test Cases, Test Case Specifications, Unit Test Plans, Program Specifications and Code Review Process
• Lead merger team and presented Technical Specifications to consultants for the Core States telephone system conversion

Confidential, Rochester, NY

Associate Systems Engineer

Responsibilities:

• Client Server application development utilizing Clipper 5 dBase Language
• Support, update and backup Xerox’s EPSA dBase files via using UNIX-SCRIPTS/ARCSERVE
• Ensure that customers can access PC Software and infrastructure peripherals on Novell Network Server

Confidential, Rochester, NY

Deposit Delivery Programmer

Responsibilities:

• Utilized JobTrac, TSO, Panvalet, in SDLC methodology, CICS, DB2/SQL, VSAM, IMS, JCL, SPUFI, JCLCK, RACF, Xpediter - online/batch, IMS BMP
• Supported mortgage and savings applications for various departments using IMS, JCL, VSAM, Easytrieve and Cobol, CICS
• Supported and maintained the Accounts Reconciliation (AR) and Consumer Loan Application Systems
• Lead project to convert Escrow Checks and Voucher data to collate when printing. Set Agenda, Worked with print-room personnel. Reduced printing and collating time
• Implemented Kiting Report System to track Kitters (floating checks) of $5 Thousand or more. Reports used by security department
• Maintained and customized the MS Tax Applications by downloading Dunn and Bradd Street Tax Modules.
• Participated in designing, creating and implementation of First Federal’s Financial Link System. Created and maintained the package maintenance and daily transaction file as interface to system
• Analyzed and modified program to revise of Deposit letters. Reduced the different kinds of letters that were mailed to customers
• Met with business stake holders to define and discuss requirements