Software Engineer Systems Analyst Senior (+40 years of experience)

Arnaldo Machado

Senior Software Engineer Database Architecture

Project Leader Senior Systems Analyst

WhatsApp: +55-11-9-894*-****

Email: *******.*******.*****@*****.***.**

Website: alpha.dev.br

Home Office: Caldas Novas, GO, with availability for on site work in another city/state/country.

Own company ME Ltda.: Alpha Dev Solutions in T.I. Ltda.

Skills

With more than 50 years of experience in the IT industry, he has developed deep expertise in various technologies and industries, including finance, manufacturing, engineering, agriculture, science, technology, education, and commerce. Skills include IoT, embedded systems, database architecture, legacy system development, and web applications.

Fluent in English and Spanish.

Lived in Houston, Texas, USA, for 14 months, 1996-1997.

Databases

*PL/SQL and Oracle, *Transact-SQL and MS SQL Server, *MySQL, *PL/pgSQL and PostgreSQL, *SQL PL and DB2.

Procedures, Functions, Triggers, Cursors, TUNING, Indexing. Formerly worked with BTrieve, xBase, FoxPro Server, FireBird, DBMS-II (Burroughs)

Database Programming

•TCL: COMMIT, ROLLBACK, SAVEPOINT •DML: SELECT, INSERT, UPDATE, DELETE •DDL: CREATE, ALTER, DROP, TRUNCATE •DCL: GRANT, REVOKE •PL/SQL, T-SQL •Exception Handling: TRY, CATCH

AI and Machine Learning Tools

Languages: Python •Frameworks and Libraries: TensorFlow, PyTorch, Scikit-Learn, Pandas, NumPy, Matplotlib, Seaborn, Keras, HuggingFace Transformers, XGBoost, LightGBM. And older: Prolog, Turbo Pascal, C.

IoT and Embedded Systems

Arduino, Raspberry Pi, ESP32, C, C++, Python, Hipo, MicroPython, Assembler, AIT-300/200/100, Olímpia

Tools

ChatGPT 4th paid, Power BI, Alteryx, Wix, Git, GitHub, Corel Draw, Docker, Paint, DFD-Plus, Super Project, Excel, Word, PowerPoint, Windows, DOS, Linux, WAMP, Novell NetWare, Norton Utilities, Google, Kaspersky, PuTTY, FileZilla, OBS, Notion, Coda, and more...

Programming Languages

Fortran, COBOL, Python, Flask, DJango, PHP, Ajax, JavaScript, API, Canvas, Chart.js, C, C++, C#, ABAP, ADVPL, Visual FoxPro, Assembly, HTML, CSS, CICS, PL/1, HP-GL, BetterBasic, DBase, Clipper, FoxPro for DOS and for Windows, WFL, JCL, AutoLisp, Prolog, Algol, Better Basic, Basic, ASP, Delphi, and more...

Project Management

•Project Leader, Systems Analyst, Business Intelligence.

•Data Center Manager, IT Manager, Systems Audit.

•Agile and more.

Other

•Data analysis, extraction, and conversion. Robots.

•Legacy System Restructuring.

•Microservices.

•Web Scraping.

•Website Hosting.

Education

University of São Paulo - USP - Physics Institute

Bachelor of Science Physics · (March 1973 - November 1978)

Started a PhD in Particle Physics

Focused on Scientific Computing using Fortran and PL/1, in 1990.

UniGoiás – Faculty of Information Technology

Old Fach(e) - Anhanguera Faculty of Humanities

Assistant Professor - For 3 years, from 1991 to 1994, in Goiânia, GO.

In the subjects of Systems Audit, Artificial Intelligence, Operating Systems, and Advanced Technologies.

UFU, Federal University of Uberlândia

Electrical Engineering

Started a Master's in Artificial Neural Networks, in, in 1992.

Professional Experience

2011/06 – Present

Alpha Dev - Solutions in T.I. Ltda.

(formerly Navy Net - Science and Technology - Ltda.)

Project Leader – Software Engineer

Head of Research, Product, and Software Development

•Creation, maintenance, and optimization of database architectures using PL/SQL, Oracle, MySQL, MS-Transact-SQL, MS SQL Server, PostgreSQL, Visual FoxPro, and FireBird.

