SUMMARY:

Software computer professional with 25 years of experience as a developer, and analyst in mainframe and client server environments for a large number of medium and major IT projects. Proficient in software development to create optimal solutions for internal and external customers. Experienced in full SDLC methodology. Analytical, detail oriented, collaborative, and excellent communicator.

TECHNICAL SKILLS:

Hardware: IBM Mainframe, Server

Software: IMS DB/DC, MVS, z/OS, TSO, ISPF, SDSF, UCC11, CA - 7, ESP, JCL, JES, ZEKE, VSAM, PL/1, COBOL II, CICS, MFS, DB2, QMF, SQL, Expeditor, CMS, Tracemaster, FileAid, Insync, Abendaid, Trace Master, Endeavor, Change man, Assembler, REXX, Syncsort, Easytrieve/Plus, Shell scripting, MicroFocus, Microsoft Excel, Word, SharePoint, PowerPoint, Visio, Lotus Notes, Outlook, HTML, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, Florida

Mainframe Developer

Responsibilities:

• Incorrect and incomplete information through available channels.
• Lack of traceability and reconciliation through the process flow.
• Error detection timeliness within the transaction flow
• Modified the Enrollment Reconciliation File content to send to the government using FileAid tool. The file format changes were to include the Termination enrollment indicator, paid through date, coverage year, and agent/broker information that were applied and delivered for all Plan Years. It involved reconciliation of major carriers such as Cigna, Aetna, United Health Care, and Kaiser.
• Participated in an ongoing multi-year project to deliver Maintenance 834s files to the government. Based on Industry feedback, the government acknowledged the need to utilize the standard EDI Maintenance transaction set, where only one 834 transaction is delivered.
• Created Easytrieve programs to update and report health coverage history from DB2 tables.
• Provided prompt resolution of production defects during daily run of batch and online processes.

Environment: IBM mainframe, z/OS, MVS, CICS, COBOLII, DB2, SQL, QMF, TSO/ISPF, JCL, FileAidSDSF, VSAM, Easytrieve/Plus.

Confidential, T ampa, Florida

Mainframe Software Developer

Responsibilities:

• Evaluated currency exchange functionality to produce technical design and applied new methodology for fees and taxes calculation on bank customer accounts in order to optimize profitability.
• Participated with production support in resolving discrepancies with new software version.
• Participated in the deployment of the latest Billing software version for Confidential bank.
• Added functionality to post to Intercompany GL accounts for certain Earning Credit activities in the Finance area of the Billing application for Confidential .
• Added a netting function based on the excesses and deficits calculated at the Service Charge Calculation levels of a relationship.
• Created several processes using Easytrieve/Plus to produce allocation of forwarded service charges reports for multi- month accounts.
• Modified the General Ledger process for the specified accumulators to be reported as individual entries from each of the contributing members.

Environment: IBM mainframe, z/OS, MVS, COBOLII, DB2, SQL, Expeditor, CMS, TSO/ISPF, JCL, SDSF, VSAM.

Confidential, Tampa, Florida

Senior Developer

Responsibilities:

• Evaluated high level specifications for 12 daily processes to identify the magnitude of impact to their functionalities in order to be documented and presented during a team review meeting.
• Acquired complete understanding of current batch and online functionalities to present a comprehensive overview of each functionality to the development team.
• Analyzed and maintained Assembler modules in order to comply with healthcare functionality changes.
• Produced and delivered detail designs, code changes, test case scenarios, and demonstrated test cases results satisfactorily.
• Performed extensive analysis of historical and current employee records from the Payroll system.
• Created a complex process to extract employee information from twelve DB2 tables to be used as input into a PeopleSoft environment with a 95% conversion rate and one month before the scheduled conversion date.
• Enhanced payroll software to apply detail information of personal days off taken by employees. It corrected the lack of supporting PDO detail data being applied to the General Ledger. It provided the capability of performing a complete PDO analysis at executive level, and eliminated a potential audit issue.

Environment: IBM mainframe, zOS, PL/1, COBOLII, DB2, SQL, QMF, TSO/ISPF, JCL, SDSF, ZEKE, Assembler, CICS, VSAM, FileAid, SCLM, Smart test, Windows 7, MS Office, Lync.

Confidential, Tampa, Florida

Business Analyst

Responsibilities:

• Provided a high level understanding of UL, ULV, VUL, annuity, and reinsurance products to enable a more accurate estimate of resources and time to complete the different phases of the conversion project.
• Generated job flowcharts and system interfaces documents to help understand the different aspects and complexity of the system

Environment: COBOLII, DB2, SQL, JCL, SharePoint, FileAid, Outlook, Windows XP, MS Office

Confidential, Tampa, Florida

Senior Systems Analyst

Responsibilities:

• Analyzed customer profile data bases to obtain a high level understanding of their content to migrate current Aepona provisioning system to SCM & CMP within Confidential .
• It involved identifying differences between source DB2 tables and target Oracle tables in order to provide reliable data model mapping documents.
• Analyzed Assembler and COBOL source code of billing applications to produce high level specifications to support a proof of concept presentation to executives for the Vision billing conversion project within Confidential .

Environment: COBOLII, PL/1, Assembler, DB2, Oracle, SQL, Lotus Notes, Windows XP, MS Office

Confidential, Bloomington, Illinois

Senior Systems Analyst,

Responsibilities:

• Performed analysis of a simplified Quote, Purchase, and Policy change processes to document potential modifications and allow customers to initiate changes and service their enabled State Farm auto, Universal life, Variable Universal life insurance products in a more user friendly environment.
• Promoted critical enhancements and implemented changes to rating/pricing/underwriting rules on core applications using Microfocus at StateFarm insurance companies to improve customer experience.

Environment: IBM S/370-3090, PL/1, zOS, COBOLII, DB2, SQL, TSO/ISPF, JCL, SDSF, VSAM, Cyberlife, Microfocus, Endevor, Lotus Notes, Windows XP, MS Office

Confidential, Tampa, Florida

Senior Mainframe Developer

Responsibilities:

• Installed source code and customized current processes to actualize latest version of billing software.
• Performed system restores and reruns across supported systems to ensure downtime was kept at minimum and to prevent major backlog.
• Analyzed and tested successfully multiple work-around processes to solve critical production abends.
• Researched and analyzed Assembler and COBOL source code to solve production issues saving time and resources to business and technical areas.
• Queried and updated DB2 tables in order to fix data discrepancies and keep data integrity.
• Created over 30 new processes coded in Easytrieve/Plus to produce credit and debit billing adjustments using historical data for customers that were over and under billed resulting in the recovery of over $600,000.
• Manipulated billing adjustment records utilizing FileAid to create VSAM files for easy retrieval.

Environment: IBM S/370-3090, IMS, CICS, zOS, COBOLII, Assembler DB2, SQL, SPUFI, QMF, TSO/ISPF, JCL, SDSF, FileAid, REXX, VSAM, INSYNC, CA-7, CA-11, Lotus Notes, Windows XP, MS Office, Outlook, EasyTrieve/Plus.

Confidential, Tampa, FL June 2007 to December 2008

Developer Consultant, Confidential

• Developed several new processes in the billing area of the Treasury and Security Services department for JPM Chase bank in order to comply with banking merger requirements.
• Designed and coded new online and batch programs for the Central Volume Router application to edit, validate, consolidate, and store account billing transactions in 8 new customer databases. Provided business area with detail and summary control reporting including daily account activity to business area via a web portal.
• Developed over 40 test scripts to comply with the business requirements.
• Performed software testing within the QA group. Included running jobs, troubleshooting and solving technical issues.

