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
Dharwad02-2022
Bachelor of Science - Agricultural Marketing
University of Agricultural Sciences
Bengaluru09-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