We provide IT Staff Augmentation Services!

Oracle Developer Resume

Ashburn, VA

SUMMARY:

  • 7+ years of IT experience in Design, Development, Implementation and support of RDBMS in UNIX(Sun Solaris 5.9) & Windows Environments using Oracle Tools.
  • Expertise in writing Cursors, Stored procedures, Packages, Database Triggers and functions using PL/SQL
  • Expertise in maintenance of tables, indexes, views and optimizing queries and stored procedures.
  • Extensively Worked in developing Oracle 10g/9i/8i and other Oracle tools like SQL * Loader & TOAD.
  • Expertise in Design and development of interface and conversion programs to integrate Oracle Applications modules to import data from various sources using PL/SQL, Shell Scripts and SQL*Loader.
  • Experience in logical database design (Data Modeling and E - R Diagramming techniques), Dimensional Modeling, physical database design, and applications development considerations in relational environment
  • Strong in Data Modeling including Analysis of requirements Document, Design of the Dataflow, ER Diagrams, Use Cases, Normalization and Demoralization of Tables.
  • Experience in writing Cursors, Ref Cursors, Composite data types and collections in writing backend PL/SQL code.
  • Experience in understanding business requirements for analysis, detailed design, database design & development of applications.
  • Experience in Application DBA activities like creating users, roles and granting and revoking privileges, create database schema, import/export, backup, database migration etc
  • Coded forms, reports, and back-end interfaces
  • Created ad hoc reports, customization, distribution & administration of Ad hoc Reports in Query Studio.
  • Heavily participated in brainstorming sessions, JAD sessions, and interviews with all stakeholders in the project and also created meeting minute Documents
  • Acted as liaison between the business area and development team Confidential Various stages of the SDLC
  • Proficient in Rational tools including Rational RequisitePro, Rational ClearQuest, and Rational ClearCase
  • 1 Year of experience in writing shell scripts in UNIX.
  • I am enthusiastic and project-oriented team player, with excellent communication and leadership skills to develop a creative solution for challenging clients need.
  • Strong Analytical, Inter-personnel, Problem-solving and Proven ability to work under pressure

TECHNICAL EXPERTISE:

Platforms: Windows NT/ 2000/XP, UNIX

Languages: Visual Basic 6.0, VB Script, XML, HTML 4.0, SQL, PL/SQL, Visual Basic .Net 1.1, Java, Unix, C,C++ Quick Test Pro 9.0, Quality Center 9.0, Rational ClearCase Explorer, Rational ClearQuest, Rational Requisite Pro, TOAD, Test Result Archival

RDBMS: Oracle 9i, Oracle 10g, MS-Access 2000

Tools: VSS, Rational ClearCase, TOAD 8.5,SQL *Loader, FTP, Reports 6i, Forms 6i

PROFESSIONAL EXPERIENCE:

Confidential, Ashburn, VA

Oracle Developer

Responsibilities:

  • Worked on Requirements Study for the system, design and development of an Oracle 9i database in an n-tier architecture environment.
  • Interfaced regularly with several business owners and several business patterns for data.
  • Migrated project from development to production environment.
  • Worked with the existing Shell scripts to make the required changes so as to make it compatible to the current working project.
  • Extensively used TOAD for the entire project activities.
  • Involved in creating the Oracle tablespaces, indexes, constraints, public synonyms, DB links, granting roles etc.
  • Developed, tested and maintained complicated PL/SQL for writing Views, Functions, and Stored Procedures.
  • Extensively wrote PL/SQL codes for the transformation, keeping the business rules in mind.
  • Created UNIX shell scripts to run jobs.
  • Created multiple oracle packages for retrieval of data from the system
  • Involved in optimizing SQL queries and Sql*Loader using tools like TOAD etc.
  • Involved in Query optimization using SQL Trace, and Explain Plan.
  • Coded forms, reports, and back-end interfaces
  • Upgraded forms and reports as per requirement specification
  • Creating several Forms and Porting the Reports and Forms to Application Sever.
  • Involved in Unit Testing and implementation of the system
  • Participate in development, testing and migration of oracle objects from development to testing and production environments.
  • Tuning of SQL queries to improve the performance of the system and Identify root causes and resolve problems related to system functionality.
  • Wrote various PLSQL blocks for nightly and monthly flow
  • Creating SQL, Object Views, PL/SQL database objects.
  • Performed Export, import and written Stored Procedures for Data migration.
  • Meet with business analysts on new functionality requests and production issues
  • Providing production support as needed offering timely, instantly sound problem resolution
  • Developed, modified, and optimized complex queries for data retrieval and modification.
  • Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
  • Involved in preparing Test plan, Test cases for Unit and assembly using Test director.
  • Participated in reviewing code changes.
  • Involved in documenting the modifications and intended functionalities of the interfaces
  • As a ClearCase Admin, ensured all the correct version of documents and sometimes troubleshoot in order to solve problems.
  • Prepared Weekly Status Reports

Software: Oracle 9i/10g,PL/SQL, TOAD, Shell Script, SQL*Loader, and Unix (Sun Solaris 5.9),Forms6i,Reports6i

Confidential, Atlanta, GA

Oracle Developer

Responsibilities:

  • Developed stored procedures and functions
  • Developed anonymous PL/SQL blocks and triggers
  • Created tables, table spaces, schemas, views, packages, stored procedures, triggers, functions etc using TOAD tool.
  • Modified existing packages, procedure and functions.
  • Performing and Reviewing Unit Test Results and Code Changes.
  • Wrote SQL*Plus queries to manipulate data and generate various reports
  • Involved in tuning SQL queries
  • Creating SQL, Object Views, PL/SQL database objects
  • Created UNIX shell scripts to run nightly jobs and monthly jobs
  • Upgraded forms and reports as per requirement specification
  • Creating several Forms and Porting the Reports and Forms to Application Sever.
  • Developed some part of user interface
  • Participate in development, testing and migration of oracle objects from development to testing and production environments.
  • Meet with business analysts on new functionality requests and production issues
  • Worked in migration from Oracle 8i to Oracle9i.
  • Involved in documenting the modifications and intended functionalities of the interfaces.
  • Developed, modified, and optimized complex queries for data retrieval and modification.
  • As a ClearCase Admin, ensured all the correct version of documents and sometimes troubleshoot in order to solve problems.
  • Preparing weekly status reports
  • Prepared Quality Related documents.
  • Responsible for creating test cases, unit testing, integration testing of customizations functionality
  • Trained and helped the end users in their daily transactions.

Software: Oracle 8i/9i, PL/SQL, Oracle Loader,TOAD, SQL*Plus, Sun Solaris 7,Forms 6i,Report6i

Hire Now