Data Analytics Professional: SQL to BI, $1.9M Savings

Sai Pragna Kancheti

Dallas, TX ***************@***********.*** 469-***-**** LinkedIn Portfolio SUMMARY

Data Analyst with 4+ years across product analytics, healthcare compliance, and client-facing BI. Skilled in SQL, Power BI (DAX), Python, Excel automation, and Tableau - translating behavioral, claims, and revenue data into decisions that cut reporting effort by 55%, reduced operational backlogs by 22%, and prevented $1.9M in compliance exposure. Experienced in post-release analytics QA, cohort tracking, and HIPAA-aligned reporting. Partner with cross-functional stakeholders and AI/ML teams to validate production feature signals and data quality before model releases. WORK EXPERIENCE

INTUIT, Data Analyst Jul 2024 - Present

• Owned post-release analytics QA for tax-filing and payment events; used SQL warehouse checks at row/timestamp level to identify duplicates and late-arriving records, reducing daily KPI volatility by 21%.

• Defined and implemented Power BI DAX measures for refund, acceptance, and error-state KPIs; delivered a daily performance dashboard to cross-functional stakeholders, reducing incident triage time by 35%.

• Ran post-release analytics validation in Python (Pandas) on raw event exports to confirm volume counts, ordering, and null handling before KPIs were cleared for leadership reporting.

• Reworked cohort retention and retry-failure tracking by correcting session stitching logic in the data layer, which improved repeat-user measurement accuracy by 17% for quarterly product reviews.

• Worked directly with the AI/ML team to sanity-check real-time feature inputs and anomaly flags in Python, ensuring training signals matched live user behavior before each model refresh. HUMANA, Business Data Analyst Jan 2024 - Jun 2024

• Analyzed Audited Medicare Advantage claims in SQL against CMS reimbursement rules, flagging billing mismatches that prevented $1.9M in potential compliance exposure during internal reviews.

• Built monthly compliance monitoring dashboards in Power BI (DAX) using enrollment, provider, and claims tables, helping Ops teams close audit findings 32% faster across two regional plans.

• Automated prior-authorization and denial tracking using Excel (VBA + macros), replacing manual case logs and reducing repeat denial turnaround time by 14% within one quarter.

• Validated eligibility and risk-adjustment feeds using SQL checks and reconciliations under HIPAA-aligned data handling rules, cutting downstream reporting defects by 41% before submission to compliance and regulatory teams. SAGE SOFTTECH, Business Intelligence Analyst Feb 2020 - Aug 2022

• Built end-to-end sales and revenue dashboards in Tableau using cleaned SQL warehouse tables, which helped leadership track monthly conversions and cut manual reporting effort by 55% across three client accounts.

• Pulled raw CRM, billing, and web-traffic data using SQL joins and window functions; built a funnel drop-off view that exposed broken lead-to-sale handoffs and improved qualified lead conversion by 18% after process fixes.

• Automated weekly business performance reports in Excel (Power Query + Pivot models), replacing static exports and saving nearly 12 hours per week for ops and account managers.

• Created customer churn and usage tracking models in Python (Pandas) using session and transaction logs, helping product teams isolate drop-off behavior and recover 9% lost active users within two quarters.

• Standardized multi-client reporting ELT pipelines by transforming raw feeds into structured fact and dimension tables in SQL, which stabilized dashboard refresh failures and improved data trust during client reviews. TECHNICAL SKILLS

Data Analysis & Statistical Methods: EDA, Root Cause Analysis, Variance Analysis, Cohort Analysis, Funnel Analysis, Statistical Analysis, Hypothesis Testing, A/B Testing, Regression Analysis, Clustering, Time Series Analysis, Predictive Modeling, KPI Definition, Data Storytelling, Trend Analysis, Business Insights Business Intelligence & Data Visualization: Power BI (DAX), Tableau, Looker, Power Query, Churn Analysis, Customer Segmentation, Retention Strategies, Marketing Campaign Analysis, Anomaly detection Data Engineering & Cloud Platforms: Data Pipelines, ETL, Data Modeling, Data Warehousing, Data Transformation, Apache Airflow, Informatica, Databricks, Cloud Data Warehousing, Snowflake, Amazon Redshift, Google BigQuery, AWS Programming & Scripting: Python (NumPy, Pandas, Matplotlib, SciPy, scikit-learn, Seaborn), SQL, Jupyter Notebooks, Reporting automation, data cleaning, aggregation, workflow orchestration, Statistical software, SAS EDUCATION

San Jose State University, Master of Science in Software Engineering GPA: 3.7/4.0 Aug 2022 - May 2024 CERTIFICATES

AWS Academy Graduate - Cloud Architecting (Amazon Web Services) AI For Everyone - Coursera Structuring Machine Learning Projects - Coursera

Contact this candidate