We provide IT Staff Augmentation Services!

Resume

4.00/5 (Submit Your Rating)

Oracle Apex Pl Sql, DevelopeR

PROFESSIONAL SUMMARY:

  • Over 7 years of programming experience as an Oracle Apex/PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS) in a variety of applications including insurance, healthcare, telecommunications and business applications.
  • Experience with various technologies such as Oracle12c/11g/10g/9i, SQL, PL/SQL, Oracle APEX 3.0/3.2/4.0/4.2/5.0 , Oracle Forms 6i/10g and Oracle Reports 6i/10g, SQL*Loader, Dynamic SQL, TOAD, PL/SQL Developer.
  • Extensive experience in developing complex SQL Queries, Triggers, Materialized Views, Stored Procedures, Functions, Packages and other database objects.
  • Developed several types of forms and reports using Oracle APEX such as form on a table, view, master detail reports, tabular forms and others.
  • Developed several application processes, computations, validations, LOVS, LISTS, shared components for code reusability.
  • Implemented security features for authentication at different levels using the LDAP, SSO Authentication and authorization schemes in APEX that are custom at data levels.
  • Extensively worked with JavaScript’s, Jquery, Bootstrap and Ajax calls for rich look and feel of the Apex pages with minimum page refreshes.
  • Experience in developing the forms and reports using Oracle Apex for the business logic implementation and automation of workflows with rich UI.
  • Experience in developing Forms 6i/10g and generating Reports in Report 6i/10g.
  • Experience with writing SQL queries for data validation and data integrity testing.
  • Experience with performance testing for data loading process in DWH environment.
  • Experience in Tuning using various types of Hints, Partitioning, Indexes, Explain Plan and TKProof.
  • Expertise in Operating Systems like Sun Solaris, HP UNIX, Windows XP/NT/2000.
  • Involved in database designs, functional design and collection of user requirements.
  • Experience in functional design of the application specific modules and other core areas.
  • Experience in Team Management, Quality Assurance, Software Testing, and Reverse Engineering etc.

TECHNICAL SKILLS:

Database: Oracle 12c/11g/10g/9i/8i, Oracle Express, Oracle APEX 3.0/3.2/4.0/4.2/5.0 , MS SQL Server 2000, Microsoft Access, ODBC, JDBC.

Languages: SQL, PL/SQL, Dynamic SQL, T - SQL, UNIX/Linux Shell Scripts, Java, Visual Basic.Net, C++/C, JSP, ASP, VB Script, PHP, Perl, JavaScript, XML.

Web: HTML, DHTML, CSS, JavaScript, Ajax, Jquery, Bootstrap, VBScript, ASP, PHP, Core Java, Java Servlets, J2EE, Apache Tomcat

Development Tools: Oracle APEX 3.0/3.2/4.0/4.2/5.0 , Oracle Forms 6i, Oracle Reports 6i, Visual Studio.Net, Visual Studio 6, Microsoft Access, Oracle SQL *Plus, Visio, TOAD, PL/SQL Developer, SQL Developer, OBIEE, UNIX/Linux Utilities.

Methodologies: ER Diagram, OOP, OOA, UML, Structured Analysis, Agile

Operating Systems: UNIX, Linux, Windows XP/2000/NT/98

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apex/PL/SQL Developer

Responsibilities:

  • Extensive experience in developing complex SQL Queries, Triggers, Materialized Views, Stored Procedures, Functions, Packages and other database objects.
  • Developed several types of forms and reports using Oracle APEX such as form on a table, view, master detail reports, tabular forms and others.
  • Developed several application processes, computations, validations, LOVS, LISTS, shared components for code reusability.
  • Implemented security features for authentication at different levels using the LDAP, SSO Authentication and authorization schemes in APEX that are custom at data levels.
  • Extensively worked with JavaScript’s, Jquery, Bootstrap and Ajax calls for rich look and feel of the Apex pages with minimum page refreshes.
  • Experience in developing the forms and reports using Oracle Apex for the business logic implementation and automation of workflows with rich UI.
  • Experience in developing Forms 6i/10g and generating Reports in Report 6i/10g.
  • Experience with writing SQL queries for data validation and data integrity testing.
  • Experience with performance testing for data loading process in DWH environment.
  • Experience in Tuning using various types of Hints, Partitioning, Indexes, Explain Plan and TKProof.
  • Expertise in Operating Systems like Sun Solaris, HP UNIX, Windows XP/NT/2000.
  • Involved in database designs, functional design and collection of user requirements.
  • Experience in functional design of the application specific modules and other core areas.

We'd love your feedback!