Anukrithi Myadala

Senior Power BI and SQL developer with 5+ years building enterprise dashboards backed by SQL reporting layers for operations, finance, procurement, and supply chain teams. Subject-matter expert across Power BI Desktop and Service, DAX, Power Query (M), and advanced SQL, with deep data modeling (star schema, fact/dimension, many-to-many) and report performance tuning. Experienced leading data platform migrations and standing up automated pipelines and refresh schedules.

Known as the go-to resource for Power BI troubleshooting, governance, documentation, and end-user enablement, partnering directly with business stakeholders to turn reporting needs into accurate, actionable dashboards.

Senior Business Intelligence Engineer at Virginia Department of Transportation (2021-07 – 2026-03)

• Partnered directly with business stakeholders (executive and director level) to gather reporting requirements and translate them into 60+ enterprise Power BI dashboards and semantic models across operations, finance, procurement, and supply chain — serving 2,000+ users.
• Wrote and tuned complex SQL (joins, GROUP BY, views, stored procedures, CTEs, window functions) to build the reporting views and datasets behind Power BI dashboards, and optimized slow queries for report performance.
• Applied data modeling best practices — star schema design, fact/dimension and many-to-many relationships — and architected a governed tabular model on Azure Analysis Services with composite storage and incremental refresh over 50M+ row fact tables, cutting full refresh from ~4 hours to ~25 minutes and report load times by 55%.
• Served as the go-to resource for Power BI troubleshooting, performance tuning, and best-practice guidance, including advanced DAX (calculated columns, measures, time-intelligence, variance, rolling averages, YoY/QoQ, what-if) and Power Query (M) custom transformations.
• Built automated data pipelines and refresh schedules on Azure Synapse and Azure Data Factory, replacing brittle ad-hoc SSIS jobs to ensure timely, reliable reporting.
• Led migration of 15+ legacy SSRS and Tableau workbooks to Power BI and supported the agency's move to a modern Azure data platform — re-modeling schema and rebuilding reporting logic rather than lift-and-shift; embedded reports into operations portals via Power BI REST API.
• Implemented governance measures — Row-Level Security across 6 regional districts and 40+ functional groups so users only saw authorized data — plus version control, regular data quality checks, and reconciliation of report totals against source systems.
• Performed manual data validation in Excel (pivot tables, lookups) to verify dashboard accuracy against source financials, and built conforming Power Query transformations from Oracle EBS, SAP, Salesforce, SQL Server, and flat files.
• Handled ad-hoc reporting requests from business teams within agreed turnaround times, tracking work in Jira alongside project-based dashboard delivery.
• Documented data sources, business logic, and report definitions, authored the agency-wide BI style guide and governance standard, and trained stakeholders to maximize self-service analytics adoption.

Front-End Developer / BI Analyst at University of South Carolina (2020-05 – 2021-05)

• Authored SQL Server and Oracle datasets (CTEs, window functions, cumulative aggregations) powering recurring and ad-hoc Tableau and SSRS reports.
• Delivered Tableau dashboards and ad-hoc reports for deans and program directors covering COVID-19 tracking, library services, and student engagement.
• Built SSRS tabular, matrix, and parameterized reports integrated with campus data-warehouse sources, and trained stakeholders on self-service analytics.

M.S. in Software Engineering – San José State University (2027)

B.S. in Computer Science – University of South Carolina (2021-05)