Oracle Sql

* ***** **

APT B

Wayne, NJ *****

Cell: 1-312-***-****

******.**@*****.***

Indira Roy

Summary

. Oracle PL/SQL Professional with 10+ years of experience in PL/SQL and

Oracle Development tools.

. Around 7+ years of experience in Oracle Applications with experience

in customization and implementation of Oracle Applications Modules

like Order Management(OM), Inventory(INV), Purchasing(PO), Accounts

Receivables(AR), Accounts Payables (AP), General Ledger (GL) and

Application Object Library(FND).

. Extensively worked on PL/SQL Stored Procedures, Functions, Stored

Packages, Database Triggers, Cursors and Dynamic PL/SQL.

. Experienced in data modelling, creating entities and primary and

foreign keys.

. Managed full life cycle of a project starting with defining scope,

technical design, coding, testing and production implementation.

. Worked with Key and Descriptive Flexfields.

. Designed and customized reports and forms as per the business

requirements using Oracle Reports and Oracle Forms 6i.

. Experience in Design and Development of RICE (Reports, Interfaces,

Conversions and Enhancements) components.

. Experience in Order to Cash cycle and Oracle Workflow.Extensive

experience in Implementation, Customization, and Support for Oracle

Applications using Oracle development and reporting tools like

SQL*Loader, PL/SQL, TOAD, SQL*Plus, Reports 6i and Forms 6i.

. Worked directly with clients to get the business requirements and

scope.

. Worked directly with users during User Acceptance testing.

. Experienced in creating project plans using MS Project.

. Worked as a coordinator between offshore development team and client

team.

. Experience in writing technical design document (AIMS) MD70.

. Experience in Application System Administration activities like

registering Concurrent Programs, defining value sets and registering

reports and forms.

. Proficient in understanding client's needs.

. Demonstrated ability to work as part of a team with aggressive time

schedules.

. Good communication skills, interpersonal skills, self-motivated, quick

learner, team player.

. Completed training in datastage.

Technical Skills

Oracle Applications: Oracle Applications 11i - OM, INV, PO, AR, AP, GL,

FND

Operating Systems: UNIX, LINUX, Windows XP/2000

Languages / Tools: SQL*Plus, PL/SQL, PL/SQL Developer, SQL Developer,

SQL*Loader, Toad 8.0, Shell Scripting, MS Visual Source Safe

RDBMS: Oracle 11g/10g/9i/8i

GUI Tools: Reports 6i, Forms 6i, Oracle Workflow

Professional Experience

IBM Global Services

May '05 - Jul '13

Clinet: UPS, NJ

Jun '09 - Feb '13

PL/SQL Technical Lead, Onsite Coordinator

Responsibilities

* Attending business requirement and functional requirement sessions and

provide the analysis and the estimates for the requirements.

* Prepare technical impact documents.

* Develop PL/SQL packages, stored procedures and functions.

* Wrote scripts in PL/SQL to download data into text files using DBMS

UTL_FILE.

* Extensively worked on Oracle External Tables.

* Develop shell scripts to submit PL/SQL packages.

* Provide solutions to meet the client requirement and prepare detail

designs.

* Prepare project plans for detail design, coding and unit testing and

system testing.

* Create resource allocation plans.

* Co-ordinate between the offshore and the onsite regarding the

requirements.

* Create Detail Design review document which includes a summary of all the

requirements per release and review the document with users of different

applications.

* Guide the developers regarding coding and unit testing.

* Deliver the solutions to the client and attending review sessions.

* Participate in system testing, integration testing and user acceptance

testing.

* Co-ordinate with different groups of users to perform user testing.

* Provide post implementation support.

* Co-ordinate with different groups of users during user testing.

* Provide process improvement solutions to the client.

Environment: UNIX, PL/SQL, SQL*Loader and Toad 8.0 and SQL Developer

Client: Canadian Wheat Board, CA Jan '09 - Jun '09

Role: Oracle Apps Technical Offshore Lead

Responsibilities

. Wrote scripts in PL/SQL to download data into text files from various

tables using DBMS UTL file package and procedures.

. Prepared technical specifications document (MD 70) based on the

functional requirement specifications (MD 50).

. Registered customized reports and concurrent program/sets using System

Administrator and Application Developer.

* Monitor the status of offshore scope.

* Provide guidance to the offshore team regarding technical

development.

* Release developed objects to onsite.

* Provide help to the offshore team during unit testing of offshore

objects.

* Hold weekly team meetings and maintain MOM for each meeting.

* Make sure that all offshore development follows the quality

guidelines.

