09/06/2022 updated

**** ******** ****
100 % available

Senior Mainframe Developer/Consultant

Cascais, Portugal
Portugal
Cascais, Portugal
Portugal

Profile attachments

CV - João Batista Aguiar da Silva

CobolJavaMainframeMS AccessCICSdb2Mainframe COBOL CICS DB2 developer
I have been working with COBOL and COBOL/CICS for the last 36 years. Born in Brazil, I came to Portugal in 1991, where I live until now as naturalised citizen.

On the last 6 month I've been working in a project for tuning and optimisation of COBOL/CICS programs and services to reduce the average processing time and also reduce the client's Homebanking Net availability.

For the previously 4 years I have done the migration and rewrite of COBOL/CICS applications generated by the AGL Principia Code Generator. Rewrite of the encapsulated IBM MQSeries API from C to COBOL routines. 
Rewrite and adaptation of Account Maintenance workflow to allow automate treatment without human intervention.

For the previous years I have been working for several companies where I played the following roles and functions:
  • Acceptance tests and requisites validation;
  • Functional and technical analysis;
  • Maintenance, redesign and development of applications and COBOL/CICS programs as back-end SOA services;
  • Migration and integration of mainframe applications.
  • Redesign and implementation of batch routines; 
  • Design and development of Java Programs and APICs as Middle-Tear for COGEN (insurance package) COBOL/CICS BackEnd;
  • Design and development of Java Programs for NetBanking and MIFID questionnaires, for mainframe BackEnd integration;
  • Maintenance of PL/I Programs of the KORVAS (Ceding Reinsurance package, from MSG Systems AG-DE);
  • Development Access and Excel solutions (Macro and VBA routines) connected to DB2 Mainframe Databases.



Mainframe OS Systems:
  • VSE, MVS /ESA - Specialist - 36 Years

Databases:
  • DL/I, Specialist - 6 Years, Professional Experience 
  • IDMS, Specialist – 4 Years, Professional Experience
  • DB2, Specialist - 28 Years, Professional Experience 
  • MS Access, Specialist - 20 Years, Professional Experience

Mainframe Development Languages:
  • Cobol/CICS, Specialist - 36 Years, Professional Experience 
  • CSP e CSP/SQL, Specialist - 3 Years, Professional Experience
  • PL/I, Independent - 3 Years, Professional Experience 
  • Mantis, Independent - 2 Years, Professional Experience 
  • Easytrieve, Intermediate - 3 Months, Professional Experience 

Non Mainframe Development Languages:
  • Python, Independent - 8 Years, Professional Experience 
  • C, Junior – 4 Months, Professional experience
  • Java, Intermediate - 5 Years, Professional Experience 
  • MS Access (VBA), Specialist - 20 Years, Professional Experience

Languages

EnglishFluentPortugueseNative speakerSpanishGood

Project history

Analyst Programmer

Bankinter, by Sucesso Simultâneo, Lda

Banking & Financial Services

- Maintenance, redesign, retrofit and tuning of applications and programs with high CPU usage
levels, looking for a significant reduction of CPU usage and resources.
- Maintenance, redesign, retrofit and tuning of applications and programs with high CPU usage
levels, looking for a significant reduction of downtime of Net services (Homebanking).

Technologies:
Cobol/CICS, DB2, SQL, Spufi, VSAM, JCL, TSO, Excel

Analyst Programmer

BNP Paribas

Banking & Financial Services

- Migration (rewrite) of COBOL/CICS/IDMS applications generated by AGL Principia.
- Design, development and implementation of COBOL applications to treat MT599 SWIFT
messages (free text). Those MT599 messages consists in account creation, update or close
solicitations. Creation of a message workflow with the extracted (parsed and interpreted)
solicitations. Integration with the Account Application by manual intervention or automatic treatment
to execute those solicitations. Automatic treatment of the correspondent client messages, by text or
SWIFT email.
- Design, development and implementation of a COBOL module to encapsulate the IBM MQSeries
API (as a deprecated C application replacement).
- Account management application update to allow automatic treatment. The development of
service modules with those application functionalities.
- Development and implementation of COBOL/CICS (IDMS or DB2) applications in BDT and SCC.

Technologies:
* Cobol/CICS, IDMS, DB2, SQL, Spufi, VSAM, FileAid, SPITABS, MQSeries, JCL, TSO, C,
Excel, MS Access, Principia

Analyst Programmer

Barclays Bank

Banking & Financial Services

- Maintenance, redesign, retrofit and tuning of applications and programs with high CPU usage
levels, looking for a significant reduction of CPU usage and resources.

Technologies:
* Cobol/CICS, DB2, SQL, Spufi, VSAM, FileAid, JCL, TSO, Excel, MS Access

Functional Analyst

Barclays Bank Portugal

Banking & Financial Services

1




- Acceptance tests and requisites validation of SEPA for Corporate application, developed by SIBS
Portugal for Barclays Bank.
- Acceptance tests and requisites validation of financial transference files for clients.
Tests and validation of SEPA Transactions procedures (Net and Mainframe) developed in Barclays
Bank.
- User guides creation for new SEPA procedures in Mainframe applications and for SEPA for
Corporate application.

Technologies:
* Cobol/CICS, DB2, SQL, Spufi, VSAM, FileAid, JCL, TSO, MS Office, Web Services.

Analyst Programmer

Barclays Bank

Banking & Financial Services

- Development and adaptation of Cobol/CICS applications as back-end SOA services to new Net
Banking Application.
- Development and adaptation of Cobol/CICS applications as back-end SOA services to MIFID
Questionnaires module.

Technologies:
* Cobol/CICS, DB2, SQL, Spufi, VSAM, FileAid, JCL, TSO, Java, Web Services.

Analyst Programmer

Caixa Geral de Depósitos, by ITIL4G, Lda.

Banking & Financial Services

- Maintenance, redesign and development of applications and COBOL/CICS programs.

Technologies:
* Cobol/CICS, DB2, SQL, Spufi, VSAM, JCL, TSO, Excel.

Analyst Programmer

Barclays Bank

Banking & Financial Services

- Maintenance, redesign, retrofit and tuning of applications and programs with high CPU usage
levels, looking for a significant reduction of CPU usage and resources.
- Maintenance, redesign and development of applications and COBOL/CICS programs as services
to a Lombardi (IBM) front-end. Loans Systems.

Technologies:
* Cobol/CICS, DB2, SQL, Spufi, VSAM, FileAid, JCL, TSO, Excel, MS Access, SOAP-UI,
MCSP

Analyst Programmer

Grupo Caixa Seguros; Inf. e Serv. Lda

Banking & Financial Services

- Development and maintenance of applications of the Outputs System.
- Maintenance and development of Cobol/COGEN applications and Cobol as SOA services for the
Finances System.
- Maintenance and development of Cobol/COGEN applications and Cobol as SOA services for the
Entities System.

Technologies:
* Cobol/CICS, VSAM, DB2, COGEN, MS Access

Functional and Technical Analyst

TAP Air Portugal

Industry & Mechanical Engineering

- Functional and technical analysis of the Calibrations Tracking and Operation Control System for
TAP Air Portugal's Calibration Laboratory.
- Functional analysis of the Fleet Reliability and Ship Maintenance Module.

Technologies:
* AllFusion/Gen, Cobol/CICS, DB2, SQL, Spufi, JCL, TSO, PHP

Analyst Programmer

Portugal Telecom

Telecommunications

- Development and maintenance of Billing's pricing plans system.
- Design, development and implementing applications in MS Access and DB2 for Pricing Plans
migrations.
- Development, maintenance and production monitoring of Finishing Invoice Management
application (TMN and TV Cabo).

Technologies:
* PPDS, Cobol/CICS, DB2, SQL, Spufi, VSAM, FileAid, JCL, TSO MS Access, Python

Analyst Programmer

Companhia Seguros e Pensões (Grupo BCP); V Estações, Inf. e Serv. Lda

