We provide IT Staff Augmentation Services!

Lead Oracle Apex Developer/adf Developer Resume

2.00/5 (Submit Your Rating)

Sacramento, CA

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, Sacramento, CA

Lead Oracle APEX Developer/ADF 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 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.
  • 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 4.2, 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 auto complete, 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, Irvine, CA

Oracle APEX Developer

Responsibilities:

  • Design and developed multiple web (UI) pages usingJSF, Rich Faces, JSP and XHTML.
  • Developed, invoking and implemented validations onJSFbacking beans.
  • Implementing business logic using JAVA,JSFcoding / development with EJB.
  • 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, Java, Servlets, JSP2.0,Struts1.2, Tag Libraries, XML, Oracle 11g, SQL, PL/SQL, SQL Developer, JavaScript, CSS, XML

Confidential, Phoenix, AZ

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).

Confidential, Denver, CO

Oracle APEX Developer/Developer/Analyst

Responsibilities:

  • 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 designing and developing various interactive reports with column filters for managing Applications using Oracle Application Express APEX 3.1/3.2
  • Also involved in making changes to the existing forms, and reports (Master-Detail) using Oracle APEX3.2; depending upon the user suggestions and feedback.
  • Responsible for moving the Oracle APEX applications to the new development and production server environments.
  • Responsible for performing validations against the database column data in Oracle APEX Interactive reports and tabular forms using JavaScript.
  • Involved in exporting, importing, and installing the Oracle APEX Applications to the new environments using the Utilities provided in Oracle APEX 3.2
  • Created lot of images within the system in the form of Logo, applied the image as a report column, created tabs, lists and many pages using pl/sql.
  • Created sign in and signup process for the user login.
  • Developed various types of regions (HTML, Report, Form, Chart, Tree, List, PL/SQL Dynamic) using Oracle APEX 3.2 depending upon the requirements, which is a part of page rendering process of the Application.
  • Created Custom authorization and authentication for the application.
  • Created documentation, design and implemented rich user interfaces using Oracle Apex.
  • Created database objects like Tables, Indexes, Sequences and Views etc.
  • Involved in design, development and Modification of PL/SQL stored procedures, functions, packages and triggers to implement business rules into the application.
  • Used extensively Cursor Expressions for data retrieval and manipulation in Oracle Database.
  • Developed Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries.
  • Extensively worked on Performance tuning by using Explain plans and various hints.
  • Worked on Table Partitioning and deploying various methods of indexing like local Indexes and Global Indexes on portioned tables.
  • Used UTL file package to read and write to external files.
  • Used BI Publisher reports to get the data for the application as and needed.

Environment: Oracle APEX 3.1/3.2, Oracle 11g, SQL, PL/SQL, SQL*Plus, PL/SQL Developer, XML, XML Spy, UNIX, PERL, Oracle BI Publisher 11.1.

Confidential, Dubuque, Iowa

Oracle Developer/Analyst

Responsibilities:

  • Developed Stored Procedures, Packages, and Functions using PL/SQL for the batch framework.
  • Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, triggers, packages, stored procedures, roles and granting privileges.
  • Fixed and Developed front end application programming using Java Swing
  • Used multiple packages of the Core Java API, including Swing, printing and imaging.
  • Responsible for 24/7 Production support during loads.
  • Writing PERL shell scripts to massage the data before loading into the database tables.
  • Used SERENA pvcs version control management software’s for maintaining the code version standards and security.
  • Implementing quality control techniques for bug fixing & troubleshooting the existing batch jobs dependencies and code modules, also used BUGZILLA bug tracking tool.
  • Extensively used TOAD, SQL Loader, Materialized views.
  • Involved in major code rewrite effort to increase performance by normalizing the data and using index organized tables.
  • Performed application SQL tuning using Explain plan, TKPROF, Indexes, Partition Pruning, Bulk Processing and Hints.
  • Extensively worked with SQL* LOADER, XML style sheets, global temporary tables to load data into the database.
  • Implemented Export/Import Oracle utilities using External tables to move data to different schemas.
  • Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
  • Involved in tuning the long running PL/SQL queries for maximum efficiency in various business schemas of batch processing.
  • Worked with Business teams to make sure requirements were converted correctly and the correct logic was implemented in the technical design and code.
  • Worked with CFM files for the application frontend.

Environment: Oracle 10g, SQL, PL/SQL, Core Java 6.0, SQL Navigator 5.5, Shell scripting, PERL, Adobe Cold Fusion and Windows XP.

We'd love your feedback!