* Co-ordinate with onsite SME regarding functional and technical

requirements.

Environment: Oracle Applications R11i, Reports 6i, PL/SQL, SQL*Loader and

Toad 8.0, Forms 6i

Client: IBM India Pvt. Ltd Jun'08-Dec '08

Role: Oracle Applications Technical Consultant

Responsibilities

. Creating PL/SQL programs for Item Import and Purchase Order Import and

Vendor Import. The purpose was to create a repository of interfaces

across all Oracle Application modules.

. Unit testing of the PL/SQL programs developed and preparing Unit Test

case Documents.

. Registering Concurrent Programs.

. Development of Customer Interface.

Environment: Oracle Apps 11i, SQL, PL/SQL, UNIX, TOAD

Client: Handleman Company Nov'05-Feb '08

Role: Oracle Applications Technical Consultant

Responsibilities

. Creating MD70 documents.

* Creating PL/SQL programs for Item Import and Purchase Order Import

and Vendor Import.

. Creating custom PL/SQL packages based on functional requirements.

* Testing of the PL/SQL programs developed and preparing Unit Test

case Documents.

. Creating Oracle forms as per client requirement using Template.fmb.

* Creating SQL*Loader control files to load legacy data to staging

tables.

* Registering Concurrent Programs, Reports and Forms.

* Creating a Oracle Workflow process based on client's requirements.

* Responsible for managing estimates, tracking and change control

aspects of the project.

Environment: Oracle Apps 11i, SQL, PL/SQL, UNIX, TOAD, SQL*Loader, Oracle

Workflow

Client: ADVO Inc May'04-Sep'04

Role: Oracle Applications Technical Consultant

Responsibilities

* Developed the Shortage Summary Report which provides the client with

accurate reporting of postage expenses and correct client billing

information using Oracle Reports 6i.

* Developed the Print - Paper Volume Forecast report which will be sent to

external Print Vendors to give an estimate for forecasting the paper and

press time requirements using Oracle Reports 6i.

* Preparation of Test plans for oracle reports.

* Registering Concurrent Programs for reports.

Environment: Oracle Apps 11i, SQL, PL/SQL, UNIX, TOAD, Oracle Reports 6i

Oracle Corp., Bangalore, India

Jan'04-Apr'04

Client: City of Memphis

Responsibilities

* Creation of technical designs (MD070 for interfaces and CV060 for

conversions) and pl/sql packages for Inventory category Code Conversion,

Invoice Interface, Vendor Conversion and Employee Conversion.

* Creation of staging tables.

* Creation of control files to load data from data files.

* Creation of PL/SQL programs (procedures and packages) to validate and

load data into Oracle Apps base tables.

* Creation of shell scripts.

* Creation of test plans.

* Creation of request sets in Oracle Applications.

* Registering Concurrent Programs.

Environment: Oracle Apps 11i, SQL, PL/SQL, UNIX, TOAD

KPIT Cummins Infosystems Ltd., India

Jan'03-Dec'03

Client: Cummins Inc.

Responsibilities

* Creation of custom tables.

* Creation of database triggers.

* Creation of PL/SQL programs (procedures and packages)

* Creation of reports.

* Creation of shell scripts to transfer data files from a remote server,

using FTP and rename and purge the data files.

* Creation of PL/SQL programs to create extract files with employee data,

promotions data, terminations data and new hire data from hire with a

given period.

* As configuration controller taken part in Quality Management activities

and also taken part in final audit of CMM 5 Assessment as a FAR

(Functional Area Requirement) group member.

Environment: Oracle Apps 11i, SQL, PL/SQL, UNIX, TOAD, Reports 6i

PriceWaterHouse Coopers Software Ltd., India

Sep'01-Dec'02

Client: Kotak Mahindra Bank Limited, Mumbai, India

Hutchison Max Telecom Ltd., Mumbai, India

CCCO(Calcutta Chemicals), Kolkata, India

BPL Ltd., Bangalore, India

Responsibilities

* Creating interface programs using PL/SQL for transferring of data from

legacy applications to Oracle General Ledger and from Oracle payables to

the legacy systems.

* Transferring value sets and concurrent programs from one instance to

another using FNDLOAD.

* Upgrading existing customized oracle reports to 6i.

* Creating data conversions for item, vendor, employee, purchase order,

open invoice.

Environment: Oracle Apps 11i, SQL, PL/SQL, UNIX, TOAD, Reports 6i

Education:

Masters in Urban Planning from School of Planning and Architecture, New

Delhi - 2001

Bachelors in Architecture from Bengal Engg., College, Shibpur - 1999

Contact this candidate