SUMMARY:

• Over 7 years of software development experience using Oracle technologies including Four years of experience in Developing Applications Using Application Express Framework.
• Involved in complete SDLC including architecture, analysis, design, development, testing, implementation & maintenance of application software in the Client/Server and web based environments.
• Extensively used PL/SQL to build Oracle Packages, stored procedures, functions, triggers, cursors, ref cursors, views for processing data, enforcing referential integrity and needed business rules.
• Extensively worked on PL/SQL Object Types, Dynamic SQL, Collections, Autonomous transaction, Compound triggers, Materialized Views.
• Developed Test Strategy, Test Plan, Test Cases (Functional and Non - Functional), Test Scenarios from System Requirement Specifications and Business requirements.
• Knowledgeable in client-server technology, GUI design, and Relational Database Management.
• Experienced in Tuning SQL and PL/SQL code for better performance with large volume of data.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX Scripting, SQL, PL/SQL and SQL Loader.
• Experience in using Oracle Apex 4.2/4.0/3.2/3.0/2.8, Forms 10g/6i/5.0&4.5, Reports 10g/6i&2.5, Oracle designer 6i/4.7, Oracle discoverer 10g for developing end user screens and reports and also adept in using Oracle Tools like SQL* Plus, Toad, SQL Developer, SQL Loader, Data Loader, SQL navigator, JDeveloper.
• Expertise in using APEX 4.1/4.0/3.2/3/1/3.0 application builder tool to build database driven applications such as developed Interactive Reports and Hyper Text Linked Reports.
• Experience in developing validations of the page and page items using Ajax calls and also PL/SQL packages.
• Experience in developing interfaces to interact with multiple schemas for data loads and refresh.
• Expertise in using HTML, CSS, Jquery, JavaScript and Ajax in APEX applications to have client side
• Programming and Validations.
• Experience in implementing Authentication, Authorization on Embedded PL/SQL gateway, Oracle HTTP Server and Web logic server.
• Experience in developing SQL*Loader control programs and PL/SQL validation scripts for validating data to load data from staging tables to production tables.
• Proficient in writing UNIX KORN Shell Scripts.

TECHNICAL SKILLS:

Database: Oracle 8i, 9i, 10g, 11g, 12c,MS Access.

Operating Systems: Sun Solaris, Unix, Windows NT/2000/XP/2010, Linux Tools

DB Utilities: Oracle Forms 10g/6i/4.5,Reports 10g/6i/2.5, Oracle Apex 5.0/ 4.2/4.0/3.2/3.0/2.8, Oracle Designer 6i/4.7,Oracle Discoverer 10g

GUI Tools: SQL*PLUS, SQL Developer, TOAD, SQL*Loader, SQL Navigator, Loadrunner, Winrunner, Jenkins 3.5, Microsoft Visio, Rational Rose.

Languages: SQL, PL/SQL, C, C++, Perl, JavaScript, Unix shell scripts.

Web Technologies: ASP, HTML, CSS,DHTML, XML, VB 6.0

Subversion: Tortoise SVN, GitHub

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Oracle Apex Developer

Responsibilities:

• Understand the requirements of the application functionality based on the design document received.
• Writing complex SQL queries and PL/SQL procedures and functions to extract data from various source tables.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
• Work with end users and business team to understand the functionality of the applications in Oracle APEX 4.2.
• Responsible for developing custom application using APEX. This involves developing APEX Reports and Forms, conversion of Oracle Reports into Oracle APEX Reports.
• Analyzed business requirements and technical specifications of application in development and produced test cases for functional testing, integration testing and regression testing.
• Involved in the meetings continuously with users and modifying the test cases accordingly to test the new features developed in the application as per the user requirements as part of UAT.
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing & Implementation.
• Created page processes at several instances and computations in APEX.
• Developed validations using Ajax calls with JavaScript and PL/SQL packages.
• Experience in using Application processes and items for code reusability across the application.
• Experience in building classic reports, interactive reports and dynamic PL/SQL reports to enhance the performance.
• Followed standardized patterns to prevent SQL injections and url tampering from APEX applications.
• Experience working with several types of pages items, regions, page processes and branching.
• Experience in conditional processing of code and display regions based on several conditions.
• Configure SSL for APEX over web logic server, HTTP server and others in Test and production environments.
• Developed the user interface using the Oracle Apex form types depending on the requirements.
• Develop the PLSQL Scripts to analyze other DB objects like Procedures, Packages, Triggers, Sequences etc in the VLS-MSP migration applications.
• Experience in using JavaScript, HTML, and CSS and also built standard templates to meet the corporate Themes for the application.
• Created and modified SQL*Loader scripts for migrating flat file data into target.
• Wrote Shell Scripting programs to execute PL/SQL and SQL Files.
• Wrote the Control-m Jobs to schedule the batch files. Written batch files to execute the backend PL/SQL Programs, and Oracle Reports.
• Created New and modified Database procedures, functions, triggers and other database objects by using TOAD tool.
• Providing support for the EWB systems and worked with other teams in the migration process for converting production legacy system to the new system.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, Hints, Indexing and Partitioning of tables.

Environment: Oracle 11g, Oracle Apex 5.0/4.2/4.1, Apache Jenkins 3.5, Tortoise SVN, Control-M,Apache JIRA,SQL, PL/SQL, TOAD, SQL Developer, SQL *Plus, Windows NT

Oracle Apex Developer.

Responsibilities:

• Gather requirements and review functional requirements, business flows including application security
• Responsible for developing custom application using APEX. This involves developing APEX Reports and Forms, conversion of Oracle Reports into Oracle APEX Reports.
• Involved in full development cycle of planning Analysis, Design, Development, Testing & Implementation.
• Created page processes at several instances and computations in APEX.
• Developed validations using Ajax calls with JavaScript and PL/SQL packages.
• Experience in using Application processes and items for code reusability across the application.
• Experience in building classic reports, interactive reports and dynamic pl/sql reports to enhance the performance.
• Followed standardized patterns to prevent SQL injections and URL tampering from APEX applications.
• Experience working with several types of pages items, regions, page processes and branching.
• Experience in conditional processing of code and display regions based on several conditions.
• Designed the look and feel of the APEX forms (User Interface) along with the users.
• Developed the user interface using the Oracle Apex form types depending on the requirements.
• Develop phase, APEX application and Develop PL/SQL API's for business logic (business Logic is not to be developed in APEX)
• Experience in using JavaScript, HTML, and CSS and also built standard templates to meet the corporate themes for the application.
• Writing complex SQL queries and PL/SQL procedures and functions to extract data from various source tables.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling
• Designed and developed Oracle Forms & Reports using Forms10g/6i/4.5 and Reports10g/ 6i/2.5. Including Forms based on stored procedures
• Extensive experience with various test efforts like data validation, integrity testing and Unit testing.
• Used Oracle designer to produce the ER diagrams, Dataflow, function Hierarchy.
• Created and modified SQL*Loader scripts for migrating flat file data into target.
• Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team.
• Wrote Shell Scripting programs to execute PL/SQL and SQL Files. Wrote the Corn Jobs to schedule the batch files. Written batch files to execute the backend PL/SQL Programs, and Oracle Reports.
• Created New and modified Database procedures, functions, triggers and other database objects by using TOAD tool.
• Providing support for the EWB systems.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, Hints, Indexing and Partitioning of tables.

Environment: Oracle 11g/10g, Oracle apex 4.1/4.0, Forms 10g, Reports10g, Designer 10g, SQL, PL/SQL, TOAD, SQL Developer, SQL *Plus, Windows NT

Oracle Developer

Responsibilities:

