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.