Stéphane R.

Stéphane R.

Senior Data Engineer

Bogota, Colombia
Hire Stéphane R. Hire Stéphane R. Hire Stéphane R.

About Me

Stephane has 20 years of international experience with data analytics and business process optimization. He excels in DB design, BI, ML algorithms, big data, and predictive analytics that automate processes empowering clients to focus on value-added activities. He developed an impact analysis for disease programs based on WHO data. Stephane is passionate about risk management. He understands business challenges and uses strategic tools to engineer predictive models and deliver E2E solutions.

Work history

UpStack
UpStack
Senior Data Engineer
2022 - Present (2 years)
Remote
  • Worked with databases, acquiring Data, ETL/ELT, big data pipelines, and cloud services, also implementing and training teams to use SVN version control system.

  • Collaborate with analytics and development teams to improve data models, increasing data accessibility and fostering data-driven decision making across the organization.

  • Works closely with teams of software engineers, product managers, and other stakeholders.

Freelance
Freelance
Data Scientist / BI & Data Engineer
2021 - Present (3 years)
Remote
  • Manage and provide data expertise for integrations from different providers to BCG's in-house data lake lighthouse.

  • Built new integration interfaces on Finartis' wealth management platform - mapping transactions and positions.

  • Executed advanced queries and provided data solutions on the NetSuite implementation project for Loom.

Blue Orange Digital
Blue Orange Digital
Data Scientist
2020 - 2021 (1 year)
Bogota, Colombia
  • Migrated a local Markov model for student loan analysis to AWS - increasing access, adaptability and model run times by 12x.

  • Optimized the model and implemented SageMake to handle Notebook instances per client requirements.

  • Designed and implemented a new model development flow to help non-technical staff duplicate, modify and interact with models.

Citi
Citi
Data Scientist
2019 - 2020 (1 year)
Bogota, Colombia
  • Led the data science team to define data strategy, priorities and deliverable schedules on the project.

  • Built a big data discovery tool that helps to save time through metadata analytics.

  • Engineered a notifications centre dashboard integrated with Arcadia Data to help clients identify financial products.

Click-to-Meat
Click-to-Meat
Data Scientist
2016 - 2018 (2 years)
Paris, France
  • Standardized, collected, normalized, cleaned, and integrated data on the Click-to-Meat platform.

  • Created trustworthy datasets and KPIs to enhance correlation and threshold analysis on the platform.

  • Built and implemented new solutions to transform legacy platforms into modern, data-oriented solutions.

The Global Fund
The Global Fund
Business Intelligence Specialist
2014 - 2016 (2 years)
Geneva, Switzerland
  • Led a team of 6 backend developers to design, implement and maintain BI apps for TGF.

  • Implemented a new data mart by simplifying ETL processes on a SQL Server to enhance query performance by 40%.

  • Designed KPI dashboards for the TGF Board and migrated the on-premise BI solution to the cloud.

Technip
Technip
Oracle BI Consultant
2011 - 2013 (2 years)
Paris, France
  • Designed and deployed a new OBIEE interactive dashboard with analytics for health, safety, and environmental events.

  • Built a new source system data model and deployed a Snowflake model in the DWH for Technip.

  • Executed a balanced scorecard solution to align Technips group strategy with business KPIs.

Axande
Axande
Oracle Applications & BI Consultant
2006 - 2011 (5 years)
Paris, France
  • Worked with the latest Oracle-based financial analytics tools to provide data-driven solutions for clients.

  • Recommended appropriate solutions for implementing Oracle and BI reports on projects.

  • Provided clients with detailed, actionable reports on projects - documenting findings from data processing and analysis.

Portfolio

Business Intelligence Specialist - The Global Fund
Business Intelligence Specialist - The Global Fund

Designed and deployed a new analytics platform to manage HR activities within TGF - repairing a flawed legacy DWH solution on the Oracle EBS. Enhanced KPIs for the system and delivered an OBIEE dashboard with reduced data volume and improved query performance - leading to improved productivity for the HR team.

Data Engineer - Blue Orange Digital
Data Engineer - Blue Orange Digital

Migrated an inefficient, time-consuming and redundant local Markov development platform to cloud-based notebooks on AWS - refactoring and optimizing solutions on the platform. Developed a guided model development flow and provided technical support on the project.

Data Scientist - Metadata Functionality
Data Scientist - Metadata Functionality

Enhanced the metadata functionality for a data lake platform maintained offline - creating a Python-based query tool to help discover the actual data in the data lake without querying existing tables. Developed a tool to query the metadata using string filter capabilities to reduce end queries for resulting objects.

Education

Education
AWS® Certified Solutions Architect - Associate
AWS
2019 - 2019
Education
MSc. Applied Data Science and Big Data
Data ScienceTech Institute
2017 - 2018 (1 year)
Education
Oracle® OBIEE 11g Implementation Specialist
Oracle
2010 - 2010
Education
MBA, International Business
Fox School of Business at Temple University
1998 - 1999 (1 year)
Education
Bachelor of Business
Victoria University
1993 - 1998 (5 years)