Power Bi Business Intelligence

.

Sravani Kumari

Sr.PowerBI Developer

210-***-**** ***********@*****.***

PROFESSIONAL SUMMARY:

Having around 6+ years of experience in the IT industry, specializing in Data Warehouse, Business Intelligence, and Databases, using the Microsoft Business Intelligence suite.

Expertise in creating visually appealing dashboards in Power BI, utilizing a combination of interactive visuals, color schemes, layout design, and data storytelling techniques.

Proficient in creating various visualizations using Power BI, such as slicers, line chart, pie chart, histograms, scatter plots, bullet chart, heat maps, and tree maps.

Proficient in creating DAX measures to perform complex calculations, aggregations, and data analysis in Power BI reports and dashboards.

Good experience in designing dimensional data models using Star and Snowflake schemas to support efficient reporting and analysis in Power BI.

Experienced in automating ETL processes using Azure Data Factory (ADF), significantly reducing data preparation time and ensuring consistent, high-quality data for reporting.

Hands-on experience in developing complex data models in Snowflake to support advanced analytics, reporting, and business insights.

Experienced in utilizing Azure SQL's advanced features to ensure secure and efficient management of large datasets.

Hands-on experience with SSIS for extracting, transforming, and loading data from various sources (SQL Server, flat files, APIs, etc.) into databases.

Extensive working experience in relational database management systems (RDBMS) including Oracle, DB2, PostgreSQL, Redis, and MS SQL Server.

Expertise in utilizing database tools such as SQL Developer, TOAD, and IBM Data Studio for database development, administration, and optimization.

Proficient in developing stored procedures, views, triggers, and complex queries, as well as T-SQL programming, query optimization, and performance tuning on SQL Server.

TECHNICAL SKILLS:

Reporting Tools : Power BI Desktop, Power BI Service, Power BI Gateway, Tableau, Snowflake, QlikSense, QlikView, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

ETL Tools : SQL Server Integration Services (SSIS), Informatica, Azure Data Factory

Modeling & IDE : MS Visio, SSMS, Power Pivot, Power Query, TOAD, SQL Developer

Databases : MS SQL Server, Oracle, PostgreSQL

Operating Systems : Windows, UNIX

Scripting/Languages : SQL, PL/SQL, T-SQL, Python, HTML, Unix Shell Scripting

Other Tools : Oracle SQL Developer, MS Office, FTP, Teradata Viewpoint, Control-M, MS Access, Excel, Rally, JSON, JIRA, Git, Azure DevOps

PROFESSIONAL EXPERIENCE:

Cigna Healthcare, Dallas, TX May 2023 – Present

SSIS/Power BI Developer

Responsibilities:

Designed and developed interactive dashboards and reports using Power BI, addressing various business needs and requirements.

Created different data visualizations using line chart, pie chart, histograms, maps, scatter chart, and bullet chart using Power BI.

Designed and implemented complex data models to support business analytics and reporting requirements.

Designed and developed SSIS packages for ETL operations, integrating data from multiple sources including flat files, APIs, and databases.

Developed complex, parameterized reports using SQL Server Reporting Services (SSRS) for financial and operational dashboards.

Worked with DAX expressions to create new measures and calculations as per business requirements.

Extensively used data blending, filters, actions, and hierarchies features in Power BI.

Designed Star schema and Snowflake schema models to optimize query performance and support efficient reporting.

Wrote and optimized DAX and MDX queries to enable advanced data slicing, filtering, and time intelligence in Power BI and SSAS.

Implemented row-level security (RLS) and role-based access control (RBAC) in Power BI to ensure data confidentiality and compliance with regulatory requirements.

Integrated custom .NET code within SSIS Script Tasks and Script Components to extend ETL functionality and handle specialized logic.

Built and maintained administrative dashboards to monitor capacity usage, user activity, workspace health, and department-level metrics.

Worked on the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.

Designed and implemented multidimensional and tabular models using SQL Server Analysis Services (SSAS) to support OLAP cubes.

Automated data synchronization pipelines in Azure Data Factory to integrate data between Azure SQL Database, Azure Blob Storage, and SQL Server.

Implemented GPG encryption and automated secure data transfers using the SFTP protocol to meet data privacy and compliance standards.

Utilized GitHub for version control, including branching, merging, and pull requests, to manage SSIS, SSRS, and SSAS projects

Built Python scripts within Microsoft Fabric notebooks for large-scale data processing in lakehouse environments.

Developed complex data models in Snowflake to support advanced analytics, reporting, and business insights.

Published the developed dashboards and reports on the Power BI Service for end-user access across the organization.

Conducted performance tuning of Power BI reports to optimize load times and improve user satisfaction.

Environment: Power BI Desktop, Microsoft Fabric, Power Apps, Power BI Service, Snowflake, Azure SQL Database, Azure Data Factory, Power Query, SSIS, T-SQL, DAX, Azure, Excel.

