SUMMARY:

• 10 years of experience as Database developer (Oracle 9i, 10g & 11g) with expertise and knowledge on Database designing, SQL Programming and knowledge on database administration. Have 3 years of experience in UNIX.
• I have given few Training classes on Oracle 10g SQL and PL/SQL
• I have been in technical panel as part of Organization activities.
• Knowledge on Oracle DBA concepts.

SKILLS:

• Oracle SQL
• Oracle PL/SQL
• Solaris (Unix)
• Oracle Apps (Scheduling jobs)

ENGAGEMENT OVERVIEW:

Confidential

Project Lead

Responsibilities:

• Monitor the IM, PM, SR tickets and CC
• Ensure the SLA’s are met for IM’s and SR’s
• Perform RCA for tickets which have crossed SLA and seek improvements
• Ensure service specialists are aware of all open issues in the application and provide them an update on IM,PM and CC’s
• Ensure team is following the process correctly w.r.t IM,PM and CM
• Plan for transitions in the team whenever required and track them properly to ensure complete knowledge has been provided to the team
• Meeting with the GSK service specialists to understand the status of PM and CC’s and seek their help wherever required
• ...etc
• Involved in developing PL/SQL packages.
• Implementing Batch processing jobs and creating materialized views.
• Thorough knowledge of records, objects, implementing autonomous triggers, resolving mutating errors and instead of triggers using business logic.
• Knowledge of implementing reusable and parallel enabled packages, pipelined deterministic functions and transformative functions and table Functions.
• Creating all kinds of tables and partitioning depending on requirement.
• Thorough knowledge on external Procedures
• Thorough knowledge of implementing nested tables, associative arrays (PL/SQL tables) and Varrays.
• Working with dynamic SQL and ref cursors.
• Thorough knowledge of handling exceptions
• Working with external files and SQL*loader.
• Extensively Involved in Writing PL/SQL Stored Procedures and Packages.
• Prepared scripts for validating all the objects.
• Gathered root causes for any objects which are invalid.
• Prepared the Unit Test Cases for each and every possibility of the system.
• Done the Unit Testing for all the Test Cases and prepared Unit Test Report.
• Involved in writing UNIX shell scripting

Environment: Oracle 10g & 11g, TOAD 9.2, PL Edit, UNIX

Confidential

Project Lead

Responsibilities:

• Involved in developing PL/SQL packages.
• Implementing Batch processing jobs and creating materialized views.
• Thorough knowledge of records, objects, implementing autonomous triggers, resolving mutating errors and instead of triggers using business logic.
• Knowledge of implementing reusable and parallel enabled packages, pipelined deterministic functions and transformative functions and table Functions.
• Creating all kinds of tables and partitioning depending on requirement.
• Thorough knowledge on external Procedures
• Thorough knowledge of implementing nested tables, associative arrays (PL/SQL tables) and Varrays.
• Working with dynamic SQL and ref cursors.
• Thorough knowledge of handling exceptions
• Working with external files and SQL*loader.
• Extensively Involved in Writing PL/SQL Stored Procedures and Packages.
• Prepared scripts for validating all the objects.
• Gathered root causes for any objects which are invalid.
• Deployed the invalid objects to the destination environment using Kintana Tool.
• Coded the catch - up scripts for the delta data.
• Prepared the Unit Test Cases for each and every possibility of the system.
• Done the Unit Testing for all the Test Cases and prepared Unit Test Report.
• Created Concurrent Job for the Catch-Up Script in Oracle Apps 12g and scheduled the same.
• Deployed the code from Dev to STAGE Environment using Kintana Tool.
• Involved in writing UNIX shell scripting

Environment: Oracle 11g, TOAD 9.2, PL Edit, PVCS, Kintana,UNIX

Confidential

Project Lead

Responsibilities:

• Same as previous project

Environment: Oracle 11g, TOAD 9.2, PL Edit, PVCS, Kintana,UNIX

Confidential

Senior Consultant

Responsibilities:

• Same as previous project

Environment: Oracle 11g, TOAD 9.2,SQL & PL/SQL Developer, UNIX,MKS

Confidential

Team Member

Responsibilities:

• Same as previous project

Environment: Oracle 11g, Oracle Apps 12g (scheduling jobs), TOAD 9.2, PL Edit, PVCS, Kintana, UNIX

Confidential

Team Member

Responsibilities:

• Handled this project individually with minimal support from Oracle App’s team.

Environment: Oracle Apps 12g

Confidential

Team Member

Responsibilities:

• Same as previous project

Environment: Oracle 11g, Oracle Apps 12g (scheduling jobs), TOAD 9.2, PL Edit, PVCS, Kintana,UNIX

Confidential

Team Member

Responsibilities:

• Same as previous project

Environment: Oracle 11g, Oracle Apps 12g (scheduling jobs), TOAD 9.2, PL Edit, PVCS, Kintana, UNIX

Confidential

Team Member

Responsibilities:

• Same as previous project

Environment: Oracle 11g, Oracle Apps 12g (scheduling jobs), TOAD 9.2, PL Edit, PVCS, Kintana,UNIX

Confidential

Team Lead

Responsibilities:

• Same as previous project

Environment: Oracle 9i and 10g, Windows NT,UNIX

Confidential

Team Member

Responsibilities:

• . Change Request to include a new Plan Type in location updates.sh Confidential quarterly cost update process inter company discount rates in order to check the space on new-swanaba.singapore server of /safedir include REQ# within subject header on EMAIL devices
• Change Issue Note to replace a redundant field on the issue note ("code") with the associated part to RV opunit code
• Change EMEA Soleil Invoices-Despatch Notes Export Control Destination Control Statement
• Archiving DOC directory
• Modification to badexcesspullback code in GPT autoreq code for HOLD bins
• Flatfile submitted to change the leadtime and repair vendor OpUnit for FRUs in Soleil

Environment: Oracle sql, pl/sql, UNIX shell scripting,awk, perl, oracle forms and reports

Operating System: Solaris 9 and 10

Confidential

Team Member

Responsibilities:

• Service desk tickets has been resolved by communicating with the users
• Written few Oracle DML scripts in order to make the changes
• If the work around does not work use to create a change request

Environment: Oracle sql, pl/sql, UNIX shell scripting,awk, perl, oracle forms and reports.

Operating System: Solaris 9 & 10

Confidential

Team Memeber

Responsibilities:

• Service desk tickets has been resolved by communicating with the users
• Written few Oracle DML scripts in order to make the changes
• If the work around does not work use to create a change request

Environment: Oracle sql, pl/sql, UNIX shell scripting,awk, perl, oracle forms and reports.

Operating System: Solaris 9 & 10

Confidential

Programmer

Responsibilities:

• Designing and Coding Stored Procedures in PL/SQL intended for Patches.
• Monitoring Job Scheduling Applications like AppWorx.
• Coding Shell Scripts for Data Loading.
• Resolving Issues at all levels of severity.
• Product Support and Maintenance.

Environment: MS Office 2000, Oracle 9i, VSS, Windows 2003, TOAD, Sql Loader, Unix.