• Gather requirements and review functional requirements, business flows including application security.
• Responsible for developing custom application using APEX. This involves developing APEX Reports and Forms, conversion of Oracle Reports into Oracle APEX Reports.
• Involved in full development cycle of planning Analysis, Design, Development, Testing & Implementation.
• Created page processes at several instances and computations in APEX.
• Developed validations using Ajax calls with JavaScript and PL/SQL packages.
• Experience in using Application processes and items for code reusability across the application.
• Experience in building classic reports, interactive reports and dynamic pl/sql reports to enhance the performance.
• Followed standardized patterns to prevent SQL injections and url tampering from APEX applications.
• Experience working with several types of pages items, regions, page processes and branching.
• Experience in conditional processing of code and display regions based on several conditions.
• Designed the look and feel of the APEX forms (User Interface) along with the users.
• Developed the user interface using the Oracle Apex form types depending on the requirements.
• Develop phase, APEX application and Develop PL/SQL API's for business logic (business Logic is not to be developed in APEX)
• Experience in using JavaScript, HTML, and CSS and also built standard templates to meet the corporate themes for the application.
• Writing complex SQL queries and PL/SQL procedures and functions to extract data from various source tables.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling
• Designed and developed Oracle Forms & Reports using Forms10g/6i/4.5 and Reports10g/ 6i/2.5. Including Forms based on stored procedures
• Extensive experience with various test efforts like data validation, integrity testing and Unit testing.
• Used Oracle designer to produce the ER diagrams, Dataflow, function Hierarchy.
• Created and modified SQL*Loader scripts for migrating flat file data into target.
• Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team.
• Wrote Shell Scripting programs to execute PL/SQL and SQL Files. Wrote the Corn Jobs to schedule the batch files. Written batch files to execute the backend PL/SQL Programs, and Oracle Reports.
• Created New and modified Database procedures, functions, triggers and other database objects by using TOAD tool.
• Providing support for the EWB systems.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, Hints, Indexing and Partitioning of tables.

Environment: Oracle 11g/10g, Oracle apex 4.1/4.0, Forms 10g, Reports10g, Designer 10g, SQL, PL/SQL, TOAD, SQL Developer, SQL *Plus, Windows NT

Oracle Developer

Responsibilities:

• Experience working with several types of pages items, regions, page processes and branching.
• Experience in conditional processing of code and display regions based on several conditions.
• Designed the look and feel of the APEX forms (User Interface) along with the users.
• Developed the user interface using the Oracle Apex form types depending on the requirements.
• Experience in using JavaScript, HTML, and CSS and also built standard templates to meet the corporate
• Themes for the application.
• Writing complex SQL queries and PL/SQL procedures and functions to extract data from various source tables.
• Developed and maintained SQL Scripts to extract data from the database.
• Involved in writing SQL Scripts to Parameterize the Actions to test Different screens of the whole Application.
• Generating reports to ensure data integrity and validate business rules.
• Performing Manual Testing to test the usability of the application.
• Involved in full development cycle of planning Analysis, Design, Development, Testing & Implementation.
• Created page processes at several instances and computations in APEX.
• Experience in using Application processes and items for code reusability across the application.
• Experience in building classic reports, interactive reports and dynamic pl/sql reports to enhance the performance.
• Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
• Extensive experience with various test efforts like data validation, integrity testing and Unit testing.
• Used Oracle designer to produce the ER diagrams, Dataflow, function Hierarchy.
• Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team.
• Wrote Shell Scripting programs to execute PL/SQL and SQL Files. Wrote the Corn Jobs to schedule the batch files.
• Written batch files to execute the backend PL/SQL Programs, and Oracle Reports.
• Created New and modified Database procedures, functions, triggers and other database objects by using TOAD tool.

Environment: Oracle 11g/10g, Oracle Apex 4.1/4.0, Forms 10g, Reports10g, Designer 10g, SQL, PL/SQL, TOAD, SQL Developer, SQL *Plus, Windows NT

Software Consultant

Responsibilities:

• Created database objects for the system like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures.
• Developed Front-end forms depending upon the logic such as Master-detail form and complex forms for the application.
• Loaded data into various tables from Flat files, Access database as well as from Excel Spreadsheets using SQL*Loader.
• Developed stored procedures, packages and functions for the application that could be called by Forms & Reports.
• Developed complex reports like matrix reports, tabular reports for the systems using running totals, sub totals, grand totals and daily balance.
• Developed new Data Input forms and Reports using Oracle Forms and Reports builder.
• Written scripts to create Temporary tables in various schemas and Audit Transactions.
• Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling.

Environment: Oracle 8i/9i, UNIX, Forms 4.5 and Reports 2.5, SQL, SQL*Plus, PL/SQL, SQL*Loader, Toad.