Senior Power BI Developer with 6+ Years BI Experience
Resume:
Kasa Prathyusha
Sr.Power BI Developer
********.******@*****.***
PROFESSIONAL SUMMARY:
Overall, 6+ years of experience in Data Visualization and Business Intelligence.Knowledge in Designing, Administration, Analysis, Order Management, Customer loyalty analytics, including needs assessment, business process flows, Analytics repository management, Administration, and the development of custom modules for the Business Intelligence Data Warehouse using Power BI, Snowflake DB, and Alteryx. Proven ability to translate complex business requirements into robust analytical solutions. Experience with Azure Synapse pipelines, dataflows, views, and end-to-end data warehousing lifecycle. Adept at collaborating with stakeholders, conducting unit testing, and optimizing data performance. Strengths include teamwork, multi-tasking, and delivering high-quality results; organized, goal-oriented, and sociable.
Proficient in Power BI development, creating complex, interactive, and innovative dashboards with drill-down, drill- through, and drop-down menu options.
Skilled in data modeling, performance tuning, and transforming raw datasets into actionable dashboards using DAX and Power Query (M).
Experience in ETL development, data mapping, metadata management, and designing reporting solutions from multiple data sources and warehouses.
Extensive experience in Power BI Desktop, Power BI Service/Administration, including troubleshooting, user/group setup, permissions, and security roles.
Developed executive dashboards and leadership reports, converting data into actionable insights to influence C- suite strategic decisions.
Applied advanced Power BI capabilities, including calculations, parameters, hierarchies, groups, sets, trend lines, forecasting, and advanced analytics visuals.
Strong track record in healthcare BI reporting, building dashboards aligned with HIPAA, Medicaid/Medicare, and accreditation standards such as Joint Commission quality and safety metrics.
Hands-on experience in real-time and historical trend analysis, KPI tracking, and performance monitoring, enabling operational and strategic decision-making.
Built composite models in Power BI, balancing import and Direct Query modes for large-scale datasets.
Implemented Row-Level Security (RLS) and role-based access controls to safeguard sensitive healthcare and financial data.
Integrated Power BI with Azure services (ADF, Azure SQL, Azure Analysis Services) for scalable enterprise-level analytics.
Experienced in Power BI Report Builder, creating paginated reports for drill-down, drill-through, and parameterized reporting.
Collaborated with data engineers to optimize ETL pipelines, data integration workflows, and automate processes using Azure Data Factory and PySpark for large-scale transformations.
Expertise in SQL and T-SQL, writing complex queries, stored procedures, and performance-optimized solutions to support BI reporting.
Delivered hands-on training and mentorship to business users, enabling self-service analytics while maintaining governance and compliance standards.
Strong ability to translate business requirements into actionable BI solutions, ensuring insights directly support organizational strategy and operational efficiency. TECHNICAL SKILLS:
Category Skills & Tools
Data Visualization / BI Power BI, Tableau (2020.x/10), Qlik Sense, Crystal Reports, SSRS ETL & Data Modeling Microsoft Fabric, Azure Synapse Pipelines, Azure Data Factory (ADF), PySpark, Alteryx, Informatica, SSIS
Databases &
Warehousing SQL Server, Snowflake, Oracle, Google BigQuery, Hive, Dremio Programming &
Scripting SQL, T-SQL, PL/SQL, Python, PySpark, DAX, Power Query (M), PowerShell Specialized Expertise
Trend Analysis, Forecasting Models, Executive Dashboards, KPI Scorecards, Accreditation
& Compliance Reporting, Leadership Presentation of Insights Category Skills & Tools
Domain Knowledge
Healthcare (Accreditation, Compliance, Joint Commission Standards, EHR/Clinical Data, Medicaid, SNAP), SaaS, Customer Success, Finance, HR, Sales, Marketing, Event Survey Big Data Systems Apache Spark, Spark SQL, Azure Data Lake, Dataflows, Data Marts, Views, Complex Joins Cloud Platforms Microsoft Azure (ADF, Data Lake, Synapse, Azure SQL), Google Cloud (BigQuery) Version Control & Tools Git, TFS, MS Office Suite (Excel, PowerPoint, Visio, Project, SharePoint) Work Experience
Memorial Healthcare System, Miramar, FL May 2024 – Present Senior Business Intelligence Developer
Responsibilities:
Proficient in Power BI Desktop for data visualization and interactive report/dashboard creation.
Experienced in Power BI Service, including publishing reports, workspace creation, app deployment, user access, and collaboration.
Designed compliance-oriented dashboards tracking healthcare metrics, accreditation KPIs, patient safety indicators, and regulatory reporting requirements.
Implemented Row-Level Security (RLS) and workspace access controls to ensure secure, role-based data access.
Migrated legacy Crystal Reports and SSRS reports to Power BI for modernized reporting.
Built SSAS Tabular models and implemented DAX measures for high-performance calculations and multi-dimensional analysis.
Extensive experience in Power Query (M) for data transformation, cleansing, and integration from multiple sources (SQL Server, Oracle, CSV, Excel, Snowflake, Azure).
Developed Azure Synapse pipelines, Dataflows, and Microsoft Fabric integrations to automate ETL and data integration for healthcare datasets.
Leveraged PySpark and Spark SQL for large-scale healthcare data processing, transformations, and batch ETL workflows.
Created interactive dashboards with advanced visualizations: drill-through, drill-down, maps, KPIs, trend lines, forecasted reports, hierarchies, bins, sets, and calculated fields.
Developed automated refresh and alert processes for Power BI datasets using integrated Power Automate flows.
Optimized SQL queries, stored procedures, complex joins, and indexing to enhance report and dashboard performance.
Designed OLAP/SSAS models for dimensional analysis and enterprise reporting.
Performed data wrangling, mapping, and modeling across large-scale healthcare and public health datasets, ensuring accuracy and reliability.
Built dashboards for case management, eligibility, service intake, appeals resolution, and other healthcare program metrics.
Implemented data integration pipelines using Azure Data Factory and Azure SQL to consolidate multiple healthcare and administrative data sources.
Developed KPI-based dashboards with calculated measures to support monitoring of healthcare program performance and compliance.
Published and maintained Power BI reports, apps, and datasets for enterprise-wide consumption.
Conducted unit testing, data validation, and troubleshooting to ensure high-quality reporting outputs.
Automated ETL and reporting workflows, reducing manual intervention and enhancing efficiency.
Collaborated with stakeholders to translate business requirements into actionable BI solutions, metrics, and visualizations.
Environment: Power BI Desktop & Service, Power Query (M), DAX, Qlik Sense, Tableau, SQL Server, Snowflake, MySQL, SSRS, Azure Synapse, Microsoft Fabric, Azure Data Factory, Azure Dataverse, Azure Data Lake, PySpark, Spark SQL, PowerShell, Power Automate, SSAS Tabular, Git, ServiceNow, MS Excel, TOAD. Wells Fargo, Chicago, IL Aug 2022- May 2024
Business Intelligence Developer
Responsibilities:
Built interactive financial dashboards featuring drill-through, drill-down, KPIs, variance analysis, and time intelligence to track revenue, expenses, and portfolio performance.
Developed and maintained SSAS tabular models for banking analytics, implementing Row-Level Security (RLS) to ensure secure access to sensitive financial and customer data.
Designed and implemented ETL pipelines using Azure Data Factory (ADF), SQL Server, Snowflake, AWS S3, Oracle, and REST APIs to integrate core banking, transaction, and regulatory data.
Migrated banking data platforms and BI infrastructure to Microsoft Azure, enhancing scalability, performance, and ensuring robust backup and disaster recovery strategies.
Developed complex T-SQL queries, stored procedures, triggers, and views to support financial reporting, transaction processing, and regulatory compliance.
Modeled financial metrics such as loan portfolio performance, credit risk trends, customer churn, and revenue forecasting using Power BI and DAX time intelligence.
Designed enterprise data pipelines integrating multiple financial data sources (core banking systems, payment systems, and external APIs) for unified reporting.
Automated data refreshes and ETL workflows using Power Query, ADF, and Power BI dataflows to enable near real-time financial reporting and monitoring.
Built executive dashboards and KPI scorecards for risk management, compliance, treasury, and profitability analysis.
Conducted data validation, reconciliation, and exploratory analysis to ensure accuracy and integrity of financial datasets.
Published secure Power BI reports for stakeholders, ensuring compliance with data governance policies and implementing RLS and access controls.
Designed and maintained OLAP/SSAS models for financial and regulatory reporting, supporting multidimensional analysis.
Optimized SQL queries, joins, and stored procedures to improve performance of financial dashboards and reduce report latency.
Implemented data warehouse and dimensional modeling (star/snowflake schemas) tailored for banking analytics and regulatory reporting requirements.
Environment: Power BI Desktop & Service, DAX, Power Query, SSRS, Qlik Sense, SQL Server, Oracle, Snowflake, MySQL, Azure Synapse, Azure Data Factory, Azure SQL, SSAS (Tabular/OLAP), T-SQL, Python, Tableau, Workday APIs, AWS S3, Redgate, Excel, Jira, Agile.
Centene Corporation, Tampa, FL May 2020 to Aug 2022 Business Intelligence Developer/ Analyst
Responsibilities:
Gathered and analyzed business requirements and translated them into interactive Power BI dashboards and reports aligned with business KPIs.
Designed and developed scalable Power BI data models using Star/Snowflake schemas, relationships, and optimized data structures.
Built interactive dashboards using advanced features such as Drill-through, Drill-down, Bookmarks, Slicers, and Custom Visuals.
Developed complex DAX measures and calculated columns for KPI tracking, trend analysis, and forecasting.
Utilized Power Query (M language) for data extraction, transformation, and data cleansing from multiple sources.
Integrated Power BI with SQL Server, Azure SQL, BigQuery, MySQL, and cloud data sources for enterprise reporting.
Implemented Row-Level Security (RLS) and role-based access control to ensure secure and governed data access.
Built and optimized Power BI datasets using techniques like query folding, incremental refresh, and aggregation tables for large-scale data.
Created Power BI dataflows and semantic models to enable reusable and centralized data transformation logic.
Published reports to Power BI Service, configured workspaces, apps, and managed deployment across environments.
Performed performance tuning of dashboards and datasets to reduce load time and improve user experience.
Developed SSIS ETL packages to extract, transform, and load data into data warehouses and Power BI reporting layers.
Designed and deployed SSAS Tabular models, creating KPIs, hierarchies, and measures for analytical reporting.
Created SSRS reports including drill-down, parameterized, and paginated reports for operational reporting needs.
Integrated Azure Data Factory (ADF) pipelines for automated data ingestion and transformation workflows.
Built KPI-driven dashboards for business performance, compliance tracking, and operational insights.
Conducted data validation, testing, and troubleshooting to ensure data accuracy and consistency.
Collaborated with cross-functional teams to deliver end-to-end BI solutions from data ingestion to visualization.
Migrated legacy reports (SSRS/Tableau) to modern Power BI solutions for enhanced usability and performance.
Optimized SQL queries, stored procedures, and database objects to support efficient reporting and analytics. Environment: Power BI Desktop & Service, Power Query, DAX, Microsoft Fabric, SQL Server, Oracle, MySQL, Google BigQuery, Dremio, SSIS, SSAS, Tableau, R, Python, Excel, Jira, MS Project, Alteryx, Apache Hadoop, Agile. Education: Master’s in Information Technology, Webster University
Contact this candidate