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