Marco Aurélio Rocha Email & Phone Number

State Of São Paulo, Brazil

• 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.

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.

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.

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

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