Jhony Pilonetto

Experience

• 

  Lojas Colombo S/A

  Dec 2014 - Sept 2020

  # Creation of indexes and analysis of execution plan to improve performance;#Dynamics AX data extraction# Process mapping;# Development of data visualizations using storytelling;# Creation and Maintenance of report templates in Excel with VBA;# Data analysis using the Power BI tool;# Data processing and file import (ETL) through SQL Server Management Studio;# Development of monitoring KPIs focused on sales, purchases, marketing, logistics, among other sectors;# Data analysis with BI for fast and safe decision making;# Flow alignments of self-service projects;# Training of professionals to work with Power BI and Excel;# Layout standardizations. Show less # Conducted studies based on financial products, such as: *Credit Card -- Loss analysis, fee simulations and bottom line impacts. *Carnê -- Loss analysis, profile of defaulting customers X non-defaulting customers, among other analyses. *Personal credit# Data analysis focused on campaign planning, scenario creation, projections and process automation.# Together with the team, I planned how to bring the best result to the telesales and collection call center.# Creation of tracking and monitoring of sales and collection performance. Show less

  • Market intelligence analyst

    Dec 2019 - Sept 2020

  • Planning and Control Assistant

    Jan 2018 - Dec 2019

  • Billing assistant

    Jan 2015 - Dec 2018

  • Collection Operator

    Dec 2014 - Oct 2015
• 

  Grendene S/A

  Oct 2020 - Jan 2022

  Data intelligence analyst

  QlikSense Application Development: Proficient in developing applications within QlikSense, leveraging its functionalities to create robust and user-friendly solutions for data representation and analysis.Python and QlikSense API Integration: Skilled in integrating Python and QlikSense APIs, specifically focusing on extracting, processing, and interpreting information, enhancing data accessibility and usability.Process Enhancement and Metrics: Expertise in optimizing processes and refining metrics, ensuring efficiency and effectiveness in operations, thereby contributing to overall performance improvement.Data Visualization and Storytelling: Proficient in crafting impactful visualizations and data presentations using storytelling techniques, transforming complex data into compelling narratives for informed decision-making.Macroeconomic Data Compilation: Proficient in analyzing scenarios, gathering macroeconomic data, monitoring news, and compiling information related to international trade, global economics, and commodities.Supply Chain Data Analysis: Experienced in data analysis within Supply Chain Management, utilizing analytical tools to derive insights, optimize processes, and streamline operations for improved efficiency and performance. Show less

• 

  Nstech

  Jan 2022 - now

  Senior BI Analyst

  Strategic Data Analysis: I conduct in-depth analyses using advanced BI tools to transform data into actionable insights, identifying patterns and trends that drive strategic decisions.Data Model Development: I create and manage custom data models to provide a comprehensive view of performance metrics, ensuring accuracy and relevance in decision-making.SaaS Metrics Development and Monitoring: I develop and monitor Software as a Service (SaaS) metrics, analyzing data to evaluate performance, usability, and customer satisfaction, providing insights for continuous optimization.Revenue Operations (Rev Ops): I integrate sales, marketing, and service strategies, optimizing processes and collaborating with cross-functional teams to align goals, implement efficient workflows, and drive revenue growth.Process Optimization: I identify and resolve operational bottlenecks, refining processes to increase efficiency and profitability, continuously seeking innovative solutions to drive the organization’s sustainable growth.I actively collaborated with the Financial Planning & Analysis (FP&A) team to structure and build essential data related to the Profit & Loss Statement (P&L), Cash Flow, and other relevant financial information. Show less