Project Oracle

Aniket J. Gharat.

Local address -: New York, USA

Mobile Number: - +1-530-***-**** / +44-745*******

Permanent address -:

***, ***** ******* *****, ********** Road,

Near railway station, Virar (East),

Tal -: Vasai, Dist -: Thane, 401303

Mobile no: - +91-988*******

Email: - ******.******@*****.***

Summary I have 5.4 years of Technical & Functional experience in Oracle

Retail (RETEK). Especially I have worked with Retail Merchandise

System (RMS), Retail Integration Bus (RIB) and Retail Data

Warehouse (RDW) modules. I also hold good experience in PL/SQL,

SQL, Pro*C, Forms and oracle database concepts and Unix. I have

good experience in using Appworx/UC4 Scheduling tool as well,

which is mostly used for scheduling batches of Oracle Retail

application. I also hold good written and verbal communication

skills. I have good team leadership skills and invariably meet

client expectations. Currently I am working with Oracle Solution

Services India Pvt. Ltd. as a Consultant, and have experience in

implementation, Support and Maintenance projects.

I had worked with Morrisons, Apoteket, Landmark, Nakheel

RetailCorp, Kamal Osman Jamjoom clients and currently I am

working with Saks Inc client, Many times I got appreciation mail

from clients about fast responses, analysis and solutions to

problems.

COMPETENCIES

Category Major Skills - Primary Minor Skills - Secondary

Verticals RETAIL UTILITIES

Domains / RMS, RIB, RDW, SQL, PLSQL, SIM, ORACLE REPORTS, CORE JAVA,

Programming Skills ORACLE FORMS, Pro*C, UNIX JSP, SERVLET, EJB (Enterprise Java

SCRIPTING Beans), J2EE(struts, hibernate)

(As Applicable)

Tools & Techniques Blue Print Foundry(BPF),

Appworx / UC4

Databases Oracle 9i/10G/11G SQLSERVER 7

Software Tools TOAD,SQL Developer, Oracle Developer 6i, 2000 (Forms &

Forms Developer 10g Reports), Eclipse

Operating Systems Windows 98 onwards, UNIX LINUX

EXPERIENCE SUMMARY

Category Description No of Projects

Role Software Engineer 6

Lifecycle 6

Development & Support

PERSONAL ACCOMPLISHMENTS

Degree/Certification/Publication Year of Passing -

(If applicable )

Academic pursued B.E. in Computer Engineering

Qualification with First Class from Pune University 2007-08

pursued Diploma in Computer

Technology with First Class from 2005

Mumbai University

Certifications, OCA (Oracle Certified Associate) 2010

Scores Developer Track

Development Programs

(Training Undergone) SQL, PLSQL, Unix, PROC*, Oracle Forms

& Reports, Java, Oracle integration &

interface, OBIEE, Oracle

Retail(Retek) Functional Training

Languages Known English, Marathi, Hindi

Client / Team Effective solution designing,

Feedback analysis, testing and fast responses

Awards Special Recognition GEM Award by 2011 & 2012

Oracle 2012

Performer of the Month Award

PROFESSIONAL EXPERIENCE

Employer Name - Oracle Solution Services India Pvt. Ltd., Bangalore

Project / Client Name / Location - Saks Inc Design / Saks Inc. / New York, USA

Duration: Jan 2013 to Till Date

Technologies - RMS, RIB, SIM, PL/SQL

Project Profile:

Saks Incorporated is a Fortune 1000 operator of high-end department stores in the

United States under the nameplate Saks Fifth Avenue, corporate headquarter is in

Midtown Manhattan, New York City. Saks is known for being a luxury retailer and

operates 45 Saks Fifth Avenue stores, 61 Saks Fifth Avenue Off 5th stores and the

ecommerce site saks.com. It competes with high-end specialty stores in the Upper

East Side of Manhattan, notably Bergdorf Goodman, Barneys New York, and

Bloomingdale's; it also competes with luxury retailers Neiman Marcus and Lord &

Taylor.

Role: On-site Team Member

Contribution / Highlights :

As a team member I was actively involved in the below phases of project :

Gap Analysis, solution design on the various RMS modules.

Researched and resolved base RMS, RIB issues.

RMS, SIM & RIB testing for various scenarios.

Worked with team members to determine the pros and cons of various approaches for

integration.

RMS Integration mapping with Legacy applications via RIB.

Design for implementing SIM in Warehouse.

Design for implementing offsite storage location for SIM Store.

RMS custom integration testing for release 1c.

Solving complex RIB integration issues.

Employer Name - Oracle Solution Services India Pvt. Ltd., Bangalore

Project / Client Name / Location - Morrisons / Morrison-Wipro / UK

