Mario Palma

Summary

Total ** + years of IT industry experience having a Financial Market mainly on IBM Mainframe.

Experience developing, maintaining and supporting Mainframe applications Cobol, DB2, SQL, QMF, SPUFI, JCL, VSAM, BATCH, CICS, MVS TSO/ISPF, OS/390, z/OS, Altamira, Control-M, SCM, NDM, REXX, SYNCSORT, ICETOOL, Changeman, CA-Easytrieve, CA-Endevor, Remedy, JIRA, Slack, Wiki, Outlook.

Working mainly for banks (BBVA Bancomer, Citigroup Banamex, Santander, Bank of America, Insurance GNP) developing computer systems with activities such as Requirements Survey, Analysis, Design, Development, Interfaces, Testing, Debugging, Release, Documentation of integral solutions, Systems such as SAR, Afore, Management Systems, Fobaproa, Credit Cards, SPEI, Channels of Payment, Deposits, Mortgage, Loans and many more.

Consulting, knowledge and domain of SQL Server several Microsoft versions, Microsoft Office tools.

Knowledge of the market in government solutions and banking applications.

Dynamic person who uses creativity, leadership, experience and teamwork to design and execute solutions that creates value for the client.

Once requirements are finalized, participate in various SDLC phases – Coding, Unit Test, System Test, User Acceptance Test & Implementation

Effective communicator with the ability to create IT solutions, technology, businesses that convey value to both customers and end users.

Mentality of learning and growth.

Worked in the areas of analysis, design, development, test, production support and implementation phases of Cobol applications.

QA for Santander for 2 years, in the IBM Mainframe environment.

Business Analysis with Business Intelligence (BI).

Hands on experience TSO/ISPF.

Good Experience in developing in COBOL.

Experience in SQL and working with databases such as IBM DB2, SQL and MS SQL Server.

Good debugging skills that deep diving into technical issues, collaborating with cross-domain experts.

Unit testing and implementation of automation processes and tools.

Good understanding of Agile/SCRUM/SAFE meetings. TECHNICAL SKILLS

COBOL Programs development in Batch and On-Line processes. DB2 Knowledge and management of relational database (create, delete, update, consult tables, records, indexes, triggers, etc.)

VSAM Knowledge and management of VSAM KSDS, ESDS, JCL-IDCAMS (create, delete, update, consult VSAMs, records, define clusters, indexes, Repro, Listcat, Alter, Delete, etc.)

SQL Creation, Query, Update, Delete: tables, records and SQL language handling. CICS Program Development, Compilation, Debugging, BMS Management, Compilation, CICS Commands. CEDA, CECI, CEMT, CEDF.

MVS TSO/ISPF Mainframe environment management and its menus and commands. JCL Knowledge and management of jobs, creation of sequential files, VSAM indexed, not indexed, Sort, GDGs, Compile programs, Execute Programs, Check job exits, validate job steps, Utilities (IEBGENER, IEBCOPY, etc.).

Endevor/Changeman/

SCM

Systems Development Life Cycle, Version Control System. Control-M/CA-7 Schedule jobs, workload automation. Remedy Request facilities or releases to production. Easytrieve Development of programs with files and reports. REXX Coding of procedures, functions and TSO Commands. SCM SDLC (Software Development Life Cycle) Phases, Methodologies, Process, and Models.

SYNCSORT, ICETOOL Utilities (JCL) of OS/390, z/OS. JIRA Software development tool used by agile teams to plan, track and release software. IBM Developer for

z/OS (IDz)

Integrated Development Environment for the development and debugging of z/OS applications.

Education:

Experience Summary:

Company Location From To

IBM México Mexico City, México Oct - 2019 Till date Getronics Mexico City, Mexico May – 2011 Ago-2019

MPM Software Mexico City, Mexico Jun – 2006 Jan – 2011 Softtek Mexico City, Mexico Dec – 1997 Mar – 2006

IBM MÉXICO, S.A. DE C.V., Oct 2019 – Till date, Mainframe Technical Lead (Financial Sector) Description:

In this project we are working with the agile methodology and each 15 day sprint is with a USA bank in the credit card department, development, maintenance, testing, release, documentation of each task.

Ability to create and modify documentation pertaining to system processing.

Assists in the design, development, testing, implementation, and documentation of new software and enhancements of existing applications.

Work with System Development Life Cycle.

Analyze, design, code, test, debug, document and maintain programs. Responsibilities:

Cobol developer in batch, reports, read files, update files (Sequential and VSAM s).

Execution of JLC's as requested for process flows.

Understand the business process to modify the new task in the Jira, analyze the program(s), validate input and output files as well, or its structure.

Run JCL's inside the Control-M and validate that the executions are successful and if not see what the issue is.

EXAMINATION COLLEGE\UNIVERSITY YEAR GRADE

Bachelor Administrative

Computer Systems

UVM – University of Mexico's Valley

Mexico City, Mexico

1993 FC

Diploma in Banking and

Credit

ITAM – Autonomous Technological Institute

of Mexico

Mexico City, Mexico

1997 FC

Diploma in Business ITAM – Autonomous Technological Institute of Mexico

Mexico City, Mexico

1998 FC

Programs with Easytrieve.

Task assignment in the Jira software and move status as you go.

Test scenarios of possible cases or as required and document the evidence in the repository.

Participate in Scrum calls, Daily Stand Up, Backlog grooming, Iteration Planning and retrospective meetings.

Move the components in packages in the different environments of the SCM version control. GETRONICS MÉXICO, S.A. DE C.V., May 2011 - August 2019, Analyst Programmer (Financial Sector) Description:

The scope of this project is to send money by message to cell phone to withdraw money from the ATM and the project of (SPEI) Interbank Electronic Payment System.

