We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Ashburn, VA

SUMMARY

  • 8 +Years of experience in Design, Development, implementation and support of RDBMS in production and development Environments using Oracle Tools.
  • Involved in entire lifecycle including requirement analysis, estimation, design, implementation testing and production support (SDLC).
  • Expertise in creating PL/SQL Packages, Procedures , Functions , Triggers , Views and Exception handling for retrieving, manipulating, checking complex data sets in Oracle .
  • Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.
  • Experience in Oracle Supplied Packages, Dynamic SQL, Records and PL/SQL tables.
  • Designed application framework and developed Oracle APEX Application.
  • Involved in Migrating Data from legacy application to Oracle Apex environment.
  • Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
  • Collaborate with Oracle Support to provide solutions when functional and technical bugs are encountered.
  • Knowledge 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.
  • Good knowledge on Oracle Forms and reports.
  • Good Experience in MYSQL ETL Tool SSIS, SSRS.
  • Identifying Adhoc reports which have been requested frequently by business users.
  • Created/Maintained clustered/non clustered Indexes on columns for fast and efficient reporting process.
  • 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.
  • Strong SQL Server DDL, DML skills with expertise in writing efficient queries and troubleshooting complex queries.
  • Proficient in Data Analysis, Data Validation, Data Lineage Data Cleansing, Data Verification and identifying data mismatch in data loading process.
  • Reviewed the deliverables from offshore and communicated changes to developers.
  • Responsible for developing interactive Reports, data entry forms, hypertext linked reports using Oracle APEX 5.0.
  • 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 in 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.
  • Creating business users’ reports based on their requirements and adding functionalities to new and existing Apex Application.
  • Extensively worked with third party database tools like TOAD & PL/SQL Developer
  • Experience in design and development of both OLTP and OLAP applications

TECHNICAL SKILLS

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

Scripting Technologies: SQL, UNIX and Python.

Languages: C, PL/SQL, HTML, Core Java, CSS, XML, .net.

Tools: SQL Developer, SSIS, TOAD, SQL plus, SQL Loader, Explain Plan Oracle Apex 3.2, Oracle Apex 4.2, Oracle Apex 5.0, Oracle Apex 5.1.1.

Operation systems: Windows &LINUX

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

Methodologies: AGILE

PROFESSIONAL EXPERIENCE

Confidential, Ashburn, VA

Oracle PL/SQL Developer

Responsibilities:

  • Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
  • Extensive back-end programming, hands on experience developing applications using oracle PL/SQL.
  • Hands on experience in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Object types and Collections.
  • Expertise in writing Complex Stored Procedures, Packages, and Functions using PL/SQL for the batch framework.
  • Designed and developed several Apex batches and triggers on standard as well as custom objects.
  • Expertise in writing SQL Queries (Sub queries and Join conditions), PL/SQL subprograms and Query Level Performance tuning.
  • Strong understanding of end-to-end project management, SDLC methodologies of Waterfall and Agile.
  • Experience with data migration using BULKCOLLECT.
  • Involved in the continuous enhancements and fixing of production problems. Co-ordinate and delegated work to Offshore team.
  • Analyzed data integrity problems and aided assistance in giving solutions.
  • Created and manipulated stored procedures, functions, packages, and triggers using TOAD.
  • Experience in SQL performance tuning using Cost-Based Optimization (CBO).
  • Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
  • Ability to write complex SQL queries for reporting purpose.
  • Debugging APEX applications and PLSQL codes.
  • Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
  • Wrote Loader scripts using SQL Loader/External tables to load large tables.
  • Creating business users reports based on their requirements and adding functionalities to new and existing APEX Applications.
  • Creating indexes on tables to improve the performance by eliminating the Full Table Scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
  • Developed Stored Procedures, Functions, Packages and SQL Triggers using PL/SQL.
  • Generated complex stored procedures and functions for better performance and flexibility.
  • Good knowledge on OLAP systems.
  • Tuned database by tuning queries, creating tables, indexes, Materialized Views, Partitioning Indexes and Re-writing queries using an optimized path and gathering necessary statistics on objects using EXPLAIN PLAN.
  • Unit testing the PL/SQL code. Made necessary database structure changes for OLTP as per business requirements.
  • Generated SQL and PL/SQL scripts to create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
  • Writing SQL queries to generate reports and schedule them to be triggered by crontab.
  • Supported integration and end user testing with efficient defect management process.

Environment: Oracle 12c, Agile, SQL, PL/SQL, SQL Developer, XML, Toad, JIRA, GIT, UNIX, Oracle apex 5.1.1 Oracle 18.2

Confidential, Louisville, KY

Oracle PLSQL/Apex 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.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
  • Good knowledge on OLAP systems.
  • Wrote Shell Scripts for Data loading and DDL Scripts, Used PLSQL Stored Procedures, Packages, Database Triggers, SQL and Oracle Utilities in this development process time.

    Developed Unix Shell Scripts for scheduling the jobs and created pre and post session commands

  • 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 with Performance Tuning for Oracle RDBMS using Explain Plan.
  • 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.
  • Generated SQL and PL/SQL scripts to create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
  • 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, ETL, Oracle 11g,12c, Agile, UNIX, SQL, PL/SQL, SQL Developer, HTML, CSS, JavaScript, AJAX, XML.

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.
  • Strong Oracle, PLSQL, SQL*Loader, Informatics ETL, UNIX, Shell scripting.
  • 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.
  • Analyzes and resolves complex technical issues for Production Support of Oracle databases and PL/SQL in support of ETL batch processes .
  • 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.
  • Wrote Shell Scripts for Data loading and DDL Scripts.
  • 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 using SQL*Loader .
  • Utilize Dynamic T-SQL within functions, stored procedures, views, and tables.
  • Extensively worked with third party database tools like TOAD & PL/SQL Developer.
  • Experience in design and development of both OLTP and OLAP application.
  • Experience in Database design using Normalization 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, ETL, Oracle 11g, SQL, PL/SQL, SQL Developer, UNIX,SVN, HTML, CSS, JavaScript, AJAX.

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.
  • 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
  • Involved in writing low-level specifications for screens designed

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

Hire Now