We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

3.00/5 (Submit Your Rating)

Brooklyn, NY


  • 8 years of experience in IT industry with emphasis on Analysis, Design, Development, Implementation and Management of projects using Oracle (Sql, PL/SQL).
  • 7 years of experience working with Oracle 9i/10g including PL/SQL programming.
  • Solid experience in translating business requirements into creation of Database Objects.
  • Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
  • Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.
  • Prepared BRS (Business Requirement Specifications) document that gives the detailed information about the requirements.
  • Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS.
  • Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries
  • Proficient in tuning queries used in the application.
  • Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
  • Experience in advanced PL/SQL concepts like Bulk collect and forall.
  • Expertise in Dynamic SQL, Records, Arrays and Exception Handling.
  • Very Good experience with UNIX Cron Jobs, Batch Processing with highly complex data model
  • Experience in understanding complicated performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
  • Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
  • Possess excellent oral / written communication and interpersonal skills.
  • Good ability to quickly grasp and master new concepts and technologies.
  • Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.
  • Significant experience in 24/7 Production Environment Support.


  • Oracle 11g/10g/9i/8i, Toad for Oracle Expert 12
  • Ultra Edit Professional Text/HEX Editor 20, SQL*Plus
  • Microsoft Visual SourceSafe, Microsoft Silverlight
  • Mantis Bug Tracker, TFS, Windows Vista/NT/XP/7
  • UNIX with Shell Scripting, Oracle Developer Suit
  • Oracle Enterprise Manager, Developer 2000
  • Oracle Discoverer, SQL*PLUS, Toad 8.6/8.5/6.0
  • SQL, TSQL, PL/SQL, XML,HTML,C/C#/C++, Borland C++ Builder 5
  • JAVA, ODBC/JDBC, CRM,Putty, Erwin 4.1/4.0/3.5, MS Visio, Hudson
  • Crystal Reports, Oracle Forms and Reports 9i/6i, MS Word, Excel, Access, Winmerge, Win SCP


Confidential, Brooklyn, NY

Oracle PL/SQL Developer


  • Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
  • Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
  • Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
  • Used SQL loader to load the data from the files provided by the interfacing applications.
  • Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functionsas part of Project/Application requirements.
  • Created partitioned tables and partitioned indexes to improve the performance of the applications.
  • Wrote PL/SQL Database triggers to implement the business rules in the application.
  • Created external tables to handle huge volumes of data which is not used frequently.
  • Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
  • Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language for the top management for decision making.
  • Implemented all modules logic by using Triggers and Integrity Constraints.
  • Good understanding of database objects and ability to triage issues.
  • Involved in PL/SQL code review and modification for the development of new requirements.
  • Created materialized views required for the application.

Environment: C++, UNIX Shell Scripting, Forms, PL/SQL, Oracle 10g, 11g, TFS

Confidential, Lenexa, KS

Oracle PL/SQL Developer


  • Worked with BA to collect and document database design requirements and do data modeling with DB architect using Erwin.
  • Implement the back end changes in existing product and in designing the database by gathering and understanding requirements from Business / System Analysts.
  • Analyzed the functional specs provided by the data architect and created technical specs for all the projects.
  • Created and modified Reports using Crystal, Business Objects and Discoverer as per the business requirements.
  • Defined relationships using primary keys and foreign keys for the entities and normalized the entities.
  • Used BULK COLLECT, BULK INSERT and FORALL to decrease query execution time.
  • Reproduce Oracle schema objects includes tables, temporary tables, views, indexes, triggers and procedures, based on customer requirement.
  • Created test cases and test reports and worked with QA team to validate the data and scenarios.
  • Worked on various backend Procedures and Functions using PL/SQL.
  • Troubleshooted performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan.
  • Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
  • Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
  • Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
  • Involved in Unit Testing Stored Procedures and Functions.
  • Development of C modules for activation, deactivation and modification of these plans in Clarify Front End
  • Created SQL*Loader scripts to load data into the temporary staging tables.
  • Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
  • Used TOAD, PL/SQL developer tools for faster application design and developments
  • Developed procedures using Dynamic SQL.
  • Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
  • Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
  • Created Materialized Views and partitioning tables for performance reasons.
  • Resolving the issues on priority basis.
  • Responsible for Analyzing and Implementing the Change Requests.
  • Involved in handling the changes in compiling scripts according to the database changes.

Environment: UNIX shell scripting, Oracle 10g, PL/SQL, Clarify, Oracle 11g, Oracle developer 11g, Oracle EBS, ERP R12, Oracle Enterprise Manager, MS SQL server management studio 2008, Toad for Oracle 9.0, PL/SQL, Erwin.

Confidential, Plymouth, MI

