Sharath Chandra Appanabhotla

Business Analyst @Premier Inc.

NC, US

Designed, developed, and maintained scalable Power BI dashboards and reports for multipledepartments, including finance, healthcare claims, and marketing, ensuring data accuracy and visual appeal.• Created custom Power Apps integrated with SharePoint Online and Dataverse, streamlining claimsubmission and approval processes with user-friendly interfaces.• Developed and optimized Power Automate workflows to automate repetitive tasks such as eligibilitychecks and data syncing between disparate healthcare systems, cutting manual processing time by 40%.• Connected Power BI to various data sources (SQL Server, PgAdmin, Excel, EHR systems) with seamlessdata refresh scheduling and error handling.• Built advanced data models using Power Query and DAX to support complex analytics, incorporatingcalculated columns, measures, and hierarchies.• Implemented row-level security (RLS) to control data access by roles and user groups, safeguardingsensitive patient and financial data.• Developed PowerShell and Python scripts to extend Power Platform capabilities, automate administrative tasks, and perform data validation and cleansing.• Maintained and enhanced SharePoint Online sites, including custom lists, forms, and workflows to support cross-team collaboration and documentation management.• Conducted stakeholder interviews and workshops to gather detailed business requirements, translating them into technical user stories and acceptance criteria.• Collaborated with Solution Architects and development teams to ensure Power Platform solutions metenterprise architecture standards and compliance requirements (HIPAA, HL7, FHIR).• Led UAT test plan creation and execution, ensuring deployed solutions met business needs and were free of defects before release.• Provided end-user training sessions and created documentation materials to facilitate Power Platformadoption and best practices.