BALAPAVAN KOMMAREDDY

ABOUT

An analytics professional, skilled in business intelligence and machine learning, having close to 3 years of industry experience in delivering business solutions.

PROFESSIONAL EXPERIENCE

Data Scientist Intern (Sales & Marketing)

Oklahoma Gas & Electric Energy Corp, Oklahoma City May 2019 – May 2020

Predicted monthly weather impact across various sectors and future 7-day loads using the XGBoost/Neural Network algorithms in Python. These predictions enabled making better pricing, capacity decisions, and saved time.

Deployed these models in the Linux server as CRON jobs to run automated predictions daily/monthly. Visualized the predictions using real-time dashboards in Power BI.

Segmented customers based on demographic and usage data to isolate a group of customers that were targeted by email, for a Pilot Program aimed at installing smart thermostats, which resulted in a 2000% ROI.

Saved a wind plant customer $140k by discovering insights in their generation patterns.

Designed A/B tests on IoT data, to choose a cost-saving solution for mass consumption, by working together with many internal teams. Built data pipelines in Python.

Designed impactful real-time interactive dashboards using Tableau for reporting on customer churn, energy efficiency, and demand-side management programs.

Technologies Used: Teradata SQL, SAP HANA, Tableau Desktop, Python, Bash, Excel, Alteryx

Graduate Research Assistant

Oklahoma State University, Stillwater Jan 2019 – May 2019

Assisted professor in research by creating surveys and developing reports from responses data.

Mentored students in performing statistical analysis on qualtrics data.

Data Analyst

Accenture, Hyderabad, India Dec 2016 – May 2018

Involved in data wrangling from different sources, validation and cleaning using ETL to transfer data in a usable format to Data warehouse. Extracted data from OLAP cubes using MDX queries for client-specific requirements.

Built and optimized SQL scripts, indexes and complex queries for data extraction and hypothesis testing.

Developed Interactive dashboards for a retail store client, reporting on KPI’s for various sales metrics. Insights generating led to an increase in sales by 20%

Technologies Used: SQL Server, Visual Studio, SSIS, SSAS, SSRS, Tableau, PowerBI, Python

PROJECTS

Salary Prediction Project: Developed a Salary Prediction ML Model that can be used to predict the expected salaries for employees given date regarding their company, job type, experience, industry etc. Neural Network model was chosen as it outperformed other ML models tested with 10% reduction in MSE compared to base model. Project Link

Text Analytics on Food.com Recipes Data: Pre-processed 1M+ reviews, vectorized text using TF-IDF and predicted the Sentiment of the reviews using naïve Bayes, MLP Neural Network algorithms. Classified recipes into various Cuisines with 80% accuracy using Gradient boosting. Clustered ingredients data and identified interesting patterns in clusters. Implemented Apriori algorithm for Market Basket analysis by training on ingredients text data. Project Link

US Airlines Delays/Cancellations : Analyzed the US Airlines data at various airports by creating interactive storyboards in Tableau. Discovered insights on cancellation, delay reasons and best time to fly etc. Tableau Public Link

HireHeros data: Performed cleaning, EDA on HireHeros website data, and predicted the alumni that are most likely to complete the survey using R. Tested several models selected neural networks as final model as it performed well. Project Link

Credit Card Fraud Detection: Classified credit card transactions as Fraud/Non-Fraud using various algorithms. Applied t-SNE and PCA to visualize the data.

CONTACT

Phone: +1-405-***-****

Email: addb29@r.postjobfree.com

Location: Tampa, FL

linkedin.com/in/kommareddy-pavan

github.com/kbpavan

TECHNICAL PURVIEW

Programming Languages: SQL, Python, R, VBA, Linux Shell, MDX

Database: SAP HANA, SQL Server, Teradata

Statistics: Hypothesis tests

Data Visualization: Tableau, Power BI, ggplot2, Matplotlib, seaborn, SAS -VA

Machine Learning: Scikit-Learn, Keras, TensorFlow, PyCaret, Pandas, NumPy.

Natural Language Processing: NLTK, Genism

Analytics Tools: Alteryx, Knime, Git

Big Data: PySpark

Cloud Computing: AWS

ACADEMIC CREDENTIALS

Master of Science in Management Information Systems (Data Science) GPA-4/4

Oklahoma State University May 2020

Bachelor of Technology (Instrumentation Engineering)

Andhra University, India May 2016

CERTIFICATIONS

Tableau Desktop Specialist - Tableau

Analyzing and visualizing data with Power BI – Microsoft

Data Scientist with Python- Data Camp

Google Digital Analytics - Google

MANAGEMENT SKILLS

Critical thinking

Communication & Decision-making

Asana, Git, PowerPoint

Cross- Functional team coordination

Contact this candidate