Freelancer profile translated to English.

Description

Seasoned IT professional with over 26 years of experience in enterprise CRM system architecture, ETL, business intelligence, and full-stack development. Recognized Oracle Siebel CRM specialist (versions 5 to IP2026), having led complex projects for government organizations and Canadian multinationals.

What sets me apart: my ability to bridge the gap between legacy systems and new technologies. Where others see a constraint, I see an opportunity — modernizing without rebuilding everything, integrating AI and automation into existing environments, and delivering tangible value without starting from scratch.

Today, I support organizations in their digital transformation by combining my systems architect rigor with a mastery of emerging technologies: AI agents (Claude API, OpenAI API), automation pipelines (Make, n8n), and AI web tool development (Lovable, Claude Code). A rare senior hybrid profile — focused on measurable results, on-time delivery, and knowledge transfer.

Industry field of expertise

Languages

French
Native or bilingual
English
Conversational

Workplace preferences

Can work on-site

Québec (up to 50km)

Gagné Informatique 2000 Inc.
AI & Automation Projects — Independent Development
CONSULTING AND AUDITS
December 2025 - Today (6 months)
Boischatel, Canada
Period of intensive training (+100 hours) and applied development (+300 hours) in artificial intelligence and automation. Objective: to master emerging tools and integrate them concretely into real projects — capitalizing on 26 years of systems architecture expertise to go where a beginner could not. Several real deliverables and advanced prototypes produced during this period.

• voyagefamille.ca — complete overhaul of the family travel blog with integration of AI tools: budget calculator, itinerary generator, interactive Leaflet.js map, and synchronized PHP calendar — PHP/AJAX/OpenAI architecture with file prompts and DB logging
• Social media agent — Make pipeline + Claude API automatically generating and scheduling Facebook, Instagram, and Pinterest posts from blog articles, with manual validation via Google Sheets
• Lead capture and qualification pipeline (Web form → Make → Claude API → Resend) — with automated prospect tracking and personalized transactional email sending
• Complete automation of meeting minutes — Calendly + Zoom + Noota (transcription) + Gamma (formatting) — zero manual intervention between the meeting and the final distributed document

Prototypes & Applied Learning
• Voice AI agent (Rounded AI) — prototype telephone agent capable of understanding natural language, answering questions, and transferring to a human
• Multi-step AI agent in n8n — autonomous workflow with memory, API calls, and conditional logic; exploration of self-hosting and multi-agent architecture
• Claude → Notion intelligent form — natural input prototype transformed into structured entry in a Notion database via API
• ReponsePro — MVP for generating responses to Google reviews via Claude API, targeting Quebec SMEs; Lovable/React/Vite deployment on cPanel
• Mastery of Claude Code (Cowork) — development
AI Automation Systems Integration Conversational AI Agent AI Agent
Régie du Bâtiment du Québec (RBQ)
Mandate 7 • Siebel CRM Architect / Analyst / Configurator
PUBLIC SECTOR
January 2016 - May 2026 (10 years and 4 months)
Québec, Canada
Maintenance and continuous evolution of a government Customer Relationship Management (CRM) solution based on Oracle Siebel CRM, including Electronic Service Delivery (ESD) applications, interfaces with legacy systems, and data exchanges with the Régie's partners. This mandate covers several version upgrade cycles (IP2016 to IP2026) and numerous functional evolution initiatives.

• Organic and Functional Architecture — active participation in defining solutions with the client, impact analysis of changes, effort estimation, and writing estimation documents
• Siebel CRM Configuration — development of new views, applets, business components, workflows, eScript scripts, and EAI integrations
• Version Upgrade Management — IP2016, IP2020, IP2021, and IP2026 migration; installation and configuration of Siebel application servers
• External API Integration — Google Maps (worksite geolocation), clicSÉQUR express (government authentication), partner services via Siebel EAI
• Development of Java data conversion and migration tools
• Performance Optimization — SQL tuning, SQL Server index review, application internal link optimization
• Siebel Mobile Experimentation — prototype on iOS and Android tablets for field inspectors
• Level 3 Technical Support — resolution of functional and technological anomalies in production
• Mentoring internal developers and analysts — code review, Siebel best practices
• Evaluation and implementation of a flexible and customizable communication solution for users (Oracle BI Publisher)

Environment: Siebel 8.2 IP2026, Siebel Open UI, Public Sector, Mobile, Remote, eScript, Tools, EAI, EIM, .NET, HTML/CSS/JS, VBScript, SQL Server, Oracle, Oracle BI Publisher, Java, P+ Methodology
Siebel CRM API Integration Oracle BI Publisher SQL Server
La Capitale Assurance
BI Programmer Analyst
BANKING AND INSURANCE
September 2015 - December 2015 (3 months)
Québec, Canada
As part of the individual insurance systems modernization program (Quartz project), design and delivery of a business intelligence platform for reporting, operational monitoring, and performance analysis needs.

• BI Architecture Design — dimensional modeling, datamart definition, data source mapping
• Dynamic and Complex ETL Development — extraction of data from the Oracle source system to the data warehouse and datamarts, management of transformations and business rules
• SQL Query and PL/SQL Procedure Optimization — reduction of processing times
• Development of monitoring and management reports under Cognos
• Performance testing, compliance testing, and data validation

Environment: Oracle 12c, PL/SQL, Cognos, SQL Developer
PL/SQL Cognos