Vaeshnavi Reddy Alla
Professional Summary
Data Analyst with 4+ years of experience delivering business intelligence, operational analytics, and reporting solutions across healthcare and enterprise environments. Experienced in analyzing 12M+ records, building executive Power BI and Tableau dashboards, automating reporting workflows with Azure data platform and Excel, and improving reporting accuracy through data validation and ETL support. Strong skills in SQL optimization, DAX, Python (Pandas), Azure Data Factory, and stakeholder collaboration to translate business requirements into scalable analytics solutions.
Technical Skills
Work Experience
- Developed executive Power BI dashboards tracking 40+ operational KPIs across workforce productivity, backlog, turnaround time, and SLA compliance using star schema modeling and 50+ DAX measures, reducing executive reporting time by 45%.
- Built enterprise SQL analytical workflows (CTEs, window functions, stored procedures) to analyze 12M+ operational records and identify workforce scheduling bottlenecks, enabling a 20% improvement in operational efficiency.
- Automated weekly operational reporting by creating Azure SQL data marts and Excel Power Query/Power Pivot solutions that replaced 15+ manual reports and saved 18 analyst hours per month.
- Designed a data quality validation framework using SQL reconciliation, duplicate detection, and exception reporting across 200+ attributes, improving reporting accuracy by 30% and reducing escalations.
- Collaborated with operations managers and cross-functional stakeholders in Agile sprints to translate business requirements into analytics solutions, increasing stakeholder adoption and actionable usage of reports.
- Accelerated SQL development and documentation using AI-assisted tools and query optimization techniques, improving ad-hoc analysis turnaround and maintaining consistent performance SLAs.
- Designed interactive Power BI and Tableau dashboards using star schema modeling, drill-through pages, and 35+ DAX measures to monitor SLA compliance and customer service KPIs for enterprise clients.
- Developed optimized SQL reporting solutions using recursive CTEs, window functions, stored procedures, and PIVOT transformations to process 8M+ records, reducing report execution time by 35%.
- Automated monthly operational reporting with Power Query, Power Pivot, and advanced Excel formulas, increasing analyst productivity by 40% and standardizing templates across teams.
- Performed trend and root cause analysis by combining operational metrics and customer behavior data, identifying drivers of service issues and reducing reporting discrepancies by 25%.
- Implemented data cleaning and transformation workflows in Python (Pandas, NumPy) to streamline ETL inputs and improve downstream report quality and consistency.
- Coordinated with business and technical stakeholders to validate source systems, document business rules, and deliver executive reports used for client-facing strategic decisions.
- Authored SQL queries, joins, CTEs, and stored procedures to extract and prepare enterprise data for recurring reports and ad hoc analyses, improving report production efficiency by 30%.
- Assisted in developing Power BI dashboards and Excel-based KPI reports that enabled business users to monitor operational performance and key metrics.
- Performed data validation, reconciliation, duplicate detection, and referential integrity checks using SQL and Excel to ensure consistent data quality for reporting.
- Supported ETL processes by validating source data, testing transformed datasets in Azure Data Factory, and documenting business rules for production deployments.
- Automated repetitive reporting and data preparation tasks using SQL, Python (Pandas), and Excel macros, reducing manual effort and accelerating delivery timelines.
- Collaborated with analysts, ETL developers, and stakeholders to troubleshoot reporting issues, gather requirements, and continuously improve reporting processes.
Projects
- Built an end-to-end ETL pipeline to ingest, clean, transform, and load retail order data into MySQL using Python and Pandas to enable downstream analytics.
- Automated data cleansing, validation, and feature engineering to improve reporting accuracy and readiness for analysis.
- Wrote optimized SQL queries to analyze sales performance, customer behavior, regional trends, and profitability.
- Designed interactive Power BI dashboards visualizing revenue trends, customer segments, product performance, and executive KPIs.
- Used Git/GitHub for version control and documented ETL workflows and database schema for maintainability.
- Analyzed 4,000+ customer records to identify behavior patterns and drivers of credit card churn.
- Performed data cleaning, feature engineering, exploratory analysis, and predictive modeling using tidymodels in R.
- Identified high-impact churn indicators and produced actionable insights to support targeted retention strategies.
- Built interactive Tableau dashboards to monitor churn trends, segmentation, and key business KPIs for stakeholders.
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.