Database Developer


  • Developed stored procedures to extract the data from different sources and load it into data warehouse.
  • Involved in creating detailed Functional Documentation which includes all Business requirements and Technical specifications.
  • Used Oracle PL/SQL for implementing business rules and do performance tuning procedures.
  • Created data mapping files for the data coming from different web services.
  • Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
  • Developed procedures using Dynamic SQL.
  • Worked for designing Logical and Physical data models for Master Data and Transactional Data. knowledge and experience in structured systems analysis and design techniques
  • Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
  • Worked with ETL team and architect to build data model for staging area.
  • Prepare the Mapping document which details out the mapping of source to the target data model with application of business rules.
  • Importing and exporting the data into multiple environments.
  • Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
  • Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database.
  • Involved in handling the changes in compiling scripts according to the database changes
  • Developed reports using complex queries as per client request as a part of production support
  • Performed SQL tuning using Explain Plan, Hints and indexes
  • Responsible for performing code reviews
  • Created SQL*Loader scripts to load data into temporary staging tables
  • Utilized SQL*Loader to load flat files into database tables

Environment: Oracle 10g, SQL Server Reports 10g, SQL, PL/SQL, Toad, Oracle RDBMS, SQL Developer.


Systems Engineer,


  • Created several new interfaces and enhanced the existing interfaces to adapt to a complicated Warehouse management system (WMS), implemented using SQL, PL/SQL, Unix, Pro*C and shell scripting.
  • Implemented stored procedures, functions, triggers, views and other application database code objects using SQL, PL/SQL.
  • Improved the efficiency of Interface jobs by tuning the PL/SQL queries, Oracle SGA, troubleshooting of various slow performances database tables, indexes and memory.
  • Developed complex SQL queries with inline queries and sub queries for faster data retrieval from multiple tables and used cursors and collections to access large data.
  • Extensively used SQL*LOADER for data loading, used Export and Import Utilities for Logical backups.
  • Created a new technical system which accepts and process XML messages from WMS using J2EE, Spring & iBATIS.
  • Automated generation and publication of reports for Process Improvement, implemented using JAVA, JSP.
  • Created and modified shell scripts according to the project requirements for scheduler.
  • Worked in all phases of SDLC waterfall environment.
  • Prepared test strategy preparation, test case creation, test execution, bug tracking and preparing technical documents for the same.
  • Involved with Component Integration Testing, System Testing, Load Testing and Regression Testing
  • Developed testing tools in C/C++ during User Acceptance Testing phase.
  • Responsible for the maintenance of Version Description Document (VDD) to track the control versions of software to be deployed in production environment.
  • Developed tools to automate generation and publication of reports in actual production environment.
  • Scheduled and Monitored Control-M jobs, Created Batch Jobs and Scheduler jobs in Unix
  • Involved with code deployment in Production Environment.
  • Provided offshore support for technical issues as part of Production support.
  • Involved in gathering and analyzing the requirements and creating Functional & Technical specifications documents.
  • Performed Functional and Technical Analysis of PL/SQL packages for interactions between client and the data warehouse.
  • Developed High Level Design for developing new interfaces for the back end of the inventory distribution system by working with various stakeholders, developers and production teams.
  • Designed and developed a Data Model for Warehouse-Store inventory distribution. Developed ER Diagrams, Data flow diagrams based on the requirement specification.
  • Supported a 3-member team that designed and created low level design for the inventory system.
  • Documented Solution Architecture Design for transferring the inventory from Mini-Load system to Bulk Areas.
  • Involved in constant interaction with clients during implementation phase and analyzed new business requirements, enhancements and change requests and prepared change analysis and gap analysis documents.
  • Responsible for Data Migration activities like extracting, transforming, migrating (ETL) and validating data from one Distribution Centre to another.
  • Developed end to end implementation plan by coordinating with various interface teams.
  • Re-instantiated the required schemas from the phased out data base to the new data base, synchronized the schemas and altered the data model.


Oracle Developer


  • Developed functions, procedures and packages as re-usable application programs that translated complex business logic using PL/SQL and SQL to transform data between source staging area to target staging area. Extensively used PL/SQL tables, cursors and exception handling.
  • Created database objects like Tables, Sequence, Synonyms, Views, and Materialized Views.
  • Involved in developing interactive forms and customization of screens using Oracle Forms.
  • Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
  • Maintenance included enhancing the existing stored programs, forms and reports with additional procedural and non-procedural programming logic to meet complex user requirements and fixing the bugs on priority basis.
  • Importing data from different varieties of sources like flat file, excel file or Oracle dump file into Oracle database source schema tables using SQL*loader.
  • Responsible for creating and maintaining the Table spaces, Users and assigning Roles and Privileges.
  • Developed, Tested and Migrated the Oracle PL/SQL scripts to Production.
  • Worked on tuning the SQL Queries for better performance and troubleshooting development problems.
  • Extensively worked on developing KORN shell scripts for scheduling the jobs using CRONTAB and invoking the procedures through shell scripts.
  • Involved in implementing bug fixes and enhancements within packages, forms, and reports.
  • Responsible for preparing user manuals and quick guides.

Environment: Oracle, Forms, Reports, PL/SQL, SQL Navigator, Oracle Enterprise Manager, Exceed, Humming Bird, JSP, Java Script, HTML

We'd love your feedback!