Summary
Overview
Work History
Education
Skills
Websites
Certification
Personal Information
Timeline
Generic

Dishita Chokshi

North Carolina

Summary

Highly detail-oriented and performance-driven Data Analyst with over 4 years of experience delivering data-driven solutions in insurance, healthcare, retail pharmacy, and financial services industries. Expert in transforming complex, raw datasets into actionable business insights using advanced tools such as SQL, Python, R, Tableau, and Power BI, with a focus on automating ETL processes and developing intuitive, interactive dashboards. Proficient in applying statistical modeling, machine learning algorithms, and A/B testing methodologies to optimize business processes, enhance strategic decision-making, and improve customer engagement outcomes. Skilled in leveraging cloud platforms (AWS, Azure, Snowflake) and big data technologies (Hadoop, Spark) to manage large-scale datasets while ensuring strict compliance with HIPAA and SOX regulations. Exceptional communicator and collaborator, experienced in Agile and Scrum environments, adept at engaging cross-functional teams and presenting complex analytical insights to C-level executives and stakeholders. Proactive problem-solver with a proven ability to identify inefficiencies, design innovative data solutions, and implement process improvements that drive operational excellence. Committed to continuous learning, staying current with emerging data analytics trends, tools, and best practices to deliver cutting-edge solutions that align with business objectives.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Data Analyst

Walgreens
10.2023 - Current
  • Developed and deployed advanced predictive models using Python’s Scikit-learn library to forecast store-level inventory demand, analyzing historical sales data and market trends to reduce stockouts by 25% and minimize waste by 15%, enhancing operational efficiency across 200+ retail locations.
  • Designed and maintained over 10 dynamic Power BI dashboards to monitor critical KPIs, including sales performance, inventory turnover, and customer engagement metrics, reducing reporting time by 40% and enabling real-time decision-making for regional managers.
  • Executed sophisticated SQL queries in MySQL and SQL Server to perform customer segmentation, leveraging demographic and purchase data to create targeted marketing campaigns, resulting in a 20% increase in campaign ROI and improved customer retention.
  • Automated ETL pipelines using Python and PostgreSQL, integrating disparate data sources to ensure data integrity and consistency, saving approximately 12 hours of manual processing time per week and improving data availability for analytics teams.
  • Spearheaded a large-scale data migration to Snowflake and AWS S3, ensuring seamless transition of sensitive healthcare data while maintaining strict HIPAA compliance, achieving zero downtime and enabling scalable cloud-based analytics.
  • Conducted in-depth statistical analysis using R to optimize pharmacy refill adherence programs, identifying key patient behavior patterns and implementing interventions that improved patient outcomes by 10%, enhancing customer satisfaction scores.
  • Created compelling data visualizations using Seaborn and Matplotlib to uncover seasonal inventory trends, enabling proactive stock management and reducing overstock costs by 8% across regional distribution centers.
  • Use Tableau’s native Salesforce connector to establish a secure API-based connection. This ensures data pulls are authenticated and up-to-date.
  • Utilized Git for version control to manage analytical codebases in Jupyter Notebooks, ensuring reproducibility and collaboration across cross-functional data teams, streamlining code review processes.
  • Delivered interactive Tableau dashboards to C-level executives, presenting actionable insights on pricing strategies and market expansion opportunities, influencing strategic decisions that drove a 15% increase in regional sales.
  • Proficient in VLOOKUP, XLOOKUP, INDEX-MATCH, and nested IF formulas for dynamic data lookup and validation.
  • Actively participated in Agile sprint cycles, collaborating with product managers and developers to deliver analytics solutions on time, enhancing data-driven decision-making and operational agility.
  • Mentored junior analysts on best practices in data visualization and SQL query optimization, fostering a culture of knowledge-sharing and improving team productivity by 10%.

Data Analyst

TD Bank
NC
06.2022 - 09.2023
  • Built and implemented machine learning models using Python (Scikit-learn, Pandas) to predict customer lifetime value, analyzing transactional and behavioral data to identify high-value customers, resulting in an 18% increase in retention rates and improved marketing efficiency.
  • Developed and optimized complex SQL queries in Oracle and SQL Server to detect and prevent fraudulent transactions, identifying anomalies in real-time and saving $1.5M annually through proactive fraud mitigation strategies.
  • Created comprehensive financial KPI dashboards in Tableau and Power BI, visualizing metrics such as ROI, cost-to-income ratios, and customer acquisition costs, optimizing investment strategies and resource allocation by 12% for regional branches.
  • Automated quarterly financial reporting processes using Python, Excel VBA, and SSMS, streamlining data extraction and transformation workflows, reducing processing time by 50% and enabling faster delivery of reports to stakeholders.
  • Built interactive dashboards using Power BI and Tableau to visualize KPIs, trends, and cross-functional metrics.
  • Skilled in building and analyzing pivot tables to summarize large datasets quickly.
  • Connected tools to diverse data sources including Excel, Salesforce, Google Analytics, and SQL databases.
  • Conducted R-based credit risk modeling to enhance underwriting decisions, incorporating statistical techniques to assess borrower risk profiles, reducing loan defaults by 15% and improving portfolio performance.
  • Streamlined post-merger database integration using SSIS and Azure Data Factory, consolidating disparate financial datasets while ensuring SOX compliance, maintaining reporting continuity, and supporting audit requirements.
  • Performed A/B testing using statistical methods to evaluate new digital banking product features, analyzing user engagement data to optimize user interfaces, resulting in a 10% increase in feature adoption rates.
  • Leveraged Google Analytics to analyze customer behavior across digital banking platforms, identifying friction points in the conversion funnel and implementing improvements that enhanced funnel efficiency by 12%.
  • Processed high-volume transactional datasets using Apache Spark (via Databricks), enabling scalable marketing analytics and delivering insights on customer spending patterns to support targeted campaigns.
  • Collaborated with marketing and product teams to develop data-driven strategies, presenting insights in executive meetings that influenced product roadmap decisions and improved customer satisfaction.

Data Analyst

Blue Cross and Blue Shield
NC
02.2021 - 05.2022
  • Designed and implemented Python and SQL-based fraud detection algorithms for healthcare claims data, analyzing patterns to identify fraudulent activities, reducing fraud-related losses by 20% and protecting organizational revenue.
  • Developed predictive models in R to enhance underwriting efficiency, leveraging statistical techniques to improve risk classification accuracy, enabling more precise policy pricing and reducing risk exposure.
  • Built and deployed interactive Tableau dashboards to visualize claims trends and operational performance metrics, streamlining reporting processes by 35% and enabling stakeholders to make data-driven decisions quickly.
  • Automated ETL workflows using Informatica PowerCenter and Python, integrating claims and policyholder data from multiple sources, saving 15 hours of manual processing weekly and improving data availability for analytics.
  • Conducted customer segmentation analysis using SQL and statistical modeling, identifying high-value policyholders and tailoring retention strategies, resulting in a 22% increase in policyholder retention rates.
  • Managed and shared documents through DoD SharePoint and OneDrive, ensuring proper access controls and data classification tagging.
  • Performed competitive pricing and policy analysis using Excel (advanced formulas, PivotTables), identifying market opportunities that drove a 12% revenue increase through optimized pricing strategies.
  • Utilized Hadoop and Azure Synapse Analytics to process large-scale claims datasets during high-stakes audit cycles, ensuring compliance with regulatory requirements and supporting accurate financial reporting.
  • Maintained HIPAA-compliant documentation for all analytical processes, using Microsoft Office Suite tools to support quarterly internal reviews and ensure adherence to healthcare regulations.
  • Partnered with compliance teams to validate data processes, ensuring alignment with industry standards and contributing to successful audit outcomes with zero discrepancies.

Education

Bachelor of Technology - Computer Science

Parul University
04.2019

Skills

  • Data Visualization
  • Tableau
  • PowerBI
  • Matplotlib
  • Seaborn
  • Excel
  • PivotTables
  • VBA Macros
  • Database Tools
  • MySQL
  • PostgreSQL
  • Oracle
  • Microsoft SQL Server
  • SSMS
  • Programming Languages
  • Python
  • Pandas
  • NumPy
  • Scikit-learn
  • R
  • SQL
  • Big Data & Cloud
  • AWS
  • S3
  • Redshift
  • Azure
  • Snowflake
  • Hadoop
  • Spark
  • Databricks
  • ETL & Data Tools
  • Informatica PowerCenter
  • SSIS
  • Azure Data Factory
  • Tools & Platforms
  • Jupyter Notebook
  • Git
  • Google Analytics
  • Microsoft Suite
  • Methodologies
  • Agile
  • Scrum
  • Waterfall
  • Statistical Analysis
  • Machine Learning
  • A/B Testing
  • Operating Systems
  • Windows
  • Linux

Certification

  • Springboard - Data Analytics Career Track: Foundations to Core
  • Udemy - Statistics for Data Science and Business Analysis

Personal Information

  • Title: Data Analyst
  • Visa Status: Green Card Holder
  • Work Permit: Green Card Holder

Timeline

Data Analyst

Walgreens
10.2023 - Current

Data Analyst

TD Bank
06.2022 - 09.2023

Data Analyst

Blue Cross and Blue Shield
02.2021 - 05.2022

Bachelor of Technology - Computer Science

Parul University
Dishita Chokshi