Hema Vankayalapati

Developed Power BI visualizations, KPIs, and advanced DAX queries; built compliance-driven Paginated Reports for claims, billing, and utilization; configured Azure security groups; built Python ETL pipelines; created dashboards for usage, billing, and membership; designed and maintained Power Query M transformations; implemented reusable M functions; integrated PL/SQL-backed views; scheduled SQL Server Agent jobs; integrated Microsoft Dataverse; enforced HIPAA Row-Level Security; built Power Platform apps and flows; developed Fabric data pipelines; supported SharePoint Online, OneDrive, Power Apps, and Power Automate.

Planned, defined, and designed data architectures; performed data analysis and migration; gathered requirements; created financial performance dashboards and SSRS reports; converted Excel-based models to Power BI dashboards and Paginated Reports; optimized Power BI reports; built SQL queries, views, and stored procedures; developed reusable Power Query transformations; implemented complex DAX calculations; used Python (PySpark) for preprocessing data for Snowflake; automated data transformation jobs; created and shared dashboards with security/embedding; worked in Agile with 2-week sprints; optimized reports for large data volumes; collaborated with finance stakeholders on KPIs.

Gathered requirements, prepared functional/technical design documents; collected and cleaned data from multiple sources; developed SQL queries for analysis; built interactive dashboards (Power BI/Tableau) to track KPIs; performed EDA to identify patterns and anomalies; supported ad-hoc analysis; designed basic data models; automated recurring reports using Power Query/Python; ensured data quality and governance; collaborated with senior analysts and engineers on metrics and data governance.