Stephane is available for hire

Stephane Ruault

Verified Expert in Engineering

Data Engineer and Developer

Location

Bogotá - Bogota, Colombia

Toptal Member Since

November 30, 2020

Stephane possesses an impressive 20 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

Loom

Stripe, Revenue Operations (RevOps), Snowflake, Tableau, Financial Data...

Wagner-Group - Main

SQL, Azure, PLC, Visual Basic for Applications (VBA), PostgreSQL, FactoryTalk...

GTCR, LLC

NetSuite, SQL, Accounting, TM1, English

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

Part-time

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

2021 - PRESENT

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.

Technologies: Stripe, Revenue Operations (RevOps), Snowflake, Tableau, Financial Data, Stripe Sigma, Data Queries, SQL Performance, Data Wrangling, Data-driven Dashboards, Creative Problem Solving, Business Analysis, Data Management, SQL DML, T-SQL (Transact-SQL), Communication, Data Manipulation, NetSuite, Business Intelligence (BI), Data Analytics, Database Transactions, Transactions, OLAP, OLTP, Exploratory Data Analysis, Tableau Desktop Pro, Tableau Server, Data Validation, Interactive Dashboards, Analytics, Documentation, Accounting, Financial Risk Management, Risk Management, Data Reporting, English, Query Optimization

SQL Database Expert

2023 - 2024

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.

Technologies: SQL, Azure, PLC, Visual Basic for Applications (VBA), PostgreSQL, FactoryTalk, English

NetSuite Developer

2023 - 2023

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.

Technologies: NetSuite, SQL, Accounting, TM1, English

Data Analyst

2023 - 2023

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.

Technologies: Data Science, Data Analytics, Scientific Data Analysis, Dashboards, Data Visualization, Exploratory Data Analysis, Excel 365, Data Validation, Documentation, Risk Management, Amazon QuickSight, English

Stripe Data Analyst

2023 - 2023

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.

Technologies: Data Analysis, SQL, Stripe, Microsoft Excel, Stripe API, NetSuite, Tax Audits, Accounting, English

Lead BI Data Architect and Developer

2022 - 2022

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.

Technologies: Amazon Web Services (AWS), Amazon QuickSight, PostgreSQL, Financial Data, Amazon RDS, AWS Lambda, Amazon Athena, Data Queries, SQL Performance, Data Wrangling, Data-driven Dashboards, Creative Problem Solving, Business Analysis, AWS Certified Solution Architect, Data Management, Data Lakes, Redshift, Confluence, SQL DML, T-SQL (Transact-SQL), Communication, Architecture, Data Aggregation, Google Forms, Data Manipulation, Database Architecture, RDBMS, Technical Writing, Business Intelligence (BI), Data Analytics, Lambda Functions, Database Structure, Database Transactions, Transactions, OLAP, Exploratory Data Analysis, Data Integration, Data Structures, Google Sheets, APIs, Excel 365, Software Development, Data Governance, Interactive Dashboards, Analytics, Documentation, Cloud Architecture, Control & Cost Analysis, Data Scientist, Accounting, Financial Risk Management, Trading, Banking & Finance, Investment Funds, Risk Management, Data Reporting, English, Query Optimization

Data Engineer

2021 - 2021

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.

Technologies: Snowflake, Python, GitHub, Confluence, Jira, Apache Airflow, Python 3, Data Analysis, Big Data, Data, Data Architecture, CSV File Processing, Data Engineering, Amazon S3 (AWS S3), Git, Data Analytics, Cloud, Consulting, Pandas, Database Modeling, Data Wrangling, Business Analysis, Data Management, Data Lakes, SQL DML, T-SQL (Transact-SQL), Dimensional Modeling, Communication, ETL Tools, Data Aggregation, Data Manipulation, Data Pipelines, Technical Writing, Exploratory Data Analysis, Data Integration, Data Structures, Data Governance, Data Validation, Documentation, NumPy, Data Scientist, Financial Risk Management, Investment Funds, Risk Management, Data Reporting, English, Query Optimization

Data Integration and PL/SQL Engineer

2021 - 2021

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.

Technologies: Oracle, Relational Databases, PL/SQL, Oracle PL/SQL, Financial Data, Data Queries, SQL Performance, SQL DML, Data Wrangling, Data Migration, Data Management, T-SQL (Transact-SQL), Communication, Performance Tuning, Data Manipulation, RDBMS, Database Optimization, Transactions, Data Integration, Stored Procedure, Accounting, Financial Risk Management, Trading, Banking & Finance, Investment Funds, Risk Management, English, Query Optimization

Data Scientist

2020 - 2021

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.

Technologies: Amazon SageMaker, R, Amazon Web Services (AWS), Amazon S3 (AWS S3), Software as a Service (SaaS), Snowflake, Data Analysis, Complex Data Analysis, Big Data, Data, Data Engineering, Solution Architecture, Data Wrangling, Data Migration, Creative Problem Solving, AWS Certified Solution Architect, Data Management, SQL DML, Communication, Architecture, Performance Tuning, Data Manipulation, Software Development, Analytics, NumPy, Data Scientist, Investment Funds, Risk Management, English

