Oracle Developer Resume CA - Hire IT People

SUMMARY

7+ years Experience in System analysis, Design, Programming, Testing & Support of applications using Oracle 11g/10g/9i/8i database.
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, CA

Oracle Developer

Responsibilities:

Implemented wrappers using Oracle 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.
Use TOAD developer tool for faster application design and developments.
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 Developer

Responsibilities:

Implemented wrappers using Oracle PL/SQL.
Implemented and developed test cases for database scripts.
Used Qwest tools (Toad 8.0, SQL Navigator) for database monitoring and tuning.
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 Developer

Responsibilities:

Confidential, Temple Terrace, FL

Oracle Developer

Responsibilities: