Luiz Malanczyn Email & Phone Number

State Of Paraná, Brazil

Curitiba, Paraná, Brazil

Curitiba, Paraná, Brasil

Lead the development of dashboards and reports using the company’s internal BI system to support decision-making for managers and directors.Maintain the integrity of the data warehouse, ensuring data accuracy and consistency across all levels of reporting.Provide actionable insights through data analysis, optimizing processes and driving business performance improvements.Mentor and train two IT team members, acting as a tech leader and guiding their development in BI and data… Show more Lead the development of dashboards and reports using the company’s internal BI system to support decision-making for managers and directors.Maintain the integrity of the data warehouse, ensuring data accuracy and consistency across all levels of reporting.Provide actionable insights through data analysis, optimizing processes and driving business performance improvements.Mentor and train two IT team members, acting as a tech leader and guiding their development in BI and data analytics.Collaborate with cross-functional teams to implement data-driven solutions efficiently and effectively.Biggest Project - Importation Process Simulation vs Realization ReportObjective: Developed a comprehensive report comparing the simulated and actual costs of the company’s importation process, which spans approximately three months for products arriving from China to Brazil. The report broke down expenses and incorporated dollar fluctuations, providing a clear view of the financial impact.Role: Principal developer, responsible for designing, developing, and implementing the entire report using SQL.Challenges: The complexity of the importation process, with numerous variables and fluctuating values, required an in-depth understanding of the business and the application of precise metrics to ensure accuracy.Outcome: The report revealed inefficiencies in the payment process, where unnecessary payments were being made, and some currency exchanges were inflating product costs. This discovery paved the way for automating the generation of pricing tables, leading to potential cost savings.Collaboration: Worked closely with the senior pricing analyst, the importation manager, and directly with the company’s executive team. Show less

Curitiba, Paraná, Brasil

Analysis of key business aspects to assess factors driving results and summarizing them in presentations. Creating dashboards to monitor and track key performance indicators. Developing customized reports, summarizing and presenting data in visually appealing formats. Providing technical support to troubleshoot analysis and reporting issues. Key Contributions: Acted as the lead BI for Mutant’s largest client, ensuring data consistency in the data warehouse and delivering… Show more Analysis of key business aspects to assess factors driving results and summarizing them in presentations. Creating dashboards to monitor and track key performance indicators. Developing customized reports, summarizing and presenting data in visually appealing formats. Providing technical support to troubleshoot analysis and reporting issues. Key Contributions: Acted as the lead BI for Mutant’s largest client, ensuring data consistency in the data warehouse and delivering valuable insights for the client and Product Owner (PO). Developed detailed documentation of team processes and trained new BI analysts in an agile environment.Major Project: Created a report that tracked the number of simultaneous calls to an Interactive Voice Response (IVR) system, revealing that the client needed to purchase additional ports to reduce queue time and improve customer experience.Challenges: As the principal BI for the company's largest client, I often managed projects independently, balancing high expectations and delivering impactful results.Outcome: The report led to strategic decisions that reduced customer queue time by 30 minutes, and the process documentation improved team efficiency. Show less

Curitiba, Paraná, Brasil

Developed integrations between our ERP system and the VTEX e-commerce platform, as well as between our ERP and the PayPal API for client credit analysis. This was accomplished using pure Python, leveraging Pandas for data processing and handling API responses.Created reports on customer purchasing behavior, leading to a 20% increase in sales for some represents that use the report.

Curitiba, Paraná, Brasil

Optimized a SQL query tracking the entire process from sale generation to product shipment, that all company uses, reducing query time from 1 minute to 10 seconds, an 83% improvement in efficiency.

Curitiba, Paraná, Brasil

Learned Power BI from scratch and became the go-to person for creating reports across all teams. Developed comprehensive dashboards and reports for departments, including those used by the executive team for strategic decision-making.

Mba (Master Of Business Administration), Data Science And Analytics

Conducted a factorial analysis on data from various districts in Curitiba, focusing on factors such as rent, education, and security. This.

Bachelor'S Degree, Computer Science

Activities and Societies: Volunteering, Community Action Conducted research to develop a new method for detecting "concept drift" in Java.

Ensino Médio Profissionalizante (Pós-Médio), Information Technology