Data Scientist

2019 - 2020

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.

Technologies: DataRobot, SQL, Python 3, Arcadia, Cloudera, International Projects, 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, Data Queries, SQL Performance, Data Wrangling, Data-driven Dashboards, Microsoft Power BI, Business Analysis, Data Management, Data Lakes, SQL DML, T-SQL (Transact-SQL), Communication, Architecture, Data Aggregation, Data Manipulation, Technical Writing, Business Intelligence (BI), Data Analytics, Database Structure, Database Transactions, Transactions, OLAP, OLTP, Data Integration, Data Structures, Data Governance, Interactive Dashboards, Analytics, Documentation, Data Scientist, Accounting, Financial Risk Management, Trading, Banking & Finance, Investment Funds, Risk Management, PySpark, Data Reporting, English, Query Optimization

Senior BI Consultant

2014 - 2016

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.

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, Data Queries, SQL Performance, SQL DML, Data Wrangling, Healthcare, SQL Server 2008, Data-driven Dashboards, Creative Problem Solving, Business Analysis, Data Management, T-SQL (Transact-SQL), Dimensional Modeling, Communication, ETL Tools, Architecture, Performance Tuning, Data Aggregation, Data Manipulation, Database Architecture, RDBMS, SQL Server DBA, Technical Writing, Business Intelligence (BI), Data Analytics, Database Optimization, Database Structure, Database Transactions, Transactions, OLAP, OLTP, Applications, Database Performance, Data Integration, Data Structures, Informatica, Software Development, Data Validation, Interactive Dashboards, Analytics, Documentation, Accounting, Financial Risk Management, Investment Funds, Risk Management, Data Reporting, English, Query Optimization

BI Consultant

2011 - 2013

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.

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, Data Queries, SQL Performance, SQL DML, Data Wrangling, SQL Server 2008, Data-driven Dashboards, Creative Problem Solving, Business Analysis, Data Management, T-SQL (Transact-SQL), Dimensional Modeling, Communication, ETL Tools, Architecture, Performance Tuning, Data Aggregation, Data Manipulation, Database Architecture, RDBMS, Technical Writing, Business Intelligence (BI), Data Analytics, Database Structure, Database Transactions, Transactions, OLAP, OLTP, Applications, Database Performance, Data Integration, Software Development, Interactive Dashboards, Analytics, Documentation, Financial Risk Management, Risk Management, Data Reporting, English, Query Optimization

BI Consultant

2010 - 2011

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.

Technologies: 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, Data Queries, SQL Performance, Data-driven Dashboards, Creative Problem Solving, Business Analysis, SQL DML, T-SQL (Transact-SQL), Communication, Performance Tuning, Data Manipulation, RDBMS, Business Intelligence (BI), Data Analytics, OLAP, Windows, Database Performance, Software Development, Interactive Dashboards, Analytics, Documentation, Financial Risk Management, Risk Management, Data Reporting, English

Oracle Consultant

2009 - 2011

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.

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, Data Queries, SQL Performance, SQL DML, Data Wrangling, Data Migration, Oracle DBA, Data-driven Dashboards, Business Analysis, Data Management, T-SQL (Transact-SQL), Communication, Data Manipulation, Database Administration (DBA), Database Architecture, RDBMS, Technical Writing, Business Intelligence (BI), Data Analytics, Enterprise Resource Planning (ERP), Database Optimization, Database Structure, Database Transactions, Transactions, OLAP, OLTP, Applications, Database Performance, PL/SQL, Stored Procedure, Software Development, Data Validation, Interactive Dashboards, Analytics, Documentation, Accounting, Financial Risk Management, Data Reporting, Query Optimization

Oracle Consultant

2010 - 2010

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.

Technologies: Oracle, PCI DSS, Transparent Data Encryption (TDE), Finance, Data, Data Architecture, Databases, Database Development, Data Engineering, Data Queries, SQL Performance, SQL DML, Oracle DBA, Data Management, T-SQL (Transact-SQL), Communication, Data Manipulation, Database Architecture, RDBMS, Database Structure, Windows, Database Performance, Data Structures, PL/SQL, Stored Procedure, Database Security, Documentation, Financial Risk Management, Banking & Finance, Query Optimization

Oracle Consultant

2009 - 2009

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.

Technologies: Oracle Discoverer, SQL, Oracle, Data Analysis, Dashboards, Data, Data Architecture, Databases, Database Development, Communication, Documentation

Business Analyst

2009 - 2009

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.

Technologies: Oracle Apps, Oracle, Reports, Data, Data Architecture, Databases, Database Development, Oracle EBS, EBSr12, Oracle E-Business Suite (EBS) R12, Business Analysis, Communication, RDBMS, Enterprise Resource Planning (ERP), Transactions, OLTP, Applications, Stored Procedure, Documentation, Accounting, Financial Risk Management

Oracle Consultant

2007 - 2008

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.

Technologies: Oracle Apps, SQL, Oracle, International Projects, Data, Data Architecture, Databases, Database Development, Oracle Application R12 EBS, EBSr12, Oracle E-Business Suite (EBS) R12, Data Migration, Oracle DBA, Business Analysis, Data Management, SQL DML, T-SQL (Transact-SQL), Communication, RDBMS, Enterprise Resource Planning (ERP), Database Transactions, Transactions, OLTP, Applications, Documentation, Accounting, Financial Risk Management

Oracle Consultant

2003 - 2005

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.

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, Data Queries, SQL Performance, SQL DML, Data Wrangling, Data Migration, Oracle DBA, Data-driven Dashboards, Creative Problem Solving, Business Analysis, Data Management, T-SQL (Transact-SQL), Communication, Data Manipulation, Database Administration (DBA), Database Architecture, RDBMS, Enterprise Resource Planning (ERP), PHP, Database Optimization, Database Structure, Database Transactions, Transactions, OLAP, OLTP, Applications, Windows, Database Performance, Data Structures, Sage, PL/SQL, Stored Procedure, Software Development, Documentation, Oracle Application Express (APEX), Accounting, Financial Risk Management, Query Optimization

Database Developer

2000 - 2003

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.

Technologies: Oracle, Oracle EBS, Sage, Microsoft Access, PL/SQL, Stored Procedure, Oracle Application Express (APEX), Software Development, Accounting, Financial Risk Management, Visual Basic for Applications (VBA), Query Optimization

Experience

Big Data Discovery Tool

Enhanced data lake functionality by developing a Python-based query tool that dynamically discovers actual data within the data lake, bypassing the need to query existing tables.

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

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 faced limitations in analyzing HR activity managed through Oracle EBS and SumTotal. While a prior team had already implemented a DWH solution, I identified a design flaw that could impact its long-term viability. Despite this, the client remained committed to the project and its delivery schedule, choosing to proceed with the analytics platform development. Through extensive interviews with HR business partners and managers, I identified around 10 core metrics and defined relevant dimensions for slicing and analyzing these metrics.

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

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.

SALT Client Testimonial

Dirk AndersonDirk Anderson

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."

Skills

Languages

SQL, SQL DML, T-SQL (Transact-SQL), Stored Procedure, Python, Snowflake, R, Visual Basic for Applications (VBA), Python 3, PHP

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, Google Forms, Tableau Desktop Pro, Google Sheets, Cloudera, DataRobot, Amazon SageMaker, Git, GitHub, Confluence, Jira, Apache Airflow, Looker, EBSr12, Amazon Athena, AWS IAM, Amazon CloudWatch, AWS Glue, TM1

Paradigms

Business Intelligence (BI), Database Development, Dimensional Modeling, OLAP, Database Design, ETL, Data Science

Platforms

Oracle, Amazon Web Services (AWS), 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, Microsoft SQL Server, 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), Neo4j, MongoDB

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, Arcadia, Oracle Apps, Key Performance Indicators (KPIs), Complex Data Analysis, Big Data, Data Architecture, CSV File Processing, Cloud, Solution Architecture, Consulting, Excel 365, Oracle Forms & Reports, Amazon RDS, Stripe Sigma, 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, Revenue Operations (RevOps), Oracle EBS, Fivetran, Lambda Functions, Tax Audits, Scientific Data Analysis, Predictive Modeling, Exploratory Data Analysis, APIs, Informatica, PLC, FactoryTalk

Frameworks

Hadoop, Spark

Libraries/APIs

Pandas, Sage, NumPy, PySpark, Stripe, Stripe API

Industry Expertise

Accounting, Banking & Finance, Healthcare

Education

2017 - 2019

Master's Degree in Data Science

Data ScienceTech Institute - Nice, France

1998 - 2000

Master's Degree in Business Administration (MBA)

Temple University - Philadelphia, USA

1993 - 1997

Bachelor's Degree in Business

Victoria University of Technology - Melbourne, Australia

Certifications

MARCH 2023 - MARCH 2026

AWS Certified Cloud Practitioner

AWS

MARCH 2023 - PRESENT

Neo4j Certified Professional

Neo4j

JANUARY 2023 - PRESENT

Graph Data Modeling Fundamentals

Neo4j

JULY 2021 - PRESENT

Machine Learning on AWS

Amazon Web Services

JULY 2021 - PRESENT

Data Analytics on AWS

Amazon Web Services

JULY 2020 - PRESENT

DataRobot Essentials

DataRobot

FEBRUARY 2019 - FEBRUARY 2022

AWS Certified Solutions Architect Associate

AWS

JUNE 2017 - PRESENT

Big Data Foundations

IBM

NOVEMBER 2010 - PRESENT

Oracle Business Intelligence 11g Certified Implementation Specialist

Oracle

Collaboration That Works

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

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring