Sales Management

Resume of Gayathri Karthikeyan

** ****** *******,

Appartment 13,

Parlin, New Jersey

Zip 08859

Phone : 732-***-****

email:

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

L2 VISA with Employment Authorization

Professional Experience

AS400 developer with 5 years of work experience

Company

Customer

Work duration

Years of

experience

Domain

Silver Lake information

systems

Bangalore

Baby wear

March 2005 - August 2005

6 months

Supply chain management

DynPro

IBM(Scotia Bank)

August 2006 - October 2006

3 months

Banking domain

Valtech India Limited

Louis Vuitton

November 2006 - Till date

4+ years

Retail domain

Skills

Languages/Scr : RPG400, ILE RPG, ILE CL, SQL, C, C++, Shell scripts.

ipts

RDBMS : DB2 UDB/400

Tools : Quick press

Operating : OS400 (V5R3), Windows, Linux, Unix

System /

Environments

Organization : Valtech India Pvt Ltd

Duration : November 2006 to till date (Valtech India Pvt.Ltd.)

Role : Developer, Sr Developer

Team Size : 10

Language/Tool : RPGLE, CLLE, DB2/400, SDA, SEU, RLU, SQL

s

Client : Louis Vuitton, France

Highlight of the requirements:

Store integrated payment solution

Vaponline for Spain

Cash Drawer requirement

Reason code management

Zip code backfill

Credit and credit notes enhancements

Client Duplicates and Audit report

Eco tax management

Complete set of customers history and new related features

Phone Order Sales Type

Repair input process modification

Tag Print

Deposit in waiting status

Associate code shortlist

Add two mobile address in the customer file:

GUI: (Government unify invoice)

Detax for Europe

Reversible Transaction History Inquiry

Printing of Delivery Note

Order confirmation

Goods received note

Article Master Print

Responsibility/Case handled in Valtech (India)

Store integrated payment solution(SIPS)

Involved in specification writing for credit card processing.

The Objective of implementing SIPS (Store Integrated Payment Solution) is to

provide a global card payment integrated solution to all LV stores worldwide.

OneInterface application is provided by Global Blue and it is acting as a

'bridge' between RMS and payment terminal.

Rule to perform a regular sale using card payment.

Card payment type information should be sent from RMS to payment terminal through

One Interface to invoke the proper application (Credit card or Debit Card or Gift

card or CUPD) for authorization request.

Then Swipe/insert the card in Payment terminal.

Payment terminal will send the authorization request to bank to approve the

payment.

The processor (Bank) will send the approved/Declined response to Payment terminal.

Then Payment terminal will send the response to Oneinterface.

Oneinterface will send the authorized response to RMS.

If the request is approved, the transaction can be completed as usual. If the

request is declined, the cashier can terminate the transaction or ask the customer

to provide an alternate form of payment.

Reservation for Vaponline stores:

The current process in Retail (RMS) replicates the sales but not the reservations.

That means the MAG and RSV stocks will not be consistent at the Europe level. The

replication of the reservations will be developed in a future version. Goal of this

requirement is to provide a workaround solution to update reservation stocks at the

zone level till the implementation of the future development.

Cash Drawer requirement

The main objective of the requirement is to open the cash drawer automatically for

the appropriate payment mode without using the key, when the sale is validated by

F9 function key. It will be helpful for audit purpose also to track the non-sale

opening of cash drawer through RMS, automatic opening of the cash drawer eliminates

the need for cash drawer keys to be available on the floor at all times.

Reason code management:

A new field Reason code will be added in sale's screen which will describe the

reason for returning an item or discount given on a particular item. In sale

transaction screen, When an item is selected and Return reason code/Discount reason

code parameter is equal to 1 in CFGVTE, then user will be prompted to select reason

code from the popup.

Zip code backfill:

The purpose of the requirement is to reduce the client entry time while creating a

new client. The entry of the zip code will be automatically informing the some

basic elements of the address. The existing CLICDP file will be used and updated to

include the Province/state field.

Credit and credit notes enhancements:

The main purpose of this requirement is to do some enhancements in the credit and

credit notes, to improve the credit features.

Message when the amount of the item and the amount in 'Amount' (by line) is not the

same.

2. Message when the credit note amount is greater than the sale.

3. Computation of the amount when it becomes negative.

Selection automatically of the correct document type.

Client Duplicates and Audit report:

The main purpose of this requirement is to list the duplicate customer records by

store and to have an audit for the cleanliness of customer database. For this new

reports will be generated based on Kanji family name, Kanji first name and mobile

phone number. Menu option 70-11-15 (Duplicates report) at store level and 05-11-15

(Duplicates report) at head office level needs to be created only for Japan Stores.

Eco tax management:

The main purpose of this requirement is to apply Eco tax on Electrical and

Electronic Equipments. As of now Eco tax will be applied on particular products

like Quartz watches, the light key rings and trunk motors. The Eco tax would be

extended to other products in the future and now it is applicable only for France.

The Eco tax information for items will be received through interface ITEM file and

it will be moved to ART file.

Complete set of customers history and new related features:

The objective of this requirement is to collect all the details about the client

sales history in country level. Option '7' from the client's list will display the

overview of the transactions for the customer in the country: The transaction

amount displayed will either be including tax or excluding tax.

Phone Order Sales Type:

The main objective of this enhancement is to fight credit card "charge backs" in

LVNA stores by knowing which sales transactions were conducted over the phone. For

this a new flag field should be created in the sales transaction and a new field

VTEORG should be added in VTEENT.

Repair input process modification:

The main aim of the requirement is to avoid displaying of repair screen for Japan

Environment while creating a repair transaction, to control that a new parameter

needs to be added in the CFGVTE table.

Add two definitions in CFGVTE table for group header as "JPN" and parameter as "No

repair in waiting".

F15 function key should be displayed and used only when the "No repair in waiting"

parameter is 0.

Document type should not be changed as '9' when the user informs option 8(repair)

in the item line.

Tag Print:

The purpose of this requirement is to develop new function 'Tag printing' in RMS to

print tags / labels for items for various reasons including new prices, damaged

tags, stock integration, etc. So with the help of this functionality tags can be

printed whenever required and it will save time in replacing old tags when prices

are changed.

Deposit in waiting status:

The main purpose of this requirement is to differentiate the waiting and issued

status deposit, a new post code '0' will be created for waiting status deposit in

VTE014 table. When a deposit is created, without validating by F9 function key,

instead F12/F3 function key is pressed the status will be updated as '0' - Waiting

in the file VACSTS/VTEENT. When the deposit is validated by F9 function key the

status will be updated as '1' - issued.

Associate code shortlist:

The main objective of the requirement is to shortlist the sales by sales associate

at item line. So that Sales performed by sale associate for each item will be

calculated and displayed as turnover amount in the Sales shortlist screen.

Currently, the shortlist for sale associate is based on the header level; in this

case the amount calculated for display turnover is including other sale associate

at the item line.

Add two mobile address in the customer file:

The main purpose of the requirement is to add two more Email address fields in

Sales/Deposit/Reservation screen for Advance client research and including the new

feature Client Email Address Popup for email in client first page. Popularly in LV

Japan they are using mobile to connect to internet. Mobile email address will be

collected in store from the customer's in order to invite them to register in the

Louis Vuitton website to buy products.

GUI: (Government unify invoice)

The goal of this requirement is to re-develop the sale specific functions of GUI in

v4.3 and re-use the other functions that were developed in v3.5. In v3.5, the GUI

sales functions were developed using specific screens (even for the standard

functions like client, items, payment input). This is not desirable as any feature

added in the sales screen will need to be re-developed in the GUI specific screens

as well.

Detax Europe - GRIPS Global Refund

The detax module in RMS has to be out sourced to solution GRIPS provided by Global

refund for Europe zone. The objectives associated are store efficiency, increased

profit and easier management.

The information captured in RMS will be sent to GRIPS,

To calculate all refunds (for all stores in the Europe),

Printing the tax-free cheque specific to a country,

Voiding a detax issued and

Generating daily and monthly reports for RMS accounting.

The communication between RMS and GRIPS has to happen via a localised middleware

known as GRECR. The GERCR middleware runs on JAVA run time environment and the mode

of communication is through XML-message via TCP socket connection.

Organization

IBM Global Services - Scotia Bank (India)

Duration

August 2006 to October 2006(IBM Global services - Scotia Bank )

Role

Developer

Team Size

7

Language/Tools

RPGLE, CLLE, DB2/400, SDA, SEU

Project details:

Reversible Transaction History Inquiry

Upon receiving request for reversible transaction inquiry, host will populate the

message showing all possible reversal transactions and send it to the front end.

This means that the output of this request will be a set of transactions available

for reversal for that Loan. The number of transactions that will be sent back to

the front end at a time in the reversible transactions inquiry message will be 16

which means in one request a maximum of 16 transactions will be displayed to the

users. For the CLS Reversal transaction inquiry, Host will send in 16 records to

the FE in each request and only 1 record will be flagged to indicate that only this

transaction can be reversed. For one-to-many transactions like Payout, the main

transaction will have the details like the Dr/Cr indicator, the reversal flag, the

reversible transaction amount and the reversible transaction Code.

Organization

Bangalore Baby Ware (India) - Cuthbert's UK

Duration

( On assignment with Bangalore Baby Ware, Bangalore & Cuthbert's, UK at Bangalore

for Silver Lake Information Systems Pvt Ltd )

Role

March 2005 to August 2005

Team Size

4

Language/Tools

RPGLE, CLLE, DB2/400, SDA, RLU, SEU

Project details:

TIM is a specialized ERP product, a network -oriented application which runs on

AS400 environment, addressing the Information requirements of all segments of the

textile and apparel industry and contains various modules including Sales,

Planning, and manufacturing, Inventory& Purchasing, Costing, and Database etc.

Responsibility/Case Handled

Printing of Delivery Note

Workflow

Case 1: Warehouse Transfer

Goods are transferred between warehouse for operational reasons, such as:-

Transfer of goods from a main store to a sub-store, in a production unit

Transfer of finished goods from finished goods warehouse of production units to a

centralized dispatch warehouse so, a delivery note is printed for both reasons

above.

Case 2: Issue to Production

Materials are issued to production orders from material stores. In this function,

materials are selected for issue, by article code and then by specific

cartons/containers. When the delivery note is printed, all materials selected for

transfer in that session shall be used.

Case 3: Returns to supplier

Materials can be returned to suppliers for various operational reasons. In this

function, materials are selected for issue, by article code and then by specific

cartons/containers. When the delivery note is printed, all materials selected for

transfer in that session shall be used.

Order confirmation

This order confirmation process is included in COPS (Customer Order processing) in

TIM ERP.

Situation to confirm order:

Accept the order through Cops module. Based on the product availability, the

delivery date for the order quantity will be assigned. In this stage, the order

will get confirmed.

If the order quantity is more than the product availability,

Case 1 The order acceptance will be partial, based on the quantity available.

Case 2 The order will be accepted completely, and then the assigned delivery date

for the order will be a delayed one.

For both the cases Order Confirmation report will be generated.

Goods received note

This Goods received note module is used in Mash (Management accounting stock

handling) module in TIM ERP.

At what stage the goods received note is produced:

Through SOS (supplier order processing) we can order for some quantity of product

(can be Thread, Packs, Buttons, and Labels

Through Mash module, we have to receive the order, whatever quantity ordered or

less than that also we can accept it.

The received quantity with quality 1, is referred to as best quality, with quality

<6, will be accepted, but the quality with 6, it will be considered as a rejected

quantity, so we have to subtract the rejected quantity from the received quantity,

it will be considered as an accepted quantity, the rejected quantity will be send

back to the supplier.

We have to confirm the warehouse movement, for the accepted quantity, in this stage

GRN will be produced. In order to generate a GRN number data area is used. Based on

the GRN No we can reprint the order acceptance detail (i.e. Goods Received Note)

4. Article Master Print

The main objective of this requirement is to produce two different format of

article master report based on article type. The articles are packs, threads,

labels, garments, fabrics . . . The article types are P, T, L, G, F...respectively.

The articles which is purchased from the external agency, based on that report will

be produced which will have the details of purchase cost, selling price. Another

format will have the details of production cost, selling Price.

Summary of Educational Qualification

1999-2003 BE (ECE) Madras University, AVIT, Chennai 72%

199*-****-**+2 Nirmala Matriculation Higher Secondary 82%

School, Chidambaram

199*-****-** Sevamandir Matriculation School, Port Novo 73 %

Educational/Academic Achievements

Scored 100% in Maths in 10+2 Board Exam

Training Programs Attended @Silver Lake, Bangalore

AS/400 concepts and Programming facilities

DB2/400 Relational database coding and Implementation

Control Language Program

Interactive Program Design

RPG IV Program

[pic]

Contact this candidate