Vipul Bhogendra Kota

µ å +vipulbkota**@1-321-***-**** gmail.com D Vipul Bhogendra Kota H vipulbkota26 Education

University Of Central Florida Orlando

M.S. Data Analytic Aug. 2019 – May 2021

• GPA, 3.95/4.0

Gitam University India

B.Tech. Electronics and Communication Engineering Aug. 2012 – Jun 2016

• GPA, 3.0/4.0

Experience

Data Analyst Dec 2016 – Jul 2019

Tech Mahindra full-time

• Developed efficient reports in tableau to analyze the KPI of medical representatives.

• Optimized the data view by utilizing accurate aesthetics and enhanced overall performance by 15%.

• efficiency of medical representatives increased by 10% by accurately recommending potential customers.

• Optimized extraction loads using Pyspark to make it four times faster.

• Saved 10% budget to clients by automating the monitoring of jobs and reporting the same to stakeholders.

• Initiated and led development of new data. Results of effort include a significant drop in post conversion errors and an overall 20% reduction in data operation conversion development timeframes.

• Collaborated with internal GSK team to ensure global manufacturing project can obtain data accurately from GSK and conduct weekly report to internal manager and increasing their efficiency by 20%.

• Collaborated with products and sales team to automate data visualization using Tabaleau for tracking customer journey across various segments.

• Maintaining the application and troubleshooting it and supporting with various activities of data analysis for review of daily reports, data compilation, and report generation and increasing the availability by 20%.

• Garnered 30% rate increase for new clients by applying analytics to determine best data loader based on clients need.

• Migrated from Oracle 10 to Oracle 12c and optimized run time by 15%. Relevant Projects

Capstone Project Aug 2020 – Dec 2020

Orlando utilities electric theft

* Worked in team of 4.

* Identified outlier with an accuracy of 99% by calculating and leveraging electric-to-water usage ratios by region, subdivision, etc.

* Developed correlation heat maps to identify the contributing factors (correlations) that increase the likelihood of theft/tampering at a particular premise.

* Provided visualizations, scoring indexes, and other outputs that allow OUC’s Revenue Assurance team to prioritize field investigations. Course Project Mar 2020 – Apr 2020

Covid

* Designed interactive dashboards using Shiny to analyze the trends in Covid cases. Course Project Aug 2020 – Dec 2020

Movie reccomender

* Augmented movie recommended system using ALS in Pyspark Skills

Languages: Python, C/C R, Java, SAS

Data visualization: Qlikview, Qliksense, Tableu, Power BI Developer Tools: Jupyter Notebooks, Git, Google Cloud Platform, VS Code, Amazon AWS Machine Learning: Bagging, Boosting, Regression, SVM, Markov Model, Dimension Reduction

(PCA, SVD), CNN, RNN

Database: Oracle 12c, Mysql, Nosql, Teradata,T-sql,Snowflake Libraries:: Pytorch, Keras, Numpy, Pandas, Tensorflow, NLTK, OpenCV, Scikit-learn, Lucene, SpaCy

Big Data: Spark, Hadoop

Web Technologies: D3.JS, Shiny, Django, Javascript,HTML/CSS Data Warehousing: OLAP, Slowly changing Dimensions,CRM

Contact this candidate