We provide IT Staff Augmentation Services!

Sr. Oracle Pl/sql Developer Resume

2.00 Rating

Nashville, TN

PROFESSIONAL SUMMARY:

  • Over 8 years of Professional Experience as an ORACLE PL/SQL Developer in analysis, design and implementation of applications in different domains.
  • Extensive experience in Client - Server application development using Oracle 11g/10g/9i/8i.
  • Strong experience in making use ofTOAD, SQL *PLUS, SQL *LOADER and SQL Navigator.
  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Experience with Data flow diagrams, dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
  • Effectively made use ofTable Functions, Indexes, Table Partitioning,Collections,Analytical functions, Materialized Views,Query Re-WriteandTransportable table spaces.
  • Strong experience inData warehouse concepts, ETL.
  • Extensive experience in developing complex database objects likeStored Procedures, Functions, Packages and Triggers using PL/SQL.
  • Experienced in developingmaterialized viewsfor data replication in distributed environments.
  • Excellent technical and analytical skills with clear understanding of design goals of ER modeling forOLTPand dimension modeling forOLAP.
  • Experience inOracle suppliedpackages, Dynamic SQL, RecordsandPL/SQL Tables.
  • Strong experience in partitioning tables using partition techniques to increase performance.
  • Experience with Oracle Supplied Packages such asDBMS SQL, DBMS JOBandUTL FILE.
  • Expertise in Communicating with theClient to gather the requirements.
  • Expertise in maintaining and updating databases.
  • Proficient and highly skilled in database debugging skills like performing reverse engineering in validating database results set like row counts and validation of data with source systems.
  • Experienced in implementingdata governance standards in handling schema objects of database by reviewing with database architecture, business analysts and data governance team.
  • Experienced in database performance techniques like partitioning the tables, which have frequent inserts, updates and deletes to reduce the contention and to improve the performance.
  • Worked extensively onRef Cursor, External TablesandCollections.
  • Expertise inDynamic SQL, CollectionsandException handling.
  • Strong experience of key Oracle performance related features such asQuery Optimizer, Execution PlansandIndexes.
  • Proficient in implementing Autonomous Transactions and Exception Handling in a well-structured manner.
  • Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery whenever needed.
  • Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as Explain Plan and TKPROF.
  • Experience in advanced PL/SQL concepts like BULK COLLECT and FORALL.
  • Proficient in modifying existing oracle forms and creating new forms. Design and developed around 80+ forms for an entire module.
  • Expertise in handling deadlock issues during the application processing.
  • Ability to work efficiently in both independent and team environments.
  • Ability to rapidly learn new concepts with excellent interpersonal and problem solving skills.
  • Ability to work in Multi-Platform Environments like Windows and UNIX.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, UNIX Scripting, HTML, XML, PYTHON.ETL Tools Informatica, SAP Business Objects DataIntegrator.

Databases: Oracle 11g/10g/9i/8i,Microsoft SQL Server.

Operating Systems: Windows XP/ Windows 7, UNIX.

Database Tools: TOAD, SQL *LOADER, SQL *PLUS, SQL NAVIGATOR.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle PL/SQL Developer

Nashville, TN

Responsibilities:

  • Participating in Client BA meetings to gather the business requirements and analyzing the requirements by understanding the existing system effectively.
  • Involved in the analysis, design, coding and testing of the application.
  • Created tables, indexes and Materialized views and also database triggers for data integrity maintainability.
  • Performing full analysis to divest the unnecessary DB Schemas/Objects and to make sure that there is no impact to the up-stream and down-stream systems/links.
  • Involved in writing Technical and Functional Design Documents.
  • Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions etc.
  • Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
  • Performing data load through different techniques like bulk collect, SQL Loader and External Tables.
  • Involved in writing/modifying the triggers as per the requirements.
  • Controlling the logical flow using the triggers for different links.
  • Involved in development and performing testing with different sets of data and documenting the results for client review.
  • Identifying the root cause for any code failure and maintaining effective documentation for that for future .
  • Performing testing on Pre-Prod environment to analyze the performance issues of the newly written or modified queries.
  • Used UTL FILE built-in package to generate files as per the requirement.
  • Conducted extensive performance tuning using TKPROF and pipelined table functions.
  • Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.
  • Responsible for troubleshooting the errors that occurred when the production group hit a roadblock.
  • Involved in the continuous enhancements and fixing of production problems.

