Sign in

Sales Data

Hyderabad, Telangana, India
September 22, 2019

Contact this candidate


Ashish Chandan

+91-983-***-****;; Hyderabad


Bachelor’s degree holder in Engineering in the field of Electronics and Communication.

Industry experience around 7.5 years with one of top IT Firms, Tata Consultancy Services Limited and HCL Technology .

Completed Post Graduation in Data Science from IIIT-Bangalore and also worked on R, Python, RevoScaleR & Hadoop.

Experience in different Machine Learning and Deep Learning projects.


PG Diploma in Data Science IIIT-Bangalore & UpGrad I CGPA 3.93 / 4 Jul 2017–Jul 2018

A comprehensive 11-month program taught by Industry experts and IIITB faculty; 7 case studies & projects; 400+ hours of academic learning & 30+ hours of industry mentoring

Consistently scored >80th percentile on all projects for data management, statistics and predictive analytics courses

●B.Tech, Electronics & Communication I CGPA 7.99/10 2011

Institute of Engineering & Technology M.J.P. Rohilkhand University, Bareilly


Call / Issue Data Analysis for building FAQ, user training based on geography, age, product, mode of ticket raised (web, mobile) for a giant US based cable company.

Sales forecasting for stores using Auto ARIMA and DeepAR (AWS)

Activity detection of human using smart phone data (accelerometer & gyroscope) to determine running, sleeping, sitting, walking, climbing and descending stairs Deep Learning and traditional machine learning methods.

HR Case Study to Determine Attrition: Predicted employee likely to leave organisation by analysing a company data of one year having 4000+ employees using Logistic Regression with 75% accuracy.

Uber Supply-Demand Analysis: Use Exploratory Data Analysis to determine supply and demand of Uber cabs at airport during different time of a day.

Car Price Prediction: Predicted car prices for a new firm entering in market by building Linear Regression model on a dataset of 205 car models.

Lending Club Fraud Detection (EDA): Lending Club is peer to peer lending firm. Performed Exploratory Data Analysis to determines driving factors behind loan default.

Handwritten Digit Recognition: Used a MNIST data which is a large database of handwritten digits where we have pixel values of each digit along with its label. Used Support Vector Machine(SVM) technique with different Kernels to get best accuracy.

Retail-Giant Sales Forecasting: “Global Mart” is an online store super giant having worldwide operations. It takes orders and delivers across the globe and deals with all the major product categories - consumer, corporate & home office. Used Time Series analysis (classical decomposition and auto ARIMA) to forecast the sales and quantity for the next 6 months (for 2 most profitable segments).

The New York City Taxi & Limousine Commission: The data given provide details of trips made by the taxis in the New York city. Exploring the trip data using Hive in AWS.

NYC Parking Tickets: The dataset contains details of parking violation tickets connected by NYC Police Department. Exploratory Data Analysis was performed in SparkR in AWS.

Ecommerce Capstone Project: Calculated ad stock for different mode of media. Derived different KPIs like holidays, discount, mode of payment etc. and build models like Linear, Multiplicative, Koyck and Distributed lag models to find driving factors for GMV(Gross Merchandise Volume).

Details of the project and assignments undertaken in the program can be viewed under:


Data Analyst Jun 2019 - Present

HCL Technologies, Hyderabad

Client : DBS Bank

Trade data analysis to trigger any kind of fraud for institutional banking trade on monthly and daily basis.

Creating indicators to find dispute invoice, overdue invoice. Creating triggers for audit team.

Issue data Analysis Aug 2018 – May 2019

Machine Learning Engg.,Tata Consultancy Services, Kolkata

Client: Comcast

Analysing call/issue data for the purpose of building FAQ, educating users.

Sentiment analysis on call/issue log.

Activity Detection Jun 2018 – Aug 2018

Machine Learning Engg.,Tata Consultancy Services, Kolkata

Activity detection of human using smart phone data (accelerometer & gyroscope) to determine running, sleeping, sitting, walking, climbing and descending stairs Deep Learning and traditional machine learning methods.

Sales Forecasting Jan 2018 – May 2018

Machine Learning Engg.,Tata Consultancy Services, Kolkata

Client: Comcast

Sales data forecasting for stores/region using DeepAR (AWS) algorithm.

Determining driving factors for sales using LIME & SHAP.

Extract Transform Load

Hadoop Developer, Tata Consultancy Services, Kolkata Nov 2015- Dec 2017

Client: Comcast

Worked as a Hadoop developer to develop a data mart in HDFS of equipment data. Used ETL (Extract Transform Load) techniques to sqoop data from MySQL and Oracle database to HDFS and formed SCD (Slowly Changing Dimension).

Led a team of 10 members from technical prospective to ingested 200+ tables in 2 months.

Transition & Service Governance

Team Member, Tata Consultancy Services, Kolkata Oct 2014-Oct 2015

Client: FriendsLife Insurance

Reviewing different projects (new services) considering Service Management point of view, and also coordinating with technical groups to understand their requirements to support the service as BAU (Business As Usual).

Analysing Service Desk call details, prepare & work with technical teams to implement measure to improve customer satisfaction (CSAT).

Infra-structure Support

Problem Manager, Tata Consultancy Services, Kolkata Feb 2013-Sep 2015

Client: FriendsLife Insurance

Worked as Problem Manager, responsibility includes understanding client infrastructure and its issues, Coordinating with different resolvers (technical) towers to find root cause of the issues and providing fix so that the same can be avoided in near future.

Initial Project Process Setup

Team Member (Transition Management- Service Management),

Tata Consultancy Services, Kolkata Aug 2012-Jan 2013

Client: FriendsLife Insurance

Worked in Transition project as a Team member for transition of Service Management includes framing process for carrying Incident Management, Problem Management, Change Management etc. Moreover, to train the Technical towers about the process to be developed.

Initial Learning Program(ILP)

Trainee, Tata Consultancy Services, Chennai Mar 2012-Jun 2013

As a trainee during initial learning phase, have been trained in different phases of IT Infrastructure Library (ITIL), and its processes and functions. ITIL lifecycle phases include Service Strategy, Service Design, Service Transition, Service Operations and Continuous Service Improvement (SIP). Processes include Demand management, Financial Management, Risk Management, Security Management, Asset and Configuration Management, Problem Management etc. Functions include Help Desk, Technical Management, IT operation Management and Facility Management.


Machine Learning: Linear regression, Logistic regression, KNN, Modelling Techniques, Naive Bayes classifier, Support Vector Machine (SVM), Decision Tree, Bagging, Boosting

Deep Learning: Multi-Layer Perceptron (MLP), Convolution Neural Network (CNN), Recurrent Neural Network (RNN), Long-Term Short-Term Memory (LSTM)

Analytics Languages: R (Intermediate), Python (Intermediate)

Visualization tools: Tableau, ggplot, Matplotlib

ITIL V3: IT Infrastructure Library V3 Certified (Foundation)

Hypothesis Testing

Databases: Hadoop Distributed File System (Intermediate)

Statistics & Exploratory Data Analysis

Programming: Shell Scripting (Introductory), SQL (Intermediate), Spark (SparkR,Pyspark), Pig

Tools: Excel, Sqoop, HP ALM, UC4

Process: IT Infrastructure Library (ITIL) V3

Text Analytics: Topic Modelling (Latent Dirichlet Allocation), Natural Language Processing (NLP)

Data Analytics Packages: NumPy, Pandas, Matplotlib, Plotly, Scikit-Learn, Tensorflow Keras


Received Star of the Month award for delivering projects on time.

Got Technical Excellency Award for providing delivering ETL work.

Received On the Spot Award for training about the process during DR (Disaster Recovery) situation/BCP(Backup Recovery Plan).

Contact this candidate