Marco Aurélio Rocha Email and Phone Number
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
-
Engenheiro De Automação E IaMr Soluções DigitaisState Of São Paulo, Brazil -
Data Analyst - Logistics PartnershipBat 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 -
Data Analyst - Logistics Foreign Trade (Comex)Bat Jun 2022 - May 2023Uberlâ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 -
Data Intern - Warehouse LogisticsBat Jun 2021 - May 2022Uberlâ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 -
Project InternDespa Oct 2020 - Mar 2021Uberlâ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
-
Financial AdvisorInvestiu | Xp Investimentos Aug 2019 - May 2020Uberlâ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
-
Mechanical Engineering
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?
-
1yahoo.com
-
-
-
Marco Aurélio Rocha
Botucatu, Sp
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial