
Stephane Ruault
Verified Expert in Engineering
Data Engineer and Developer
Bogotá - Bogota, Colombia
Toptal member since November 30, 2020
Stephane possesses an impressive 24 years of international experience in data analytics and business process optimization. Throughout his career, he has excelled in various areas, including database design, business intelligence (BI), machine learning algorithms, big data, and predictive analytics. Stephane's expertise lies in developing solutions that automate processes, allowing clients to allocate their efforts toward value-added activities.
Portfolio
Experience
- SQL - 20 years
- Data Modeling - 20 years
- Data Analytics - 18 years
- Business Intelligence (BI) - 15 years
- Data Visualization - 15 years
- Data Engineering - 10 years
- Amazon Web Services (AWS) - 5 years
- Python - 2 years
Availability
Preferred Environment
Amazon Web Services (AWS), Python, SQL, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Database Design, Data Modeling, Data Analysis, Complex Data Analysis, Dashboards
The most amazing...
...thing I've created is an impact analysis framework based on data from the World Health Organization, contributing greatly to the field of disease programs.
Work Experience
SQL Developer
Loom
- Enabled the accurate calculation of accrual revenue recognition based on cash-basis invoices and payments—utilizing advanced techniques on the Stripe platform to develop and execute complex queries.
- Participated actively in the implementation project for NetSuite, a cloud-based ERP system, contributing expertise in revenue recognition processes and ensuring seamless integration with existing systems.
- Collaborated closely with the revenue operations support team, aligning live contracts with the reporting platform to ensure accurate and consistent reporting of financial data.
- Implemented interactive and insightful analytics dashboards using Tableau, utilizing data from Snowflake sources, providing stakeholders with valuable insights and visualizations to support data-driven decision-making.
- Leveraged the capabilities of Stripe Sigma, a powerful SQL-based analytics tool, to write complex queries for revenue analysis, enabling in-depth examination of revenue trends, patterns, and performance.
SQL Database Expert
Wagner-Group - Main
- Implemented an automation solution in FactoryTalk to load recipes from an external database, set the PLC tags accordingly, get the tag values from the test machines, and store these test results in a database for future QA analysis.
- Implemented code in VBA to interact with the FactoryTalk HMI and the PLC tags.
- Designed and implemented the data model to store the recipes and the test results.
NetSuite Developer
GTCR, LLC
- Connected to a NetSuite data source to run direct SQL queries.
- Wrote in SQL the equivalent of a NetSuite report building a hierarchy in the account dimension.
- Made the dataset available to TM1, an external data warehouse.
Data Analyst
Ryerson University
- Conducted comprehensive research and gathered publicly available data sets on greenhouse gas (GHG) emissions, specifically in Toronto, focusing on understanding the current environmental landscape.
- Employed advanced analytical techniques to analyze the policies implemented to achieve net zero emissions, assessing their effectiveness and impact on GHG reduction.
- Developed and deployed a predictive model to forecast the potential outcome of the policy implementation, enabling a quantitative assessment of its effectiveness.
- Concluded that initiatives proposed by the policy were insufficient to attain the targeted GHG emission reductions, providing valuable insights and recommendations for further action to address the gap between current efforts and the desired goals.
Stripe Data Analyst
Kalkomey
- Developed and executed complex queries on the Stripe payment processing platform to generate comprehensive tax reports, ensuring accurate and timely tax compliance for the organization.
- Acted as a trusted advisor, guiding clients on leveraging the full potential of their Stripe data to maximize benefits and optimize financial processes.
- Delivered customized reporting tools to the finance team, enabling effective access and analysis of Stripe data. These reporting tools provided valuable insights and streamlined financial reporting processes.
Lead BI Data Architect and Developer
SALT's
- Conducted comprehensive information gathering on data sources and locations, engaging with key stakeholders and business data users to understand their data requirements and the specific insights they sought to uncover.
- Developed a strategic plan to access the necessary data effectively.
- Provided expert recommendations on architecture, tools, and software to ensure optimal data management and analytics capabilities. Developed connectors to establish seamless connectivity with diverse data sources.
- Implemented robust security measures to restrict access to personally identifiable information and other sensitive data within the BI system, ensuring only authorized individuals were granted appropriate access privileges.
- Spearheaded the implementation of a user-friendly, self-service reporting tool and dashboard featuring key initial reports to empower users to generate insights.
- Established a data lake utilizing AWS services, enabling data extraction from external exchanges and facilitating efficient data storage and retrieval.
- Created a comprehensive self-service data analytics catalog within Amazon QuickSight, offering users a wide range of tools and resources to analyze and visualize data autonomously.
- Pre-built various impactful dashboards tailored explicitly for marketing and asset management teams, providing them with quick and actionable insights to drive informed decision-making.
Data Engineer
BCG
- Led and managed data integration initiatives, overseeing the seamless flow of external data from providers into the in-house data lake, Lighthouse, hosted on the Snowflake platform.
- Monitored and reported on the integration progress, collaborating closely with stakeholders to gather requirements and driving projects to successful completion.
- Developed and implemented streamlined processes to improve project velocity and maintain high-quality standards.
- Delivered comprehensive user documentation and a robust data platform to the enablement team, allowing efficient data lake onboarding and utilization.
- Maintained a crucial asset template and checklist, authored technical documentation targeting technical audiences, and collaborated with marketing and enablement teams to produce engaging user-focused content.
- Implemented Python and Airflow-based data pipelines, ensuring reliable data ingestion, monitoring capabilities, reporting on functionalities, and enforcing necessary technical access limitations.
- Configured and established complex business data views within Snowflake, enabling end-users to access curated data sets catering to their needs.
- Managed the service level agreement with data providers for the subscription-based data lake, ensuring timely and reliable delivery of data and maintaining strong working relationships.
Data Integration and PL/SQL Engineer
FINARTIS
- Orchestrated the development of integration interfaces responsible for efficiently loading positions and transactions received from various banks into the wealth management platform.
- Took charge of implementing accurate mappings for transactions and positions, ensuring seamless integration and data consistency within the system.
- Integrated the development work into Jenkins CI, establishing a robust continuous integration process to enhance efficiency and maintain quality standards throughout the project.
Data Scientist
Blue Orange
- Enhanced accessibility, adaptability, and collaboration capabilities by migrating a locally developed Markov model for student loan analysis from the RStudio integrated development environment to the AWS cloud infrastructure.
- Improved the performance of a student loan financial model significantly by refactoring and optimizing its codebase, resulting in a 12x increase in model run times compared to its initial inference speed.
- Implemented the deployment of the optimized model to cloud-based notebook environments using Amazon SageMaker. Effectively managed and customized notebook instances according to the client's specific requirements.
- 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.
Data Scientist
Citi
- Gained significant time savings by developing and deploying a Python-based big data discovery tool, leveraging metadata analytics.
- Conducted a comprehensive analysis of financial behavior within multinational corporations by examining payment data, providing valuable insights and recommendations.
- Implemented a notifications center to facilitate clients accessing optimized financial products, seamlessly integrating it with a dashboard powered by Arcadia Data.
- Crafted intricate queries to extract meaningful business opportunities from vast global transaction datasets stored in a Cloudera data lake.
- Orchestrated a team of four professionals, overseeing the coordination of business requirements prioritization and delivering projects on schedule.
Senior BI Consultant
The Global Fund
- Enhanced query performance on Oracle DB by 40% through effective optimization techniques, improving system efficiency.
- Streamlined ETL procedures on SQL Server 2012 by conceptualizing and implementing a comprehensive human resources data mart. This initiative facilitated global workforce analytics by simplifying data integration processes.
- Evaluated the efficacy and consequences of country and disease programs through meticulous assessment, subsequently presenting findings on OBIEE dashboards.
- Developed and delivered KPI dashboards on Oracle BI, offering the executive board a comprehensive overview of program performance.
- Spearheaded and coordinated a remote team of six proficient back-end developers located in India, directing the implementation of BI applications for procurement purposes.
- Executed the migration of an on-premises Oracle BI solution to the cloud, ensuring a seamless transition and leveraging cloud-based capabilities for enhanced system performance and scalability.
BI Consultant
TechnipFMC
- Aligned group strategy with KPIs by implementing a balanced scorecard, driving performance and strategic alignment.
- Delivered an interactive OBIEE dashboard for health, safety, and environment events, offering analytics and statistics on accidents and causes at petrol sites.
- Improved data integration and reporting capabilities by reverse-engineering the data model of a Synergy system for HSE, creating a multi-dimensional model in the data warehouse (DWH) stored on Oracle DB.
BI Consultant
EurosportsBet
- Developed comprehensive analytical reports catering to various departments, including management, finance, fraud and responsible gaming, marketing, and customer service, enabling data-driven decision-making and actionable insights.
- Conducted an audit of QlikView Server performance and implemented improvements, optimizing its performance to meet acceptable standards and ensuring efficient data processing and visualization capabilities.
- Designed and implemented gaming statistics and probability calculations, enabling accurate measurement and analysis of gaming outcomes—supporting strategic decision-making and enhancing the gaming experience.
Oracle Consultant
Groupe Flo
- Installed Oracle BIEE and efficiently identified and integrated relevant data sources. Created robust physical and logical models encompassing facts, dimensions, interactive reports, dashboards, and gauges.
- Managed the installation and configuration of Discoverer 11g components, including metadata using RCU, WebLogic, and Discoverer. Executed an upgrade of the End User Layer (EUL) to 11g.
- Established and set up Oracle E-Business Suite (EBS), seamlessly integrating and reconciling the accounts receivable (AR), accounts payable (AP), and general ledger (GL) modules. Built customized financial reports tailored to business requirements.
- Developed intricate reports analyzing consumer behavior within the restaurant industry, utilizing advanced analytics and data visualization techniques to extract actionable insights and support informed decision-making.
Oracle Consultant
Mastercard
- Provided comprehensive oversight of regulatory compliance with Sarbanes-Oxley requirements and ensured adherence to payment card industry standards, demonstrating a strong commitment to maintaining data integrity and security.
- Implemented Oracle Advanced Security transparent data encryption, enhancing the confidentiality and protection of sensitive data assets within the organization.
- Spearheaded the implementation of an audit trail using Oracle Audit Vault, enabling robust monitoring and tracking of database activities, ensuring compliance, and mitigating potential risks.
- Managed and mentored a junior resource, fostering their professional development and equipping them with the necessary skills to independently handle maintenance tasks, contributing to increased team productivity and self-sufficiency.
Oracle Consultant
U10
- Installed Oracle Discoverer, a powerful business intelligence tool, and played a key role in creating the EUL within the data mart, enabling efficient data access and analysis.
- Set up users, defined their roles and responsibilities, and implemented robust security measures to ensure appropriate access to data and maintain data integrity.
- Constructed the logic model of the EUL, defining the relationships and hierarchies that governed data navigation and reporting within the Oracle Discoverer environment.
- Facilitated a comprehensive training workshop for administrators and end-users, equipping them with the necessary skills and knowledge to effectively utilize Oracle Discoverer for data analysis, reporting, and decision-making.
Business Analyst
RATP
- Demonstrated strong problem-solving skills by effectively gathering, investigating, and resolving functional anomalies related to the AR, AP, purchase order, eTax, and GL modules within Oracle EBS R12.
- Managed and resolved service requests with Oracle proactively, ensuring timely resolution of technical issues and maintaining smooth system operation.
- Provided valuable functional user assistance and support in resolving anomalies within EBS R12 financial modules, assisting users in effectively navigating and utilizing the system to optimize financial processes and improve operational efficiency.
Oracle Consultant
CMA-CGM
- Led the successful international implementation of the Oracle financial solution for shipment booking agencies in France, South Korea, Hong Kong, and Japan, ensuring seamless adoption and alignment with local business requirements.
- Oversaw the critical task of migrating customer and supplier reference data from the legacy system to open transactions and trial balances within the Oracle financial solution, ensuring accurate and complete data transfer.
- Managed comprehensive business process training programs, equipping key stakeholders and end-users with the necessary knowledge and skills to effectively utilize the Oracle financial solution.
- Provided ongoing support to both key users and end-users, addressing inquiries and resolving issues to ensure smooth system operation and user satisfaction.
Oracle Consultant
Parcours
- Redesigned the operational information system for B2B vehicle financing, facilitating seamless integration between the operating system and accounting modules in Oracle applications.
- Developed a budgetary forecast based on a comprehensive 5-year business plan, establishing various scenarios and creating interactive analytical reports using Oracle Discoverer.
- Managed diverse financial processes, including bank loans, vehicle financing, vehicle depreciation, constructor repayments, client and supplier invoicing, and direct debit transmissions.
- Oversaw pricing, contracts, and the integration of the vehicle catalog, managed used car sales, detected anomalies in petrol card usage, and generated analytical accounting reports.
- Led the design and development of a web page for listing second-hand vehicles, automating the process from rental contract termination to actual car returns.
- Created a customer extranet offering analytical tools for lease and management contracts, assisting clients in effectively managing contracts approaching completion through customized alerts.
- Migrated specific applications from Google Forms and Reports 6i to 10g, adapting them for web mode and improving overall functionality and user experience.
- Implemented interactive analytical reports, modeled analytical segments, integrated them with accounting key segments in Oracle applications, configured business areas, and developed worksheets in Oracle Discoverer.
Database Developer
Alpha Technologies
- Built Oracle database applications, leveraging technologies such as Forms, Reports, Discoverer, and PL/SQL, in alignment with business requirements and specifications, ensuring efficient and effective solutions.
- Created and implemented analytical reports on Oracle databases and ERP systems, offering valuable insights and actionable information to key business stakeholders, enabling data-driven decision-making.
- Designed comprehensive data models on Oracle databases, meticulously mapping out the structure and relationships to effectively manage the operations of specific online transaction processing systems.
- Ensured adherence to business specifications and requirements throughout the design process.
- Constructed robust data interfaces bridging Sage 100 and Oracle EBS, enabling seamless data integration and synchronization between the two systems.
- Developed comprehensive financial reports utilizing Sage 100 as the data source.
Experience
Big Data Discovery Tool
I leveraged the tool's capability to query data lake metadata, employing string filters to refine search results, reducing end queries to specific objects such as tables and columns. I also implemented dynamic query construction with filter values, enabling users to search for tables containing specific strings and optionally return tables with fields matching a second string. Additional filter clauses can be added for result refinement. Finally, I generated insightful reports in the form of frequency tables—showcasing the records found in tables containing specific fields and corresponding values—empowering data analysis and exploration within the data lake.
Markov Model Migrated to AWS Cloud - 12x Faster
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
Upon successful delivery of interactive dashboards on Oracle OBIEE, HR users experienced a decline in query performance over time due to the design flaw in the DWH. To address this issue, I revisited the DWH design and implemented modifications that reduced data volume by 95% while simultaneously improving query performance by 40%. More importantly, this correction was made without impacting the analytics application, which comprised separate layers—physical, logical, and presentational—ensuring seamless operation and maintainability.
Client Testimonials
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.
SALT Client Testimonial
CxO | Strategic Technology Leader | Blockchain | Crypto | Information Security & Cyber Risk | Board Director/AdviserCxO | Strategic Technology Leader | Blockchain | Crypto | Information Security & Cyber Risk | Board Director/Adviser
July 21, 2022, Dirk managed Stéphane directly.
"Stephane is the consummate professional. As the CTO at SALT I contracted him to help build an enhanced Business Intelligence platform and then pretty much turned him loose with some design requirements, but almost no guidance or support. He took it all in stride and he not only created the platform but several analytic dashboard and report MVPs to prove its functionality. Stephane will figure out how to do what you ask for, and also what you need but forgot to ask, and make it all happen – an invaluable asset to any company."
Education
Master's Degree in Data Science
Data ScienceTech Institute - Nice, France
Master's Degree in Business Administration (MBA)
Temple University - Philadelphia, USA
Bachelor's Degree in Business
Victoria University of Technology - Melbourne, Australia
Certifications
AWS Certified Cloud Practitioner
AWS
Neo4j Certified Professional
Neo4j
Graph Data Modeling Fundamentals
Neo4j
Machine Learning on AWS
Amazon Web Services
Data Analytics on AWS
Amazon Web Services
DataRobot Essentials
DataRobot
AWS Certified Solutions Architect Associate
AWS
Big Data Foundations
IBM
Oracle Business Intelligence 11g Certified Implementation Specialist
Oracle
Skills
Libraries/APIs
Pandas, Sage, NumPy, PySpark, Stripe, Stripe API
Tools
Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Microsoft Power BI, Tableau, OBIEE Answers, Amazon QuickSight, Microsoft Excel, BigQuery, Oracle Application Express (APEX), Plotly, Microsoft Access, Oracle BI Publisher, Oracle E-Business Suite (EBS) R12, Stripe Sigma, Google Forms, Tableau Desktop Pro, Google Sheets, Visual Studio, Spreadsheets, Cloudera, DataRobot, Amazon SageMaker, Git, GitHub, Confluence, Jira, Apache Airflow, Looker, EBSr12, Amazon Athena, AWS IAM, Amazon CloudWatch, AWS Glue, TM1
Languages
SQL, SQL DML, T-SQL (Transact-SQL), Stored Procedure, Visual Basic, Python, Snowflake, R, Visual Basic for Applications (VBA), Excel VBA, Cypher, Python 3, PHP
Paradigms
Business Intelligence (BI), Database Development, Dimensional Modeling, OLAP, Database Design, ETL
Platforms
Oracle, Amazon Web Services (AWS), Oracle Database, Arcadia, AWS Lambda, Windows, QlikView, Jupyter Notebook, Amazon EC2, Azure
Storage
Oracle PL/SQL, PostgreSQL, Databases, Relational Databases, PL/SQL, Graph Databases, SQL Performance, Data Lakes, Database Architecture, RDBMS, Database Structure, Database Transactions, OLTP, Database Performance, SQL Stored Procedures, SQL Server 2016, Microsoft SQL Server, Neo4j, Database Modeling, SQL Server 2008, Oracle DBA, Redshift, Database Administration (DBA), SQL Server DBA, Data Pipelines, MySQL, Data Integration, Data Validation, Database Security, SQL Server 2012, Amazon S3 (AWS S3), MongoDB
Frameworks
Hadoop, Spark
Industry Expertise
Accounting, Banking & Finance, Revenue Operations (RevOps), Healthcare
Other
Oracle Discoverer, Data Visualization, Reports, BI Reporting, Reporting, Data Warehouse Design, Data Modeling, Data Warehousing, Data Analysis, Dashboards, Dashboard Design, Dashboard Development, Data, Data Engineering, Data Profiling, Data Analytics, Financial Data, Data Queries, Data Wrangling, Data Migration, Data-driven Dashboards, Creative Problem Solving, Business Analysis, AWS Certified Solution Architect, Data Management, Communication, Architecture, Performance Tuning, Data Aggregation, Data Manipulation, Technical Writing, Enterprise Resource Planning (ERP), Database Optimization, Transactions, Software Development, Interactive Dashboards, Analytics, Documentation, Data Reporting, English, Query Optimization, International Projects, Finance, Oracle Apps, Key Performance Indicators (KPIs), Complex Data Analysis, Big Data, Data Architecture, CSV File Processing, Cloud, Solution Architecture, Consulting, Excel 365, Data Science, Oracle Forms & Reports, Amazon RDS, ETL Tools, NetSuite, GDPR, Cloud Security, Applications, Tableau Server, Data Structures, Data Governance, Cloud Architecture, Control & Cost Analysis, Data Scientist, Financial Risk Management, Trading, Investment Funds, Risk Management, Software as a Service (SaaS), PCI DSS, Transparent Data Encryption (TDE), Machine Learning Automation, Oracle Application R12 EBS, Oracle HRMS, Machine Learning, Amazon Machine Learning, Oracle EBS, Fivetran, Lambda Functions, Tax Audits, Scientific Data Analysis, Predictive Modeling, Exploratory Data Analysis, APIs, Informatica, PLC, FactoryTalk
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring