SUMMARY:

• Around 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System RDBMS .
• 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.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL PLUS, TOAD and SQL LOADER
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables
• Basic knowledge on Shell Scripts for invoking SQL.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Involved in the development of enhancements related to Oracle Human Resources Core HR , Oracle Payroll modules.
• Involved in the Clarifying queries related to payroll, absence and workflow issues to the business users

TECHNICAL SKILLS:

Database Technologies RDBMS : Oracle 8i/9i/10g/11g, SQL, PL/SQL, SQL Server 2005

Languages : UNIX shell script basics

Application Package : MS-Office

Operating Systems : MS-DOS, Windows, UNIX

IDE Tools : TOAD, SQL Loader, SqlTools and PL/SQL developer

PROFESSIONAL EXPERIENCE:

Confidential

Role: Technical Lead

Responsibilities:

• Develop the reports using report builder
• Tuning the queries
• Working with business users to automate the process
• Code review
• Creating the test plans
• Testing the code

Environment: Oracle 11g, UNIX, Oracle report Builder

Confidential

Role: Senior Developer

Responsibilities:

• Develop schemas, tables, triggers, indexes, sequences, constraints, functions and procedures.
• Establish an applications security requirements during development
• Keep the database administrator informed of required changes
• Responsible for the hardware and OS on which the database will run
• Conducted training sessions on the servers and the applications.
• Creating a procedures based on the requirement
• Coordinating with Application Admin and Application Support teams for the issue resolution
• Involved in patching the database servers and the application updates

Environment: Oracle 11 g, UNIX, SWIFT

Confidential

Role: Oracle Test Lead

Responsibilities:

• 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.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.

Environment: Oracle 10 g, Manual Testing

Confidential

Role: Oracle developer, SQL Server DBA

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: SQL Server 2005, Oracle 10 g

Confidential

Role: Oracle developer

Responsibilities:

• Created users privileges with appropriate roles and levels of security.
• Database Re-organization Database, Tablespaces, Tables etc. . Re-Org is done from time to time for the primary storage objects like Tables, Indexes.
• Creates a number of Dev/Stg and prod Database instances.
• Performing logical backups using export utility and recovering specific object or schema using import utility.
• Monitoring and performing daily incremental backups, weekly backups.
• Troubleshooting performance issues reported by the application team.
• Backup of the production and Development Database, based on business requirements.
• Schema, Table, Database refreshes on demand for dev teams.
• Interaction with client/users on various issues.
• Experience in supporting production and development environments.
• Taking care of all other daily routine DBA tasks like creating users, roles, table space.
• Monitoring the user sessions.
• Analyzing GUI problems.
• Locking and unlocking transaction codes.
• Monitoring Database growth, backup logs, archives directory status.
• Table space monitoring.
• Maintaining all the database servers on offshore.
• Provided different schemas for the developers with different privileges.
• Developed the Exception handling utility in all the procedures.
• Assisted the client with database issues.
• Supported the team by deploying the application.
• Created and maintained the database on Dev/QA/Prod instances.
• Implementing troubleshoot techniques for the issues that are going to occur.
• Reviewed all the procedures and allowed the developers to maintain the standards suggested by the client.

Environment: Oracle 11 g, Java 1.5