Now you can Instantly Chat with Sergio!
About Me
- More than 11 years’ experience in Java (7 years) and C#
- Five years in front-end languages like JSF(CDI), JSP (Servlet), Spring Framework, HTML, CSS, JavaScript, Angular
- More than 11 years’ experience in databases lik...
- More than 11 years’ experience in databases like Oracle, SqlServer, MySQL and Postgres
- Currently focused on big projects especially building API to microservices in Java, Spring Boot and Angular as front-end.
Skills
Portfolio Projects
Contribute
Upgrade the stack of technologies from legacy systems to a new stack using Spring Boot, Spring Framework, Drools, Oracle
Description
UBS Investment Bank provides corporate, institutional, and wealth management clients with expert advice, innovative financial solutions, outstanding execution and comprehensive access to the world's capital markets. My role was to upgrade the stack of technologies from legacy systems to a new stack using Spring Boot, Spring Framework, Drools, Oracle
Show More Show LessContribute
Extract and convert data from legacy databases to new databases through an API in java ● Work together UI team to define the new layout ● Created react components to try the technology
Description
MTI is a government company responsible for providing technical knowledge to all other departments that are part of the state administration. I’m located at Secretary of Treasure from Mato Grosso. In this department exists more than 70 different systems, some big, some smalls. These legacy systems are made with different technologies like Cobol, PHP, Adabas, Delphi and etc.
This project (SIS) is to integrate and change old and legacy system to a unique solution and change these old technologies.
Situation
After a thorough analysis, I saw a lot of problems especially about access and reports from legacy systems. I realized an opportunity to improve our environment providing a unique solution and Spring Boot was chosen to do this. I made a pilot project to show for my bosses and it was approved. So I could extend to all legacy systems the new standard.
Task
My role in this project has been to design and develop the system using back-end technologies such as spring boot and Node JS (just to experiment the technology, not a standard) and front-end with Spring MVC and React.
Show More Show LessContribute
● Build the API to access the database and the fiscal code. ● Using JSF to create some parts of the system that requires parameters from users ● Build the Webservices that are used by costumers
Description
This project is to provide an electronic tax document for companies that move goods between cities and states in my country. Every truck that is in movement needs to have this document to passes through Tax office. Our Taxes office receive a big number of trucks to be inspected, the system informs according to some variables, which truck will be inspected and which no need this inspection. The fiscal compares the goods with this electronic document and apply fines if exists some problem. If the truck receives some fine, is registered on the system and this truck receives a high priority for the next time that it passes through the Tax office. The most part of the system is Webservices where our customers can consume these services and send us the requirements.
Show More Show LessContribute
Developed functions, procedures, Packages to access the data from tables in oracle database.
Description
NBS is the largest Brazilian company in the branch of software for automotive dealerships with more than three thousand clients in all national territory.
NBS provide the SPED-Fiscal document that consists basically of replacement of the Register of Entries, Register of Exits, Register of Inventory, Register of the Tax on Manufactured Products (IPI) and Register of the Tax on Circulation of Goods and Services (ICMS) with digital files for integration of the information provided to the federal, state and municipal tax administrations.
Situation
This was a new document requested by The Brazilian government and the company had a short deadline to deliver this document. The person responsible to develop this was fired. In that moment I had a short experience with PL/SQL and Oracle database and my boss arrived at me and gave this big responsibility.
Task
Understand the requirements from the government and work together with the product owner to decide which table in the database could provide the data to generate this document.
Show More Show LessContribute
● I collected the requirements ● I modeled the database ● Developed the business rule ● Developed the user interface
Description
Univag is one of the largest private university in the state of Mato Grosso. With more than twenty-five years of existence and with approximately nineteen thousand students.
Within the university, there is a language department where students can study languages from other countries like English, French, German and Italian.
Situation
The objective of this project was to build a website for the dissemination of this language department.
Task
In this project, I was assigned to do it completely. From the collection of the requirement, through the design of the database to the user interface.
Show More Show LessContribute
● Update site content ● Develop animated banners with extra information
Description
Univag is one of the largest private university in the state of Mato Grosso. With more than twenty-five years of existence and with approximately nineteen thousand students.
Univag has a site where students can obtain information about courses, internal procedures for students, events, protocol services and institutional events.
Show More Show LessContribute
● I collected the requirements ● I modeled the database ● Developed the business rule ● Developed the user interface
Description
CRC-MT is the state board of accountants. Responsible for registration, release of registration and maintenance of active professional life of state accountants. Among its attributions is to promote events with the objective of updating and training the knowledge of accountants.
Situation
There was no automated system for online registration at events and lectures. The objective of this project was to provide a platform for accountants to register for events that are frequently performed by CRC.
Show More Show LessWebsite where accountants can search for more information about events, history
Contribute
● Update site content ● Develop animated banners with extra information
Description
CRC-MT is the state board of accountants. Responsible for registration, the release of registration and maintenance of active professional life of state accountants. Among its attributions is to promote events with the objective of updating and training the knowledge of accountants.
Situation
The CRC has a website where accountants can search for more information about events, history of the department, board members, and how to obtain clearance for work as an accountant. I was part of the team for the maintenance of this site.
Task
Keep the site updated with data provided by managers.
Show More Show LessContribute
● Developed functions, procedures, Packages to access the data from tables in oracle database. ● Develop the Front-End side of this project ● Develop the core of this project that was predict
Description
The inventory module was in high demand for upgrades, and one of those upgrades was to provide a quantity-forecasting feature for parts to utilities. This functionality provided for the approximate quantity of a particular part for a given period to maintain the stock with the exact amount needed for the sale of parts
Show More Show LessContribute
For this project, I: ● Designed the new interface for this desktop application ● Developed the modules ● Extract the data from old system to new tables
Description
To develop this system we needed to change the old system that was made in Delphi and put in Microsoft technologies. I worked on this project since the beginning until finished it.
Task
In the project, I had to play the role of Senior C# Developer and work together with product owners to understand the requirements and share with other co-workers.
Show More Show Less