Data Analyst - SQL, Power BI, Python Expert

Keerthi Madhavaram Data Analyst

IL, USA +1-331-***-**** ************@*****.*** LinkedIn

SUMMARY

Data Analyst with 4+ years of experience using advanced SQL, Power BI, and Python to analyze healthcare and transactional datasets. Improve reporting efficiency, strengthen data accuracy, and support revenue cycle performance. Skilled in ETL development, data validation, dimensional modeling, and query optimization. Translate complex data into clear insights for operations, finance, and leadership teams.

TECHNICAL SKILLS

SQL & Data Querying: Advanced SQL, Joins, CTEs, Window Functions, Subqueries, Query Optimization, Indexing, Stored Procedures, Data Extraction, Data Validation

Programming: Python, Pandas, NumPy, Data Transformation, Automation Scripts Business Intelligence: Power BI, DAX, Data Modeling, Dashboard Development, KPI Reporting, Tableau Data Engineering: ETL Pipelines, Apache Airflow, Data Pipelines, Dimensional Modeling, Star Schema, Fact and Dimension Tables Databases & Cloud: SQL Server, Snowflake, PostgreSQL, MySQL, AWS S3 Analytics: Regression Analysis, Cohort Analysis, Trend Analysis, Variance Analysis, Performance Metrics Domain Knowledge: Healthcare Claims Data, Revenue Cycle Analytics, Operational Reporting, Financial Reporting Data Governance: Data Quality Controls, Reconciliation, Documentation, Audit Support PROFESSIONAL EXPERIENCE

Data Analyst

Sharp HealthCare

Dec 2024 - Current

• Analyzed 25M+ patient and claims records using advanced SQL (joins, CTEs, window functions), reducing report turnaround time by 35% and improving visibility into revenue cycle and operational performance.

• Developed interactive Power BI dashboards tracking readmissions, length of stay, denial trends, reimbursement metrics, and provider performance, contributing to a 12% reduction in preventable claim denials.

• Automated recurring ETL workflows using Python and scheduled data pipelines, decreasing manual reporting effort by 40% and improving consistency across monthly financial reporting cycles.

• Implemented data validation rules and reconciliation checks across billing and finance datasets, increasing reporting accuracy by 30% and reducing downstream corrections.

• Optimized long-running SQL queries through indexing and execution plan tuning, cutting query runtime by 28% across large healthcare datasets.

• Standardized KPI definitions and reporting logic across departments, eliminating metric discrepancies between finance, compliance, and operations teams.

• Performed variance and trend analysis during budgeting and forecasting cycles, supporting data-backed resource allocation and operational planning decisions.

• Documented data sources, transformations, and reporting logic to improve audit readiness and cross-team knowledge sharing.

Data Analyst

Ace Infoway

Jan 2021 - Dec 2023

• Wrote optimized SQL queries, joins, and stored procedures for business intelligence reporting, reducing dashboard refresh time by 30% across high-volume transactional systems.

• Built Power BI and Tableau dashboards analyzing revenue performance, customer segmentation, and operational KPIs, contributing to an 18% increase in campaign conversion rates.

• Developed automated data pipelines using Python and Apache Airflow, reducing manual data preparation by 45% and improving analytics delivery timelines.

• Redesigned dimensional models and fact tables within the data warehouse, increasing reporting accuracy by 25% and improving scalability for growing data volumes.

• Conducted cohort analysis, regression modeling, and trend evaluation to identify performance drivers and support marketing optimization strategies.

• Collaborated with engineering teams to resolve data inconsistencies and improve source system integrations, strengthening dataset reliability.

• Created standardized reporting templates and documentation, improving consistency across client deliverables and reducing rework.

EDUCATION

Master of Science in Health Informatics

Roosevelt University, Chicago, IL GPA: 3.83

Bachelor of Science in Microbiology, Biotechnology, Chemistry Siddhartha Degree College for Women, India CGPA: 8.7

Contact this candidate