Open to opportunities

Aachal Mahakale

@aachalmahakale

Message

Data analyst and clinical research informatics builder transforming healthcare datasets.

United States

Message

What I'm looking for

I’m looking for a role where I can own clinical/healthcare data quality, build research-ready datasets, and deliver reliable reporting—collaborating with investigators and stakeholders to improve outcomes through strong analytics and automation.

I’m a data analyst focused on clinical research data management and analysis, with hands-on experience building and maintaining structured databases in REDCap-style workflows and EHR/EMR environments. At Arizona State University and in healthcare settings, I translate study protocols and stakeholder requirements into data collection fields, validation rules, data dictionaries, and analysis-ready datasets.

I’m especially strong in data quality work—cleaning, normalizing, validating, resolving discrepancies and missing values, and supporting QA/QC and query resolution. I’ve managed data workflows for 60+ participants, extracted and prepared 5,000+ clinical/operational records, and built reporting outputs and dashboards; I also developed Python/Streamlit tools that calculate Charlson Comorbidity Index scores and generate personalized clinical summaries.

Experience

Work history, roles, and key accomplishments

Data Analyst

The Design School

May 2025 - May 2026 (1 year)

Built SQL, Python, Excel, and Power BI workflows across 3+ data sources to support extraction, cleaning, validation, reporting, and dashboard development for stakeholder decisions. Investigated data quality issues (missing values, duplicates, inconsistent fields) and improved reporting efficiency by standardizing validation and quality-check workflows.

SQL Python Excel Power BI Data Extraction Data Cleaning Data Validation Data Quality Dashboard Development

Graduate Research Assistant

Desmart Lab

May 2025 - Jan 2026 (8 months)

Supported REDCap database setup and upkeep by translating study protocol requirements into structured data collection fields, validation rules, and data dictionaries. Managed human-subject research data workflows for 60+ participants, performing data cleaning, normalization, QA/QC, and query resolution for analysis-ready datasets.

REDCap Data Collection Validation Rules Data Cleaning Data Normalization QA&QC Query Resolution Excel SPSS R Python

Healthcare Data Analyst

Kakatkar Hospital

Feb 2022 - Aug 2024 (2 years 6 months)

Managed REDCap-style research database workflows, including setup, form creation, validation rules, tracking logs, and ongoing database upkeep for clinical studies. Extracted, cleaned, normalized, and prepared 5,000+ records from EHR/EMR and Cerner workflows for analysis-ready reporting using Excel, SQL, Python, R, and SAS.