Penubaku Siddardha
Professional Summary
Data Analyst with 2.7 years of experience delivering analytics, BI and automated MIS pipelines using Power BI, SQL and Python across healthcare and infrastructure domains. Skilled in designing role-based Power BI dashboards with DAX and Power Query, building SQL ETL and pandas data pipelines, and operationalizing Excel-based MIS to provide real-time KPI visibility to clinical, administrative and maintenance teams. Experienced in hospital operations analytics and BMS telemetry analysis; I have architected scorecards and time-intelligence measures to support executive decision-making and preventive maintenance planning. Certified Microsoft Power BI Data Analyst (PL-300) and Google Data Analytics certified, I take end-to-end ownership of data pipelines, ensure data quality, and translate operational data into measurable process and cost improvements.
Technical Skills
Work Experience
- Architected and deployed 10+ role-based Power BI reports using Power BI and DAX to deliver real-time KPIs for clinical and administrative stakeholders.
- Automated daily MIS pipelines using Python scripts and Excel macros, cutting manual report preparation time from 4 hours to 30 minutes per run.
- Built complex DAX measures and time-intelligence calculations to monitor length-of-stay, bed-occupancy and procedure volumes for executive trend analysis.
- Designed and maintained SQL ETL queries and transformations to extract, join and validate patient encounter and operational datasets across sources.
- Investigated anomalies in admissions and billing datasets using pandas to identify root causes, leading to a 12% reduction in billing mismatches.
- Created operational scorecards and interactive dashboards that informed staffing and inventory decisions for multiple clinical units.
- Monitored real-time BMS telemetry and performed time-series analysis in Python to detect deviations in HVAC and power-system behavior.
- Developed SQL queries to aggregate sensor logs and produce daily performance summaries used by operations teams for trend monitoring.
- Implemented threshold-based alerts and Excel KPI visualizations that reduced reactive maintenance tickets by 25%.
- Identified root-cause patterns across electrical and UPS datasets, enabling schedule adjustments that lowered emergency interventions by 30 incidents annually.
- Standardized ingestion and schema formats from multiple BMS vendors to improve data quality and simplify downstream analysis.
- Produced periodic reports and dashboards to support preventive maintenance planning and stakeholder reviews.
Projects
- Built an interactive Power BI dashboard analyzing multi-season IPL match data to surface team performance, player stats and venue trends.
- Designed DAX measures and calculated columns to compute KPIs such as win percentage, strike rate and economy rate across seasons.
- Cleaned and transformed raw match and player datasets in Power Query to ensure consistency across multiple sources.
- Implemented slicers, drill-throughs and trend visuals enabling stakeholders to filter insights by team, player, venue and season.
- Queried the AdventureWorks sales database with SQL joins, subqueries and aggregations to identify top products and customer segments.
- Developed a Power BI dashboard visualizing sales trends, profit margins and regional performance to support business decisions.
- Built DAX-based KPIs and time-intelligence measures (YoY, MTD, YTD) to track revenue and growth over time.
Education
Certifications
Powered by Drivetube · Create your own profile at drivetube.ai
Explore Drivetube
- Drivetube Profile — 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 Board — verified openings crawled ATS-by-ATS from 100,000+ real company career pages across 35 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.
- Job Hunt Program — managed job hunting, a one-time purchase from $199.99. JobScout matches verified roles to your real experience band, Blend AI writes a uniquely tailored resume and cover letter for every application, and the Autofill extension fills the form — or Let Us Apply submits it for you. Documentation.
- Resume Writing Services — 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.
- Community Membership — from $4.99/month (₹1,999/year in India). Unlocks the gated job-board filters — visa sponsorship, security clearance, workplace and application time — plus Job-Scout AI matching, Resume Report AI, Interview AI prep sheets, Recruiter Outreach AI sent from your own Gmail, Apply or Skip triage, a daily market feed and a $10,000+ library including 23 ATS-validated resume templates. Documentation.
- Drivetube Hire — for employers — 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.
Full product documentation — every product explained, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.
The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.