Open to opportunities

Roger Fajardo Flores

@rogerfajardoflores

Message

I turn commercial, audience, sales, and operational data into decision-ready insights using Power BI, Python, and SQL.

Peru

Message

What I'm looking for

I'm looking to turn commercial, audience, sales, and operational data into decision-ready insights through BI, automation, KPI development, and clear communication with business leaders.

At Grupo RPP, I analyze audience behavior, program performance, target affinity, and competitor rankings to deliver weekly commercial recommendations, client-facing arguments, and management reporting. I also contribute to Audiences 360 / ARIA, integrating radio, television, YouTube, streaming, and digital sources into a cross-media commercial view.

I've enabled approximately 40 sales users to access audience intelligence through self-service Power BI, replacing a fragmented workflow across approximately 60 Excel files. I reduced monthly Board reporting from approximately three days to 30 minutes, creating more capacity for validation, insight generation, and decision support.

Previously at Corp. Celima | Trebol, I integrated Sell Out and stock data, supported forecasting and pricing decisions, and improved Sell Out processing from one day to 30 minutes. I also build Python and API workflows for competitive YouTube monitoring, live-chat analysis, and campaign reporting.

Experience

Work history, roles, and key accomplishments

Current

Commercial Intelligence Analyst

Current

Grupo RPP

Oct 2025 - Present (10 months)

Analyzes audience behavior, program performance, target affinity, and competitor rankings, converting findings into recommendations for Sales and Commercial Management. Builds Power BI data models and DAX measures, queries OLAP models with Python, and prepares weekly audience briefings.

Power BI DAX Python SQL OLAP Statistical Analysis Self Service BI Data Modeling