Oracle Pl/Sql Developer

Harsha V Employer:

David

(M)- 678-***-**** (**0)

***-****

Email ID: **********@*****.***

*******@***********.***

SUMMARY OF SKILLS:

o Over 5 years of IT experience in System Analysis, Design, Development,

Maintenance and Support using Oracle Database 9i/10g/11g, SQL, PL/SQL,

SQL * Loader, Query Optimization, Performance Tuning, Trouble Shooting

and having experience in Unix, Linux and Windows environment.

o Provided assistance in logical/physical data modeling using ERWIN.

o Experience with multiple RDBMS including Oracle 11g/10g/9i SQL server

2008/2005 databases on UNIX, Linux and Windows enterprise platforms.

o Effectively made use of Table Functions, Indexes, Table Partitioning,

Collections, Analytical functions, Materialized Views, Query Re-Write

and Transportable table spaces.

o Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function

Based).

o Developed Complex database objects like Packages, Stored Procedures,

Triggers, functions and ref cursors using SQL and PL/SQL.

o Experience in creating cursors, composite data types, collections and

exception handling.

o Proficient in working and conceptual knowledge of Oracle Forms 6i/10g

and Oracle Reports 6i.

o Proficient in Oracle tools and utilities such as TOAD, SQL Navigator,

PL/SQL Developer, SQL Developer.

o Experienced in performance tuning using SQL Trace - TKPROF and Explain

Plan.

o Experienced in working with utilities like SQL*Loader, External

Tables, Import, Export to extract and load large volume of data.

o Experience in Oracle supplied packages, Dynamic SQL, Records and

PL/SQL Tables.

o Loaded Data into Oracle Tables using SQL Loader.

o Worked extensively on Ref Cursor, External Tables and Collections.

o Expertise in Dynamic SQL, Collections and Exception handling.

Partitioned large Tables using range partition technique.

o Adept in Oracle performance tuning using Automatic Database

Diagnostics Monitor (ADDM), Automated Workload Repository (AWR),

Active Session History (ASH), Statspack, TKPROF and EXPLAIN PLAN

o Good knowledge of key Oracle performance related features such as

Query Optimizer, Execution Plans and Indexes.

o Developed various Unix Shell Scripts to manipulate data files.

o Experience in migration and conversion from Flat Files/MS Access/SQL-

Server to Oracle using Oracle SQL* Loader

o Hands on experience with tools like Export and Import Utilities.

o Experience in writing Test Plans, Defining Test Cases, Developing and

Maintaining Test scripts.

o Expertise in Unit Testing, Integration, Functional, System,

Performance, Load, Regression Testing and Validation Testing.

TECHNICAL SKILLS:

Databases Oracle 9i/10g/11g, MS Sql Server.

Operating Systems Windows Server 2003/2000/NT, Windows Vista/ XP/98/95,

UNIX, Linux.

Programming& SQL, PL/SQL, UNIX Shell Scripting.

Scripting Languages

Database Tools TOAD 8.5/8.0, SQL-Developer, PL-SQL Developer,

SQL*Plus, SQL*Loader, Import and Export, Informatica.

Database Modeling Erwin r7/r4, MS Visio 2007/2010.

Tools

Tuning Tools TKPROF, EXPLAIN PLAN, Statspack, ADDM, AWR, ASH.

PROFESSIONAL EXPERIENCE:

Project#1

Client Merial, A Sanofi Company, Atlanta, GA

Role Sr. Oracle PL/SQL Developer.

Duration July 2014 to Present.

Environment Oracle 10g, SQL* Plus, SQL * Loader, TOAD, Erwin,

SQL Server 2008, UNIX.

Responsibilities:

o Involved in creating Database Design (Physical and logical) as per

the requirement given by business

o Worked on Erwin Data Modeler for mapping both user-defined and default

data types

o Developed PL/SQL packages, procedures, functions, materialized views,

SQL Scripts and triggers to populate the historic data in the tables

applying business logic

o Worked on sequences, functions, synonyms, indexes, triggers,

packages, stored procedures, roles and granting privileges on OLTP

server.

o Involved in Creation of tables, Partitioning tables, Join

conditions, correlated sub queries, and nested queries, views for

the business application development.

o Created temporary tables and developed SQL*Loader control files to

load the legacy data into the temporary tables.

o Wrote Materialized views and complicated queries using SQL.

o Involved in writing SQL queries (Sub queries and Join conditions),

PL/SQL programming.

o Used the advanced features of PL/SQL like collections, nested

table, array & Dynamic SQL.

o Worked with Oracle Enterprise Manager.

o Wrote SQL sub-queries with join conditions and PL/SQL scripts

o Involved in performance tuning of SQL queries and Created indexes

on tables and optimizing Stored procedure queries

o Design and developed the scripts to create table, views, indexes

and sequence.