Insurance

- Migration and integration of Ceding Reinsurance System from the Group's Companies to and
unified system.
- Cogen 4.1 Co-Insurance Module retrofit.
- Maintenance and development of Java Services and Cobol/CICS/DB2 Apics. SOA services in
Cobol.
- Maintenance and development of applications for the Policies/Health Module.
- Maintenance and development of applications for the Output System.

Technologies:
* COGEN 4.1, Java, Websphere, JBO (Java layer) and Cobol/CICS back-end
Korvas (MSG Systems AG), Cobol/CICS, DB2, SQL, Spufi, VSAM, FileAid, JCL, TSO
*

Analyst Programmer

Cia. Seguradora império, by V Estações, Inf. e Serv. Lda

Insurance

- Development and maintenance of applications of the Retirement Account Savings System.
- Development and maintenance of applications of the Claims System.
- Development and maintenance of applications for Report Dematerialization in Reinsurance
System.
- Development and maintenance of applications for Ceding and Accept Reinsurance System.
- Development and maintenance of applications for the Reinsurance's automatic accounting in the
Millennium package.
- Monitoring Korvas (Ceding Reinsurance package, from MSG Systems AG-DE).

Technologies:
* Cobol/CICS, DB2, SQL, Spufi, VSAM, JCL, TSO, MS Access
* Korvas (MSG System AG), PL/I

Analyst Programmer

UBP - União de Bancos de Portugal, by Réditus Consulting S.A.

Banking & Financial Services

- Development and maintenance of applications in the Current Account and Card Systems.

Technologies:
* Cobol/CICS, DB2, SQL, Spufi, VSAM, JCL, TSO

Analyst Programmer

Seguradora Portugal Previdente; Réditus Consulting S.A.

Insurance

- Development and maintenance of applications in the Claims Systems.
- Redesign and implementation of batch routines of the Claims Systems.

Technologies:
* Cobol/CICS, DL/I, VSAM, JCL, CORTEX, TSO

Analyst Programmer

CTT e Carris, by Megasis - Serv. de Eng. Inf.

Other

- Development of the Carris Lisbon's Uniform Control System.
- Development of the CTT's International Account System Module.

Technologies:
* Cobol/CICS, VSAM, JCL, TSO
* CSP/SQL, Cobol2 Workbench Microfocus

Analyst Programmer

Cia. de Seguros Império, by ECS, Sist. de Inf. S.A.

Insurance

- Development and maintenance of applications of the Retirement Account Savings System.

Technologies:
* Cobol/CICS, DB2, SQL, Spufi, VSAM, JCL, TSO

Analyst Programmer

Direção Processamento de Dados, S.A.

Internet & IT

- Development and maintenance of applications of the Human Resources System.
- Human Resources user's support and monitoring.
- Development and maintenance of applications for the Dobra Tabacos Company.
- Conversion and migration of APL/DI applications to Cobol/CICS.

Technologies:
* Cobol/CICS, VSAM, DB2, SQL, Spufi, JCL, TSO
* CSP, e CSP/SQL, APL/DI

Programmer

Grupo Gerdau

Industry & Mechanical Engineering

- Development and maintenance of applications in the Stocks System.
- Development and maintenance of applications in the Accountant System.
- Application conversion from VM/SP to MVS/XA.
- Development and maintenance of applications in the Information Management System.
- Development and maintenance of applications in the Supply and Sales System.

Technologies:
* Cobol/CICS, DL/I, VSAM, JCL, VOLLIE, ROSCOE
* Mantis, EasyTrieve

Programmer

Banco Maisonnave

Banking & Financial Services

- Development and maintenance of applications in Current Accountant System and Financial
Investment System.

Technologies:
* Cobol/CICS, DL/I, VSAM, JCL, ICCF, TSO/ISPF

Programmer

JH Santos, Indústria e Comércio

Goods & Retail

- Development and maintenance of applications in Account and Supply System.

Technologies:
* Cobol/CICS, DL/I, VSAM, JCL, ICCF

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in