Thiago Monteiro Barbosa

R&D of an e-store platform. Built on Magento, with Akeneo PIM to handle the products catalogs. Creation of PoF environments, testing of connectors, SQL optimization and Docker.

Agenda Nacional is an intranet system used to book meetings and reunions in SERPRO's rooms. It checks the availability of the requested rooms, lists all possible schedules and warns the participants about it. The old system was discarded and we are developing a new one.

dotProject is an open source plataform for project management. The project covered adapting the software to the way SSPDS ( CTIC ) handled projects. That included layout adjustments, removing unecessary modules and developing new ones.

Managed to remove unnecessary fields and modules, created a new css-based layout for the entire system created a new module for sms-texting from scratch. This one module was awarded the 2nd most innovative open source solution by the state government… Mostrar más

dotProject is an open source plataform for project management. The project covered adapting the software to the way SSPDS ( CTIC ) handled projects. That included layout adjustments, removing unecessary modules and developing new ones.

Managed to remove unnecessary fields and modules, created a new css-based layout for the entire system created a new module for sms-texting from scratch. This one module was awarded the 2nd most innovative open source solution by the state government.

* Lead Developer and designer (PHP, CSS, javascript, html )
* Technical requirements research
* DBA of MySQL database
* Testing and bug fixing Mostrar menos

Migrated Funceme's website from the old html-only to a content repository one.

Set up the content repository and migrated all the old content to it. Created the new css layout and a new 3D logo using Blender.

Fixed and improved the old php code used for generating graphical charts over rainy season's data.

System to keep track and generate reports (using chartdirector) of hardware and OS installed on
each and all Funceme’s computers.

Developed from scratch. This system is the single tool for FUNCEME's hardware and OS management.

* Researched technical requirements
* DBA of MySQL database
* Design, development and testing

Project in association with COGERH. The water level monitoring of Ceará's lakes was done on paper-pencil level. This system consisted in using FUNCEME's free phone call department to collect data from lakes' monitor agents, filling a web report that would store that information in a MySQL database.
In case a lake would reach its maximum capacity, sms and email alerts would be sent to COGERH's leaders.

This system was developed from scratch and allowed the state of Ceara to stop… Mostrar más

Project in association with COGERH. The water level monitoring of Ceará's lakes was done on paper-pencil level. This system consisted in using FUNCEME's free phone call department to collect data from lakes' monitor agents, filling a web report that would store that information in a MySQL database.
In case a lake would reach its maximum capacity, sms and email alerts would be sent to COGERH's leaders.

This system was developed from scratch and allowed the state of Ceara to stop monitoring its lakes' water level from the pencil-and-paper model to a fully web based one, which improved both the accuracy of this monitoring also the informing of authorities about emergencies.

* Lead PHP developer
* DBA
* HTML and CSS development
* Testing and debugging Mostrar menos

New layout of Biophysics portal site.

* Developed html and css layout

Solution for keeping track of company's vehicles: who rented each car, the vehicle's conditions and fuel level, date of renting and return.

Developed the system from scratch and deployed it on FUNCEME's server.

* Researched technical requirements
* DBA of MySQL database
* Lead php developer

Development of new website.

* Developed a few classes and pages

Odonto System charged his employees for mobile calls. This system had the purpose to make it clear for the employees how much and for what they were being charged.

* Developed some pages and classes

Development and optimization of stored procedures and functions on SQL SERVER 2005 database.
Frontend and backend in .NET environment.

SERPRO's installment of IBM ALM, which governs the company's projects and human resources.

Managed to create better looking reports and optimize the loading time of older ones.

* Creation, design and testing of reports and consults using Pentaho Report Designer
* Edition of workspaces using the ALM interface

SERPRO's BI solution based on Pentaho Suite.

Managed to optimize ETLs to reduce their processing time up to 80%, reports' up to 30% and re-modeled the postgresql database for better relations and used a pattern for naming tables and entities.

* ETL development of jobs and transformations for data handling using Pentaho Data Integration
* Technical requirements research
* DBA of relational postgreSQL database used for an indicators dashboard, using Squirrel SQL and Power… Mostrar más

SERPRO's BI solution based on Pentaho Suite.

Managed to optimize ETLs to reduce their processing time up to 80%, reports' up to 30% and re-modeled the postgresql database for better relations and used a pattern for naming tables and entities.

* ETL development of jobs and transformations for data handling using Pentaho Data Integration
* Technical requirements research
* DBA of relational postgreSQL database used for an indicators dashboard, using Squirrel SQL and Power Architect
* Creation of reports using Pentaho Report Designer Mostrar menos

DIVAT - Dívida Ativa da União ( Union Active Debt ): mainframe system that handles the records of persons and companies at fault with the federal union.

Managed to optimize existing sub programs, reducing their processing time. Documented some sub programs that lacked any kind of documentation.

* Code optimization of existing sub programs
* Technical requirements research
* Analisis and development of new sub programs and functionalities
* Handling records of persons and… Mostrar más

DIVAT - Dívida Ativa da União ( Union Active Debt ): mainframe system that handles the records of persons and companies at fault with the federal union.

Managed to optimize existing sub programs, reducing their processing time. Documented some sub programs that lacked any kind of documentation.

* Code optimization of existing sub programs
* Technical requirements research
* Analisis and development of new sub programs and functionalities
* Handling records of persons and companies
* Documentation of old and new sub programns
* ROSCOE, Natural and Adabas
* Bug fixing Mostrar menos

Moedas Estrangeiras (Foreign Currencies) - mainframe system that selects and s debts and payments in foreign currencies for the federal government.

Managed to improve layout screens for a friendlier experience.

* Layout improvements
* Bug Fixing
* ROSCOE, Natural and Adabas

ROL de Responsáveis ( List of Trust Positions ) - mainframe system that keeps track of all goverment trust positions: all employees ever assigned to a specific position and also all positions an employee got assigned during his/her career.

Managed to migrate the list of workers from 2013's to 2014's database without problems.

* Interface improvements
* Bug fixing
* Active year transition supervisioning and migration
* Documentation of existing programs
* ROSCOE… Mostrar más

ROL de Responsáveis ( List of Trust Positions ) - mainframe system that keeps track of all goverment trust positions: all employees ever assigned to a specific position and also all positions an employee got assigned during his/her career.

Managed to migrate the list of workers from 2013's to 2014's database without problems.

* Interface improvements
* Bug fixing
* Active year transition supervisioning and migration
* Documentation of existing programs
* ROSCOE, Natural and Adabas Mostrar menos

CLACON is a mainframe system responsible for classifying monetary resources from Brazil's federal goverment among states and cities. Later on, those resources are delivered by SIAFI system.

Managed to create new subprograms and optimized old ones, that later became part of the New CLACON system.

* Mainframe development of new sub programs using Natural and Adabas
* Processing and formating of data files