Felipe Longarai Trisotto
Verified Expert in Engineering
Data Analyst and Developer
Florianópolis - State of Santa Catarina, Brazil
Toptal member since October 4, 2022
Felipe is a driven and meticulous data analyst and engineer with a proven track record of over seven years in the industry. Possessing a deep expertise in multiple database technologies, Felipe has been instrumental in delivering high-impact projects for multinational companies. His solutions not only elevated operational efficiency, but also transformed data into valuable business assets, generating significant revenue growth for his clients.
Portfolio
Experience
- SQL - 6 years
- Data Analysis - 6 years
- Microsoft Power BI - 5 years
- ETL - 5 years
- Data Visualization - 5 years
- Python - 5 years
- Data Engineering - 3 years
- Web Scraping - 3 years
Availability
Preferred Environment
SQL, Python, ETL, Data Visualization
The most amazing...
...solution I’ve developed is a 24/7 voice bot that generated more revenue in the first few hours than expected and still runs today.
Work Experience
Senior System Analyst
Ria Money Transfer
- Developed and implemented a robust SQL Server and Azure database solution, optimizing store procedures and schemas for efficient data management.
- Spearheaded a vital project converting a legacy system to Unicode, enhancing global user accessibility and experience.
- Utilized Git for version control, ensuring smooth integration between database solutions and C# applications.
Database Analyst
Code7
- Built and deployed over 1,500 high-performing bots, streamlining operations and improving productivity.
- Developed cutting-edge tools that revolutionized task handling. This resulted in a significant reduction in task time from hours to minutes, boosting my team's productivity.
- Provided exceptional customer support, ensuring that every customer fully mastered the tool and alleviating any difficulties they encountered along the way.
- Developed custom data visualizations using Python libraries such as Matplotlib and Seaborn, which enabled the team to uncover valuable insights and trends that would have been difficult to identify using traditional reporting methods.
- Implemented data visualization best practices to ensure consistency and accuracy across all monthly reports and real-time dashboards, resulting in increased trust in the data and improved stakeholder decision-making.
SQL Developer
DataHub Analytics
- Performed daily maintenance and improvement of vast amounts of data, performing a thorough cleaning, standardization, and enrichment of thousands of records for multinational clients with exceptional efficiency and accuracy.
- Designed and implemented sophisticated socio-economic analysis, delivering tangible results for several companies in their marketing and anti-fraud initiatives. His work had a significant impact on these organizations' success.
- Optimized complex recurring queries, drastically reducing computing time from days to mere hours while processing millions of records. This resulted in increased efficiency and improved productivity.
- Created visually engaging and interactive dashboards using Power BI, allowing business teams to easily analyze and interpret complex data sets, leading to more informed decision-making.
- Leveraged data visualization tools such as Tableau and Power BI to create dynamic and interactive visualizations that enabled stakeholders to explore data at a granular level and gain a deeper understanding of complex business processes and trends.
Experience
Petys
https://trisotto.github.io/Petys/Credit Fraud Analysis for Fintech
I delivered a comprehensive study, complete with statistics, interactive dashboards, and real-life examples, that provided valuable insights into potential customer groups and the manipulated and enriched data.
Data Pirate Cep
https://github.com/Trisotto/data_pirate_cepThe project was made even more convenient with the use of Docker, which enabled the creation of a Docker image for quick and seamless execution.
InvestHub
I utilized the Jupyter Notebook, Python, Beautiful Soup, Pandas, sci-kit-learn, matplotlib, and Plotly. I captured and processed data, applied deep learning, linear regression, and time series models, and presented the results in visually appealing and interactive graphics.
TaxesDB
https://github.com/Trisotto/TaxesDBDBAChallenge
https://github.com/Trisotto/DBAChallengeEducation
Bachelor's Degree in Computer Science
Federal University of Santa Catarina - Florianópolis, Santa Catarina, Brazil
Certifications
Architecting with Google Compute Engine
Google Cloud
Fundamentals of Data Visualization in Tableau
365 Careers
The Data Science Course 2022: Complete Data Science Bootcamp
365 Careers
Skills
Libraries/APIs
Pandas
Tools
Microsoft Excel, Microsoft Power BI, Git, Query Plan, Jira, Tableau, Excel 2016, Figma
Languages
SQL, T-SQL (Transact-SQL), Python, Java, C++, XML, Snowflake, C#
Paradigms
Object-oriented Programming (OOP), ETL, Database Design, Business Intelligence (BI), Scrum, Dimensional Modeling, OLAP
Platforms
Oracle, Linux, Windows Server, Oracle Database, Google Cloud Platform (GCP), Azure, Docker, Amazon Web Services (AWS)
Storage
Oracle SQL, MySQL, Databases, Microsoft SQL Server, PL/SQL, Database Modeling, Database Architecture, PostgreSQL, Database Administration (DBA), Database Performance, SQL Server DBA, Microsoft DBA, Data Pipelines, DB, Relational Databases, Oracle DBA, SQL Server 2008, Azure SQL, SQL Server 2016, Database Backups, SQL Server Integration Services (SSIS), Data Lakes, SQL Server Analysis Services (SSAS)
Frameworks
Windows PowerShell, .NET
Industry Expertise
Project Management
Other
Data Structures, Data Analytics, Data Management, Data Modeling, Data Architecture, Data Engineering, Data Visualization, Query Optimization, Data Analysis, Query Composition, Performance Tuning, Data, Scripting Languages, Architecture, System Administration, Excel 365, Web Scraping, Data Science, Amazon RDS, Big Data, Dashboards, DAX, Data Migration, ETL Tools, Business Analysis, Data Warehousing, Database Clusters, Web Crawlers, Scraping, Microsoft Servers, Machine Learning, AnyDesk, BI Reports
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring