Consultant — SQL & Data Engineering

My name is Dominique Beneteau, I'm a SQL and Data Engineering consultant with over fifteen years’ experience helping organisations design, develop, optimise and integrate their data systems. I specialise in T‑SQL development, complex stored procedures, performance tuning and ETL delivery.

• Expert-level T‑SQL, stored procedures and performance tuning.
• ETL design and development, processes orchestration, operational support tools.
• Data migration & system integration in regulated environments.
• Data validation, profiling, reconciliation and production cutover processes.
• Data (re-)modeling (Kimball, Inmon) and processes refactoring.
• Custom solutions with a pragmatic approach.

Beyond the technical work, I help teams reach their full potential: Guiding developers on best practices, improving delivery processes, and getting projects up to speed quickly.

A few achievements and tasks performed

• Development of a processes orchestrator. 100% SQL Server solution, no broker, no third party tools. Dependencies, scalable parallelism, monitoring, error handling, operational notifications. (github)
• Development of a files listener in replacement of a decommissioned open source tool. 100% SQL Server solution, no third party tools.
• Development of a asynchronous executor for low criticality requests. 100% SQLServer solution. (github)
• Development of a Data Quality engine. 100% SQL Server solution. (github)
• Multiple ETLs developed from scratch.
• Multiple DW models developed from scratch.
• Stored procedures validation/optimisation campaigns organised over thousands of stored procedures (through automation, syntaxic analysis and dynamic alters).
• Development of multiple metadata based engines.
• Data model refactoring with parallel runs and incremental implementation so data integrity and completeness can be checked real time.
• Automated reconciliation framework for financial datasets.
• Mentored teams and established best-practice SQL coding standards.