I am a Software Development and Data Processing Professional with 10 years of broad-based experience participating in all SDLC phases; that performs object oriented analysis, design, test and development leveraging SQL, PL/SQL, Oracle APIs, Oracle APEX 4.0/4.2/5.0/18.1/19.1, BI Publisher, ETL and data modelling techniques.
Around 8 years of experience in Application Development using Oracle SQL, PL/SQL, and Oracle Application Express (APEX).
Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.
Hands-on experience with Oracle APEX 4.0/4.1/4.2/5.0/5.1/18.1/19.1.
Integration of Oracle APEX with Oracle EBS.
Experience in REST Web Services.
Experience in APEX reports queries & report Layout.
Experience in creating master detail forms.
Experience in developing forms based on views, tables and procedures in tabular and form layouts.
Experience in developing interactive grid, collections, APEX_MAIL and etc.
Excellent conceptual knowledge of Oracle 10g/11g,12c, PL/SQL and SQL.
Experience in Database design using Normalization and E/R Diagrams.
Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
Developing Excel, Word, PDF, XML Templates and Reports in Oracle BI Publisher.
Experience in developing External Tables, Joins, Indexes and sequences.
Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
Experience in writing technical design documents and developing unit test documents.
Experience working with public sector financial projects