SUMMARY

• Over 5+ years of programming experience as an OraclePL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Expertise in Oracle SQL,PL/SQL
• Expertise in creating and modifying database objects like Tables, Indexes, Views, Triggers, Synonyms, Sequences, and Materialized views using SQL and PL/SQL.
• Expert level experience onPL/SQLthat includes Cursors, Ref - cursors, Procedures, Functions and Packages, Object, Partitioned Tables, and Table Indexing.
• Expertise in using user defined and system defined Exceptions for Error handling.
• Experience in creating composite data types and collections.
• Experience in using tools likeSQL* Plus,SQLAssistant,PL/SQLdeveloperand TOAD.
• Experienced in writing UNIX shell scripts for automating the process of data loading& Batch Processing.
• Experienced in writingSQLstatements,PL/SQLcode for the database objects such as tables, views, indexes, sequences, procedures, functions, packages, and triggers.
• Expertise in Optimizing Database performance, Hints, Indexing, Materialized View, Partitioning, Parallel processing, pipelining, managing locking scenarios for multiple users
• Good experience in data modeling using Erwin Data Modeler: Creating entities, relationships, sub-types, schemas and ERD to database schemas.
• Good experience in Software Engineering Processes (Agile and Waterfall Methodologies). Development of software project based on users' requirements and meeting deadlines to satisfy users' need.
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques.
• Developed and maintained system documents, including technical specifications, data mapping, program logic and flowcharts.
• Worked in analyzing and Implementing the ETL architecture using ETL Informatica,SQL* Loader,PL/SQL.
• Experience in DML, DDL, and TCL operations.
• Extensive experience in Database query tuning, Performance tuning of Reports.
• 24/7 Production Database Support & Maintenance.
• Experience in Migration and Upgrade of databases.
• Expert knowledge with Microsoft Excel, Power Point, Word.
• Excellent analytical and problem-solving skills and can work independently.
• Excellent Communication and responsible team player.

TECHNICAL SKILLS

Databases: Oracle11g, 10g, 9i, MSSQLServer

Languages: SQL,PL/SQL, T-SQL, Java, HTML, C#, .NET

Operating Systems: Windows, Linux, Unix, Shell

DB Dev. Tools: TOAD,SQLDeveloper,SQL*Plus, Informatica Power Center,SQLLoader, Warehouse Builder, Erwin

PROFESSIONAL EXPERIENCE

Oracle PL SQL Developer

Confidential

Responsibilities:

• Created complex functions, stored procedures, and packages by usingPL/SQL.
• Responsible for working with user groups, analyzing reported problems, performing root cause analysis and presenting alternatives to correct the problem.
• Developed back end interfaces usingPL/SQLpackages, stored procedures, functions, Object Types, Pipelined functions,Oraclequeues and used Collections, Bulk Collects to improve performance by minimizing the number of context switches between thePL/SQLandSQLengines.
• Hands on experience in developingpl/sql - stored procedures, functions, packages, proc-c programming on Unix platform, shell scripting based applications.
• Wrote complexSQLqueries using Joins, sub queries and inline views to retrieve data from the database for reporting and analytics in <>
• Created Cursors, Collections, and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Worked on various tables to create Indexes to improve query performance. Also, worked on partitioning large tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
• Worked on various reports like formulary analysis, UM criteria, UM audit, formulary draft status.
• Developed technical system documentation.
• Performed unit testing and supported integration testing and end user testing.
• Extensively worked on production issues with effective defect management.
• Proactively tunedSQLqueries and performed refinement of the database design leading to significant improvement of system response time and efficiency.

Environment: SQL,PL/SQL,Oracle10g/11g, Toad,SQL*Plus,SQL*Loader, MS Office, Windows XP,OracleReports 10g,OracleForms 10g.

Oracle PL SQL Developer

Confidential

Responsibilities:

• Worked with various functional experts to implement their functional knowledge into working procedures.
• Developed application and database triggers, functions, procedures, and packages inPL/SQL,Oracle11g as back - end.
• Creation of database objects like tables, views, procedures, packages usingOracletools like SQLLoader,SQL* Plus andPL/SQL.
• Created variousSQLandPL/SQLscripts for verification of the required functionalities.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), Table Partitioning and Error Handling.
• Worked on optimizing existing procedures and functions usingPL/SQL.
• Worked on User Exit, DynamicSQLandPL/SQLblock inPL/SQL.
• Created various Database triggers usingPL/SQL.
• Have converted old data from Flat files toOracledatabase UsingSQL* Loader.
• Wrote various kinds ofSQLqueries involving Correlated Sub queries, UNION, Inner and Outer Joins
• Developed UNIX Shell Scripts and PLSQL procedures to import and export data.

Environment: SQL,PL/SQL, UNIX Shell Scripting,Oracle10g/11g, Toad,SQL*Plus,SQL*Loader, PUTTY, MS Office, Windows XP,OracleReports 10g,OracleForms 10g.

Senior Oracle PL/SQL Developer

Confidential

Responsibilities:

• Strong experience with Very Large Databases, over 8 terabytes.
• Database developing usingOracle11g and UNIX shell script.
• Responsible in requirements gathering, analysis, design and development of any enhancements in the application.
• Understanding the requirements and carrying out impact analysis
• Coded complexSQLqueries to retrieve data from the database depending on the need.
• Designed and developed data loading processes usingPL/SQLand UNIX Shell scripts.
• Created database objects like tables, views, indexes and sequences.
• Responsible for the design, construction, unit test, code review and bug fix.
• Participated in Functional Testing and Unit Testing.
• Creating data mapping documents, technical documents as well as QA/production release notes.
• Use and maintain all version of codes in PVCS.
• Wrote complex functions and stored procedures to populate time dimension values with complex logic.

Environment: Oracle11g, TOAD forOracle, Netezza, Aginity Workbench for Netezza, Putty, UNIX, PVCS Version Manager, SBM, MS Communicator

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Developed variousPL/SQLobjects like procedures, functions, packages, Cursors, pipeline functions and triggers in accordance with the business needs.
• Created database objects like tables, views, synonyms, indexes, views, materialized views and sequences.
• Define and represent entities, functions and flows between the entities.
• Participated in analyzing the requirements for the logical and physical design of the database.
• Knowledge of Normalization, Data Warehousing, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.
• Loading data into test warehouse for the business analyst to perform QA testing usingSQLLoader utility and Data pump utility.
• Performed exception handling for data that did not conform to the required format.
• Implemented purging techniques on the data which is not required by the clients.ImplementedPL/SQLscripts in accordance with the necessary Business rules and procedures.
• OptimizedSQLstatements andPL/SQLblocks by usingOracleHints, Explain plans, profiling, collecting statistics and Trace sessions for Cost based Optimization.

Environment:, Oracle10g,PL/SQL,OracleFMW, xml, .Net, Visio, UNIX Shell scripts, SVN, Toad,SQLDeveloper, HP Quality Center,SQL*Loader, Import Export.