Jacques Hervochon

I managed the migration of custom reports to support, maintain and improve existing client products. ▶ Migrate custom reports while ensuring data consistency ▶ Validate and reconcile data between legacy and new reporting systems ▶ Improve legacy dashboards by improving data layout ▶ Investigate and resolve data and visualisation issues ▶ Document data transformations, dependencies and reporting logic

I was in charge of migrating the company’s dashboards, working across multiple topics, teams, and datasets to ensure a smooth and efficient transition. ▶ Migrate existing reports from Power BI to Metabase. ▶ Create new dashboards based on emerged business and add new datapoints as required. ▶ Develop and optimize complex SQL queries to support dashboard creation. ▶ Collaborate with business stakeholders to understand reporting objectives and requirements. ▶ Rebuild and enhance visualizations in Metabase to meet analytical and business needs. ▶ Ensure data integrity and consistency between Power BI and Metabase outputs. ▶ Identify and implement opportunities to improve dashboard usability and performance.

I played a key role in completely revamping all company’s dashboards from scratch, introducing a new reliable and robust BI tool. Additionally, I was actively involved in conducting analysis to enhance the understanding of the subscriber’s journey. ▶ Defining metrics to align with clients expectations. I am closely working with Customer Success Team to ensure dashboards accurately and align to client needs. ▶ Designing and organising dashboards layouts to clearly and effectively present metrics. ▶ Implementing advanced analytics in dashboards to empower independent decision-making. ▶ Consistently providing analysis and reports to meet company goals and assist in troubleshooting outages and incidents. ▶ Deploying and updating dashboards integration using Git and GitLab

I had the chance to join the team from the very beginning and contributed to the creation of the dashboards and setting up new processes. Part of a fast paced Startup environment, handling new challenges and projects on a daily basis. ▶ Creating a complete BI tool and interactive features for Game Studios. ▶ Working closely with the Finance Team to fully automatise the Studio Payout. I provided automatical reports on finance performances with distribution and time series analysis. ▶ Migration of the data pipeline to ensure better quality of data and reduce cost queries. ▶ Providing insights on player behaviours in order to answer key business questions.

As a member of the Pricing Team, my responsibilities included optimizing revenue growth. ▶ Optimising the schedule for TV channel advertisements. ▶ Analysing the performance of the Group’s TV and Radio performances as well as competitors.

As a seller, I used my programming skills to provide an automated sales report. Leading this project independently in an English-language environment was a significant achievement. ▶ Developing a high-impact dashboard to automate inventory accounting facilities time-saving and enhance operational safety.

As an apprentice with the Data and Consumer Insight Team, I had the opportunity to automate the monthly channel performance analyses, presenting significant new challenges for the company. ▶ Creating an automated performance report covering linear, digital and social platforms for kids, cinema and series channels. The dashboard saved 2 week's work a month. ▶ Automating data collection processes on a daily, weekly, monthly and yearly basis to identify emerging trends. ▶ Analysing TV audiences to conduct comprehensive assessments for both kids and movies brands’ touchpoint. ▶ Delivering monthly digital performance presentations to Teams, enhancing their understanding of measuring metrics and social performance. ▶ Providing support in TV performance presentation to assist the Programmatic Team in optimising programming strategies. ▶ Conducting competitive analysis as part of the project to launch a new series channel, including benchmarking and competitive intelligence.

I helped the Research Department in the analysis of sport events sponsoring (Roland Garros 2016 and JO RIO 2016). Besides, I conducted and shared the weekly catch-up performances. - Evaluation of the advertising effectiveness to measure the impact of the sponsor campaigns. - Regular and ongoing communication with announcers to planning and setting-up the project. - Analysis of catch-up performance - Creation of TV show's performance insights - Call for tenders

I established a new consumer panel for audience measurement with the Data Scientist Team. - Definition of samples method constitutions - Data processing - Medias' panel consumption analyses (TV, radio) - Creation of innovative analyses presentations

- Implementing databases - Collection, compilation and data processing