Project Design

SUMMARY:

. ** Years of work experience as an analyst, designer, consultant,

developer, solution architect, solution lead.

. Extensive worked experience on Retail, Healthcare, Game domains.

. Strong functional and technical work experience on ORMS (Foundation data,

Cost & Deal, Stock Ledger, Inventory Management), OReSA, ORPM, OReIM,

Allocation.

. Functional and technical solution design experience in Integration

solution between Oracle Retail Application and Other legacy system like

PIM, POS, and Financial etc. Worked on ORIB, RETL, Pro C, PL/SQL side.

. Functional end to end integration solution design using TIBCO,

Informatica.

. Strong functional/technical capabilities in ORSIM, ORWMS, RMA, ORPOS.

. Technical experience in Oracle Form, Pro C, C, PL/SQL, Unix shell scripts

etc.

. Technical experience in Java, J2ee, Struts, Spring, Ajax, Java Scripts

etc.

. Experience on Java GUI development side like Applet, AWT, Swing etc.

. Worked on advance technologies like load balancing, clustering etc.

. Worked on estimation, technical templates, code templates design etc.

. Worked on complete SDLC life cycle of projects like

analysis/design/development etc.

. Excellent communication and documentation skills and is able to work

individually as well as a team member.

. Adaptable and able to work under pressure.

. Good at influencing, leading, negotiating and delegating

EDUCATIONAL QUALIFICATION:

. ME (Master of engineering): From Jadavpur University, Kolkata, in

Mar'2003 with percentage of 79 under same university.

. BE (Bachelor of engineering): From Motilal Nehru Regional Engineering

College, Allahabad in 2000 with percentage of 77 under Allahabad

University in Computer science and Engineering.

TECHNICAL SKILLS:

Oracle Application (RETEK) : ORIB, ORMS, OReIM, ORPM, OReSA, ORSIM,

Allocation, RTM

Languages : Java, C, C++, XML, C#.

Technologies : JDBC, J2EE, HTML, AJAX, Stax, Java script,, Spring, JSF,

Struts, Hibernate, Java GUI (Swing),XML,XSLT,HTML,

CSS, XSLT, PL/SQL, ZXTM(Load balancing product) etc.

Databases : Oracle 9i, SQL server.

Operating Systems : Windows NT/2000, Windows 95, Linux, IBM AIX.

Web /App Servers : Tomcat, Web Logic 8.x, Oracle Application server.

Designing Tools : Design Pattern, UML diagram.

Other Technology : Oracle Retail Application ERP, Pro C,

Oracle Form

Professio0nal experience:

Client: JCPenney Company, Inc., USA

April 2013 to Till Date

Role: Integration Lead

Project: JCPenney Oracle Solution.

Description: This project involves the implementation of Oracle solution

for current invoice matching, allocation, sales audit and price management

modules. It also include the integration solution of these application

with other legacy system like financial system, general ledger, Point of

Sale, JCP.COM, Cash Room, ITSA.

As a solution architect my responsibilities are taking care of all Oracle

Retail implementation activities. Involve in Oracle Application design of

Foundation Data Invoice Matching . Also doing the solution design of

Integration between legacy system and these oracle retail applications

using Oracle Retail Integration bus, batch design and development (Pro *C)

and RETL.

Responsibilities:

. As a Consultant working with Client on OReSA solution and involve in :

o Functional Specification Document

o Configuration documents for Totals, Rules, GL entries etc.

o Technical Design Documents

o Implementation and testing

. As an Integration solution lead working on inbound integration of POS

systems and OReSA. Working on outbound integration between OReSA and

downstream system.

o High level solution design.

o Functional Specification Document

o Mapping documents

o Technical Design Documents

o Implementation and testing.

Environment: TIBCO, Informatica, Pro C, ORIB, ORMS, OReSA, PL/SQL, Advance

Queue, Pro C, Oracle Form..

Client: Ahold USA Inc, USA

Dec 2008 to April 2013

Role: Consultant

Project: AHold Retail Implementation for NextGen

Description: Here we are doing Oracle Retail implementation for this 3rd

largest retail company. Solution involve the highly customization of retail

ERP products. Solution includes the integration requirement between these

application and other legacy system like financial, PIM, Vendor management

etc.

Responsibilities:

. As a business Consultant working with Client on Different Cost and Deal

related Gaps and their resolution and involve in .

o Functional Design Document

o Gap Functional Design and Estimates

o Technical Design Documents

o Implementation and testing

. As a Consultant worked on ORMS, ORPM,OReIM and Allocation involve in

o Functional Design Document

o Gap Functional Design and Estimates

o Technical Design Documents

o Implementation and testing.

. As an Integration Lead I was leading a team of 4 people.

. Capturing and analyzing the Integration requirement of and design of

following FDDs.

o Store Inventory integration

o Finance Integration

o OReSA Integration

o RPM Integration

o OReIM

o Cost and Deal and Stock Ledger

. Designing of the TDD of Integration interfaces of the following.

o . Finance Integration (OReSA, Cost and Deal, Stock Ledger,

Foundation Data OReIM)

o Fundation data and Store Inventory Integration

o RPM integration

o Development and Unit Testing

Environment: OReIM, ORMS (Cost and Deal, Stock Ledger, Purchase Order and

Replenishment), ORPM, Oracle Retail Invoice Matching (OReIM), Oracle

Allocation, Retail Integration (ORIB), batch design and development (Pro

*C) and RETL.

Client: Super Value Supermarket,USA

May 2007 to Dec 2008

Role: As Project leader

Project: Oracle Solution

Description: SuperValue (Shaw) is an international group of quality

supermarkets based in the United States. Project involves the development

of Oracle Retail applications for it in U.S. System also provides near real

time data integration between Oracle RMS and legacy applications and

indirectly supporting all users of the system.

Responsibilities:

. As an Integration Lead I was leading a team of 4 people.

. Capturing and analyzing the Integration requirement of and design of

following FDDs.

o Foundation Data Integration

o Store Inventory Integration

. Designing of the TDD of Integration interfaces of the following.

o Item interface from External system to ORMS

o Vendor Integration

o Integration of EDI invoice to OReIM and ORMS

o Integration of Regular, Clearance and Promotion to ORMS

. Development and Unit testing (Test case preparation too) of following

interfaces

o Export GL chart of account to ORMS

o Export of Audited Sales data from OReSA to ODS

o Export of Sales from OReSA to SIM.

Environment: Retail Integration (ORIB), batch design and development (Pro

*C) and RETL

Client: BT B2B, BT a UK based company

Oct 2006 to Apr 2007

Role: Infrastructure Designer, Developer

Project: BT B2B- Flow Control

Description: Here flow control is introduced in BT B2B gateway. For

controlling this flow ZXTM is design and developed. ZXTM is a Script

language (like a Perl). It provides a lot of facility like load balancing,

bandwidth management, Flow control, security etc. to our network traffic.

Responsibilities:

. Design the solution and provided the low level diagram for application.

. Developed the software using ZXTM.

. Write test cases and execution of it.

Environment: ZEUS, Linux, ZXTM 4.1 a load balancing products.

Client: BT, UK based company

Aug 2006 to Oct 2006

Role: Analyst, Designer, Developer

Project: Knowledge Repository BT site

Description: Knowledge repository is a part of a big project BT.COM. Here

knowledge repository is used to maintain information and resources for

BT.COM..

Responsibilities:

. Analysis of application and designing of use cases to get the details.

. Design the solution and provided the low level UML diagram for

application.

. Developed the software using Java,j2ee, Java Scripts, Ajax, Ejb,

Struts.

. Developed exception, logger frameworks for entire projects.

Environment: UML2.0, Struts, J2EE, AJAX, XML, SQL Server, Windows 2000, MS

SQL Server, Tomcat5.1.

Client: Mansion.com, Singapore

Nov 2005 to July 2006

Role: Analyst, Designer, Developer

Project: Mansion project

Description: Mansion is a Singapore based Casino (Betting) company. This

management software includes all functionality of betting modules to be

implemented using Java/J2ee/Struts/Spring etc.

Responsibilities:

. Analysis of betting module of application and designing of use cases to

get the details.

. Design the solution and provided the low level UML diagram for entire

betting application.

. Developed the software using Java,j2ee, XML, XSLT, Java Scripts, Ajax,

EJB, Struts, Spring.

. Developed exception, logger frameworks for entire projects.

. Write test cases and execution of it.

Environment: UML2.0, J2EE, XML, XSL, Java Script, JSF, Spring, Hibernate,

Struts, AJAX, Windows 2000, MS SQL Server, Bea WebLogic, PL/SQL.

Client: BITS-Pilani

July 2004 - Nov 2004

Role: Project Developer

Project: BITS Virtual University

Description: This VU project envisages the design and development of

multimedia course that is web-enabled that goes towards the curriculum of a

full-fledged degree program. This enables people who are off-campus to

avail of the facilities offered to a normal on-campus student registered

under the same program. The advantage of this concept of VU is that

students can get a degree from BITS, while being off-campus.

Responsibilities:

. Analysis of application and designing of use cases to get the details.

. Design the solution and provided the low level UML diagram for

application.

. Developed the software using Java,j2ee, Java Scripts, Ejb, Struts.

Environment: HTML, JavaScript, JSP, Servlets, EJB, JSP, JDBC, RMI, AJAX,

Struts, Windows 2000, MS SQL Server, Bea WebLogic.

Client: BITS-Pilani

July 2004 - Mar 2005

Role: Project Developer

Project: Knowledge transfer system

Description: The BITS Technology transfer portal aims at being a commercial

medium for knowledge sharing and transfer. It aims at building a portal

where users can post new products/solutions and as well share the existing

knowledge base, distributes geographically, for their best advantage by

joining the discussion groups and online communities.

Responsibilities:

. Analysis of application and designing of use cases to get the details.

. Design the solution and provided the low level UML diagram for

application.

. Developed the software using Java,j2ee, Java Scripts, Ejb, Struts.

Environment: UML2.0, JSP, Servlets, EJB, JSP, Struts, Spring, JSF,

Hibernate JDBC, RMI, Windows 2000, MS SQL Server, Bea WebLogic.

Client: Kolkata Telephone Exchange

Jan 2003 to July 2004

Role: Developer

Project: Customer management

Description: Customer management is environment whereby customers are

provided access via login id's and passwords. Depending on their account

level they may be able to make online request for new connections(for new

customer guest login), see details for their calls, see details for a

customer based on its phone no, his billing information etc.

Responsibilities:

. Analysis of application and designing of use cases to get the details.

. Design the solution and provided the low level UML diagram for

application.

. Developed the software using Java, JDBC, Java Thread.

Environment: Servlet, JSP, JDBC, Java Thread, SQL.

Client: Colossal Software Technologies Pvt. Ltd.

August 2000 to July 2001

Role:

Project: UML creation tool

Description: Creating an UML by knowing its plain text requirement.

Responsibilities:

. Analysis of application and design the solution and provided the low

level UML diagram for application.

. Developed the software using Java, Servlet, EJB, Java Thread.

Environment: Java, Servlets, EJB, SQL

Contact this candidate