Power Bi Business Intelligence

Sai Likitha *************@*****.*** 281-***-****

Professional Summary

Results-driven and detail-oriented MSBI and Power BI Developer with 6+ years of experience in designing, developing, and deploying end-to-end Business Intelligence solutions using the Microsoft BI Stack (SSIS, SSRS, SSAS), Power BI, and Azure cloud services. Expertise in data modeling, ETL processes, dashboard development, and performance optimization, with a strong foundation in T-SQL and data warehousing concepts.

Proficient in developing complex T-SQL queries, stored procedures, CTEs, views, functions, and performance-tuned scripts for handling high-volume transactional datasets.

Hands-on experience building scalable ETL pipelines using SSIS, incorporating dynamic configurations, robust error handling, and automation via SQL Server Agent and Azure Data Factory (ADF).

Extensive knowledge of Dimensional Modeling using Kimball methodology, including Star/Snowflake schemas, fact/dimension tables, and Slowly Changing Dimensions (SCD Types 1 & 2).

Delivered impactful reporting solutions using SSRS and Power BI, featuring KPIs, slicers, drill-downs, bookmarks, Row-Level Security (RLS), and custom DAX expressions.

Built and deployed SSAS Tabular and Multidimensional Models with DAX/MDX, hierarchies, perspectives, and calculated measures for high-performance analytical reporting.

Skilled in Azure Synapse Analytics, Azure SQL Database, Blob Storage, Power BI Service, and hybrid data orchestration strategies.

Experienced in Power BI Gateway, Power BI Embedded, dataflows, and live/direct query integrations with SSAS and Azure sources.

Knowledgeable in DevOps practices, including Git-based version control and CI/CD pipelines using Azure DevOps for automated deployment of BI artifacts.

Actively contributed in Agile/Scrum teams: sprint planning, backlog grooming, UAT, stakeholder demos, and cross-functional collaboration with analysts, product owners, and developers.

Well-versed in data governance, semantic modeling, lineage tracking, and report auditing to ensure secure, accurate enterprise reporting across industries such as finance, healthcare, retail, and operations.

Currently exploring modern tools like Power BI Dataflows, Azure Synapse, Databricks, and SSIS Integration Runtime in Azure to build future-ready BI architectures.

Microsoft Certified: Power BI Data Analyst Associate

Technical Skills

Business Intelligence (BI) Tools:

Power BI (Desktop, Service, Gateway, Embedded), SSIS (2012–2022), SSRS, SSAS (Tabular & Multidimensional), DTS, Microsoft PerformancePoint, ProClarity

ETL & Reporting:

SSIS, SQL Server Agent, Azure Data Factory (ADF), Paginated Reports, Drill-through Reports, Excel Pivot Tables, Power BI Dataflows, Power Query (M)

Databases & Data Warehousing:

Microsoft SQL Server (2008–2022), Azure SQL, Azure Synapse Analytics, Sybase, MS Access, Oracle

Cloud Platforms:

Azure Data Factory, Azure Synapse Analytics, Azure Blob Storage, Azure SQL Database, Azure Analysis Services, Power BI Service, SSIS Integration Runtime

Programming & Query Languages:

T-SQL, DAX, Power Query (M), C, C++, Java, VBScript, HTML, JavaScript, XML, XPath

Modeling & Design Tools:

Erwin Data Modeler, Microsoft Visio, Star/Snowflake Schema, Dimensional Modeling (Kimball), SCD (Type 1 & 2)

Development & Version Control Tools:

SQL Server Management Studio (SSMS), Visual Studio (2012–2022), Business Intelligence Development Studio (BIDS), Git, Azure DevOps, TOAD

Operating Systems:

Windows Server (2008–2022), Windows 10/8/7/XP

Collaboration & Productivity Tools:

Microsoft Office Suite, Microsoft Outlook, SharePoint (MOSS 2007), Microsoft Teams

Professional Experience

Client: CVS Health

Role: Senior BI / Data Engineer

Duration: April 2022 – Present

Responsibilities:

Designed and implemented modern BI and data integration solutions leveraging Azure Synapse, ADF, and Power BI Premium to deliver real-time analytics and scalable reporting across healthcare and life sciences domains.

Built and optimized data pipelines using SSIS, ADF, and cloud platforms (Azure, AWS, GCP), integrating diverse data sources including Oracle, Excel, flat files, and SQL Server, with a 35% reduction in ETL runtimes through query tuning and stored procedure enhancement.

Developed SSAS Tabular and Multidimensional models with KPIs, hierarchies, partitions, and perspectives to support analytical reporting and self-service BI initiatives.

Created executive dashboards and interactive reports using Power BI and SSRS, applying advanced DAX calculations, KPI scorecards, and drill-down/drill-through capabilities to support decision-making in Medicaid operations and pharmaceutical sales.

Led the migration of legacy BI platforms (e.g., Cognos) to Power BI, reducing report load time by over 50% and improving report usability and accessibility across departments.

Established centralized Power BI Dataflows and Shared Datasets, enabling semantic model reuse and governance across multiple teams.

