Power Bi Business Intelligence

Lakshmi

Email: *******.****@*****.*** Ph: 980-***-****

Professional summary:

Highly skilled Power BI Developer with over 9+ years of experience in Business Intelligence

(BI), Data Analytics, Dashboard Development, and ETL Pipelines across various domains including finance, healthcare, and retail.

Proficient in Power BI Desktop, Power BI Service, Power BI Pro, and Power BI Mobile, with extensive use of DAX, Power Query (M), Power Apps, and Power Automate to build interactive and performance-optimized dashboards.

Strong command in SQL, T-SQL, PL/SQL, and database development in SQL Server, Oracle, and Snowflake; skilled in performance tuning and writing complex queries, stored procedures, and triggers.

Hands-on experience with Azure Data Factory, Azure Synapse Analytics, Azure Data Lake, and Databricks for modern cloud-based data integration and analytics.

Expertise in SSIS for ETL, SSRS for paginated reports, and SSAS for OLAP cube development; experienced in Data Modeling (Star & Snowflake schema) and data warehousing concepts.

Managed full lifecycle of Power BI solutions – from requirement gathering, data extraction, transformation, reporting, to publishing and maintenance with automated data refresh and gateway configurations.

Strong knowledge of data governance, Row-Level Security (RLS), role-based access, and compliance in BI environments.

Experience in Agile/Scrum and SAFe methodologies, with tools like JIRA and Azure DevOps; SAFe 6.0 Scrum Master certified.

Proven ability to translate complex business requirements into compelling visual insights using KPIs, time-series analysis, dynamic filters, and custom visuals.

Collaborated cross-functionally with business analysts, data engineers, and stakeholders to deliver scalable, secure, and actionable BI solutions in enterprise settings.

Created custom visuals, tooltips, bookmarks, and drill-through pages to enhance storytelling in dashboards.

Designed parameterized and paginated reports using Power BI Report Builder and integrated them with Power BI Service.

Developed complex DAX measures for YTD, MTD, cumulative totals, and conditional formatting based on performance thresholds.

Built real-time dashboards using Direct Query and streaming datasets from APIs and cloud databases.

Integrated Power BI reports with SharePoint, Teams, and PowerApps for seamless business workflow.

Implemented incremental data refresh, enhancing report performance on large datasets.

Managed Power BI Gateway installation, configuration, and troubleshooting for on-premise data access.

Experience in embedding Power BI reports into web applications using Power BI REST APIs and JavaScript SDK.

Monitored and optimized report performance using Performance Analyzer, reducing load times by 50%.

Strong grasp on data lineage, data classification, and metadata management within BI ecosystems.

Developed KPI scorecards, heatmaps, variance analysis visuals, and executive summaries. Technical skills:

Business Intelligence &

Reporting

Power BI, DAX, Power Query, Power BI Gateway, SSRS, SSAS, Power Automate, SSIS, PowerApps

Databases SQL Server 2012/2014/2016/2017, SSAS, SSRS, Azure SQL Database, MySQL, Oracle, PostgreSQL

ETL Tools SSIS, Azure Data Factory, KingswaySoft

Programming &

Scripting

C#, SQL, Python, JavaScript, T-SQL, DAX, HTML, CSS Cloud & Data

Platforms

Azure (Azure SQL Database, Azure Data Lake, Azure Synapse Analytics), Power Apps, SharePoint Online, Power Automate Version Control Git, TFS, Azure DevOps

Development &

Reporting Tools

Visual Studio, Visual Studio Code, SQL Server Management Studio

(SSMS), Report Builder, SQL Server Data Tools (SSDT) Data Integration OData, RESTful APIs, Data Export Service, JSON, XML Security Role-Based Security (RBS), Field-Level Security, Power BI Row-Level Security (RLS), Azure Active Directory Integration Data Modeling & Data

Warehousing

SQL Server, Azure Synapse, Dimensional modeling, Star Schema, Snowflake Schema, OLAP

