You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Aurélien SchrickeAS

Aurélien Schricke

Supermalter

Decision Support Consultant | Business Product Owner

On-demand
16 projects
Saint-Étienne, FR
15+ years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Aurélien

Extensive experience (~20 years) in supporting activity management in the Pharmaceutical sector (Research and Development and Commercialization).

Business Product Owner of an Artificial Intelligence solution for recommendation and optimization of marketing plans for medical representatives, in charge of configuration and Reporting applications.

Deployment of project management tools (Ms Project, Planisware, Trello, etc.) and user training. Rationalization and improvement of activity and resource planning, capacity analysis (strategic planning and operational planning)...

Consulting in the development and deployment of performance management tools. Identification and definition of Key Performance Indicators (KPIs), implementation of dashboards linked to existing information systems.

Development of automated data analysis and processing tools (ETL). Connection to data sources, processing/transformation/data quality improvement, and development of data analysis and reporting dashboards.

Development of decision support applications for project/portfolio management, activity and resource management, process improvement, results analysis, document management.

Consulting and operational support for Continuous Improvement initiatives (Lean Services) and process optimization (BPMN) in an R&D environment.

Process/task automation (UI Path)
Proficiency in data processing tools (MS PowerBI, Qlik, Business Objects, Snowflake, MS Access, etc.)
Expert in Microsoft Office tools (TOSA certified MS Excel 943/1000)
Proficiency in specific clinical research business tools (CTMS, eCRF, Veeva, etc...)
  • French

    Native or bilingual

  • English

    Fluent

  • German

    Basic

Can work on-site
Saint-Étienne (up to 50km), Lyon (up to 100km), Paris (up to 50km)

Experience

  • Johnson & Johnson Innovative Medicine
    Business Product Owner for an AI Program
    PHARMACEUTICALS INDUSTRY
    July 2022 - July 2025 (3 years)
    Issy-les-Moulineaux, France
    Mission within the Data and Analytics department, I am responsible for the development of new reporting and data analysis applications for the Europe, Middle East, and Africa region, in conjunction with an artificial intelligence solution for recommending customer interactions within the framework of marketing plans.

    Among my main responsibilities:
    - I ensure the strategic alignment of the vision for the products I am responsible for
    - I ensure the return on investment of innovations made on these products
    - I manage the development team's roadmap, I populate the backlog with new features to be developed, for which I gather client requirements and create User Stories
    - I participate in the deployment, training, and adoption of the developed products
    - I am the guardian of the "Voice of the Customer" and ensure that all developments are in line with customer needs.

    Key results:
    - Deployment (scaling) and improvement of an AI program configuration tool that optimizes marketing plans.
    - Development and deployment (scaling) of a Reporting tool that allows for the review, validation, and monitoring of pharmaceutical laboratory drug marketing plans.
    - Weekly use in over 26 countries, by more than 160 users
    - Management of an average annual budget of €350k
    Artificial Intelligence Business Intelligence Strategic Planning Training Product Roadmap
  • SERVIER MONDE
    Data Designer Consultant - Ad-hoc R&D Developments
    PHARMACEUTICALS INDUSTRY
    October 2020 - June 2021 (9 months)
    Suresnes, France
    For the R&D Quality Assurance Department.
    Development of a management tool for the department's annual performance plans, covering the monitoring of over 1,700 quality documents and training for 80 employees worldwide.

    - Gathering client needs. Stakeholder interviews. Translating needs into functional specifications.
    - Project scoping. Planning development. Workload estimation.
    - Tool development using Excel® and VBA, SharePoint®. Assistance in creating KPIs in PowerBI®.
    - Setting up progress meetings with the client and incorporating modifications.
    - Phased product delivery (agile mode). User guide writing.

    Results: Better management of annual Quality Plans through data reliability, sharing, and monitoring of objective achievement. Process improvement (60% time savings).
    Business Intelligence Microsoft Power BI Microsoft Excel SQL
  • SERVIER MONDE
    Data Designer Consultant - Ad-hoc R&D Development
    PHARMACEUTICALS INDUSTRY
    October 2019 - September 2020 (1 year)
    Suresnes, France
    For the R&D Operations Department.
    Evolution of a project budget reconciliation tool (Actual/Committed/Budgeted).

    - Project scoping. Planning development. Workload estimation.
    - Tool development using Excel® and VBA, SharePoint®.
    - Connecting the tool to various data sources (Planisware®, e-CTMS, invoice tracking tools).
    - Reconciliation table (matching) of expenses/budgets.
    - Consolidation, issuance of alert reports.

    Results: Improved visibility on budgets and commitments for project teams. Project budgets are better monitored and adhered to.
    Microsoft Excel Budget Management Project Management

Reviews

5.0

Out of 3 ratings

A

Aurélien

Janssen Belgium

Reviewed on 4/3/2023

I had the pleasure of working with Aurélien and I must say that it was a great experience. He is one of the most dedicated and hardworking freelancers I have ever worked with. He approaches every project with a high level of professionalism and rigor, which ensures that the end result is of the highest quality.
A

Aurélien

Janssen

Reviewed on 1/16/2023

Aurélien worked in our EMEA team to manage the dashboards for an artificial intelligence solution in customer engagement. He worked full-time (5 days/week) for a few months. Aurélien was a real asset to our team. His expertise in data project management allowed us to optimize our processes and improve the quality of our dashboards. He was also very effective in gathering user requirements and implementing new tools. Furthermore, he always demonstrated professionalism and it was a pleasure to work with him. I highly recommend this consultant for any project management assignment with a data component!

Recommendations

Be the first to recommend Aurélien

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Specialized Master in Innovation Management in Agri-business and Bio-industries
    AgroParisTech and NEOMA Business School
    2005
    Gestion de projet, Propriété intellectuelle, Management, Contrôle de gestion, Etudes de marchés, Marketing opérationnel, Business Plan, Elaboration d'un projet d'innovation
  • DEA in Microbiology and Biotechnology
    University of Provence (Aix-Marseille I)
    2003
    Microbiologie aérobie et anaérobie, biologie moléculaire, séquençage d'ADN, génomique, caractérisation de souches bactériennes, extraction, séparation.

Skill set

Categories