Career Summary

Nearing 3 years of IT experience in Oracle Apps, Order Management iStore. Strong expertise in Oracle PL/SQL, Oracle 11i. Implementation experience of integrating iStore module with ERP. Strong knowledge of PL/SQL.

TECHNICAL SKILLS

Primary Skills

SQL, PL/SQL, C, C++, java

Operating Systems

Windows 9X/2000/NT,DOS, Unix, Linux

Languages

C, C++, Java, PL/SQL, Perl, HTML

Development Tools

TOAD, SQL Navigator, Oracle Forms & Reports 6i, SQL*Plus.

Database

ORACLE 9i.

Domain Knowledge

Oracle Applications 11i (iStore, OM)

ERP

Oracle Applications 11i

Documentation

MS Word, MS Excel, MS Power Point.

Configuration Management

Visual Source Safe, Serena Version Manager

Release Tool

Mercury IT Governance (Kintana), Clear Case Remote Client (CCRC)

Working Experience

Software Engineer, Confidential June 23rd

• Enhanced the Compensation Planner for Workscape clients.
• Handled 5x, 6x, 7x and 8x versions of Compensation Planner with different database structures.
• Configured various pay elements of the Compensation Planner.
• As a database developer on PL/SQL, Oracle 11i, achieved the following tasks for various projects.
• DB installation
• Input file process
• SQL loader process
• Custom procedures for Data validation
• Implementation of functions, procedures, packages and triggers
• Creation of materialized view and custom tables
• Views for reports
• JMT tasks
• Output file generation
• Performance tuning
• Worked on CCRC (Clear Case Remote Client) software, for code deliverables.
• Implementation done on iStore integration Project for 10 months. Achieved to integrate the iStore Box with ERP thereby eliminating the interface.
• Support and enhancement of Oracle Applications modules in OM, iStore and Enterprise Resource Planning (ERP) for over a year.
• Worked on RICE components such as Oracle Forms 6i, Oracle Reports 6i, Interfaces.
• Attained knowledge of Order Management and iStore modules
• Handled configuration Management Software like VSS.
• Hands on experience with PL/SQL stored procedures, functions, triggers, packages using Oracle 9i.
• Strong expertise in Kintana (Mercury IT Governance)and PVCS (VMI Net).

Confidential.

Textron.

Client

Workscape, 7x version of Compensation Planner

Project Description

Textron is automating the administration of its salary planning process. Workscape will host the Workscape/Compensation Planner application supporting the data preparation, planning, and analysis and reporting of compensation recommendations. The client will access the applications via a URL Textron.Employee.com provided by Workscape. This project is 6.x version.

Environment: Oracle 11i.

Tool: Toad, CCRC, Edit Plus, Text Pad

Duration

2 Sep, 2008

Role / Responsibility

Db Developer for DB Installation, input files loading, creation of custom packages for data validation, functions, procedures and triggers.

Team Size

20

Confidential.

Project Name

IBM

Client

Workscape, 6x version of Compensation Planner

Project Description

IBM is automating the administration of its salary planning process. Workscape will host the Workscape/Compensation Planner application supporting the data preparation, planning, and analysis and reporting of compensation recommendations. The client will access the applications via a URL IBM.Employee.com provided by Workscape. This project is 6.x version.

Environment: Oracle 11i.

Tool: Toad, CCRC, Edit Plus, Text Pad

Duration

Nov, 2008

Role / Responsibility

Db Developer for Output File Generation, creation of views for reports, creation of packages, functions, procedures and triggers. Also, creation of materialized views and custom tables.

Team Size

20

Confidential.

Project Name

Kroger

Client

Workscape, 5x version of Compensation Planner

Project Description

Kroger is automating the administration of its salary planning process. Workscape will host the Workscape/Compensation Planner application supporting the data preparation, planning, analysis and reporting of compensation recommendations. The client will access the applications via a URL Kroger.Employee.com provided by Workscape. This project is 5.x version.

Environment: Oracle 11i.

Tool: Toad, CCRC, Edit Plus, Text Pad

Duration

Feb, 2009

Role / Responsibility

Db Developer for Error Report Generation using Packages and procedures, Output File Generation and Performance tuning of sql files.

Team Size

20

Confidential.

Project Name

Accenture

Client

Workscape, 8x version of Compensation Planner

Project Description

Accenture is automating the administration of its salary planning process. Workscape will host the Workscape/Compensation Planner application supporting the data preparation, planning, analysis and reporting of compensation recommendations. The client will access the applications via a URL Accenture.Employee.com provided by Workscape. This project is 6.x version.

Environment: Oracle 11i.

Tool: Toad, CCRC, Edit Plus, Text Pad

Duration

Till Date

Role / Responsibility

Db Developer for SQL loader process, creation of Packages and procedures, Output File Generation, creation of materialized views for reports, Performance tuning.

Team Size

20

Confidential

Project Name

Unisys Corp IT Oracle applications support (OM and iStore)

Client

Unisys

Project Description

Support and Maintenance of all ERP and iStore modules used in Unisys.

Also, supporting the web application of iStore to solve issues related to users, customers and placement of orders.

Environment: Oracle Apps 11.5.9, Oracle Apps 11.5.3, Reports 6i, workflow builder 2.6, forms 6i, TOAD.

Duration

Sep, 2007

Role / Responsibility

Playing a role of a team member however training freshers on these modules.

Contributions

Supporting and enhancement of Oracle applications modules in iStore and OM

Team Size

30