Mukesh N. Bhatt

blackstartNetworking and Communications

Oct 26, 2013 (3 years and 5 months ago)

147 views






Page
1

of

14




Mukesh N. Bhatt

mukeshnbhatt@yahoo.com
,
mukeshnbhatt@gmail.com


Phone
(GSM)
: +91
-
9824006828 (

Cell

)


Title :

DCPA (National Computing Centre,NCC,UK),
MCA,OCP
-
9i
(Oracle Certified




Professional
, Oracle Corporation, USA
),MBA(Finanace) with
20
+ years
experience

in IT with Automobile and Banking domain experience.


Summary



20
+ years

of diversified experience in IT with industry domain experience in
Automobile

Manufacturing (
1
8
+

years)

and

Banking (2 years
)



Currently managing
Data C
entre of SQL
-
2005 AND Oracle
-
9i across entire state of
Gujarat

with Intra Branch (WAN) connectivity
.



Currently heading ERP
and Infrastructure
Project
-
IT

of
Entire
Gujarat State Br
anches.

(Front End : dot net
-
2008 and Back End
-

MS SQL
-
2005)



Involved
in

SDLC
,
PLCM (Production Life Cycle Management)

Hardware / Software

SL
A

documentation
,

maintain
ing

Data Centre,

OLTP,
Cisco
firewall
ASA5500 series,
security

,
Info VPN server
,

Cisco
-
1700
, 1741

&
C1921
series Routers

and MS
-
Exchange Server
-
2007.



Involved in Hardware capacity
P
lanning,

Budgeting, P
urchasing
, Monitoring

and
M
aintenance.



Currently Manage Principal

(ASHOK LEYLAND LTD)

ERP Central Server
and our Intra
State Branch
Connectiv
ity
across

entire state Gujarat, India (CRM & DMS modules)



Currently Manage Principal (
Renault Car, France
) ERP
(DMS
-
Autodeal)

Central Server
and
Intra
Branch Connectivity across entire Gujarat

State
, India



Involved in SQL
-
2005

/ ORACLE
-
9i

database adminis
tration.



I was managing IT infra

(Sales, Service & Parts)

of KOBELCO

(Japan)

India across entire
state of Gujarat.



Currently I am heading Ashok Leyland (Hinduja Group
-
UK) ERP

(SAP Modules)

Infrastructure IT Project across entire state of Gujarat.



Current
ly I am heading
Renault

Car
, France

ERP
(DMS
-
Autodeal)

Infrastructure IT
Project across entire state of Gujarat.



Hands on experience as SEO.



ERP

(AUTOMOBILE DOMAIN)

• Managing the ERP & Implementation.

• ERP full cycle implementation
.(
F
inance
, HR, Production, Purchasing,
Inventory
,


Sales and Marketing)

• Creating
functional specification documents



Pro
ject planning
.


• Creating business cases, identifying risks involved for new projects.

• Analyzing the domain requirements, identifying gaps.

• Identifying IT resource requirement.

• Expertise in devising a technical solution and creating technical pla
ns for any


required problem

• Proven expertise in integration of different systems and designing of interfaces with


ERP system.

• Complete SDLC experience.

• Key & End user training of all modules

• Preparation of User manual for
business Proces
s

• Analysis

of current system setup and understanding integration between them.

• Understanding current business
process architecture

and interrelation between



business processes

and systems. Thereby analyzing the scope for systems /






Page
2

of

14


business
process improvisation.

• Managing the complete Life Cycle for system modifications:

• Preparation of
Functional Specifications

and
Technical design documents

for


development of system customizations.


Conducting

unit test, user acceptance test, prep
aration of
user manuals
,


deployment of solution, end user group training.


Managing bridges of third party software
,


Technical Profile

Platform

Windows
-
2003
-
R2 Enterprise with Clustering
, Raid 5, SATA controller
,
Novell 5.0

SCSI

mirror

Operating Sy
stem

Windows XP Professional
-
SPIII
, Red Hat Enterprise Linux WS 4.0, SCO
Unix 5.0

Databases

Oracle 7, Oracle 8i, Oracle 9i (9.2.0.1.0)
-
Enterprise Edition,MSSQL
-
2005
,
Oracle 11i / 11g

GUI

Oracle Developer 2000 ver.6
i

Report writer

Oracle Report Ver.2.5



Tools/ Utilities

MS FrontPage, PageMaker, MS Project, MS Visio

Server

IBM
x3650 M3, Xenon 4C E5640 80W 2.66 GHz/1066 MHz/12MB,

1x4GB, O/Bay 2.5in HS SAS/SATA,SR M5014,675W p/s, Rack
, 4GB (1x4GB,
2Rx4, 1.5V) PC3
-
10600 CL9 ECC DDR3 1333MHz LP RDIMM, IBM

600GB
2.5in SFF Slim
-
HS 10K 6Gbps SAS HDD, IBM 6Gb SAS HBA, IBM 675W
Redundant AC Power Supply,

LAN Switch

[1]
Cisco
Catalyst 3750 24 10/100/1000 + 4 SFP + IPB Image, COLL
8x5xNBD INT, Cat 3750 24 10/100/1000T 4 SFP St1RU
-
L3

[2] Catalyst 2960S 24 GigE, 2

x SFP LAN Lite, COLL 8x5xNBD INT, Cat
2960S 24 GigE,2 x SFP LAN Lite



L2

Backup / Storage

Sun Storage


146x10 GB SAS with Raid Controller
, TS2900 IBM Tape

Auto

loader

with LTO4 Half High

SAS Tape Drive
, LTO4 Tandberg

Languages

COBOL’85, Microsoft A
SP DOT NET
-
2008
(AJAX & SILVERLIGHT
TECH)

Firewall

CISCO Firewall
-
ASA5500 series with VPN and Anti Virus Security
,
Sonicwall Firewall
-
NS2400

with security

Data Routing (WAN)

CISCO Router
-
1700
,
1741

&
C1921
series
, MSP800

thru BSNL MPLS &
Reliance ISDN
, 1:
1 Fibre
and RF
with 1 mbps P to P and ILL of Reliance
Communications
, 1 mbps ILL 1:1 Tata Communication Ltd thru WIMAX

&
PtoP (Dedicated Point to Point 1 mbps)

Web

Client

Citrix web client for Ashok Leyland and VMware Zimbra web client for
Renault India
Pvt Ltd


Current

Position

:
System Engineer

/DBA


Lead
-
Oracle
-
9i

and MS


SQL
-
2005


(Incharge
-
EDP)

-

Gujarat State
-

Reporting to: Sr.General Manager

Automotive Manufacturers Ltd., A
hmedabad
, G
ujarat
, I
ndia


(
Domain Name

: automotiveml.com)

Automotive M
anufacturers is one of the main dealers of Ashok Leyland

(Hinduja Group)
, Maruti, Bajaj,
Audi Car, Kobelco (Earth Moving Equipments)
,

V
olks
w
agen Car
,

GULF Oil


and Mahindra

& Mahindra
.
The territory of th
ese

dealership for Southwest India.

Main responsibi
lities :

[1]
As
Oracle
/SQL

DBA :



Performed DBA activities in 24X7 environment



Inv
olved in Database Creation


Maintenance


Optimization


Backup & Restore,

Application Deployment.



Create and modify physical storage structures (i.e. tablespaces, table
s, indices, partitions,
clusters, snapshots, rollback segments, temporary storage structures, clusters and data files)



Size physical storage structures to minimize database fragmentation and chaining



Distribute and balance I/O






Page
3

of

14



Plan for future storage ca
pacity requirements for the server and database



Monitor and optimize the performance of database applications and the database as a unit



Monitor the availability and reliability of database
-
related procedures, processes, and services



Manage users, privi
leges, roles, and quotas to control and monitor user access to the
database



Maintain a backup and recovery strategy for database information and restore the database as
required



Maintain archived data for point
-
in
-
time restorations



Install, upgrade, con
figure, and tune network access to the database (i.e. SQL*Net, Oracle
Names, ODBC etc)



Assist project teams with applying standards and resolving integration issues



Assist project teams in prototyping and optimizing queries



Assist project teams in desig
ning the database storage structures and program units as to the
effect on :



The performance of the database as a unit



The performance of the server executing the RDBMS



The performance of the database during data operations and transactions



The efficie
ncy of backup and recovery procedures for the database



Provide education and training to database users and developers



Develop DBA support utilities, scripts and tools.



Commissioning and installing new applications.



Hands on experience of Oracle TAR (M
eta Link support)



Database Design, Administration, Backup and Recovery. Main tasks include:



Periodic verification of all database instances uptime. Recoverability of Backup.



Look for any new alert log entries etc.

Main Responsibilities as DBA



Constantly Re
view Performance tuning opportunities by

o

Verifying free space in tablespaces

o

Identify bad growth projections

o

Identifying space
-
bound objects

o

Reviewing contention for CPU, memory, network or disk resources

o

Reviewing fragmentation

o

Data mining

o

Database mirror
ing



Ensure data consistency, quality, accuracy and integrity



Defining and/or implementing access control to the data



Planning and implementing backup/restore and recovery process by writing/
maintaining manual scripts and RMAN scripts for performing online

backups



Designed/ tested and Implemented Disaster recovery using manual standby
databases



Installed and Configure SCO Unix Ver.5



Tuning the disk I/O and number of Check Points



Performing Export backups



Sizing of rollback segments and redo logs



Resource m
anagement, User privileges management



Object Management



Security Management



Data Loading



Maintenance



Monitoring/Tuning (SQL)



Capacity planning and management



Database requirement analysis, Performance tuning, Physical/logical database
design, Impleme
ntation of backup/recovery strategies, Assisting developers
with tuning SQL



Developing standards for the overall data warehouse architecture
.






Page
4

of

14




General Responsibility :




Creation of Overall network Design (
Wireless
LAN & WAN) , Plan, acquire, and
coordi
nate installation of in
-
house and remote hardware and software across the


organization's network.



Maintain 3
-
Tier Server (Application, Database and Web)



Maintain MS
-
Exchange server with Entire Gujarat Domain E
-
mail IDs.



Design and implement s
hort
-

and long
-
term strategic plans to make certain network
capacity meets existing and future requirements.



Develop, implement, and maintain policies, procedures.



Develop and deploy methodologies for testing network performance and providing
network perf
ormance statistics and reports.



Plan and ensure effectiveness of security solutions, including firewalls, anti
-
virus
solutions, and intrusion detection systems.



Conduct research and make recommendations on network products, services,
protocols, and stand
ards in support of network procurement and development efforts.



Negotiate with vendors, outsourcers, and contractors to secure network products and
services. Assess, approve, and administer all equipment, hardware, and software
upgrades.



Establish best p
ractices and policies for installing, configuring, maintaining, and
troubleshooting end user workstation hardware, software, and peripheral devices.



Establish service level agreements with end users.



Plan user accounts, permissions, and access rights.



In
stall, configure
and train on
Webex
Meeting
conferencing for MIS



Define Quality, Security and Governance framework in the areas of communication
and infrastructure



Define ICT Policies and Procedures



Introduce new technology in the areas of communication
and infrastructure



Achieve operational efficiencies and
discipline

with a goal to achieve zero downtime for
business
.



Repair & maintenance of desktops, servers, laptops, printers, telecom &
communication products



Installation, configuration and resolution

of problems in system software’s such as MS
-
Outlook, MS
-
Office, Windows XP, Windows 2003 Server, MS
-
Visio, MS
-
Project,
AutoCAD etc



Installation, configuration and maintenance of networking components such as
switches, routers etc.



Installation, Commission
ing and maintenance of Info
-
Tech related products such UPS,
Batteries, MPLS , Broadband Connectivity, EPABX, FCT

of SMS Tracking
, Leased
lines etc.



Managed Fianancial proposal of Vehicles for Gujarat State Road Transport
Corporation Bus Chassis and Bus Bod
y.



Implementation, maintenance and enhancement of In
-
House

ERP



Cost analysis, budgeting and scheduling of various projects (Software, Hardware,
Networking and Manpower Management).



Implementing, Administering, Troubleshooting,
Managing and maintaining app
lications
within a tight budget and time frames.




Implementation and maintenance of Web applications



Co
-
Ordinate
Vendor Management
and IT Team.



Programme management and project delivery tools and techniques.






Page
5

of

14



Experience of working within a large cross
-
funct
ional project organization.


Strong understanding of release and change management process



Strong analytical and problem
-
solving skills



Excellent work standards, highly motivated, team player, action oriented with

continuous improvemen
t mindset



Ability to develop and maintain strong relationships with vendor teams and internal
customers



Project and Asset Management



Update Anti Virus and Patches.



Managing Finance Related
Project of the Organisation.



Ensuring network security & update
network diagram as when changes happened



Carryout user management activities



DATA
Backup maintenance



Hardware & OS upgrade maintenance



Experience in
LAN, MAN AND WAN
Network
Management and
Administration.
Essential router management, L2 /L3 network swi
tches management and firewall
management. Windows OS. System administration.



Maintaining the hardware configuration change control



Execute plans, arrangement and deployment of Hardware & Software



Systems security & compliance



Setting up security polici
es



Data centre support & maintenance



Change management system in networking & server configuration



S
erver OS level patch upgrade



Network monitoring / security


uptime



M
aintain the
A
udio/Video devices
,
IP BASED E
P
A
BX
(CENTREX)

systems,
ONLINE
SYNC
UPS,

CCTV
,

IT assets inventory

etc



SLA maintenance & monitoring



Managing LAN, MAN and WAN protocols.


Tools used during Oracle 9i DBA training
:

RMAN,
TOAD
(Loader),

DATA GUARD and OEM (

Oracle
Enterprise Manager)

General overview(hand
s
on) about RAC




[2]
As

System Engineer/DBA Lead
(
Gujarat State
)
:


Ashok Leyland
ERP

(CRM/DMS)

MODULES

CRM

Front End

Back End



Oracle
E
-
Business Suite
-
11i

Oracle
-
10g (10.0.1.2) Enterprise

