We provide IT Staff Augmentation Services!

Sr. Oracle Developer Resume

0/5 (Submit Your Rating)



  • 7 years of diversified experience in analysis, design, development, testing and implementation in Oracle Development.
  • Good experience with Oracle RDMS (9i, 10g and 11g) and Proficient working experience in SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers, Indexes and AOL.
  • Good working experience in Reports 6i/9i & Forms 6i for both development and customization of several Reports as per client specifications.
  • Working Knowledge on Unix Shell Scripting with sh, bashes csh and ksh shells.
  • Working in performance oriented environment dealing with Oracle E - Business suite Applications R11i/R12 in doing technical work within its various modules such as the Accounts Receivable (AR), Accounts Payable (AP), Order Management (OM/OE/ONT), General Ledger (GL) & Service Contracts.
  • Worked on RICE Components like Interfaces, Conversions and Extensions.
  • Strong in using tools such as TOAD, SQL Navigator, SQL*Loader, and SQL*Plus.
  • Good experience with version control systems such as CVS, PVCS and tools like Quality Center, Kintana and Client specified custom tools.
  • Thorough understanding of Rational Unified Process (RUP).
  • Good experience in advanced PL/SQL concepts like build in packages DBMS SYSTEM, DBMS OUTPUT etc to achieve commendable improvement in performance.
  • Good experience in web technologies like HTML/DHTML, XML.
  • Expertise in all phases of the Software Development Life Cycle (SDLC) including Analysis, Physical and Logical design, Resource Planning, Code development, Testing, Implementation and Maintenance.
  • Involved into Data Migration from Oracle 8i to 9i & 9i to 10g and extensive hands on Data Extraction and Data Comparison.
  • Extensive development experience with Oracle 10g and 11g database.
  • Have acquired basic knowledge on Oracle Applications Framework (OAF).
  • In addition to excellent technical abilities possesses strong oral and written communication skills, analytical and interpersonal skills.


Programming Languages: SQL, PL/SQL, C, Java

ERP Systems: Oracle E-Business Suite R11i, R12

Database Systems: Oracle 8i/9i/10g/11g, SQL Server 2000/2005, MS access 2005/2008

Developer Tools: SQL Loader, TOAD, Oracle SQL Developer, Oracle JDeveloper, MS VISIO 2007

Operating Systems: Windows 95/98/2000/XP/NT/7, UNIX, RH Linux, Windows Vista, Windows server 2000/2003.

Source control: CVS, PVCS

Scripting/Web technologies: Unix Shell Scripting, XML, JavaScript, HTML/DHTML

GUL Tools and Frameworks: Oracle Reports Builder 10g/9i/6i, Oracle Forms Builder 10g/9i/6i, Crystal reports, Developer 2000 and Oracle Applications Framework.

OS Tools: Putty, FTP/SFTP, WinSCP

Project Management Tools: Adobe works, MS Office Suite 2003/2007


Confidential, Chicago

Sr. Oracle Developer


  • Improved the performance of the application by rewriting the SQL queries.
  • Used Bulk Collect feature to improve performance in stored procedure.
  • Worked on Production Support, attending production calls, troubleshooting the application and resolving bugs.
  • Extracted data from oracle database and spreadsheets and staged into staging tables and applied business logic to load them in the central oracle database.
  • Extensively used Joins, Triggers, Stored Procedures and Functions in Interaction with backend database using PL/SQL.
  • Created procedures to truncate data in the target before the session run.
  • Test case/data preparation, execution and verification of the test results.
  • Used Git for version control and flyways for deploying code into environments.


Confidential, San Jose, CA

