SUMMARY

• Highly qualified IT Professional with around 4.5 years of experience in Application Development usingOracle SQL, Oracle PL/SQL andOracle Application Express (APEX).
• Around 5 years of experience in Design, Development, implementation and support of RDBMS in production and development Environments using Oracle Tools.
• Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.
• Involved in entire lifecycle including requirement analysis, estimation, design, implementation testing and production support (SDLC).
• Designed application framework and developed Oracle APEX Application.
• Involved in Migrating Data from legacy application to Oracle Apex environment.
• Expertise in Design and development of interface and conversion programs to integrate Oracle Applications modules to import data from various sources using PL/SQL and SQL*Loader.
• Expertise in Developing front end screens using Oracle Apex, SQL and PL/SQL.
• Coded test packages and performed unit testing of PL/SQL code using PL/SQL framework and the SQL Developer unit testing package.
• Expertise in developing, enhancing and tuning of Oracle database objects and advanced PL/SQL programs.
• Strong experience in writing SQL queries, Stored Procedures, Functions, Packages, Database Triggers, Exception Handlers, Cursors, pipeline functions, PL/SQL Records and Collections.
• Expertise in writing Complex Stored Procedures, Packages, and Functions using PL/SQL for the batch framework.
• Tuned database by tuning queries, creating tables, indexes, Materialized Views, Partitioning Indexes and Re - writing queriesusing an optimized path and gathering necessary statistics on objects using EXPLAIN PLAN.
• Responsible for developing interactive Reports, data entry forms, hypertext linked reports using Oracle APEX 5.0.
• Implemented Oracle APEX API’S such as APEX ITEM, APEX MAIL, APEX COLLECTION, APEX APPLICATION, APEX PLSQL JOB and APEX UTIL.
• Extensively worked on production issues with effective defect management.
• Extensive knowledge and hands-on experience with AJAX, CSS, HTML, JavaScript.
• Formulated SQL queries, functions and processes as per customization requirement for APEX.
• Supported APEX applications and conducted performance tuning for PL/ SQL.
• Involved in exporting, importing, and installing the Oracle APEX Applications to the new environments using the Utilities provided in Oracle APEX.
• Worked with SSO and other custom APEXauthentication schema and authorization schemas for different user roles
• Creating business users reports based on their requirements and adding functionalities to new and existing ApexApplication.
• Extensively worked with third party database tools likeTOAD & PL/SQL Developer.
• Experience in design and development ofboth OLTP and OLAP applications

TECHNICAL SKILLS

Databases: Oracle10g/11g/12c, SQL Server

Scripting Technologies: SQL, JavaScript and Python.

Languages: C, PL/SQL, HTML, Core Java.

Tools: SQL Developer, SQL Navigator, TOAD, SQL plus, WINSCPTOAD, Oracle Apex 3.2, Oracle Apex 4.2, Oracle Apex 5.0, Oracle Apex 5.1.1.

Operation systems: Windows &, Windows Vista, XP, UNIX, LINUX

Development Tools (IDE): Eclipse 3.1, JBuilder, Edit Plus 3.0, TOAD, PL/SQL Developer, SQL Developer

J2EE Technologies: Servlets, JSP, EJB, XML, Structs

Methodologies: AGILE, SCRUM

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

Oracle PL/SQL Developer

Responsibilities:

• Responsible for gathering requirements from the end users and converting the business requirements into technical specifications.
• Extensive back-end programming, hands on experience developing applications using oracle PL/SQL and Apex
• Expertise in writing SQL queries, Stored Procedures, Functions, Packages, and pipeline functions.
• Hands on experience in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Object types and Collections.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL
• Expertise in developing interactive Reports, data entry Forms, hypertext linked reports using Oracle APEX 5.1.
• Experience in testing applications in UAT and involved in importing and Exporting apex applications from dev to prod during release.
• Experience in adding alerts for master detail Forms based on user requirements.
• Created Custom authorization and authentication for the application depending on the business roles.
• Unit testing the PL/SQL code. Made necessary database structure changes for OLTP as per business requirements.
• Created Apex Forms, classic reports and interactive reports in apex with use of java script, HTML, Apex Collections, APEX ITEMS etc.
• Used various plugins to implement new features which native apex does not provide.
• Generated SQL and PL/SQL scripts to create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
• Hands on Experience in installing Apex during Server upgrades.
• Analyzed the design and developed a JavaScript for the application.
• Responsible for moving the Oracle APEX applications to the new development and production server environments.
• Supported integration and end user testing with efficient defect management process.
• Involved in design, development and Modification of PL/SQL stored procedures, functions, packages and triggers to implement business rules into the application.
• Extensive knowledge and hands-on experience with AJAX, CSS, HTML, JavaScript.

Environment: Oracle APEX 5.1.1, Oracle 11g, SQL, PL/SQL, SQL Developer, SVN, HTML, CSS, JavaScript, AJAX, XML, fusion charts.

Confidential, Atlanta, GA

Oracle PL/SQL Developer

Responsibilities:

• Strong experience in writing SQL queries, Stored Procedures, Functions, Packages, and pipeline functions.
• Expertise in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Object types and Collections.
• Extensively used EXPLAN PLAN for performance Tuning.
• Involved in Unit Testing of Procedures and functions.
• Translated business/functional requirements to create and alter database objects like Tables, Indexes, Constraints, Indexes, Triggers, Grants, Synonyms and Stored Procedures.
• Expertise in developing interactive Reports, data entry Forms, hypertext linked reports using Oracle APEX.
• Experience in creating Static LOV/Dynamic LOVs for the drop-down menus
• Developed APEX 5.0 Dynamic Actions to enrich the user experience, minimize user interaction and reduce key strokes.
• Good exposure on using AJAX, CSS, HTML, JavaScript for creating classic reports and interactive reports.
• Expertise in developing different item types like resizable text area, data picker, number field, and new rich-text editor using Oracle APEX 5.1.
• Formulated SQL queries, Functions and processes as per customization requirement for APEX.
• Supported APEX applications and conducted performance tuning for PL/SQL.
• Expertise in writing the SQL, PL/SQL stored procedures to meet the business requirements and the transformations.
• Expertise in loading data from legacy systems usingSQL*Loader.
• Utilize Dynamic T-SQLwithin functions, stored procedures, views, and tables.
• Extensively worked with third party database tools likeTOAD & PL/SQL Developer.
• Experience in design and development ofboth OLTP and OLAP application.
• Experience in Database design usingNormalization and E/R Diagrams.
• Expertise in setting security measures on APEX, database security, application security and system security.

Environment: Oracle APEX 5.1, Oracle APEX 5.0, Oracle 11g, SQL, PL/SQL, SQL Developer, SVN, HTML, CSS, JavaScript, AJAX, fusion charts.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Responsible for gathering the requirements from the end users and converting the business requirements into technical specifications.
• Involved in system analysis, development, documentation and implementation of the inventory and payroll system.
• Involved in design of database model (E-R Model).
• Migration from MS-Access to Oracle.
• Wrote SQL Statements, Stored Procedures, Functions, and Packages to accommodate the new business requirements, business rules, and changes using SQL Navigator, SQL* Plus and TOAD.
• Expertise in developing interactive Reports, data entry forms, hypertext linked reports using Oracle APEX 4.0.
• Expertise in developing different item types like resizable text area, data picker, number field, and new rich-text editor using Oracle APEX 4.0.
• Hands-on experience with AJAX, CSS, HTML, JavaScript.
• Expertise in setting security measures on APEX, database security, application security and system security.
• Developed a debug methodology for tracing the payment details using Stored Procedures and Functions.
• Worked with Oracle APEX EMAIL, interactive and classic reports.
• Created indexes on tables and Optimized Stored procedure queries.
• Developed procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements
• Designed, developed modules using Visual Basic 6.0 and Oracle 8i.
• Involved in writing low-level specifications for screens designed

Environment: SQL, PL/SQL, Oracle 8i, 10g, Oracle Apex 4.0, TOAD, SQL*Plus, Windows XP