Hello! I'm Abhishek
Data Analyst with an ability to find useful insights from Data using Advanced Data Analytics/Modelling/Visualization techniques and help make the business better and profitable decisions.
Abhishek Dutta
Data Analyst | Business Intelligence Analyst
Phone:
312-468-3320
Email:
adutta9@hawk.iit.edu
Address:
2951 South King Drive
Chicago , IL , USA - 60616
​
Date of Birth:
July 31st, 1990
​
EXPERIENCE
June 2017-Aug 2017
Data Analyst Intern
Jan 2014-May 2016
Business System Analyst
HBR Consulting LLC
Migrated an on-going project from QlikView to MS Power BI for better data visualization on client's web application.Also,worked on Capstone project and did RnD on Third-Party Risk mitigation to improve our services.
L&T Infotech
I was a part of the QHNG Project which is a Home insurance product (Property and Casualty Insurance).Discussed Business requirements with stakeholders and converted them to technical specifications also analyzed various Insurance Transactions.
Nov 2012-Dec 2014
Software Developer
L&T Infotech
Developed and maintained EXCAL and ICAL insurance systems and worked on various complex SQL queries to fetch data for analysis purpose.Also, created Tableau dashboards to help capture project's health and status monitoring.
EDUCATION
2016-2018
Master's Degree
ILLINOIS INSTITUTE OF TECHNOLOGY
DEPARTMENT: Information Technology and Management
SPECIALIZATION: Data Management
GPA: 3.90 / 4.00
2008-2012
Bachelor's Degree
ORIENTAL INSTITUTE OF SCIENCE AND TECHNOLOGY
DEPARTMENT: Information Technology
GPA: 3.69/4.00
1996-2008
School
ST.JOSEPH CO-SCHOOL
​
CLIENTS & COMPANIES
SKILLS
R Programming
MS Sql Server , SSIS and SSRS
Power BI
Tableau
Oracle 11g and 12C
SAS Programming
ACADEMIC PROJECTS
H1-B Visa petitions Prediction for 2016
​
Fitted a logistic Regression model to predict H1-B petitions for 2016 year by analyzing data from 2011-2015 which was approximately 30K records.Also , visulaized the results.
​
Tools used: R studio, MS Excel, Weka, MS Project and Tableau
​
Sentimental Analysis on 45th President of USA- TRUMP
​
​
Extracted tweets from Twitter API and performed analysis on people’s sentiments on TRUMP.
​
Tools used: R studio, MS Excel, Weka, MS Project and Power BI
American Society Analysis
Downloaded IL state data from ACS and performed analysis like -predicting impact of degrees (PhDs, Master’s and Bachelor’s) on Income and classified tax-payers by various factors.
​
Tools used: SAS studio, MS Excel, Weka, MS Project and Power BI