Confidential - Oracle Developer

Raleigh, NC

Responsibilities:

  • Interacted with Business users to understand the expectations of the system against documented requirements.
  • Fast paced development Involving daily scrums and team meetings based on the issues.
  • Created master and transaction tables using the functional requirements.
  • Designed various key database schemas as required.
  • Created several complex Oracle PL/SQL packages for business activities using Oracle collection objects.
  • Used dbms jobs, dbms scheduler to schedule the oracle jobs in a sequential order to process several programs in a single go.
  • Developed several automation scripts to move data between staging area and other schemas related to the application.
  • Involved in creation of various indexes on relational tables, which are, BTREE, BITMAP, FUNCTION BASED.
  • Used various database DML triggers using PRAGMA AUTONOMOUS technique.
  • Worked in several UNIX scripts in implementing of Oracle automated program calls.
  • Involved in various data loading techniques using SQL LOADER, UTL FILE and EXTERNAL TABLES.
  • Implemented various OLTP transactions using SQL/PLSQL.
  • Worked on ASCII SQL based on specific requirements.
  • Extensively used USER and DEFINER rights to optimize code reuse from various schemas.
  • Rule based and cost based optimization.

Confidential - PL/SQLDeveloper

Franklin Lakes, NJ

Responsibilities:

  • Developed PL/SQL procedures to generate flat files.
  • Developed packages, procedures with BULK COLLECT, associative arrays, temporary tables and VARRAYS to improve performance and efficiency.
  • Extensively developed SQL*Loader and PL/SQL scripts to load data from flat file to Oracle Applications interface tables.
  • SQL Query Tuning, Data conversion from legacy system to Oracle Database, PL/SQL procedures and functions were written to validate the data and load into staging tables.
  • Used UTL FILE to validate data before loading to Interface tables.
  • Worked with Interfaces and Data Conversions.
  • Good knowledge of EDI transferred the transactional data to Japan on daily basis and loaded data into GERS (point of sales) system.
  • Involved in automating process using UNIX.
  • Involved in Unit Testing and Integration Testing.

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Analyzed the business requirements for the enhancements needed in the contract Administration application and related policy modules.
  • Documented the detailed requirements and prepared DLD for the new enhancements.
  • Performed several DDL, DML and TCL operations.
  • Created huge database packages with related functions and procedures.
  • Created views by joining multiple cash flow tables to show output as a report to the user.
  • Extensive PL/SQL programming including Development of new backend packages, procedures and functions to in advanced modules.
  • Worked on BULK COLLECT for bulk loading the data into various transaction tables.
  • Used UTL FILE to load the data into oracle tables from FLAT, CSV and Text files.
  • Added database triggers to some history tables of the database.
  • Used file handling in Oracle to read and write into files associated with the modules.
  • Refresh the development and test databases using export/import utilities.
  • Provided 24*7 on call support to production environment.
  • Implemented various automated UNIX shell scripts to invoke pl/sql anonymous blocks, Stored PROEDURES/FUNCTIONS/PACKAGES using SQL PLUS session in silent mode.
  • Worked on inline and correlated sub queries based on business context.
  • Implemented various customized Oracle reports using different techniques in Oracle sql/pl-sql.
  • Extensive and in depth analysis of the problem tickets to dig out the root cause for the problems.
  • Involved in Impact analysis of the defects to the associated functionalities and modules in the Production environment.

Confidential - Database Developer

Responsibilities:

  • Prepared program Specification for the development of PL/SQL procedures and functions.
  • Created Custom Staging Tables to handle import data
  • Created custom triggers, stored procedures, packages and functions to populate different database
  • Developed SQL* loader scripts to load data in the custom tables
  • Run Batch files for loading database tables from flat files using SQL*loader
  • Created UNIX Shell Scripts for automating the execution process
  • Developed PL /SQL code for updating payment terms
  • Created indexes on tables and Optimizing Stored Procedure queries
  • Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions / enhancement on oracle application
  • Created Indexes and partitioned the tables to improve the performance of the query
  • Involved in preparing documentation and user support documents
  • Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

We'd love your feedback!