Guilhem Jolly

Within the Medical Care Innovative Oncology Branch, I design and deliver end-to-end BI reporting solutions and forecasting tools. As Analytics Engineer I carry end-to-end code-migration from on premises solutions to cloud-based ETL and Warehouses to deliver high availability and high scalability for analytics purposes with Power BI applications. My projects: • Deployment of one Sellout Data Platform. Migration of Code Legacy of monthly Sellout Sales with Snowflake and Dbt to centralise data from multiple worldwide data providers, harmonize handling rules, automate quality testing and error detection: - 300k€ on external data products spent • Deployment of CI/CD rules for Power BI development and admnistration across pharma Business Unit • Built reports to track market share analysis and forecasting across pharmaceutical portfolio (oncology and mature treatments) • Modelisation of Parallel Trades Analysis for Loss Profit (~5M€) by Pierre Fabre to rebalance Financial Performance between Local Business Units with Finance and Sales data Technical Environment: Snowflake, dbt, Power BI, Azure, GitLab

Data Analyst Upskilling in Power BI & SQL for B2B and B2C. Development of custom learning contents and usecases.

Developed tailored learning modules for small and medium-sized businesses to integrate Power BI seamlessly into their operational environments : embedded solutions, applications deployment and data lifecycle management

Functional and technical support for the finance department in Dynamics F&O on Sales, AP, AR, Bank Statements, Fixed Assets across 5 brands (Celine, Loewe, Givenchy, Kenzo, Emilio Pucci). Led technical and architecture code redesign workshops of a customized reconciliation module in Dynamics F&O. Automated monitoring of data input and output of this module on a dashboard that resulted in a decrease of errors by over 80% across the brands. Technical Environment: Big Query, PowerBI, Big Query Dataforms, Microsoft Dynamics

Testing and development of a publication subscription pipeline for monitoring status of jobs across different ETL environments (Azure, Talend) and Applications (SAP, Power BI) for Live System Support Team. Automated scraped flat file cleaning for 6 marketplaces and +100K counterfeiting offers across Asian social networks and marketplace for a Legal Department. Technical Environment: Azure, SAP, PowerBI, GitHub

Design of a dashboard to supervise the variable mandatory training courses attended by 50K+ store employees throughout Germany. Creation of a macro for the finance department to collect second-hand product transactions from the Product Management System. Technical Environment: AWS Redshift, Looker Studio, Big Query

• Content Marketing: updating web media content and profit offerings, product iteration • Growth Hacking: Paid Ads and SEO content optimization • Media Writing Structuring (over 200,000 monthly views): ops management, community management • Development of acquisition freemium products