Gabriel Margonato

Experience

• 

  Oracle Brasil

  Dec 2016 - Feb 2017

  Internship Student

  After attending Oracle's Big Data and Analytics Hackathon, I was invited to have an experience in the Oracle office alongside the pre-sales team, learning the challenges and dynamics of the company in a practical way.

• 

  Itaú Unibanco

  Feb 2017 - Nov 2021

  - Designed ETL processes to migrate data from on-prem to AWS, using Alteryx Designer and Server. Migrated data to AWS using Hadoop and Alteryx, focusing on big data principles with formats like Avro, Parquet, and ORC, to improve data handling capacity.- Utilized SAS Enterprise Guide for data flow automation and loaded and processed datasets with PROC SQL and SAS language.- Created Tableau reports to track supplier performance and conducted statistical analysis for the implementation of new variable compensation models and the insertion of new indicators.- Developed Tableau dashboards and committee materials for managing indicators related to credit card delivery and customer relationship.- Designed and built statistical models on large data sets to guide business decisions in insurance, finance, and ombudsman.- Governed the Performance-Based Pay model of third-party companies based on established indicators.- Led a productivity initiative for the call center by developing performance-tracking dashboards and applying gamification. Implemented a machine learning model to set dynamic productivity targets, reducing absences and boosting monthly product sales. Partnered with Marketing to incentivize call center agents through a points-based rewards system, improving engagement and increasing call center productivity across a 3,000-agent team. Show less

  • Junior Data Analyst

    Sept 2018 - Nov 2021

  • Intern

    Feb 2017 - Aug 2018
• 

  Puravida

  Jan 2022 - Aug 2022

  Data Analyst

  - Developed an inventory forecasting model to reduce stock excess and stabilize supply-chain flow based on monthly sales targets, implementing corrective actions through planned promotional windows.- Collaborated with CRM team members to optimize social media investments and decreased subscription churn by analyzing patterns and creating customer retention strategies.- Designed and maintained Power BI dashboards for the e-commerce division, providing real-time insights on subscription metrics and inventory levels for executive management.- Responsible for managing our Cloud environment, including creating and maintaining BigQuery tables. - Head of development for ETL workflows in the e-commerce growth and sales area.- Extracted data from multiple data sources and processed them using Python and SQL. Translated e-commerce business propositions into PowerBI dashboards and executive management reports. Show less

• 

  Metro Inc.

  Sept 2022 - Mar 2023

  Cashier

  - Responsible for processing customer transactions, handling cash and credit card payments, and providing excellent customer service. - Assisted with keeping the store clean and organized, and ensuring that the registers and checkout area were fully stocked. - Improved my communication and customer service skills, as well as the ability to work efficiently under pressure in a fast-paced environment.

• 

  GUS Canada

  Mar 2023 - now

  Data Analyst

  - Built and streamlined the access to the company’s data through secure, access-based Power BI dashboards, enhancing decision-making for officers and Executive Directors, with close-to real-time data.- Spearheaded the Data Governance department by implementing industry-leading framework standards, reducing report processing times through policies, limiting data columns and optimizing data retrieval.- Created AI-driven solutions, leveraging Azure's OpenAI Services and AWS, increasing the placement of our students in co-op positions, and analyzing our partner's programs to recommend improvements based on market needs.- Developed a Power Apps (Canvas) Faculty Management System, decreasing manual data entry errors to zero and enhancing data security by transitioning storage from SharePoint to MS SQL Server. Show less

• 

  Fleming College Toronto

  Sept 2023 - Apr 2024

  Instructor

  Introductory Computing (September 2023 to April 2024)- As an instructor for Introductory Computing course inside the Business Program, it was my responsibility to familiarize students with computer's hardware and software. Topics included file management, security risks, utility programs, cloud services, and the basics of Microsoft Office packaged.- In addition to the foundational curriculum, I led sessions delving into Visual Basic for Applications (VBA), aimed at imparting programming concepts to non-technical students. This included hands-on exercises culminating in the development of automation macros during class sessions.- As an enrichment opportunity, I facilitated a workshop on Storytelling, offering insights into Strategy, Structure, Visuals, and Emotions Resonance - to enhance presentations and communications. Show less