PROFESSIONAL SUMMAMRY

• Around Seven years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Expert in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD,SQL Developer.
• Strong experience in Data warehouse concepts, ETL, Informatica.
• Hands on with Logical and Physical Data Modeling.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based)
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables and Exception Handling.
• Developed Materialized views for faster retrieval of Data
• Created Partition Tables for large tables.
• 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 Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB,UTL_FILE
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Cursor, External Tables, Collections.
• Experience with Data flow diagrams, Data dictionary and Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Dynamic SQL, Collections and Exception handling
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features, such as Query Optimizer, Execution Plans and Indexes ,Pipelined tabled functions for faster execution
• Hands on experience with Oracle forms and reports
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan, HINTS.
• Experienced in ETL techniques and Analysis and Reporting
• Expertise in developing Unix Shell Scripts.
• Good knowledge on Informatica 8.6.0
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Operating Systems : DOS, Microsoft Windows 9X, NT/2000/2003, UNIX, LINUX
Languages : PL/SQL, HTML, UNIX Shell Scripting, C and C++, JavaScript 
Databases : Oracle 8i/9i/10g, MSSQL
ETL Tools : Informatica 8.6 
RDBMS : Oracle 10g/ 9i/8i (SQL, PL/SQL, Stored Procedures, Triggers),Sql server 2008
Testing Tools : Win runner, QTP.

EDUCATION

• Bachelor of Engineering

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA October 2009 - Present 
Senior Oracle PL/SQL Developer

Confidential is the leading provider of legal and GRC management solutions for corporate legal departments, staff counsel, and government agencies. Mitratech’s TeamConnect products allow organizations to increase competitiveness by proactively managing enterprise risk and improving performance.

• TeamConnect- TeamConnect is a J2EE platform built on a foundation of open standards. Its Java API and Web Services interface allow for easy integration with corporate systems and customization of business logic.
• Collaborati – Electronic billing facilitates the electronic delivery of an invoice from a vendor to a client.

Responsibilities

• Involved in requirement gathering, High level and Detail level design documentation
• Developed, modified, and optimized complex queries for data retrieval and modification.
• Developed stored procedures and packages which will help to execute the business logic.
• Translated user requirements into data flows, detail technical specifications and database requirements
• Worked on various Joins such as inner, self, outer joins and full outer joins.
• Created and executed PL/SQL objects such as triggers and worked on issues relating to Triggers while loading data into Database tables.
• Implemented the ETL operation Using Pentaho to accomplish the task of loading the values into Database Tables.
• Implemented PL/SQL objects such as packages to extract from various sources i. e. Flat Files, XML Files, Data Base Tables and then ETL process, provide data for reporting.
• Wrote complex procedures and functions for loading from staging area to Database.
• Created tables, schemas, views, packages, stored procedures, triggers, functions etc using TOAD.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges
• Extensively used cursors to process the migration by developing unique code values that facilitate mapping of data.
• Created triggers and worked around issues of triggers such as Mutating Tables.
• Developed PL/SQL packages that implement the part of mapping of data to the Database tables.
• Extensively worked on Materialized Views that help for the faster retrieval of information
• Created indexes such as Bitmap and Binary tree, function based indexes to improvise the performance and tuned them.
• Worked on Inline views and correlated sub queries to improvise the performance of the queries.
• Good knowledge of key Oracle performance-related features, such ascost-based optimizer, hints, indexes, clusters, partitioning, temporary tables
• Used advanced PLSQL concepts like Bulk collect, PLSQL tables and Dynamic SQL for DML operations for better performance
• Experience with Business Objects, Universe.
• Extensively used performance tuning for SQL queries which take long time
• Performed unit testing and moving it from development to production.

Environment
Oracle 10g, Pentaho, Toad 9.1, SQL Developer, Explain Plan,FTP, MS excel , Tomcat 6.0, SQL Server 2005, XML,SOAP,Webservices

Confidential , TX Sep 2008 – Oct 2009
Oracle PL/ SQL Developer

Responsibilities

• Interacted with Business Analysts and Users in requirement gathering Built complex queries using SQL and wrote stored procedures using PL/SQL
• Worked in Data modeling, Data mapping and Data flow
• Involved in Requirement gathering and writing Functional and Technical documents
• Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements
• Created materialized views, Inline Views & normal views where business requirements needed
• Tune the SQL queries and complex procedures to improve performance
• Created database triggers for data security & Consistency
• Experience in writing procedures, functions and packages for new requirements.
• Usedadvanced PL/SQLconcepts likeBulk collect, PL/SQL tablesand Dynamic SQL for DML operations for better performance
• Developed PL/SQL and web PL/SQL stored procedures
• Implemented Advanced PL/SQL Concepts for better performance of PL/SQL Applications
• Wrote PL/SQL backed stored procedures for database access and tuned them efficiently.
• Worked in Production Support Environment testing for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Extensively used EXPLAIN PLAN utility to leverage SQL queries.
• Performance tuning of Oracle Databases and User applications.
• Involved in Unit Testing for the application.
• Involved in solving day-to-day problems, giving support to the users.
• Provided 24/7 on call production support.

Environment
Oracle 10g, TOAD, PL/SQL, Explain Plan, TKProf, Informatica 8.6.0, UNIX, HTML

Confidential, New York May 2007 – Aug 2008
Application Developer

Responsibilities:

• Involved in gathering the requirements by conducting meetings and prepared the technical design documents.
• Created Sql loader scripts for loading the data from a flat file to Site Manager and SLIM.
• Involved in creating Packages, Triggers, Functions, and Procedures
• Involved in writing data Conversion scripts.
• Developed UNIX shell scripts for data loading and extraction.
• Involved in writing complex SQL queries to extract data from various source tables.
• Involved in Query tuning and used hints to improve performance.
• Involved in writing PL/SQL programs fordata conversions using the oracle built in packages like UTL_FILE,DBMS_SQL
• Created materialized views and refreshed using the DBMS_MVIEW package.

Environment: ORACLE 10g, SQL* Plus, UNIX, Toad 9.0.1, Windows XP, SQL * Loader.

Confidential Sep 2005 – April 2007
SQL Developer

Responsibilities

• Responsible for systems analysis, development, maintenance and support of Oracle based Data Warehouse Applications.
• Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections
• Established connectivity to the applications based on Oracle for ETL.
• Responsible for the performance tuning tasks of the database.
• Extensively used explain plans to get the statistical data for the performance tuning of the SQL queries and Stored Procedures.
• Responsible for back end stored procedures development using PL/SQL predefined procedures
• Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL*Loader and PL/SQL.
• Designed and developed Oracle PL/SQL and Shell Scripts.
• Designed and developed an application to automate tracking of data feeds, validate data and check errors in the data files before uploading data to the data warehouse

Environment : Oracle 8i, PL/SQL, Oracle Forms and Reports, SQL Developer, Windows 2000.

Confidential May 2004 - Aug 2005
Developer

Responsibilities

• Modeling the business requirements
• Diagrammatic representation of business processes
• Define and represent entities, functions and flows between the entities
• Using the transformers to generate initial designs
• Re-visit the proposed/implemented designs to improvise/change existing business requirements.
• Developed PL/SQL procedures & functions to support the reports by retrieving the data from the data warehousing application.
• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.
• Enforced database integrity using primary keys and foreign keys.
• Created PL/SQL functions to facilitate business functions and calculations

Environment : Oracle 7.3.4, TOAD, Windows NT