Stephane Ruault, Data Engineer and Developer in Bogotá - Bogota, Colombia
Stephane Ruault

Data Engineer and Developer in Bogotá - Bogota, Colombia

Member since July 17, 2020
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.
Stephane is now available for hire

Portfolio

  • BCG
    Snowflake, Python, GitHub, Confluence, Jira, Apache Airflow, Python 3...
  • Loom
    Stripe, RevOps, Snowflake, Tableau
  • Finartis
    Oracle, Relational Databases, PL/SQL, Oracle PL/SQL

Experience

Location

Bogotá - Bogota, Colombia

Availability

Part-time

Preferred Environment

Amazon Web Services (AWS), Python, AWS, SQL, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Database Design, Data Modeling, Data Analysis, Complex Data Analysis, Dashboards

The most amazing...

...impact analysis I've developed was for disease programs around the world based on WHO data.

Employment

  • Data Engineer

    2021 - PRESENT
    BCG
    • Managed data integration projects from data providers to the in-house data lake Lighthouse.
    • Tracked and reported on the integration status, worked with stakeholders to collate requirements, and drove projects to completion. Developed processes to increase the velocity and quality of projects.
    • Delivered the user documentation and data platform on Snowflake to the enablement team.
    • Maintained a key asset template and checklist, drafted documentation for technical audiences, worked with marketing, and enabled teams to create compelling user-focused documentation.
    • Implemented the data integration processes in Python and Airflow. Provided hands-on set up of automated data feeds, end-user data views, API access. Facilitated monitoring, reporting, and technical access limitations.
    • Ensured that end-users could access resources through User Portal, lighthouse toolkit, and other modalities.
    Technologies: Snowflake, Python, GitHub, Confluence, Jira, Apache Airflow, Python 3, Data Analysis, Big Data, Data, Data Architecture, CSV File Processing, Data Engineering, AWS S3, Git, Data Analytics, Cloud, Consulting, Pandas, Database Modeling
  • SQL Developer

    2021 - PRESENT
    Loom
    • Developed advanced queries on Stripe to produce accrual revenue recognition from cash basis invoices and payments.
    • Participated in the NetSuite implementation project.
    • Worked with RevOps support to align the live contracts to the reporting platform.
    Technologies: Stripe, RevOps, Snowflake, Tableau
  • Data Integration | PL/SQL Engineer

    2021 - 2021
    Finartis
    • Developed the integration interfaces to load positions and transactions sent by banks to the wealth management platform.
    • Implemented the mappings of transactions and positions.
    • Integrated the work done to Jenkins CI continuously.
    Technologies: Oracle, Relational Databases, PL/SQL, Oracle PL/SQL
  • Data Scientist

    2020 - 2021
    Blue Orange
    • Migrated a locally developed Markov model used in student loan analysis from R Studio IDE to AWS cloud. As a result, increased access, adaptability, and collaboration.
    • Increased model run times by 12x compared to its initial inference speed by refactoring and optimizing a locally developed student loan financial model.
    • Deployed the optimized model to cloud-based notebook environments managed with AWS. Implementing the SageMaker tool, I deployed, managed, and customized Notebook instances according to the client's needs.
    • Architected and implemented a model development flow based on a predefined notebook template. This guided model development flow enabled non-technical employees to duplicate, modify, and interact with their models.
    Technologies: Amazon SageMaker, R, AWS, Amazon Web Services (AWS), AWS S3, Software as a Service (SaaS), Snowflake, Data Analysis, Complex Data Analysis, Big Data, Data, Data Engineering, Solution Architecture
  • Data Scientist

    2019 - 2020
    Citi Group
    • Designed and implemented a big data discovery tool capable of saving vast amounts of time in the process through metadata anaytics.
    • Analyzed the financial behavior of global corporations through their payments.
    • Enabled a notifications center for opportunities for clients to use the most optimized financial products. Integration to a dashboard using Arcadia Data.
    • Wrote complex queries to identify business opportunities from global transactions stored in a data lake on Cloudera.
    • Led a team of four to coordinate business requirements priorities and a deliverable schedule.
    Technologies: DataRobot, SQL, Python 3, Arcadia, Cloudera, International Business, Finance, Reports, BI Reporting, Reporting, Key Performance Indicators (KPIs), Data Modeling, Data Warehouse Design, Data Warehousing, Data Analysis, Complex Data Analysis, Big Data, Dashboards, Dashboard Design, Dashboard Development, Data, Data Architecture, Databases, Database Development, ETL, Data Engineering, Hadoop, Spark, Data Profiling
  • Senior Business Intelligence Consultant

    2014 - 2016
    The Global Fund
    • Improved the query performance by 40% and simplified the ETL processes on the SQL Server 2012 by designing and implementing the human resources data mart, enabling workforce analytics at the global level.
    • Measured the performance and impact of programs implemented by the country and disease delivered to OBIEE dashboards.
    • Delivered the KPI dashboards giving the board a high-level view of the programs on Oracle BI.
    • Led an offshore team of six back-end developers in India to implement BI apps for procurement.
    • Migrated an on-premises Oracle BI solution to the cloud.
    Technologies: SQL Server 2012, Oracle Apps, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), SQL, Database Design, Data Visualization, Oracle, Reports, BI Reporting, Reporting, Data Warehouse Design, Key Performance Indicators (KPIs), Software as a Service (SaaS), Data Modeling, Data Warehousing, Data Analysis, Complex Data Analysis, Dashboards, Dashboard Design, Dashboard Development, Data, Data Architecture, Databases, Database Development, ETL, Data Engineering, Microsoft SQL Server, Solution Architecture, Oracle Application R12 EBS, OBIEE Answers, Database Modeling
  • Business Intelligence Consultant

    2011 - 2013
    Technip
    • Implemented a balanced scorecard, aligning group strategy to KPIs.
    • Delivered an OBIEE (Oracle Business Intelligence Enterprise Edition) interactive dashboard for health, safety, and environment events. Provided the analytics and statistics of accidents and their causes at petrol sites.
    • Reverse-engineered the source system data model, a Synergy system for HSE, to a Snowflake model in the DWH stored on the Oracle DB.
    Technologies: Oracle, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), SQL, Database Design, Data Visualization, Reports, BI Reporting, Reporting, Data Warehouse Design, Key Performance Indicators (KPIs), Data Modeling, Data Warehousing, Data Analysis, Complex Data Analysis, Dashboards, Dashboard Design, Dashboard Development, Data, Data Architecture, Databases, Database Development, ETL, Data Engineering, Solution Architecture, Relational Databases, Oracle BI Publisher, OBIEE Answers, Database Modeling
  • Business Intelligence Consultant

    2010 - 2011
    EurosportsBet
    • Developed analytical reports for all departments, specifically management, finance, fraud and responsible gaming, marketing, and customer service.
    • Audited and improved performance on Qlikview Server to an acceptable level.
    • Built and calculated gaming statistics and probabilities.
    Technologies: Business, Oracle, PostgreSQL, QlikView, SQL, Data Visualization, Reports, BI Reporting, Reporting, Data Warehouse Design, Key Performance Indicators (KPIs), Data Warehousing, Data Analysis, Complex Data Analysis, Dashboards, Dashboard Design, Dashboard Development, Data, Data Architecture, Databases, Database Development, ETL, Data Engineering
  • Oracle Consultant

    2009 - 2011
    Groupe FLO
    • Installed Oracle BIEE, identified relevant data sources, created the physical and logical model, including facts and dimensions, interactive reports, dashboards, and gauges.
    • Installed and configured the Discoverer 11g components, including metadata via RCU, WebLogic and Discoverer. Upgraded EUL to 11g.
    • Set up and configured the Oracle e-Business Suite. Reconciled AR, AP, and GL. Developed the bespoke financial reports.
    • Developed complex reports analyzing consumer behavior in restaurants.
    Technologies: Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle Discoverer, Oracle Apps, SQL, Oracle, Finance, Reports, BI Reporting, Reporting, Key Performance Indicators (KPIs), Data Modeling, Data Analysis, Complex Data Analysis, Dashboards, Dashboard Design, Dashboard Development, Data, Data Architecture, Databases, Database Development, ETL, Data Engineering, EBSr12, Oracle Application R12 EBS, Oracle BI Publisher, Oracle E-Business Suite (EBS) R12, OBIEE Answers
  • Oracle Consultant

    2010 - 2010
    Mastercard
    • Oversaw regulatory compliance with Sarbanes-Oxley (SOX) and met the Payment Card Industry (PCI) requirements.
    • Implemented Oracle Advanced Security Transparent Data Encryption.
    • Initiated an audit trail using Oracle Audit Vault.
    • Managed a junior resource to be self-sufficient in maintenance tasks.
    Technologies: Oracle, PCI DSS, Transparent Data Encryption, Oracle Audit Vault, Finance, Data, Data Architecture, Databases, Database Development, Data Engineering
  • Oracle Consultant

    2009 - 2009
    U10
    • Installed Oracle Discoverer. Created the End-User-Layer in the data mart.
    • Set up users and their roles and responsibilities. Built the logic model of the EUL.
    • Delivered a training workshop for administrators and end-users.
    Technologies: Oracle Discoverer, SQL, Oracle, Data Analysis, Dashboards, Data, Data Architecture, Databases, Database Development
  • Business Analyst

    2009 - 2009
    RATP
    • Gathered, followed up on, and resolved functional anomalies around AR, AP, PO, eTax, and GL modules.
    • Created and resolved service requests with Oracle.
    • Provided functional user assistance and anomaly resolution around EBS R12 financial modules.
    Technologies: Oracle Apps, Oracle, Reports, Data, Data Architecture, Databases, Database Development, Oracle EBS, EBSr12, Oracle E-Business Suite (EBS) R12
  • Oracle Consultant

    2007 - 2008
    CMA-CGM
    • Spearheaded the international roll-out of the Oracle financial solution for shipment booking agencies in France, South Korea, Hong Kong, and Japan.
    • Managed the data migration of customer and supplier referential from the old system to open transactions and trial balances.
    • Handled the business processes training. Provided support to key and end-users.
    Technologies: Oracle Apps, SQL, Oracle, International Business, Data, Data Architecture, Databases, Database Development, Oracle Application R12 EBS, EBSr12, Oracle E-Business Suite (EBS) R12
  • Oracle Consultant

    2003 - 2005
    Parcours
    • Completed the redesign of the operational information system for B2B vehicle financing. Interfaced flows between the operating system and accounting in Oracle applications.
    • Provided a budgetary forecast according to a five-year business plan to set up different possible scenarios. Created the interactive analytical reports using Oracle Discoverer.
    • Managed the bank loans, vehicle financing, vehicle depreciation, and constructor repayments. Settled the client and supplier invoicing and completed direct debit transmissions.
    • Oversaw the pricing, contracts, and the integration of the vehicles catalog. Managed the used car sales, the detection of petrol card use anomalies, and the analytical accounting reports.
    • Completed the design of the operational system and the underlying database design.
    • Led a team to completely design and develop the web page listing second-hand vehicles. This business process was automatically captured from rental contract ending and actual car returns.
    • Created a customer extranet to provide them with analytical tools for their vehicles on lease and management contracts. Helped clients manage the contracts coming to term with a system in the form of customized alerts.
    • Migrated specific applications in Google Forms and Reports 6i to 10g, adapted from a client and server to web mode.
    • Implemented interactive analytical reports, modeled the analytical segments, linked them to accounting key segments in Oracle applications, handled the set up of business areas, and created worksheets in Oracle Discoverer.
    Technologies: Oracle Discoverer, Oracle Apps, Oracle PL/SQL, Oracle, SQL, Database Design, Data Visualization, Reports, BI Reporting, Reporting, Data Warehouse Design, Data Modeling, Data Analysis, Complex Data Analysis, Dashboards, Dashboard Design, Dashboard Development, Data, Data Architecture, Databases, Database Development, ETL, Data Engineering, Solution Architecture, Relational Databases, Oracle Forms & Reports, Oracle Application R12 EBS, Oracle E-Business Suite (EBS) R12, Database Modeling

Experience

  • Big Data Discovery Tool

    The metadata of the data lake was maintained offline and not always up to date.
    Taking this functionality one step further, I created a Python-based query tool to discover actual data in the data lake without querying existing tables.

    The tool queries the metadata of the data lake with string filter capability to reduce end queries to the resulting objects (tables and columns). Queries are built dynamically with a filter value to search in the resulting objects.

    For example:
    The user enters a string to filter the table names containing that string and optionally another string to return those tables, including a field with that second string. Then an additional parameter string to be used as a filter clause on the resulting areas is added.
    The end report is a frequency table of records found in those tables containing that field with that value.

  • Markov Model Migrated to AWS Cloud - 12x’s Faster
    https://blueorange.digital/casestudy/markov-model-migrated-to-aws-cloud-12xs-faster/

    Challenges:
    Local development environments are inherently limited. There was no possibility to easily share results nor engage other team members in model development.

    The existing codebase was inefficient, which resulted in a slow development speed. Since the company required multiple similar models to be developed, this did not align with its long-term goals.
    The existing codebase was not following best practices, which made it expensive to maintain, with each further code change costing the company both money and time.

    Local model development was not sustainable. Without versioning and keeping track of models, it was impossible to reuse them across different applications.

    Model migration: From local development to cloud-based notebooks.
    I refactored and optimized a locally developed student loan financial model. The effects of our work could be seen immediately; after refactoring, the model could run 12x times faster compared to its initial inference speed. I migrated the local codebase to a cloud-based notebook environment, created a guided model development flow, and provided technical support.

  • HR Analytics Platform

    The Global Fund had limited capability for analytics of the HR activity managed in Oracle e-Business Suite and SumTotal. A DWH was already in production from a prior team, but I identified a design flaw and alerted the project team about its long-term viability. Having committed to the project and its delivery schedule, the client decided to continue the analytics platform development.

    Following various interviews with HR business partners and managers, around ten core metrics were highlighted, and dimensions were identified to slice these metrics. At the end of the successful delivery of interactive dashboards on Oracle OBIEE, the HR users noticed degrading query performance over time due to the design flaw of the DWH.

    I went back to the DWH design and modified it, reducing data volume by 95%, improving query performance by 40%. This correction was done without affecting the analytics application, which has three layers (physical, logical, presentation) separate from each other.

    Testimonial from Mike Hayward: "Stephane got us to a stable platform, we moved into a second phase of delivering even more productivity from BI. I wholeheartedly recommend him not only for his technical skills but his attitude and his social skills."

  • Client Testimonials

    Groupe FLO Testimonial: "Stéphane is a passionate, enthusiastic, and competent BI and ERP professional. EBS, OBIEE, databases fascinate him. His optimistic character allows him to integrate into teams and forge lasting relationships."— MC Jaurand, IT Manager.

    Technip Testimonial: "Stephane was a great contributor to deploy our BI strategy using OBIEE. His knowledge of the tool, along with his business understanding, was instrumental to the success of our project. " —Jean-Luc Brunat, VP TechnipFMC.

    The Global Fund Testimonials: "Stéphane was initially brought in to rescue a BI project on the verge of collapsing. In a matter of a few weeks, he proposed an action plan and rebuilt the entire BI layer." —Stephane Vignoud, Data and Integration Manager.

    "Stéphane got us to a stable platform and delivered even more productivity from BI. I wholeheartedly recommend Stéphane, not only for his technical skills but his attitude and social skills." —Mike Hayward, HR at Global Fund.

Skills

  • Languages

    SQL, R, Python 3, Python, Snowflake
  • Tools

    Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle Application Express (APEX), OBIEE Answers, Microsoft Power BI, Microsoft Excel, BigQuery, Plotly, Microsoft Access, Oracle BI Publisher, Oracle E-Business Suite (EBS) R12, Cloudera, DataRobot, Amazon SageMaker, Git, GitHub, Confluence, Jira, Apache Airflow, Tableau, Looker, EBSr12
  • Paradigms

    Business Intelligence (BI), Database Development, Database Design, ETL, Data Science
  • Platforms

    Oracle, Amazon Web Services (AWS), QlikView, Jupyter Notebook
  • Storage

    Oracle PL/SQL, Databases, Relational Databases, PostgreSQL, Microsoft SQL Server, Database Modeling, SQL Server 2012, AWS S3, PL/SQL, Graph Databases, Neo4j
  • Other

    Oracle Discoverer, Data Visualization, Reports, BI Reporting, Reporting, Data Warehouse Design, Data Modeling, Data Warehousing, Data Analysis, Dashboard Development, Data, Data Profiling, AWS, International Business, Finance, Arcadia, Oracle Apps, Key Performance Indicators (KPIs), Complex Data Analysis, Big Data, Dashboards, Dashboard Design, Data Architecture, CSV File Processing, Data Engineering, Cloud, Solution Architecture, Consulting, Excel 365, Oracle Forms & Reports, Software as a Service (SaaS), PCI DSS, Transparent Data Encryption, Oracle Audit Vault, Machine Learning Automation, Oracle Application R12 EBS, Oracle HRMS, Data Analytics, Machine Learning, Amazon Machine Learning, RevOps, Oracle EBS
  • Frameworks

    Hadoop, Spark
  • Libraries/APIs

    Stripe, Pandas

Education

  • Master's Degree in Data Science
    2017 - 2019
    Data ScienceTech Institute - Nice, France
  • Master's Degree in Business Administration (MBA)
    1998 - 2000
    Temple University - Philadelphia, USA
  • Bachelor's Degree in Business
    1993 - 1997
    Victoria University of Technology - Melbourne, Australia

Certifications

  • Machine Learning on AWS
    JULY 2021 - PRESENT
    Amazon Web Services
  • Data Analytics on AWS
    JULY 2021 - PRESENT
    Amazon Web Services
  • DataRobot Essentials
    JULY 2020 - PRESENT
    DataRobot
  • AWS Certified Solutions Architect
    FEBRUARY 2019 - FEBRUARY 2021
    Amazon Web Services
  • Big Data Foundations
    JUNE 2017 - PRESENT
    IBM
  • Oracle Business Intelligence 11g Certified Implementation Specialist
    NOVEMBER 2010 - PRESENT
    Oracle

To view more profiles

Join Toptal
Share it with others