UPS, Chicago, IL Jan 2022 – May 2023

Power BI Developer

Responsibilities:

Designed and developed interactive Power BI dashboards for financial reporting, enabling real-time insights into portfolio performance, risk management, and financial metrics.

Collaborated with business and IT teams to define data governance policies, ensuring accurate financial data reporting.

Developed Power BI reports by connecting to Snowflake and SharePoint sources, transforming raw data into actionable insights.

Developed and optimized ETL processes using Azure Data Factory to extract, transform, and load data from ERP systems into Power BI, ensuring data consistency and high-quality reporting.

Migrated legacy Cognos reports to Power BI and improved user experience by reducing report load times.

Worked on the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards, ensuring real-time access to critical financial data.

Migrated reports from Tableau to Power BI by checking compatibility, verifying data sources and connectors, and setting up database connections to SQL Server and Oracle.

Used Python scripts to perform data transformations and calculations before loading the data into Power BI.

Automated data refreshes, report generation, and loading processes using Power BI REST APIs.

Implemented best practices for handling large datasets, reducing data load report refresh times.

Developed interactive Power BI dashboards for sales, inventory, and customer analysis, improving business performance and operational efficiency.

Collaborated with cross-functional teams to gather the requirements and translating them into actionable reports for leadership and operations teams.

Created data visualizations using slicers, line charts, pie charts, heat maps, and tree maps to present sales trends, inventory status, and customer demographics.

Designed and implemented complex data models using Star and Snowflake schemas for reporting and analysis of sales and inventory data.

Designed dataflows and pipelines within the Power Platform ecosystem, ensuring seamless data refreshes and integrity across multiple sources.

Utilized DAX measures to perform complex calculations and aggregations for performance metrics like sales growth, product performance, and regional analysis.

Developed Power Apps applications to improve internal workflows, integrating Power BI data to make decisions in real time and simplify data collection.

Used Power Automate to automate tasks like inventory tracking and sales reporting, improving efficiency across teams.

Migrated legacy manual processes Power Platform, improving data accuracy and reducing reporting time by 70%.

Published the developed dashboards and reports on the Power BI Service for end-user access across the organization.

Environment: Power BI Desktop, Power BI Service, Azure SQL Database, Tableau, Azure Data Factory, Power Automate, Power Query, SSIS, T-SQL, DAX, Azure, Excel.

Bank of America, Richardson, TX Apr 2019 – Dec 2021

Power BI Developer

Responsibilities:

Designed and developed Power BI dashboards and reports to meet business requirements and enhance data visualization.

Collaborated with IT and business teams to define data governance policies and procedures, ensuring data quality and consistency across the organization.

Utilized Power Query Editor for data cleansing, transformation, and manipulation tasks prior to loading data into Power BI.

Developed complex data models, integrating data from multiple sources including SQL Server, Oracle, and cloud-based APIs.

Created and optimized data pipelines, data flows, and triggers in Azure Data Factory to automate data movement and transformation tasks.

Designed and optimized DAX measures to transform raw data into actionable insights for various departments, including sales, finance, and operations.

Developed and implemented OLAP cubes to efficiently aggregate and analyze large datasets, enabling key insights and trends for enhanced decision-making.

Developed ETL processes to extract, transform, and load data from various sources into Power BI.

Worked closely with data engineers to streamline ETL processes and improve data quality.

Managed and optimized nightly and weekly data load processes by configuring automated job tasks, ensuring smooth execution and on-time completion.

Designed and developed interactive Power BI reports and dashboards for finance, marketing, and operations teams.

Developed complex DAX measures and calculations, improving decision-making by providing real-time insights into sales, marketing, and finance data.

Utilized DAX functions like GROUPBY, SUMMARIZE, and CALCULATE in Power BI to analyze customer data, enabling effective segmentation of subscribers based on demographics and usage patterns.

Integrated data from multiple sources, including SQL Server, SAP BW, Oracle, and Excel into a unified data warehouse model.

Used SSIS to extract, transform, and load data from multiple sources into data warehouses, enhancing the performance of Power BI dashboards and reports.

Developed Power BI reports that delivered actionable insights into key performance indicators (KPIs), including subscriber growth, churn rates, network performance, and revenue generation.

Created custom visuals and templates to standardize reporting formats and enhance user experience.

Optimized ETL processes using SQL Server Integration Services (SSIS) for improved data loading and transformation.

Streamlined data collection processes using Power Query and DAX and scheduled automatic data refreshes in Power BI Service.

Published and shared Power BI reports and dashboards through Power BI Service, ensuring seamless access and real-time insights for stakeholders across departments.

Environment: Power BI Desktop, Power BI Service, SSIS, T-SQL, DAX, SQL Server, Oracle, Azure Data Factory, Excel, API, Power Query, Excel.

Contact this candidate