devarun bharadwaj

devarun bharadwaj

Data Analyst
India
Assamese, Hindi, English

About Me

Entry-level Data Analyst with hands-on experience in SQL, Excel and Power BI through end to end analytics projects across e-commerce and healthcare domains. Strong at data cleaning, KPI analysis and dashboarding to ident…

Experience

Research Intern

Microbial Mining Bio-Tech Pvt Ltd
Feb 2025 - Jun 2025 · 4 months

Maintained and analyzed operational data logs for 3,000+ samples across hydroponic trials.
Tracked batch-level consistency, quality deviations, and process variability.
Applied statistical checks to monitor operational stability across experimental cycles.
Presented summarized insights to supervisors for decision-making on trial adjustments.

Research Intern

Microbial Mining Bio-Tech Pvt Ltd
Feb 2025 - Jun 2025 · 4 months

Maintained and analyzed operational data logs for 3,000+ samples across hydroponic trials., Tracked batch-level consistency, quality deviations, and process variability., Applied statistical checks to monitor operational stability across experimental cycles., Presented summarized insights to supervisors for decision-making on trial adjustments.

Intern

MS Ramaiah University of Applied Sciences
Sep 2024 - Jan 2025 · 4 months

Collected and analyzed growth data from diagnostic workflows using spectrophotometry.
Built trend plots to identify deviations in processing conditions.
Documented process observations and communicated findings to faculty teams.

Intern

MS Ramaiah University of Applied Sciences
Sep 2024 - Jan 2025 · 4 months

Collected and analyzed growth data from diagnostic workflows using spectrophotometry., Built trend plots to identify deviations in processing conditions., Documented process observations and communicated findings to faculty teams.

Research Intern

Indian Institute of Science (CES)
Jan 2023 - Jun 2023 · 5 months

Processed and analyzed 840+ datasets to identify statistical correlations.
Structured results into reports and presentations for academic review.

Research Intern

Indian Institute of Science (CES)
Jan 2023 - Jun 2023 · 5 months

Processed and analyzed 840+ datasets to identify statistical correlations., Structured results into reports and presentations for academic review.

PROJECTS

Healthcare SQL + Power BI Analytics Project (End-to-End Project)

Duration : 14-Nov-2025 - 29-Nov-2025

• Designed a relational database to audit hospital operations, including patient scheduling and billing workflows. • Discovered a 26% appointment no-show rate, identifying specific scheduling inefficiencies that directly impacted doctor productivity and revenue. • Analyzed doctor workload patterns to identify departmental imbalances, providing recommendations for better resource and appointment allocation. • Built an interactive 3-page Power BI dashboard to monitor daily operational KPIs and financial insights for leadership.• Converted findings into actionable recommendations for improving resource utilization and reducing operational waste.

Blinkit SQL Case Study (End-to-End Project)

Duration : 04-Oct-2025 - 04-Nov-2025

• Analyzed a multi-table database covering orders and delivery logs to simulate real world logistics and business analytics workflows. • Wrote 20+ optimized SQL queries to track delivery performance, operational bottlenecks, and marketing effectiveness.• Flagged delivery delays and low-performing zones, highlighting specific process constraints impacting service ratings. • Evaluated Marketing ROAS to identify underperforming campaigns, recommending a reallocation of budget to higher-return channels. • Performed customer segmentation to distinguish churn-risk users, identifying service gaps in the operational lifecycle.

Certifications

Data Modeling in Power BI – Microsoft

Microsoft · Bengaluru, India · 2025

Google Professional Data Analytics

google · Bengaluru, India · 2025

Skills

Excel Structured Query Language (SQL) Problem Solving Communication Visualization Power BI Tableau Python basics Data Cleaning EDA KPI Analysis Clustal Omega PyRx PyMOL Geneious Attention to Detail Python
Report this Profile?