NAVEEN K

 

Summary

Oracle APEX and PL/SQL Certified Developer with over 4.5 years of experience in analysis, designing and developing interactive web applications using Oracle APEX, with a strong focus on PL/SQL, to create database- driven solutions. Proficiency in Application Development using Oracle SQL, PL/SQL, and Developer Oracle Application Express (APEX).

 

Professional Summary

 

• Proficient in designing and developing interactive web applications using Oracle APEX.
• Experienced in creating complex APEX forms, interactive reports/grids, and charts to present data effectively.
• Responsible for the integration of third-party APEX Plugins and JavaScript libraries to enhance application functionality.
• Experience in developing forms based on views, tables and procedures in tabular and form layouts.
• Created logical and physical database objects - table spaces, tables, indexes, referential integrity constraints, and triggers to development needs.
• Worked on DB Design, Oracle Forms & Reports, and PL/SQL Development.
• Hands on experience in installation and configuration of Oracle APEX, ORDS, Oracle database and Oracle form builder.
• Experience in Monitoring Database, Handling exceptions and Generating AWR reports.
• Familiarity with using CI/CD pipeline with GitLab and Jenkins.
• Have exposure to Banking, Forex Trade Finance, Life sciences.

 

Professional Experience

R&D Development Engineer

Confidential

(APR 2022 - Present)

• • Developed and maintained APEX applications to address business needs and enhance user experiences.
  • Collaborated with stakeholders to gather and refine application requirements.
  • Designed and implemented database objects, including tables, indexes, triggers, procedures, functions, packages, and constraints.
  • Created interactive APEX reports, forms, report queries and charts for data presentation and analysis.
  • Conducted performance tuning to optimize application speed and efficiency.
  • Implemented security measures, including authentication and authorization schemes.
  • Conducted unit testing and worked on debugging applications to ensure data integrity.
  • Developed UNIX Shell Scripts and batch scripts for automating the execution process.
  • Hands on experience with AWS utilizing custom Oracle RDS databases, S3 bucket, instance creations.

Environment: Oracle 19c, SQL Developer, SQL Loader, Putty, WinSCP, and AWS.

 

 Confidential

(FEB 2020 – MAR 2022)

• • Gathering and analysing requirements from product owners.
  • Translated business requirements and software design specifications into Oracle Forms applications.
  • Wrote SQL, PL/SQL, SQL Plus programs required to retrieve data using cursors and exception handling.
  • Involved in updating procedures, functions, triggers, and packages based on the change request.
  • Conducted unit testing of applications prior to release for user acceptance testing.
  • Prepared applications for release to test, pre-production and production environments.
  • Verifying & documenting stories deployed in production.

 

Environment: Oracle 12c, Oracle 11g, Oracle forms, SQL * Plus, PLSQL Developer.

 

 

Technical Skills

 

• PLSQL
• HTML

• SQL
• C++

• Python

• Java

• CSS

• AWS

• Jira

• GitLab

 

Certifications

 

• Oracle APEX Cloud Developer Professional, certified by Oracle with hands-on experience and knowledge required to design, develop, and deploy Oracle APEX applications.

 

Education

 

 Jawaharlal Nehru Technological University, Ananthapur

Master of Technology, Computer Science.

 

 Madanapalle Institute of Technology & Science, Madanapalle

Bachelor of Technology, Computer Science & Engineering.