SUMMARY

• Around 7+ years of extensive experience in the complete Software Development Life Cycle (SDLC) & Agile Methodology.
• Around 4+ years of experience in Oracle APEX, Developed Oracle APEX applications in complete SDLC lifecycle.
• Extensive knowledge and hands - on experience with AJAX, CSS, HTML, JavaScript.
• Extensive knowledge and hands-on experience with AJAX, CSS, HTML, JavaScript.
• Worked with Oracle APEX on APEX.ITEM CHECKBOX, APEX.ITEM RADIOGROUP.
• Worked with Oracle APEX EMAIL, interactive and classic reports.
• Extensive experience writing Stored Procedures, Functions, Packages, PL/SQL routines, Database triggers, Shell-Scripting, unit testing integrity and also involved in complex backend data extraction, transformation and loading operations on oracle using INFORMATICA, SQL Loader and DATA PUMP utilities.
• Created multiple customized PL/SQL Procedures & Packages for various businesses’ needs, to transform data before the loading process, and to manipulate and sort data for the Reports specifications.
• Well experienced in Query Optimization and Tuning using bulk collections, Hints, Explain Plan, SQLTRACE. Experienced in creating External tables, Uploading/Downloading data using SQL*Loader control files.
• Strong Data Modeling experience using ER diagram, Dimensional/Hierarchical data modeling, Star Schema modeling, Snowflake modeling using tools like Erwin.
• Extensive experience writing Stored Procedures, Functions, Packages, PL/SQL routines, Database triggers, Shell-Scripting, unit testing integrity and also involved in complex backend data extraction, transformation and loading operations on oracle using INFORMATICA, SQL Loader and DATA PUMP utilities.
• Expertise in source control tools like CVS, SVN and Clear Case.
• Possess strong leadership, interpersonal and excellent analytical & problem solving skills.
• Expertise in writing Triggers Creating tables, views, Indexes, Constraints, partitions etc. Expertise in using cursors, collections, records, Dynamic SQL, Object Types, bulk operations, exception handling, analytical functions, DBMS packages, etc.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, UNIX Shell Programming and PERL.

RDBMS: Oracle 11g/10g/9i/8.x, SQL server 2007/2005, and MS Access.

Database Tools: SQL Navigator 4.1/5.1, PLSQL Developer, TOAD and SQL developer.

Operating Systems: Windows NT/2000/98/XP, Linux and Sun Solaris.

Web Applications: JAVA, CSS, XML, and HTML, Oracle APEX(front-end)

PROFESSIONAL EXPERIENCE

Confidential, Houston, Tx

Lead Oracle APEX Developer

Responsibilities:

• Worked on the project for developing the relational database schema for building the table structure.
• Extensive knowledge and hands-on experience with AJAX, CSS, HTML, JavaScript.
• Worked with Oracle APEX on APEX.ITEM CHECKBOX, APEX.ITEM RADIOGROUP.
• Worked with Oracle APEX EMAIL, interactive and classic reports.
• Developed APEX 5.0 Dynamic Actions to enrich the user experience, minimize user interaction and reduce key strokes.
• Developed Fusion charts using APEX 4.2.
• Implemented APEX 5.0 for APEX Office Printing (AOP). Implemented summary, interactive report and detailed reports.
• Developed and implemented different item types resizable text area, data picker, number field, and new rich-text editor using Oracle APEX 5.0.
• Used BI Publisher for the project reports if needed.
• Implemented in-bound operation for an independent module.
• Developed Dialog boxes using Modal regions and fmodal.
• Developed in creating Static LOV/Dynamic LOVs for the drop-down menus.
• Developed Template design for particular reports.
• Responsible for developing interactive Reports, data entry forms, hypertext linked reports using Oracle APEX 5.0.
• Created reports in Answers and embedded them in Dashboards according to the requirements.
• Developed and modified Oracle packages, stored procedures, functions, Scripts, synonyms, tables and indexes to implement business requirements and rules.
• Used SVN version control management software’s for maintaining the code version standards and security.

Environment: Oracle APEX 5.0, Oracle APEX 4.2.5, Oracle 12c, SQL, PL/SQL, SQL Developer, SVN, JavaScript, CSS, XML, fusion charts.

Confidential, Sacramento, CA

Lead Oracle APEX Developer

Responsibilities:

• Worked on the project for developing the relational database schema for building the table structure.
• Extensive knowledge and hands-on experience with AJAX, CSS, HTML, JavaScript.
• Worked with Oracle APEX on APEX.ITEM CHECKBOX, APEX.ITEM RADIOGROUP.
• Worked with Oracle APEX EMAIL, interactive and classic reports.
• Developed APEX 5.0 Dynamic Actions to enrich the user experience, minimize user interaction and reduce key strokes.
• Developed and implemented different item types auto complete, resizable text area, data picker, number field, and new rich-text editor using Oracle APEX 5.0.
• Responsible for developing interactive Reports, data entry forms, hypertext linked reports using Oracle APEX 5.0.
• Developed in creating Static LOV/Dynamic LOVs for the drop-down menus.
• Developed Template design for particular reports.
• Uploading Files into the application and storing them in the database and retrieving in the history
• Developed reports using BI Publisher which involved printing images on the PDF Documents.
• Developed and implemented different item types auto complete, resizable text area, data picker, number field, and new rich-text editor using Oracle APEX 5.0.
• Responsible for developing interactive Reports, data entry forms, hypertext linked reports using Oracle APEX 5.0.
• Created reports in Answers and embedded them in Dashboards according to the requirements.
• Designed and developed custom Dashboards.
• Developed Back Order Detail Report and Sales Tracking Report using XML/BI Publisher.
• Developed and modified Oracle packages, stored procedures, functions, Scripts, synonyms, tables and indexes to implement business requirements and rules.
• Used SVN version control management software’s for maintaining the code version standards and security.

Environment: Oracle APEX 5.0, Oracle 11g, SQL, PL/SQL, SQL Developer, SVN, JavaScript, CSS, XML

Confidential, San Francisco, CA

Lead Oracle APEX Developer/ADF Developer

Responsibilities:

• Extensive knowledge and hands-on experience with AJAX, CSS, HTML, JavaScript.
• Developed and implemented different item types resizable text area, data picker, number field, and new rich-text editor using Oracle APEX 5.0.
• Modified Themes and Template design as per the requirements.
• Created Oracle Apex Application from Scratch for few applications.
• Implemented the Authorization and Authentication schemes for the application
• Developed query based conditional validations using APEX 5.0 for forms and reports in the page rendering and page processing.
• Implemented Oracle APEX APIs such as APEX ITEM, APEX MAIL, APEX COLLECTION, APEX APPLICATION, APEX PLSQL JOB and APEX UTIL.
• Created region type, item type and dynamic action plugins using the APEX Plugin functionality and Jquery plugins.
• Developed in creating Static LOV/Dynamic LOVs for the drop-down menus.
• Implemented SSO Authorization scheme (third-party plugin) for the users to access application.
• Developed Template design for particular reports.
• Uploading Files into the application and storing them in the database and retrieving in the history
• Created reports in Answers and embedded them in Dashboards according to the requirements.
• Designed and developed custom Dashboards.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
• Batch jobs Design using PL/SQL, SQL* Plus, SQL*Loader, Unix Shell programming.
• Used SVN version control management software’s for maintaining the code version standards and security.

Environment: Oracle 11g, SQL, PL/SQL, SQL*Plus, Toad, UNIX, K-Shell, SVN, SQL Developer, Oracle APEX 5.0,Oracle APEX 4.2.

Confidential

Oracle APEX Developer

Responsibilities:

• Uploading Files into the application and storing them in the database and retrieving in the history
• Extensively used shared components for the Authorization schemes and importing images which can be used throughout the application.
• Analyzed the design and developed a JavaScript for the application. Modified the CSS as needed.
• Performed Data Modeling for the requirements to design the table structures and the relationships between the tables for the module.
• Developed APEX 4.2Dynamic Actions to enrich the user experience, minimize user interaction and reduce key strokes.
• Worked on eliminating duplicates by using the concepts of the relational database schema design techniques in the tables.
• Sent Email notification to the users using APEX MAIL.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Implemented Performance Tuning by using Explain Plan and TKPROF tools that included Optimizer hints, using Indexes and also Query tuning
• Developed and implemented different item types auto complete, resizable text area, data picker, number field, and new rich-text editor using Oracle APEX 4.2.
• Responsible for developing interactive Reports, data entry forms, hypertext linked reports using Oracle APEX 4.2.
• Created reports in Answers and embedded them in Dashboards according to the requirements.
• Developed and modified Oracle packages, stored procedures, functions, Scripts, synonyms, tables and indexes to implement business requirements and rules.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Implemented Performance Tuning by using Explain Plan for Query tuning.

Environment: Oracle APEX 4.2, XML, Oracle 11g, SQL, PL/SQL, SQL Developer, JavaScript, CSS, XML

Confidential

Oracle Developer/APEX Developer

Responsibilities:

• Worked on graphical query builder and generated reports using SQL workshop provided in APEX.
• Developed query based conditional validations using APEX 4.1 for forms and reports in the page rendering and page processing.
• Create DB links and synonyms to connect the APEX application database to different database.
• Used Oracle APEX 4.1 utilities to Export and Import Large Volumes of Data in the format of CSV files, Excel Sheets into the tables.
• Developed and modified Oracle packages, stored procedures, functions, Scripts, synonyms, tables and indexes to implement business requirements and rules.
• Created Oracle Apex Application from Scratch for few applications.
• Implemented the Authorization and Authentication schemes for the application
• Developed query based conditional validations using APEX 4.1/4.2 for forms and reports in the page rendering and page processing.
• Implemented Oracle APEX APIs such as APEX ITEM, APEX MAIL, APEX COLLECTION, APEX APPLICATION, APEX PLSQL JOB and APEX UTIL.
• Created region type, item type and dynamic action plugins using the APEX Plugin functionality and Jquery plugins.
• Create DB links and synonyms to connect the APEX application database to different database.
• Sent Email notification to the users using APEX MAIL.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Implemented Performance Tuning by using Explain Plan and TKPROF tools that included Optimizer hints, using Indexes and also Query tuning.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
• Batch jobs Design using PL/SQL, SQL* Plus, SQL*Loader, Unix Shell programming.
• Prepare and execute unit and integration test cases and support the build and releases activities. Support the QA and UAT testing.
• Involved in the solving the tickets that are raised by the end users.
• Responsible for creating PLSQL Programs and UNIX Scripts for Data Validation and Data Conversion.
• Prepared UNIX shell script for the transfer of files from FTP to SFTP.
• Used SVN version control management software’s for maintaining the code version standards and security.
• Involved in conversion of DBMS JOBS to control-m jobs to maintain SLA and to implement more options.
• UTL FILE utility used to write the debug information and also for saving the data to a flat file.
• Used multiple parameterized cursors and complex loops for extracting the data.

Environment: Oracle 11g, SQL, PL/SQL, SQL*Plus, Toad, UNIX, K-Shell, SVN, Putty PSFTP, SQL Developer, Oracle APEX 4.1,Oracle APEX 3.2, Control-M (Third-party tool).