Testing the volume of the application.

Meetings and coordination with other modules that require the catalog of products in the entity.

Progress meetings with the groups involved.

Manage and coordinate the client and business requirements.

Participate in Scrum calls, Backlog grooming, Iteration Planning and retrospective meetings. Responsibilities:

Cobol developer in batch, reports, read files, update files (Sequential and VSAM s).

Programming evolutives of applications.

Programs with access to DB2.

Battery of tests (different stages).

Data collection analysis.

Participate in Scrum calls, Backlog grooming, Iteration Planning and retrospective meetings.

Managing user requirements.

Move the components in packages in the different environments of the CA-Endevor version control. MPM SOFTWARE, S.A. DE C.V., June 2006 - January 2011, Administrator (Financial Sector and Government)

Description:

The scope of this project was the development of a system for the billing and collection of drinking water consumption for the municipalities of the state.

Development of Business Plans, Control.

Meetings and coordination with other modules that require the catalog of products in the entity.

Customer service improvements.

Deliver advances with the client.

Coordinated efforts with our company and other operating partners in all projects and planning. Responsibilities:

Cobol developer in batch and on-line, reports and files, access DB2, submitted JCLS s.

Validate that all models work correctly.

Managing user requirements.

Attention to current clients and potential in all technological aspects.

Technological support and information analysis.

SOFTTEK, December 1997 - March 2006, Analyst Programmer (Banking Sector) Description:

The scope were several projects with the client BBVA Bancomer bank were in the department of the Retirement, Savings System, ATMs, Management system, Payment Methods.

Meetings and coordination with other modules that require the catalog of products in the entity.

Customer service improvements.

Deliver advances with the client.

Coordinated efforts with our company and other operating partners in all projects and planning.

Coordinator of projects in different areas.

Supervision of correct achievements of proposed project controls.

Analysis of the user and solution of the problem.

Compose the future stages of the project and the new requirements.

Control of the performance of the personnel.

Creation of personnel evaluation techniques.

Responsibilities:

Cobol developer in batch and on-line, reports and files.

Validate that all models work correctly.

Managing user requirements.

Experience with Cobol.

Experience with JCL.

Experience in mainframe application architecture.

Analysis, Design, Development and Test using COBOL, CICS, JCL, SQL, and DB2.

Debugging, implement, and support moderate-to-complex programs.

System maintenance and development.

Product support.

System documentary.

Process flow make-up.

Database model design.

Project specification make-up.

Management of users.

Mainframe IBM, DB2 and use and coordination of Cobol.

Use and coordination of CASE tools.

Design of flowcharts.

Unit tests and integral systems.

Move the components in packages in the different environments of the Changeman version control. Technical Platform:

Cobol, DB2, SQL, QMF, SPUFI, JCL, VSAM, BATCH, CICS, MVS TSO/ISPF, OS/390, z/OS, Altamira, Control-M, SCM, REXX, SYNCSORT, ICETOOL, Changeman, CA-Easytrieve, CA-Endevor, Remedy, JIRA, Slack, Wiki.

Achievements:

1. Participation in the analysis, design, development of a solution in the financial market, called "SPEI"

(Interbank Electronic Payment System) I participated in the design with the treasurers of all the banks in Mexico in the ABM (Association of Banks of Mexico) (2001). 2. Managed several large development projects on Client-Server and IBM Mainframe platforms. Participation in the development of the SAR system, AFORE, Management System for BBVA Bancomer bank, recognition and publication in the newspaper (1998). 3. Postgraduate with emphasis in Banking, Finance, Business, Technology and Entrepreneurship (1997- 1998).

4. Systems consultant since 1997, designed computer systems for banks, for example, Bank of America

(buying and selling dollars between London and Mexico City), Participation in the development of the

“Fobaproa” system in banking, IBM system Mainframe (2005). 5. Designed the main IT systems for the government in the specific management of the Billing and Collection of Drinking Water Supply and Sewerage for Municipalities of Mexico, commercialized and implemented in several municipalities (own development) (2003). 6. Implemented controls (QA) in software development in Serfin-Santander bank in 2000, created the protocols for release of systems in production, before 2000 there was no control, therefore, there were many problems at the time to launch the systems in production. Quality Assurance functions

(2000).

Certifications:

1. Completed “SCRUM Master Certification” on 07/2019. 2. Completed “COBIT Foundation Certification” on 24/09/2015. 3. Completed “ITIL Foundation Certification” on 06/2015. 4. Completed “DevOps Essentials Certification” on 05/2020. 5. Completed “Design Thinking” on 06/2020.

6. Completed “Management 3.0” on 06/2020.

7. Completed “Lean Change Management” on 07/2020.

8. Completed “Product Owner” on 07/2020.

Courses:

1. Completed “PMP Courses” on 07/2015.

2. Completed “Cobol Workbench GUI for Mainframe Course” on 04/1996. 3. Completed “Micro Focus Course” on 02/1995.

4. Completed “CA-Easytrieve Course” on 10/2018.

5. Completed “IMS-DB DL/I Course” on 01/2019.

6. Completed “CA-Endevor Course” on 03/2019.

7. Completed “Changeman Course” on 11/2018.

8. Completed “Control-M Course” on 11/2018.

9. Completed “JIRA Software” on 12/2019.

10. Completed “REXX” on 01/2020.

11. Completed “DevOps Essentials” on 05/2020.

12. Completed “Design Thinking” on 06/2020.

13. Completed “Management 3.0” on 06/2020.

14. Completed “Lean Change Management” on 07/2020. 15. Completed “Product Owner” on 07/2020

16. Completed “CA-7 Workload Automation” on 09/2020 17. Completed “Leading SAFE 5.0” on 09/2020

Contact this candidate