PL/SQL Developer Resume Los Angeles, CA - Hire IT People

SUMMARY

PL/SQL Developer, having 7 years of development Experience in Oracle database in a renowned IT Organization.
Responsible for creating triggers, packages and stored procedures.
Responsible for using Collections and implementing the same in projects.
Developed SQL*Loader programs to load data from flat file to temp tables.
Developed PL/SQL programs to update interface tables and execute along with loader programs.
Tuned SQL queries, Stored Procedures and various applications from database front.
Developed SQL*Loader programs to load data from flat file to temp tables. Developed PL/SQL programs to update interface tables and execute along with loader programs.
Working experience on advanced SQL concepts like RANK, DENSE RANK, ANALYSTICAL FUNCTIONS etc.
Have got exposure on various database tools like Oracle SQL Developer etc.
Actively worked on OLTP (transactional systems) and OLAP (reporting systems).
Develop and implemented the complex reporting queries.
Have got exposure on Extract Transform and Loading (ETL).
Collaborating with senior architects to discuss the requirement and to finalizing the database changes to pin down to technical development.
Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.

TECHNICAL SKILLS

RDBMS: Oracle 11g (SQL, PL/SQL)

Operating Systems: HP - UNIX, Windows 2K/NT/XP.

Languages / Technologies: C, PL/SQL.

Tools: /Utilities: SQL*PLUS, Oracle SQL Developer 4.0

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

PL/SQL Developer

Responsibilities:

Implemented wrappers using PL/SQL and UNIX.
Developed reporting queries for OLAP systems.
Implemented and developed test cases for database scripts.
Involved in tuning the queries and stored procedures.
Tuned bad performing reporting queries.
Involved in optimizing SQL queries and Sql*Loader using tools like TOAD etc.
Involved in delta changes (modification related to database with each release), adding/modifying objects.
Involved in production support of the product after every release.

Environment: Oracle 11g, SQL, PL/SQL, UNIX, OLAP, Sql*Loader

Confidential, Bloomington, IL

PL/SQL Developer

Responsibilities:

Implemented wrappers using PL/SQL and UNIX.
Implemented and developed test cases for database scripts.
Extensively working on ETL using oracle PL/SQL and Unix
Involved in tuning the queries and stored procedures.
Tuned bad performing reporting queries.
Used SQL*Loader to load the data into the staging database and transactional systems.
Involved in production support of the product after every release.
Used ORACLE sql DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 11g, SQL, PL/SQL, UNIX, OLAP, Sql*Loader

Confidential, Warren, NJ

PL/SQL Developer

Responsibilities:

Environment: Oracle 11g, SQL, PL/SQL, UNIX, OLAP

Confidential, Temple Terrace, FL

PL/SQL Developer

Responsibilities:

Implemented wrappers using PL/SQL.
Implemented and developed test cases for database scripts.
Involved in tuning the queries and stored procedures.
Loaded the data into database tables using SQL*loader from text and excel files.
Tuned bad performing reporting queries.
Involved in production support of the product after every release.

Environment: Oracle 11g, SQL, PL/SQL, UNIX, OLAP, Sql*Loader