Architected CI/CD pipelines for BI assets using Azure DevOps and Jenkins, improving version control, automating deployments, and reducing manual errors by 40%.

Implemented Row-Level Security (RLS) and Power BI Apps for secure, role-based access and streamlined report distribution.

Integrated Azure Purview to manage metadata and enable end-to-end data lineage tracking for data governance compliance.

Utilized Python (Pandas, NumPy) and Jupyter Notebooks for data wrangling, validation, and exploratory analysis within BI workflows.

Collaborated with business and technical stakeholders to define KPIs, gather requirements, perform gap analysis, and document functional/technical specifications.

Conducted training sessions for 30+ analysts and stakeholders, promoting Power BI best practices, semantic modeling, and performance optimization.

Optimized Power BI models with composite models, incremental refresh, and columnstore indexing to ensure high-performance analytics on large Medicaid and healthcare datasets.

Environment: Azure Synapse Analytics, Azure Data Factory, Azure SQL, Power BI (Desktop, Service, Dataflows), SSIS, SSRS, SSAS (Tabular & Multidimensional), SQL Server (2022/2019), Amazon Redshift, Google BigQuery, Snowflake, Python (Pandas, NumPy), Jupyter Notebooks, Git, Azure DevOps, Jenkins, Docker, Tableau

Client: Bank of America, North Carolina

Role: SQL BI Developer

Duration: July 2020 – March 2022

Responsibilities:

Migrated legacy DTS packages to SSIS 2019, incorporating robust error handling, logging (via event handlers and checkpoints), and retry mechanisms to improve ETL reliability.

Designed, developed, and deployed complex SSIS packages to extract, transform, and load data from heterogeneous sources (Excel, OLE DB, flat files) into SQL Server.

Created and scheduled automated jobs using SQL Agent and SSIS to refresh data warehouses and marts supporting enterprise reporting needs.

Designed star schema-based data models and implemented indexing strategies, table partitioning, and query optimization, resulting in up to 40% performance gains.

Developed and maintained SSAS Multidimensional and Tabular models with calculated members and measures using MDX and DAX; built user-friendly perspectives for business users.

Created interactive dashboards and executive-level reports in Power BI with Row-Level Security (RLS), alerts, and KPIs; published to Power BI Service and collaborated with 50+ stakeholders to drive adoption.

Built advanced SSRS reports including parameterized and drill-down reports, integrating financial, operational, and compliance KPIs; automated delivery using subscriptions.

Wrote and optimized T-SQL stored procedures, functions, and triggers, implementing complex business logic and ensuring referential integrity across systems.

Used SQL Profiler and Execution Plans to troubleshoot slow queries and improve performance across environments.

Collaborated with cross-functional teams (Finance, Sales, Compliance) to gather requirements, deliver actionable insights, and support strategic business decisions.

Managed database security, backup/restore operations, and migration of objects across environments, ensuring data integrity and availability.

Played a key role in the modernization of legacy reporting systems, contributing to the organization’s shift from static reporting to dynamic BI solutions.

Environment: SQL Server 2019, SSIS, SSRS, SSAS (Tabular & Multidimensional), Power BI (Desktop & Service), Azure SQL Database, T-SQL, Visual Studio 2019, Windows Server 2019, MS Office

Client: UnitedHealth Group, Minnetonka, Minnesota

Role: SQL BI Developer

Duration: May 2019 – June 2020

Responsibilities:

Developed and optimized ETL pipelines using SSIS to automate data ingestion from claims, insurance, and provider-related data sources.

Designed and maintained OLAP cubes in SSAS to support advanced analytical capabilities across business units.

Created source-to-target mapping documents and implemented complex business logic using stored procedures, functions, triggers, views, and constraints.

Assisted in modernizing the BI stack by integrating on-prem and Azure-based data sources into a Power BI-centered reporting architecture.

Designed and published interactive reports and dashboards using Power BI and Tableau; implemented complex DAX queries for calculated measures and KPIs.

Configured and maintained Power BI Gateway (Enterprise & Personal) and SSAS live connections to enable scheduled data refresh and real-time reporting.

Reduced T-SQL query overhead by applying performance tuning techniques such as indexing strategies, TOP operator, and query restructuring.

Developed data models (logical/physical) using ERWIN to support data warehousing and analytics solutions; participated in JAD sessions for requirement gathering.

Facilitated internal user training on Power BI for self-service analytics and conducted weekly presentations to business users on report updates.

Implemented audit logging, data quality checks, and data dictionaries to ensure compliance and data governance best practices.

Participated in PoCs for migration of legacy BI solutions to Azure Data Factory and Power BI Service.

Environment: SQL Server 2014/2016/2017, SSIS, SSRS, SSAS, Power BI (Desktop & Service), T-SQL, Tableau, Visual Studio 2016, BIDS, TFS, SharePoint, Azure Data Services, PowerShell, MS Excel

Education:

Masters in management information system from Lamar University, Houston, Texas.

Contact this candidate