•Development of IoT and embedded systems using Arduino, Raspberry Pi, ESP32, C++, Python, and MicroPython.

•Design and development of web applications using PHP, MySQL, API, AJAX, Canvas, Chart.js, JavaScript, microservices, CVS, HTML, CSS, and XML, including hosting solutions.

•Management of Legacy Systems development, COBOL, Fortran, PHP.

•Implementation of robust Back-End systems and cloud hosting solutions.

•Systems analysis, auditing, and Business Intelligence.

•Leadership in new business prospecting.

•Implementation of Power BI, and similar tools.

•Creation of lightweight and secure web applications and web services.

•Legacy system restructuring.

•Use of Web Scraping technologies, data extraction, and conversion.

•Application of various programming paradigms, including procedural and object-oriented programming (OOP), functional programming, MVC, and microservices.

•Recovery of old software by reading Assembler commands in hexadecimal to understand and modify the code of .exe files.

2009/07 – 2011/03

I.B.M. – Hortolândia, SP.

Software Engineer – Senior Systems Specialist, Advisor Level 7

Support, consulting, development, and maintenance of systems using COBOL, Fortran, PHP, and scripting languages.

2007/02 – 2009/04

Fast Solutions

Software Engineer

Responsible for the VISA Vale Pedágio system at Banco Real.

•Correction and restructuring of the compromised system using PHP and Oracle.

•Optimization of queries and indexes, and conducting system audits.

•Successful implementation of new protocols for transportation companies.

1971/01 – 2007/01

Architect and Software Engineer

•Project Leader, Data Center Manager, Systems Analyst, IT Manager, and Accounts Manager in various types of companies.

•Work with COBOL, Fortran, Algol, database architecture, systems analysis, and many other languages and technologies, including Better Basic, C, C++, Assembly, BTrieve, Novell Net, DBase, Clipper, FoxPro, Visual FoxPro, FoxPro Server, AutoLISP, Prolog, PL/1, DFD-Plus, Super Project, Corel DRAW, PHP, and MySQL.

•Development of projects in civil engineering, agriculture, and the oil industry, in Payroll and HR, Accounting, Cost Center, Banking Sector, Physical Sciences, Embedded Systems, and others.

•Specialized in Web development since 1995.

Some of the numerous companies for which he provided services:

1996/07 – 1997/09

Houston, Texas, USA

Fortran and COBOL Developer.

Developed COBOL and Fortran programs, which were adapted and tested by Noorali Habib, an independent consultant, who facilitated the services.

1991/02 – 1994/03

UniGoiás – Faculty of Information Technology

Old Fach(e) - Anhanguera Faculty of Humanities

Assistant Professor

In the subjects of Systems Audit, Artificial Intelligence, Operating Systems, and Advanced Technologies. In Goiânia, GO.

1991/11 – 1992/02

SANEAGO Company

Systems Analyst

COBOL programming using IBM for the water and sewage billing system.

Completed IBM's ESE - Specialist System course.

1989/04 – 1990/01

PISA – Paper Industry

Part of the Jornal O Estado de São Paulo group

Deputy IT Manager at the São Paulo headquarters, Project Leader, and Senior Systems Programmer Analyst.

COBOL and Fortran programming, from HP, completed all HP courses related to the HP-3000.

1988/03 – 1989/04

Banco BANESPA / Baneser

Project Leader, Senior Programmer Analyst.

Led the Project for the new Payroll and HR System, extremely complex and comprehensive.

Joint venture with other companies, being the legal contractual representative, signing, and approving each document.

Reported directly to the IT Advisor to the Presidency, Sérgio Wolkov.

COBOL programming using Micro Focus, for Novell NetWare, with BTrieve and DBase databases.

1984/11 – 1985/02

Wormald Resmat Parsch Ltda.

Systems Analyst and Programmer

COBOL programming using Cobra-540, adaptation of a Fortran program, brought from England, for the calculation of sprinkler networks, to calculate water flow in fire-fighting systems, allowing adequate pressure at each point, using reducers and pressure boosters.

