Senior Oracle Technical Analyst at Government of Nunavut, Canada (2025-11 – Present)
Implementation and Supporting for Oracle ERP Financials, Projects & HCM Cloud technical design, development, integrations, Reporting.
- Facilitated Oracle Fusion Financial Reporting workshops and business requirement gathering sessions across multiple government departments.
- Led migration and redesign of legacy Oracle EBS reports into Oracle Fusion reporting solutions using OTBI, Smart View, BI Publisher, and Financial Reporting Center.
- Delivered financial reporting solutions supporting General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Cash Management, Procurement, and Projects.
- Developed management dashboards, financial reconciliation reports, budget reports, and operational reporting solutions.
- Worked closely with Finance stakeholders to identify reporting gaps and recommend Oracle Cloud standard reporting alternatives.
- Served as trusted advisor to business users by challenging unnecessary custom reporting requests and promoting Oracle Fusion Cloud best practices.
- Provided leadership during testing, user acceptance testing (UAT), report validation, and production deployment activities.
- Developed several integrations with web services such as REST and SOAP using Oracle OIC
- Supported Oracle ERP Financials, Procurement, PPM, HRMS & Payroll production issues.
- Designed and developed several OIC integrations using REST/SOAP, JSON Web services using HDL FBDI, ADFDi, HCM Extracts and APIs. Including Bank reconciliations, Security reports, several GL/Sub ledger reconciliation reports.
- Built several Oracle reports using OTBI and BI Publisher reports for HR/Payroll, Financials, Projects
- Supported EBS ↔ Fusion coexistence and cloud transformation.
- Performed SIT, UAT, payroll validation and release activities.
- Excellent technical experience in Oracle Cloud HCM Fast Formulas on OTL, Core HR, Payroll, Absence Management, Oracle Advanced Benefit, HR Self service, Reporting, interfaces
- Worked on Oracle Cloud Conversions using FBDI/FBDL, ADFDi
- Integration Experience with RESTFUL and JSON services.
- Built several reports using HCM extracts, BI Publisher, OTBI for Oracle ERP Financials, Procurement, Projects & HCM Cloud
- Designed and Developed data file transformation into HDL upload/HDL Loader, FBDI formats.
Senior Oracle Techno-functional Consultant at Government of NewBrunswick, Canada (2022-06 – 2025-10)
- Facilitated Oracle Fusion Financial Reporting workshops and business requirement gathering sessions across multiple government departments.
- Led migration and redesign of legacy Oracle EBS reports into Oracle Fusion reporting solutions using OTBI, Smart View, BI Publisher, and Financial Reporting Center.
- Delivered financial reporting solutions supporting General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Cash Management, Procurement, and Projects.
- Developed management dashboards, financial reconciliation reports, budget reports, and operational reporting solutions.
- Worked closely with Finance stakeholders to identify reporting gaps and recommend Oracle Cloud standard reporting alternatives.
- Served as trusted advisor to business users by challenging unnecessary custom reporting requests and promoting Oracle Fusion Cloud best practices.
- Provided leadership during testing, user acceptance testing (UAT), report validation, and production deployment activities.
- Built several OTBI and BI Publisher reports for HCM (Core HR, Payroll, Benefits, OTL etc), ERP Financials and Procurement Reports.
- Designed and development GNB Security reports, several GL/Sub ledger financial reconciliation report amongst others.
- Performed Oracle Cloud HCM Fast Formulas on OTL, Core HR, Payroll, Absence Management, Oracle Advanced Benefit, HR Self service, Reporting
- Oracle HCM Reporting, Payroll Integrations for Government of New Brunswick
- Oracle HCM Extracts design and development.
- Oracle OTBI/BIP Reports development
- Oracle Fusion HCM Cloud
- Oracle Cloud HCM Fast Formulas
- HCM extracts
- Oracle HCM Extracts design and Oracle OTBI/BIP Reports development
Senior Oracle EBS/Fusion Techno functional Lead Consultant at ATCO / IBM (2020-07 – 2022-06)
Oracle ERP Financials, Projects, SCM & HCM Cloud technical design, development, integrations, Reporting and implementation. Providing techno-functional support for Oracle Fusion Oracle ERP (Financials & Human Resources, HCM, Procurement, Advanced Pricing, Inventory, Order Management & Shipping, OTL, Core HR, Payroll, Absence Management, Oracle Advanced Benefit, HR Self service, Reporting, interfaces, extensions and customizations).
- Participated in Oracle EBS to Oracle Fusion Financials transformation initiatives including reporting assessments and reporting modernization programs.
- Designed and developed OTBI analyses, BI Publisher reports, Financial Reporting Center reports, and Smart View reporting solutions.
- Supported reporting requirements across General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Cash Management, Procurement, and Project Accounting.
- Conducted report inventory assessments and report conversion planning activities for Oracle Cloud migration initiatives.
- Collaborated with business stakeholders and solution architects to optimize reporting architecture and reduce customizations.
- Oracle CEMLI development for AR, FA, AP, GL, Cash Management, SCM, Oracle Warehouse Management, HRM, Oracle Advanced Benefit, Oracle Projects, PO, I-Expense, I-Proc, & Financial Modules.
- Supported EBS ↔ Fusion coexistence and cloud transformation.
- Expertise in design and mapping of EBS Financials/Procurement/SCM/Cloud ERP modules
- Technical business process design, documentation and implementations.
- Worked on multi-year business transformation projects
- Experience using various data interchange formats like JSON and XML
- Experience with web services such as REST and SOAP
- Development experience with web services such as REST and SOAP using Oracle OIC
- Supporting Oracle Data Integration Cloud Services, Oracle Data Integration Platform Cloud, Oracle Integration Cloud
- Oracle Cloud HCM Fast Formulas
- Oracle Cloud reporting - Oracle OTBI Dashboard
- Oracle HCM, Payroll Integrations for Canada
- Oracle OTBI/BIP Reports development
- HCM extracts
- Oracle HCM Extracts design and Oracle OTBI/BIP Reports development
- Data conversion/Integration for Oracle HCM Fusion applications, Oracle REST/SOAP service, ORDS, Oracle Integration Cloud Services (OIC), ESS job scheduling, PGP Encryption and SSH setups.
- Excellent experience in Data loading into Fusion HCM using HCM Data Loader Tool which includes the Workforce structure data, Worker data, Work relationships data, and Salary info.
- Expertise in Configurations, Personalization, Fusion Data Security, File-based loaders (FBL), Spreadsheet loader, Payroll Batch Loader, OTBI Reports, BI Publisher reports, HCM Extracts.
- Oracle Cloud Conversions using FBDI/FBDL, ADFDi
- Experienced in Oracle integrations using Oracle repository and Business event, Oracle Integration Cloud (OIC)
