Marcelo M.Data Analyst
Skills
A Data Engineer with an advanced degree in Data Science and Decision from Insper and a Bachelor's in Administration and Business from Universidade Anhembi Morumbi, holding AWS Solutions Architecture certification and proficiency in Azure Databricks, Apache Airflow, and various databases. Possesses over three years of professional experience in data analysis and engineering across different sectors. Notable accomplishments include leading CRM data transformation for a significant Spanish bank using PySpark, SQL, and Databricks to develop both batch and real-time data pipelines. As a Senior Data Analyst, executed comprehensive business data analysis for the Groceries Operations Team, creating influential dashboards with Metabase and Tableau, and managing ETL pipelines with Airflow. Previous experience includes optimizing SQL Server client data insertion and generating insightful PowerBI reports. Demonstrates a strong commitment to solving complex data challenges and enhancing value for clients and stakeholders through collaborative and innovative methods that prioritize diversity and inclusion.
Data Engineer
10/1/2022 - 11/1/2023
Developed proficiency in driving CRM data transformation and accelerating delivery for a major financial institution. Demonstrated technical expertise in testing and deploying both batch and real-time data pipelines, ensuring seamless data integration and efficiency.Senior Data Analyst
4/1/2021 - Present
Led comprehensive business data analysis for the Groceries Operations Team, facilitating informed decision-making. Developed impactful dashboards utilizing Metabase and Tableau, enhancing data visibility and insights. Conducted ETL processes using PySpark, SQL, and Databricks to ensure accurate and timely data transformation. Efficiently managed ETL pipeline tasks with Airflow, optimizing workflow automation and operational efficiency.Data Analyst
7/1/2020 - 3/1/2021
Contributed to forensic and intelligence investigations through the generation of evidence-based reports. Optimized raw client data insertion processes into SQL Server, ensuring data integrity and streamlined workflows. Created insightful and actionable PowerBI reports, facilitating data-driven decision-making.Data Analyst - Associate I
10/1/2019 - 7/1/2020
Developed proficiency in creating detailed reports and presentations tailored for actuarial clients. Spearheaded the development of an open-source tool designed to automate actuarial audit processes, contributing to the community on GitHub. Enhanced understanding and application of automation in actuarial services.Financial Controlling Intern
2/1/2018 - 11/1/2018
Developed expertise in Visual Basic for Applications (VBA) and streamlined various business processes by automating repetitive tasks within Microsoft Excel and other Office applications. Leveraged advanced VBA scripting to manipulate data, generate reports, and integrate with other systems. Utilized SAP ABAP for back-end automation and customization, enhancing workflow efficiency. Demonstrated proficiency in debugging and optimizing VBA code for performance improvements. Ensured seamless data exchange between SAP and Excel by creating custom scripts and macros. Familiarity with SAP GUI scripting allowed for the automation of complex SAP transactions and improved accuracy. Enhanced user experience by designing and implementing user-friendly Excel interfaces. Extensive experience in using tools like SAP NetWeaver to develop, test, and deploy automated solutions. Showcased the ability to troubleshoot and resolve technical issues related to VBA and SAP integrations promptly.Financial Controlling Intern
1/1/2016 - 11/1/2017
Developed advanced proficiency in VBA and SAP automation. Executed complex scripting to streamline business processes, significantly reducing manual workload and increasing efficiency. Leveraged SAP GUI Scripting to automate data extraction and report generation, ensuring consistent accuracy and timely output. Utilized Excel VBA for data manipulation and integration with SAP, creating seamless workflows and enhanced data analysis capabilities. Demonstrated expertise in developing custom macros and tools tailored to the specific needs of the business, which facilitated improved decision-making and operational performance. Enabled seamless collaboration and version control by utilizing SVN and Git, ensuring that all developed solutions were accessible and maintainable across multiple teams.
Business Administration at Anhembi Morumbi University
2015 - 2019Data Science at Insper
2020 - 2021
AWS Certified Solutions Architect ‒ Associate at Unknown Institution
1/1/2022
Marcelo is available for hire
Hire Marcelo M.
All Howdy Candidates are vetted for skills and english proficiency.
