Power Bi Azure Data

Gunti Mounika

Sr. Power BI Developer

737-***-**** ************.*****@*****.***

Professional Summary

●Over 6+ years of working experience as Power BI with high proficient knowledge in Data Analysis

●Excellent proficiency in Software Development Life cycle (SDLC), Agile/Scrum and waterfall methodologies.

●Expert in creating Power BI Reports, Dashboards, using Power BI Desktop Power BI Pro, and Power BI Service.

●Hands - on experience in Azure Cloud Services: Azure Data Explorer, Azure Synapse Analytics, SQL Azure, Data Factory and Azure Data Lake, Expertise in generating reports using SQL Server Reporting Services (SSRS), Power Implemented Azure Dataflow Gen2 and Dataflow transformations in Microsoft Fabric to cleanse, transform, and enrich large datasets for downstream analytics.

●Designed and developed ETL pipelines in Data Factory (via Fabric) to ingest data from on-premises Oracle databases using Self-hosted Integration Runtime, migrating structured data efficiently into the Fabric Lakehouse.

●Built reusable and parameterized pipelines supporting incremental load strategies to enhance performance and reduce cost.

●Managed Fabric workspaces, including organizing artifacts (Lakehouse, Notebooks, Pipelines), assigning roles, and implementing access control (RBAC) for secure collaboration.

●Ensured data consistency, reliability, and compliance with enterprise standards by implementing data validation scripts and monitoring solutions using Fabric Monitoring Hub and Azure Monitor.

●Collaborated with cross-functional teams to automate end-to-end data ingestion, transformation, and reporting workflows in Fabric, reducing manual intervention by 60%.

●Enabled real-time analytics by integrating Fabric Lakehouse with Power BI (Direct Lake mode), providing stakeholders with instant insights into business metrics. Experience with BI tools: Power BI, Tableau, SAP BusinessObjects, Excel Services.

●Good exposure to Python programming, Effective development and support knowledge on Oracle, SQL, PL/SQL, T-SQL queries, Experience in Logical Data Model (LDM) and Physical Data Models (PDM) using Erwin, ER/Studio and Power Designer data modeling tools.

●Experience in designing interactive dashboards, reports, performing ad-hoc analysis and visualizations using Tableau and Power BI, Hands-on experience in Normalization and De-normalization techniques for effective and optimum performance in OLTP and OLAP environments.

●Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.

●Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Data Profiling, Data Mapping, Performance Tuning and System Testing.

●Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment, Experience on publishing Power BI reports on dashboards in Power BI server.

●Experience in extract transform and load(ETL) processing large datasets of different forms including structured, semi - structured and unstructured data

●Execute change management processes surrounding new releases of SAS functionality

●Strong background in data processing, data analysis with hands on experience in UNIX and Windows Servers.

●Working in reporting using Business Objects, Crystal reports, Designed WEBI /CR reports.

●Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.

●Implemented Azure Dataflow Gen2 and Dataflow transformations in Microsoft Fabric to cleanse, transform, and enrich large datasets for downstream analytics.

●Designed and developed ETL pipelines in Data Factory (via Fabric) to ingest data from on-premises Oracle databases using Self-hosted Integration Runtime, migrating structured data efficiently into the Fabric Lakehouse.

●Built reusable and parameterized pipelines supporting incremental load strategies to enhance performance and reduce cost.

●Managed Fabric workspaces, including organizing artifacts (Lakehouse, Notebooks, Pipelines), assigning roles, and implementing access control (RBAC) for secure collaboration.

●Ensured data consistency, reliability, and compliance with enterprise standards by implementing data validation scripts and monitoring solutions using Fabric Monitoring Hub and Azure Monitor.

●Collaborated with cross-functional teams to automate end-to-end data ingestion, transformation, and reporting workflows in Fabric, reducing manual intervention by 60%.

●Good experience in developing, deploying, and managing reports using SQL Server Reporting Services (SSRS) for enterprise-level reporting solutions.

●Extensive domain knowledge of Property & Casualty Insurance, including policy administration, claims, underwriting, and premium reporting.

●Enabled real-time analytics by integrating Fabric Lakehouse with Power BI Direct Lake mode, providing stakeholders with instant insights into business metrics.

●Good communication skills, work ethics and the ability to work in a team efficiently with good leadership skills.

Technical Skills

Business Intelligence: Power BI Desktop, Power BI Pro, Power BI Report Server, Tableau and Business Objects.

Databases: Oracle 12c/11g,Teradata15/14,DB2, SQL Server, Synapse

Cloud Services: Azure Data Explorer, Azure Data Lake, Azure Data Factory, SQL Azure, Azure Data Bricks

Reporting Tools: Excel, SSRS, Power BI, Tableau, SAS, Business Objects. Project Execution Methodologies: JAD, Agile, SDLC, Waterfall, and RAD ETL Tools: SSIS (SQL Server Integration Services), Informatica Operating Systems: Window and UNIX

Professional Experience

Teladoc Health - Tampa, FL July 2024 – Present

Senior Power BI Developer Responsibilities:

●Worked with Power BI Service for creating Dashboards and sharing them to business users.

●Integrated custom visuals based on business requirement using Power BI desktop

●Collaborated with and across agile teams to design, develop, test, implement, and support technical solutions in Microsoft Azure Data Platform.

●Analyzed data from heterogenous sources using Azure Data Explorer.

●Involved in Data Cleansing using Power Query in Power BI Desktop Editor.

●Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports, Developed visual reports, dashboards and KPI scorecards using Power BI desktop.

●Recreated existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL data warehouse environment

●Presented the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.

●Wrote calculated columns, Measures query’s in Power BI desktop to show good data analysis techniques, Deployed Tableau Connect with Azure SQL Synapse Analytics and SQL Database to set up the data source.

●Developed Python scripts to clean the raw data.

●Analyzed and designed the business rules for data cleansing that are required by the staging and OLAP & OLTP database, 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.

●Designed and developed T-SQL stored procedures to extract, aggregate, transform, and insert data

●Performed the Exploratory Data Analysis and Descriptive Data Analysis in Python using Pandas, Matplotlib, Seaborn, SciPy, NumPy, Azure Data Explorer and StatsModels.

●Validate and develop Meta Data for all developed reports in Microsoft Power BI Desktop.

●Used Azure Data Factory as an orchestration tool for integrating data from upstream to downstream systems, Involved in connecting multiple data sources in Power BI to implement working reports

●Automated various data extraction, transformation, and loading tasks with Python

●Involved in ETL, Data Integration and Migration.

●Analyzed Azure Data Factory (ADF) and Azure Data Bricks to build a new ETL process in Azure.

●Designed and developed Business Intelligence solutions using MSBI tools.

●Worked with import and direct query, creating custom table in the Power BI.

●Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.

●Worked on creating a File based Data lake using Azure Blob Storage, Azure Data Factory(ADF), Azure HDInsight, Developed analytics solutions by defining and translating business requirements into dashboard & reporting solutions and implementing them within Microsoft Power BI Desktop and visualizations.

●Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI, Worked on Azure Cloud technologies such as Azure Data Lake (ADL), Azure Data Explorer, BLOB Storage, HD Insight.

●Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements, Developed reports to visually explore data and create an interactive report Excel and Power BI.

●Worked on the reporting requirements and involved in generating the reports for the Data Model using crystal reports

●Created visualization reports and dashboards using Power BI desktop and published them to the Power BI Service, Used various data visualizations with Power BI.

●Involved in creating calculated columns, Measure in Power BI Desktop.

●Created reports utilizing Excel services, Power BI and deployed them on SharePoint Server as per business requirements.

●Migrated legacy ETL workflows from on-prem Oracle databases to Microsoft Fabric Lakehouse using Azure Dataflows Gen2, replacing traditional pipelines with modern, scalable solutions.

●Built end-to-end pipelines for extracting data from on-prem Oracle, performing data quality checks, transformations, and loading into Delta tables in the Fabric Lakehouse.

●Designed and implemented dataflows for key business dimensions and fact tables with transformations like joins, lookups, filters, conditional splits, and aggregations.

●Designed and developed Power BI dashboards for tracking claims processing efficiency, loss ratios, underwriting performance, and policy lapse trends.

●Created ADF pipelines to ingest and transform policy, premium, claims, agent, and reinsurance data from on-premise and cloud-based insurance systems.

●Built interactive visuals to monitor claims incurred vs. claims paid, average claim settlement time, and fraud detection metrics for the Claims department.

