Vikas Pandey | Oracle APEX Architect & Senior Consultant (Oracle ACE Associate)

Vikas Pandey

Senior Consultant – Ernst & Young (EY)

Oracle APEX Architect | Oracle ACE Associate | 9+ Years Experience

Professional Summary

I am an Oracle APEX Architect and Senior Consultant with 9+ years of hands-on experience in designing, developing, and modernizing enterprise applications using Oracle APEX, Oracle Database, SQL/PLSQL, and ORDS. My professional journey spans pharmaceutical consulting, insurance, healthcare, and enterprise product development, where I have delivered scalable, secure, and performance-optimized solutions for Indian and global clients.

Currently, I work as a Senior Consultant at Ernst & Young (EY), focusing on application architecture, data migration, performance tuning, advanced reporting, and system integrations. As an Oracle ACE Associate, I strongly believe in architectural clarity, best practices, and mentoring teams to build long-term sustainable Oracle solutions.

What I Do

• Custom enterprise application development using Oracle APEX
• Legacy modernization including Oracle Forms to APEX migration
• Advanced reporting using AOP, PL/PDF, Jasper Reports, and BI Publisher
• API development and integrations using Oracle ORDS and REST services
• Data migration, validation, and SQL/PLSQL performance optimization
• Training and mentorship to build industry-ready Oracle professionals
• Product innovation and solution architecture for long-term client success

Professional Experience

Senior Consultant — Ernst & Young LLP, India
December 2023 – Present | Noida (Hybrid)
At EY, I work on Oracle-based consulting engagements, developing and maintaining enterprise applications with a strong focus on SQL/PLSQL development, data analysis, and performance optimization. My responsibilities include data migration and validation, query tuning, client collaboration, and supporting project delivery to ensure quality and timely execution.

Senior Consultant — Ultragenic Global Pvt. Ltd.
December 2020 – December 2023
Worked extensively on pharmacovigilance and drug safety systems for pharmaceutical clients. Responsibilities included Oracle ARGUS customization, PL/SQL development, data migration, validation, E2B import/export enhancements, and performance tuning. Collaborated with cross-functional teams to ensure smooth deployment and post-go-live stability.

Oracle APEX Consultant — Mawai Infotech Limited
October 2018 – December 2021
Designed and developed web applications using Oracle APEX with a focus on usability, performance, and maintainability. Integrated APEX with HTML, CSS, jQuery, AJAX, and responsive layouts. Also handled manual testing, enhancements, and issue resolution.

Oracle APEX Developer — Consult IT Technologies Pvt. Ltd.
August 2016 – October 2018
Designed and developed Oracle APEX applications with robust database design and optimized SQL queries. Provided production support, handled enhancements, conducted user training, and managed data migration while ensuring data integrity.

Key Project Experience

• MYMEDIAPP – Telemedicine platform with EHR, payments, video consultations, and third-party integrations
• Jubilee Insurance & Pensions Portal (Kenya) – Pension administration, reconciliation, MIS reporting
• Raksha Medical – End-to-end healthcare platform covering hospital, pharmacy, pathology, and patient workflows
• Velocity – Inventory and asset management system with SCM, finance, and reporting modules
• Drug Safety Translation & Local Assessment Solutions – Custom Oracle/ARGUS solutions for Novartis
• LifeSphere® MultiVigilance (LSMV) – Oracle to PostgreSQL migration with backend logic support

Technical Expertise

• Oracle Database: SQL, PL/SQL, performance tuning, data migration
• Oracle APEX: APEX 5.x to 21.x, web services, JSON, file handling
• Reporting: Jasper Reports, AOP, BI Publisher
• Web: HTML, CSS, jQuery, AJAX
• Tools: SQL Developer, Toad, Export/Import utilities

Certifications & Professional Learning

• Microsoft – Artificial Intelligence on Azure
• IBM – Introduction to Artificial Intelligence
• DeepLearning.AI – AI for Everyone
• Lund University – AI, Business & the Future of Work
• University of Colorado – Agile Leadership
• Udemy – Cloud Computing, Cybersecurity Awareness, AI Risk

Contact & Collaboration

🌐 Website: vikasapexian.com
💼 LinkedIn: LinkedIn Profile
📩 Consulting / Mentorship: vikaspandey641@gmail.com

© 2026 Vikas Pandey | Oracle APEX Architect • Oracle ACE Associate