Alan Borges De Melo Email & Phone Number

State Of Paraná, Brazil

Curitiba E Região

● Responsible for a detailed financial analysis of the company's profit and loss results (PNL), ensuring the financial data’s accuracy and relevance;● Conducting profitability analysis by product, identifying specific contributions to corporate profitability;● Analysis of cost centers, profit and loss accounting, ensuring the financial records’ integrity and compliance;● Identifying and implementing cost reduction strategies in all the company areas, aiming at resource optimization and continuous improvement;● Financial reports, including sales volume, profitability by product, by area and overall, providing valuable insights for strategic decision-making;● Constant financial results monitoring compared to the planned budget (Actual vs. Forecasted), focusing on the financial objectives’ alignment;● Development of profitability analysis for Marketplace and export operations, supporting international expansion strategies;● Refinement of the budgeting and financial forecasting processes, strengthening the financial planning’s accuracy and strategy.Main results: (1) Partial payment of the amount charged per meal in the cafeteria, generating savings of 200.000 BRL per year. (2) Promotion and merchandising contracts review, with an opportunity to reduce costs of 84.0000 BRL per year. (3) Cut unused monthly and annual fees, with projected savings of 12,000 BRL per year. (4) Optimization of the toll hiring and parking tags for the fleet, saving 4.000 BRL per year. (5) expenses analysis by cost center and ledger account, providing visibility into operation’s expenses.

Curitiba And Region, Brazil

● Conducting economic analysis for Renault automobiles manufactured in Brazil, regarding models such as Sandero, Logan, Duster, Master and Captur, encompassing the costs monitoring and consolidation in relation to established budgets, rigorously applying the Cost Control Model (CCM) methodology;● Responsible for the unit budget of these vehicles for the following year, leading a detailed analysis of all available versions, their functionalities and optional features, in addition to the respective associated costs, to ensure budget accuracy;● Cost projections development (forecasts), including the risks and opportunities analysis, to ensure an up-to-date vehicle’s financial visibility, based on variables such as macroeconomic inflation, variations in component costs and fluctuations in raw material prices, in addition to integrating new information from engineering, strategic planning and purchasing leaders of each model;● Comparisons between up-to-date financial visibility and previously established budgets, with the aim of understanding and monitoring budget fluctuations, thus contributing to financial management;● Cost indicators analysis, including the purchased parts’ total cost , costs of value-added transformations, and logistics and customs costs, which allowed a detailed and effective control over operating expenses;Main results: (1) Development and management of advanced tools for the projection of individual parts’ costs of the main vehicles, based on commercial visibility. (2) Updating and simplifying the tool for consolidating the individual vehicles’ results for Brazil. (3) Conducting detailed benchmarks at the individual components level for various vehicles. (4) Development of a spreadsheet for budget allocation by financial pillar.

Curitiba And Region, Brazil

● Supervision and management of logistics performance indicators, including creating, monitoring, and developing PowerBI dashboards to simplify the visualization and distribution of information related to these indicators.● Planning of strategic actions to improve areas of low performance within logistics, using detailed analysis from the data collected;● Working as a key element in implementation projects in the Forestry sector, coordinating and integrating innovative solutions to existing operations;● Financial monitoring, including cost monitoring and financial results analysis within the finance department, ensuring data accuracy and support in strategic decisions;● Preparation and presentation of detailed reports on KPIs, offering valuable insights for the company's decision-making and strategic planning.Main results: (1) Participation in the BBM Green Belt program with a multidisciplinary team, aiming to reduce Total Maintenance Time and its costs, through the Lean Six Sigma transport methodology. (2) Development of a dashboard in PowerBI to consolidate information such as daily billing, harvest volume, downtime and maintenance. (3) Collaboration with outsourced companies for the development of specific software for the and harvesting management, bringing and updating solutions directly applicable to the operation.

Curitiba And Region, Brazil

● Working as POC of the outsourced company APISUL in the operations of VOTORANTIM CIMENTOS, assuming the management of the indicators in the Logistics Control Tower;● Creation and development of databases and dashboards using tools such as PowerBI and Excel, focusing on the preparation, monitoring and analysis of performance indicators;● Planning of actions for the continuous logistics performance improvement, based on analysis and insights obtained through the monitored indicators;● Preparation of management reports, monitoring of performance indicators and provision of subsidies to support strategic decision-making. Main results: (1) Development of a unified report with different indicators of the Control Tower, consolidating information from different software in a single weekly report. (2) Complete update of the mapping of the units.

Curitiba And Region, Brazil

● Assistance in the supervision of quality indicators, with the development and monitoring of KPIs to evaluate the plant's performance, including the creation and implementation of dashboards using tools such as Power BI and Tableau;● Engaged in Production and Quality, responsible for the definition of parameters and fundamental performance related to quality;● Responsible for generating and maintaining complaints in the system, ensuring the accuracy and quality of information recorded, in addition to supporting team members with various transactions and establishing SAP use standardization;● Continuous experience with the company's quality methodologies, including Problem Solving, FMEA, PDCA, 5W2H, SWOT, among others, demonstrating deep engagement in operational excellence and continuous improvement;● Preparation of reports and control sheets. Main results: (1) Proposition and implementation of the Supply Interdiction process for products with suspected quality, resulting in the reduction of the problems faced by Logistics in relation to batch control. (2) Development of a Tableau dashboard with the results of the quality indexes of the Curitiba plant and daily control of incidents and quality complaints.

Curitiba And Region, Brazil

● Working in the administrative area, playing a key role as a link between the commercial and factory teams, encompassing production planning and control, input purchase management, and financial supervision of logistics and commercial areas;● Comprehensive management of financial controls, covering strategic areas such as operations, logistics and sales, ensuring efficiency and financial alignment with the company's objectives;● Development of key performance indicators (KPIs) to monitor individual goals and evaluate corporate results, providing valuable insights for continuous improvement and informed decision-making.Main results: (1) Development of an automated spreadsheet for Production and Inventory Control and Planning, ensuring adequate availability of products to meet customer demands. (2) Development of an automated spreadsheet for financial control and accounts payable and receivable.

Curitiba And Region, Brazil

● Contribution to the effective management of occupational safety in the logistics unit of the Rio Branco do Sul Factory, through support in incident management, including the reporting and analysis of safety indicators;● Active participation in the implementation of improvements and adaptations to safety processes, aiming to ensure a safe and healthy working environment for employees;● Development of practical and theoretical skills in management and work safety, acquired through practical experience and the application of theoretical knowledge in a real work environment;● Contribution to the company's safety culture, promoting employee awareness and engagement in relation to safe practices in the workplace.

Curitiba And Region, Brazil

● Management of financial and administrative routines, including procedures such as bank reconciliations, payments, collections, issuing invoices and purchases;● Efficient execution of bank reconciliations to ensure the accuracy and integrity of the company's financial records;● Timely and accurate payments and collections, ensuring adequate cash flow and compliance with financial obligations;● Issuance of invoices in accordance with tax and tax regulations, ensuring legal compliance and adequate recording of transactions;● Management of the purchasing process, including negotiation with suppliers, acquisition of materials and services necessary for the company's operations;● Compliance with established financial and administrative policies and procedures, ensuring efficiency and compliance in all activities.

Lato Sensu Postgraduate - Mba, Data Analysis With Bi And Big Data

Undergraduate Degree, Production Engineering

Undergraduate Degree, Chemical Engineering