Pablo Silva Email & Phone Number

Federal District, Brazil

Brasília, Federal District, Brazil

Database and Business Intelligence Consulting

Montes Claros, Mg, Brazil

• Introduced custom dashboards in Power BI, providing a clear and detailed view of the S&OP, bringing assertiveness to the achievement of sell in and sell out goals.• Established KPIs to evaluate the performance of deliveries, including return rates, route profile, vehicle occupancy rate and route profitability, cost of deliveries and dispersion rate between planned and executed KM, among others.• Based on this detailed information, we implement data-driven strategies to optimize logistics processes.• This analytical approach resulted in measurable savings, with a significant highlight of approximately R$ 200k in the last year, focusing especially on freight costs and outsourced labor, which became unnecessary.

Brasilia, Df, Brazil

Leadership in the Implementation of the Market Intelligence Sector and Significant Results:• Assumed full responsibility for the implementation and development of the Market Intelligence sector, establishing solid foundations for strategic analyses.• Managed all activities related to sales administration, focusing on high impact analysis and reporting.• I highlight my crucial role in the development of the Business Intelligence platform (Qlik Sense), a fundamental tool for strategic insights from salespeople to the C-Level• Improved the Commercial Policy by making it more comprehensive, redefining pricing and discount strategies to optimize financial performance.• Led significant improvements in the structure of Variable Compensation, aligning incentives with commercial goals and results.• Committed to the continuous improvement of strategic planning and business processes, aiming at operational efficiency and market share gain.• Based on a trade strategy, we led a work in 2019 analyzing shelf facing with market share, resulting in commercial renegotiations that recovered more than 10 percentage points (Nielsen) in just 4 months. This achievement demonstrates the effectiveness of the implemented strategies and data analysis to achieve tangible results.

Brasilia, Df, Brazil

During my time as an analyst, I was instrumental in implementing significant change, aligning diverse skills to drive operational and strategic effectiveness. Some of the accomplishments include:• Created and implemented the first commercial key performance indicators (KPIs), providing a solid basis for evaluation and decision-making.• Assumed responsibility for the calculation and deployment of goals and calculation of variable compensation, in addition to modifying the compensation model to align incentives with commercial objectives.• Developed several reports and dashboards, using tools such as Qlik Sense, Microsoft Power BI and SQL. This effort resulted in a significant increase in the quantity, quality and speed of delivery of crucial information to the Board and business areas.• Took care of the sales force system, solving integration problems with the ERP (Protheus) and thus improving the performance of the sales, financial and billing teams.• Constantly monitored the consumption of commercial funds, including discounts and bonuses, ensuring an efficient management of available resources.These accomplishments demonstrate my ability in data analysis, dashboard creation, problem solving, and logical programming. In addition, the experience with TOTVS Protheus and ETL (Extraction, Transformation and Loading) contributed significantly to the success of these initiatives.

Montes Claros, Mg, Brazil

I was responsible for developing the Commercial Intelligence area, providing full support to decision-making and executing the strategic direction of the area, participating in the creation of action plans, presentation of results, creation of goals, Distributor Management Program (PGD), routing, budget control and other pertinent matters.

Itu, Sp, Brazil

Initially, I joined the Trade Operations team offering support from quantitative planning, acquisition and delivery of promotional materials in the cold market, self-service and special channels. Soon after, I was part of the Mercado Frio team where I took care of all strategic indicators in the area, interfaced with the field team and distributors, participated in the preparation and proposal of promotional actions aimed at growing volume/and or numerical distribution and developed new tools. for analysis and distribution of information in the area.I worked on the "Sucesso na Certa" campaign, which was a major Trade action with national coverage and contributed to projects in other departments such as Marketing, DHO, IT.

Montes Claros, Mg, Brazil

Belo Horizonte, Mg, Brazil