Duration: 13 months from Dec 2011 to Dec 2012

Technologies - Oracle Forms, PRO*C, SQL, PL/SQL, Unix, RMS

Project Profile:

Morrison Supermarkets plc is the fourth largest chain of supermarkets in the

United Kingdom, headquartered in Bradford, West Yorkshire, England. Morrisons

currently has more than 455 superstores in the United Kingdom. Most Morrisons

stores operate from large superstores with a core focus on groceries and home

wares, with fewer electronics, clothing and furnishings than the company's main

supermarket rivals.

Role: Team Member

Contribution / Highlights :

As a team member I was actively involved in the below phases of project :

Up-gradation of RMS from 13.1.2.4 to 13.1.4.4 involving PRO*C batches, PLSQL

packages and customization.

Customization of RMS Forms.

Customization of RMS PRO*C batch programs.

Development of PRO*C Batch Programs.

Retrofitting/Backport for RMS patches involving modifications to PRO*C batches,

PLSQL packages.

Preparing installation scripts.

Testing of RMS customizations and reporting defects.

Detail document preparation for customization, installation scripts and retrofits

done.

Award : Got Special Recognition GEM Award from Oracle

Employer Name - Oracle Solution Services India Pvt. Ltd., Bangalore

Project / Client Name / Location - Apoteket Plogen / Apoteket-Tieto / SWEDEN

Duration: 10 months from Feb 2011 to Nov 2011

Technologies - SQL,PL/SQL,Unix, RIB, RMS, SIM, UC4

Project Profile:

Apoteket AB is the pharmacy for all of Sweden and offers consumers throughout the

country medicines and attractive health care products, advice and solutions to

inspire people to live healthily and make it easier to feel good. Apoteket has a

wide range of knowledge services and offers medicine supplies to many business

enterprises in the health care sector. company has over 350 pharmacies throughout

the country.

Role: On-site Team Member

Contribution / Highlights :

As a On-site team member I was actively involved in the below phases of project :

Automation of different tasks with the help of Unix, SQL, PLSQL.

Missing Sales data loading at GL, RESA & RMS.

Solving some issues related to SIM.

Debugging failed batches & providing solutions.

Supporting of RIB and UC4.

Monitoring of batches scheduled by UC4 & recovery of failed batches.

Solving different RIB related Issues.

Supporting RIB & UC4 development instances for any issues faced by technical team.

UC4 installation for training environment for users.

Handling some small DBA tasks (applying patches, compiling batches, deploying

packages & procedures etc.)

Award : Got Special Recognition GEM Award from Oracle

Employer Name - Zensar Teachnolgies Ltd., Pune

Project / Client Name / Location - RetailCorp / Nakheel / United Arab Emirates

(DUBAI)

Duration: 1 Year 8 month from April 2009 to December 2010

Technologies - SQL,PL/SQL,Unix, RDW, RIB & APPWORX

Project Profile:

Nakheel Retailcorp, the Dubai-based franchisor of many world-leading brand names

in fashion, sportswear, food and beverage including Go Sports, Joebloggs, IC

Companys and Peak Performance, has selected Oracle(r) Retail merchandising,

planning and stores applications to enhance retail operations and performance. The

Oracle Retail applications is helping Nakheel Retailcorp to identify optimal

inventory levels and pricing at its stores across the region and provide a retail

platform to support corporate expansion plans.

Role: Team Member

Contribution / Highlights :

As a team member I was actively involved in the below phases of project :

Installation of rib and appworx .

Monitoring of jobs scheduled by appworx & recovery of failed jobs.

Contacting with the client for report generation of store's daily inventory status

& transcations.

Solving Rib related Issues & SR's raised by clients.

Supporting RIB & Appworx development instances for any issues faced by technical

team.

Automation of Some Reports with the help of Unix, SQL, PLSQL.

Sales data loading at RDW, finding missing transactions and loading again.

Recovery of failed batches of RDW by finding root cause & providing solution.

Reverting double or extra data like sales, inventory posted to RDW.

Employer Name - Zensar Teachnolgies Ltd., Pune

Project / Client Name / Location - KOJ Support / Kamal Osman Jamjoom Est. / UAE

(DUBAI)

Duration: 1 Year 7 months from May 2009 to December 2010

Technologies - SQL,PL/SQL,Unix, RDW, RIB & APPWORX

Project Profile:

Kamal Osman Jamjoom Est. (KOJ), one of the leading retail groups in UAE, has

enhanced and expanded its operations across the Gulf region, by harnessing the

power of Oracle Retail and E-Business suite solutions.KOJ owns the Mikyajy make-up

and accessories brand, and the Nayomi lingerie brand; as well as holding

franchises for The Body Shop in the Western region of Saudi Arabia and Early

Learning Centre across the GCC. The group already has more than 400 stores in the

region, but plans to grow this to over 1,000 stores in the next three years.

Role: Team Member

Contribution / Highlights :

As a team member I was actively involved in the below phases of project :

Monitoring of job scheduled by Appwrox.

Contacting with the client for report generation about RIB & Appworx.

Solving Rib related Issues & SR's raised by clients.

Received client appreciations for the projects I worked on.

Developing PLSQL & Unix script as per requirement.

Missing Sales data or Transactions finding for RDW and loading it.

Transfers data matching between RDW & RMS.

Providing solutions to failed batches/scripts of RDW.

Tracking inventory data at different levels like aggregation & base levels for

RDW.

Project / Client Name / Location - Institute Management System / ATS InfoTech. /

Pune

Duration: 5 months from March 2010 to July 2010

Technologies - Servlet, JSP, Struts, Hibernate (J2EE), MySQL

Project Profile:

ATS Infotech is one of the Company which fulfills IT Companies requirements by

providing skillful persons.

It is not only giving training to their students for technical skills but also

building them for IT Industry. Not only students but IT professionals are also

gaining knowledge from ATS inorder to increase their skills.

It has its own large staff. In order to manage all these things we are building a

application which will help them in reducing manual intervention to lots of

management things and handling all data in one place.

Role: Team Member

Contribution / Highlights :

As a team member I am actively involved in the below phases of project :

Requirement gathering for making structure of project.

Building E-R diagram and MySQL database.

Developing Application with the help of (struts,hibernate)J2EE technologies.

Employer Name - Zensar Teachnolgies Ltd., Pune

Project / Client Name / Location - LMG Go Live / Landmark / ABU DHABI (DUBAI)

Duration: 2 Years 1 Months from July 2008 to August 2010

Technologies - SQL,PL/SQL,Unix, RIB & APPWORX

Project Profile:

Landmark Group is a biggest retailer in Middle East based on Dubai. The group

currently operates over 400 stores across the countries. The Landmark group today

has a retail presence of over 5 million sq. ft. It uses Oracle Retail 12 as their

ERP system for their core merchandising and supply chain operations and the same

is integrated with their Oracle Financials and existing legacy systems.

Role: Team Member

Contribution / Highlights :

As a team member I was actively involved in the below phases of project :

Monitoring of job scheduled by appworx for production instance.

Supporting Rib for PREPROD instance.

Solving Rib related Issues & Service Request's raised by our testing team.

Report maintaining for match & mismatch at RMS and RDW.

Employer Name - Zensar Teachnolgies Ltd., Pune

Project / Client Name / Location - Guest House Management System / Zensar

Technologies / Pune

Duration: 5 Months from February 2008 to June 2008

Technologies - JSP, HTML, Core java

Project Profile:

Guest House management is an internal project done for zensar .The project is used

to maintain the allocations for the clients and the people who come from on site.

Users of the project are Admin Team of Zensar who manages Companies Guest houses

located at different places in Pune

Role: Project Trainee

Contribution / Highlights :

As a team member I was actively involved in the below phases of project :

Designed the ER Diagrams.

Interacting with users of the project for requirement gathering.

Front End screen Designing using java

Coding and Unit Testing.

EMPLOYMENT HISTORY

Employer From To Designation Area

Oracle Solution Jan 2011 Till Date Staff Consultant Customization,

Services India Implementation, Support &

Pvt. Ltd., Maintenance projects in

Bangalore Oracle Retail

Applications.

Zensar Jul 2010 Dec 2010 Software Engineer Support and Maintenance

Technologies, projects in Oracle Retail

Pune Applications.

Zensar Jan 2008 Jun 2008 Project Trainee Internal Project

Technologies, Development for Company

Pune

ON-SITE EXPERIENCE

Employer Project Duration Location Visa Type

Name

Oracle Solution Saks Inc. 12-Jan-20 New York, USA L1 VISA

Services India 13 to

Pvt. Ltd., Till Date

Bangalore

Apoteket 5 months Sweden Work Permit

Plogen

Apoteket 1 month Sweden Business Visa

Plogen

PERSONAL DETAILS

Name : Aniket Jayesh Gharat.

Permanant Address : 410, Anand Narayan Nagar, Manvel pada road, Near

railway station, Virar(East), Tal -: Vasai, Dist -:

Thane, State -: Maharashtra, 401303

Email Address : ******.******@*****.***

Contact No. : 919*********

Birth Date. : 29-April-1987

Passport Details : Passport No H1055558

Issued at Thane

Date of Issue 05-07-2008

Expiry date 06-07-2018

Contact this candidate