Sai Kalyan Singaram

About Sai Kalyan Singaram

Accomplished Business Data Analyst with almost 5 years of expertise in healthcare, sales, and business analytics, skilled at converting complex datasets into actionable insights that drive business decisions.• Designed and deployed interactive dashboards in Power BI to track KPIs, operational metrics, and clinical outcomes. Worked on Qualtrics and Medallia.• Utilized Power Query for efficient data cleaning, transformation, and integration from multiple sources (SQL, Excel, EHR exports).• Developed custom DAX measures and calculated columns to support advanced analytics and reporting needs.• Built drill-down visualizations enabling stakeholders to explore data across departments, service lines, and timeframes.• Automated recurring reports in Power BI, improving report delivery time by 30% and reducing manual effort.• Proficient in using advanced tools such as Python (Pandas, NumPy), SQL, R, and Power BI for data cleaning, manipulation, and visualization to enhance data-driven strategies.• Collaborate with business stakeholders to gather requirements, translate business needs into data insights, and ensure alignment on project goals. • Create and maintain business requirement documents, data dictionaries, process workflows, and analytical reports for clear communication and decision-making.• Experienced in designing and building robust data pipelines with ELT tools (SSIS, Power Query) and data warehousing solutions (Snowflake, PostgreSQL), ensuring smooth and accurate data processing.• Expertise in applying statistical methods, including regression analysis, ANOVA, and machine learning algorithms (Random Forest, Linear Regression), to develop predictive models that support decision-making.• Adept at creating dynamic dashboards and reports using Tableau and Power BI, providing real-time insights into critical business metrics for stakeholders at all organizational levels.• Proficient in utilizing advanced Excel functions such as Pivot Tables and VLOOKUP to automate reporting processes, increasing operational efficiency.• Strong communicator with experience in presenting complex data insights to non-technical stakeholders, fostering data-driven decision-making, and supporting business growth.

Experience

1. Business Data Analyst

   Centene Corporation

   Feb 2023 — Present · Dallas, TX, US

   Analyzed over 2.5 million healthcare claims using SQL and Python (Pandas, NumPy) to identify over-utilization and under-utilization patterns, driving strategic improvements in resource allocation.• Designed and deployed interactive dashboards in Power BI to track KPIs, operational metrics, and clinical outcomes.• Utilized Power Query for efficient data cleaning, transformation, and integration from multiple sources (SQL, Excel, EHR exports).• Designed and developed visualizations with Seaborn and Matplotlib to monitor cost and utilization trends across geographies, enabling insights that optimized resource allocation by 20%.• Implemented Power BI dashboards to provide real-time insights into claims data, cost analysis, and predictive trends, reducing manual reporting efforts and accelerating decision-making.• Applied advanced statistical methods, including ANOVA and logistic regression (SciPy), to uncover drivers of high claims costs, resulting in policy adjustments that reduced expenses by 10%.• Automated ETL workflows using SQL Server Integration Services (SSIS) and Snowflake, cutting data pipeline processing times and improving data accessibility.

Education

• University of North Texas

  Master of Science - MS, Computer Science

• Jawaharlal Nehru Technological University Hyderabad (JNTUH)

  Bachelor of Technology - BTech, Computer Science