Project Customer

SUDIP BHATTACHARYYA

*** * ***** **., ***# ****, Coppell, TX, 75019, USA

Phone: +1-972-***-**** (Mob.), +1-210-***-**** (Res.)

Email: *********@**********.*** / *****.*****************@*****.***

PROFESSIONAL SNAPSHOT

o A result-oriented professional with 12 years of experience in

- Inventory Management - Data Mining & Statistical

Modelling

- Project Management - Implementing Business Impact

Projects

o Currently working with Hewlett Packard (India) Pvt. Ltd. as Business

Operations Manager

o Experienced in managing advanced analytics projects that design, build

and implement statistical models as a business solution for customers

across industries

o Provide analytical support for cross-functional corporate initiatives on

customer & service intelligence

o Leading teams to ensure the accomplishment of service deliverables

o Skilled at planning & scheduling work, setting goals & standards,

identifying & solving problems

o Strong analytical, problem solving skills with an eye for detail along

with an eagerness to learn and an ability to work under stress

o Excellent communication and interpersonal skills

CORE COMPETENCIES

Inventory Optimization ABC Analysis Demand &

Sales Forecast

Overstock & Redeployment Warranty Analysis Spare

Part Optimization

Sales Order & Vendor Management Compliance Metrics E&O

Material Management

Regression Predictive Modeling Product

Affinity Model

Market Basket Analysis Sequential Analysis Campaign

Management

Customer Segmentation Decision Tree Marketing

Analytics

ORGANISATIONAL EXPERIENCE & RESPONSIBILITIES

Since February, 2011 with Hewlett-Packard (India) as Business Operations

Manager in GPSC Inventory Operations

o Providing support to HP Global Inventory organization with valuable

inventory reports used in key metrics and organizational score cards.

o Leading initiative on Inventory Overstock Management to help organization

to increase profitability by significantly reducing inventory cost.

o Managing Parts Rebalancing project and coordinated with different

Business Units across regions to implement it successfully.

o Working with HP vendors on Parts Scrap project under E&O (Excess &

Obsolescence) model.

From July, 2006 to February, 2011 with Hewlett-Packard (India) as Business

Operations Manager in GPSC PLM organization

o Led PSG Program Management team in Global Parts Supply Chain (GPSC)

organization.

o Managed support processes to GPLM and GPSC Engineering in maintaining the

complete Product Lifecycle of spare parts starting from New Product

Initiation (NPI) to End of Service Life (EOSL).

o Worked with the suppliers and vendors to implement engineering changes of

serviced spares.

o Communicating ideas and solutions to problems & briefing clients on the

inferences drawn from various data driven analyses.

From May, 2005 to July, 2006 with Evalueserve, Gurgaon, India as Senior

Business Analyst

o Generated and executed thought leadership ideas and solutions for the

clients to achieve business targets.

o Opportunity assessment for the new clients and provide solutions with

estimated business impacts.

o Handled various types of analytical projects in Retail/CG, BFSI and Web

Analytics space.

o Performed Statistical Analysis & Data Modeling using techniques like

Segmentation, Linear & Logistic Regression, CHAID/CART, Market Basket

Analysis etc.

o Developed algorithms and SAS coding.

o Model testing and implementation.

o Business presentation to clients.

o MIS Reporting.

From October, 2004 to April, 2005 with IMRB International, India as

Analysis Executive

o Worked on analytics projects for one of the leading Indian corporation in

tobacco industry.

o Analyzing response data obtained from Sample Survey based on designed

questionnaire.

o Optimal product recommendation to clients.

o Data Cleaning and mining using Quantum.

o Database designing using ADL.

o Data Analysis using SPSS.

From October, 2003 to September, 2004 with Bridgetree Research Services,

Kolkata, India as Statistical Database Analyst

o Worked as data analyst on Marketing Analytics projects for a major US

client (Home improvement retail chain).

o Performed customer segmentation, profiling, campaign management.

o Worked on campaign management, store opening promotional campaigns and

measuring campaign effectiveness.

o Data mining and analysis through SAS programming and report generation.

o Creating effective models for analysis & prediction, using SAS, SPSS &

ANSWERTREE.

o Preparation of Mailing lists for US clients.

o Address standardization using MAILMANAGER & MAILERS+4.

From May, 2003 to October, 2003 with Sayantan Management Consultant Pvt.

Ltd., India as Statistical Research Associate

o Worked in statistical research projects on sick industries for BIFR

(Board for Industrial & Financial Reconstruction).

o Data mining, analyzing and interpreting financial data using SPSS &

Advanced Excel.

Relevant Key Project Experience

Hewlett Packard

Overstock Management & Rebalancing

Project Abstract "Inventory Overstock & Parts Rebalancing" was an initiative taken

& Proposed to reduce inventory cost. The primary objective of this project was

Solution to identify excess inventory at country and regional level and to

make it visible to the planners across the globe.

The excess stock is rebalanced with other countries/regions,

wherever the shipment is financially viable, to meet the demand for

receiving country or region. This helped the receiving region to

reduce the inventory cost significantly by avoiding "New Buys".

A "Selective Inventory Control" derived from ABC Analysis was done

to identify the highly significant buckets purchasing new parts

Tools Used where a redeployment could be considered. A monthly metric on

"Redeployment Compliance" is reported in Global Inventory

Scorecard.

SAP NetWeaver Business Client, BW Reports, MS Access & Excel, SQL,

Power Point

Warranty Analysis

Project Abstract The key objective of this project was to build a strategy to have a

& Proposed better control on warranty claims.

Solution Based on historical claims a "Trend Analysis" was performed to make

a more realistic warranty cost estimates.

Warranty cycle times were captured to maintain optimum stock

reserves by regions/vendors/product lines. This analysis

significantly helped to minimize product recalls and also to reduce

response time and thereby improving customer experience.

Tools Used BW Reports, MS Access & Excel

Inventory Growth Analysis

Project Abstract Year to year Inventory growth was analyzed at regional level for

& Proposed different business units within HP. The output was further drilled

Solution down to spare parts level to identify the major contributing parts.

The results were shared with the planners to guide them for more

accurate planning on future demand and thereby reducing the overall

inventory cost.

SAP NetWeaver Business Client, MS Access & Excel

Tools Used

Inventory Reports

Project Abstract The team was responsible to publish multiple key inventory reports

& Proposed periodically. The major reports were:

Solution Weekly Inventory Snapshot

Monthly Inventory Report and Pricing worldwide

Quarterly E&O Report

SAP NetWeaver Business Client, BW Reports, SQL, MS Access, MS Excel

Tools Used

Evalueserve

Web Analytics - Leading Overseas Research Centre for an Media Client in US

Project Abstract Worked as a principal consultant in the Overseas Research Centre

& Proposed (ORC) that was set up by Evalueserve for a large US based internet

Solution media client. This ORC worked closely with the client on various

initiatives such as to design promotions, analyze customer behavior

and thereby help client on making strategic decisions to increase

profitability.

The responsibilities involved managing projects on Market-Basket

Analysis, Sequential Analysis (to study the browsing pattern of the

web-portals and association between them), browsing pattern

identification for their customers, search engine optimization.

Data mining, advanced SAS coding, building data models,

interpreting results were key responsibilities.

Tools Used

SAS Base, SAS SQL, MS Excel, Power Point

Predictive Models for Multinational Bank in Europe

Project Abstract It was a project to identify the most prospective customers for

& Proposed private banking facility of a leading multinational bank

Solution headquartered in Europe.

The project was carried out in two phases according client needs.

In the first phase client wanted to identify the demographics and

transactional behavior of the customers who avail their private

banking facility based on their existing customer data base. The

client also wanted to have a pointer guidance to target customers

who do not have private banking but are most likely to avail the

facility, if approached.

Job responsibilities involved Data Analysis, building predictive

data models, generating scores and also presenting output in

Tools Used business language to client.

SAS Base, SAS SQL, MS Excel, Power Point

Customer Segmentation & Profiling

Project Abstract A marketing analytics project involving segmentation of a Beer

& Proposed market. The end client's objective was to identify its most loyal

Solution customers and those customers of its rivals whom they can target

with the biggest amount of success.

Once identified, the client wanted a detailed breakup of customers

belonging to these segments according to the psychological need

motivating their beer consumption (Customer Segmentation &

Profiling).

Tools Used

SPSS, MS Excel

IMRB

Blend Tests and Pack Tests of Tobacco Products

Project Abstract Manufacturing Companies in the Tobacco/Consumer Industry are often

& Proposed willing to test four variables: trial, repeat, adoption and

Solution purchase frequency of their existing products as well as new

products/variants. Thus they survey buyer's intention for different

blends/packs through a monadic rating system.

Job responsibilities included analyzing blend wise data for

respondents and coming up with the optimal product recommendation

for the marketing managers.

Tools Used Quantum, ADL

Development of TGI (Target Group Index) database

Project Abstract A Target Group Index (TGI) database is a repository of data

& Proposed relating to consumer buying habits. It facilitates corporate houses

Solution (viz. ITC, HLL, Reliance) to evaluate the overall attractiveness of

the different market segments. About 50,000 respondents in 14

states of India are quizzed about their buying habits and the

information is summarized in a Choices database.

Responsibilities included interacting with the Field personnel to

ensure proper administration of the questionnaire. The huge amount

of data that was generated had to be edited using Quantum and the

database was prepared. Finally cost estimation of the project was

carried out using company defined strictures.

Quantum, SPSS, ADL

Tools Used

Bridgetree Research Services

Product Affinity Model for Retail Chain

Project Abstract The key objective of this project for a US based leading home

& Proposed improvement store was to understand the co-occurrence of product

Solution purchase behavior of customers and address questions like what are

they selling, how many units are moving, the sales amount and the

likelihood of two (or more) items being purchased together.

Job responsibilities involved exploring the data to structure the

model to perform Market Basket Analysis, perform Customer

Segmentation and Profiling based on Products and to identify the

product groups and associated product groups for the customer

segments.

Tools Used SAS, SPSS, Answer Tree, Excel

Campaign Tracking for a US Based Online Banking & Brokerage Company

Project Abstract Conceptualized, developed and implemented the critical success

& Proposed factors for establishing the "Campaign Tracking team". Designed and

Solution implemented tracking dashboards for new customer acquisition

programs. The dashboards were shared with the senior executives.

The new dashboards provided insights into early indicators of

profitability, like trading behavior, allowing senior management to

quickly identify unsuccessful programs and either eliminate or

alter them.

Tools Used SAS, Excel

EDUCATIONAL CREDENTIALS

o M.Sc (STATISTICS) from Calcutta University, Kolkata, India

o PGCIT (Post Graduate in Information Technology) from RCC, Jadavpur

University, Kolkata, India

COMPUTER PROFICIENCY

o Software: SAP NetWeaver Business Client 4.0, SAS Base, SAS STAT, SAS EM,

SPSS, AnswerTree

o MS Office: MS Access, Advanced Excel, MS Power Point

o Data Base Management: SQL, SAS SQL, Quantum

PERSONAL DETAILS

o Address : 215 N Moore Rd., Apt# 1122, Coppell, TX, 75019, USA

o Contact No. : +1-972-***-**** (Mob.), +1-210-***-**** (Res.)

o Work Permit : Green Card

o Hobbies : Reading, Solving puzzles, Sports, Music

Contact this candidate