The program used 500 KBytes, but with the memory limit per program still at 64 KBytes, I created a communication queue for COBOL programs, with a main COBOL program that triggered the execution of 10 identical programs that stored 50 KBytes of matrices, each with a communication mask, with parameters allowing commands to indicate which matrix, which command, clean, initialize, read, write, and the variable and element index.

Through a call from a BPL program that passed the Fortran program parameters to the main COBOL program, which then activated the corresponding COBOL program via the communication queue containing the desired variable. The Fortran program itself was divided into several overlays.

1983/10 – 1984/07

GHG – Construction Company

Head of IT Department, Analyst, and Programmer

Development in Prológica COBOL of the Budget and Costs system, and the Project Monitoring system.

1981/11 – 1982/02

Tortuga – Agricultural Products

Senior Programmer

COBOL programming using Univac-9030 for statistical calculations, using three-dimensional matrices and standard deviation calculations.

1980/03 – 1981/04

BCN – Servel, Banco de Crédito Nacional (now Bradesco)

Systems Analyst

Part of the IT Advisory team for the BCN group of companies, reporting directly to the General IT Manager, Edélcio Moraes, one of Brazil's representatives in international banking technical agreements, which set the standards and protocols for security, communications, and operational procedures in the international banking system.

Assisted in creating the new IT Master Plan due to the purchase of the Burroughs 6700/7700 and the training of all employees provided by Burroughs.

Internal support for programmers in COBOL, Fortran, ALGOL, WFL, DBMS-II.

Maintenance of complex systems in COBOL.

Development of sophisticated algorithms in ALGOL.

Completed all Burroughs courses for the B-6700/7700.

Received in-person mentorship from Carlos, Brazil's top expert in Burroughs Operating Systems and ALGOL, as I was his assistant at BCN.

1979/04 – 1980/02

COBRA – Brazilian Systems and Computers

Belonging to the Brazilian Navy and Bradesco.

Pioneering manufacturer of domestic computers, and the military computer COBRA-700, which used Fortran.

Systems Analyst.

Maintenance of Payroll, Billing, Inventory, Accounting, Accounts Payable, and Collection packages in COBOL-Interactive language, with Screen-Section, for the Cobra-400 computer.

Internal support for Analysts and Programmers in COBOL, Fortran, TAL-II, and Operating System.

Also participated as a Developer in the Assembler and Operating System team, coordinated by Salgado, on loan from PRODESP.

Home Office, September 9, 2024.

Arnaldo Machado

A successful CASE – 2007/02 – 2009/03

At Fast Solutions, address Rua Heitor Peixoto, 711,

cep 01544-000, São Paulo, SP, +55-11-291*-****.

Where Banco Real's VISA Vale Toll System was in production, which was developed over 6 years, in PHP, Oracle, PL/SQL, HTML, Java Script, including the ticketing module developed by a company in Uruguay.

The person who developed the system, made a patchwork quilt, where a lot of data was constantly changed from one variable to another, without reasons, causing extreme difficulty of tracking by XREF.

Furthermore, the data in the system was completely unstable, due to conceptual, logical and operational errors.

They called me for an interview in the afternoon and I started the next day in the morning despite living in Campinas.

The pressure on whoever had made the software was intense due to the serious problems in the system, and Banco Real was the company's “advertising” customer.

He couldn't fix so many problems anymore and he freaked out.

He left the company giving me only the information of where the software was installed.

I got this system without any manual documentation or even internally in the programs.

I put out the fire over the course of 2 to 3 months, and then I had to prove through audit reports that there were problems in other stages of the system that did not belong to our software or our production.

The first to be resolved was Miami VISA, which I managed to prove that the robot to upload the files sometimes did not upload but confirmed that they had received it, and this caused serious discrepancies, generating false alerts for the Bank.

The same happened because they did not take into account the fact that it is normal for some card charges to remain in an indefinite status and consequently with the wrong balance, due to hasty handling when loading the card.

After numerous reports from my audit, I was able to prove that I knew what I was doing, and that our system was correct, not needing these Miami checks, even more so with misinterpretations, with that Miami VISA left the circuit, stopping the noise it caused in production.

