Social Media Data Analyst
Resume:
KHANJAN PATEL
BUSINESS ANAYTICS & RESEARCH
CONTACT
**********@*****.***
McKinney, TX
linkedin.com/in/khanjan-p
github.com/Khanjan24
public.tableau.com/profile/pkhanjan
PROFILE
Dynamic and growth-oriented business
analyst seeking to be the bridge between
data scientists and stakeholders to create
data-driven solutions. Eager to utilize
analysis and storytelling skills to drive
change.
EDUCATION
2020
DREXEL UNIVERSITY [PHILADELPHIA, PA]
M.Sc. in Business Analytics
2017
GEORGE MASON UNIVERSITY [FAIRFAX, VA]
M.A. in I/O Psychology
2014
PURDUE UNIVERSITY [WEST LAFAYETTE, IN]
B.Sc. in Psychological Sciences
MANAGEMENT SKILLS
Agile Foundations
Green Belt Six Sigma Certified
KPI Dashboarding
Teamwork & Project Management
TECHNICAL SKILLS
Tableau, Power BI, Advanced
Excel (Power Query, Pivot,
VLookUp)
Python, R, SQL, and SPSS
Data Visualization
Data Wrangling & Modelling
Machine Learning
Natural Language Processing
Data Mining & Analytics
EXPERIENCE
7/2020 - PRESENT
Business & Data Analyst (Volunteer) Drexel University
Elicited requirements and feedback from the department needed to evaluate and improve the graduate program curriculums.
Developed an analytical dashboard in Power BI to highlight KPIs that track supply and demand of labor across 23 counties in Pennsylvania from 2016-2026, to statistically identify opportunities.
Implemented an ETL framework to automate the consolidation of data in power query, which increased processing time of handling data by 90%.
6/2019 – 12/2019
Student Consultant Analyst Drexel University
Evaluation of Different Natural Language Processing Models
Led a team of 3 to evaluate various NLP methods for the classification of Social Media Texts in Python, to identify users who are more likely to abuse drugs for a Fortune 500 biopharmaceutical corporation.
Performed pre-processing, feature engineering and resampling to avoid any learning biases and handle class imbalance.
Recommended the implementation of the Google BERT Model against 4 different classifier methods (K-nearest neighbors, SVM, Naïve Bayes, DT) and 2 neural network methods (RNN, CNN) based on better F-1 measures (0.485), and model accuracy (0.797). Increased the client’s overall analysis efficiency by 25%. DATA SCIENCE PROJECTS
Screening for Chronic Kidney Disease [CKD]
Created an easy to use and a cost-effective bilingual clinical tool in R for early detection of CKD in patients resulting in 87% accuracy.
Performed exploratory data analysis, clustering, and logistic regression to group patients with similar characteristics and predict each cluster’s likelihood of having CKD.
Awarded the best predictive model with the highest recall and accuracy for successfully identifying patients at the risk of having CKD generating an estimated profit of $412,000.
Developed a Churn Management Program
Developed a proactive churn management program in SPSS for a telecommunication company to predict and identify customers most likely to churn and, developed incentives to target them.
Created lift charts to evaluate the predicted model’s performance and determined economic importance of each variable for predicting attrition.
Identified customers who are 1.75 times more likely to churn than their average customers.
Contact this candidate