Data Professional Experience

Ishita Mandal

Eden Rose Complex, Beverly Park, Contact: +91-750*******, +91-986*******

Mira Road (E), Thane-401107, Email: ******.******@*******.*** Maharashtra ******.******@*****.***

Education

IIT Bombay [2013 – 2015]

M.Sc. in Applied Statistics & Informatics

Relevant Coursework: Regression Analysis, Biostatistics, Statistical Inference, Probability Theory, Multivariate Analysis, Time Series Analysis, Categorical Data Analysis, Data Structure, Design of Experiments.

University of Calcutta [2010 – 2013]

B.Sc. in Statistics Hons.

Relevant Coursework: Sample Survey, Demography, Statistical Quality Control, Index Number. Professional Experience

Vserv Digital Services Pvt. Ltd. Mumbai, Maharashtra Research Analyst [June 2015 – Present]

1. VMAX Monetization: [Jan ’15 – Present]

Mobile App Monetization and provide solutions for yield maximization

Currently working on improvement of mediation algorithm for app monetization platform called VMAX™ for app developers to maximize their revenue

Built an automated process using Hadoop-R, AWS-EMR, MySQL and Apache Hive which generates three reports on daily basis and send to various related teams based on client data.

Implemented weight assignment algorithm based on ‘Bandit algorithm’ to assign appropriate weights to ad-networks so that revenue per request maximized. 2. eCPA goal achievement: [Sept ‘15 – Dec ‘15]

to enhance existing algorithm and find new features for increasing prediction accuracy

Implemented optimization algorithm, based on Linear Programming problem solving approach

(using Solver in Excel and R software) to achieve eCPA goal for advertiser.

Performed multiple simulations on training sets with multiple time windows 3. Click Fraud Detection: [June ‘15 – August ‘15]

to find and report suspicious publishers generating fraud clicks in PPC campaigns

Used Apache Hive to query various summarized data from historical click and impression data

Analyzed such summarized data using cluster analysis in R and other techniques to define rules to identify suspicious publishers based on high clicks and CTR

Created reports on the following:

a) Time difference analysis (impact of time diff within clicks of same user) b) Creativeid analysis (impact of frequency of clicks from same user for same creativeid)

Indus Media & Entertainment Pte. Ltd. Mumbai, Maharashtra Intern [July 2014]

Analysis of the Growth and Profit of Hollywood Movies (2007-2014)

Analyzed the effects of the factors (opening weekend turnover, theatre count, budget, IMDB rating & award nominations) responsible for box office turnover of the Hollywood movies (genre: Horror, Comedy & Action) released worldwide from 2007-2014 (using MINITAB & MS-Excel).

Fitted the best Regression Model using Multiple Linear Regression for the response variable

“Worldwide Box Office Turnover” for all the three genres: Horror, Comedy & Action.

State Bank of India Diamond Harbour, West Bengal Summer Intern [May 2013 - June 2013]

Study effectiveness of various publicity medium in rural & semi-urban regions and find out effective modes of advertising based at Diamond Harbour, Canning & surrounding SBI branches.

Collected raw data through questionnaire and analyzed the most preferred advertising mode

Analyzed the customer satisfaction level of SBI facilities in rural areas

Identified the hardships faced by the branch managers to increase business in their respective areas

Explored the perception and conception of the customers towards SBI products

Got brief idea about the environmental factors affecting SBI’s performance Academic Projects

Impact of Base Rate on Lending Rate Transparency in India [July 2014 - April 2015] M.Sc. Project, IIT Bombay

[Guide: Professor Ashish Das, Dept. of Mathematics, IIT Bombay]

Regressing different components of Base rate of Public, Private and Foreign Banks

Extracting the best methodology to compute the Base rates

Model Selection and Identification of the factors affecting Osteoporosis in women [Sept ’14 - Nov ‘14] Bio Statistics Course Project, IIT Bombay

[Guide: Asst. Professor Siuli Mukhopadhyay, Dept. of Mathematics, IIT Bombay]

Data was based on the data collected at Hiranandani hospital, Mumbai

Used the skills of Multi Categorical Data Analysis and Statistical Software R

Found various factors which may lead to osteoporosis using logistic regression and chi-square tests

Longitudinal Study to follow the change in pulmonary function on historical data of 654 patients [Aug ‘2014] Bio Statistics Course Project, IIT Bombay

[Guide: Asst. Professor Siuli Mukhopadhyay, Dept. of Mathematics, IIT Bombay]

Data was on 654 patients who were seen in the Childhood Respiratory Disease Study in East Boston, Massachusetts.

Obtained appropriate descriptive statistics for each variable (both numeric and graphic).

Assessed relationships among the responsible factors separately for boys and girls.

Compared the pattern of growth of FEV by age for boys and girls. Technical & Programming Skills

Statistical Software: R, Hadoop-R, Minitab, SAS, SPSS

Language: C, C++, Oracle- 10G

Tools: MS-Excel, MS-Powerpoint, MS-Word

Database: Apache Hive, MySQL

1 year of professional experience on AWS, EMR and S3 storage. Certified Courses

R Programming, The Data Scientist’s Toolbox, Exploratory Data Analysis [Coursera]

Introduction to R [Data Camp]

Explore Statistics with R [edX]

Introduction to Data Analysis using R [Big Data University]

Completion of C Test [Spoken Tutorial Project, IIT Bombay] Personal Information

Permanent Address: Sonarpur Park, Opp. Power House, P.O. Sonarpur, Kolkata-700150, West Bengal

Language Known: English, Hindi, Bengali

Hobbies: Watching Movies And TV Series, Painting, Photography, Travelling

Current Location: Mumbai, Maharashtra

Contact this candidate