We provide IT Staff Augmentation Services!

Oracle Developer Resume

0/5 (Submit Your Rating)

Los Angeles, CA

Hire Now

SUMMARY

  • Oracle Developer, having 7+ years of IT experience in Design, Development and Maintenance of various software applications in client - server environment using Oracle Technologies & Data Warehousing on Windows Platforms.
  • 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.
  • Responsible for implementation withPL/SQL programming,Oraclereport,Unixshell scripts, modify functionon theprocedures, functions, and packages on the datawarehousingdatabase.
  • 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

Oracle Developer

Responsibilities:

  • Implemented wrappers using PL/SQL and UNIX.
  • Developed reporting queries for OLAP systems.
  • Extensively working on ETL using oracle PL/SQL and Unix
  • Implemented and developed test cases for database scripts.
  • Worked ondatawarehousing.Developed SQL*LOADER scripts to load data from flat files tooracle tables. 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

Oracle Developer

Responsibilities:

  • Implemented wrappers using PL/SQL and UNIX.
  • Create and enhanceOracleForm/Report Applications
  • Implemented and developed test cases for database scripts.
  • 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

Oracle Developer

Responsibilities:

  • Implemented wrappers using PL/SQL.
  • Developed reporting queries for OLAP systems.
  • Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
  • Writing SQL reports and scheduling these reports from UNIX scripts.
  • Implemented and developed test cases for database scripts.
  • Involved in tuning the queries and stored procedures.
  • Tuned bad performing reporting queries.
  • Involved in production support of the product after every release.

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

Confidential, Temple Terrace, FL

Oracle Developer

Responsibilities:

  • Involved in all the phases of Software Development Life Cycle(SDLC) throughout the project life cycle and developed periodic reports using Oracle Reports 9i and screens using Oracle Forms 9i.
  • 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

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship