Summary
Overview
Work History
Education
Skills
Application Subscription Analysis and Churn Prediction | Python, Tableau, Excel
Healthcare Analysis and Bill Prediction | Machine Learning, Python, AWS, Tableau
Cricket Data Analysis for Team Selection | Excel, Python, Power BI
Timeline
Generic

Deshik Patel Hangal Nanaiah

San Diego,CA

Summary

Data management professional specializing in SQL, Python, and business intelligence. Experienced in stakeholder consultation, project scope definition, and technical project management. Proficient in designing databases and creating interactive dashboards for real-time analytics. Skilled in transforming data into insights to optimize operations in data-centric environments.

Overview

3
3
years of professional experience

Work History

Application Development Analyst

Accenture
Bangalore, India
08.2021 - 07.2024

● Built and deployed interactive dashboards using Power BI and Tableau to visualize key performance
indicators, sales trends, and pipeline metrics across global regions.
● Performed in-depth analysis of business datasets using Excel to support reporting, monitor
performance metrics, and deliver actionable insights to stakeholders.
● Utilized SQL to query and extract large datasets from relational databases, ensuring accurate and
relevant data was used for analytics and visualization.
● Conducted data cleaning and preprocessing activities, including deduplication, missing value
handling, and normalization, to ensure high data quality and consistency across reports.
● Developed automated reporting solutions that reduced manual effort by 40%, integrating Excel, Power
BI, and SQL workflows for efficient, real-time business insights.
● Analyzed regional sales and deal data using Microsoft Dynamics 365, identifying performance trends
and providing actionable recommendations for UKI, Italy, Spain, Gallia, and Nordics markets.
● Partnered with cross-functional teams to translate business requirements into scalable data models
and dashboards, aligning analytics efforts with strategic goals.
● Facilitated technical training sessions focused on dashboard interpretation, data exploration, and tool
usage (Power BI, Excel), increasing data literacy across teams.
● Collaborated with IT and operations teams to ensure data integrity across SAP S/4HANA, GTS, Fiori,
and other enterprise systems, reinforcing trust in analytics outcomes

Data Analyst Intern

Cognizant
Bangalore, India
01.2021 - 07.2021

● Designed and implemented relational database schemas to improve organization and accessibility of
sales, customer, and product information
● Built interactive Tableau dashboards for real-time monitoring of product performance, enabling
stakeholders to make faster and more informed decisions.
● Leveraged SQL and Python to analyze large-scale datasets, uncovering behavioral trends and
purchasing patterns to support customer segmentation and retention strategies.

Education

Master of Science - Information Systems

San Diego State University
San Diego, CA
02.2025

Bachelor of Engineering - Computer Science

JSS Science and Technology University
Mysore, India
07.2021

Skills

  • Data Analytics
  • Stakeholder Management
  • Database Design
  • Data Cleaning
  • Data Analytics
  • Data Visualization
  • Data Modeling
  • Interactive Dashboard Development
  • Resource Management
  • Python
  • SQL
  • Tableau
  • Power BI
  • MS Excel
  • Microsoft Office
  • GitHub
  • SAP GUI
  • SAP GRC
  • Avanade Client 365
  • AEP
  • AWS
  • Snowflake
  • MySQL
  • Teamwork

Application Subscription Analysis and Churn Prediction | Python, Tableau, Excel

  • Utilized Excel for data cleaning and preliminary analysis, organizing subscription data to identify key trends before applying machine learning models for churn prediction.
  • Managed data pipeline using Snowflake and performed in-depth analysis with Python to derive actionable insights from user subscription data.
  • Provided insights and strategies for promotional optimization, resulting in a 55% increase in subscriptions.

Healthcare Analysis and Bill Prediction | Machine Learning, Python, AWS, Tableau

  • Developed a machine learning model to predict hospital billing, reducing review time by 200+ hours annually and improving billing accuracy.
  • Improved business revenue growth by 15% through more accurate billing predictions and cost projections.
  • Created and implemented Tableau dashboards to visualize key healthcare insights, reducing manual reporting time by 30%.

Cricket Data Analysis for Team Selection | Excel, Python, Power BI

  • Utilized Python and Excel for data cleaning, including handling missing values, removing duplicates, and standardizing formats. Preprocessed datasets such as batting summary, bowling summary, and match results to ensure high-quality data for further analysis.
  • Leveraged Power BI for interactive data visualization, creating dashboards with key metrics like strike rate, economy rate, and overall player performance using visuals like charts, graphs, and KPIs. Utilized DAX measures for advanced calculations to enhance insights. Created new columns and measures to make dynamic buttons
  • Analyzed individual player performance across batting and bowling metrics and compared team contributions using Power BI's interactive features such as slicers and custom visualization. Created player profiles and used data-driven insights to determine the best-performing players.
  • Developed a comprehensive scoring model for selecting the best lined 12 players, incorporating performance metrics like batting efficiency, bowling impact factor, and all-rounder contributions.

Timeline

Application Development Analyst

Accenture
08.2021 - 07.2024

Data Analyst Intern

Cognizant
01.2021 - 07.2021

Master of Science - Information Systems

San Diego State University

Bachelor of Engineering - Computer Science

JSS Science and Technology University

Similar Profiles

CREATE PROFILE
Deshik Patel Hangal Nanaiah