Karan Khanna

*** ********** ******, ******, ** +1-617-***-**** https://www.linkedin.com/in/karan-khanna-6693a345/ Available: April 2019

EDUCATION

Master of Science (M.S) in Project Management, Northeastern University, Boston, MA Expected April 2019 Related Courses: Probability and Statistics, Intermediate Analysis, Quality Management, Risk Management, Information Security Management.

Bachelor of Engineering in Information Technology, University of Pune, India May 2016 TECHNICAL SKILLS

Languages: C, C++, Java, R Language, Python, Hive, HQL. Systems: Linux, Ubuntu, Windows.

Tools: MS Office, MS Project, Advanced MS Excel (VLOOKUP, HLOOKUP, Macros, Pivot), MS Power BI, Tableau, MicroStrategy, ETL, R Studio, Qlikview, Hadoop framework Database: MySQL, MS SQL Server, Oracle, MongoDB

Statistics: Logistic Regression, Linear Regression, Navie Bayes Classifier, K-Means clustering, Neural Networks, Decision Trees, Predictive Analysis.

Other tools: MS Visual Studio, R Studio, Eclipse, Google Analytics, CRM (Salesforce), Bloomberg, MS Visio. WORK EXPERIENCE

BEING 800 GRE GMAT Academy, Pune, India - Business Solution Consultant July 2016 – June 2017

Analysed market conditions for the company clients using Python and R as analysing tools.

Prepared interactive dashboards in Tableau for sales data of the company, supporting decision making process.

Executed stored procedures, triggers, functions and SQL queries to automate daily status report.

Demonstrated strong statistical modelling skills using R to predict future sales and market scenario.

Successfully completed sales research project by applying decision trees in R for predictive analysis which increased percentage of sales by 33%.

ACADEMIC PROJECTS

Boston Crime Rate – Northeastern University Sept 2018 – Dec 2018

Extracted data from open source database.

Analysed the retrieved data using R (Rstudio) by applying ggplot2 package.

Formulate project-specific action strategies to help reduce crime rate.

Articulate data-driven visualizations of analytical dashboards by using Tableau which helped me present data altogether.

Weather prediction of New England, USA - Northeastern University Sept 2018 – Dec 2018

Retrieved csv file of weather data from popular site.

Analysed the database to excellently predict weather conditions for upcoming week by using Exploratory, Descriptive, and Predictive analysis with the help of various packages in Python in Jupyter Notebook.

Using hypothesis testing with 95% confidence interval I could successfully predict weather conditions for next one week.

RCA on Delays of flights - Northeastern University April 2018 – June 2018

Conducted analysis on customer complaints on delays of all domestic US flights.

Performed and analysis using sentiment R on text data retrieved from Kaggle website.

Categorise the analysed data into various reasons for the delay of flights and visualised this data by using PowerBI.

Through sentimental analysis I could conclude the major reasons causing the delays. Time Series on Birth Rate – Northeastern University April 2018 – June 2018

Conducted data analysis using R and predicted the birth rate using time series on the birth rate data.

Used ARIMA model based on forecasting to forecast birth-rate Y-O-Y.

Created an interactive dashboard using Rshiny package with multiple drop-down options to customize the graphs accordingly.

Prepared a report collaborating the entire analysed data with a conclusion to the analysis using PowerBI. Modi Script Character Recognition – University of Pune, India Jan 2016 – April 2016

Modi Script is ancient Devanagari script used in 20th Century and has many archives written in it.

Developed character recognition software using Machining Learning.

Build Neural networks for recognizing handwritten digits and alphabets.

Performed image processing by using binarization, segmentations and feature extraction.

Contact this candidate