SUMMARY

• Around 7 years of software development experience using Oracle, and over 4 years of experience in developing apps using APEX 2.2/3.0/3.2/4.0/4.2.
• Strong knowledge in writing Technical documents based on business requirements.
• Involved in review meetings with the team for better development of applications using APEX.
• Hands on experience writing queries, Stored Procedures, Functions, PL/SQL Packages and Triggers in Oracle and also reports and scripts.
• Strong programming skills in JQuery, JavaScript and SQL/PL/SQL.
• Worked with tools like PL/SQL Developer, SQL Developer.
• Expert in SQL and PL/SQL programming, developed complex code unit, database triggers and used latest features to Optimize performance.
• Hands - on experience converting application to Oracle Application Express.
• Experience in using JavaScript and JQuery in apex applications.
• Skilled in Database Modeling, Loading and Performance Tuning.
• Involved in preparing document and demonstrating the Version control theory in APEX, on how does different developers work on application and integrating with one application which is used in migrating to UAT.
• Knowledge on UNIX Shell Scripting.
• Good Understanding in implementing Higher-performance PL/SQL code and also worked on Performance Tuning of various views/Tables for better report execution time.
• Good Knowledge in Debugging, Testing and Deploying the Applications.
• Excellent ability in writing specifications and gathering requirements from the user to develop reports using Oracle Forms, Oracle Reports and APEX as per the needs of the client and maintain documentation of the reports for further reference.
• Excellent experience in developing the customer reports.
• Experienced in Supporting Multiple Projects simultaneously while maintaining strong quality focus on each and ability to meet deadlines.
• Experienced in working with offshore-onshore model. Coordinated offshore team in requirement transitioning, development handholding and testing phases and ensured efficient delivery.
• Proven ability to work efficiently in both independent and team work environments.

TECHNICAL SKILLS

Database: Oracle 8i/9i/10g/11g.

Dev Tools: Oracle APEX 3.X/4.X, Oracle Forms 6i/10g, Oracle Reports 6i/10g, TOAD, SQL*Plus, SQL Developer, SQL*Loader.

Languages: SQL, PL/SQL, Dynamic SQL, UNIX/Linux Shell Scripts, JavaScript.

Web Technologies: HTML, Apache, JavaScript, CSS, DHTML, XML, AJAX.

GUI: APEX, Forms 6i/9i/10g, Reports 6i/9i/10g.

Operating Systems: Windows Family, MS-Dos, UNIX

PROFESSIONAL EXPERIENCE

Confidential - Alpharetta, GA

Sr. Oracle Apex Developer

Responsibilities:

• Involved in working with analysts to gather more information on data flow designs that required for the project to develop.
• Involved in developing User interface using Oracle APEX forms.
• Developed different types of interactive reports, SQL reports and charts based on the user requirements in APEX.
• Created and used views to show data in Classic Reports.
• Involved in preparing document and demonstrating the Version control theory in APEX, on how does different developers work on application and integrating with one application which is used in migrating to UAT.
• Wrote Custom DML’S on reports to make use of the procedures and functions in APEX.
• Created parameter entry forms for the Oracle Reports to integrate them with APEX.
• Created Page Level and Item Level validations and also page processes and computations using APEX.
• Created several LOV’s, Lists, Breadcrumbs and authorizations that are used throughout the application.
• Implemented JQuery tabs, Auto Complete Features, Popup alerts and date pickers in APEX.
• Used Authorization schemes functionality of APEX to setup security on the screens in the application based on user roles.
• Implemented notification systems for higher-level managers to send mails using APEX email.
• Created Tables, Indexes, Sequences, Triggers, Procedures and Functions for faster data accesses and to incorporate business logic.
• Involved in training the users and creating user Manuel as how to use application and different features of Interactive Reports.
• Migrated applications from one environment to another, took Advisor Reports and Comparison reports to make sure that everything in sink before migrating the application.
• Involved in UAT testing and bug fixes that came across in UAT.

Environment: Oracle Application Express 4.2, SQL, PL/SQL, Toad, Oracle 11g R2, AJAX, HTML, CSS, JQuery, JavaScript, SVN, Notepad++, Windows 7.

Confidential -Hartford, CT

Oracle Apex Developer

Responsibilities:

