Stephanie Gessler

About

Learn more about me

Big Data – Analytics Expert & Leader

Driving innovation and business decisions through advanced data analytics and machine learning expertise.

Website: https://stephaniegessler.github.io
Degree: Master in Big Data and Analytics & International Busienss
Area: Zürich, Zug Area, Switzerland

Experienced Data & Analytics Engineer with a robust background in business analytics, Big Data and Machine Learning. Skilled in SQL, Python, and cloud data platforms, with a proven track record of leading data-driven projects in diverse industries.

Projects Completed

Companies Worked For

Years of Experience:

Certifications

Skills

BI (Tableau & PowerBI) 100%

SQL 80%

Python 75%

MS Fabric 75%

NOSQL 60%

ERP Systems (Rapid Response, SAP & Oracle) 75%

html & CSS 55%

Data Modelling 75%

Interests

Data Science

Machine Learning

Cloud Computing

Big Data

Business Analytics

Data Visualization

AI Development

Data Modelling

Data Engineering

Data Privacy

Project Management

Healthcare Analytics

Testimonials

I highly recommend Stephanie as an outstanding colleague. We studied together in the same Masters program in Big Data and Business Analytics, and her efficiency, organization, and dedication in codings tasks were truly impressive. Steffi consistently went above and beyond, demonstrating a strong work ethic and a willingness to tackle challenges head-on always pursuing nothing more than excellence. She always had a proactive approach to start and distribute tasks as soon as they were assigned; and her attention to detail were invaluable to our team's success. Steffi's positive attitude and collaborative nature make her a pleasure to work with in, specially in highly technical tasks coding in Python. I have no doubt that Stephanie will continue to excel in any endeavor she pursues.

Pedro V.Esteban

Deep Learning Engineer

I had the pleasure of working with Stephanie on several occasions during our Master's in Business Analytics at IE University. Stephanie is one of the most hardworking and determined individuals I know. She consistently goes the extra mile, relentlessly aiming for the best outcomes. Stephanie possesses a natural intrinsic motivation and an insatiable curiosity to learn new technologies, which she adeptly applies to her areas of interest, such as healthcare. Her dedication and passion make her an invaluable asset in any team, and her innovative approach consistently drives projects to success.

Dominik Roser

Senior Product Owner

I had the privilege to work with Stephanie at LifeScan, a former division of Johnson & Johnson. In her role as Senior Sales and Operations Planning Analyst, Stephanie impressively demonstrated her analytical, technical and organizational skills. She constantly challenged the status quo and played a vital role in improving various business processes and reporting tools. Stephanie is very experienced in ERP Systems such as Rapid Response and Oracle, as well as Business Intelligence tools like Tableau and Power BI. Stephanie is a team player. She built up strong relationships with internal and external customers and colleagues across the entire organization. It has been a joy to work with her and I can highly recommend Stephanie as a colleague. She is an enrichment for every company.

Cedric Meier

Sales and Operations Planning Manager

Resume

Check My Resume

Summary

As a passionate Big Data and Analytics Expert, I specialize in designing and implementing end-to-end data solutions that drive strategic decision-making. With extensive experience in creating and managing data infrastructures, I excel in automating data workflows, building robust pipelines, and integrating advanced analytics for actionable insights. My expertise spans various domains, including Pricing, Healthcare, and Supply Chain, where I enhance data management and operational efficiency.

Certifications

AWS Certified Cloud Practitioner
DATA SCIENTIST PROFESSIONAL DATACAMP
Programming for DATA SCIENCE with Python DATACAMP
SQL and Relational Databases 101 IBM
SQL NANODEGREE PROGRAM UDACITY
LEAN SIX SIGMA GREEN BELT SWAROVSKI

Education

MSc in Business Analytics and Big Data

2021 - 2023

ie University – School of Science & Technology, Madrid, Spain

GPA: 4.9/5.0 (Dean's List Top 10%) | Award: Best Impact Project and Best Capstone Project Presentation

MSc in International Business – Supply Chain Management

2014 - 2016

School of Business and Economics, University Maastricht, Maastricht, Netherlands

Average: ‘8.0/10’ (Cum laude with distinction Top 15%)

BSc in Economics and Business Economics- Infonomics

2009 - 2012

School of Business and Economics, University Maastricht, Maastricht, Netherlands

Nanyang Technological University (NTU), Jurong West, Singapore - Exchange Semester

2011 - 2012

Economics and Business Economics

Professional Experience

Customer and Business Analytics and Data Manager

09/2021 - Present

Viatris, Steinhausen, Switzerland

Architected and implemented end-to-end Lakehouse data pipelines using Delta Lake architecture in Microsoft Fabric, integrating data from SAP and SharePoint to Power BI. This optimization of data processing and analytics workflows enhanced business intelligence and real-time analytics capabilities.
Revolutionized reporting processes by transitioning from ad-hoc Excel-based reporting to a centralized Power BI model, while implementing advanced data modeling techniques in SQL, Fabric, and Power BI. These improvements significantly enhanced report generation speed, consistency, and the ability to support complex business queries and financial reporting analytics.
Developed web scraping algorithms for strategic insights on drug shortages and leveraged data analysis for critical decision-making in product portfolio optimization, competitor analysis, and supply chain efficiency, transforming public and internal data into actionable business intelligence.
Led a cross-functional data team, ensuring GDPR compliance and optimizing Azure Data Integration processes. Served as the Product Owner for the Viasales system (Wholesaler Data) implementation, defining business requirements, conducting UAT testing, and acting as the key contact for Swiss data integration.
Spearheaded knowledge sharing initiatives, including an AI-focused 'Lunch and Learn' session, while serving as a key decision-maker in IT tool selection. This involved evaluating and implementing cutting-edge Microsoft-based analytics platforms, fostering a data-driven culture across the Swiss organization and UK healthcare professionals.

Senior Analyst & Project Management Medical Device in EMEA

12/2017 - 09/2021

LifeScan (formerly Johnson and Johnson), Zug, Switzerland

Promoted to Senior Analyst for pioneering data-driven approaches in forecasting and supply chain optimization. Served as Product Owner in implementing Rapid Response (Advanced Planning System), overseeing requirements gathering, system configuration, and user acceptance testing.
Spearheaded the global integration of statistical forecasting within Rapid Response, actively managing forecast parameters to optimize prediction accuracy. Collaborated with country and regional teams to determine optimal forecasting methodologies, balancing statistical models with market-specific insights.
Led and facilitated S&OP (Sales and Operations Planning) meetings for MEA, UA, and RU regions, driving cross-functional alignment and strategic planning based on analytical insights. Conducted in-depth analyses of market dynamics and product performance, informing product lifecycle management strategies.
Designed and integrated a comprehensive Advanced Planning System, leveraging predictive analytics to optimize inventory levels and streamline supply chain operations, enhancing overall operational efficiency and decision-making processes.

Supply Chain Analytics & Master Data Management Planning Excellence

04/2016 - 11/2017

LifeScan (formerly Johnson and Johnson), Zug, Switzerland

Spearheaded the design and implementation of an SQL database for inventory management, while developing automated Tableau dashboards with MAPE and BIAS metrics, significantly enhancing data accessibility, analysis capabilities, and forecasting accuracy.
Created a global KPI monitoring system using advanced data visualization techniques, leading to marked improvements in supply chain efficiency. Provided critical analytical support for EMEA Plan and PEx initiatives, contributing to the Gold Achievement Award.
Engineered end-to-end data pipelines, integrating multiple data sources (SAP, Oracle Demantra, JD Edwards) into a centralized analytics platform. Led the transition from legacy Cognos systems to modern Tableau environments, enabling real-time insights and reporting.
Implemented rigorous data governance standards and executed user acceptance testing for core demand planning systems, ensuring data integrity, compliance, and seamless integration of analytical capabilities with business processes.
Collaborated cross-functionally to develop detailed user requirements for inventory projection reports, integrating financial KPIs and improving cash flow management. Leveraged SQL, Tableau, and various production systems to optimize the reporting environment, ensuring data accuracy and reliability.

Supply & Inventory Management Travel Retail World

03/2016 - 07/2014

Estée Lauder Companies, Wollerau, Switzerland

Managed inventory for seven key brands contributing to 45% of revenue.
Significantly reduced La Mer and Bobbie Brown out-of-stocks by 64% and 40% respectively using data analytics to improve demand forecasting and backorder management.

Global Demand & Supply Planner Consumer Goods Business

02/2014 - 02/2013

Swarovski, Triesen, Liechtenstein

Led a Six Sigma/Green Belt project to assess sales impacts.
Developed a tool for supply load projection.
Conducted big data analysis for demand and supply planning significantly influencing company revenue strategies.