Gabriel Rositto
Verified Expert in Engineering
Systems Engineer and Developer
Buenos Aires, Argentina
Toptal member since October 20, 2020
Gabriel is a systems engineer, and since 2011, he's occupied a range of roles related to business intelligence and data integration in general. Gabriel’s expertise includes various languages (SQL), paradigms (business intelligence), storage (Redshift), among others. Thanks to a drive to understand how things work at the most granular level, Gabriel thrives on solving challenging technical problems and investigating issues that most people overlook as "too complex" or "not worth it."
Portfolio
Experience
Availability
Preferred Environment
Amazon Web Services (AWS), REST, Tableau, Python, SQL
The most amazing...
...solution I've developed was building an end-to-end BI setup by myself—from setting up infrastructure all the way to reporting using AWS.
Work Experience
Freelance BI Lead
Lucky App
- Set up the data warehouse from scratch, including creating and configuring an AWS EC2 instance, writing the pipelines in Python, loading it into Redshift, and creating the datasets in AWS QuickSight.
- Provided ongoing support for the new requirements and existing processes.
- Integrated sources after the initial set up with Amplitude, AppsFlyer, Zoho CRM, and others and consolidated them as a single user view in the data warehouse.
- Developed the executive reporting for business investors, which illustrates the main KPI progress for all business areas.
- Designed a working prototype of a financing installments model, including payment and user blocking.
ETL Developer
Charles Taylor InsureTech
- Developed, tested, and reviewed SSIS packages to implement the required ETL setup for the project.
- Built client-facing metadata objects via Microsoft's Master Data Services software and ensured business rules and validations.
- Worked as part of the development team using Visual Studio, collaborating through Git, and organizing the workload in Azure DevOps and the Microsoft Cloud Suite.
Lead Data Engineer
OLX Group
- Migrated existing ETL jobs in Pentaho to a Python and SQL configuration orchestrated by Jenkins jobs.
- Migrated the visualization layer from MicroStrategy to Tableau due to changing the corporate reporting tool.
- Managed the BI team's workload with one direct report by working with Agile (Jira) and providing space for feedback.
- Developed integration scripts to source from Salesforce, Google Ad Manager, Google Sheets, and other internal systems.
- Maintained the existing BI setup with AWS EC2 Server, AWS S3 Buckets, and Amazon Redshift as the corporate data warehouse by developing new scripts and fixing them as required.
BI Specialist
OLX Group
- Worked on a project to offload large data from Redshift onto a file-system solution, including Hive, Presto, Parquet, and AWS Athena, although this was abandoned right before implementation.
- Developed the back-and-forth integration between Salesforce and Redshift via REST APIs in Python, which updated the main objects with BI data and reported sales data.
- Enhanced the custom fields, formulas, Apex triggers and Visualforce pages for the sales and operations team usage in Salesforce.
- Assisted the local Latin American BI team with developing and maintaining ETL jobs in Pentaho and reporting changes in MicroStrategy.
BI Manager
Dubizzle
- Led a team of two people organizing work in agile sprints (Jira), providing performance feedback, following up on issues, and creating development plans.
- Met frequently with business stakeholders to gather requirements and plan BI involvement in major business initiatives.
- Developed quality checks for main business KPIs, including data gaps, variation vs. history, and structured process logging via auxiliary tables.
- Provided a dedicated dashboard suite for revenue reporting with automatic comparisons against source data and several business rules, guaranteeing 100% accuracy and availability for critical needs.
Data Engineer
Dubizzle
- Developed, scheduled, and maintained ETL jobs in Pentaho, which fetched data from the local MENA product and loaded them into the global data warehouse solution in Amazon Redshift.
- Validated the data existing in the global solution against source data and interacted with local teams when issues arose.
- Worked on fulfilling BI-related requests for local business stakeholders, including product, finance, and marketing teams.
- Documented the main processes in the local infrastructure and all the related details in Confluence.
ETL Developer
Citi
- Developed ETL jobs using Ab Initio and Unix shell scripting.
- Validated ETL job statuses and results by using control tables stored in an Oracle database, controlling job execution by updating these tables.
- Deployed the ETL jobs from development into the UAT environment through Unix scripts.
- Performed validations by querying a test Teradata server before deployment on a live environment.
Teradata Database Administrator (DBA)
Visa
- Collaborated with a team that managed the enterprise data warehouse (DW) set up in Teradata, including user and workload management.
- Developed ETL jobs using Perl and later migrated them to PowerCenter.
- Implemented query tuning and performance optimization on data warehouse objects, including indices, explained plans, and space usage.
Programmer Analyst
Visa
- Developed ad-hoc queries in Teradata to solve business requirements and segmentations.
- Automated recurring requirements via DTS projects and SQL Server 2000.
- Created MicroStrategy reports for sharing results when required and provided reporting as Microsoft Excel files.
Experience
Freelance Projects
https://github.com/gabrielrositto217/freelance-workLucky App | Business Executive Dashboard
Some Features of the Setup:
• Data used in the visualizations is pre-aggregated at the day, month and level, with the ability to dynamically change the slice from the dashboard
• Business targets are also displayed when applicable for the user to visualize target achievement quickly
• Thorough quality checks and reviews with the business are shared monthly with investors as part of the information
I developed the dashboard and the underlying database by integrating all the available sources using Python, loading them into an Amazon Redshift cluster, and connecting QuickSight to use the data.
BI | Salesforce Integration Project
The project was finished successfully while also dealing with other BAU requests, which were challenging and demanding long hours.
Some Challenges and Details:
• Most countries had different business rules and data sources, which required several calls with different regional owners to understand the data model and regional particularities
• Timezone differences as active regions spanned from Buenos Aires to Jakarta made collaboration difficult; we kept calls to a minimum and took most things to email. The team building the Salesforce instance was a consultancy firm based in India
• The database extract was implemented in Python, orchestrated using Jenkins, and involved sending information via SFTP to a server running the load into Salesforce using Talend
• The data validation and adjustments in Salesforce, together with the business stakeholders, were also part of my responsibility
Education
Bachelor's Degree in Systems Engineering
Universidad Tecnológica Nacional - Buenos Aires, Argentina
Skills
Tools
Excel Development, Amazon QuickSight, Tableau Development, Jenkins, Jira, Amazon WorkSpaces, AWS, AWS Glue, Confluence, Ab Initio, Informatica, Control-M, DTS, Google Sheets Development, Visual Studio Development, Apache Airflow
Languages
SQL, Python, Bash, UML, Perl
Paradigms
Business Intelligence Development, ETL, Database, REST, Object-oriented Programming, Azure DevOps
Storage
Redshift, Amazon S3, JSON, Teradata, Database, Hadoop, PostgreSQL, SSIS, SQL Server 2019
Platforms
Pentaho, Amazon EC2, Unix, Linux, AWS Lambda, Salesforce Design, Oracle Development, CRM, AWS
Frameworks
Presto, Visualforce
Other
Data Warehouse, Data Engineering, Data Warehouse, MicroStrategy, Data Visualization, Unix Shell Scripting, Dashboard, Dashboard Development, System Design, Data Architecture, Artificial Intelligence, Salesforce Apex, Apache, Analytics Development, Amplitude, Data Analysis, FTP
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