Environment: IBM S/370-3090, CICS, COBOLII, DB2, SQL, SPUFI, QMF, TSO/ISPF, JCL, SDSF, Expeditor, Changeman, REXX, VSAM, FileAid, Abendaid, CA-7, CA-11, ZEJE, Lotus Notes, Microfocus, Windows XP, MS Office, MS PowerPoint, Mercury Quality Control

CiberSites, Tampa, FL

Mainframe Developer Consultant

Responsibilities:

• Developed new functionalities to enhance application performance and identify market share and growth opportunities for the MOPAR Dealer inventory management system owned by Daimler-Chrysler Corporation. Analyzed specifications coded and tested Stored Procedures programs for the D2D connector dealer program involving 2,167 car dealers.
• Performed analysis, coding and testing for a major restructuring of ISBN information to entire Hartcourt publishing mainframe application. It included restructuring IMS databases, DB2 tables and converting all files containing ISBN information. Participated in modifying and testing 400+ COBOLII programs in DB2, IMS, and CICS environments. Provided support in peer review of code changes and testing results to ensure fully compliance of technical specifications.

Environment: IBM S/370-3090, COBOLII, IMS DB/DC, DB2, Stored Procedures, SQL, SPUFI, JCL, TSO/ISPF, SDSF, Expeditor, Changeman, Librarian, VSAM, OSAM, Easytrieve, FileAid, Abendaid, CA-7, CA-11, MS Outlook, Windows XP, MS Office.

Confidential, Tampa, FL

Systems Engineer Level IV / Software Engineer

Responsibilities:

• Performed development, enhancement, maintenance and production support involving coding, testing of programs to ensure full functionality of enhancements and modifications.
• Participated in a major project to add Confidential Wireless as a new carrier. Modified 30 existing and 10 new COBOL/DB2/CICS programs to retrieve, update and insert rows in 12 restructured and 2 new DB2 databases in order to capture and report market information.
• Provided web site enhancements using HTML, Java Scripting Language and Net.Data macros to issue system-direct access SQL to retrieve up to date carrier data from DB2 Databases.
• Produced approximately 20 detail designs and 30 general designs for two billing systems...
• Participated in the completion of a high level design to migrate 5M customer records from 2 states to a new billing platform. Consulted with Developers during testing to ensure on time migration with minimal customer disruption.
• Performed analysis and assessed client software requirements to determine magnitude of impact.
• Performed extensive DB2 queries of customer data for research to determine impact of enhancements and modifications requested by clients.
• Participated in high profile migration initiative to investigate and identify optimal system
• Provided design to migrate 8 million NY customers to a new footprint-billing platform.

Environment: IBM S/370-3090, COBOLII, DB2, IMS, SQL, SPUFI, QMF, CICS, JCL, JES, Assembler, SDSF, Expeditor, Tracemaster Endevor, VSAM, OSAM, FileAid, Insync, Syncsort, Abendaid, REXX, CA-7, CA-11, NDM, FTP, Smartest, Intertest, Bookmanager, HTML, JavaScript, Net.Data, Lotus Notes, Microfocus Express, Microfocus Cobol, Windows 98, Windows XP, MS Project

Confidential, Tampa, FL

System Test Lead

Responsibilities:

• Served as a group leader to perform testing for billing / settlement applications.
• Applied knowledge of detail and general designs to setup the appropriate test conditions and satisfy testing requirements using JCL, Abendaid and CA-11 to create processes, solve technical issues and rerun testing jobs.
• Participated in the Year 2000 conversion project involving testing entire applications.
• Developed work plans, Batch and Online test environments, testing tools, test cases, and identified selection of test data. Identified coding errors and coordinated with developers to create best possible solutions.

Environment: IBM S/370, COBOLII, IBM MVS, TSO/ISPF, SDSF, DB2, SQL, SPUFI, QMF, CICS, JCL, Assembler, Endevor, VSAM, OSAM, FileAid, Abendaid, Insync, Trace Master, CA-7, CA-11, Bookmanager, Windows 95, MS Office