PROFESSIONAL SUMMARY

• Over10 years of progressive experience in the areas of Oracle PL/SQL development, Environment Configuration Management Technical Integration.
• Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with 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.
• Developing materialized views for data replication in distributed environments.
• Loading Data into Oracle Tables using SQL Loader.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design 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 Tuning for Oracle RDBMS using Explain Plan and HINTS.
• 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
• Operating Systems : UNIX, LINUX, Windows NT/2000/XP, Sun Solaris, AIX
• Programming 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.

EXPERIENCE

Confidenital

Payments Systems, AT T

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.
• Developing materialized views for 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 with application team and production support teams to resolve production issues.
• Manage privileges on tables with SPI/PCI data.

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

Confidenital

Local Ordering System, AT T

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 within 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 with database team resources.

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

Confidenital

Environment Configuration Management Technical Integration

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 that 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.

Confidenital

SQL Server Developer

Responsibilities:

• Developing DTS packages for data import and export.
• Developing Stored Procedures in MS SQL Server 2000 for the Batch Programs.
• Analysis of Batch Programs using the Business Rules, CL and Cobol Code of the existing system.
• 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.

Confidenital

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.

Confidenital

Project Trainee

Responsibilities:

• Installation of Oracle RDBMS Server 8.1.7.0.
• 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.
• 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.

Environment: Windows 2000 Server, Oracle 9i Application Server, Apache web Server, Oracle 8i.