EDUCATION

Master of Science: GPA: *.**/*.*, Business Analytics and Information Systems, University of South Florida Dec’2020 Bachelors in Engineering: GPA: 3.23/4, Information Technology, Shri GS Institute of Tech and Science May’2017 TECHNICAL CERTIFICATIONS

Certified in SAS Programming 1 Essentials, Tableau Desktop Specialist and AWS Solutions Architect Associate. TECHNICAL SKILLS

Programming Languages: C, C++, C#, Java, R, Python, HTML, CSS Databases: MS SQL Server, SQL, Oracle, MySQL Software: MS-Office Suite, R Studio, Visual Studio, Salesforce, AWS Cloud: S3, EC2, Kinesis, Lambda, Redshift, DynamoDB Visualization/Data Mining Tools: Weka, SAS Enterprise Miner, SAS, AzureML, Tableau, MS Power BI, Jupyter Notebooks Libraries: Numpy, Pandas, Matplotlib, SciPy, Ggplot2, Scikit-learn, TensorFlow Operating Systems: Windows, Linux, Mac iOS WORK EXPERIENCE

Data Analyst, Career Lift Pvt. Ltd., Indore, India Jun’2017- Nov’2018

Acquired, cleaned and structured the business data from multiple sources to ensure data quality and presentation

Developed a solid foundation of analytical practices using Python to leverage data for an improved decision making

Built reports and dashboards using Tableau representing key insights, ensured data driven actions to improve the business

Maintained, queried and reviewed databases periodically using MS SQL Server to seek improvements in the business models

Optimized and monitored performance of business to drive more accuracy, better insights and more streamlined processes CRM Data Analyst, National Academy of Inventors, USF, Tampa FL Feb’2020-Dec’2020

Single-handedly monitored and customized user accounts along with reports and dashboards generation in Salesforce CRM

Analyzed and built detailed client profiles to enhance CRM marketing strategies, create insights and troubleshoot issues

Collected and migrated the entire business data from Excel worksheets to Salesforce using bulk uploads via data loader

Responsible for maintenance of company’s Salesforce.com portal website using Community Builder setup

Played the central point of contact for all the different departments of the organization in terms of data requests RELEVANT ACADEMIC PROJECTS

Telecom Customer Churn (Technology Used – SAS Enterprise Miner, Tableau and MS Excel) Nov’2019

Identified and predicted all possible reasons and cases of customer churning using a dataset of a private telecom company

Analyzed all relevant customer data to develop focused customer retention programs using Predictive Analysis Modeling while creating Neural Networks and Decision Trees in SAS Enterprise Miner

Compared the multiple models for better prediction using varied evaluation metrics, created an interactive dashboard for the same using Tableau for better decision making

Online Customer Intention Prediction (Technology Used – AzureML, Tableau, MS Excel) Nov’2019

Analyzed customer behavior patterns to predict an intention to buy from a website with the help of Neural Networks, Decision Tree and Logistic Regression using AzureML

Created an interactive dashboard in Tableau to understand the relationship of different factors affecting customer behavior Income Prediction - US Census Income Dataset (Technology Used – Python, Jupyter Notebook) July’2019

Predicted the income of the US citizens by creating Logistic Regression and Random Forest models using Python

Analyzed, integrated and prepared the census income data by imputation, binning and discretization of independent variables, performed data exploration using the Matplotlib Library in Jupyter Notebook

Performed feature engineering, exploratory analysis & dimensionality reduction to finalize a list of features for ML modelling Bank Customer Term Deposit (Technology Used – Pyspark, SQL, Python, Tableau) May’2019

Performed pre-processing using Scalar and String Indexer on a 1.4GB banking dataset based on marketing campaign phone calls to know whether a customer will subscribe for the term deposit or not

Built predictive models namely Linear SVC, Logistic Regression, Decision Tree using Pyspark on Databricks platform over an 80% train and 20% test dataset to obtain a 79% accuracy given by the Decision Tree model POSITIONS OF RESPONSIBILTY:

Graduate Teaching Assistant, USF MUMA College of Business, Tampa FL May’2020-Dec’2020

Responsible for creating assignments, exams and grading them for two different courses

Conducted sessions to provide feedback on assignments and projects which significantly improved class performance Logistics Officer at USF Sports Services Feb’2019-Dec’2020

Responsible for maintenance and procurement of new equipment, kits, jerseys for the sport clubs

Handled budget, organized intramural events and promotional campaigns for the various sport clubs KARAN GUPTA

813-***-**** adgtnt@r.postjobfree.com linkedin.com/in/karangupta1107 github.com/karangupta11

Contact this candidate