Oracle Project
Resume:
Utpal Kumar Das
Email: ********@*****.***
Phone: 469-***-****
Experience Summary
Around 10+ years of strong IT Experience, this includes 8+ years as Techno-
Functional Consultant in Oracle Retail Applications (RMS, ReSA and RPM) and
2+ years as Oracle PL/SQL and Forms Developer in ERP (Production Module)
domain. Worked on 2 successful full life cycle Oracle Retail implementation
projects and worked also as a part of Oracle Retail Sustaining Engineering
team (Bug Fixing and Enhancement) in Oracle Corp. Extensive experience in
requirement analysis, design, development, testing and implementation of
various Oracle Retail Modules.
. Over 10+ years of IT experience with proven expertise in Software
Development Life Cycle including Requirement Analysis,
Design, Development, Unit Testing, and Implementation.
. Almost 8 years of experience in retail domain, mainly with Oracle
Retail Products
. Sound Techno-Functional Knowledge in the following Oracle Retail
modules - RMS (Retail Merchandising System), Sales Audit (ReSA), RPM,
Allocation and various new client specific customized functionalities.
. Solid project experience in customization and implementation of Oracle
Retail Merchandising System (versions 13, 12, 11 and 10), ReSA and
RPM.
. Involved in three implementations of Oracle Retail Projects.
. Worked on Bug Fixing, Development and Enhancement of Oracle RMS V10,
11 and 12, while being as a part of Sustaining Engineering team in
Oracle India Pvt Ltd.
. Proficient technical skills in Oracle PL/SQL, Oracle Forms and
Reports, Pro*c, UNIX Shell scripting and Oracle databases.
. Experienced in all phases of the software development life cycle and
defect life cycle.
. Possesses strong analytical and problem solving skills.
. Experience in communicating with customers, business and technical
groups and quality analysts during various stages of the software
development life cycle.
Technology
Below is a list of important hardware, software products, tools and methods
that I have worked with.
Hardware / Technology Tools Languages Database
Operating
System
UNIX Oracle Retail Oracle SQL Oracle
(HP and AIX) Application Forms/Reports PL/SQL 9i/10g
Windows Suite. 9i/10g Pro*C
(NT/XP) (Module : RMS, FTP Tools
ReSA, RPM and TOAD
Allocation) PL/SQL
Developer
Qualifications
Degree and Date Institute Major and
Specialization
Master Of Computer Tezpur Central Computer Application
Application, University, Tezpur,
Yr. 2003 Pass out Assam
Bachelor Of Science, Gauhati University, Statistics(M),
Yr. 2000 Pass out Gauhati, Assam Physics and
Mathematics
Project Details:
A. JC Penney
Tenure of service: Jan 2014 - Till Date.
Role: Oracle Retail Managing Consultant
Working Domain: ERP-Implementation / Enhancement
Assignments
# 1
Project Oracle Retail V13.2.x Implementation
Customer JC Penney
Period Jan-2014 to Till Date
Description JCPenney has chosen to implement Oracle
Retail Application Suite that will replace
the JCPenney's complex IT Landscape of
merchandising applications on the legacy
systems. This new system will position
JCPenney to become America's Favorite Store
by streamlining operations, reducing
redundancy and improving the cross-channel
customer experience which will enable
efficient merchandising operations management
and more accurate planning and optimization.
The project will be implemented in multiple
phases and has involved many areas of the
business. Presently, only the foundation data
and Planning Applications has gone live and
next planned schedule is to go live with
Items management, Pricing and Sales Audit. I
am working on the Item management and pricing
module including conversion and Back fill to
legacy systems.
Responsibility As an Oracle Retail Managing Consultant,
My Responsibilities involves :
Liaise with Business and BA to gather
Business Requirement and feasibility
analysis.
Preparing Solution/Functional design.
Involvement in Build & Unit Testing cycle.
Support testing team in System testing and
Integration testing.
Understanding the business process and the
legacy systems used.
Develop Procedures, Checklist and guidelines,
as necessary.
Interface Design between various legacy
systems.
Solution Oracle Retail Application 13.2.x
Environment Oracle 11g Database
B. TATA Consultancy Services
Tenure of service: May 2010 - Jan-2014.
Designation: Assistant Consultant
Role: Senior Solution Designer.
Working Domain: ERP-Implementation / Enhancement / Production Support
Assignments
The details of the various assignments that I have handled are listed here,
in chronological order.
# 1
Project RMS 10 Enhancement
Customer Sainsburys
Period Dec-2012 to Jan-2014
Description Sainsbury's, the third largest chain of
supermarkets in the United Kingdom using RMS
V9 (For Grocery) and RMS V10 (For Non-Foods)
as their core merchandising activities.
Executed the below two projects:-
1). RMS Release 2 Enhancement project, which
encompasses enhancing RMS replenishment
process, Truck Splitting and Scaling
functionality, RMS to RSS Delivery status
interface and External Allocation upload.
2). Faster Simpler Clearance and Promotion,
which encompasses enhancing clearance and
promotion screens with CSV upload facility,
Customization to create generic advertising
linked to clearance and promotion and
enabling stores print adverts.
3). Worked on proposal of Consignment &
Concessionaire project, which requires
enabling Consignment functionality in RMSV10
to fit Sainsbury requirement and
customization to introduce concessionaire
functionality(As, RMSV10 doesn't have
concessionaire functionality).
With Non Foods growth set to continue, the
Non Food Transformation programme is an
ongoing portfolio of projects focussed on
either fully utilising RMS V10 functionality
or creating new functionality in order to
meet operational growth requirements. RMS V10
Release 2 is one of these projects.
Responsibility As an Oracle Retail Senior Solution Designer,
My Responsibilities involves :
Liaise with Business and BA to gather
Business Requirement and feasibility
analysis.
Functional Requirement Analysis and
Estimation.
Preparing Solution/Functional design.
Support offshore team on preparing technical
design documents for custom developments.
Leading the development team and support
offshore team in Build & Unit Testing cycle.
Support testing team in System testing,
Integration testing and UAT.
Interface Design between various systems.
Solution Oracle Retail Application 10
Environment Oracle 10g Database
# 2
Project Lifestyle Oracle Retail Impl.
Customer Lifestyle India Pvt. Ltd.
Period MAY-2010 to DEC-2012
Description Lifestyle India implements Oracle Retail
Application Suite to support the growth and
expansion of the company. Lifestyle has
chosen Oracle Retail Application suite
Version 12.0.10 IN (RMS, RPM, ReSA, ReIM,
OSIM and Allocation) with India Localization
feature, to support the India specific
taxation structure and also to execute a
broad range of core merchandising activities,
including item maintenance, inventory
replenishment and management, purchasing,
vendor management etc. India Localization
feature covers the functionality of Multiple
MRP and Configurable VAT concept mainly.
TCS executed the implementation project by
providing best solutions, to efficiently
bridge the gap of Lifestyles core business
processes and the standard core functionality
of the Oracle Retail Application.
Responsibility As an Oracle Retail Project Lead,
My Responsibility involves :
Attending Business Requirement Workshops
Functional Requirement Analysis.
Preparing Solution design
Preparing technical and functional design
documents for custom development.
Leading the development team and also
involved in coding and preparing Unit Test
Cases.
Unit testing, Integration testing.
Interface Design between various systems.
Solution Oracle Retail Application 12.0.10IN
Environment Oracle 10g Database
Achievements Achieved Best Program Delivery Award - TCS
Outpost 2011
C. Mahindra Satyam
Tenure of service: Mar 2008 - Apr 2010.
Designation: Project Lead
Working Domain: ERP-Implementation / Enhancement / Production Support
# 3
Project A&F Oracle Retail Impl.
Customer Abercrombie & Fitch, OH, USA
Period MAR-2008 to APR-2010
Description Abercrombie & Fitch implements Oracle Retail
Merchandising System that replaces the
current merchandising applications on the
legacy system. This new system will position
ANF for the future by streamlining processes,
reducing redundancy and improving ability to
support the growth and international
expansion of the company.
The project has been implemented in two
phases and has involved many areas of the
business. I was working on the phase 2
implementation of Oracle Retail RMS which
involves customization and implementation of
stock ledger, inventory management, Price
Management, Warehouse Management,
International, Sales audit, PO work room and
SL to GL Interface. Additionally, all
remaining merchandising programs on the
legacy system, which doesn't support by RMS,
will be converted to the new system.
Responsibility As a Techno-Functional consultant at Onsite.
My Responsibility involved :
Business Requirement Gathering.
Functional Requirement Analysis.
Understanding the business process and the
legacy systems used.
Preparing technical design documents for
custom development.
Leading the development team and also
involved in coding and preparing Unit Test
Cases.
Develop Procedures, Checklist and guidelines,
as necessary.
Solution Oracle Retail Application suite 13.0
Environment Oracle 10g Database
D. Oracle India Pvt. Ltd.
Tenure of service: Jul 2006 - Mar 2008.
Designation: Application Engineer
Working Domain: Sustaining Engineering / Enhancement
# 4
Project Sustaining Engineering, RGBU(Retail Global
Business Unit)
Company Oracle India Pvt. Ltd.
Period JUL-2006 to MAR-2008
Description The Product Oracle Retail Merchandising
System is a flexible, scalable, and proven
foundation from which to execute a broad
range of core merchandising activities,
including item maintenance, inventory
replenishment, purchasing, and vendor
management. Specifically designed to manage
complex merchandising activities in a global
environment and across multiple sales
channels, the Oracle Retail Merchandising
System incorporates three functional areas:
business foundation management, merchandise
management, and merchandise financial
tracking.
These core functional areas enable retailers
to perform crucial day-to-day merchandising
activities more efficiently, allowing for
greater focus on the key decisions that will
help you drive profit targets and lower
merchandising costs. The Oracle Retail
Merchandising System streamlines business
systems and unifies business practices across
the organization for increased profitability
and improved customer service.
Role As an Application Engineer, I was mainly
involved with the Development, maintenance
and enhancement done in Items, Pricing and
Sales audit Module for the Oracle RMS and
ReSA product. My role in the team was: -
Fixing of Bugs logged by customers.
New Enhancements done in the product with the
help of product strategy team.
Involved in designing, coding and testing of
the deliverables.
Providing technical and functional help to
the team
Helping the customer and team to resolve
critical issues.
Solution Oracle Retail Application suite V10, 11 and
Environment 12
Oracle 9i/10g Database
E. WIPRO Infotech
Tenure of service: Sep 2004 - Jul 2006.
Designation: Analyst Programmer
Working Domain: ERP-Implementation / Enhancement / Production Support
# 5
Project Ashok Leyland Enterprise System
Customer Ashok Leyland
Period SEP-2004 to JUL-2006
Description The Application software named as "Ashok
Leyland Enterprise System".
The Project involved, maintenance and
enhancement of "Ashok Leyland Enterprise
System", an ERP package developed for Ashok
Leyland, earlier. Ashok Leyland is a market
leader of commercial vehicles in India. Its
goals are to improve production efficiency,
access consolidated information easily to
improve internal processes, ensure high
availability eliminating single points of
failure, scale with at low incremental cost
and ease integration with indigenous
applications. Prompted by its desire to
consolidate systems and lower costs, the
company moved to an Oracle platform in 2001
and subsequently migrated to Oracle9i Real
Application Clusters and Oracle9iAS. Ashok
Leyland has developed a centralized ERP
system, which caters to their manufacturing,
financials, marketing, sales, exports and
distribution activities.
The ERP system has been implemented in Ashok
Leyland's six manufacturing units and 60
locations across India. ``This system
seamlessly integrates all the manufacturing
units providing a 360 degree view of the
entire organization," Now, Wipro has got the
project of enhancement of new modules and
maintenance of the ERP system.
Role I am responsible for developing of Exports
Module for the ERP system, which is a new
module incorporated. We, a team from Wipro,
are working onsite in Ashok Leyland for this
project.
As a team member, My Responsibility
Includes:-
Coding Application Programs using PL/SQL and
Oracle Forms based on functional design
provided.
Prepare Technical Documents.
Responsible for unit testing.
Solution Oracle 9i Database
Environment
F. CMC Ltd.
Tenure of service: Sep 2003 - Aug 2004.
Designation: Project Trainee
Working Domain: ERP-Implementation / Enhancement / Production Support
# 6
Project Bar-Code Online Product Tracking System
Customer Hindusthan Paper Corporation Ltd.
Period SEP-2003 to AUG-2004
Description Hindusthan Paper Corporation Limited is one
of the today's large Papers manufacturing
company in the India. HPCL's brands and
products are the focus of continual
innovation and renovation so that they meet
and exceed the consumer's expectations. HPCL
has a 24*7 hour plant and the plant is fully
dependent on our system and I was the only
resident engineer from CMC Ltd., posted out
there for maintenance of the application
software and the Database.
The application Software is named, as BROPTS
(Bar-coded Online Product Tracking System),
that provides full tracking of the product
starting from the parent roll Generation to
ream/roll despatch using barcode labels. The
main objective of the application Software is
to on-line tracking of finished and
unfinished products right from parent roll
generation to despatch. All the final
products have EAN-13 bar-coded product code.
That helps the customer in meeting the
government regulations on export of
commodities.
Role I was responsible for development of the
Distribution and Paper Machine Module and
also building some reports based on that. I
was also responsible for periodically take
the back up of the database, Recovery of the
database in case of failure also managing the
whole database
Solution Oracle 9i Database
Environment
Career Profile
Dates Organization Role
Jan-2014 - Till JCPenney (On Payroll of Oracle Retail
Date Dotcom Team LLC) Managing Consultant
May 2010 - TATA Consultancy Oracle Retail -
Jan-2014 Services Senior Solution
Designer
Mar 2008 - Apr Tech Mahindra (Formerly Oracle Retail -
2010 Mahindra Satyam) Project Lead
Jul 2006 - Mar Oracle India Pvt. Ltd. Oracle Retail -
2008 Application
Engineer.
Sep 2004 - Jul Wipro Infotech Analyst Programmer
2006
Sep 2003 - Aug CMC Ltd. Project Trainee
2004
Visas
Visa Valid Till
H1B Oct-2015
Contact this candidate