Shubham Gupta

Oracle APEX & PL/SQL Developer – Emaar India Project

• Designed and implemented database-driven solutions using Oracle APEX and PL/SQL, automating workflows including invoice processing, document generation, and approval mechanisms.
• Developed complex PL/SQL procedures, packages, and triggers to enforce business logic, enhance data validation, and ensure optimal system performance.
• Built over 20 responsive APEX pages, utilizing dynamic actions, interactive grids, LOVs, and AJAX to deliver intuitive user experiences and reduce manual intervention.
• Integrated role-based access controls and session state management, ensuring secure and scalable multi-user application environments.
• Conducted performance tuning, resolving UAT issues swiftly, resulting in improved application responsiveness and enhanced end-user satisfaction.
• Prepared detailed technical documentation and facilitated user training sessions to ensure seamless knowledge transition.

ETL Developer – IVCE Project

• Engineered comprehensive ETL pipelines leveraging Alteryx and MS SQL for extracting and transforming legacy financial data for streamlined reporting.
• Automated recurring data workflows, leading to a 60% reduction in monthly report generation timelines, significantly reducing manual errors.
• Collaborated closely with analytics teams to develop real-time data dashboards, empowering stakeholders with timely insights and accurate reporting.
• Ensured data quality, compliance, and robustness through rigorous testing, logging, and adherence to best-practice auditing standards.

Oracle APEX & PL/SQL Developer – Emaar India Project

• Developed optimized front-end interfaces and robust backend logic using Oracle APEX and PL/SQL, significantly enhancing the efficiency of financial and operational modules.
• Redesigned critical invoice workflows, achieving a notable 40% reduction in processing times via backend optimization and streamlined frontend designs.
• Created interactive reports, dynamic data-entry forms, and validation routines, directly improving system usability and reliability.
• Integrated with Oracle Fusion REST APIs to facilitate seamless and secure data synchronization, reducing manual workload and enhancing operational accuracy.
• Actively participated in Agile ceremonies including daily scrums, sprint reviews, and QA testing cycles, consistently meeting project milestones and quality benchmarks.
• Collaborated closely with senior developers and mentors, rapidly acquiring best practices in Oracle APEX development, debugging strategies, and deployment techniques.