Open to opportunities

Guilherme Santos

@guilhermesantos

Message

I'm a Data Engineer moved by challenges.

Brazil

Message

I'm looking for challenges in companies that seek growth by creating value for the market and the user.

11 years of experience in retail / e-commerce companies. 6 years working with Business Intelligence and Data Engineering, a degree in Information Technology and an MBA in Strategic Business Management.

Throughout my journey, i have always sought to connect a data-driven culture with the best governance practices - bringing performance, scalability and efficiency to decision-making. With a proven track record of successful BI solutions implementation, i have helped increase efficiency and profitability for the companies i have worked for.

My tech stacks includes relational and non-relational databases (SQL, MySQL, NoSQL, Big Query), Big Data analysis (Python, R) and DataViz tools (Tableau, Data Studio, Power BI, Looker). Fluent in English and Spanish.

Experience

Work history, roles, and key accomplishments

Current

Data Engineer

Current

Mercado Libre

Jun 2023 - Present (2 years 1 month)

Development of scalable models, tools and processes that reduce manual/operational work for planning and commercial teams, and contribute through them to the acceleration of key initiatives of the 1P business.

Python SQL Machine Learning BI Data Visualization

Data Engineer

Mercado Libre

Jan 2022 - Jun 2023 (1 year 5 months)

BI solutions for Commercial Planning - First Party (Brazil and LATAM), supporting over 80 stakeholders (including commercial managers and analysts) in the management of the 1P business, improving Top-Line and Bottom-Line Growth analysis, portfolio selection, pricing, inventory health and convert rate optimization.

Tech Stack: SQL, Python, ETL pipelines in AWS and GCP, Dataviz (Tableau, Looker)

SQL BigQuery Python Google Cloud Platform (GCP)Teradata

BI Developer

Assaí

May 2021 - Jan 2022 (8 months)

Data analysis development and dashboards construction for Compliance leadership and ethics commitees. Work with IT teams in mapping of business processes and demands, requirements gathering, user story mapping, criteria, and efforts for the implementation of the internal Ombudsman CRM system and his integrations with other intern systems. Ad-hoc reports in Power BI.

SQL PowerBI Data Analysis SAP Azure Cloud

Senior Data Analyst

Via Varejo

Aug 2019 - May 2021 (1 year 9 months)

Responsible for strategic planning and business intelligence solutions in the Internal Ombudsman area. Analysis of indicators and construction of dashboards (Power BI) for fraud prevention teams, loss prevention, and compliance management.

SQL PowerBI Data Modelling ETL Data Analysis

CX Data Analyst

GPA

Nov 2017 - Aug 2019 (1 year 9 months)

Responsible for creating dashboards and support reports for the Marketing and CX departments, as well as providing insights for regional managers of physical store brands (Pão de Açúcar, Extra, Assaí, and CompreBem), e-commerce platforms (PDA Delivery and Delivery Extra), and group directorates. Analysis of indicators and qualitative reports to enable agility in action plans and decision-making.

Excel PowerBI Microsoft Office SAP Data Analysis

Social Media Analyst

GPA

May 2013 - Oct 2017 (4 years 5 months)

Responsible for monitoring fan pages and customer service profiles of the group's brands, tagging and handling, SAC 2.0 management, and analysis of metrics to measure, analyze, study, and compile all information related to customer activities on social media and channel performance. Also responsible for creating and maintaining management reports for crisis management on social networks.

Social Media Social Media Strategy