• Reviewed the Business/ Functional/ System Requirement Specs, High Level Design Documents, and Detailed Design Documents.
• Used APEX to design and develop User Interface forms and reports.
• Developed several database objects such as packages, procedures, functions, triggers, cursors, views, materialized views and others.
• Developed several pages in the APEX Application that is used for reporting and request from feeder.
• Developed items, regions, shared components such as lists, tabs, applications items and application processes.
• Developed different typed of interactive reports, SQL reports and charts based on the user requirements in APEX.
• Created several LOV’s, Lists, Breadcrumbs and authorizations that are used throughout the application.
• Created Validations and Computations in Apex during the page submission time.
• Worked with JavaScript API’s in APEX for various purposes.
• Developed charts to show statistical information related to project timelines, work orders and expenditure for the higher management.
• Developed the data elements list, Flowchart and design database based on the gathered requirements.
• Analyzing data that comes from different sources and wrote packages for maintaining a standard format.
• Used the Data load unload functionality in APEX to upload first time data into the database tables.
• Involved in writing complex queries, Functions, Procedures, and Packages for the project as required using TOAD.
• Involved in Unit and Integration testing of PL/SQL Procedures, Functions and Database Triggers.
• Involved in Production Support, Problem resolutions and bug fixing.
• Actively involved in raising issues and coordinating between the Management & Users. Involved in preparing Technical document and also Responsible for requirement analysis and client interaction.
• Involved in fixing the problems and raised issues from custom modifications in the module.

Environment: Oracle Application Express 4.0, SQL, PL/SQL, TOAD, Oracle 11g, AJAX, HTML, CSS, JQuery, JavaScript, SVN, Windows XP.

Confidential -Atlanta, GA

Oracle Apex Developer

Responsibilities:

• Involved in the complete life cycle of database development that included crating Stored Procedures, designing database and populating data for web portal for views and reporting needs.
• Customized Standard reports with the user requirements using Oracle Reports.
• Involved in developing user interface using Oracle APEX forms.
• Created parameter entry forms for the Oracle Reports to integrate them with APEX.
• Created Page level and item level validations and also page processes and computations using APEX.
• Implemented validations using AJAX and JavaScript processing for server side data fetches.
• Implemented JQuery tabs, auto complete features, popup alerts and date pickers in APEX.
• Used Authorization Schemes functionality of APEX to set up security on the screens in the application based on user roles.
• Implemented notification systems for higher level managers to send mails using APEX emails.
• Created Tables, Indexes, Sequences, Triggers, Procedures, and functions for faster data access and to incorporate business logic.
• Analyzing data that comes from different sources and wrote packages for maintaining a standard format.
• Used the data load unload functionality in APEX to upload first time data into the database tables.
• Involved in Unit and Integration testing of PL/SQL Procedures, Functions and Database Triggers.
• Involved in offshore team coordination. Working with them to provide necessary requirement documentation, validating the development work and bug tracking.
• Involved in Production support, Problem resolutions and bug fixing.
• Actively involved in raising issues and coordinating between the management & users.

Environment: Oracle Application Express, SQL, PL/SQL, TOAD, Oracle 10g, AJAX, HTML, CSS, JQuery, JavaScript, SVN, CVS, Windows XP.

Confidential - Philadelphia, PA

Sr. PL/SQL Developer

Responsibilities:

• Involved in gathering the requirements from users to develop the application from scratch.
• Involved in working with analysis for gather more information on data flow designs that require for the project to develop.
• Developed Basic APEX applications to generate reports for easy management.
• Developed Stored Procedures to maintain details of the vendors and maintained them in packages.
• Designed database tables using various Normalization techniques and database rules.
• Developed reports as per the requirements collected from the users using discoverer and Oracle reports 10g.
• Good experience working on TOAD, PL/SQL Developer for database access.
• Generate and maintain keys, constraints and Relationships between the tables for OLPT & OLAP instances.
• Developed complex SQL Queries to perform the back end testing of the Oracle database using AQL and UNIX Shell commands.
• Created Shell Scripts for automating the execution process.
• Involve in migrating applications to the new release versions.

Environment: SQL, PL/SQL, APEX, Oracle 10g, Oracle forms 10g, Oracle Reports 10g, TOAD, JavaScript, SQL*Loader, MS Excel, .

Confidential 

PL/SQL Developer

Responsibilities:

• Involved in designing and developing Oracle forms and Reports.
• Designing and building reports using Oracle Report Designer.
• Created several SQL Queries, Procedures, Functions, packages and several database objects.
• Preparation of class structure and sequence diagrams using Rational Rose.
• Using Views for designing and building reports.
• Involved in testing backend SQL Queries for Query Optimization.
• Developed Several Packages that are used in oracle forms and reports.
• Developed complex SQL Queries to perform the black end testing of the Oracle database using SQL and UNIX shell commands.
• Preparing documentation for all reports.

Environment: SQL, PL/SQL, SQL*Loader, Oracle Forms 6i, Oracle Reports 6i, SQL Editor, UNIX.