Oracle PL/SQL Developer


  • Worked on Analysis, Detailed Design, Development, Testing, Documentation and Technical Requirements for the database applications and procedures as per quarterly and monthly release requirement.
  • Provide timely Production Support by quickly analyzing the root cause and by providing alternatives to resolve issues.
  • Developed API’s, Stored Procedures, Functions and complex Packages and Triggers extensively using PL/SQL to meet business requirements.
  • Involved in month-end and quarter-end activities and generate reports using sql queries.
  • Participated in the design, development and creation of custom reports based on the customer requirements and interacting with the customer for requirement analysis.
  • Designed and developed database objects such as tables, views, synonyms, partitioned tables, indexes, sequences, database links, cursors, functions, procedures and packages and data loading using SQL Loader utility for new/enhance requirements.
  • Developed some of the basic customized OAF pages.
  • Ensure that all deliverables are thoroughly documented and Prepared source to target Data mapping documents, Unit Test case, Unit Test Plan documents
  • Worked on automating process for weekly and daily jobs using UNIX Shell Scripts
  • Developed inbound interfaces by extracting data from different sources like Excel, flat files and loaded in to development database then using API’s and Standard Concurrent programs.
  • Involved in fine-tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features.
  • Created stored Procedures using EXECUTE IMMEDIATE and REF CURSORS (Native Dynamic SQL).
  • Used partitioning and sub partitioning of tables to improve performance.
  • In Oracle Apps, created AOL objects such as Program registering, defining responsibilities, users, request group, Value set, flex-fields, profile options.
  • Developed PL/SQL scripts for Data loading and Data extraction.
  • Worked on writing Data Migration scripts such as PL/SQL procedures/create table scripts to load data successfully from legacy system to new structured schema or in to repository database.
  • Worked on Performance tuning of SQL & PL/SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN, HINTS and TKPROF.
  • Used Bulk Collect, parallel processing, bulk insert feature to improve performance.
  • Developed and maintained scripts for monitoring, troubleshooting and administration of the databases.
  • Debugging and enhancing existing applications by modifying existing packages and to optimize the performance.
  • Extended few reports from Reports 6i to Report 10g.
  • Generated report outputs in the PDF, XML etc formats using Reports 10g.
  • Facilitated easy user interface implementation and consistent data entry into the database by creating Views with Triggers.
  • Created Snapshots and Materialized Views.
  • Utilized TOAD 9.2 for developing all back end database interfaces and objects.
  • Good knowledge of Normalization and Software Development Life Cycle (SDLC).
  • Created and compiled DDL scripts and see the output errors when executing stored DDL.
  • Developed batch programs to load various types of feeds from external sources into the Oracle database using SQL*Loader and PL/SQL procedures.
  • Handled errors using Exceptions like DUP VAL ON INDEX, INVALID NUMBER and CASE NOT FOUND.
  • Developed PL/SQL to process input files and generate output files using UTL FILE utility.
  • Interacted with business analysts to develop modeling techniques and re-structuring strategies
  • Used SQL Loader in Oracle for bulk Data Loading
  • Widely used the parameters facility in UNIX and PL/ SQL to facilitate automation of the processes.
  • Involved in writing automated data loading Shell Scripts which will watch the incoming files and load them automatically and emailif the data load is successful or failure.
  • Developed and tested UNIX shell scripts to call the PL/SQL packages.
  • Unit Test the module and deliver to the QA team.
  • Written complex SQL Scripts in SQL*Plus for data reporting to business and write ad-hoc queries for various customer-reporting requirements.
  • Maintained version control of the code in PVC’s.
  • Migrated setups and code from dev. env to test and from test to production through Kintana.
  • Involved in various stages of testing - code testing, Integration Test, System Test, and UAT and in Go-Live activities and provided instant support for client testing.
  • Created Excel tools to aid data validation, which enabled team members to work more efficiently.
  • Monitored defect tracking activities using Quality Center.
  • Provided KT to fresher’s and mentored junior team-members.
  • Ensured that weekend data loads, month-end & quarter-end processing ran successfully and completely, transparent to user community.
  • Worked with DBAs for performance problems, fix the problem and make recommendations to technical staff to improve performance.

ENVIRONMENT: Oracle 9i/10g/R12, PL/SQL, SQL developer, TOAD, SQL*Plus, Reports 9i/10g, Windows XP/7, UNIX Shell Scripting, MS Office, SQL*Loader, JDeveloper, Oracle Applications

Confidential, Columbus, OH

PL/SQL Developer


  • Involved in migrating the code from one instance to other instance
  • Created database objects such as tables, indexes, synonyms, sequences and views
  • Developed PL/SQL stored procedure, functions and packages for migrating the data from staging instance to repository database
  • Developed SQL scripts to test and validate the information
  • Worked on AOL objects.
  • Implemented complex business rules with the use of integrity constraints and Database Triggers.
  • Responsible for optimizing queries and query tuning using Explain plan and auto trace.
  • Used TOAD to extract and test the data in the database.
  • Modified the code as per standards.
  • Prepared Unit Test Cases and Unit Test Plan documents.
  • Worked on the RFC’s provided by client by delivering them on time.

ENVIRONMENT: Oracle Applications 11i, Oracle 9i, PLSQL, TOAD, SQL developer, Windows XP, SQL *Plus, MS Office, UNIX.

We'd love your feedback!