Collaboration Tools Microsoft Teams, SharePoint, PowerApps Portals, Microsoft 365 PROFESSIONAL EXPERIENCE:

FIDELITY, SOUTHLAKE, TX May 2024 - Present

Sr Power BI Developer

Responsibilities:

Developed and optimized interactive Power BI reports and dashboards to provide real- time insights into customer engagement, sales performance, and financial analytics.

Built data models in Power BI Desktop using DAX for advanced calculations and time- series analysis, improving decision-making.

Integrated Power BI with Azure SQL Database, SQL Server, and SharePoint to create consolidated, interactive reports.

Designed and developed complex SSRS reports with drill-through functionality and dynamic parameters to provide deep insights into customer transactions and account activities.

Created and optimized SSIS packages for ETL processes, extracting data from various sources, transforming it, and loading it into SQL Server and Azure SQL Database.

Automated data extraction and report updates using Power BI Gateways, ensuring timely and accurate dat refreshes for stakeholders.

Collaborated with the data engineering team to integrate data from external systems using REST APIs and Azure Logic Apps, enhancing data flow for reporting.

Created custom Power BI visuals and interactive filters for improved user experience and streamlined analysis.

Implemented Row-Level Security (RLS) in Power BI to ensure secure and granular access to financial and customer data based on user roles.

Built automated workflows in Power Automate for recurring data processing tasks, reducing manual effort and improving operational efficiency.

Utilized Azure Synapse Analytics for performing big data analysis and reporting, integrating on-prem and cloud data sources.

Developed and maintained complex SQL queries, stored procedures, and views to support reporting and data analysis.

Created data pipelines in Azure Data Factory to automate data transformation and loading processes, ensuring data consistency and accuracy.

Optimized Power BI reports by reducing query execution time using best practices in DAX and efficient data modeling.

Monitored and troubleshot data refresh issues and performance bottlenecks in Power BI and SQL Server environments.

Worked on Power BI Embedded to create white-labeled dashboards for external customers, enhancing the user experience and accessibility.

Performed data reconciliation and validation using SQL Server queries to ensure that the data loaded into Power BI matched source systems.

Deployed and published reports to Power BI Service, sharing insights across business units and enhancing cross-department collaboration.

Created and configured SSRS subscription reports for automated email delivery of monthly and quarterly financial reports.

Developed custom Azure Functions for processing complex data transformations outside the main ETL pipeline, reducing processing times.

Worked with business analysts to gather reporting requirements and designed Power BI reports to meet organizational objectives.

Implemented dynamic slicers and filters in Power BI reports for enhanced drill-down capabilities and better user experience.

Participated in code reviews and Agile sprint planning sessions, ensuring high-quality deliverables and timely completion of tasks.

Environment: Power BI, DAX, Power Query, SSRS, SSIS, Azure SQL Database, SQL Server, Azure Synapse Analytics, Azure Data Factory, Azure Logic Apps, Power Automate, REST APIs, Power BI Gateway, Azure Functions, Power BI Service, Git, JIRA, Azure DevOps, SQL Server Management Studio (SSMS), Visual Studio, PowerShell Huntington Bank, Columbus, OH August 2022 - May 2024 Senior BI Developer

Project Description: Working on Finance/Revenue Reports, bookings, maintenance bookings, maintenance revenue and sales Business Dashboards, goal of project is to focus on the collection, integration, and analysis of data from different sources. This focus will result in greater insights and more effective to support decision making. My role is to explore and transform data in the form of reports and visualizations to business users. This data is then used for making decisions on equipment management. The Project involved in developing the dashboards in Power BI, Tableau.

Key Contributions:

Extracted the data from non-database sources (XLS, CSV file), Database sources (SQL Server) and Developed Visualizations by using Power Bi.

Published reports into Power BI publisher and schedule the data sets, providing row level security.

Shared dashboards to users through Office 365, Content Packs.