DMS

Front End

Back End




ASP.n
et
-
2008

Oracle
-
10g (10.0.1.2) Enterprise




MODULES
:
Pre
-
Sales

(SMS Tracking System)
, Sales, Invent
o
r
y control, Service, HRM, Accounts



(Tally
-
9.0

ERP
)





Management and Coordination of EDP department of the entire Gujarat region.



Major responsibility is to
Design, Systems An
alysis, Gap Analysis, Application Designing,
Implementation, maintenance
,

enhancement of ERP

s and business

applications, Quality
check, testing

& Configure ERP modules



Install
,

Admin

and Maintain Electronic
Sales, Service and
Parts
digital
Catalogue
s




T
ie up SLA (Software License Agreement) with
various
vendors



MIS reporting.

(e.g. TIV, Market Share analysis, Target v/s Achievement, BSC parameters
(Sales, Service & Pats & other preparing management/conference related presentation)






Page
6

of

14



Hardware capacity plann
ing, purchasing and maintaining service level agreements for Gujarat
State Branches.



Preparation of user handouts and manuals.



Development and maintenance of technical documentation.



User training on

application and system software.



Develops training req
uirements and plans for project team
.



Coordination between user and third party for

process mapping, customization & maintenance
of business applications
.



Over the years involved in Application Requirement analysis, Design and Development of Key
projects f
or the entire dealership:



project commitments through leadership, execution, teamwork, planning/scheduling, problem
analysis/resolution and productivity improvements



CURRENTLY HEADING

SAP MODULES

OF ASHOK LEYLAND LTD



AC
ROSS ENTIRE STATE OF GUJARAT.




Inventory Control
: Application included functions to do Sales and Purchase Analysis,
Location wise Stock Management, Analysis by Dealer or Retail channels



Vehicle Order Processing System
:
Target, Task, Leads, Prospects, Quota
tion,
Order, Delivery. (
Customer Details, Booking Details, Payment Details, Dealer
-
wise
Details, Customer complaint management, Sales inquiry & Analysis system

)



Workshop Billing System
: Warranty claim analysis (Labour/Spares/Lube), Job wise
analysis (Labo
r/Spares/Lube)
, Pre Delivery Inspection (PDI), Free Service, Paid Jobs.



Payroll System
: Application to provide Employee's Personal details ,Pay
-
slip, Salary
Register, Bonus Register, PF related reports, Leave detailed reports, Income
-
Tax
details including
Staff Income and Customer Payment Analysis, Tax Calculation



ERP
: Vehicle Sales, Spare Parts Control (Inventory Control), Service, HRM,
Accounts, Admin, Payroll



TRAINING TAKEN
AT

ASHOK LEYLAND MANAGEMENT CENTRE
-
HOSSUR
,
TAMILNADU, INDIA




Rolling Forecast


Expected vehicle delivery for rollover customer



Prospective list


Leads of vehicle from marketing team



Manage E
-
tender

Processing

System



Manage V
ideo Conferencing for

Management’s review meet
.




Customer Tracking System


Managing Lead data (competi
tor)



Key Account Management (KAM)


Priorities given to key account customer



Customer Database Management (CDB)


containing the details of current month sale



Balance Score Card (BSC)


process data of past
-
present
-
future i.e. Target of Vehicle
Sales, Lab
or Turn Over (LTO), Spares Sales / Workshop Consumption, Lube Sales /
workshop Consumption, Warranty Details and utilized man hours.



Master Plan of Business (MPB)


evaluate the data for current and future.



Customer Connect (CC)


To connect centrally with

principal server. The modules
contain pre
-
vehicle sales, vehicle sales, vehicle service, spares, accounts, human
resources

etc



To prepare Events Management program data



To prepare Target Verses Achievement Analysis



Pre
-
Delivery Statement (PDS)


To prepar
e the statement for vehicle delivery
-
segment wise



model wise

quantity.



Analyze all Assemblies and components with standard fitment with vendor’s
information



TAT
-

Turn Around Time analysis.






Page
7

of

14



Managing Electronic Pre Delivery Inspection

of Vehicle



Managing

Electronic Warranty Claim Analysis



DAR


Daily Activity Report Analysis



DAS


Daily Activity Services Analysis



KRA


Key Resources Area



FTU
-

First Time User



MWR
-

Monthly Workshop Return



QWR
-

Quarterly

Workshop Return



SMS


Service Market Share



ROT


Repair Operation Time



EWP


Extended Warranty Pack



ESP


Extended Service Pack



SOP


Standard Operating Procedure



SQA


Service Quality Architecture



MSL


Minimum Stock Level (Parts)



VOR


Vehicle Off Road



VUR


Vehicle Under Repair



VRR


Vehicle Rec
e
ipt R
eport



SMT


Special Maintenance Tools.



LTO



Labor Turn Over



AMC
-

Annual Maintenance Contract



MS


Market Share



SM


Service Marketing



EWP


Extended Warranty Package



EWS
-

Extended Warranty Service



CSD
-
Customer Service Data



SMS


Service Market Share



PPR



Product Performance Report



CURRENTLY HEADING

ERP

MODULES

OF RENAULT INDIA PVT


LTD ACROSS ENTIRE STATE OF GUJARAT.


RENAULT INDIA PVT LTD
-
ERP

(CRM/DMS)

MODULES


Front End

Back End


CRM
/DMS
(Autodeal)

Oracle
Forms


Oracle
-
1
1
g
Release 2 (11.0.2.3) for MS
Windows (32 bit)





Inventory Control
: Application included functions to do Sales and Purchase Analysis,
Location wise Stock Management, Analysis by Dealer or Retail channels



Vehicle Order Processing System
: Target, T
ask, Leads, Prospects, Quotation,
Order, Delivery. (Customer Details, Booking Details, Payment Details, Dealer
-
wise
Details, Customer complaint management, Sales inquiry & Analysis system )



Workshop Billing System
: Warranty claim analysis (Labour/Spares/Lu
be), Job wise
analysis (Labor/Spares/Lube)
, Pre Delivery Inspection (PDI), Free Service, Paid Jobs.



ERP
: Vehicle Sales, Spare Parts Control (Inventory Control), Servic
e, HRM,
Accounts, Admin
.



Currently heading ERP teams across entire state of Renault Car
India Pvt Ltd.



Managing Online Incident
Management
Tracking module of Renault India Pvt
Ltd.(EDP Support Activities & DMS General



Helpdesk Co
-
ordination
)
.



Managing Online Renault Assist.
-

One kind of online dynamic support relate to Sales,
Service and P
arts.



Define systems strategy, system requirements, design and prototyping, support
procedures and overall successful implementation of practical business solutions.






Page
8

of

14



Participate in all development, configuration and customization decision making to ensure
successful project launch
.



Ability to manage the delivery of a project and a team, working with teams globally.



Provide direction to development teams for custom solution realization and participate, as
necessary, in coding, testing, documentation, go
-
live

and maintenance support activities
.



Perform high
-
level analysis of customer business processes and requirements and
architect custom end
-
to
-
end solutions that meet business requirements
.




Good understanding of Quality Assurance processes & Software Develo
pment Life Cycle
.



Manage appropriate use of IT project management tools, processes, and methodologies
.



Manage effective integration management throughout the life cycle of the project
.



Develops and maintains detailed project plans
.



Reviews program material

and provides timely feedback as appropriate
.



Manage project deliverables meet stated expectations for scope, quality, cost, timing, and
business objectives
.



Identifies issues, assesses impact and executes resolution.



Develops periodic reports on a variety

of subjects including status, risks and mitigation
plans, issues and resolution, and change requests.



Develops, motivates, manages and provides leadership for team members



Manage
training requirements and plans for project team
.



Managing
RVA ( Renault Vir
tual Academy)

web based training portal for the

sales team
.


RENAULT ASSIST
-
TRACKING SYSTEM


Renault Touch



Renault Assist



Incident Management



Lead Management Tool



Renault dot Net Full Internet


IRIS : Improved Reporting Information System for Sales
, Marketing and After

Sales



Dashboard

Yearly (compare the current with previous)

Quarterly (Q1,Q2,Q3,Q4)

Monthly

Daily

o

Enquiry Analysis

o

Test Drive Analysis

o

Booking Analysis

o

Retail Analysis

o

Wholesale Analysis



KPI (Key Performance Indicator)

o

Open Enquiri
es

o

Retail Conversion

o

Test Drive Ration

o

Sales Performance

Region

Enquiry (Total)

Enquiry Targets

Enquiry (% to target achieved)



Result

o

Test Drive, Test Drive Target, Test Drive Conversion Ratio, Test Drive % to target
achieved

o

Booking, Booking Target, Boo
king Conversion Ratio, Booking % to target achieved

o

Retail, Retail Target, Retail Conversion Ratio, Retail % to target achieved






Page
9

of

14

o

Wholesale, Wholesale Target, Wholesale Conversion Ratio, Wholesale % to target
achieved



KPI (Key Performance Indicator)



Dealer V
olume Ranking (Retail National Ranking


YTD AND MTD)



Dealer Target Achievement



Top
-
N
-
Analysis

o

Enquiry Analysis (Enquries, Accumulated %, % Contribution)

o

Test Drive Analysis

o

Booking Analysis (Booking Volume, Accumulated %, % Contribution)

o

Retail Analysis



Wholesale Analysis (Wholesale Volume, Accumulated %,
(
Contribution)



Trends

o

Enquiry Analysis

o

Open Enquiry (Carry Forward)

o

Enquiry Received

o

Booking

o

Dropped

o

Open Enquiry (Current month)

o

Test Drive Analysis

o

Enquiry Received

o

Test Drive Done

o

Satisfied with Tes
t Drive

o

Test Drive Ratio

o

Booking Analysis

o

Enquiry Received

o

Booking

o

Booking cancel

o

Back Orders

o

Booking Ratio

o

Retail Analysis

o

Enquiry Received

o

Retail

o

Cancelled

o

Retail Ratio

o

Wholesale Analysis



Enquiry Analysis

o

To date open enquiries distribution

o

Monthly open
enquiry status of enquiries opened in the month



Reports

o

Daily Progress Report

o

Daily Dealership Enquiries Snapshot

o

Daily Sales Report

o

Dealer wise Progress Report

o

Daily source wise Report

o

Executive wise Modelwise

o

Daily Progress Report (MTD)

o

Day, Walk In,Tele
phone, LMT, Call Centre / Toll Free No,
Advertisement, Events, Referred, Prospects, Test Drive, Hot
Prospects (New), Hot Prospects (Cancelled), Hot Prospects
Accumulated, Delivery, Delivery cumulative, Back Order, Booking
Loss, Despatch, Vehicle in Transit
, Received, Physical Stock
Cumulative, TD strike ratio, CR ratio

o

Daily Dealership Enquiries Snapshot

o

Dealer Name, City, Models, Opening enquiries for the month,
Enquiries received for the month, Enquiries not follosed up > 48 hours
(new enquiries), Enquiry

pending follow up (new enquiry), Pending 2
-
7
days (new enquiries), Pending beyond 7 days (new enquiry)

o

Daily Sales Report






Page
10

of

14

o

Model, opening stock, opening back order, wholesale MTD, Booking
MTD, Booking Cancelled
-
MTD, Back Orders, Closing Stock, Free
stock,
Monthly allocation, Balance dispatch

o

Dealer wise Progress Report

o

Today Walk
-
In, MTD Walk
-
In, Total prospect target, Today total
prospect, MTD total prospect, Total prospect achieved (%), Test Drive
target, Today test drive, MTD test drive, Test drive/prosp
ect, Booking
Target, Today Booking, MTD Booking, Booking Achieve (%),
Conversion ratio,Test drive to booking ratio, Retail Target, Today
Retail, MTD Retails, Retail Achieved



Daily Progress Report (MTD)

o

Day

o

Walk
-
In

o

Tele In

o

LMT

o

Call Centre / Toll Free No

o

Adv
ertisement

o

Events

o

Referral

o

Prospects

o

Test Drive

o

Hot Prospects(new)

o

Hot Prospects (Cancelled)

o

Hot Prospects (accumulated)

o

Delivery

o

Delivery Cumulative

o

Back Order

o

Booking loss

o

Despatch

o

Vehicle in Transit

o

Received

o

Physical Stock (cumulative)

o

TD strike Ratio

o

C
R Ratio



Daily Dealership Enquiries Snapshot

o

Dealer Name

o

City

o

Model

o

Open with enquiries with month

o

Enquiries received for the month

o

Enquiries not followed up > 48 hours (new enquiry)

o

Enquiries pending followed up (new enquiry)

o

Pending from last 2
-
7 days (ne
w enquiries)

o

Pending beyond 7 days (new enquiry)



Daily Sales Report

o

Model

o

Opening Stock

o

Opening back order

o

Wholesale MTD

o

Booking MTD

o

Booking Cancelled MTD

o

Back Orders

o

Closing stock

o

Free stock

o

Monthly allocation



Dealership wise Progress Report

o

Today Walk In

o

MTD Walk In

o

Total Prospect Target






Page
11

of

14

o

Today total prospects

o

MTD total prospect

o

Total prospect achieved (%)

o

Test drive target

o

Today test drive

o

MTD test drive

o

Test Drive / Prospects

o

Booking Target

o

Today booking

o

MTD booking

o

Booking achieve (%)

o

Conversion ratio

o

T
est drive to booking ratio

o

Retail target

o

Today retail

o

MTD retail

o

Retail achieved

o

Back order opening

o

Booking cancel

o

Back order closing

o

Wholesale target

o

MTD wholesale

o

Wholesale today

o

Wholesale (% achieved)

o

Opening stock

o

Closing stock



Daily Service wise Repor
t

o

Enquiry Source

o

Test Drive

o

Booking

o

Retail



Executive wise Model wise Report

o

State

o

Dealer

o

Salesman

o

Enquiry (model)

o

Test Drive (model)

o

Booking (model)



Manpower Matrix

o

Dealer Name

o

Dealer Code

o

Location

o

Sales executive name

o

Work Profile

o

Educational qualificatio
n

o

Work experience(Auto)

o

Work experience (Total)

o

Employee joining

o

Employee Leaving

o

Duration (Monthly)

o

Training Induction



Ageing Reports

o

Stock ageing

o

Dealer Name

o

4
-
6 weeks

o

6
-
8 weeks

o

12
-
16 weeks

o

Total



Customer Profiling






Page
12

of

14



Adhoc reports



SNAP
-
ON
TOOLS
FOR B2B (
ANA
LYSE
FINANCIAL DATA

OF


DEALERSHIP
)


TRAINING TAKEN AT
RENAULT INDIA PVT LTD

MANAGEMENT CENTRE
-
CHENNAI
,
TAMILNADU, INDIA



Rolling Forecast


Expected vehicle delivery for rollover customer



Prospective list


Leads
of vehicle from marketing team



Manage RNFI (
it contains
GUI based online
Lead Management Tool, Online Assist
and Improved Reporting Information Systems
)



Customer Tracking System


Managing Lead data (competitor)



Key Account Management (KAM)


Priorities g
iven to key account customer



Customer Database Management (CDB)


containing the details of current month sale



Master Plan of Business (MPB)


evaluate the data
with competitor
.



To prepare Events Management program data



To prepare Target Verses Achievemen
t Analysis



Pre
-
Delivery Statement (PDS)


To prepare the statement for vehicle delivery
-



TAT
-

Turn Around Time analysis.



Managing Electronic Pre Delivery Inspection of Vehicle



Managing Electronic Warranty Claim Analysis



DAR


Daily Activity Report Analys
is



DAS


Daily Activity Services Analysis



ROT


Repair Operation Time



EWP


Extended Warranty Pack



ESP


Extended Service Pack



SOP


Standard Operating Procedure



SQA


Service Quality Architecture



MSL


Minimum Stock Level (Parts)



VOR


Vehicle Off Road



VU
R


Vehicle Under Repair



VRR


Vehicle Receipt Report



SMT


Special Maintenance Tools.



LTO


Labor Turn Over



AMC
-

Annual Maintenance Contract



MS


Market Share



SM


Service Marketing



CSD
-
Customer Service Data



SMS


Service Market Share



PPR


Product Perf
ormance Report


Title: Software Programmer


Duration: 1991
-
1992

Central Bank of India, A
hmedabad
, G
ujarat
, I
ndia

(
Domain Name

: www.centralbankofindia.co.in)

Central Bank of India is one of the largest Nationalised Bank with 2500+ branches in

India & abroad. The
main responsibilities included:



Supporting the Existing software packages and application.



Analysis, Design and Development of in
-
house Account Management System with Customer
Account Maintenance,
Savings

Accounts, Fixed Deposit, NRI,
Loans and Advances Account
Maintenance, Product Calculation, Interest Calculation



Prepared Balance sheet of entire Gujarat State using MS
-
Excel.


Title: Programmer


Duration: 1990
-
1991

PIPS Ltd. A
hmedabad
, G
ujarat
, I
ndia






Page
13

of

14

PIPS Ltd. is a consul
tancy company with departments in Software Development and Hardware
Maintenance. The company had software and/or hardware maintenance contracts of clients in Gujarat.
Main Tasks included:



Maintaining software and hardware systems for PIPS clients



Handling

Customer Support Calls



Involved in up
-
gradation, Backups, Recovery, Data Conversion, Broadcasting of Messages

Certifications



Oracle Certified Professional


9i, Oracle Corp USA, 2005



Brainbench Certified Professional in COBOL, USA

Education



Currently I
am doing

EXECUTIVE
MBA

WITH FINANACE
(
3rd

semester)

from Sikkim
Manipal University (UGC Approved) from Ahmedabad distance learning centre.



Masters in Computer Applications (MCA)


2002
-
2004


Indira Gandhi National Open
University, New Delhi


India (
Domain

:
www.
ignou.ac.in


Roll No : 000451055
year : 2004
check option Grade Card)



One year Diploma in Computer Programming and Application (1990) Apple
Information

&
Technology Division


National Computing Centre (NCC), U.K



Awards/Training

/ Achievements



S
uccessfully installed, implemented and connected principal’s ERP across entire state of
Gujarat
(Total 9 Branches)



Successfully installed, implemented and connected principal’s ERP across entire state of
Gujarat (Total 3 Branches)



Hand on Experienced on Ch
eckpoint Installation.



Achieved First rank (L.J.IGNOU CENTRE, Ahmedabad,India) in MCA project for Car Rental
System (Project done in ORACLE/D2K VER.7.0/4.0/2.5)



Achieved First rank (L.J.IGNOU CENTRE, Ahmedabad,

India) in MCA project and tutor mark
assignme
nt in COBOL, RDBMS and NETWORKING



Achieved
Second R
ank (
Institute Of Business Management and Research
,

Drive
-
In Road,

Ahmedabad,India) in M
BA (Finanace)
project for
Home Loan Products Comparison.



Nominated twice for AUTO EXPO Exhibition (World’s best Manuf
acturers of Automobile in
CAR, LCV, HGP segment and leading best manufacturers of spare parts
-
fasteners
), New
Delhi, India.



Availed training of Unix basic execution of commands during MCA



Taken training of E
-
Tendering System for Govt. Department with digi
tal signature process

(nProcure.com)



Undertaken software development and hardware training (Three Tier) conducted by Principal
company



Successfully taken training on ASHOK LEYLAND
CUSTOMER CONNECT

online training
program at
ASHOK LEYLAND MANAGEMENT CENTRE,

Ho
s
s
u
r (Tamilnadu) for Vehicle Pre
-
sales and Sales Module




Successfully taken training on ASHOK LEYLAND
CUSTOMER CONNECT

online training
program at
ASHOK LEYLAND MANAGEMENT CENTRE,
Houss
u
r (Tamilnadu) for Vehicle
Service Module



Successfully taken training

on ASHOK LEYLAND
CUSTOMER CONNECT

online training
program at ASHOK LEYLAND MANAGEMENT CENTRE, Hoss
u
r (Tamilnadu) for Spare Parts
Module



Successfully taken training from ASHOK LEYLAND on “ALERT”


[1] CRM :
-

Customer
Relationship Management Application [2]

DRM :
-

Dealer Relationship Management
Application (Telematics Services on Road Transportation Paradigm
-
GPS & GSM Technology)



Successfully taken training from
Renault

India Pvt Ltd (RIPL)

Car (France), Chennai
on
DMS
(Autodeal
-
Pre
-
sales, Sales and IT (EDP)
)



Successfully taken training from Ahmedabad RTO (Regional Transport Office) of remote
Electronic Vehicle Temporary Registration (C.R.Temp)



Successfully taken training from ASHOK LEYLAND on RFID (Radio Frequency Ide
n
tification)






Page
14

of

14




Management Pro
gram.



Successfully
completed Global IT Audit of Renault India Pvt Ltd across Entire State of Gujarat.



Successfully completed SNAP
-
ON Tools (B2B
-
Financial data) training at Renault India Pvt
Ltd, Mumbai.



Successfully accomplished SAP Hardware
/Software

modul
es
(Hands
-
on)

from Harsha
Engineering, Ahmedabad, Gujarat, India.

(www.harshaengineers.com)



FI Financial Accounting


essentially your regulatory ‘books of record’



CO Controlling


basically your internal cost/management accounting



AM Asset Management


tra
ck, value and depreciate assets



PS Project Systems


manage projects, large and small



HR Human Resources


Recruiting and Planning of People powers



PM Plant Maintenance


maintain equipment (e.g. a machine)



MM Materials Management


the supply chain ma
nagement



QM Quality Management


improve the quality of goods



PP Production Planning


manages production process



SD Sales and Distribution


from order to delivery



PLM Product Lifecycle Management



MDM Master Data Management



REM Real Estate Management



L
E Logistics Execution



SCM Supply Chain Management



EWM Extended Warehousing Management



KM Knowledge Management



CRM Customer Relation Management



QM Quality Management



HCM Human Capital Management



APO Advance Planner & Optimizer



Designed and implemented netwo
rk infrastructure for offices
across entire Gujarat State



(WAN)
users with Cisco network

and Info VPN

infrastructure in Windows environment.



Implementation

of Cisco
5510 series
firewall
with Anti Virus guard card



Implemented windows 200
3

clus
ter with 2
Xeon 3.0 servers.
.



Implementation of
MPLS and Broadband

line connectivity for remote offices with VPN



Designing the Cabling for the entire
State

networ
k.



Installing and configuring servers, Configuring active directories joining multiple server
s


O
ver

Wireless

LAN and WAN



Creating Global and Local Groups, assigning permissions



Implemented Group and Backup policies



Installed Hubs,
Manageable/Unmanageable
Cisco
Switches etc. Administering / supporting


networks
.



Configurin
g CISCO
-
1700
, 1741

&
C1921

series routers
for
MPLS

(128 / 512 hbps)
,

LAN
(wireless)

Connect, Lease line and

WAN
(wireless)

connectivity.



Creating Mailboxes, assigning permissions
.



Rebuilding and restructuring exchange servers.


Notice Period

:

45 days.


Ref
erence :
Mr.Hemant Sharma, Managing Director, Emhart Teknologies India Pvt Ltd,
Chennai. Email ID :
hemant.sharma@bdk.com



Mukesh N. Bhatt