Gurdeep Singh Sandhu

Senior Software Developer @Cargojet

Mississauga, ON, CA

Enterprise System Integration (Oracle APEX to SAP S/4HANA): Engineered secure REST API integrations using OAuth 2.0 to facilitate seamless, real-time data exchange between a legacy Oracle APEX Procure-to-Pay (P2P) system and a new SAP S/4HANA platform, ensuring business continuity during a critical system migration.*Automated Cross-System Data Synchronization: Developed a reusable Data Load Wizard in Oracle APEX to automate the synchronization of employee training records between disparate systems.This framework successfully eliminated manual updates for both HR and Cybersecurity training, ensuring real-time compliance tracking and significantly reducing administrative overhead.* Self-Service Scheduled Data Delivery Engine:Architected and implemented a self-service, scheduled data delivery system. This module leverages Oracle DBMS_SCHEDULER for asynchronous job execution and APEX_MAIL APIs,enabling users to subscribe to reports,define custom schedules, and receive automated data exports directly, streamlining information flow to stakeholders.*Data Migration Enablement Application: Designed and launched a Data Migration support application providing a live, interactive view of legacy system data via APEX Interactive Reports.This tool replaced static Excel-based reporting, drastically reducing manual data validation efforts and enhancing data accessibility for the SAP implementation team.*Dynamic & Agile Business Reporting: Authored dynamic PL/SQL packages to power flexible, user-driven APEX Interactive Reports. This solution automatically adapts to evolving business logic, eliminating the need for constant query rewrites and significantly improving reporting agility for business users.* Strategic Architectural Planning & Collaboration: Actively engaged in Release 0 planning and architecture design, collaborating with cross-functional teams to define the technical roadmap and ensure the successful integration of new systems with enterprise-level objectives.

Indira Gandhi National Open University

Postgraduate Degree

Punjabi University

Bachelor of Technology - BTech