João Felipe Chiarelli Bourscheid Email and Phone Number
System Architect with 11+ years of experience working as freelancer, at public service, at private sector and as startup founder. My great trait is my entrepreneurial spirit, with both deep understand of business rules and bold sense of self-responsibility and innovation. To apply these concepts to the technology world, I use tools, frameworks and standards to manage the technical debt in order to keep the business competitive and customer-centric with low-cost, fast iterations and focused on utility.Despite my diverse experience in tech, I focus on keep the things simple, proving that innovation doesn't always require the last new thing. I advocate in favor of good and old relational database PostgreSQL and SQL language to solve plenty of problems efficiently, taking advantage of indexes, transactions, execution plans, constraints, document store, full text search, partitions, table as queue, materialized views, triggers. I never heard of any other technology that has so much features built-in with little complexity. The greatest challenge is adapt database technology to the cloud environment, which demands a new way of thinking.I also support the good and old HTTP protocol and native browser standards such as HTML and XSLT. It provides awesome features such as cache mechanisms, DOM, request, response status code, Cookies, URI based navigation. With well configured cache and use of CDN services, you can deliver a fluid experience for the user without a lot of complexity. XSLT is a game changer in this context because it provides a equivalent experience of AJAX and JavaScript alternatives for most of the cases, with far less complexity, even without the need of an presentation server because it's done client-side at the same time it's already API first.The two most exciting areas in software development for me is business and service layer. Efficient business rules management can be achieved through BPMN/DMN standards, using Kogito. Efficient service layer management can be achieved through EIP standard, using Apache Camel. In case you need a more complex solution, you can integrate both solutions with Clojure, Scala, Kotlin, Groovy, and Java.All these technologies are great, but their true power is at cloud because they can provide also low infrastructure cost and low carbon foot-print as cloud native platforms. I think cloud is awesome because it can shift the business model from SaaS Seat Subscription to SaaS PAYG. This completely changes the software development focus from frequency of features released to refactor the most used features.
-
EntrepreneurBoteco Software HousePorto Alegre, Rs, Br -
EntrepreneurCheapp Chef Jan 2023 - PresentPorto Alegre, Rio Grande Do Sul, Brazil -
Senior Software DeveloperPlusoft Jun 2021 - Jan 2023São Paulo, BrasilIn this job I receive the challenge of maintain an on-going legacy project which loses all its developers, without any documentation. The stack was Python, Elasticsearch, RabbitMQ, Django, Oracle, OCI. The software was a Social Media CRM that integrates with Facebook, Instagram, Twitter, Google Business Profile, Play Store, Apple Store, LinkedIn, ReclameAqui, Consumidor.gov, Blogs, and others.The legacy system has 3 billion posts in it's database with complex relationship. It was very expensive to run the multitenant database on the cloud. My sharp SQL and PL/SQL skill was critical to purge without downtime 2/3 of the old data of clients that didn't maintain contract anymore. This enabled the database server to reduce it's size by the half.After stabilized the critic moment, I realized that the system was too complex to manage with a small team. During it's 10 years of existence, it was constantly improved with new features all made from scratch which lead to a giant code base with 250k lines of code. One of the main problems was that for each integration there was new chunk of code, instead of use the same code for multiple integrations, only changing the configuration. Then, I started to research how this system could be simplified, and I came with the solution of a new system using Apache Camel, Quarkus, Kogito, and Postgresql to both reduce the complexity and infrastructure costs. The new architecture was developed over microservices and cloud native.To convince the board to adopt the new architecture, I started to track the amount of time needed to create a new feature in the old architecture and compared with the time to do the same in a PoC. After convince the board, the implementation of the new architecture was the real challenge. If I could done it again I would use the Strangler Fig instead of doing it all once, because it consume too much of me. The solution reduced 98% of the codebase and 47% of the time needed to implement a new feature. -
Software DeveloperTribunal De Justiça Do Rs Apr 2019 - Jun 2021Porto Alegre, Rio Grande Do Sul, BrasilI worked in the Financial Systems Team focused on maintenance of legacy system for tax collect of notary offices according with the amount of notary stamps and complexes business rules. This ecosystem was built in Delphi, Java Spring, PHP, and Oracle.The team had a young Change Management culture, so the Change Management was complexy and error prone. I worked hard for change the culture and embrace the process of Change Management.I also contribute with improving the security awareness of the team, pointing out parts of the system that should be improved, and even actually improve some points. Unfortunately, the company was severe hacked and it caused a great damage. To participate in disaster recovery task force was very intense and I could learn important things.The greatest challenge I faced was when a law decision changed the interpretation of the rules of the system retroactively. This moment I realized the importance of to treat the business rules as an important part of the system. Because the ecosystem was legacy, there were too difficult to calculate the compensation that it should be paid, taking a year to develop the solution end-to-end.I could get a deep understand about Oracle database, understanding the Query Plan, Views, Stored Procedures, PL/SQL, Indexes, Transactions and Entity-Relationship Diagram, difference of SQL 89 and SQL 92. It was the moment when I practice writing SQL query the most, since I had to use queries to solve issue of the legacy system and create ad-hoc reports.I also could gain more experience in the Java ecosystem. I learned about Eclipse, Maven, JSP, Entity-DTO Segregation.I learned about SVN, git, gitlab, Elasticsearch, Graylog.Despite of it was a legacy ecosystem, I learned big time some interesting approach to solve problems without complex to much. For instance, the use of separate files for query instead of using ORM for solve the problem made the maintance simplified. -
It TechnicianProcuradoria-Geral Do Estado Do Rio Grande Do Sul Oct 2017 - Apr 2019Porto Alegre, Rio Grande Do Sul, BrasilI worked in the networking and support department. In the networking department I learned about Active Directory (AD), Remote Server Administration, Backup Management and Network Management, using both Linux and Windows. In the support department, I worked with desktop and laptop repair, remote help desk, and the development of VBA script for automated installation and configuration of softwares, digital certificated, Java, and dependencies.In this position I develop a great sense of Information Security, which lead me to foster this culture as well in software development positions. One of my goals was to validate the security of digital signature software created in other public service. My investigation as red team highlight two possible attacks strategy that lead to the not adopting the new software. A mail with suggestions was written to the development team and they committed to fix the vulnerability. -
Freelancer DeveloperWorkana Jul 2014 - Oct 2017Pelotas, Rio Grande Do Sul, BrasilDuring 3 years as freelancer, I worked in plenty of projects. The highlights was:- BTree Implementation for Academic Purpose (C)- Tool for manage Cowboy Competition Groups (HTML,PHP, MySQL)- Wordpress site with layout and plugins customization for video rating (Wordpress, PHP, MySQL, HTML, JavaScript, CSS)- Group chat website (PHP, MySQL, JavaScript, CSS, HTML)- Multi-level Marketing Tool (PHP, MySQL, JavaScript, CSS, HTML)- ERP Software for a Bakery Business (PHP, MySQL, JavaScript, CSS, HTML)- HelpDesk Software Management (PHP, MySQL, JavaScript, CSS, HTML)- VBA Plugin for Excel to perform Engineering Calculation (VBA, AXISVM)- Identification System with Photo and Verification Code (PHP, MySQL, JavaScript, CSS, HTML)- Wordpress site for party promotion with promoter management plugin (Wordpress, PHP, MySQL, JavaScript, CSS, HTML)- Web Crawler (PHP, MySQL, JavaScript, CSS, HTML)- Web Crawler and Dashboard for Analytics (PHP, MySQL, JavaScript, CSS, HTML)- Configuration of Corporative Email Service (DNS, DKIM)- Web Crawler and Dashboard for Vehicle Reseller (PHP, MySQL, JavaScript, CSS, HTML)- Integration with Legacy Clinic Database to Export Exams Results in PDF format (Firebird Database, PHP, MySQL, PDF, HTML, CSS, JavaScript)- Mobile App Webservice for Schedule Exams (PHP, MySQL)In all these experience I develop a very pragmatic understand of how Web works, such as HTTP protocol, OSI model. I take this experience for other jobs to solve some issue with simple solutions compared with alternative propositions. -
Eletronic TechnicianAutônomo Jan 2015 - Jul 2015Pelotas, Rio Grande Do Sul, BrasilI worked as necessity entrepreneur building my own business as home service electronic technician. I realized how a terrific customer service can generate recurrent demand and maintain a predictable revenue. In this job, I repair domestic electronic devices such as DVD player, desktop and laptop computers, radios and PA devices. One particular challenge case was a customer that constantly had problems with his computer and no technician was able to solve. Because I attended at home, I realized that the problem was electrical peak in the home circuit caused by some specific equipment the customer own. This customer was very grateful for my service and asked me to develop and maintain a system using Microsoft Access for it's business.
-
Sales PromoterMais Saude Jan 2014 - Jun 2014Pelotas, Rio Grande Do Sul, BrasilI worked as Health Insurance Seller door-to-door. In this position I learned selling techniques such as keep tracking of customer interactions in a notebook, create sales script without be a robotic, focus on quality of interactions instead of quantity, customer service.
-
Soldier Of Communications Branch9° Batalhão De Infantaria Motorizada - Regimento Tuiuti Mar 2013 - Dec 2013Pelotas, Rio Grande Do Sul, BrasilAfter my initial training as private, I worked at the Informatics Section mainly as help desk working both with Windows and Linux systems, Organization Wide Proxy Configuration, Hardware Repair, Software Installation, Desktop Optimization, Wired and Wi-Fi Network Installation. I also worked as software developer in a special project of Intelligence Department for Civilian Identification when strangers entered the battalion. This project was developed with PHP and MySQL technologies, and I learned how to access the webcam device to take a picture and how to save a picture in the database.
-
It TechnicianIfsul - Instituto Federal Sul-Rio-Grandense Jul 2012 - Dec 2012Pelotas, Rio Grande Do Sul, BrasilI worked in the development of a simple software using PHP and MySQL technologies for manage the vehicle inventory of the campus, keeping track of the odometer of each vehicle, so it was possible to assess if the driver was using the vehicle for personal businesses. It was my first experience as developer in a real world project and it was important for me to gain experience in requisites analysis and project management. I also learned more about the capabilities of SQL technology such as JOIN, instead of manually aggregate the data through loops in the application. -
Eletronic TechnicianMastertec Mar 2012 - Jul 2012Pelotas, Rio Grande Do Sul, BrasilI worked in the maintenance of domestic electronic devices such as DVD player, CD player, desktop and laptop computers, radio, both as authorized technical support and out of warranty service. In authorized technical support the job was focused on identify the board with problem and replace with a brand new board, which has little aggregate value to the business. In out of warranty service, it was necessary further analysis of the board to identify the component with problem and evaluate the possibility of replacement using electronic instruments such as multi-meter and tin welding techniques to replace both integrated circuit (IC) and discrete component.
-
Scientific ScholarshipCnpq Mar 2009 - Jun 2011Pelotas, Rio Grande Do Sul, BrasilI learned about some introduction to advanced topics in mathematics, such as Number Theory, RSA Cryptography, Pigeon Principle, Euclidean Geometry Constructions, Euclidean GDC Algorithm, Monty Hall Problem, Proof by Induction, Proof by Absurd, Proof by Counterexample
João Felipe Chiarelli Bourscheid Education Details
-
Computer Science -
Não Concluído/Not Completed
Frequently Asked Questions about João Felipe Chiarelli Bourscheid
What company does João Felipe Chiarelli Bourscheid work for?
João Felipe Chiarelli Bourscheid works for Boteco Software House
What is João Felipe Chiarelli Bourscheid's role at the current company?
João Felipe Chiarelli Bourscheid's current role is Entrepreneur.
What schools did João Felipe Chiarelli Bourscheid attend?
João Felipe Chiarelli Bourscheid attended University Of The People, Universidade Federal Do Rio Grande Do Sul.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial