Data Analyst

Siddharth Botlaguduru www.linkedin.com/in/sidbotlaguduru San Francisco, CA 408-***-**** ***.*********@*****.***

Education

Bowling Green State University, Bowling Green, OH August 2017

Master of Science in Analytics

Academic Projects

Star Schema Data warehouse:

oDeveloped backend OLAP data warehouse using Microsoft Visio, Microsoft Excel, MS Access and SQL server to facilitate customized content recommendation for a music streaming service.

Built a sales dashboard using Tableau:

oDeveloped a report to give factual insights using visualization techniques.

Customer segmentation for a Motor insurance company:

oCategorized customers into high, medium and low risk pools based on demographic data. Built a

recommendation system to predict subrogation success using text mining in SAS enterprise Miner.

Prediction of loan defaulting using R:

oUsed statistical models like decision tree, logistic regression and neural networks to predict a customer’s loan defaulting probability based on attributes such as age, marital status, debt-to-income ratio, etc.

Birla Institute of Technology and Science, Hyderabad, India August 2016

Master of Science (Honors) in Biology

Bachelor of Engineering (Honors) in Chemical Engineering

Professional Qualifications & Technical Skills

Data Processing

Data Modelling

Data Warehousing

Data Visualization

Reporting

Business Intelligence

ETL

Operations Research

Marketing Analytics

Exploratory Data Analysis

Software and Languages: C, Matlab, SQL, R, Hadoop, Python

Tools: Tableau, Visio, Microsoft Access, Microsoft Excel, SSIS, SAS Enterprise Miner

Data Mining

Statistical Testing

Regression Analysis

Machine Learning

Clustering

Predictive Analytics

Big Data Analytics

Professional Experience

Data Analyst – Intern

Akira Consultancy, Bangalore, India

July 2015 – December 2015

Collaborated with the business intelligence team to designed data flow tasks for transforming and integrating data from heterogeneous sources into an enterprise data warehouse

Contributed towards finance and profitability metric generation in a fast paced startup environment

Produced market research reports to aid the Marketing and Revenue teams to understand best marketing efforts.

Implemented a standardized method of developing metrics to help the sales team target new enterprises for business

Scheduled automated E-mails with product sales report which were sent to product managers

Business Operations – Summer Intern

Bharat Heavy Electricals Limited, Tiruchirappalli, India

May 2013 – July 2013

Developed reports for cost benefit analysis between In situ and Ex situ oil extraction

Designed algorithm for effective resource management and operational efficiency

Community Involvement

Student Coordinator for Department of Sponsorship and Marketing August 2013– August 2014

Birla Institute of Technology and Science, India

Involved in organizing various Socio-Cultural activities in collaboration with National Social Service

A member of the music club of BITS Hyderabad and was involved in opening up avenues for electronic musicians within the university

Contact this candidate