SUMMARY

• Over 4+ years of experience as an Oracle Apex and PL/SQL development including design, coding and testing of Oracle Database systems.
• Analyze user requirements, develop functional specifications and perform gap analysis of existing information systems.
• Well experienced in developing web applications and reports using Oracle Apex 18.2, 18.1, 5.1, 5.0, 4.2, 4.1, Apex 4.0.
• Utilize PL/SQL stored procedures and functions within packages, triggers, and libraries. Leverage dynamic SQL, BULK COLLECT, FORALL, materialized views and performance tuning.
• Developed modules using SQL, PL/SQL, Stored Procedures, Functions, Triggers and Reports. Created database objects such as tables, synonyms, sequences.
• Utilized tools like SQL Developer, TOAD, and Data loader, Oracle Apex to enhance functionality and user experience.
• Well experienced in Creating test plans, test cases, test scripts and perform technical unit testing.
• Used SQL*Loader to load database tables.
• Developed user interface using Oracle Forms and Reports and created UNIX scripts to execute background processes.
• Expertise in creating Materialized views in data warehousing environment, working knowledge of Nested tables, PL/SQL tables and arrays.
• Preparing reports, manuals and other documentation on the status, operation and maintenance of application software.
• Ability to convert Oracle Forms into Apex by using the using Forms metadata stored in an .fmx file.
• Promoting clean code and consistent design patterns across the team and Writing complex Sql procedures in Toad, SQL Developer and Oracle Application Express (APEX).
• Used JavaScript, HTML, CSS and jQuery code in the reports for alignment of the data and design custom themes in Oracle Apex.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, Unix

Oracle Tools: Forms 12c,11gR2, Reports, SQL Developer, Toad, SQL Loader

Reporting Tools: Oracle Apex

Scripting Languages: HTML, JavaScript

Database: Oracle 10g, 11g, 12c

Methodologies: Data Modeling Logical & Physical, FACT & Dimension Table.

PROFESSIONAL EXPERIENCE

Oracle Apex Developer

Confidential, Troy, MI

Responsibilities:

• Responsible for designing, developing, implementing, customizing and integrating applications written in Oracle Application Express (APEX) 5.0 - 18.2 with other bank systems, and providing ongoing support and future enhancements of those solutions.
• Involved in the development and testing of custom data migration scripts using custom Oracle PL/SQL subprograms in an optimized manner.
• Participating in all aspects of database programming on Oracle SQL, PL/SQL and related technologies that encapsulate SQL, including Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Table Indexing.
• Performing analysis to find the error and fix it in Procedures, Functions, Packages, Triggers, and Jobs for Data Warehouses, Data mart.
• Upgrading an environment, isolate it and perform necessary testing and remediation without impacting the other non-production environments.
• Performed Active directory integration with My Flagstar Bank website for Apex.
• Work with IT to upgrade existing APEX applications and Oracle server to newer versions by fully testing and making any necessary coding changes to support the new versions of APEX and Oracle
• Created JavaScript library that communicates with application process via AJAX for data validation before page submissions.
• Developed several Admin Screens in which mostly developed Interactive Reports using APEX and Created editable Form Pages for each Row in that Interactive Reports developed and modified form Pages using oracle APEX 18.2.
• Created Records, Tables, Objects, Collections, and Views, Materialized views and Global temporary tables (Nested Tables and Arrays) and performed Error Handling.
• Developed APEX 18.2 Dynamic Actions to enrich the user experience, minimize user interaction and reduce key strokes.
• Extensively used JavaScript for adding dynamic web content to Web Pages.
• Involved in migration of Oracle APEX Applications to the new development, UAT and production server environments.
• Involved in designing and development of several web pages using HTML, CSS and JavaScript.
• Developed and implemented authorization and authentication rules for Application Administrators in order to manage the Oracle APEX applications, users, and their log activity details.
• Involved in trouble-shooting production database problems and report problems also developed user documentation for all the application modules.
• Prepare mapping for the existing Apex applications in old Data Warehouse to new Data Warehouse.
• Perform application related Security and configure services for performance, security, and error handling.
• Closely worked with end-users to understand requirements, build rich iterative prototypes, test, release and support applications and reports as they are requested, without the benefit of a test team, support team, or group of front-end analysts.

Environment: Oracle 11.2.0.4, Oracle Apex 18.2, 5.0.1, SQL*Plus, PL/SQL, Toad, SQL Loader, JavaScript, HTML, CSS, jQuery, AJAX, ETL, JIRA.

Oracle PL/SQL / Apex Developer

Confidential, San Diego, CA

Responsibilities:

• Design and maintain custom Oracle applications using Oracle Apex 4.2, 5.1.
• Effective creation of dynamic reports within the Oracle APEX environment, using APEX reporting tools.
• Develop scripts in SQL, Pl/Sql for data conversion, data migration and act as the primary designer of applications and deployment of the Oracle APEX solutions.
• Worked with business users to translate business needs into data-driven applications.
• Plan for and test software updates, defects, and configuration changes.
• Troubleshoot and debug existing applications and responds to suggestions for improvements and enhancements.
• Developed 4 applications in Apex 4.2 and then migrated it to Apex 5.1 and modified themes to use universal theme.
• Writing new PL/SQL packages, modified existing code perform Certain Specialized functions / enhancement on oracle Application.
• Wrote scripts for Creating and maintaining tables, procedures, functions, and packages, and update, delete, and insert statements and compile them.
• Created JavaScript functions to fetch data from the server without page refreshes to display data dynamically to the user based on user activity.
• Based on the Business needs, created and modified UNIX shell Scripts within the given timelines.
• Experienced in developing page items like text area, date picker, number field, and new rich-text editor using Oracle APEX 5.1.
• Well experienced in working with remote databases for the Oracle Apex applications using Database Links.
• Reviewing Business Requirements, Functional Specifications and creating Detailed Design documents for development.
• Wrote Package and procedures in Apex Database for the file Upload and validating data.
• Involved in resolving production issues and provided on-support call for the business applications.
• Generate PL/SQL scripts for data manipulation and validation and views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Environment: Oracle Apex 4.2, 5.1, Oracle 12c/11g, Oracle forms 12c, Toad, UNIX, SQL and PL/SQL, SQL * Loader, JavaScript.

Oracle Apex/PL/SQL Developer

Confidential

Responsibilities:

• Involved in design and analysis, structure, testing and usage of the application for maintaining the records identified with various functional groups.
• Responsible for implementing authentication (SSO, LDAP, and Customized) and authorization schemes using Oracle APEX 3.2/4.0 security shared components.
• Developed Oracle APEX 4.0 dynamic actions at page level based on the requirements which demand more user interactivity and client-side functionality.
• Involved in database synchronization process across the DEV, TEST, PREPROD and PROD database environments.
• Implemented client-side validations and handled application errors on-demand using JavaScript and AJAX processes.
• Created PL/SQL Procedures, views, materialized views, Functions, cursors (Implicit, Explicit, REF), and packages using PL/SQL and TOAD.
• Implemented various dynamic actions (show/hide/enable/disable) and plugins (for items/regions/processes) within the application.
• Worked with the new component Team Development of Oracle APEX 4.0 in order to manage application development tasks, issues, and milestones.
• Participated in meetings with business analysts and stake holders (Programs Managers and Document Owners/Admins) to discuss about the requirements and implement the functionality.
• Implemented various shared components such as Navigation (tabs, lists, breadcrumbs), User Interface (themes, templates, lovs), Logic (application level items, processes, computations), Files (CSS, images, static files) using Oracle APEX 3.2/4.0.
• Implemented various Oracle APEX page level and item level validations using JavaScript, used Ajax calls to perform validations against the database.
• Work with Architects, Business Analysts, ETL developers, and QA testers to translate data requirements into the physical schema definitions for Oracle.
• Used APEX Collections as a temporary storage to handle data at the page and session level within the application.

Environment: SQL, PL/SQL, Oracle 11g, Oracle Apex 3.2/4.0.1/4.1 , AJAX, JavaScript, JQuery, CSS, HTML, MS Office, Toad, UNIX, Windows 2007, MS- Excel 2013, Notepad++.