Marco Aurélio Rocha

Marco Aurélio Rocha Email and Phone Number

Engenheiro de Automação e IA @ MR Soluções Digitais
State of São Paulo, Brazil
Marco Aurélio Rocha's Location
São Paulo, São Paulo, Brazil, Brazil
About Marco Aurélio Rocha

Data Analyst with over 3 years of experience in the Supply Chain field, specializing in data solutions that enhance process optimization and automation. Proficient in Python, SQL, Excel, and Power BI, I employ these tools to drive a data-driven culture that supports business objectives aligned with financial results. My expertise includes developing interactive dashboards, performing complex data analysis, and leveraging business intelligence tools to provide actionable insights. Dedicated to advancing technological applications in analytics, I have a proven track record of significantly reducing costs and improving operational efficiencies across multiple business areas.Main Achievements:• Reduction of R$5 million in idle stock• Cost Avoidance of R$250,000 in the process of destroying unsuitable items• Automation of processes, reducing more than 1 hour of manual work per day• Implementation of improvements in the reverse logistics process, achieving more than 95% return of materialsSkills: Excel, Power Query, Power BI, Data Visualization (DataViz), Business Intelligence (BI Tools), Python, SQL, VBA, SAP, Robotic Process Automation (RPA), Figma, Agile Methodologies, ScrumPortfolio: marco-rocha97.github.io/data-portfolio/Contact: marco.rocha97@gmail.com

Marco Aurélio Rocha's Current Company Details
MR Soluções Digitais

Mr Soluções Digitais

View
Engenheiro de Automação e IA
State of São Paulo, Brazil
Website:
bat.com
Employees:
1
Marco Aurélio Rocha Work Experience Details
  • Mr Soluções Digitais
    Engenheiro De Automação E Ia
    Mr Soluções Digitais
    State Of São Paulo, Brazil
  • Bat
    Data Analyst - Logistics Partnership
    Bat Jun 2023 - Present
    • Utilized Python and SQL for statistical analysis to identify and mitigate sales outliers, achieving a R$5 million reduction in idle stock by enhancing inventory accuracy and optimization.• Employed Excel to review the process of destroying unsuitable materials, leading to a cost reduction of R$250,000 annually while supporting environmental sustainability initiatives.• Streamlined the ETL process by developing automated workflows with Power Query, saving over one hour of manual work daily, thus improving data processing efficiency and report timeliness.• Conducted detailed logistics planning and materials distribution analysis across 33 warehouses using Excel and Power BI, maintaining an over 99% service level agreement (SLA) and ensuring optimal inventory distribution.• Led User Acceptance Testing (UAT) and conducted end-to-end validation of an international Artificial Intelligence (AI) project to automate decision-making, ensuring smooth implementation and user satisfaction.• Developed a stock occupancy dashboard in Power BI to monitor the occupational health of each location, providing real-time insights and facilitating data-driven decision-making.• Automated report extraction via SAP Script and VBA in Excel, gaining more than 30 hours per month and enhancing precision in data analysis.• Implemented Machine Learning (ML) in Python for forecasting, improving the DFA (Demand Forecast Accuracy) level.Key technologies and tools: Python, SQL, Excel, Power BI, Power Query, Data Visualization (DataViz), Business Intelligence (BI Tools), SAP, SAP Script, Figma, RPA, Agile methodologies
  • Bat
    Data Analyst - Logistics Foreign Trade (Comex)
    Bat Jun 2022 - May 2023
    Uberlândia, Minas Gerais, Brasil
    • Led a project to optimize fill rates in containers. Although unsuccessful, it provided valuable insights into challenges and opportunities in the area.• Automated the documentation process using Excel, increasing the department's reliability and gaining more than 2 hours per week• Developed an Excel system for calculating lead time based on specific requirements, providing accurate forecasts and streamlining the logistics process.• Forged solid partnerships, fostered an understanding of regional particularities, and developed fluency in English and Spanish through direct interaction with over 15 markets worldwide.• Used Excel to plan the distribution of raw materials, semi-finished, and finished products to various countries around the world, with a focus on Latin America (LatAm).• Ensured compliance with specific sanctions regulations and customs clearance by controlling export documentation to Cuba.Key technologies and tools: Excel, Power BI, Power Query, Data Visualization (DataViz), Business Intelligence (BI Tools), SAP, Agile methodologies
  • Bat
    Data Intern - Warehouse Logistics
    Bat Jun 2021 - May 2022
    Uberlândia, Minas Gearis, Brazil
    • Implemented an Excel solution to improve the reverse logistics process, achieving more than 95% return of materials, reducing costs and environmental impact.• Created Power BI dashboards for weekly and monthly meetings, providing clear and up-to-date views of the operational performance of each area, helping decision-making in line with business objectives.• Developed a gatehouse system for yard management using BI tools like Excel and Power BI, optimizing control of loading and unloading priorities, enabling more efficient management of the flow of materials.• Monitored KPIs and identified opportunities for improvement, developing action plans to improve indicators (e.g., efficiency, accuracy).• Participated in the annual inventory control audit (both internal (SOx) and external (KPMG)), ensuring inventory accuracy and compliance with regulations.Key technologies and tools: Excel, Power BI, Power Query, Data Visualization (DataViz), Business Intelligence (BI Tools), SAP, Agile methodologies
  • Despa
    Project Intern
    Despa Oct 2020 - Mar 2021
    Uberlândia
    • Data analysis using Excel to identify and mitigate cost drivers in material purchases and optimize processes, leading to cost savings of R$100,000 for the company.• Planned, designed, documented, and executed a mechanical project using Trello and Agile methodologies, ensuring efficient project delivery and collaboration.• Managed projects with Trello to guarantee delivery within the agreed Service Level Agreement (SLA), achieving over 95% on-time delivery rateKey technologies and tools: Excel, SolidWorks, Trello, Agile methodologies
  • Investiu | Xp Investimentos
    Financial Advisor
    Investiu | Xp Investimentos Aug 2019 - May 2020
    Uberlândia, Minas Gerais, Brasil
    • Collecting and analyzing data on each client's financial objectives• Analysis of historical data such as profitability, volatility, and correlation between different assets• Identification of investment opportunities using relevant data and metrics such as beta, Sharpe Ratio and VaR.• Construction of diversified and optimized investment portfolios for each client profile• Monitoring investment performance using customized dashboards and reports• Identifying trends using data analysis, enabling adjustments to be made to the portfolio if necessary• Using data to present clear reports on investment performance• Strengthening client relationships through clear, data-driven communication

Marco Aurélio Rocha Education Details

Frequently Asked Questions about Marco Aurélio Rocha

What company does Marco Aurélio Rocha work for?

Marco Aurélio Rocha works for Mr Soluções Digitais

What is Marco Aurélio Rocha's role at the current company?

Marco Aurélio Rocha's current role is Engenheiro de Automação e IA.

What schools did Marco Aurélio Rocha attend?

Marco Aurélio Rocha attended Federal University Of Uberlândia.

Who are Marco Aurélio Rocha's colleagues?

Marco Aurélio Rocha's colleagues are Reina Visagie, Sneekdha Brishty, Кристина Какава, Maricela Palacios Coronilla, Kashif Afzal, Perfect Siyabonga Mbuyazi, Kawsar Ali.

Not the Marco Aurélio Rocha you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.