Marcelo M.
Data Analyst

Skills

Spark

Python

Mongodb

Amazon Aws

Marcelo is available for hire

Hire Marcelo M.

All Howdy Candidates are vetted for skills and english proficiency.

Bio

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.