Integrate Power Apps to Power BI reports to receive client required feedback from business users using different DB’s, Power Automate

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.

Applied DAX for Various Reports.

Use different (DAX) Expressions to create measures and calculated column.

Using DAX and Branch Method created the n Number of TOP Levels in the visuals for result

(Top 3, 5 or any number to present the Data)

Utilized Power BI Desktop for data modeling and created datasets for paginated reports.

Created the Row Level Security using the branch method of Path and PathContain Function in the Calculated column and managing the role (Using DAX)

Applied the DAX (Data Analysis Expressions) to various types of reports Time Intelligence, Cost and Benefit analysis.

Created the Running Total for the Monthly Billing.

Applied DAX creating different measures and Calculated Columns

Created Call summary reports on Power BI with the implementation of the Data Analysis Expressions and working deep with the M-Language to fix the bug and issue in Power Query editor

Responsibilities:

Developed Dashboard Visualizations, cross tables, Bar charts, Waterfall, Tree map and complex reports which involves custom Controls and Custom Expressions using bars, lines and pies, maps, scatter plots, Gantts, bubbles, histograms, bullets, heat maps and highlight table.

Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, and Scatter Plots in Power BI.

Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.

Created different data visualizations using Lines, Pies, Histograms, Maps, Scatter, Bullets using Power BI.

Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.

Creation of extracts, publish data sources to tableau server, set up refresh schedule for extracts in Tableau serve and monitoring the failure extracts and trouble shooting.

Deployed and scheduled the reports in the Service.

Published Power BI Reports in the required origination and Made Power BI Dashboards available in Web clients and mobile apps.

Wrote DAX expressions to create new measures, calculations per business requirements.

used data blending, filters, actions, and hierarchies feature in Power BI. Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Responsible for Developing Dashboard and preparing ad-Hoc Reporting.

Wrote complex T-SQL queries to retrieve and transform data for paginated reports.

Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.

Utilized Tableau server to publish and share the reports with the business users.

Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.

Participated in daily stand-ups with clients on daily design and development effort.

Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions. Environment: Azure, MS SQL Server, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Migration Assistant (SSMA), Oracle, SQL Profiler, T-SQL, Power Bi Desktop, pro

Client: Healthfirst, New York, NY October 2018 - August 2022 Role: Power BI Developer

Project Description: Project involves in developing dashboards in Power BI, Tableau. Developed BI analytics strategy, The Project involved in developing the dashboards in Azure environments.

Responsibilities:

• Worked with various versions in Tableau, Tableau Server, Tableau Public, Tableau Reader and Tableau Online.

• Extensive experience on building dashboards using Tableau.

• Ability to introduced Tableau to Client’s to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user and help them make effective business decisions.

• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

• Created incremental refreshes for data sources on Tableau server.

• Involved in Requirements gathering/analysis, Design, Development, Testing and Production roll of Reporting and Analysis projects.

• Able to creatively stretch the capability of Tableau to customize and develop creatively stunning and dynamic visualizations.

• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

• Deep, technical knowledge of both Tableau Desktop and Tableau Server from an administrative and a consultative standpoint.

• Strong oracle SQL skills with good knowledge of RDBMS concepts.

• Work directly with Quality Assurance associates to ensure all deliverables are accurate and of the highest quality.

• Designed and developed ETL workflows and datasets in Alteryx.

• Processed data in Alteryx for tableau reporting.

• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

• Managed report subscriptions to deliver paginated reports to stakeholders via email or other distribution channels.

• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.

• Designed and developed ETL solution using SSIS, Azure data factory and created CAS jobs using Microsoft internal tools like Geneva Analytics data studio. Environment: Hadoop, Tableau Amazon Redshift, Data stage 7.5, Python, Alteryx, Teradata, Oracle 12c, SQL Server 2008, TOAD, PL/SQL, Java Script. Azure, DevOps. Amazon, India Jan 2016 - October 2018

Power BI Developer

Project Description: This project is an Ecommerce web-based application which allowed the customer to get a view of all the products in the store and buy them online. The application mainly dealt with the online payment and billings. It provides a search feature which uses Regular Expression or pattern matching with a user interface called Search box through which consumers can access and view latest and top selling products/offers. It uses Secure Good payment Gateway solution for customer to make a payment.

Responsibilities:

Developed diverse PowerBI dashboards incorporating various chart types (Pie Charts, Bar Charts, Tree Maps) for effective data visualization.

Utilized Power 81 (POWER Pivot/View) to design scorecards and dashboards tailored for different departments and upper-level management.

Conducted investigative projects using Python for data analysis and machine learning.

Experienced in working with Azure services such as Blob Storage, Data Lake, Data Factory, Azure SQL, and Databricks.

Analyzed website activity using Google Analytics to gather insights.

Developed data profiling, munging, and missing value imputation scripts in Python for data understanding.

Architected and implemented medium to large-scale BI solutions on Azure using various Azure Data Platform services.

Exposed and worked in Cloud platforms such as AWS, Azure Data Lakes, MDS (Master Data Services) systems, & Sisense (Data Virtualization tool).

Designed cross-functional dashboards integrating Azure Data Lake and Snowflake via DirectQuery.

Developed ETL pipelines and cloud-based reporting solutions.

Implemented governance policies and optimized large-scale reporting systems.

Coordinated multi-vendor teams across geographies; managed timelines, risk, and executive reporting.

Used Power BI and Excel for metrics dashboards, improving visibility into budget and resource allocation

Developed cross-functional dashboards using Power BI and Qlik, improving access to sales and claims data.

Worked with Azure Data Lake and Snowflake to model and serve data.

Delivered scalable visualizations and scorecards for executives and department leads.

Developed cross-functional dashboards using Power BI and MicroStrategy embedded reports.

Modelled Snowflake cubes and integrated with Power BI Direct Query.

Built ETL pipelines using Azure Data Factory and performed big data analysis using Spark.

Implemented governance and auditing through O365 Security Center.

Connected Power BI with ERP systems, EHR platforms, and cloud environments, ensuring secure and seamless data access.

Experience with APIs and data connectors, streamlining data flow from EHR systems to Power BI

Configured Power BI datasets to connect to Snowflake using Direct Query and Import Mode, optimizing performance for large datasets and ensuring efficient data retrieval for analytics.

Utilized Power BI (Power View) to create various analytics dashboards that depicts critical KPI along with slicers and dicers enabling end -user make filters

Proficient in administering activities in O365 Security & Compliance Center, ensuring secure dashboard access.

Expertise in data processing with big data ecosystem tools and databases (HDFS, Spark, Hive, AWS Redshift).

Strong knowledge of SQL Server, SSIS, SSAS, and SSRS for ETL processes and report development.

Implemented auditing strategies for data governance, ensuring quality, master data management, and stewardship.

Created Alteryx workflows for data preparation, blending, and visualization in Tableau & Power BI.

Automated workflows using PowerShell and developed monthly reports with Python, improving efficiency.

Managed Cisco Meraki for gateway/firewall/switch, VPN, wireless APs, website/port monitoring, and traffic shap- ing.

Modeled SISENSE cubes and designed dashboards with different widgets that represents KPI’s.

Extensive experience in developing stored procedures, views, triggers, and complex queries on SQLServer.

Generated ad-hoc reports in Excel Power Pivot and shared insights using Power BI for strategic planning.

Experienced with reporting tools such as SQL Database, Hadoop, Tableau, and Salesforce dashboards.

Strong knowledge of designing and creating dimension and cubes with Snowflake and STAR schema using SSAS.

Environment: SSAS, SQL, Hadoop, Tableau, Power BI, KPI’s, SSIS, SSRS, ETL, VPN, HER, Data Lake, Blob Storage,

Contact this candidate