Pratibha Rana

About Pratibha Rana

Results-driven Oracle APEX Developer with 10+ years of experience designing and delivering scalable, high-performance enterprise applications. I specialize in building robust database-driven systems using Oracle Application Express (APEX), PL/SQL, and advanced SQL, with a strong focus on performance optimization, clean architecture, and business impact. Over the years, I’ve had the opportunity to work on mission-critical projects for global organizations such as the International Labour Organization (ILO) and Deutsche Bank, where I contributed to building reliable, secure, and scalable solutions. What I bring to the table:Expertise in Oracle APEX (v5.x–v23.x) for modern web application development Strong command over PL/SQL, SQL tuning, and database design Hands-on experience with RESTful APIs, JSON integrations, and AOP reporting Proven ability to optimize performance (achieved up to 70% faster query execution) Experience working across Oracle, PostgreSQL, and IBM DB2 databases Key achievements:Delivered 10+ database design projects with optimized query performance Reduced data loading time by 42% through SQL tuning and data modeling Improved system efficiency via PL/SQL scheduler jobs and backend optimization Built enterprise reporting solutions using AOP (PDF, Excel, Word, HTML) Mentored developers and led cross-functional teams to successful project delivery How I work:I thrive in Agile environments, collaborating closely with stakeholders, understanding business requirements, and translating them into scalable technical solutions. I’m known for strong problem-solving skills, clean coding practices, and mentoring team members. Tools & Technologies:Oracle APEX | PL/SQL | SQL | JavaScript | CSS | REST APIs | PostgreSQL | DB2 | Git | Jira | AOP | Data Modeling Currently:Working as an Oracle APEX & SQL Developer at Tech Mahindra, contributing to enterprise applications for global clients. Let’s connect:I’m open to opportunities, collaborations, and discussions around Oracle APEX, database optimization, and enterprise application development.

Experience

1. Oracle Apex & Sql Developer

   Tech Mahindra

   Jan 2022 — Present · Gurugram, IN

   Working on projects for the International Labour Organization (ILO, Geneva), developing and maintaining Oracle-based enterprise applications.• Designed and implemented Oracle SQL queries, database architecture, and backend logic for enterprise systems.• Completed 7+ SQL database design projects, optimizing queries and developing PL/SQL stored procedures, triggers, materialized views, and functions.• Built and integrated REST APIs for Oracle APEX applications, improving system interoperability.• Implemented dynamic reporting solutions using Oracle APEX Office Print (AOP) enabling export to PDF, Excel, Word, and HTML formats.• Developed custom Microsoft Word AOP templates for internal and client reporting.• Improved system performance through query optimization and PL/SQL Scheduler jobs (10+).• Authored technical and training documentation supporting adoption of Quality Management Systems.• Mentored 4 team members and coordinated delivery between offshore and onsite teams.

Education

• Kurukshetra University

  Bachelor of Technology - BTech, Computer Science

  2011 — 2015