Skip to content

Vishwa Teja Bandapally

Data Analyst • Hyderabad, India • linkedin.com/••••• • drivetube.ai/•••••

Professional Summary

Data Analyst with 1.3+ years of experience building MIS, ETL, and executive BI solutions for multi-branch healthcare diagnostics. Specialized in SQL Server data modeling, incremental ETL with watermark parameters, and Power BI reporting to deliver CEO-facing dashboards and mobile-optimised views. Owned end-to-end reporting across 8–10 branches, validating LIS and billing sources to maintain data governance and zero escalations. Instrumented revenue and channel-profitability analyses that traced referral declines, corrected pipeline logic, and increased daily patient volume from ~700–800 to 1,200+. Automated HR and stock processes for 350+ employees using Power Query and Power Automate, cutting payroll reconciliation cycles and daily reporting time substantially. Experienced in PostgreSQL-backed ETL and Python data cleansing scripts for scheduled refresh pipelines. Seeking Data Analyst roles focused on healthcare revenue analytics and operational BI.

Technical Skills

Programming Language: Python,SQL
Databases: PostgreSQL
Data Analysis & Visualization: Power BI,Watermark Parameters,Power Query,TAT Analysis,DAX,Looker Studio
Data Integration & ETL: ETL,Incremental Loads
Compliance & Governance: Data Governance
HR Modules & Functional Areas: HR Analytics

Work Experience

Konnect Diagnostics
Hyderabad, India
Data Analyst
Oct 2024 – Present
Provided MIS, ETL and BI for a multi-branch healthcare diagnostics network; reporting and analytics supported leadership, finance and operations across branches.
Tech Stack: SQL Server, Power BI, Power Automate, ETL
  • Owned the MIS and BI function for 10+ branches, built SQL Server data models and Power BI dashboards that replaced manual spreadsheets and reduced daily reporting time from hours to under 30 minutes.
  • Diagnosed a month-on-month revenue dip via DoD/MoM analysis, traced the issue to declining doctor-wise referrals and a SQL logic error, corrected the ETL logic and supported re-engagement efforts that raised daily patient volume from ~700–800 to 1,200+.
  • Conducted channel-profitability analysis (walk-in vs referral) using role-based Power BI reports, producing insights that reshaped marketing allocation and supported sustained revenue improvement.
  • Engineered ETL pipelines with full and incremental loads using watermark parameters and scheduled refreshes, enabling prior-day data availability within minutes of business opening.
  • Implemented automated branch stock-management with Power Automate audit alerts and an immutable audit trail, cutting stock wastage to near zero through early exception detection.
  • Developed an HR MIS for 350+ employees for salary segregation and headcount cost reporting, reducing monthly payroll reconciliation cycle by ~70% through automated reconciliation templates and validation checks.
  • Delivered mobile-optimised, CEO-facing Power BI dashboards for live visibility into revenue, patient flow, and branch performance for executive decision-making.
  • Identified sample-processing bottlenecks through end-to-end TAT analysis and recommended staffing adjustments that improved throughput without headcount increases.
Konnect Diagnostics
Hyderabad, India
Data Analyst Intern
Jul 2025 – Oct 2025
Supported MIS and reconciliation efforts for the diagnostics network; work focused on daily/monthly doctor-level reports, HR reconciliation, and source-data validation.
Tech Stack: Power Query, LIS
  • Backed daily and monthly MIS reporting across 8+ branches, preparing doctor-level patient flow and attendance reports for management review.
  • Maintained the HR MIS reconciliation model covering 350+ employees, standardising salary inputs and reducing manual payroll adjustments.
  • Prepared DoD and MoM revenue comparison reports that accelerated identification of underperforming branches from hours to minutes for finance reviews.
  • Validated MIS figures against LIS and billing source data prior to dissemination, preserving data governance and preventing reporting escalations.
  • Automated recurring reconciliation steps using Power Query and scheduled refreshes, lowering manual effort required for daily reports.
  • Performed ad-hoc analyses to support branch-level operational decisions and weekly leadership meetings.
Excelerate
Remote
Project Lead Intern
May 2025 – Jun 2025
Delivered ETL, master-dataset consolidation and KPI dashboards for a consulting client; work included full ETL lifecycle and delivery of automated reporting.
Tech Stack: PostgreSQL, Python, Power BI, Looker Studio, ETL
  • Led a team of 8 to design the ETL approach and unify 7+ raw datasets into a single master PostgreSQL database, owning profiling, cleansing and field mapping.
  • Managed the full ETL lifecycle including transformation rules and validation checks to ensure consistent master data across sources.
  • Implemented Python scripts for data cleansing, standardisation and automated validation to reduce manual preprocessing effort.
  • Reduced cross-source report generation from hours to under 20 minutes (~80% faster) by consolidating datasets and automating transformations.
  • Delivered Power BI and Looker Studio KPI dashboards with scheduled refreshes, enabling the client to replace a manual weekly process with automated planning reports.
  • Trained client stakeholders on dashboard usage and maintained documentation for ongoing ownership and change control.
Excelerate
Remote
Data Visualisation Associate
Jan 2025 – Mar 2025
Built decision-focused Power BI reports and performed EDA for consulting engagements to surface revenue trends and KPI gaps.
Tech Stack: Power BI, DAX, SQL
  • Translated ambiguous business questions into executive Power BI reports that aligned visuals to decision points for stakeholders.
  • Conducted exploratory data analysis using SQL and Power BI to surface revenue trends, channel performance and KPI gaps for client reviews.
  • Designed decision-focused dashboards using DAX measures and role-based filters to deliver actionable insights for operations and finance.
  • Optimised data models and visuals to improve dashboard refresh performance and mobile rendering without altering source data.
  • Partnered with stakeholders to iterate dashboard design and define acceptance criteria prior to release.
  • Documented data transformations and created user guides to enable self-service queries and reduce ad-hoc reporting requests.

Education

Western Business School, Pune
PGDM — Business Analytics • Pune, India • 2022 – 2024
Woosong University
Student Exchange — Data Visualisation & Marketing • South Korea • 2023 – 2024
Baba Farid Group of Institutions, Dehradun
B.Sc. Agriculture • Dehradun, India • 2017 – 2021

Certifications

Google Data Analytics Foundations — Coursera
Power BI for Beginners — Simplilearn
Data Visualisation for Business — Tata Forage
PwC Power BI Job Simulation — Forage

Powered by Drivetube · Create your own profile at drivetube.ai

Everything on Drivetube

Six products, two of them free forever. Start wherever you are.

Read the docs →
  • Your free digital resume

    at drivetube.ai/in/your-name: one true standard resume with a Hiring Snapshot (visa status, expected salary, notice period, work preference, relocation), an ATS-ready PDF download and a single shareable link. Free forever; interview requests come from verified employers and your contact details stay masked until you accept.

    Documentation
  • Verified jobs, posted in the last 3 days

    verified openings crawled ATS-by-ATS from 160,000+ real company career pages across 50+ ATS platforms. Shows the true posting date from the source ATS — not when a listing was indexed — and deletes every general listing 3 days after it was actually posted. No ghost jobs, no ad-sponsored listings, no staffing reposts, no account needed.

    Documentation
  • Written by senior career writers

    human-written, ATS-optimised resumes by senior career writers, from ₹499.99 / $25.99. Available in every country, written to the destination country's own standard — a US resume, UK CV, German Lebenslauf and Indian resume are genuinely different documents. A paid service, separate from the free Drivetube Profile.

    Documentation
  • Drivetube OneFrom $39.99 / 3 mo

    Daily matched jobs, tailored resumes, or we apply for you

    Drivetube's paid service. Community sends daily Jobsheets of fresh jobs matched to your profile on WhatsApp and email, with the Drivetube Community ($39.99 for 3 months or $69.99 for 6 months; ₹999 or ₹1,899 in India). Jobhunt is one-time application credits with Community included: one credit tailors one resume and its cover letter (100 for $99 with 3 months of Community, 250 for $199 with 6 months). Let Us Apply is an add-on to Jobhunt: a human expert applies 250 times for you on your credits ($0.60 each, $150). Everything lives on one dashboard at drivetube.ai/drivetubeone.

    Documentation
  • For employers — no job postings, no applications

    hiring with no job postings and no applications. Paste your real job description and AI matches it against candidates' true standard resumes, returning ranked candidates with a match %, matched and missing skills and written reasoning. Free tier included; employers pay, candidates never do.

    Documentation
  • Documentation

    every product explained in full, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.

  • Playbooks

    tactical job-search guides. Each post is one named tactic with the situation it applies to, the exact steps, a copy-paste message and honest failure modes. Free, no account.

The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.

Pricing is identical on the web, iOS and Android — no app-store markup. Monthly Community membership is purchased in the iOS app only; the website sells annual plans. The Android app has no in-app purchase, so Android members subscribe on drivetube.ai and then sign in to the app with full access. Membership follows your account, not your device.