Ankit Yadav

Healthcare Data Analyst with hands-on experience in transforming raw clinical and operational data into structured master charts, statistical outputs, and actionable research insights. Currently working at Brainers Commercial Pvt Ltd, supporting medical research documentation provided to medical college students. Proficient in Advanced Excel, SQL, Python (Pandas, NumPy, Matplotlib), Power BI, and Jamovi for end-to-end data cleaning, analysis, visualization, and reporting.

Experienced in dashboard development, KPI tracking, hypothesis testing, and preparation of research-ready datasets for evidence-based clinical decisions.

Healthcare Data Analyst at Brainers Commercial Pvt Ltd (2026-01 – Present)

Full-time on-site role focusing on healthcare research and clinical analytics

• Developed and maintained structured master chart datasets for healthcare research and clinical analytics projects using Advanced Excel and SQL
• Performed end-to-end data cleaning, preprocessing, and validation — handling missing values, duplicates, formatting inconsistencies, and outliers to ensure high data accuracy
• Conducted statistical analysis using Jamovi including descriptive statistics, T-test, Chi-square, ANOVA, correlation, and regression analysis to support clinical research outcomes
• Transformed raw healthcare datasets into research-ready outputs — tables, charts, and summaries used directly in medical research papers for medical college students
• Built interactive dashboards and visual reports in Power BI and Excel to track KPIs, patient trends, treatment outcomes, and research performance metrics
• Utilized Python (Pandas, NumPy, Matplotlib) for data manipulation, exploratory data analysis, and visualization of clinical datasets
• Applied statistical methods including p-value interpretation, confidence intervals, hypothesis testing, and regression modelling on real-world healthcare data
• Collaborated with internal research teams to improve data quality, reporting consistency, and analytical processes across all projects

Data Analyst at CETPA Infotech Pvt. Ltd. (2024-07 – 2024-12)

Internship on-site focusing on data collection, transformation, and analytics

• Collected, cleaned, and transformed structured and semi-structured datasets using SQL, Python (Pandas, NumPy), and Excel, ensuring high data accuracy and consistency
• Designed and optimized SQL queries using JOINs, subqueries, CTEs, and aggregations to extract actionable insights from large relational databases
• Built interactive Power BI dashboards with KPIs, slicers, drill-throughs, and DAX measures to track business performance, trends, and anomalies
• Used Advanced Excel features — Pivot Tables, VLOOKUP/XLOOKUP, Power Query, and Charts — for ad-hoc analysis and business reporting
• Automated repetitive reporting tasks using Excel Power Query and Python scripts, improving team efficiency and reducing manual effort

Bachelor of Technology in Information Technology – JIS College of Engineering (2020-06 – 2024-06)

Higher Secondary in Science – Purnea College (2018-06 – 2020-06)