SUMMARY:

• Around 7 + years of programming experience as an Oracle PL/SQLDeveloper in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables
• Basic knowledge onShell Scriptsfor 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

Technical Lead

Responsibilities:

• Develop the reports using report builder
• Analyze the SAS code
• Convert the SAS code into PL/SQL Procedures
• 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, SAS

Confidential

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

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 likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Loaded Data into Oracle Tables usingSQL Loader.

Environment: Oracle 10 g, Manual Testing

Confidential

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
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesand Dynamic SQL.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

Environment: SQL Server 2005, Oracle 10 g

Confidential

Oracle developer

Responsibilities:

• Created users & privileges with appropriate roles and levels of security.
• Converted the reports from Actuate to Jasper using the XMLS
• Developed application to hold the Jasper reports loaded from the XMLS.
• 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, Developed Reports using iReport