o Extensively involved in tuning the queries and applying hints for

faster and better performance of the SQL queries.

o Created the Shell Scripts to automate the execution of the PL/SQL

subprograms.

o Created the test scripts and complex queries to test the timesheet

application and to quality assurance of the data.

o Involved in preparing test plans, unit testing, System integration

testing, implementation and maintenance.

Project 2

Client Lowe's Companies Inc., NC

Role Oracle PL /SQL Consultant.

Duration August 2013 To June 2014.

Environment Oracle 11g, PL/SQL, SQL*Plus, PL/SQL Developer

6.0, Toad 9.1, SQL * Loader, UNIX, Shell Scripts,

Erwin r7, Windows, Linux.

Responsibilities:

o Interacted with Business Users and Business System Analysts to gather

the Requirements.

o Participated in the full software development life cycle.

o Involved in creating Logical and Physical data modeling using ERWIN.

o Created database objects like Tables, Sequences and Constraints as per

the business requirements.

o Extracted data from the source views by writing the procedures to load

the data into staging tables.

o Wrote PL/SQL code for data Conversion in there Clearance Strategy

Project.

o Created database views and materialized views.

o Developed complex Oracle Forms providing extensive GUI features (multi-

selects drag and drop, graphical charts, automated system alerts and

notifications etc.).

o Created database triggers based on business requirement.

o Developed stored functions, packages based on requirement.

o Wrote high performance queries/programs using Collections, Bulk Binds,

Objects, Nested tables, REF Cursors, pipeline functions etc.

o Modified and debugged several PL/SQL programs for performance tuning

using techniques like EXPLAIN PLAN, TKPROF and DBMS_PROFILER.

o Written complex Oracle SQL queries with complexity using Inner/Outer

joins, Union All, Intersect& Minus set operators.

o Developed Oracle Golden Gate extract, pump, and replicate to implement

the business logic transformation for near real time data.

o Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD

for the business users. Transformed complex business rules to Oracle

PL/SQL.

o Created indexes on tables and optimized procedure queries.

o Maintained Database security by authenticating users, using logon

triggers.

o Running explain plan for tuning the SQL queries.

o Used Exception Handling extensively for the ease of debugging and

displaying the error messages in the application.

o Created test scripts, documented procedures that I have created.

o Involved in production support, like monitoring the performance of the

UNIX jobs.

o Involved in the Error Diagnosis, developing test plans to conduct the

Unit and Integration testing.

Researching and resolving the problems occurred with the Jobs and also

involved with the end user to resolve the problems.

Project 3:

Client State Bank of Hyderabad, Hyderabad, India

Role Oracle PL/SQL Developer

Duration May 2011 to June 2013.

Environment Oracle 10g, Oracle Forms and Reports 6i, SQL,

PL/SQL, Erwin, UNIX, Windows XP, Microsoft

Excel, TOAD.

Responsibilities:

o Created data mapping to map the data from different sources to Oracle.

o Involved in implementing the data integrity validation checks through

constraints and triggers.

o Developed and modified packages, functions and stored procedures for

data conversions.

o Developed PL/SQL procedures to create database objects dynamically

based on user inputs.

o Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data from

the Data repository using cursors and exception handling.

o Created indexes on tables to improve the performance by eliminating

the full table scans.

o Created views for hiding actual tables and to eliminate the complexity

of the large queries.

o Created Records, Objects, Collections to store ordered group of

elements for faster assessment of tables.

o Created Error Handling to handle run-time errors in the PL/SQL code.

o Involved in code walk through and review sessions with the development

team.

o Used Oracle Hints and explain plan to fine tune the queries.

o Increased performance tuning by rewriting some of the Queries.

o Designed and developed Oracle forms and reports according to user

specification.

Project 4

Client ITC InfoTech, India

Role Database Developer

Duration June 2010 to April 2011

Environment Oracle 9i/10g, PL/SQL,SQL*Loader, SQL Navigator,

SQL*Plus, UNIX, Windows NT 4.0/2000/XP

Windows2000

Responsibilities:

o Prepared program Specification for the development of PL/SQL

procedures and functions.

o Created Custom Staging Tables to handle import data

o Created custom triggers, stored procedures, packages and functions to

populate different database

o Developed SQL* loader scripts to load data in the custom tables

o Run Batch files for loading database tables from flat files using

SQL*loader

o Created UNIX Shell Scripts for automating the execution process

o Created indexes on tables and Optimizing Stored Procedure queries

o Design, Development and testing of Reports using SQL*plus

o Created Indexes and partitioned the tables to improve the performance

of the query

o Involved in preparing documentation and user support documents

o Involved in preparing test plans, unit testing, System integration

testing, implementation and maintenance

EDUCATIONAL QUALIFICATION:

Bachelors in Technology from VIT University, India.

Contact this candidate