SUMMARY

• Over10 years of progressive experience in the areas of Oracle PL/SQL development, Environment Configuration Management & Technical Integration.
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance wif timely delivery against aggressive deadlines.
• As a Database Team Lead involved in building a cohesive team structure to drive the company’s vision to viable realizable goals.
• Knowledge Transition by preparing plans, work schedule, understanding documents, managing transition calls and tracking transition status.
• Functional experience includes Payments Applications, Telecommunications, HR/Payroll Applications and Insurance Applications.
• Strong skills include SQL, PL/SQL in Oracle 8i, 9i, 10g, 11g; SQL, T - SQL in Sybase and MS SQL Server 2000, UNIX, LINUX.
• Developing complex Stored Procedures, Functions, Packages and Triggers using SQL, PL/SQL.
• Developingmaterialized viewsfor data replication in distributed environments.
• Loading Data into Oracle Tables usingSQL Loader.
• Experience wifData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Performing periodic maintenance tasks like Table Partitioning, Index rebuilds, Statistics Collection and data purge to ensure efficiency and reliability of the applications and databases.
• Writing Shell scripts and SQL updates for reference data based on High Level Design/Low Level Design.
• Query Performance Tuningfor Oracle RDBMS usingExplain PlanandHINTS.
• Creating and scheduling jobs using DBMS JOB and DBMS SCHEDULER
• Problem determination and Trouble shooting in Development, Test and Production Environments.
• Environment Configuration Management by Integration of the Patches, Installation and Configuration of HR Design Client/HRD Studio, DDL deployment, Execution of Jobs and Bug fixing.
• Analysis and development of Batch Programs using the Business Rules and code of the existing system.

TECHNICAL SKILLS

Core Strengths: Oracle SQL, PL/SQL; Sybase SQL, T-SQL, UNIX.

RDBMS: Oracle 8i, 9i, 10g, 11g, Sybase ASE 12.x/15.x, MS SQL Server 2000

OperatingSystems: UNIX, LINUX, Windows NT/2000/XP, Sun Solaris, AIXProgramming

Languages: SQL, PL/SQL, T-SQL, DTS, Shell Scripting.

Tools: Oracle Enterprise Manager, Toad for Oracle, SQL Developer, Sybase Central.

Application Servers: Oracle 9i Application Server Administration and Oracle 9i Application Server Portal Development.

PROFESSIONAL EXPERIENCE

Confidential

Payments Systems

Responsibilities:

• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance.
• Writing DML scripts and Shell scripts for updating reference data based on High Level Design/Low Level Design.
• Writing DDL scripts for Tables, Views, Constraints, and Indexes based on High Level Design/Low Level Design.
• Developing complex Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developingmaterialized viewsfor data replication in distributed environments.
• Creating SQL Loader scripts for data loading.
• Data encryption using DBMS CRYPTO to secure SPI/PCI data.
• Query Performance tuning using Execution Plan, Hints and AWR.
• Perform activities of reference data maintenance, table maintenance through partitioning and compression, writing procedures for data archival/purge and other efforts typically undertaken to improve the efficiency and reliability of the applications and databases.
• Creating and scheduling DBMS Scheduler Jobs for executing stored procedures on an interval basis.
• Work wif application team and production support teams to resolve production issues.
• Manage privileges on tables wif SPI/PCI data.

Environment: Oracle 11g/10g, Solaris/Windows Server, SQL, PL/SQL, TOAD, OEM, AWR, UNIX Shell Scripts.

Confidential

Local Ordering System

Responsibilities:

• Preparation of High Level document, Detail Level Design document and other relevant documents for development process.
• Developing database Stored Procedures for Change/Modification Requests.
• Developing shell scripts for data conversion and resolution of Trouble Tickets.
• Analysis and Documentation of the existing database architecture.
• Knowledge Transition for database activities from the existing teams.
• Preparing plans, schedules for work, attending transition calls, to track transition status and management reviews wifin the project.
• Preparing and Reviewing Understanding Documents and Query Register for the Knowledge Transition.
• Build and maintain reference data driven from System requirements and client requests.
• Administration of the Content Management Application (CMA) which facilitates a higher level of data integrity and provides a mechanism to quickly implement content and data changes.
• Executing routine database jobs/tasks as a part of every release and providing support during Implementation on Production for a release.
• Formulating and developing new tools for reducing man hours and increasing efficiency.
• Providing support as required and mentoring team members while solving technical problems and providing technical guidance on solutions.
• Allocation and follow up of tasks wif database team resources.

Environment: Sybase ASE 12x/15x, UNIX/Windows Server, Sybase Central, Sybase Interactive SQL, CMA.

Confidential

Environment Configuration Management

Responsibilities:

• Providing technical support for the HR Access development and test environments.
• Installation and Configuration of HR Design Client/HRD Studio used for customizing the HR Access Application.
• Installation and Configuration of HR Access WebTools dat include OpenHR Server, Query Server and the HR Access Web Application.
• Integration of Patches, Creation and Modification of tables in the database, Execution of Jobs, Bug fixing etc.
• Environment Configuration for the Web Application through HR Design Client.
• Resolving user requests for the technical issues as well as various other tasks for the development environments.
• Preparation of Scenarios for Regression tests and enhancements included in the new release using requirement documents.
• Execution of Regression tests for HR Design Server, HR Design Client and WebTools.
• Integration of the HR Design Server Patches and validation of patches and events for the new releases of HR Design Server, HR Design Client and WebTools.
• Automation of the Scenarios for Regression tests using QTP.
• Conducting HR Access technical trainings.

Environment: Windows Server 2003, Unix/AIX, Lotus Notes 6.0, Oracle 9.x/10.x, SQL Server 2000, SQL Server Enterprise Manager, SQL Query Analyzer, Apache Tomcat Web Server, QTP 8.0.

Confidential

SQL Server Developer

Responsibilities:

• Analysis of Batch Programs using the Business Rules, CL and Cobol Code of the existing system.
• Developing Stored Procedures in MS SQL Server 2000 for the Batch Programs.
• Developing DTS packages for data import and export.
• Designing queries for Reports generated through the Batch Programs.

Environment: Windows Server 2003, Unix/AIX, RedHat Linux, Oracle 9.x/10.x, SQL Plus, PL/SQL, SQL Server 2000, SQL Server Enterprise Manager, SQL Query Analyzer.

Confidential

Junior Database Administrator

Responsibilities:

• Installation and Maintenance of Oracle RDBMS Server 8i, 9i and 10g.
• Oracle Database Setup, Administration and Performance Tuning.
• SQL, PL/SQL Tuning for Oracle based Applications.
• Database migration.
• Creating database in MS SQL Server 2000.
• Migrating database from Fox-Pro to MS SQL Server 2000.
• Developing scripts for creating database objects.
• Developing scripts for Data Migration.

Environment: Windows 2000 Server, Unix, Oracle 9i Application Server, Apache web Server, Oracle 8i, SQL Plus, PL/SQL.

Confidential

Project Trainee

Responsibilities:

• Developing a web based Library System for handling of Electronic files and to manage records and transactions in a library related to physical items.
• Provide facility to store media files in the database.
• Installation of Oracle RDBMS Server 8.1.7.0.
• Upgrading Oracle RDBMS Server from 8.1.7.0 to 8.1.7.4.
• Installation and Configuration of Oracle 9i Application Server.
• Upgrading Oracle 9i Application Server Portal from 3.0.9.8.0 to 3.0.9.8.5.
• Migration of Database Schemas.
• Migration of 9i Application Server Portal Applications.