Senior Data Integration Analyst (Oracle / OFSAA)
March 2021 – March 2026 - Desjardins | Montreal, Qc – Contract
· Participate in requirements gathering sessions to define and document OFSAA-FSDF functional specifications, configurations, and enhancements.
· Meet with product managers to understand business needs, perform gap analysis, and translate technical requirements.
· Provide support for production-related issues;
· Manage and troubleshoot SQL environments and databases. Quickly identify the root causes of errors and optimize code when necessary.
· Analyze existing systems at a high level and recommend improvements as needed;
· Manage engine mapping tables (EBX). Ensure data integrity and certify updates to the various tables.
· Conduct impact analysis for complex customer requests. (i.e., upstream changes to data used by all clients and documenting all affected flows. Implementation of a high standard of documentation for impact analyses.
· Creation of dynamic SQL queries that generate fact table comparison scripts to quickly generate high-level validation reports for device data.
· Development of SQL queries for use with the Graphviz tool, which generates PDF diagrams in seconds illustrating batch processes in flow form with connections between each task, based on dependencies in OFSAA.
· Implementation of a knowledge base for daily production support and for developing enhancements to the various OFSAA components.
· Diagrammatic documentation (Visio) of a large portion of the data flows supported by the team;
· Training of new junior employees joining the team.
· Development of controls to be performed during integrated tests to accelerate data validation and for the comparison of each release vs the baseline to identify potential anomalies or validate code changes.
Technology Environment
· Oracle 19
· PL/SQL
· SQL Developer
· TOAD
· OFSAA
Moody’s Risk Authority (RAY) - System Administrator / SQL Expert
November 2015 – March 2021 – BNP Paribas - Montreal, Qc - Contract 2 years via ExpertTech + permanent 3 years
· Served as Risk Foundation System Administrator and SQL specialist, managing Risk Foundation servers, including Web, Task, and QlikView components, to ensure platform stability, performance, and reliable operational support.
· Managed end to end workflow, development and implementation of Moody's Risk Authority and Qlikview based Risk Discovery systems for Credit and Market Risk RWA calculations.
· Developed SQL and automation scripts to support project implementation, including initial tactical data loads, Oracle statistical analysis automation, and loading utilities for the SysAdmin team.
· Created comparison scripts to identify differences in Risk Foundation objects across environments and developed Oracle DDL scripts to generate BNP Paribas Risk Foundation objects in a controlled, standardized manner.
· Designed and modeled database tables used for Federal Reserve regulatory reporting, ensuring data structures aligned with compliance and reporting requirements.
· Implemented SVN-based standards for object and script version management, improving traceability, consistency, and change control across development and administrative activities.
· Developed custom PL/SQL packages to streamline Risk Foundation administration, enhancing automation, maintainability, and operational efficiency.
· Integration with upstream OFSAA, MRX, LAP systems and downstream Axiom-based Regulatory Reports system for Federal Reserve Bank filing (HCR, CCAR).
· Data Delivery Automation using Autosys through the Moody's upstream and downstream pipeline.
· Credit and Market Risk Analysis Moody's Analytics Implementation for Intermediate Holding Company Program FR Y-9C, FFIEC031, FFIEC102, FR Y-14A, FR Y-14Q Schedules preparation and automation.
Technology Environment
- Oracle 12c
- Oracle PL/SQL
- SQL Developer 4
- Tortoise 1.9
- Moody’s RiskFoundation 4
ETL Administrator and Developer
January 2013 - November 2015 - Yellow Pages Group – Montreal, Qc - permanent
• Administered the DataStage 8.1 development server, ensuring a stable, well-maintained, and highly available environment for development and testing activities.
- Developed automation scripts to back up DataStage projects, improving reliability, reducing manual effort, and strengthening asset protection.
- Created and configured DataStage projects in compliance with Yellow Pages standards, ensuring consistency and alignment with established internal practices.
- Designed and modeled a DataStage metadata schema to support impact analysis reporting and enable end-to-end traceability of data flows from source to target systems.
- Developed PL/SQL packages to support ETL processing, increasing automation, control, and overall efficiency in data integration operations.
Technology Environment
- IBM InfoSphere DataStage 8.1
- AIX 5.1
- Oracle 9i
- TOAD
ETL Expert and Developer
June 2008 - January 2013 - Videotron S.E.N.C. – Montreal, Qc - Contract 2 years + permanent 3 years
• Led the modeling and implementation of the Business Objects SAP PS RapidMart to support business intelligence and project reporting requirements.
- Produced comprehensive technical documentation for the SAP PS RapidMart to facilitate maintenance, knowledge transfer, and ongoing support.
- Designed ETL workflows in SAP Data Integrator to ensure efficient, accurate, and scalable data integration processes.
- Coordinated the migration of all ETL projects to the production environment in Data Integrator, ensuring stable and reliable deployment.
- Managed and optimized ETL processes to improve processing performance, data quality, and operational efficiency.
- Created and maintained ETL metadata in Data Integrator to support consistency, traceability, and governance across data integration activities.
- Developed and administered the Business Objects universe, including data modeling, contexts, and object creation, to enable robust reporting capabilities.
- Designed and delivered multiple Business Objects reports in both client-server and Web Intelligence (WebI) environments to meet business reporting needs.
Technology Environment
- Data Integrator 11.7
- DB2 8.2
- TOAD
- Business Objects XI R2
o Universe Designer o Metadata Integrator o WebI
ETL Expert and Developer
May 2008 - June 2008 – CMAH – Ottawa, Ontario - permanent
• Designed and implemented an ETL framework, including metadata management for ETL processes, to support structured, maintainable, and scalable data integration activities.
- Established ETL standards and guidelines to ensure consistency, quality, and alignment with organizational best practices.
- Developed ETL solutions using Data Integrator, translating business and technical requirements into efficient data integration workflows.
- Migrated all ETL projects into the production environment using Data Integrator, ensuring smooth deployment and operational stability.
- Managed and optimized ETL processes to improve performance, reliability, and overall execution efficiency.
- Trained consultants on new ETL projects to support knowledge transfer, accelerate onboarding, and maintain delivery quality.
- Created and maintained Data Integrator metadata to strengthen governance, traceability, and long-term maintainability of ETL assets.
Technology Environment
- Data Integrator 6.5
- SQL Server
- TOAD
Data Warehouse Administrator & ETL Expert and Developer
January 2005 - January 2008 – Imperial Tobacco Ltd – Montreal, Qc - permanent
Data Warehouse Administration
- Administered a multi-layer data warehouse environment composed of staging, DW, and Data Mart components to support enterprise data integration and reporting.
- Developed Oracle database objects with Oracle Designer and maintained a standardized, well-structured warehouse design.
- Improved Data Mart performance through index tuning, materialized views, and aggregated tables, enhancing query speed and reporting efficiency.
- Monitored data quality using control reports and ETL logs to ensure reliable processing and accurate results.
- Refreshed production data into the quality environment using export/import methods to support testing, validation, and controlled deployment activities.
ETL Specialist
- Architected and implemented an ETL framework with detailed process metadata to standardize and support enterprise data integration workflows.
- Defined ETL standards and guidelines to improve consistency, governance, and delivery quality across initiatives.
- Developed ETL workflows in Data Integrator and PL/SQL for SAP, Siebel V3, files, and Oracle data sources.
- Led the migration of ETL projects to production, ensuring stable deployment of Data Integrator objects, tables, and PL/SQL processes.
- Optimized ETL operations and metadata management while training consultants on new project implementations.
Technology Environment
· Oracle PL/SQL 9i
· Dynamic SQL
· Oracle Designer 6i
· TOAD
· Data Integrator 6.5
Data Warehouse Administrator & ETL Developer
March 2001 - January 2005 – Imperial Tobacco Ltd – Montreal, Qc - permanent
• Led the upgrade of Cognos from version 6 to version 7, ensuring a smooth transition with minimal disruption to reporting operations.
- Provided 24/7 operational support for the data warehouse and ETL environment, maintaining high availability and rapid issue resolution across critical processing cycles.
- Automated control reports to improve monitoring, strengthen data validation, and reduce manual effort in recurring operational activities.
- Defined roles and responsibilities for the Data Warehouse team, helping establish clearer governance, accountability, and operational efficiency.
- Installed and configured Cognos server software to support enterprise reporting services and platform stability.
- Implemented version control practices for Acta Works to improve traceability, consistency, and change management across ETL assets.
- Designed ETL processes integrating multiple source systems, including files, SAP 4.6b, Oracle, and Siebel, to support reliable data acquisition and transformation.
- Managed Oracle performance tuning and optimization activities to improve database responsiveness and support scalable processing.
- Created all Oracle database objects using Designer, ensuring a standardized, well-structured, and maintainable database design.
- Supervised two projects assigned to a co-op student, providing guidance, oversight, and support for successful delivery.
- Led upgrades for Acta Works, Oracle, and Designer to maintain platform currency, compatibility, and long-term stability.
Technological Environment
- Visual Source Safe
- Acta Works (Data Integrator)
- Oracle PL/SQL
· Dynamic SQL
· Oracle Designer 6i
· TOAD
· Cognos PowerPlay
· Cognos Impromptu
· Cognos Upfront
· Cognos Web Server
- Winbatch Scripts
- Unix shell scripts & crontab
- Windows 2000 Server
- SAP 4.6b
PL/SQL Programmer & ETL Developer
May 1999 - March 2001 – Imperial Tobacco Limited – Montreal, Qc – contract via ERS Informatique
• Designed and implemented PL/SQL ETL solutions to manage results, statistical data, and historical information in support of enterprise reporting and analytics.
- Led the automation and ongoing maintenance of Impromptu reports and Cognos PowerPlay cubes, improving reporting efficiency, consistency, and operational reliability.
Technological Environment
· Data Integrator
· Cognos Impromptu
· Cognos Web Report Administrator
· Cognos PowerPlay Web Administrator
Oracle Trainer
May 1999 - ERS. Informatique Inc. - Boucherville, Qc - permanent
• Managed onboarding and training for new ERS employees, delivering clear process guidance, technical support, and knowledge transfer to groups of 6 to 8 staff members to accelerate ramp-up and ensure consistent team readiness.
Technological Environment
• Oracle Forms 4.5 & Reports 2.5
- Oracle PL/SQL
- Oracle Web (HTTPS)
PL/SQL & Oracle Forms Developer
April 1999 – E.R.S. Informatique Inc. - Boucherville, Qc - permanent
• Designed and implemented an automated conversion system for ACE*Comm, improving processing efficiency, reducing manual intervention, and supporting more reliable workflow execution.
Technological Environment
- Oracle Forms 4.5
- Oracle PL/SQL & Dynamic SQL
Web oriented Oracle PL/SQL Developer
September 1998 - April 1999 - permanent for ERS Informatique – client - Department of National Defence -
• Administered and maintained the CCGR Operations Management Control system, providing stable production support and ensuring alignment with operational needs.
- Coordinated and delivered change requests from the Auditors General of National Defence, translating audit-driven requirements into effective system enhancements.
- Oversaw internet security management for the CCGR website, supporting secure operation and protecting the integrity of the web environment.
Technological Environment
- Oracle PL/SQL
- Oracle Designer
