Summary
Overview
Work History
Education
Skills
Accomplishments
Core Competencies
Key Presentations
Key Achievements
Certification
Timeline
Generic

Ashika Thimmaiah

Bengaluru

Summary

Detail-oriented and performance-driven Data Analyst with over three years of experience in the Pharmaceutical and Healthcare sectors, specializing in SQL-based data extraction and advanced Tableau dashboarding. Proven expertise in designing scalable, interactive BI solutions and automating complex data workflows. Adept at transforming raw, complex healthcare data into business-ready insights that empower strategic decision-making. Strong technical foundation combined with a knack for visual storytelling, enabling stakeholders to make informed, data-driven decisions with confidence.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Associate

Definitive Healthcare
Bengaluru
08.2024 - Current

Spearheading advanced data visualization initiatives using Tableau, focusing on executive-level dashboards with multi-source integrations and predictive elements.

Partnered with cross-functional teams to enhance self-service analytics capabilities, leading to a 25% reduction in ad-hoc dashboard requests.

Optimized SQL queries and Databricks pipelines for large-scale healthcare datasets, improving ETL performance by 40%.

Introduced version control and documentation standards for Tableau dashboards and SQL scripts, enhancing reproducibility and team collaboration.

Developed data quality frameworks to identify anomalies in patient-level datasets, significantly reducing reporting errors.

Mentoring junior analysts in SQL, dashboarding best practices, and data storytelling techniques.

Analyst

Definitive Healthcare
Bengaluru
08.2022 - 08.2024

Built and maintained end-to-end SQL pipelines for extracting, transforming, and delivering healthcare provider and patient data for internal and client reporting.

Developed interactive Tableau dashboards that tracked key healthcare metrics such as claims volume, provider utilization, and treatment pathways.

Automated routine reporting processes using SQL and Excel, reducing manual effort by 30+ hours/month.

Played a key role in APLD (Aggregated Patient-Level Data) analytics, uncovering patient demographics and treatment trends to guide healthcare strategy.

Contributed to Market Mix Modeling (MMM) projects by preparing datasets and creating visual outputs to assess marketing channel effectiveness.

Worked on improving data reliability and integrity by implementing validation checks and monitoring scripts across key databases.

Provided ad-hoc analytical support to internal teams and external clients, translating complex data into clear business insights.

Education

Master of Science - Agricultural Economics

University of Agricultural Sciences
Dharwad
02-2022

Bachelor of Science - Agricultural Marketing

University of Agricultural Sciences
Bengaluru
09-2019

Skills

SQL: Joins, CTEs, Window Functions, Query Optimization, ETL

Tableau: Interactive Dashboards, LOD Expressions, Parameters, Custom Charts

Databricks: Data Pipelines, Notebooks

R & Python: Regression, Forecasting, Data Cleaning

Excel: Pivot Tables, Formulas, Automation (Advanced Level)

Accomplishments

Outstanding Performance Award (2023–2024): Recognized for SQL automation efforts and delivering user-centric Tableau dashboards that improved data visibility across multiple business units.

Core Competencies

  • Data Analysis & Visualization: Tableau (Advanced), SQL (ETL & Analytics), Excel
  • Dashboard Development: Interactive Dashboards, UX/UI Design for BI Tools
  • Database Management: Data Extraction, Cleaning, Transformation, Joins & CTEs
  • Data Warehousing & ETL: Query Optimization, Automation, Databricks
  • Statistical Analysis: R, Python (Basic), Regression Techniques
  • Business Intelligence: KPI Tracking, Ad-hoc Reporting, Executive Dashboards
  • Healthcare Data Expertise: APLD, Claims, Provider & Institutional Data

Key Presentations

Presented Insights from Healthcare Provider, Medical Institution, and APLD Data: Delivered a series of data-driven insights to senior stakeholders, highlighting key trends and actionable findings from large-scale healthcare datasets. These insights helped optimize service delivery and supported data-driven decision-making across various healthcare operations, leading to improved patient outcomes and better resource planning.

Tableau Dashboard Walkthroughs: Conducted regular walkthroughs of interactive Tableau dashboards for cross-functional teams. Demonstrated how to use visual analytics for faster, more informed decisions in areas such as claims analysis, provider behavior, and institutional performance tracking.

Key Achievements

Automated SQL data pipeline for healthcare reporting, improving refresh time by 30%

Designed and deployed Tableau dashboards adopted by multiple business teams, improving reporting efficiency by 40%

Recognized as a go-to resource for SQL troubleshooting and dashboard enhancements within the analytics team.

Certification

Introduction to SQL, Simplilearn

Tableau Training, Simplilearn

Business Analytics with Excel, Simplilearn

Advanced Excel Formulas & Functions, Udemy

Timeline

Associate

Definitive Healthcare
08.2024 - Current

Analyst

Definitive Healthcare
08.2022 - 08.2024

Master of Science - Agricultural Economics

University of Agricultural Sciences

Bachelor of Science - Agricultural Marketing

University of Agricultural Sciences
Ashika Thimmaiah