Sandro R.Data Analyst
Skills
With over nine years of experience in data, various roles have been undertaken, including Analyst, Supervisor, Scientist, Coordinator, and Data Specialist. Developed an analytical environment integrating PySpark with multiple data sources to streamline ETL processes, reduce data volume, provide ad-hoc queries, and support diverse analytical developments. Automated BI reporting solutions significantly reduced manual labor, facilitated a liaison role between the data team and operations directory, and created a university admissions simulator using student grade projections. This project allowed the Operations Directorate to utilize simulated scenarios for sales arguments to Educational Systems Regulators. As a Coordinator of Data Science Analytics, the transformation of the department was achieved by structuring technologies and forming a team. Market study analysis flow automation was accomplished through an interface connected to various databases and developed a predictive model for the number of beneficiaries of all health plans in Brazil with over 98% accuracy. This model enabled comprehensive commercial and marketing analysis on short-, medium-, and long-term bases and a preliminary customer clustering model exploring adherence and cancellation scenarios was developed. Contributed to increasing the lead conversion rate from 3% to 11%, substantially enhancing ROI through data-driven insights in partnership with the Market Intelligence Directorate. Participation in numerous analytical initiatives and support for IT department technology integration efforts for data storage were also key responsibilities.
In establishing a shopping center's data analysis unit, automated monthly performance indicator reporting reduced task execution time by over 80%. Sales projection-based audits of designated stores were conducted, including creating a 'discount map,' a BI tool for generating scenarios for rent discount risk assessment and revenue projection to aid data-based commercial strategies. Fiscal documentation audit processes yielded over R$200 thousand in direct revenue within one year.
Data Specialist
5/1/2023 - 9/1/2023
Led the development of an analytical environment integrated with Apache Spark to streamline ETL processes, significantly reducing data size and improving efficiency. Executed customer clustering using advanced data services to identify profitable profiles and zones with high potential for adoption. Conducted in-depth analysis of utilization indicators, providing a comprehensive 360-degree view of the service adoption lifecycle.Data Scientist
5/1/2022 - 8/1/2022
Conducted detailed data analysis of schools participating in the Letrus program, employing AWS Athena for data pre-processing and exploratory data analysis (EDA). Compiled and presented report results to the board, highlighting key insights and trends. Developed and implemented ETL routines through AWS Glue, ensuring efficient and accurate data ingestion from legacy systems. Produced comprehensive data products by integrating and analyzing multiple data sources, aiding in the creation of compelling sales arguments for regional education offices (SREs).Coordinator of Data Science Analytics
11/1/2020 - 5/1/2022
Developed and managed projects in Data Science and Analytics with a focus on predictability, customer clustering, time series, and profile cloning. Applied extensive data analysis techniques to identify patterns and generate insights for commercial and marketing opportunities. Conducted market studies to evaluate potential for medical, hospital, and dental consumption, employing machine learning models to analyze large datasets comprising socioeconomic data, regulatory agency data, and internal forecasts. Created data products for sales, marketing, and Market Intelligence departments through the development of ETL routines and Exploratory Data Analysis (EDA) of data from regulatory and government bodies.Data Scientist
10/1/2019 - 11/1/2020
Gained expertise in exploratory data analysis (EDA) and the development of key performance indicators (KPIs). Acquired proficiency in automating tasks using VBA, streamlining various processes. Specialized in the creation of dashboards and data visualization reports, using advanced tools and techniques to present complex data insights effectively.Data Supervisor
6/1/2019 - 12/1/2019
Conducted extensive market studies to evaluate sales potential and implemented effective Trade Marketing actions. Utilized data mining techniques to create comprehensive market information report interfaces and performed detailed competition analysis. Generated actionable leads for the sales team by analyzing sales potential across various micro, macro-regions, and municipalities. Managed and audited sales programs for regional-level dealerships, ensuring the effective marketing of Hapvida plans.Senior Data Analyst
12/1/2018 - 6/1/2019
Conducted comprehensive market studies to evaluate the sales potential of health plans and implemented strategic Trade Marketing actions. Developed dashboards and data visualization reports, utilizing tools to transform complex data into actionable insights. Generated and analyzed sales reports from dealerships, focusing on health plan sales, and provided detailed findings and insights to the Trade Marketing directorate. Enhanced skills in market research, data analysis, and report generation, leveraging technical expertise in dashboard creation and data visualization.Market Intelligence and Audit Assistant
12/1/2016 - 12/1/2018
Excelled in sales forecasting for stores and kiosks within shopping centers, aiding marketing, commercial, and financial strategies. Engaged in the development of Business Intelligence tools to monitor key performance indicators, conduct discount simulations for tenants, and evaluate financial and commercial risk scenarios. Conducted comprehensive market studies to compare operations with similar market players. Strategically selected stores for auditing based on sales forecasts, evaluating the costs versus revenue benefits of audits. Managed an internship team of 14 individuals within the department. Oversaw the audit of tax documentation, enabling the recovery of retroactive amounts for the shopping center.Market Intelligence and Audit Intern
12/1/2014 - 12/1/2016
Developed expertise in on-site auditing, ensuring accurate assessment and compliance. Prepared detailed surveys and conducted evaluations of consumption patterns for various stores and kiosks, enhancing overall operational efficiency. Analyzed sales data from shopping center operations to compile comprehensive indicators and monthly reports, providing actionable insights for business improvements.Accounting Assistant
12/1/2012 - 12/1/2014
Specialized in managing accounting records and processes. Developed expertise in handling Personal Income Tax (IRPF) and Corporate Income Tax (IRPJ). Demonstrated proficiency in executing various administrative routines and ensuring compliance with regulatory standards.
Accounting Sciences at Paulista University
2014 - 2018MicroMasters Program: Statistics and Data Science at MIT
2023 - 2024Statistics at Unieducar - Corporate University
2020 - 2020Algorithms and Data Structures at Focus College
2023 - 2023
Python Training for Data Science at Alura
10/1/2022Database and SQL for Data Science with Python at IBM
9/1/2022SQL Training with PostgreSQL at Alura
3/1/2022Innovation Training for Leaders at Alura
3/1/2022Creative Training at Alura
3/1/2022Communication Training for Leaders at Alura
3/1/2022Statistical Training with R at Alura
1/1/2022Data Science at IBM
9/1/2021Data Scientist Training at Data Science Academy
11/1/2020Python - Fundamentals for Data Analysis 3.0 at Data Science Academy
3/1/2020Microsoft Power BI for Data Science 2.0 at Data Science Academy
3/1/2020
Sandro is available for hire
Hire Sandro R.
All Howdy Candidates are vetted for skills and english proficiency.
