SUMMARY

• A mainframe information systems professional with over 20 years experience in the areas of finance, brokerage, manufacturing and airlines computer applications
• Extensive experience with CONFIDENTIAL, IMS, DB2, VSAM, CICS, JCL, EASYTRIEVE PLUS, IDMS, ADSO, OLM, IDDL, CULPRIT. TSO/ISPF MVS, ROSCOE and VM editors
• Strong software development analysis and design skills on IBM mainframe platforms, fully familiar with Software development Life Cycles, materials control, bill of materials, material explosion systems, payrolls, inventory, accounting, accounts payable and accounts receivable systems
• Character, reliability and determination to get the job done
• Organized, efficient and pr cised with strong communication and liaison skills
• Decisive and direct, yet flexible in responding to constantly changing assignments
• Skilled in planning and execution of special production projects during time-critical assignment
• Able to coordinate multiple projects and test stages meeting deadlines under pressure
• Enthusiastic, creative and willing to assume increased responsibility
• Attention to details and strong follow through
• Proficient in writing Techniques applied to application program and final user system documentations, system standards
• Good foundations on VB6/Access/SQL Server 6.0 developer with excellent communications skills with clients, vendors and team members. Strong presentation and interviewing skills
• Bilingual: English and Spanish

TECHICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Technicale writer

My first assignment was to convert a whole batch conciliation banking application from RPG II into CONFIDENTIAL VSAM CICS-BMS programs consisting of some 35 programs as part of this re- engineering some programs were taken out of commission and replaced by online ones, such as check in circulations needed to be cancelled and others. Reports were written in CONFIDENTIAL as well, since the client wanted each one of the old RPG programs to become one CONFIDENTIAL. Once done with this assignment I stayed in Hacienda providing support for the Puerto Rico Income Tax System PRITAS . This big application is the heart of the Local Government Income Tax collection system for individuals and corporations. Its application programs are written in CONFIDENTIAL/DB2/CICS using the old Andersen Consulting Install/1 platform. Easytrieve was widely used for reporting due to its flexibility to interact with DB2. A few satellite applications are written in NATURAL/ DB2. Frecuently I had to modify, test and promote into the production environment a application programs as needed via task request solicited by the user.

Confidential

Senior IT Consultant / Applications Developer / Technicale writer

Confidential at this client site was to write the specifications in pseudo code for each one of the application programs involved in the processing of producing statistics, line connections, disconnections, billing and invoicing reports that need to get into the SIF interface Integrated invoice solution package . I had to write CONFIDENTIAL-VSAM in order to convert and migrate mainframe data into the application server running Java API as part of the new invoicing solution.

Confidential

Senior IT Consultant / Applications Developer

• My role at this client site was to write a series of EASYTRIEVE programs using VSAM KSDS, ESDS and create flat files and to populate DB2 tables already defined and in place for the Medicare part B information to be migrated for the Claims Vision project.
• EASYTRIEVE was the language of choice at this client site in combination with DB2 and VSAM files.
• Other duties were to create the necessary procedures, JCLs and thorough testing of these programs.
• Analysis of the data selected and revision of the data reports generated.

Confidential

Senior IT Consultant / Applications Developer

Confidential duty at this client site was to be trained and learned the business to be a back up for the senior analyst in charged of this application. My role was to provide maintenance and support for the mainframe applications like the Isuzu credit, PO Campaigns Recalls on vehicle parts and Repair Order printings RO Printings among others. These applications use IMS/DB/DC, DB2 with Confidential

• This project involved modification of the various CICS/Confidential programs as well as DBS maps and DB2 Tables used in the process of calculating and maintaining the information related to the paid, freed or reduced lunches for the students of the schools in the Miami Dade County.
• This endeavor included Modification of NATURAL written programs and expansion of intermediate files, ADABAS/DB2 files, JCL, PROC and daily schedule jobs as well as Support reporting mostly written is EASYTRIEVE Plus.
• Other activities at this client site dealt with daily maintenance of the COMPASS and FUEL systems, which were applications that supported maintenance for schools busses and police school patrol vehicles.
• Presented an impact analysis of the DB2 tables and views involved.
• Designed and programmed changes for CICS BMS screens.
• Analyzed changes for NATURAL Structured and reporting programs for the add amounts CENTS.
• Modified NATURAL Screens and Reports with the Income amounts showing the CENTS.
• Wrote modification code for batch and On Line programs.
• Applied changes to Easytrieve report programs.
• Scheduled complete and sound testing for user approval.
• Prepared documentation of the project.

Confidential

Senior IT Consultant / Applications Developer

• My first role at this client was to analyze the existing identification cards issuance system as well as the claims and subscription systems in order to get acquainted with the applications and the HIPAA regulations in order into stop using social security numbers as contract numbers.
• Once this project was finished I did maintenance activities to this and other applications at TRIPLE SSS Health Insurance.
• Designed new CICS BMS screens to crossed reference new and old contract numbers.
• Write new CONFIDENTIAL CICS programs in order to generate new contract numbers.
• Write on Line CONFIDENTIAL/CICS VSAM inquiry programs for the crossed reference master File.
• Apply changes on EASYTRIEVE PLUS reports, and write new reports using EASYTRIEVE PLUS programs.
• Performed day by day maintenance of programs, reports, JCL and procedures for batch applications

Confidential

Senior IT Consultant / Applications Developer

• Modified existing application programs to process the new area codes.
• Expanded and preparer VSAM master files to carry the new area codes.
• Similar approach as above with additional programmers analyzed and developed the remaining applications.
• Responsible for converting files and tune up program codes written in CONFIDENTIAL using VSAM and IDMS Batch and ONLINE ADSO, ADSA, IDDL, OLM, DMLO, OLQ Dialogs in order to carry and access the new Area codes throughout the RSB, NENA and OSADIA Customer Service Orders and billing application systems.
• Wrote new programs in order to convert old data to the new area code data.
• Modified Online BMS maps in order to work with the new area codes.
• Modified reports and invoice applications in order to show the new area codes.
• Modified IDMS/ADS Database records, maps and dialogs in order to work with the area codes.
• Modified batch JCL and procedures.

Confidential

Senior IT Consultant / Applications Developer

• My role in the Department of Labor DOL team site was mostly maintenance of job request applied to the various applications to the GMGroup Consulting department outsources for DOL.
• Modified all existing tables, online and batch CONFIDENTIAL/CICS programs in order to increment the unemployment insurance benefit from 54 to 72 days.
• Developed a manual entry system into an ONLINE application written in CICS-Web enable approach using DB2 tables and VSAM-KSDS files.
• This application was an online data entry system providing 3270 data screens accurate validation routines and a Batch interface composed of detail transaction reports, file back-ups maintenance and JCL modules.
• The transactions handled by this application were employee maintenance records, holidays, sick, on leave, holidays and worked hours in records called TALLY Records.
• Accounting transactions records were later added to the process.
• User training manuals, user system documentation and application program directives were written for this system as part of the whole endeavor.
• Expanded/modified tables in order to change the unemployment benefits from 54 to 72 days.
• Modified the code of the existing programs to agree with the new benefit changes.
• Modified reports and special forms in order to print the new benefit changes.
• Modified and tested JCL and batch procedures.
• Designed new BMS maps and VSAM files in order to process and control time and tally cards.
• Wrote new CONFIDENTIAL/CICS web enabled programs for the time/tally cards applications.
• Wrote user manual and GM-Group documentation.
• Prepared and conducted client site testing, evaluation and approval

Confidential

Senior IT Consultant / Applications Developer

• This project implied a thorough analysis of an existing DB2 database tables as well as a complete reprogramming of the outdated CONFIDENTIAL modules. A complete refurbish of the MRA system was necessary due to the inadequate handling of the data and undocumented updates to the source code rendered a great deal of this code useless.
• Responsible for the conversion into ADABAS/NATURAL in order to suit the RMA needs at SAI Systems head quarters in Hyderabad, India composed of DIGITAL Computers
• Developed a data capture application using INTERNET Web pages data capture and SQL-Server 7.0.
• Performed DB2 RMA Tables analysis.
• Wrote and modified existing Natural/ADABAS programs.
• Converted DB2 finished and returned tables into ADABAS.
• Designed data and process flow for the RMA project.
• Designed, generated and populate a MSSQL/Server database.
• Designed CSS, fonts and graphics for the RMA application.
• Wrote new web program pages using HTML, ASP and JavaScript.
• Designed and conducted INTRANET testing.
• Documented the new application and wrote users and contingency manuals.

Confidential

Senior IT Consultant / Applications Developer

• Analyzed a financial application written in RPG II since RPG II was no longer supported by IBM Mainframe Platforms this Conversion was a compulsory issue for the client in order to keep their application to convert to CONFIDENTIAL II
• Studied and analyzed the programs written in IBM RPG II to present a work plan including cost, duration and approach to tackle the conversion.
• Responsible for the coding of new CONFIDENTIAL II batch programs.
• Performed tests, created documentation and acquired final user's approval.

Confidential

Senior IT Consultant / Applications Developer

• Responsible for studying a Mutual fund financial application for LORD ABBET, known as HYPOTHETICAL INVESTMENT STUDIES.
• This application required an in-depth study due to the lack of documentation and analysis.
• The objective was to produce a complete and sound spec document for migration of the application from AS/400 to a VB6 application
• Analyze and review the existing HIS application on an AS/400 system.
• Designed a project cost, data process and data flow plan for the new application.
• Re-programmed the application on the local Network using VB6, MSSQL/Server 7.0 and Crystal Reports.

Confidential

Senior IT Consultant / Applications Developer

• Conversion into the CONFIDENTIAL II/MVS VM 1.2.1 IBM compiler
• My job in this project was to keep track, analyzed and supervise the Windowing Y2K changes coded into existing CONFIDENTIAL programs by a team of offshore programmer based in India.
• Coordinated the various approaches in order to carry out the VSP/PFM code conversion.
• Coded revision and replacement of obsolete CONFIDENTIAL statements.
• Performed testing and documentation of the encountered problems and remedial applied.

Confidential

Senior IT Consultant / Applications Developer

• Campaigns and production Y2K Conversion
• My responsibility at this client site was to apply the windowing Y2K approach to CONFIDENTIAL/CICS/ DB2 applications as well as conduct testing of the changes. The changes were done using Micro Focus CONFIDENTIAL in a PC and were migrated and tested in the mainframe.
• Performed analysis of CICS screens and reports for Y2K changes.
• Performed analysis of DB2 tables for Y2K changes.
• Prepared test case scenarios.
• Presented and acquired user's approval.