Roman Lakovskiy

Within the Insights & Analytics team, I serve as the key stakeholder for evaluating and optimizing omnichannel engagement strategy impact across multiple therapeutic areas. My expertise and analysis drive customer knowledge enrichment and engagement effectiveness measurement. Key Achievements: • Designed and implemented omnichannel engagement strategies using AWS, Tableau, and SQL, improving customer segmentation precision by 25% • Built predictive models and interactive dashboards enabling data-driven decisions that enhanced ROI across therapeutic portfolios • Led cross-functional collaboration in Agile environments, optimizing project workflows to deliver strategic initiatives on time and within scope • Developed advanced analytics frameworks for measuring engagement effectiveness and customer journey optimization Skills: Microsoft Power BI • Tableau • Python • SQL • AWS • Statistical Analysis • Predictive Modeling • Project Management • Pharmaceutical Analytics

Developed and implemented advanced statistical models for sales forecasting and A/B testing, driving commercial excellence across multiple business units. Key Achievements: • Created and deployed cross-BU Power BI reporting solutions with Azure integration, reducing reporting time by 35% and improving accuracy • Built forecasting models and A/B testing frameworks using Python and R, achieving 20% improvement in targeting precision and campaign effectiveness • Designed incentive plans and segmentation strategies, leveraging Power Apps for enhanced engagement tracking • Coordinated global partnership projects with QGIS-supported geographic and business analysis Accomplishment: Developed comprehensive SFE tool in Power BI, integrating data from multiple sources to track KPIs across Commercial, Regulatory, Marketing, and SFE departments. Skills: Microsoft Power BI • Python • R • SQL • Microsoft Azure • Statistical Analysis • A/B Testing • Project Management • Power Apps • QGIS

Key Achievements: • Provided customized analytical solutions and project management services to international clients • Developed SFE tools for major pharmaceutical companies including Ferring, Galderma, and Medac • Successfully managed market entry projects for American and German startups in France • Built long-term partnerships with industry leaders through consistent delivery of high-impact solutions Client Portfolio: Ferring, Medac, Valeo, Zuffa, Galderma, and other international organizations Skills: SQL • Python • R • Microsoft Power BI • Google Cloud Platform • Project Management • Business Development • Pharmaceutical Analytics

Conducted comprehensive statistical analysis and geomarketing research to optimize targeting strategies and enhance customer engagement programs. Key Achievements: • Performed in-depth statistical analyses and geomarketing studies, optimizing targeting strategies for improved campaign effectiveness • Continuously monitored and enhanced customer engagement initiatives to maximize performance metrics • Successfully migrated databases to AWS, improving data management efficiency and accessibility • Implemented new territorial optimization based on market research and geographic algorithms Skills: SQL • Python • R • Microsoft Power BI • AWS • Statistical Analysis • Geomarketing • QGIS • Database Migration

Delivered end-to-end Sales Force Effectiveness consulting, specializing in incentive design, territorial optimization, and data visualization. Key Achievements: • Led SFE consulting projects including objectives-incentives design, territorial optimization, and data visualization • Managed and mentored junior analysts in project management and Tableau development • Enhanced team technical and analytical capabilities through structured skill development programs Skills: Python • JavaScript • Microsoft Excel • Data Analysis • VBA • Hadoop • Team Management

Established and managed comprehensive Sales Force Effectiveness department while developing internal CRM systems and commercial analytics capabilities. Key Achievements: • Led SFE initiatives including network audits, geomarketing analysis, objectives-incentives, and SOG/SIG optimization • Developed and implemented internal CRM system (Weavy), creating reporting guidelines and operational frameworks • Built high-performance SFE department from ground up, integrating commercial analytics and developing executive dashboards Accomplishment: Created comprehensive SFE department, integrated internal commercial analytics, and developed dashboards for enhanced commercial performance visualization and understanding. Skills: SQL • Data Analysis • Microsoft Excel • Management • Hadoop • Microsoft Access • CRM Development

Managed operations for four luxury jewelry boutiques across premium French locations, implementing strategic sales and operational improvements that drove exceptional revenue growth. Successfully managed 4 high-end jewelry boutiques (Paris, Courchevel, Nice, Monaco), implementing new sales strategies and operational excellence initiatives that increased revenue from €1.2M to €6.2M (417% growth over 5 years)

Led cost breakdown analysis and provided strategic support to procurement teams, focusing on supplier negotiations and cost optimization initiatives in the automotive industry. - Conducted detailed cost breakdown analyses to identify savings opportunities and optimize supplier relationships - Provided analytical support to purchasing teams, enabling data-driven procurement decisions - Led negotiations with suppliers to secure favorable terms and reduce operational costs