The second was VISA (Brazil), where I showed errors arising from the lack of data consistency, in the common cases in which the card passes through toll booths in remote places in Brazil that are sometimes temporarily without electricity.

They asked for a suggestion and I gave it to them: because there were manual processes occasionally, it was necessary to check the card's check digits, as well as the toll values posted, which used to be below something around 100 Reals, and VISA let it go a toll value of 20 thousand Reals.

They accepted and resolved.

The third was with the company from Uruguay, which did the ticketing, but due to a logic error when there was duplicity, they still did the Update, which changed the date, removing an event of a month already consolidated, and playing in another, causing a lot of confusion.

And then they fixed the code as I instructed, and the problem was solved.

And then finally, after many audit reports, we were able to prove to the carriers that the problems that remained were not ours, but simply that they had not adopted a new protocol that had existed for a while, but that required development, on their side, but they didn't do it because it was too costly and our system was completely full of errors, and it was no use for them to improve on their side.

But when we got our entire system right, the pressure on them from the Bank was enough for them to make the necessary adaptations.

And then the system was in order...

On one occasion, there was terrible pressure on me for a mistake that was actually caused by the bank and the plasterer, producing magnetic cards with a layout of an earlier version, or something like that, and I managed to prove that I and our company had no responsibility for the operational consequences, where even truck drivers protested at the doors of transport companies.

If the system had still been wrong, things would have turned ugly for us, because before me, our company was always to blame for everything.

I corrected some of our internal operating procedures, and made a program that corrected a very common operating error when processing the same batch again by mistake.

Two years after I started, the system didn't need me for anything else, and so I left the company, where I worked informally, with all the autonomy granted by the IT Director, who understood the importance and quality of my work.

The director, in turn, joined the company at the request of the owner, who had great references of him, and his character; to try to end the dominance of several employees over the operational KNOW HOW that was kept secret by them, leaving the company hostage to them.

But the director couldn't stand that IT environment, which was one of the most poisonous I've ever known, and he left about 3 months before me.

And so without the director, who gave me autonomy and had wisdom in decisions, I also decided to leave, staying only until it was confirmed that the whole system that I fixed was running wonderfully without the need for any intervention on my part.

I only left when I finalized everything that needs to be fixed in the system, and leaving was very healthy for me.

But before toasting, I made programs to generate internal audit reports, to help them locate possible third-party errors, if needed.

A few months before everything went back to normal, I was asked to write an official report to be the basis of Banco Real's negotiations for the sale of the software, the product and the portfolio of customers related to the product.

Due to the indeterminate statuses that occurred, when the person loading the cards removed them before completion, the question remained whether the card was loaded or not.

And to find out the balance, the last load with valid status was needed, which I used to calculate the total MINIMUM amount existing on the active cards.

And he also had to add the values of the undefined status after this valid charge, in order to calculate the MAXIMUM total value existing on the cards.

And so the bank and the applicants for the purchase of the product would know the range of values, between the maximum and the minimum, of all the active charges on all the cards, to take into account when evaluating the value of the product and its consequent negotiation.

In view of this, my audit reports had to be very accurate, clear, transparent and convincing, accompanied by tangible and auditable evidence, including methodology, and programming code.

Due to the computational and querying complexity for which the logical architecture of the database was not designed, as well as the small and slow physical infrastructure, it was to be expected that it could take an excessive amount of time.

For that, I made the program in PL/SQL, but running it only for a tiny amount of data, and the time it took was a lot.

I made a projection of how long it would take, and it turned out to be disastrous, as it would take many days, competing with the system in production, and it could still be finished ahead of time for other reasons.

So I looked for another solution.

I exported from Oracle, only the necessary data fields, and even simplifying the various codes and indexes, to make them smaller.

And I created tables on FoxPro Server, on a server disconnected from the network, and completely dedicated to this task, and I imported the data.

So I made a program in Visual FoxPro, and I ran it overnight. In the morning it was ready.

Then there was the long work of producing the official audit reports.

And so, even with many trying to knock me down since I joined the company, I gained the respectability of having managed to do everything necessary, far beyond expectations, as I entered into technical contacts with all the companies involved, showing solutions and assertiveness.

São Paulo, SP.

Arnaldo Machado Filho

Contact this candidate