Mainframe Applications Developer

Bilingual Systems Specialist with experience in IBM mainframe and data base administrations. Designed, developed, implemented, and tested systems in the financial, administrative, human resources, inventory, stocks, and production control areas. Over 18 years experience with relational data structures, theories, principles, and practices. Demonstrated skills in business and technical analysis, testing, and quality assurance. Recognized for strong problem solving skills. Comprehensive knowledge and understanding of Data Warehouse sign principles. Can proactively identify, troubleshoot, and resolve complex data integrity issues.

Mainframe Application Development strengths include:

• 30 years of COBOL, Assembler-HL BAL and Easytrieve
• 3 years of PL/I, Natural and ADABAS
• 30 years of CICS
• Expert in Credit Cards, Bank and Manufacturing Industries Design, Development and Implementation
• 10 years giving support for Operation System Support as a Software Support
• 30 years in IMS-DB Administrator Hierarquical databases and VSAM
• 20 years in DB2 Relational Data Bases
• SQL coding, queries, index, and database IO performance tuning, Capacity Efficiency
• Over 20 years experienced with ROSCOE, TSO, XPEDITER, CA-7, FILE-AID, CA-VIEW, ABEND-AID, etc
• 10 years working with low Platform COBOL Microfocus, Microbase
• 12years experiencedefining test strategy for all applicable phases of the SDLC Software Development Life Cycle , including test scenarios/acceptance criteria, etc.
• Strong experiencemanaging multiple tasks simultaneously and prioritize tasks accordingly
• Development in Micro Platform using Visual Cobol like Microfocus/Microsoft Cobol
• Intermediate in SAS, REXX, Java, .NET, SQL SERVER Microsoft certified , etc
• Delivers quality and timely results, i.e., technical and customer support, based on company business needs and objectives.
• Identifies and resolves complex technical problems and issues with assigned applications and work processes. Escalates problems beyond level of expertise to manager, more experienced technical staff or vendor representatives

Technical Profile

Databases: DB2, SQL, IMS DB/DC, VSAM Teleprocessing: CICS, VTAM, BTAM, BMS, GTB, NERDO, OMEGANON

Languages: COBOL2, Assembler-HL, Easytrieve, SAS, REXX, PERL,Java, 3GL, 4GL, .NET

Operating Systems: Z/OS, MVS/ESA, OS/VS1, DOS/VSE, VM, internal transients, I/Os

Third-Party Software: MS Office-2010, Lotus Notes, Sametime, Outlook Extended Visio, Peregrine system and SDM, IOC, EURC, ECM, PKS, ACR, CMM, OFFICER 2000-2012, JAVA and SQL SERVER 2000-2012 Microsoft certified , Lotus Notes, Peregrine, ECM, EURC, IOC/SDRS, PAR, ACR, VISIO, EIRDS,EDGAR, ROSCOE, etc.

Technical Competencies

• Over 22 years of experience with relational data structures, theories, principles, and practices
• Worked with current extractions and transformation processes
• Mastered stored procedures, SQL coding, advanced queries, indexed database IO performance turning for DB2
• Obtained comprehensive understanding of Data Warehouse design principles

Mainframe Business Systems Development Experience

• Defined system strategy and development of system requirements, design, prototyping, testing, support procedures, and implementation of custom technology solutions
• Engaged in full cycle implementation
• Automatic routines to generate test environments for JCL Job Generation, GDB Base Generation, and PDS Members Copy
• CA7 AUDIT and CROSS REF system
• AUTOMATIC ANALISE AND REDUCTION FOR COBOL PROGRAM codes PERFORMANCE IMPROVEMENT
• CICS TABLES AUDIT and CROSS REF system
• Automatic DASD CONTENTION detection automatically every day to avoid jobs to delay a long time to run.
• IBM Mainframe JCL AUDIT and CROSS REF system
• Evaluated and recommended new/improved processes and technological innovations as per client specifications Special Software Packages Developed and Implemented
• Performed functional and system analysis, feasibility studies and design studies
• LOADLIB, SOURCELIB, COPYLIB and CNTLCARD members automatic check up and RETROFIT control
• Automatic source COBOL, Assembler, PL/I and Natural Source programs Extraction,Audit and XREF
• Unit Level Testing Routines for IBM Business System Environment Jobs
• Automatic ICF VSAM catalogs Extraction, Audit and XREF
• Automatic VSE and MVS/Z-OS JCL Extraction, Audit and XREF
• Intercontinental Communication System for Brazilian Central Bank like DTC developed and implemented using CICS, COBOL2, Visual Basic, DB2, VSAM and Assembler Language

Experience

Confidential

Applications Support Analyst/AVP

• Tuned and supported systems development with CICS/VSAM resources to obtain better performance for online and batch applications in Custody systems
• Analyzed data bases to solve performance problems connected with the improvement of data access
• Adapted own software audit system for mainframe data processing to automatically prepare the Impact Analysis, Master Element List, and Work Load reports for system maintenance and upgrades
• Developed and maintained new routines for custody systems using Assembler, COBOL, Easytrieve, and SAS languages involving unit and individual tests, walk-through, and documentation preparation in order to move into production usage incorporated usage of Endeavor, TSO, Xpediter, CA-7, ABEND-Aid, CA-View, SDR, File-Aid, Omeganon, BMS GTB , ACR, Lotus Notes, Outlook, Peregrine, EURC, NERDO, and others
• Developed and maintained business system work load calculations for the Treasury and Securities Systems department
• Provided support to system analysts and programmers
• Provided on-call support to solve batch and online issues for internal users
• Recommended and changed based on contention analysis batch routines to save run times and overriding JCLS automatically.
• Implement CICS new regions for Treasure Department.
• . Solved contention problems for daily batch critical path writing two new assyncronous transactions conversing which could be invoked by batch programs thru CICS EXCI resource.

Confidential

Technical Credit Card System Support Consultant

• Provided assistance in Integri Americas products for new clients to implement hardware and software for credit card test simulator and payment system
• Conducted hardware and software technical presentations for Credit Card Support Department

Confidential

Applications Developer

• Developed batch and online programming communications with Stratus platform to receive and process information about Credit Card inquiries authorizations, declines, referrals . Extremely complex system which required working with scripts and high level of concentration to avoid errors.
• Implemented Peregrine System and SDM Methodology to control all project phases.
• Controlled test scripts and walk-throughs to check changes and resources being implemented or unit tested for complete results
• Retrofitted controls to maintain several versions for the same system, module, or program level
• Prepared master plan/master element list in order to follow up on all phases of project
• Solved complex online abends through the use of debugging tools ABEND-Aid and XPEDITER
• Implemented Data Processing Audit, Control, and Cross-Reference System to prepare impact analysis, work load, and master element lists in order to install new releases for Sungard Package
• Implemented automatic test JCL batch routine to include compare steps and overriding of JCLS automatically saving hundreds of labor hours.

Confidential

System and Applications Programmer

• Developed and maintained hundreds of Assembler, COBOL, and CSP programs using IMS-DB and DB2 for accounting area
• Adapted and implemented new IRS Tax Routine with annual changes for shared interest and profits
• Coded and tested several CSP/AD programs for accounting
• Used STROBE, ABEND-Aid, and EXPEDITER to solve performance and production abends
• Adapted and Implemented Data Processing Audit, Control, and Cross-Reference System

Confidential

and Assembler programs Implementation of Y2K for financial Industry projects Automatic Conversion like IMS-DB to DB2, COBOL/VS to COBOL2, SDF to BMS Maps, CSP/AD to VISUAL-AGE, etc.

Confidential

Communication System BIR to provide connections between Industries and finance Corporation with global DUN BRADSTREET mainframes installed in all continents allowing the flow of commercial/financial Information, using MVS, TSO, ISPF/PDF, CICS,COBOL2, DB2 and VSAM from overseas companies to guarantee import and export transaction between Brazil and all DUN BRADSTREET connected countries.

Confidential

Manager responsible for System Analyzes, Development, Unit Test and implementation for several business systems developed for factories chemical industry, supermarkets, shops and others . Over 1,400 Cobol programs developed under my responsibility and management with Visual Cobol like Microfocus/Microsoft .