Post Job Free
Sign in

Project Oracle

Location:
9168
Posted:
February 16, 2011

Contact this candidate

Resume:

[pic][pic][pic]

NAVDEEP KUNDRA

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

SUMMARY

Techno-functional IT professional with 10+ yrs. of experience in local &

International markets (Middle East, UK, European, Eastern retailers). 8

yrs. of commendable experience in Oracle Retail ERP with various companies

[fashion, grocery, hypermarket, kiosks, franchisee ops, pvt label etc.]

Demonstrated skills in technology, processes & people management to achieve

Business Systems efficiencies. Skilled in utilizing quality processes for

continuous improvement [specifically SIX SIGMA] and project management [PMI

methodologies]. Set up change control processes, RTS reduction [support

time], resource utilization analysis and been part of rolling out ITIL

processes.

Strong in building teams to achieve faster results with stable &

predictable deliveries. Skills to align business processes with IT effort

available & align IT deliverables as per corporate priorities

Have worked extensively with Sr. Executives from business and C[x]O level

management teams. Have been part of corporate level evaluations on engaging

into new projects or taking tough calls to withdrawal / suspension of

approved projects. Managed a team size of 45 (in house + external

consultants). Managed projects worth Total CAPEX of USD 100K - USD 10 Mn.

Enhanced learning & deliveries @ key implementations / organizations

(Infosys, TESCO, GE, Accenture, Nordstrom, GAP, Karstadt, Landmark Group,

Kamal Osman Jamjoom etc.)

Have been part of 3 end to end Oracle Retail implementations (v10,12) and

program managed one of the most successful implementations in Middle East

for Oracle Retail v12, Oracle EBS (Financials) v11, HRMS (Payroll).

Additionally have worked on 14 different projects in Oracle Retail ERP

CORE EXPERTISE

. Oracle Retail ERP - Oracle Retail (v 9 to v13)

o Expertise (Tech/Func): RMS, ReSA, WMS, ReIM, Allocation, RPM,

RIB, RTM, Batch

o Exposure : SIM, RDW, MFP, POS, RDW

. Project Managed Oracle EBS (Financials) and Oracle HRMS

implementations

. Very good understanding of Supply Chain processes, Inventory Mgmt,

Purchasing, PLM, Order management, Warehousing.

. Retail Domain knowledge

. Conducting CRP sessions

. Process setups, review & improvements for retail business / IT

. Requirement Gathering, Analysis & Solution Design in a single / multi

system environments

. System Integration, Data Migration, Testing, Trainings and QA

(technical & functional)

. Vendor selection and management

. Global IT Experience [companies US, UK, EU, Middle East, Far East,

India]

. Change management - Business influence & IT influence to optimize IT

systems without compromising maintainability

. Processes / Methodologies roll out[Six Sigma, PMI, ITIL]

. Worked in onsite, off-site, multi-site environments

. Technical skills in Oracle PLSQL, Unix, Pro*C, D2K etc. (Client-Server

Tech), RIB,OBIEE

. Expertise in tools e.g. TOAD, MS Project, MS Visio

. Experienced in setting up & using schedulers like Control-M, CA-

Autosys, Maestro & Appworx, Cron

PROFESSIONAL EXPERIENCE

1. Third Party Warehouse Implementation

Company/Client : Landmark Group

Duration : May'09 to Apr'10 Team Size : 5

Platform : D2K, UNIX, Shell Scripting, Oracle SQL / PLSQL, RMS,

RIB, WMS

Role : IT Project Lead

Overview : Landmark corporate selected Oracle retail as an enterprise

application for all its operations. It included Oracle MOM suite (RMS,

ReSA, ReIM, RTM, RPM, RA), SIM, ORWMS, ORDW, OBIEE. One of the businesses'

automation needs required third party WMS system to be implemented for PTL

operations and for multi-sku storage / handling operations.

The system implementation required integration of third party WMS (RDS) to

integrate with Oracle Retail MOM, ORWMS systems where the inventory was

managed by RMS. Due to complexity of both the systems complete solution was

delivered through interface design and a completely non-intrusive solution

was delivered along with near real time integration.

The unit through put was significantly increased with turnaround time of 36

hrs was reduced to 10 hrs.

2. System Stock Accuracy

Company/Client : Landmark Group

Duration : Jan'10 to Jun'10 Team Size : 4

Platform : D2K, UNIX, Shell Scripting, Oracle SQL / PLSQL, RMS,

RIB, WMS

Role : Project Lead

Overview : The warehouse application since went live in April 2008

has been having the issues of inventory accuracy w.r.t stock visibility to

buying / merchandising vs stock visibility to warehouse teams; causing loss

of sales opportunity, over stocking at stores along with massive issues in

inventory reconciliation.

The project was done in different phases of DMAIC methodology (Design,

Measure, Analyse, Improve and Control). The inventory accuracy was measured

to be very low in the range of 85-87% between the systems vs physical

accuracy of 98% and above. The project measured and analysed the issue in

business processes and some bugs in IT systems. The real issue was

diagnosed to be change management & training where users due to ignorance /

due to easy bypass were not following the process. The resistance was due

to some system controls that needed users to follow processes in multiple

steps. The subprojects were launched with focus on process enforcement, re-

training, IT fixes and control. The control mechanism was put in place that

checks system accuracy 2 times in a week and provides individual item level

discrepancy.

The inventory accuracy between the systems increased from 87% to 99.58%

within 4 months and physical stock accuracy to 99.49%. 6 months in a row

business achieved 100% fulfilment from WH to store.

3. Support & Maintenance

Company/Client : Landmark Group

Duration : May'09 to Feb'11 Team Size : 15

Platform : D2K, UNIX, Shell Scripting, Oracle SQL / PLSQL, RMS,

RIB, WMS, Java, Pro*C, OBIEE

Role : Support Lead

Overview : Managing support & upgrades of Oracle Retail - legacy

retail applications (800+ stores, 7+ brands, 10l+ countries)

4. Oracle Retail Implementation

Company/Client : Landmark Group

Duration : Jan'10 to Feb'11 Team Size : 4

Platform : D2K, UNIX, Shell Scripting, Oracle SQL / PLSQL, RMS,

RIB, WMS, Java, Pro*C, OBIEE

Role : Subject Matter Expert / QA Lead

Overview : Working multiple roles to up skill teams (Tech Arch, QA,

Functional Trainer and Project Consultant for PMO activities)

5. Auto Replenishment

Company/Client : Landmark Group

Duration : Mar'10 to Jun'11 Team Size : 2

Platform : D2K, UNIX, Shell Scripting, Oracle SQL / PLSQL, RMS,

Role : Subject Matter Expert / QA Lead

Overview : Create bespoke replenishment for legacy application (WH to

Store) using the similar logic of Oracle Retail Replenishment ensuring when

legacy is converted during implementation, the process is already in place.

6. Oracle Retail Implementation & Support

Company/Client : KOJ

Duration : Jan'07 to Apr'09 Team Size :

16

Platform : D2K, UNIX, Shell Scripting, Oracle SQL / PLSQL, RMS,

RIB, WMS, MOM, Java, Appworx etc.

Role : Project Manager

Overview : KOJ selected Oracle retail as an enterprise application

for all its operations. It included Oracle MOM suite (RMS, ReSA, ReIM, RTM,

RPM, RA), SIM, ORWMS, ORDW, OBIEE. The project was delivered on-time,

under budget with support of Implementation partner. It involved rolling

out of MOM suite to all the businesses of head office (one go-live) and 2

warehouses (1 UAE, 1 KSA). This is one of the very first pure Vanilla

implementations of Oracle retail and the most successful as well. The

project delivered in a record time also provided on version of truth for

business to manage i.e. stock position of all the stores visible by end of

the day to the business teams for their quick decisions. The project was

done in collaboration with systems integrator with only ONE experienced

Oracle Retail hiring. Change management, Service transition to support was

managed in-house. One of the exceptional achievements on the project was

Legacy integration with ORIB and trickle polling from legacy stores, no

mass uploads. WMS ROI was 150 days.

7. Business Reports (OBIEE)

Company/Client : KOJ

Duration : Sep'08 to Mar'09 Team Size : 3

Platform : UNIX, Shell Scripting, Oracle SQL / PLSQL, Oracle

Retail v12 (WMS, MOM), OBIEE, Appworx etc.

Role : Project Lead

Overview : KOJ project plan included installation of RDW (for data

capture) with delayed implementations. In year 2008 Oracle roadmap of OBIEE

influenced KOJ's decision of replacing planned Micro-Strategy

implementation with OBIEE. The project was a challenge due to lack of

skills with OBIEE and oracle retail in addition to Oracle din't support

OBIEE on v12. The project was delivered by learning OBIEE with trial and

error, additional remote / web training on OBIEE. The internal IT team

played the role of BA, capturing the requirement, validating, sign-offs and

implementation of OBIEE for business in 2 phases (Operational reports &

Analytics). The project was exceptional with ROI in weeks due to miniscule

investment of USD 3000/- for training & no external consultant.

8. TESCO 10AL

Company/Client : TESCO

Duration : Mar'06 to May'06 Team Size : 5

Platform : D2K, UNIX, Shell Scripting, Oracle SQL / PLSQL,

Oracle Retail v10(RMS, RIB, MOM) etc.

Role : Project Lead

Overview : TESCO International required Asia localisation for their

implementation in China & Japan. The work involved language and process

localisation of RMS to meet the requirements of specific geography. The

core technical work involved reviewing the requirement document, convert

the same to Tech design, discuss it through multi-site team and deliver the

code pack after unit testing to QA.

9. GAP FP

Company/Client : GAP

Duration : May'06 to Jul'06 Team Size :

4

Platform : D2K, UNIX, Shell Scripting, Oracle SQL / PLSQL,

Oracle Retail v11 (WMS,RMS, RIB, MOM) etc.

Role : Project Lead

Overview : GAP inc decided to move from their Oracle Retail v10g

(version 10 for gap) to version 11. As part of this move all the mods / bug

fixes done for GAP Inc. in v10 had to be forward ported to v11. The project

was to identify,design, code and deliver those mods.

10. Karstadt Kompact

Company/Client : Karstadt Kompact

Duration : Jul'06 to Dec'06 Team Size :

6

Platform : D2K, UNIX, Shell Scripting, Oracle SQL / PLSQL,

Oracle Retail v11 (WMS, RIB, MOM) etc.

Role : Project Lead

Overview : Karstadt Kompact went independent from the parent company

and decided to implement oracle retail v11. The project involved

participating the client calls along with Accenture consulting and document

client requirements. Build SAE document for Solution Approach and

Estimation to be reviewed by client for acceptance. The back ground work

involved validating the existing application features against user

requirement, identifying the Gaps and proposing the workaround as well as

the solution.

11. Support Transition from Korea

Company/Client : TESCO

Duration : Jun'04 to Dec'04 Team Size : 4

Platform : D2K, UNIX, Shell Scripting, Oracle SQL / PLSQL,

Oracle Retail v10 (MOM) etc.

Role : Sr. Sytems Analyst

Overview : TESCO korea was the first implementation of Oracle Retail

in the group. The project phase-1 was already live and supported by local

Korea team. A team of Oracle Retail experts and technology experts

travelled to korea for a period of 4 months and build a transition scope,

support model and handover plan. The project of 3 months of study, 1 month

shadow and 2 months offloading allowed TESCO to release experienced Korean

team for other Retail implementation projects in the group.

12. TinaB implemtation Turkey

Company/Client : TESCO

Duration : Jan'05 to Sep'05 Team Size : 7

Platform : D2K, UNIX, Shell Scripting, Oracle SQL / PLSQL,

Oracle Retail v10 (MOM), Biztalk, Retalix etc.

Role : Team Lead

Overview : Based on initial learning's from Korea implementation,

Tesco designed and implemented the first model for reducing implementation

time. The model TinaB (Tesco In A Box) was designed to achieve implement

once, replicate many times. The model further was refined later on to TOM

(Tesco Operating Model). In TinaB implementation a total of 12

nationalities from 5 different companies working for 4 different sites came

together to implement 1st store of Tesco Turkey (kipa) in a period of 1+

yrs. The specificities of the implementation were removing of RIB with

Biztalk, store systems from Retalix. The model also had a built in

transition plan for HSC team support handover. Many control mechanisms were

built in and included into the model.

13. YEC conversion

Company/Client : TESCO

Duration : Oct'05 to Mar'06 Team Size : 7

Platform : D2K, UNIX, Shell Scripting, Oracle SQL / PLSQL,

Oracle Retail v10 (MOM), Biztalk, Retalix etc.

Role : Team Lead

Overview : Based on the decision from TESCO board all countries had

to comply with 5-4-4 calendar. The Korean implementation and Turkey

implementation done before the decision were on regular Gregorian calendar

and the decision required a massive change / within the system migration /

re-built of data for past and changes in stock ledger processes. The

project was executed in parallel for both the countries led by one common

PMO and having reusable components.

14. Tech Channel

Company/Client : GE

Duration : Feb'03 to Mar'04 Team Size :

10

Platform : HP-Unix, Pro*C, PL/SQL, Maestro, COBOL, ProCobol, VB

6, Shell Scripts, awk

Role : Project Lead (Offshore)

Overview : The project is to modify / remove Tech Channel Contract

(warranty contracts sold by technicians at consumer's place) creation from

HBI Legacy system. This project provides business benefits by way of faster

contract creation. (3-4 days vs. 12-16 hrs). Minimum intervention by Tech

for contract creation by having all calculations reference data on system &

eliminated reference papers (Tech motivated by friendly front-end). Legal

benefits include restricting the sale of contract and control on tax by

system, not relying on Technicians awareness. Financial benefits include

elimination of manual processing of paper checks, cash $$. Avoid under-

price sales (potential to save $$ 250,000 annually).

15. Warranty Contracts BULL Exit / GE Appliances

Company/Client : GE

Duration : Sep'03 to Dec'03 Team Size :

8

Platform : HP-Unix, Pro*C, PL/SQL, Maestro, COBOL, ProCobol, VB

6, Shell Scripts, awk

Role : Project Lead (Offshore)

Overview : The applications for warranty management had historically

been running on HONEYWELL provided BULL system having its own language /

database and OS. The project was to migrate the application from legacy

technology to Unix / Oracle Based systems. This project provided business

leaders to control commissions rates for contract sale by technician

(controllership), selling more variety of contracts (more $$ / better

service), commission reporting for tech on web (saving time for queries),

reduced dependencies on HBI (saving in $$ due to costly support).

16. Tech Channel Commissions Control / GE Appliances

Company/Client : GE

Duration : Sep'03 to Dec'03 Team Size :

8

Platform : HP-Unix, Pro*C, PL/SQL, Maestro, COBOL, ProCobol, VB

6, Shell Scripts, awk

Role : Project Lead (Offshore)

Overview : The project was to drive more control / visibility on

commissions for Tech Channel Contract Creation & take that out of HBI

Legacy system. (25% of project out of HBI)

17. OXYGEN (NORDEI) / NORDSTROM INC, USA

Company/Client : GE

Duration : Sep'00 to May'02 Team Size :

80

Platform : SunOS 5.6 ( Unix shell scripts), WinNT / Pro*C,PLSQL, TOAD, Syncsort, C, D2K, SCCS

Role : Software Engineer / Module Lead

Overview : Conversion of the merchandise system from a legacy system

to an ORACLE based RMS (Retek Merchandising System). The project was a five

phase project for RETEK Implementation.

a. Setup SKUs. b. Create Orders c. Capture Sales

d. Integrate PKMS and RMS. e. Integrate Merchandise planning and

RMS, RMS stock ledger and GL.

Redesign of merchandising application for ORACLE based system. Preparation

of the software background for RETEK, to support and interface legacy DATA

and applications. Implementation of RETEK packages RMS and RDW (Retek

Data-Warehousing) for the client. RMS package allows the client to create

and maintain their Purchase Orders, Merchandise Price Management. The

project also helped Nordstrom to have a greater visibility on Perpetual

Inventory, helping Nordstrom employees having greater and faster access to

find items on hand and their location. The RMS-based application will

replace current ordering systems (POMR), Price Change System, Book

Inventory (Stock Ledger) system and Merchandise Transfer system. RDW is a

data-warehousing tool generates reports from RMS data. The project was the

one which received EXTERNAL CUSTOMER DELIGHT AWARD in the year 2002.

EARLY CAREER

. Sep 1999 - Sep 2000: Trainee Engineer

TRAINING / CERTIFICATIONS

. Six-Sigma DMAIC & DFSS - General Electric Company (GE)

. Basics of Effective Communication & Achieving personal Goals - GE

Croton Ville

. Applying Leadership Basics from GE India Corporate Learning Services

. More than 40 Self Improvement courses from Quicknowledge / SkillSoft

. PMI Methodologies, ITIL Foundation

. Trained on Unix, PLSQL/SQL, Oracle DB, C, Pro*c, Oracle Forms /

Reports, Java, OBIEE

OTHER INFORMATION

LOCATION: Dubai, U.A.E.

EDUCATION: Bachelor of Technology (B.Tech)

Higher Diploma in Software Engineering (HDSE)

EPBM from IIM Calcutta

MARITAL STATUS: Married

PHONE: +971-**-*******



Contact this candidate