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

SUMMARY

Oracle 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).
Good knowledge and experience working in Java using jdbc, HTML, XML.
Collaborating with senior architects to discuss the requirement and to finalizing the database changes to pin down to technical development.

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

Oracle PL/SQL Developer

Responsibilities:

Implemented wrappers using PL/SQL.
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 implementing the data integrity validation checks through constraints and triggers.
Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
Extensive use of XML.
Involved in delta changes (modification related to database with each release), adding/modifying objects.
Involved in production support of the product after every release.

Confidential, Bloomington, IL

Oracle 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.
Tuned bad performing reporting queries.
Using Swing Concepts in Java Front End Forms are designed.
Used SQL*Loader to load the data into the staging database and transactional systems.
Involved in production support of the product after every release.

Confidential, Warren, NJ

Oracle PL/SQL Developer

Responsibilities:

Confidential, Temple Terrace, FL

Oracle PL/SQL Developer

Responsibilities: