-
Mainframe System Analyst
Mar 2022 - present days
Spread Brasilia
Working with agile methodologies in the modernization of the legacy IBM Mainframe system.
Using the proprietary SADS tool, working mainly in the Financial Funds system, having contact with UNIX programs, CICS Online
and batch processes.
In parallel to the activities of analysis and programming, I worked assisting in the dissemination of knowledge and editing of video lessons on Spread tools.
-
Youtuber
Ago 2007 - present days
Youtube
A psychedelic channel free and without logic. My variety channel, focused on travel, tourism and rail.
Digitalization of photos and 35 mm negatives from the photographic collection of my travels started in 1991.
Creating video photos using Movavi and MS Movie Maker.
Editing thumbs, video covers and illustrative images using Canvas.
Publishing small animations using Animaker software.
Improving and adjusting images with paint.net software.
-
Digital Marketer Consulting
Mar 2014 - present days
Bellacosa Index Page
Advice and support in dissemination on social networks. Image editing and art creation in Paint.Net and Canva Web.
On Facebook profile optimization, content creation, events and pages.
On Google page creation and network dissemination.
-
Alternate/substitute city councilor in Itatiba
Mar 2016 - Sep 2020
MDB Itatiba
Linked to the municipal board of the Itatiba MDB, participating in the party's social communications work,
attending sessions in the Municipal Chamber,
taking care of dissemination on Social Networks and actively participating in the Election campaign in 2016, 2018 and 2020.
Participation in events at the Legislative Assembly of Sao Paulo (ALESP).
-
Financial Analyst : Back-office
Mar 2016 – Feb 2017
Quadrante Investimentos
Backoffice service and financial follow-up of brokerage clients' transactions, analysis of bank statements;
testing and debugging in SmartBrain softhouse's third party "Smart Quadrant" financial software and legacy base data migration,
VBA macro creation in Excel for data formatting and extraction of statistical information.
-
IBM Mainframe System Analyst
Aug 2013 – Mar 2014
BRQ Digital Solutions
Programming in Cobol, JCL, DB2 mainframe environment for Safra and Itaú Banks.
Draw sequential flowchart in MS Visio.
Plan and assign tasks in MS Project.
Perform tests: individual and integral in job and jcl.
Analyze queries performance in Db2 and if necessary create indices and other improvements.
-
System Developers - Mainframe / AIX
Feb 2012 – Jun 2013
Zurich - Darwin Project
Sistemi Informativi
External consultant for programming in many environment : Insurance Life - Phase I (Mainframe) and Phase II (AIX).
Management for Actuarial Life Table; Actuarial Mathematics; Unit Linked; Transformation and Disinvestment module pays and receives RID ABI (Associazione Bancaria Italiana) standards of italian finance pay CBI (Corporata Banking Interbancario).Management of tariff calculation and migration from HOST to AIX.
Technologies : Mainframe : JCL, Cobol, CICS, DB2.
AIX : Shell script, Cobol, CICS, DB2
-
System Developers - Mainframe / Stored Procedure DB2
Jun 2011 - Jan 2012
Unicredit DPE ph1 Finance Controls
Sistemi Informativi
Creation of a parameterized module for charging bank services and a basket of charged products.
External consultant for programming in Mainframe environment Variation Massive
Technologies : Mainframe : JCL, Cobol, CICS, DB2 (Stored Procedure), Easytreave, Rexx.
-
IBM Mainframe - System Developers
Jun 2010 - Dec 2010
Barclays Portugal - New product Swap for interest rate.
Aubay Portugal
External consultant for programming and analysis in IBM Mainframe. Creat a new
manager products in Derivatives: Swap for Interest Rate in Housing Credit, Derivatives market.
Technology : Cobol, JCL e CICS, Database DB2, QMF, Spufi, Endevor, OPC Platinum in MVS System.
-
System Developers - IBM Mainframe - ALNOVA
Jan 2010 - Jun 2010
CGD: Caixa Geral de Depositos - Alnova Project
Aubay Portugal
External consultant for programming and analysis in IBM Mainframe framework Alnova in deposit accounts and central application of the bank client web interface (Caixa Directa).
Technologies : Mainframe - Cobol e CICS, Querys in DB2 (QMF e Spufi), JCL, Changeman ,OPC, enviroument IBM MVS
Visual Basic and MS Windows, MS Office, MS Visio
Resolution of anomalies reported by users units via Remedy Software.
-
System Analyst
Nov 2008 - Dec 2009
BFinance Consulting
Freelance
Support in MS Office with VBA, programming in Visual Basic + MS SQL
programming in Oracle
Business or sector Consulting
General services for creating VBA macros in Microsoft Excel on budget spreadsheets, costs for engineering office. HTML page design and improvement
-
IBM Mainframe : Systems Analyst
May 2007 – Set 2008
BPI - Banco Portugues de Investimentos
Adecco Portugal
Migrate files VSAM for new database in DB2;
Programming for batch process in JCL language for process SEPA;
New interface in the files transfer between Bank, SIBS;
Remodeling Target II and new functions payments and transfer;
Looking workflow transfers for SWIFT, Target II, SIBS and correct if necessary ;
Converting text in ASCII from Internet Banking for EIBCD;
Conversion flat file BPI format for SIBS format;
Create a document for the SEPA Project;
Validation of transfers receiving and transfer for BPI clients;
Interfce for BPI System Accountancy and Systems Transfering and Payments ;
Create in Easytrive forms and maps;
In CICS language renew interface on-line for system legacy;
Create in MS Excel worksheet that simulates for accounting from payments send and receive, validate flat file in SEPA format for send and receive;
Simulate for debt and credit between clients and account bank;
Notification for Banco de Portugal the system statistics and programming routines help protection and combat for money laundering;
Create routine for update for address table for Target II;
Validation Target II address in Swift Table address;
Create tables in DB2 and maintenance legacy.
Reporting weekly with leader of the BPI project about progress of process;
Report to the team analysis and when i need help and suport in the bank business rules ;
Feedback to the other BPI systems;
Contact and meeting other players (SIBS, Banco de Portugal and banks in Portugal, Spain) for swap file transfer and create text files;
Monitoring the others programmers in team;
Create mass test for debug program;
Documenting changes and catalog programs;
Contact with IBM team for pass programs in test ambient for the validating ambient and subsequent production ambient;
Contact with the DBA team for create new tables and update columns and index;
Contact : CICS team for create new transactions and Internet team for new fields in the forms;
-
IBM Mainframe System Analyst
Fev 2006 – May 2007
Novabase
1st Project DGITA – Direcção Geral de Informatica Tributaria e Aduaneira
Problems:
Low experience of IBM Mainframe members;
Old System, with little documentation available;
Public company with proper features in work : low productivity, small team and total dependence of Accenture;
The building of programs in IBM mainframe used paradigm Oriented Object, create bizarre programs with high consume of CPU and loss performance with increase data.
Soluctions:
Preventive maintenance and improvement of systems of the Department Management of financial flows;
Processing of monthly transfer of municipality;
Fortnightly processing of reimbursement to taxpayers and payments to experts;
Inclusion of new features in the statistical system of tax collection;
Optimization Software Validation and Payment of Tax Municipal Vehicles (IMSV);
Correction of abends if necessary;
Improvement of existing software and economy of cicles CPU in the mainframe;
Occasional maintenance and legal framework of the existing software;
Preparation of statistics for the collection of taxes and the size of the taxpayers in debt recovery courts.
2nd Project Attachment order in the BES - Banco Espirito Santo
Problems:
Spaghetti code in Cobol / Cics / DB2;
Code packaged in include
Timing over-estimated;
High turnover of staff;
Framework proprietary for developing (Novabase Code Generation).
Soluctions:
Analysis and codify in Cobol Mainframe;
Translate the book requirements for cobol language;
The Portfolio Management System win a new interface for attachment for order,
guarantees for loans, lock for amount of maintenance and debts to the tax authorities;
Test and create a mass of test;
Monitoring in the production;
Correction of errors (Abends).
-
IBM Mainframe System Analyst
Fev 2004 - Jan 2006
DPW Stirtan Consultoria Informatica
Skandia Portugal
Team tri-national (Brazilian, Portuguese and Spanish);
Software in Spanish legal framework being converted to Portuguese laws;
Lack of tools to support development (new software);
The Portuguese users don´t knew the main software tools from Skandia;
Few manuals for developers.
Review the existing codes;
Correction of abends if necessary;
Validate with Spanish team the technical specifications;
Embed validations according to Portuguese law;
Codify, testing e implementation of software with Skandia Team;
Develop small applications in Visual Basic to facilitate daily tasks;
Distribute work for the team and check progress of the other programmer;
Create documentation of existing software and add updates;
Skandia Spain
Developer simulated from SDD - Direct debit system;
Develop tools for payments in Internet Banking (PS2 format);
Develop tools for Tax Information;
Develop tools for accounting debts note;
Develop tools for create XML information securities;
Create a PHP page for simulate gains in investment;
Travel to Madrid to save programs and validation of specifications and testing with IBM Spain and Skandia;
Adapting the software to Portuguese reality;
Support the Spanish team in small maintenance of the system;
Monitoring of daily processing;
Creat a lot of features in software Skandia.
-
IBM Mainframe System Analyst
Oct 2002 - Dec 2003
Datarroba Consultoria Informatica
Freelance
1st - BPN- Banco Português de Negocios incorporation of securities brokerage FINCOR
Conversion of Fincor´s POC Accounting Plan to BPN´s POC (POC = the official accounts);
Conversion of old accounting movements from Escudos to Euros;
Conversion database from Primavera ERP layout to Navision’s layout;
Desassembly ERP Primavera for lookup rules of business FINCOR;
Legal deadline to complete the conversion;
Support the team in the closing month of accounting.
Encode small applications;
Convert movements accounting;
Feedback to teams and reporting for director BPN.
2nd - Deutsche Bank Portugal System of loans
Migrate old System of loans in MS Access/VBA to System developed to measure in JAVA/MS SQL;
Datarroba was dissolved in the process of programming.
Analyze the workflow of the request of loans and the optimization process;
UML design in the various stages of the process;
Code, Testing and Review of accounting in Cobol legacy to define now flow accounting in Java program;
Feedback between team and Deutsche Bank.
3rd - Turismo Da Natureza Data Modeling
Data modeling, customer base in MS Excel spreadsheet.
Database design in MS SQL.
Creation of direct mail for contact in Visual Basic.
ETL business spreadsheets in DML files
-
IBM Mainframe Systems Developer
Nov 1997 – Jun 2002
Abn Amro Real Banco
Create a technology interface between ABN, BOVESPA, CMV and Brazil Central Bank;
Learning in flight, because the system was created from scratch. First release was in 1998.
Implement events shareholders:
1 - Calculation and Payment of Dividends;
2 - Calculation and Payment of Bonus;
3 - Incorporations;
4 - divisions;
5 - groups;
6 - Deploy;
7 - Conversion of species and class;
8 - Register of shareholders;
9 - Extract of detailed stock transactions;
10 - prevent money laundering;
11 - Protect against fraud and mismanagement;
12 - Exchange of files between the Stock Exchange and the ABN;
13 - Exchange of files between business and ABN;
14 - Exchange of files between ABN and other banks;
15 - Migration of data;
16 - Custody of metals and other values;
17 - Custody of checks;
18 - Support brokerage ABN;
19 - Increase of capital;
20 - Reduction of capital;
21 - General Meetings of Shareholders;
22 - Creation of Acts of the Assemblies;
Correction of the Y2K bug to the system of loans, current accounts, payments to suppliers and Investments.
-
IBM Mainframe System Programmer
Nov 1997 – Feb 2000
Banco Real (Realplan)
Trainee analyst in mainframe, internship in the area of current accounts, loans, support and programming pool.
Junior Analyst in the area of Stock Management.
Technologies used Roscoe, PLI, JCL, Natural, Adabas, CICS, SORT, TSO, File-Aid and MVS
Banco Real was acquired by Banco ABN in 1998, but the merger completed in 2000.
-
Finance Technical
Jan 1997 – Nov 1997
ABSA Aerolinhas Brasileiras SA
I worked in Finance Area: balance line AWB, payments airport tax, receives transport air cargo, payments of comissions at agents, cash flows analysis, payments IATA tax.
Developer small aplications in Clipper and Visual Basic.
-
Finance Analyst
Oct 1995 - Dec 1996
Transbrasil Linhas Aereas
I worked in the financial area, billing reconciliation, financial inspectorate, payment of commissions to agents, statistical analysis of the deviations of the recovery (credit card, installment, cash), and critical survey of fraud in search of players.
Development of applications, filters for location and identification of fraud in Clipper and Visual Basic.
-
Economic Financial Technical
Fev 1989 - Set 1995
Fundaçao CESP
Monitoring of expenditure and revenue, accounting classification, statement of budget, cost control and evaluation of performance by sector.
