Vishwa Teja Bandapally
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
Work Experience
- 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.
- 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.
- 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.
- 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
Certifications
Powered by Drivetube · Create your own profile at drivetube.ai
Everything on Drivetube
Six products, two of them free forever. Start wherever you are.
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- Free Job BoardFree
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 - Resume Writing ServicesFrom $25.99
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 - Drivetube HireFree tier
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.