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 at
• 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

Responsibility:-

As an Oracle Developer:

• 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

Role: Oracle Developer

Responsibility:-

• 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