Payel Banerjee Dhara

Mobile No. : 831-***-****

Email : accbnk@r.postjobfree.com, accbnk@r.postjobfree.com

Experience Summary

I am an associate in IBM for last 2 years 4 months and prior to that had

been working in Tata Consultancy Services for 5 years and 9 months.

Currently I am in United States with L2 visa and a valid EAD.

My technological knowledge is in Oracle SOA(BPEL, Mediator, AIA, B2B, SOA

Governance), Oracle PL/SQL, Oracle EBusiness Suite(R12)

Technology

Below is a list of important hardware, software products, tools and methods

that I have worked with.

Qualifications

Degree and Date Institute Major and Percentage

Specialization

Bachelor of JIS College of Information Technology 81.2

Technology Engineering,

July 2005 Kalyani

Career Profile

Dates Organization Role

05/09/2011 till date IBM Advisory System

Analyst(Band 7A)

28/11/2005 - 02/09/2011 TATA Consultancy IT Analyst

Services (TCS)

Training / Continuing Education Summary

Program or Course Coverage Dates

Initial Learning Program All TCS-ILP 2005

(ILP) Subjects

ODI Oracle Data 2009

Integration

fundamentals

Oracle Fusion Middleware XML, Webservices, 2009

SOA (BPEL, ESB,

Business Rules)

Oracle Application AIA Foundation Pack 2010

Integration Architecture

Oracle Applications R12 Oracle Apps R12 2010

Financial

Modules(AP,AR,CM)R

Oracle BPM 11g Oracle BPM, BAM, 2011

Implementation Boot Camp Business Rules,

Human Workflow

SOA 11g Administration Boot SOA Suite 11g and 2011

Camp Weblogic

Administration

SOA Governance Oracle SOA 2013

Governance 11g

Certification

Certification Technology

Oracle Certified Associate Oracle PL/SQL

(OCA)

Project

(In reverse chronological order)

Project Description Role

Technology

Unifirst Unifirst is a supplier of Offshore Oracle SOA

Duration : uniforms and protective Senior 11g, AIA

clothing in the United Developer Foundation

Jan 2013 - Feb States. The project aims to Pack,

2013, replace the "Account Oracle EBS

June 2013 - Management System" being used R12, Oracle

Oct 2013 for 20 years with a new PL/SQL

system using Oracle eBusiness

Suite and Oracle Fusion

Middleware. I was responsible

for implementing some of the

critical integration

interfaces.

Integra Integra is a world leader in Module Oracle SOA

Duration : medical devices and offers Leader 11g, B2B,

innovative solutions in EDI, AIA

Feb 2012 - Orthopedics, neurosurgery, Foundation

December 2012 spine, reconstructive and Pack,

general surgery. In the Oracle EBS

United States, Integra is a R12, Oracle

leading provider of surgical PL/SQL

instruments to hospitals,

surgery centres and alternate

care sites, including

physician and dental offices.

Integra has decided to

implement a single global

instance of Oracle E-Business

Suite R12 and elected Oracle

SOA Suite, AIA and B2B server

to integrate Oracle EBiz with

the trading partner systems.

As an Oracle Fusion

Middleware Consultant, my

responsibilities included:

(1) Analysis and design of

SOA integration requirements

(2) Preparation of the SOA

and AIA Development standards

and technical specification

template for integration

interfaces

(3) Requirement analysis from

the functional design

documents. Thereafter regular

interactions with the

functional owners and

business owners to understand

the capacity of the work and

helping them to update the

different mappings in the FS

document.

(4) High level designs for

the 2 most important,

critical and complex EDI

interfaces(850 and 810).

(5) Building the code

components for B2B, SOA/AIA

and PLSQL, preparing the code

bundles of the above

components

(6) Building the Technical

Specifications and updating

them.

(7) Iterative complex unit

testing(mainly for 15

different layouts for 810 and

4 different file formats for

850) due to multiple changes

for both 850 and 810

(8) Deployment in different

instances, providing SIT, UAT

support and continuously

integrating changes till go

live.

Oracle Fusion A PoC was implemented on SOA Analyst Oracle SOA

CoE Governance which aimed at 11g, OER,

exploring the functionalities OSR

Duration : of Oracle Enterprise

Repository (OER) and Oracle

December 2011 Service Registry (OSR) with

the help of a case-study on

the end-to-end lifecycle of

an asset or more explicitly

web-service.

DJ Orth DJO LLC (DJO) is a Module Oracle SOA

Opedics diversified medical devices Leader 11g(BPEL,Me

manufacturer made up of six diator),

Duration : distinct globally dispersed Oracle EBS

business units. DJO had R12, Oracle

August 2011 - separate ERP systems to PL/SQL

Feb 2012 support each of the business

units.

DJO hence was seeking for a

system integrator to support

the consolidation of the

various ERP systems

sequentially to a

standardized new single

instance of the Oracle

E-Business platform with

unified business processes.

So all the existing

interfaces needed

redevelopment to handle data

flow to/from Oracle EBS using

Oracle Fusion Middleware 11g.

I am currently working as the

integration lead responsible

for the enhancement and

re-designing and

post-production support of

inbound and outbound

interfaces with SOA.

My key responsibilities

include :

(1) Taking the hand-over from

a third party vendor

initially responsible for SOA

implementation.

(2) Identifying interfaces

with slow performance and

doing the root cause analysis

for each of them by

interaction with relevant

business owners.

(3) Modification of all such

components and corresponding

MD70 documents.

(4) SOA server administration

(5) Detailed analysis of

Functional Design documents

of the new interfaces and

thereafter driving the

development team to build the

code components and MD70

documents and henceforth a

detailed review of the same.

Imparting training sessions

as and when required.

McGraw-Hill MHC has its financial system Module Oracle SOA

Company (MHC) on Lawson where financial Leader 11g(BPEL,Me

Atlas Project data from various systems of (SOA, diator),

One its different divisions are Oracle OSB, AIA

(Replacement consolidated. All financial PL/SQL) Foundation

of Lawson reporting at corporate level Pack,

Systems with is done from this Corporate Oracle EBS

Oracle R12) Lawson Finance. R12, Oracle

The project deals with the PL/SQL

Duration : replacement of the age old

Lawson platform to the new

July 2010 - Oracle EBS R12. All internal

August 2011 and external systems those

are integrated to Lawson will

be integrated to Oracle EBS

R12. So all the existing

interfaces will have to be

modified/ redeveloped to

handle data flow to/ from

Oracle EBS using Oracle

Fusion Middleware 11g. OSB

and AIA Framework(BPEL,

Mediator) will be used along

with Oracle PL/SQL for

components where standard API

will not be available.

I had been working as

offshore lead on the

interface area (SOA, Oracle

Pl/SQL) leading a team of 8

members.

My key responsibilities

included :

(1) Developing the high level

design of the interface,

preparing the strategy

document for the same by

interaction with technical

team at the customer end.

(2) Detailed analysis and

review of Functional Design

documents of the interfaces

with regular meetings with

Functional team and relevant

business owners.

(3) Driving the development

team to design the Technical

Design Documents and

thereafter code components as

per relevant Functional

Design Documents.

(4) Managing the deployments

and deliveries of the

interfaces.

(5) Interaction with QA team

on the technical

understanding of the

interfaces and verification

of logged defects in QC.

Other responsibilities

included :

Identification and gathering

of necessary software

components and driving the

installation team and making

the entire offshore setup.

BT EMP PAL The system called STARS Module ODI, XFB

Manage contains cost and revenue Leader

Commercial data of different

Inventory Multi-National Corporate

Duration : (MNC) contracts operating

March 2010 - with BT. EMP PAL acts as the

June 2010 integration layer responsible

for extraction of the

requisite data from different

tables in STARS database

(using ODI), transforming the

same and write to files in a

specific file format in PAL

directory (using ODI), and

transfer the files to GSDW

team (EIP Platform) using

XFB. The process is a

scheduled one operating on

1st working day of each

month.

I was working as the module

leader responsible for the

design and ODI development in

parallel.

BT EMP PAL An agency called Reuters Offshore Oracle

Manage prepares the raw currency lead PL/SQL,

Currency Rates exchange rates feed and needs BPEL

to transfer the processed

Duration : feed to GDW Finance

February 2010 Datawarehouse. EMP PAL acts

as the integration layer in

the whole process. The

objective of EMP PAL is to

prepare the processed

exchange feed and FTP it to

GDW, schedule a process to

calculate the average monthly

conversion rates for each

currency and push it to GDW

tables, schedule a process to

push the currency exchange

rates data for the current

table to History tables the

and expose the following web

services : (1)

queryDailyCurrencyRates (2)

queryMonthlyAverageCurrencyRa

tes

(3)

queryDateRangeCurrencyRates.

I was responsible for

development of BPEL

processes, database design

and PL/SQL code review.

BT EMP PAL PAL NWMS (Northallerton Offshore Oracle

NWMS Warehouse Management System) PL/SQL PL/SQL,

Duration : is an integration project Lead BPEL, ESB

September 2009 based on IBM Message Queue Developer

- January 2010 and message broker. The scope

of this project is to design

22 interfaces, 11 of which

will read raw message from

the queue in ASC system (in

Mainframe), process this data

in PAL layer (using

BPEL,ESB,Database Adapter,

PL/SQL) and pass on the

result to OWMS system which

is based on Oracle Apps 11i,

the other 11 will do the

reverse processing i.e., read

from Oracle Apps base tables,

form the message and pass

onto the Mainframe system.

My role was mainly concerned

with database design and

PL/SQL development in PAL

layer which is actually doing

the entire processing and

formation of the message and

also development of BPEL, ESB

codes partially.

MIS The MIS (Management Offshore Oracle

development Information System) PL/SQL PL/SQL, JSF

project application is an in house Developer

solution to allow BT Property

Duration : individuals to place all the

May 2009 - building and property related

August 2009 important information in a

single location, other than

spreadsheets and lists. It

provides a secure system with

access controlled at both

login and individual data

field level which provides

the confidence needed to

allow BTP individuals to

place such important

information in a single

location, whist if necessary

knowing they still have full

control over any access to

it.

The approach of development

was Agile where User Story is

the basic unit of scope.

During the project each User

Story is progressively

elaborated from being little

more than a one-line

description through to a set

of Acceptance Criteria.

The design is based on Oracle

Business Suite where my role

was mainly concerned with

database design and

development of PL/SQL

packages, procedures,

triggers and scheduling batch

processes and front-end

design partly.

Cobalt COBALT (Combined Operational Offshore Oracle

migration BCM Activity Living Tool) PL/SQL PL/SQL

project supports enterprise-wide Developer

Business Continuity

Duration: Management, resilience and

December 2008 contingency planning. It can

- April 2009 provide information on which

operational readiness

decisions may be made, aiding

the managed restoration of

services in the event of an

incident affecting the

ability of BT to deliver

services to its customers,

such as the loss or partial

loss of a BT building or

service.

My role was concerned with

development of Oracle Pl/SQL

Packages, Procedures and

Functions and database design

partly in line with the

existing business.

BT Obtree BT has a number of intranet Onsite Livelink

Support sites developed in Obtree co-ordina Web Content

(LLWCM). TCS provides 1st tor(till Management,

Duration: line, 2nd line and 3rd line July) and Oracle 9i

April 2008 - support for all these sites. thereafte PL/SQL, SQL

November 2008 r

My role was concerned to deal offshore

with 3rd line issues mainly lead.

using Obtree.

BT Obtree BT Openreach is one of the Lead Livelink

websites most important customers of Developer Web Content

migration BT and BT HR is another vital and Management,

(BT Openreach, site of BT. Openreach and HR Onsite Oracle 9i

BT HR) had their intranet sites co-ordina PL/SQL, SQL

designed using Obtree 9.2 tor

Duration: earlier which are migrated to

January 2008 - Obtree 9.5 with new look and

March 2008 feel and enhanced

functionalities of Web 2.0.

BT Two newly evolved LOB's (BT Onsite Livelink

Transformation Design and BT Operate) co-ordina Web Content

Web Site homepages were developed tor Management,

development using Obtree and with a set Oracle 9i

of brand new web 2.0

Duration: functionalities. The other

September 2007 sites of this project include

- March 2008 Group Strategy Portfolio and

Group Industry Portfolio.

BT Group BT has a number of intranet Offshore Livelink

Communications sites developed in Obtree Developer Web Content

LOB site (LLWCM). All the main Line of Management,

template Business homepage templates Oracle 9i

standardisatio were given standard agreed

n functionalities and new

functionalities were

Duration: developed.

November 2006

- August 2007

Hardware Software Products Tools Methods

Intel Oracle SOA Suite, Oracle Service-Oriented

processor Oracle PL/SQL, Jdeveloper, Architecture,

PC Oracle EBusiness PL/SQL Developer, Database designing,

Suite, Oracle B2B Editor, Web Content

B2B, EDI, SOA Oracle UCM Site management,Web

Governance(OER or Studio designer, applications,Object

Oracle Enterprise TOAD, Microsoft Oriented Concepts

Repository, OSR Visual Studio.NET and Structured

or Oracle Service 2003(1.1) methods

Registry, OWSM),

Ant script,

Oracle Data

Integrator(ODI),

Oracle Service

Bus(OSB),

Livelink web

content

management(Obtree

), Java, SQL

server 2000,

Oracle UCM

Contact this candidate