●Enabled actuarial and underwriting teams to perform retention analysis, risk segmentation, and premium pricing insights using advanced DAX measures in Power BI.

Environment: Power BI Desktop,Agile,SQL,Power Map, Power View, Business Objects, T-SQL, OLTP, Python, ETL, MS Excel,Azure Data factory

UnitedHealth Group - Minneapolis, MN Jan 2023 - June 2024 Senior Power BI Developer

Responsibilities:

●Created reports and dashboards using Power BI Pro.

●Made DAX queries in Power BI desktop.

●Conducted JAD sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them.

●Designed and implemented database solutions in Azure SQL Data Lakes, Azure SQL

●Designed and Developed Data Collectors and Parsers by using Python.

●Developed ETLs to pull data from various sources and transform it for reporting applications using PL/SQL, Primarily involved in Data Migration using SQL Azure, Azure storage, Azure Data Factory (ADF) and Azure Data Explorer.

●Created Crystal Reports with multiple drilldown and sub-reports.

●Performed data mining on Claims data using very complex SQL queries and discovered claims patterns, Designed security model of reporting system, creating groups, folders, and users in Business Objects.

●Performed in Power BI, and Power BI Pro.

●Developed pipelines to move the data from Azure blob storage to Azure SQL data warehouse and blob

●Installed and configured Power BI Gateways to keep the dashboards and reports refresh automatically.

●Designed the Data Marts in dimensional data modeling using star and snowflake schemas.

●Created Crystal Reports Repository objects (Reports template, commands)

●Configured Power BI enterprise data gateway for scheduled data refresh of Power BI datasets.

●Developed JSON Scripts for deploying the Pipeline in Azure Data Factory (ADF) that process the data using the SQL Activity, Load the processed data into final view point centralized DWH for further Power BI reporting.

●Developed custom calculated measures using DAX in Power BI to satisfy business needs.

●Used forward engineering approach for designing and creating databases for OLAP model

●Wrote T-SQL queries, Stored Procedures and used them to build packages.

●Migrated existing self-service reports and ad-hoc reports to Power BI.

●Worked on all types of transformations that are available in Power BI query editor.

●Created complex Custom Views using SQL Developer to create data sets for Power BI dashboards.

●Created Free-hand SQL and Ad-hoc reports in Crystal Report.

●Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis, Worked with Azure Blob Storage, Azure Data Lake, Azure Data Factory(ADF), Azure Analytics, Polybase, Azure HDInsight, Azure Databricks and Azure Data Explorer.

●Worked with dataset ingestion, data model creation, reports, dashboards, Power BI Pro features, Cloud, direct queries, and dax expressions.

●Identified the entities and relationship between the entities to develop Conceptual Model using ERWIN.

●Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

●Developed batch processing solutions by using Data Factory and Azure Data bricks

●Implemented Power BI PowerQuery to extract data from external sources and modify the data to generate the reports, Created the Crystal reports using Oracle tables and tested the reports by cross checking and verified data against the reports generated from the legacy system.

●Designed and built a Data Discovery Platform for a large system integrator using Azure HdInsight components, Designed and maintained reports in Power BI, built on top of Azure Synapse/Azure Data Warehouse.

●Created, Maintained & scheduled various reports in Power BI like Tabular Reports.

●Involved in creating dashboards and reports in Tableau.

●Expertise in designing and delivering interactive and paginated reports for operational and executive-level insurance reporting.

●Developed and deployed end-to-end SSRS reporting solutions to support policy administration, claims management, and financial oversight within the Property & Casualty insurance domain.

●Implemented data quality rules in ADF Data Flows to validate key insurance data attributes such as policy effective dates, sum insured, claim amount, policyholder demographics, and agent details.

●Designed Power BI reports to analyze persistency and renewal ratios, policy cancellations, and grace period trends across Life and Health insurance portfolios.

Environment: Power BI Pro, SDLC, Azure, SQL, Python, PL/SQL, Crystal Reports, MS Excel, OLAP, T-SQL, Oracle, Azure Data Bricks, Tableau.

CareFirst - Baltimore, MD Dec 2020 – Dec 2022

Power BI Developer Responsibilities:

●Managed relationship between tables in Power BI using star schema.

●Created different Power BI reports utilizing the desktop and the online service and schedule refresh.

●Created Power BI reports and dashboards on OLAP and relational db.

●Wrote SQL Stored Procedures and Views, and coordinate and perform in-depth testing of new and existing systems.

●Developed the logical data models and physical data models that capture current state/future state data elements and data flows using ER/ Studio.

●Participated in UAT sessions to educate the business users about the reports, dashboards and the BI System, Developed SQL Joins, SQL queries, tuned SQL, views, test tables, scripts in development environment.

●Created Power BI Reports using the Tabular SSAS and SSIS models as source data in Power BI desktop and published reports to service.

●Used SQL extensively in command objects of Crystal reports

●Used data analysis techniques to validate business rules and identify low quality missing data in the existing Amgen enterprise data warehouse (EDW).

●Used different types of slicers available in Power BI for creating reports.

●Configured Power BI Report Server for SSRS deployed and scheduled reports in Report Manager.

●Involved in database development by creating Oracle PL/SQL Functions, Procedures and Collections.

●Used data profiling tools and techniques to ensure data quality for data requirements.

●Involved in Data mapping specifications to create and execute detailed system test plans.

●Worked with developers on the database design and schema optimization and other DB2 aspects.

●Implemented Data security (Row level security (RLS)) on Dataset and Reports in Power BI.

●Involved in installation of Power BI Report Server.

●Actively involved in Normalization & De - normalization of database.

●Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports

●Created SSIS package to extract data from OLTP to OLAP and scheduled jobs to call the packages and stored procedures.

●Worked on the reporting requirements and involved in generating the reports for the Data Model using crystal reports, Involved in Developing PowerBI Reports and Dashboards from multiple data sources using Data Blending.

●Created Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate results for the reports, Effectively used data blending feature in tableau.

●Used Microsoft Excel tools like pivot tables, graphs, charts, solver to perform quantitative analysis.

●Scheduled report subscriptions and data-driven alerts for business users and leadership teams.

●Implemented row-level security on the SSRS server based on role-based access controls.

●Integrated SSRS reports with Excel and Power BI for dynamic reporting options.

●Created parameterized ADF ETL pipelines to ingest data from on-premises flat files to snowflake using key vaults connection and linked service.

Environment: Power BI Report Server, ER/Studio, Oracle, SQL, Power BI, Tableau, T-SQL, DB2, MS Excel, Crystal Reposts, OLAP, OLTP, UAT.

Bank of America - Charlotte, NC Feb 2019 - Nov 2020

BI Developer Responsibilities:

●Designed and developed interactive and visually appealing Power BI dashboards, showcasing key performance indicators and trends derived from Snowflake data.

●Designed and Developing the Dashboard Reports in power BI using DAX

●Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).

●Setup/Configure Integration Runtime for Azure Data Factory, Enable SSIS DB for Management Instance in Azure.

●Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

●Developing the reports using Power BI, Power Pivot and SSRS.

●Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS

●Deployed SSIS packages and Reports to Production Servers.

●Involved in creation of Data warehouse Cubes in SQL Server Analysis Service (SSAS).

●Migrated data using ETL Tool in SSIS.

●Created notifications and alerts, subscriptions to reports in the Power BI service

●Created Relationships, Actions, Data Blending, Filters, Parameters, and Hierarchies, Calculated fields, Sorting, Grouping, Live connections and in-memory in both Tableau and Excel.

●Maintained system monitoring jobs and provided high availability support.

●Created, Maintained & scheduled various reports in Power BI Reports.

●Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).

●Participated in Database Architecture and data modeling design.

●Developed stored procedures in SQL Server to standardize DML transactions such as insert, update and delete from the database, Utilized Power Query and Power Pivot to transform and model Snowflake data, ensuring accuracy and relevance in reporting.

●Created reports in Power BI by importing data, shaped and transformed data for business intelligence (BI).

●Generated Visualize data, author reports, scheduled automated refresh of reports and created and share dashboards based on reports in Power BI desktop.

●Reported all events and requirements through established reporting mechanisms in SSRS.

●Reviewed and developed data models and database designs with development teams

●Wrote store procedures for some job automations.

●Fine Tuning SQL to improve performance of report and extraction times of data extract.

●Provided support for Tableau developed objects and sound understanding of the tool administration.

●Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.

●Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.

Environment: Power BI, MS SQL Server, T-SQL, Snowflake, Agile.

Education

Masters at University of Webster Universit

Contact this candidate