Upgrade Post project
Profileimage by JooBatista AguiardaSilva Senior Mainframe Developer/Consultant from Cascais

João Batista Aguiar da Silva

Cascais
available

Last update: 06.09.2022

Senior Mainframe Developer/Consultant

Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Full Professional) | Portuguese (Native or Bilingual) | Spanish (Limited professional)

Keywords

Attachments

JBCV_(2020)-en.pdf

Skills

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

Project history

06/2019 - 12/2020
Analyst Programmer
Bankinter, by Sucesso Simultâneo, Lda (Banks and 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
07/2015 - 12/2019
Analyst Programmer
BNP Paribas (Banks and 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
01/2014 - 11/2015
Analyst Programmer
Barclays Bank (Banks and 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
01/2013 - 11/2014
Functional Analyst
Barclays Bank Portugal (Banks and 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.
01/2014 - 03/2014
Analyst Programmer
Barclays Bank (Banks and 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.
01/2013 - 09/2013
Analyst Programmer
Caixa Geral de Depósitos, by ITIL4G, Lda. (Banks and financial services)
- Maintenance, redesign and development of applications and COBOL/CICS programs.

Technologies:
* Cobol/CICS, DB2, SQL, Spufi, VSAM, JCL, TSO, Excel.
05/2012 - 01/2013
Analyst Programmer
Barclays Bank (Banks and 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
05/2008 - 12/2011
Analyst Programmer
Grupo Caixa Seguros; Inf. e Serv. Lda (Banks and 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
01/2008 - 11/2008
Functional and Technical Analyst
TAP Air Portugal (Industry and 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
01/2004 - 05/2008
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
01/2000 - 01/2004
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
*
01/1995 - 06/2000
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
05/1994 - 01/1995
Analyst Programmer
UBP - União de Bancos de Portugal, by Réditus Consulting S.A. (Banks and financial services)
- Development and maintenance of applications in the Current Account and Card Systems.

Technologies:
* Cobol/CICS, DB2, SQL, Spufi, VSAM, JCL, TSO
05/1993 - 12/1994
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
12/1991 - 10/1993
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
01/1991 - 08/1991
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
01/1990 - 01/1991
Analyst Programmer
Direção Processamento de Dados, S.A. (Internet and Information Technology)
- 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
01/1990 - 01/1990
Programmer
Grupo Gerdau (Industry and 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
01/1990 - 01/1990
Programmer
Banco Maisonnave (Banks and 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
01/1990 - 01/1990
Programmer
JH Santos, Indústria e Comércio (Consumer goods and retail)
- Development and maintenance of applications in Account and Supply System.

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

Local Availability

Only available in these countries: Portugal
Profileimage by JooBatista AguiardaSilva Senior Mainframe Developer/Consultant from Cascais Senior Mainframe Developer/Consultant
Register