Power Bi Business Intelligence

Muralidhar Reddy Bovilla

Chicago, IL +(1-315-***-**** **************@*****.*** https://linkedin.com/in/muralidhar-reddy-bovilla-b89131269

PROFILE SUMMARY

Highly motivated and dedicated Information Technology profession with 12 years of experience in Business Intelligence, Data Warehousing, Azure Data Lake, Azure SQL Database and Google Cloud environments.

Experienced working with business leaders to identify business requirements, key performance metrics, developing business insights and data analytics.

Strong experience in developing reports, data visualization, interactive dashboards, KPI scorecards, UI/UX design using Power BI, Power BI Report Builder, Tableau, SSRS, IBM Cognos, SAP Business Objects, SAP Crystal Reports and SAS.

Experienced in developing data model, semantic layer using Power BI, SSAS by integrating data from different sources systems and created calculated measure using DAX queries and implemented Row Level Security (RLS) to restrict data.

Extensive experience in Power BI Administration includes managing workspaces, datasets, dataflows, reports, dashboards, setting up gateway, scheduled report refresh, creating apps, providing access permission to end users using Power BI Service.

Experienced in design, develop and implementation of ETL/ELT using Azure Synapse, Azure Data Factory, SSIS and Data Stage.

Hands-on experience designing solutions using Microsoft Fabric, blending modern data engineering with business intelligence.

Strong experience in coding SQL, PL/SQL, T-SQL to analyze data and create database objects like tables, views, stored procedures and schema using Azure SQL Database, MS SQL Server, Oracle and Salesforce.

Strong experience in developing canvas, portals using Power Apps and integrated Power BI reports into portal using Power Page.

Strong experience in designing and implementation of cloud flows, desktop flows and automate the flow using Power Automate.

I have strong experience in Agile methodology process story refinement, sprint planning and product demo to customers.

Strong analytical, problem solving, communication skills and quickly identifying future potential issues or roadblocks.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Shell Scripts, Python.

Reporting/Data Analytics: Power BI, Power Apps, Power Automate, Power Pages, Power BI Report Builder, Tableau, SSRS, IBM Cognos, SAP Business Objects, SAP Crystal Reports, SAS.

ETL/ELT Technologies: Azure Data Factory, Azure Synapse Analytics, SSIS, Data Stage

Could/Database: Azure Cloud, Azure SQL Data Warehouse, Azure Data Lakes, Microsoft Fabric, Google Cloud, GCP Big Query, GCP Data Lake, GCP Data Lakehouse.

Other Tools: Microsoft 365, Share Points, One Drive, Microsoft Forms, Azure DevOps, TFS, GIT

PROFESSIONAL EXPERIENCE

Conagra Brands, Chicago, IL. August 2024 - till date

Power BI Architect

Environment: Power BI, Power Query, M Query, Power BI Service, Power BI Desktop, Microsoft Fabric, Azure Synapse Analytics, Azure SQL Database, Azure Blob Storage, Azure DevOps, TFS, GIT, SQL, PL/SQL, T-SQL, SSMS, Power Apps, Power Automate, Agile Methodology.

Designed and developed scalable Snowflake data pipelines using Snow SQL, Tasks, and Streams to support real-time supply chain and batch data ingestion from sources including cloud storage and APIs.

Spearheaded the migration of legacy databases to optimized architecture in Azure Databricks, achieving sub-second query performance during peak load; leveraged Azure Notebooks for collaborative analytics development and integrated workflows across five systems, eliminating 50+ hours of manual work monthly.

Built and deployed data pipelines using Microsoft Fabric, utilizing One Lake and Lakehouse architecture to centralize structured/unstructured data, and integrated Fabric Dataflows Gen2 with Power BI and Synapse for end-to-end BI solutions.

Implemented CI/CD pipelines via Azure DevOps to automate deployment of Azure Data Factory and database updates; optimized workflows for MES and Infor Visual ERP integration, reducing manual intervention and enhancing system connectivity.

Engineered scalable reporting by configuring Power BI Gateways, automating refresh schedules, and launching 10 interactive dashboards with DAX; conducted Power BI migration analysis, resolving performance bottlenecks and improving dashboard accessibility.

Created custom calculated measures using DAX, utilized Python scripts and M functions in Power BI for advanced transformation and automation, and engineered paginated reports with structured layouts that resolved user pain points.

Represented data through cross tabs, scatter plots, maps, pie charts, bar charts, gauges, and funnels in Power BI; modeled dimensions and facts to support effective data analysis across multiple domains.

Designed interactive reports using Power ON with real-time data entry, planning, and write-back; configured and optimized write-back for scenario planning and budgeting directly in Power BI visualizations.

Developed applications using Power Apps and executed over 15 automated workflows in Power Automate for SharePoint-integrated migration announcements, reducing manual effort by two hours per project.

Modeled complex datasets using Analysis Services with advanced hierarchies and perspectives; designed star schema and snowflake data models to support high-performance analytics, reducing reporting time by 40%. Enforced RLS and encryption via Active Directory and collaborated on Microsoft Fabric governance and security best practices.

Collaborated with data scientists to integrate Python-based machine learning scripts within Power BI reports for anomaly detection in supply chain metrics, enabling proactive decision-making and reducing issue resolution time by 30%.

BDP International (PSA BDP). Noida, India. March 2020 - January 2023

Power BI Architect

Environment: Power BI, Power Query, M Query, Power BI Service, Power BI Desktop, Azure Synapse Analytics, Azure SQL Database, Azure Blob Storage, Azure DevOps, TFS, GIT, SQL, PL/SQL, T-SQL, SSMS, Power Apps, Power Automate, Agile Methodology.

Led the team in gathering requirements, documenting user stories, sprint planning, retrospectives, and delivering product demos to stakeholders; managed scope, deliverables, and risks to ensure timely, scalable, and secure BI solutions.

Designed and developed data models and semantic layers by integrating data from multiple source systems into Power BI datasets using Power Query, enabled reusability of clean data across reports.

Developed reports and dashboards in Power BI Desktop using shared datasets and external sources; created DAX measures, modified M queries, and implemented RLS for secure access to supply chain and logistics data.

Managed end-to-end Power BI Service deployment, including publishing reports, configuring gateways, RLS, refresh schedules, workspaces, apps, and user access.

Partnered with data engineering and ML teams to define KPIs and data readiness for predictive analytics models in logistics forecasting, improving shipment accuracy by 15% through actionable dashboard integration.

Created test cases and plans; validated report design, functionality, formatting, and data accuracy to ensure reports deliver correct insights.

Expert in T-SQL, stored procedures, views, and table creation; deployed database objects across DEV, UAT, and PROD environments, validating data integrity and ensuring a single source of truth.

Designed, developed, and maintained ETL/ELT pipelines using Azure Synapse and Azure services; integrated Snowflake with Airflow and ADF to automate pipeline execution with alert mechanisms for failure handling.

Created Snowflake data models using star and snowflake schemas to support high-performance analytics; implemented RBAC and masked policies to enforce data security and compliance.

Optimized and managed data storage using Azure SQL Database and Azure Blob Storage; monitored and troubleshot data workflows to ensure consistent performance.

Developed Power Apps and Power Automate solutions to streamline logistics workflows like shipment tracking and order processing, integrating with SharePoint and Power Pages; saved 30+ hours monthly and improved user adoption across 200+ logistics staff.

Right ship. Hyderabad, India. March 2018 - February 2020

Power BI Lead

Environment: Power BI, Power Query, M Query, Power BI Service, Power BI Desktop, Azure Synapse Analytics, Azure SQL Database, Azure Blob Storage, Azure DevOps, TFS, GIT, SQL, PL/SQL, T-SQL, SSMS, Power Apps, Power Automate, Agile Methodology.

Gathered input from finance and operations to define a comprehensive business requirement framework aligned with deliverables; conducted evaluations of existing reports to close requirement gaps, improving data relevancy by 30% using user feedback.

Constructed robust SQL scripts for seamless data transfer across 20+ tables; created and optimized stored procedures, user-defined functions, and views using execution plans, logs, SQL Profiler, and Database Engine Tuning Advisor.

Performed data profiling and verification in pre-staging environments using SQL stored procedures, ensuring data quality for real-time financial reporting.

Developed and deployed SSIS ETL packages and backend processes to maintain system integration and populate new Data Marts, supporting end-to-end data pipeline execution.

Formulated granular access controls to safeguard sensitive information across three departments, resulting in zero security breaches during annual audits.

Designed interactive Power BI dashboards using KPIs, advanced charting, filtering, and OLAP analysis; leveraged Power Query for seamless integration between disparate data sources.

Created report and page-level filters in Power BI Desktop and implemented advanced DAX measures and calculated columns to support role-based security across 10 datasets.

Published comprehensive Power BI reports with advanced visualizations on the Power BI Service; integrated data gateways for real-time synchronization, achieving 95% uptime and enabling immediate business insights.

Streamlined data integration from three major platforms using advanced Power BI queries; reduced key metric update cycles from hourly to near real-time.

Led migration of legacy reporting systems to Power BI and Azure cloud, planning roadmaps and deliverables; improved report generation time by 60% and increased user engagement by over 40% through enhanced self-service analytics.

Genpact. Gurgaon, India. February 2017 - February 2018

Power BI Developer

Environment: SQL Server 2016, SSDT, T-SQL, ETL, SSIS, SQL Profiler, Erwin, SSMS, Power BI Desktop, PBI Gateways.

Determined operational objectives by studying business rules, gathering information, evaluating output, and clarifying requirements and formats.

Engaged daily with team members to decode challenging requirement sets while swiftly clarifying upwards of 35+ questions from developers every week, enhancing overall productivity during critical phases and achieving smoother transition milestones within projects.

Developed complex T-SQL queries and stored procedures for the purposes of moving and maintaining data and to run reports based on MS SQL Server.

Optimized queries by evaluating execution plans, creating indexes/table partitions, SQL profiler and DTA.

Loaded data from flat data files into SQL Server database tables utilizing bulk insert and SSIS.

Mapped the source, destination, staging area per ETL strategy and performed data cleansing and data profiling.

Analyzed user feedback to shape visualization choices on dashboards, ensuring relevance across departments, and identified three critical areas causing delays and inefficiencies, which were subsequently addressed.

Configured alert systems within Power BI that promptly notified stakeholders of data anomalies; this feature led to quicker decision-making times averaging a decrease of 15 hours per month.

Leveraged Power BI gateway to synchronize dashboards and reports with on-premises data sources, ensuring real-time updates that enhanced decision-making capabilities across finance operations for over 200 stakeholders.

Established real-time monitoring systems within Power BI services that flagged threshold breaches automatically; reduced response times per incident while ensuring data accuracy maintained at a high level.

Maintained synchronization between published reports and dataset using Power BI gateway.

Transformed reporting capabilities using advanced features like bookmark navigation within Power BI desktop that allowed users to access 4 distinct views swiftly without navigating away from the main interface.

Configured Power BI gateway to keep dashboards and reports up to date with on-premises data sources.

Defined security policies for Power BI reports, linked reports, folders, resources, and data sources.

AAA Insurance. Pune, India. April 2016 - December 2016

Power BI Developer

Environment: SQL Server 2016, SSDT, T-SQL, ETL, SSIS, SQL Profiler, Erwin, SSMS, Power BI Desktop, PBI Gateways.

Extracted data from SQL Servers, Azure, excel sheet, flat files, CSV files.

Facilitated daily team collaboration sessions where findings identified user interface challenges within existing applications that directly contributed towards refining analytics visualization strategies for end users.

Published Power BI Reports in the Power App and Made Power BI Dashboards available in Power BI Service.

Deployed efficient code within existing frameworks utilizing VBA functions alongside SQL queries embedded into the environment; this resulted directly in saving two hours daily on routine data extraction processes.

Formed Row level security with Power BI and integration with Power BI Service Portal

Established a schedule for data refresh in data sources on Power BI service by configuring enterprise data Gateway.

Generated detailed analytical dashboards within Power BI using custom DAX expressions to automate reporting; saved an average of 10 hours per week on manual report generation for the finance team.

Wrote complex DAX expressions to generate calculated columns and filters for role-based security.

Administered Power BI gateways by connecting datasets and updated the gateway with missing data sources.

Compiled a comprehensive content pack that segmented datasets and reports for five departments, ensuring improved data distribution and reducing information overload by streamlining access to relevant dashboards.

Processed focus sessions with diverse stakeholders to extract critical functional specifications; synthesized findings to pinpoint the top three desired capabilities leading to a more optimized development approach for future updates.

Scripted complex T-SQL queries to analyze and retrieve data from large databases, leading to a 30% reduction in report generation time while enhancing the accuracy of insights provided for business decision-making.

Vodafone India. Pune, India. December 2014 - March 2016

Cognos/Power BI Developer

Environment: SQL Server 2014, SSDT, T-SQL, SQL Profiler, SSMS, SSDT, Cognos, Power BI.

Collaborated with business users to gather and refine key database application requirements, leading to improvement in user satisfaction scores based on post-implementation feedback surveys from stakeholders.

Designed stored procedures, functions, database triggers, and complicated business logic while maintaining referential integrity.

Crafted intricate T-SQL scripts and refined stored procedures for the reporting module on MS SQL, resulting in a streamlined data retrieval process that improved report generation efficiency for stakeholders.

Developed a Power BI dashboard including advanced charting and filtering to enable bifurcated data visualization according to requirement for different analysis.

Created report/page level filter in Power BI Desktop to visualize data according to requirement for analysis.

Executed advanced data transformation techniques within Power Query, delivering actionable insights that enhanced reporting capabilities by streamlining complex queries and increasing the number of accessible metrics.

Transformed disparate datasets into actionable insights using Power Query and Mashup codes in Power BI, driving a 50% increase in data accessibility for end-users across three departments within six months.

Created role-based security in Power BI data models using DAX filters.

Designed visualization solutions with business requirement documents and plans for creating interactive dashboards.

Troubleshoot performance related issues within Power BI reports and gateways.

Installed Cognos Framework Manager to develop model and implement security in Cognos administration.

Created Framework Manager Model for creating packages using DMR and Relation models.

Transformed raw data into actionable intelligence by deploying cross tabs, scatter plots, pie charts, and maps; collaborated closely with stakeholders to address three major reporting challenges faced during analysis.

Represented data using crosstabs, scatter plots, maps, pie charts, bar charts, maps, gauge, and funnel in Cognos.

American Express. Pune, India. October 2011 - November 2014 Tableau/Cognos Developer

Environment: SQL Server 2014/2012 SSDT, T-SQL, SQL Profiler, Erwin, SSMS, Cognos, Tableau, TFS.

Identified, formulated, and documented detailed business rules and use cases based on requirements analysis.

Maintained referential, domain and entity integrity across database tables utilizing constraints in SQL.

Implemented error handing techniques such as 'Try Catch' to create robust T-SQL code.

Encapsulated frequently executed SQL statements into stored procedures to reduce query execution times.

Performed root cause analysis on failures and resolved performance tuning issues on queries with SQL profiler and DTA.

Executed comprehensive reporting solutions in Cognos Report Studio that showcased key performance indicators, resulting in a 30% increase in stakeholder understanding of business metrics and trends across departments.

Mastered a List and Crosstab reports, Calculations, Conditions, Prompts based on the Business requirements.

Formulated advanced conditions and blocking functions for reports that decreased report generation time by 30 minutes each week; simplified complex data sets into actionable insights benefiting stakeholders.

Created Drill Through between Parent (Summary) and Child (Detail) Reports.

Developed and published the Cognos models to Cognos Server to create highly informative dashboards.

Engineered visually compelling reports in Cognos with advanced features such as slicers and gauges, resulting in a streamlined user experience while reducing report extraction time for query.

EDUCATION DETAILS

Utica University, Utica, NY, USA. Jan 2023 - May 2024

Master’s in Business Analytics specialized in Business Analytics and Data Science.

Osmania University, Hyderabad, TG, India Aug 2007 - Jun 2009

Master’s in Business Administration specialized in Finance and Human Relations.

Sri Venkateswara University, Tirupati, AP, India Jun 2004 - Jun 2007

Bachelor of Science.

Contact this candidate