AN INDEPENDENT DATA CONSULTANCY
For the data a business cannot afford to get wrong.
Migrations, integrations, SQL Server engineering, and reporting, with the reconciliation to prove the figures. Delivered personally, in English and French, across Canada.
GET IN TOUCHSERVICES
Six lines of work, one standard: the figures on the screen are the figures in the record.
Systems built up over years do not move by drag and drop. I move established ETL workloads onto cloud data pipelines, most often on Azure: Data Factory, Functions, and storage, with the operational monitoring to run them. A recent migration carried millions of rows through bronze, silver, and gold layers. Nothing lost, nothing invented, everything accounted for.
The database is where the truth lives, and it rewards being taken seriously. Schema design and architecture, stored procedure development, query and index performance, and steady administration of the servers themselves.
Two systems, one version of events. REST and other APIs, EDI, and real-time and batch exchanges between systems of record, including the joins between finance and operational platforms where figures most often drift apart.
When two systems disagree, one of them is wrong, and it matters which. I prove that what went in came out, find the sign and mapping errors, and explain the month-end and reporting mismatches until they close.
A business should be able to read its own affairs. Queries, extracts, reports, and the pipelines that feed them: figures stated plainly, holding up to scrutiny.
Built directly on the system of record, so what the screen shows is what the data says. .NET and Blazor web applications, including long-running portals kept under ongoing support.
Sectors served: manufacturing, insurance, managed services, agriculture, telecommunications, and the public sector.
ENGAGEMENTS
A project: a defined piece of work, scoped in writing, delivered personally from the first conversation to the final handover.
Or a retainer: a standing arrangement that gives you priority access to a specialist, for the work that does not arrive as a project: questions, incidents, small changes, and the monitoring that keeps pipelines reliable.
I take a few engagements at a time. Nothing is farmed out; when a project is a collaboration, you know from the start.
ABOUT
RPRA is a consultancy of one. I am David C. Gauthier, Principal Consultant, and every engagement is delivered by me, personally.
I have worked in data and software since 1988, and consulted independently since 2015. The corporation is younger; the practice is not. I hold a Government of Canada Secret security clearance. I am based in Longueuil, Quebec, and work across Canada, in English and in French.
Behind the consultancy is a long career spent where the data actually lives: in the ledgers, pipelines, and systems of record that businesses depend on without ceremony. It is quiet work, and I like doing it properly.
Write a line about what needs to be right. A few sentences on the systems involved and what they are doing wrong is plenty; English or French, as you prefer. You'll hear back within one business day, from me, not an intake form.
GET IN TOUCH contact@rpraconsulting.com