 Project Name : Supermarket Business Analysis
Products Brand sales and profit analysis by cleaning data, data pre-processing, data normalisation,
clustering, regression and researching cross-selling & up-selling of different products by
hypothesis testing. The Market Basket Analysis for analysing the correlation among the products
sell and evaluating the model by extraction of support, confidence & lift factors which helps to
understand the association rule. We use to predict the sales and profits in client’s business by
using predictive modelling & ARIMA model for next 3 to 5 years and represent all the reports in
different charts and graphs placed in a proper dashboard.
 Project Name : Bahanes Food Product Analysis
Bahanes is a brand of food items & sweets where data analysis is been made to find the demand
of different product in different region of UAE & abroad. The cross-selling among the food items is
been checked after cleaning, pre-processing & normalization of data. The obtained dataset is
applied further applied on unsupervised and supervised machine learning algorithm to solve the
queries of client. The prediction of sales and profit with the analysis of some food items in
different scenario is been made for the clients for next 3 to 5 years and all the reports is been
represented by the Visual Dashboards to explain in the easiest way.
 Tools used: Excel, R Programming Language & Tableau.
 All the project management and proposals to the clients are under my responsibility. The
preparation of presentation for the clients and making them understand its benefits in their
own business and helps to make a decision as per the outcomes obtained by the analysis.

 Project Name : ACT (automatic call testing)
AT&T is holding a typical network testing solution called ACT (automatic call testing) to perform
some primary test cases on the Telecom Network. Our responsibility was to perform various data
analysis on the generated logs to identify the facts & issues in the network. We use to work on the
data which is been provided by the client segregating the meta-data into further different section
on the basis of cluster or site basis. We use to clean and pre-process the data to find the relations
between telecom network parameters and extract the clusters having issue in network and
represent them statistically how much sites are performing well and where we need to work on to
sort out the issues. By extracting the best, good & poor network serving cluster or site on the basis
of the log data. We further script on each big data table, the reasons for such issues and how to
solve it. We also represent the data visually by using such tools after the analysis on datasets
which have been divided on the basis of performance and shared to clients with proper
Dashboards.
 Project Name : Cluster Drive Testing
AT&T was responsible to perform drive test in a telecom network cluster, which generates a huge
amount of data (drive test logs) & consist all the information & meta-information of the network.
We were responsible to perform a post analysis on those data & identify whether cluster is
working well or not. We use get the data cluster wise to deal with telecom network parameters of
2G, 3G & LTE and perform analysis by cleaning, pre-processing, mining & sorting in the order of
parameters which helps to understand the network performance. The datasets is been analyzed
on different telecom network parameter and accordingly data is been divided on the site basis of
performance in each section of clusters. As per depending upon the need of clients we make the
visual reports and dashboards to make them understand the performance of cluster network.
 Project Name : Sales & Profit Analysis for Indigo Airlines
The Indigo Airlines used to provide those huge amount of data and our responsibility was to
perform various analysis on those data and provide them the prediction & analysis of their profits,
sell of tickets, increase in passengers etc using Machine Learning for next 5 to 8 years and
representing visually by making Dashboards. The Data obtained is been cleaned, pre-processed,
removing of N/A values, normalization of few variable columns, forming proper dataset for
statistical analysis such as using box plots or scatter plot. The cleaned data is been used for
clustering to extract the knowledge of correlation properties in the dataset. The Similar data
obtained in each cluster is been used for analysis and modelling. To extract the profit rate of the
client we used regression model to find independent variable results depending upon the
dependent variable as per clients provided data. On the issues, to know what number of flights
should be given in each city, profit generated & passengers quantity classification is been done for
getting statistical result how much flights should organisation provide to any city on each week.
 Project Name : Analysis on Medical Reports
The clients provides the complete report of the different patients on which they did treatment,
we use to work on these datasets by cleaning and applying all data mining and segregate the
datasets on the basis of the disease by which patient was suffering. Each dataset is been used for
analysis on various parameters which test of patients provide report and examine with the final
consequences of treatment whether that person was having that particular disease of not. Using
historical data and the client provides the current data of their patients to use machine learning
algorithm for classification of patients whether they are suffering from that disease or not.
 Tools Used: Excel, SQL Server, SAS, R Programming Language & Tableau.

 CLUSTER DRIVE TEST of 2G, 3G, 4G & VO-LTE NETWORK.
 DETECTING SWAP and rectify the OFC cables. Determining RRU & ANTENNA for required network
for optimization requirement & Troubleshooting.
 Checking & Improving the KPI of 2G, 3G and 4G NETWORK.
 Improving in Key Performance Indicators (KPI) like Call Drops, Call blocks, Congestion levels
 To check carrier aggregation in 4G LTE NETWORK and obtained bandwidth up to 100 MHz
 Making reports on MAP INFO SOFTWARE to check cluster drive DOWLOADING/UPLOADING SPEED
using THEMATIC MAP with proper LEGEND.
 Manipulation of parameters in 4G Data obtained from TEMS Logs using Excel, Advance Excel &
SQL to ANALYZE the network quality in different CLUSTERS and making network reports.

In Electronics and Communication Engineering