Data Analyst

Kushagra Maheshwari

Charlotte, North Carolina 980-***-**** *******************@*****.***

Linkedin: https://www.linkedin.com/in/kushagra-maheshwari-474874119/

Summary: Data Scientist with 3 years of experience in Data Science, Business Intelligence, Data Visualization and Marketing Research. Python and SQL programmer with a strong working knowledge of R, MS Excel, Tableau and Statistics.

Education:

University of North Carolina at Charlotte, Charlotte, NC August 2016 – December 2017

Master of Science in Information Technology (Advance Database & Knowledge Discovery) GPA = 3.6/4.0

Manipal University Jaipur, Jaipur, India August 2012 – June 2015

Bachelor of Engineering in Electronics and Communication GPA= 3.8/4.0

Skills:

Analytical tools: Tableau, R studio, Jupyter, MS Excel, SAS Enterprise Minor, Blue Prism, Automate Anywhere, IBM Watson, Google Analytics, Tableau,Dialog flow, Spark.

Databases: Oracle 11g, Workbench, MongoDB, Impala

Languages: Python, R, C, MySQL, SQL, PLSQL, NoSQL, HTML5, CSS, JavaScript

IDEs: NetBeans, Sublime, Anaconda Navigator, Jupyter Notebook

Work Experience:

Data Scientist May 2017 – April 2018

Honeyfi, Charlotte, USA

Designed an algorithm that automatically identifies recurring, non-recurring bills, periodicity of bills and payment amount using Density based clustering models and applying numerous filtering techniques.

Created Monthly Household Budget Forecasting algorithm on time series data, to make user aware of current v/s desired spending and predict future spending using Autoregressive Moving Average model.

Performed descriptive analytics on the financial and transactional datasets to identify gaps in data quality and produce accurate and efficient data trends.

Created Hashing for every merchant name by assigning a unique number in a way earlier character have more weight then the later ones.

Designed a Chatbot using Dialogflow that can use google assistant services, as well as most of the features provided by the application.

Identified couple financial spending patterns that’s crucial for further addition of features in the application.

Reduced the time taken by recurring bill identifying algorithm by 95%.

Contributing ideas for company growth, not just limited to the data analytics realm.

Gained experience in Project Management, communication with senior management and presentation

Technologies : Python, SQL, MongoDB, Ms Excel, Tableau, Time Series, Forecast, Java Script, Dialogflow

Data Analyst March 2015 – July 2016 STI India Ltd, India

Gathered data to analyse the preferences from potential customers in terms of cost to illustrate strategy to maximize revenue growth to senior management.

Discovered consumer trends using data mining and statistical analysis techniques and represent the findings to geographically determine the profitable products.

Performed descriptive analytics on Personnel Management section.

Data entry, data auditing, creating data reports and monitoring all data for accuracy.

Assist in scoping and designing analytic projects and solutions. Contribute to brainstorming sessions.

Perform extract, transform, and load operations on large datasets from many complex, heterogeneous data sources

Management of SQL Databases and Data Warehouse: organize, format, validate and perform queries on large data sets.

Trained and mentored Analysts intern.

Technologies : R, Python, SQL, Ms Excel, Tableau

Junior Data Analyst Nov 2014 – March 2015

STI India Ltd, India

Worked closely with data scientists to assist on feature engineering, model training frameworks, and model deployments implementing documentation discipline.

Used Python to extract information from XML files and wrote Python scripts to clean raw data.

Performed data extraction and data wrangling using Pandas and Numpy modules in Python

Technologies: R, Python, SQL, Ms Excel

Academic Projects:

Medical Data Analysis

Utilized 70,000 clinical Database patient record, to create a classification model which will determine the readmission reason of the patients employing data preprocessing, data cleaning, pattern mining, clustering, outlier detection and classification techniques.

Technology : R Studio, R, Tableau, Excel

Image Recognition

Designed a 5 layers Sequential Convolutional Neural Network for digits recognition trained on MNIST dataset build it with Keras API (TensorFlow backend).

Technology: Python, Neural network, Keras, Jupyter Notebook

Movie Recommendation System

Python program for movie recommendation system had been written and deployed on Apache Spark platform to access the processing time, speed and to get the desired output.

Technology : Python, MapReduce, Apache Spark

Increasing Revenue on Mail-Order Catalog Data using SAS

Identified approach to economize on order while accumulating profits on mail order systems. Designed two decision tree models in SAS Enterprise Miner to eliminate redundant and irrelevant variables while generating model assessment statistics.

Technology : SAS Enterprise Miner

Movies Catalog and Rating System

Designed relational database in MYSQL to store 5 million movie records and developed front end application using JSP, HTML and CSS to enable users to search movies and records.

Technology : SQL, JSP, HTML,CSS

Certifications:

Online Certificate Courses:

Machine learning foundation: A case study approach Coursera July 2017

Introduction to Data Analysis Using Excel Coursera July 2017

Data Analytics using Python Coursera April 2016

Certified in PlSQL Universal Informatics July 2016

Certified in SQL Universal Informatics May 2016

Contact this candidate