João Henrique Dos Santos Silva

Experience

• 

  Queonetics

  Jan 2020 - May 2022

  Queonetics (formerly Trixlog) is a company that tracks vehicle fleets and monitors driver behavior, and has partnerships with giants in Brazil such as Femsa, Heineken and M. Dias Branco.Built an Enhanced BI System: Carrying out activities such as ETL jobs, Data Warehouse modeling, support to leaders in the creation of KPIs; Creation of Dashboards in tools such as Metabase and PowerBI for monitoring measurements, generating insights and promoting solutions through data analysis.Monitoring Operational Lead Time: With the BI System implemented, Operation reduces the lead time by around 30% and reduces fines for breaching SLA by 75%. About 60% of the Operation sector was covered by the system at the time. Show less Queonetics (formerly Trixlog) is a company that tracks vehicle fleets and monitors driver behavior, and has partnerships with giants in Brazil such as Femsa, Heineken and M. Dias Branco.I performed activities such as: ETL jobs, Data Warehouse (DW) Modeling, Creation of Dashboards in tools such as Metabase and SuperSet for monitoring metrics (KPIs);Promoted to junior analyst in June 2021 after contributing to a wide availability of data, for the teams of interest, of customers relevant to the company. Show less

  • Business Intelligence Analyst

    Jun 2021 - May 2022

  • Business Intelligence Intern

    Jan 2020 - May 2021
• 

  Compass UOL

  May 2022 - now

  Data Engineer

  Compass UOL is a global company specialized in digital transformation through AI.Data Platform implementation: Successfully implemented a cloud-based data platform solution for a sector of Brazillian judiciary, carrying out activities such as Data Warehouse modeling, developing SQL ETL jobs from raw to refined data with Dbt and Iceberg tables, and developing SQL and Python scripts to query over refined data and delivering to external destinations.Data Lake building: I contributed to the implementation of a Data Lake in one of the largest cosmetics companies in the world, to handle data from HR, sales, stock, operational processes, such others. Using AWS services like DMS, API Gateway, Lambda, Glue, SQS, SNS, Step Functions, S3, Athena.Designed and built a data system: implemented the application data system for a large Brazilian retailer, improving the efficiency of delivering data about customers, products, and promotions at the time of purchase, improving the user experience, whether at physical or online checkout. In some cases, wait times were reduced from 40 seconds to just 2 seconds. Utilized Redis as a cache for queries of structured data on Amazon RDS instances and unstructured data in DynamoDB.These experiences highlight my ability to drive efficiency and improve overall performance through innovative technical solutions. Show less