Gustavo A.Data Analyst
Skills
With over two years of experience in data analytics, proficiency has been developed in transforming data into actionable business insights. An investigative approach drives the uncovering of significant insights, contributing to strategic decision-making. Skills include building relationships with stakeholders and bridging the gap between technical data and strategy. Expertise encompasses data analysis, data model design, and optimizing data flow.
Proficiency with advanced tools such as Databricks, and languages including Python, PySpark, SQL, and Excel enables the creation of comprehensive reports and efficient data ingestion processes. Additionally, four years in the logistics sector have strengthened capabilities in team leadership and inventory management.
Academic credentials include a degree in Systems Development Analysis and certification in Supply Chain Management and Logistics.
Data Analytics & Intelligence Analyst
10/1/2023 - Present
Expertly developed and optimized report automation to cater to various domains including product, marketing, and commerce. Proficient in conducting Cohort, Churn, Recovery, Recurrence, and Conquest analyses using intricate user data and interactions involving communications, points, SKUs, GMV, ticketing, and more. Enabled dynamic report creation that adjusts analysis parameters based on file inputs for autonomous updates, facilitating greater departmental autonomy. Applied and validated business rules for key indicators driving value and strategic direction toward business goals. Engaged stakeholders to ensure that critical indicators are optimized and aligned with business objectives.
Employed Delta architecture in the modeling and development of the Bronze layer (sourcing data from APIs, Crawler, JSON, etc.), the Silver layer (normalized modeling), and the Gold layer (dimensional modeling). Monitored automation workflows to guarantee timely execution of reports and table updates. Managed code versioning with GitHub, reinforced through review and deliveries aligned with the DataOps model. Cultivated a Data Governance culture by meticulously documenting all processes, models, and analyses. Leveraged Databricks for report development and table ingestion, utilizing Python, PySpark, SQL, and Excel to achieve comprehensive and robust data solutions.Jr Data Analytics & Intelligence Analyst II
9/1/2022 - 10/1/2023
Focused on user segmentation for communication initiatives and automated recurring communication databases for effective A/B testing. Ensured the maintenance and monitoring of data flows feeding user bases in Responsys, facilitating efficient campaign executions. Analyzed campaign performance through comprehensive reporting of user interactions and behaviors, leading to data-driven insights. Developed and optimized automated reports tailored for marketing, commercial, and product departments. Applied and validated business rules to create impactful indicators, steering goal achievement. Utilized GitHub for version control and adhered to the DataOps model for streamlined review and delivery processes. Leveraged Databricks, along with Python, PySpark, SQL, and Excel, for report development and data analysis.Jr Data Analytics & Intelligence Analyst I
2/1/2022 - 9/1/2022
Developed user segmentation strategies for targeted communication blasts and automated recurring communication bases for A/B testing. Maintained and monitored the data flow feeding the user base for communication blasts using Responsys. Determined rewarded users by campaigns and analyzed performance and interactions with communications and behaviors within programmed mechanics. Created, optimized, and monitored report automations to meet the needs of various product areas, marketing, and commercial teams. Applied and validated business rules for indicators to align with goal achievement. Managed code version control using GitHub and facilitated reviews and deliveries within the DataOps framework. Leveraged Databricks, Python, PySpark, SQL, and Excel to develop comprehensive reports.CRM Intern
4/1/2021 - 2/1/2022
Managed and analyzed requests for communications blasts, effectively organizing and resolving conflicts within the communications calendar. Programmed promotional and relational communication blasts across multiple channels, including email, SMS, push notifications, and WhatsApp. Configured dynamic fields such as A/B testing and segmentation within communication texts and images, occasionally working directly with HTML code for emails. Set up website banners and designed promotional landing pages.
Developed a Python program to validate text and link contents in email communications, working directly with HTML files. Utilized SQL and Excel to create user segmentation, and exported the data to Responsys as needed. Scheduled and maintained communication blasts, determined campaign award recipients, and analyzed campaign performance by tracking user interactions and behaviors within programmed mechanics. Employed GitHub for version control of codes and leveraged Databricks to develop comprehensive reports using Python, PySpark, SQL, and Excel.
Analysis and Development of Systems at Anhembi Morumbi University
2020 - 2023Supply Chain and Logistics Management at Pentagon College
2017 - 2019
Statistics for Data Science and Business Analysis at Udemy
9/1/2023Scientific Computing with Python at freeCodeCamp
1/1/2022SQL Server: Introduction to SQL with Microsoft SQL Server 2017 at Alura
8/1/2021Presentation Design Office at La Gracia
8/1/2021
Gustavo is available for hire
Hire Gustavo A.
All Howdy Candidates are vetted for skills and english proficiency.
