EXECUTIVE SUMMARY

• 7+ years of experience in IT industry with emphasis on Analysis, Design, Development, Implementation and Management of projects using Oracle (Sql, PL/SQL).
• 5 years of experience working with Oracle 8i/9i/10g including PL/SQL programming.
• Solid experience in translating business requirements into creation of Database Objects.
• Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects – Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.
• Prepared BRS (Business Requirement Specifications) document that gives the detailed information about the requirements.
• Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS.
• Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries
• Proficient in tuning queries used in the application.
• Experience in designing, configuring of console applications in VB.NET
• Highly skilled in Performance tuning – analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
• Experience in advanced PL/SQL concepts like Bulk collect and forall.
• Expertise in Dynamic SQL, Records, Arrays and Exception Handling.
• Very Good experience with UNIX Cron Jobs, Batch Processing with highly complex data model
• Experience in understanding complicated performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
• Possess excellent oral / written communication and interpersonal skills.
• Good ability to quickly grasp and master new concepts and technologies.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.
• Significant experience in 24/7 Production Environment Support.
• Knowledge on Informatica Power Center

TECHNICAL SKILLS

Operating System

DatabasesEnvironments

MS Windows 2000/NT/XP/NT & VISTA, MS DOS and UNIX

Oracle 8i, 9i (9.2.0.5, 9.2.0.6), 10g, 11g

PROFESSIONAL EXPERIENCE
Confidential,Boston, MAJan’2011 –TillDate
Oracle PL/SQL Developer,

Responsibilities:

• Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• Used SQL loader to load the data from the files provided by the interfacing applications.
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Created partitioned tables and partitioned indexes to improve the performance of the applications.
• Designed, developed and customized forms by using Oracle Forms 6i and Reports 6i.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Created external tables to handle huge volumes of data which is not used frequently.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language for the top management for decision making.
• Implemented all modules logic by using Triggers and Integrity Constraints.
• Good understanding of database objects and ability to triage issues.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Created materialized views required for the application.

Environment:
C, C++, UNIX Shell Scripting, Forms , PL/SQL,Oracle 10g,11g.

Confidential,Somerville,NJMarch’2009 – Dec’2010
Oracle PL/SQL Developer,

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Involved in Unit Testing Stored Procedures and Functions.
• Created Materialized Views and partitioning tables for performance reasons.
• Worked on various backend Procedures and Functions using PL/SQL..
• Troubleshooted performance issues and bugs within packages, forms, and reports using dbms_output, Forms debugger, explain plan.
• Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
• Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
• Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
• Development of C modules for activation, deactivation and modification of these plans in Clarify Front End
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Developed procedures using Dynamic SQL..
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• Created Materialized Views and partitioning tables for performance reasons.
• Resolving the issues on priority basis.
• Responsible for Analyzing and Implementingthe Change Requests .
• Involved in handling the changes in compiling scripts according to the database changes.

Environment:

C, C++, UNIX shell scripting, Oracle 10g, PL/SQL, Toad, Clarify

Confidential,Covina, CAMay’2008 –Feb’2009
Oracle PL/SQL Developer,

Responsibilities:

• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions and Triggers.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24 hour production support.
• Developed Korn shell scripts to kick off back end PL/SQL, SQL programs.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Utilized SQL*Loader to load flat files into database tables.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Partitioned tables and indexes for better performance of application
• Contacting Application Team and clients to gather the information for migration. Reviewed architecture.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Involved in handling the changes in compiling scripts according to the database changes.
• Developed reports using complex queries as per client request as a part of production support.
• Provided on call support, solved the user issues and made necessary changes.
• Resolving Production severity Issues in time and meeting the SLA.
• Writing high quality and well documented code according to standards.

Environment:
C, C++, UNIX shell scripting,10g,11g, PL/SQL, Toad, Clarify

Confidential,Plymouth, MISep’2007 – April’2008
Oracle PL/SQL Developer,

Responsibilities:

• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Involved in creating detailed Functional Documentation which includes all Business requirements and Technical specifications.
• Used Oracle PL/SQL for implementing business rules and do performance tuning procedures.
• Created data mapping files for the data coming from different web services.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
• Developed procedures using Dynamic SQL..
• Worked for designing Logical and Physical data models for Master Data and Transactional Data.
• knowledge and experience in structured systems analysis and design techniques
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Worked with ETL team and architect to build data model for staging area.
• Prepare the Mapping document which details out the mapping of source to the target data model with application of business rules.
• Importing and exporting the data into multiple environments.
• Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
• Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database.
• Involved in handling the changes in compiling scripts according to the database changes
• Developed reports using complex queries as per client request as a part of production support
• Performed SQL tuning using Explain Plan, Hints and indexes
• Responsible for performing code reviews
• Created SQL*Loader scripts to load data into temporary staging tables
• Utilized SQL*Loader to load flat files into database tables

Environment:Oracle 10g , SQL Server Reports 10g, SQL, PL/SQL, Toad, Oracle RDBMS,SQL Developer.