Sirisha Bhargavi Jakkampudi

Senior Analyst (Power BI Developer & Admin)

Accenture

07.2022 - Current

Designed and developed advanced Power BI dashboards and reports for various business units.
Hands-on experience using Power Query to perform data cleaning, transformation, and shaping from multiple data sources to create efficient data models for reporting in Power BI.
Involved in a migration project from Spotfire to Power BI, where I contributed to replicating dashboards, ensuring data accuracy, and optimizing report performance in the new environment.
Collaborate with Stakeholders to gather and understand business requirements.
Implement data models, measure, KPIs and calculated columns using DAX and Power Query.
Optimize dashboards for performance and usability.
Integrate Power BI with various data sources (SQL, Excel, Snowflake, SharePoint etc.)
Ensure data accuracy, consistency and Security compliance.
Administered Power BI Service including workspaces, capacities, user roles, and gateway configurations.
Troubleshoot and optimized dataset refresh issues and incremental refresh configurations.
Involved in Migration project from Spotfire tool to Power BI
Developed multiple Power BI reports with different data sources
Collaborated with business users to understand requirements and deliver solutions.
Monitored Power BI performance and usage metrics, optimizing dashboard/report performance and proactively addressing issues to ensure high availability.
Installing, configured and maintained Power BI gateways, ensuring smooth data connectivity across on-premises and cloud data sources.
Extremely adept at working on ServiceNow, handling CTASK, service requests, and incidents without violating SLAs.
Pro-actively worked on gateway monitoring and regularly monitor the gateway report’s, log files and spooling folder and created a report to monitor gateway performance and refreshes for each gateway cluster.
Deployment: Raised a change request (CRQ) for deploying the changes to production. Once got approvals from Technical advisory board (TAB) and change advisory board (CAB), Deployment of Power BI Datasets and Reports from Development Environment to Test and then to production in deployment timeline window.
Pro-actively worked on gateway and capacity monitoring and noticed the datasets which are causing issues for gateways.
Experienced in configuring and maintaining Power BI Service (app.powerbi.com) for content sharing and managing the premium capacity of Power BI Service.
Involved in resolving problem tickets by performing root cause analysis for a permanent fix, document for future reference and provided a workaround if it is Product related issue and perform pre- and post-checks for the servers during upgrades/patching.
Participating in the resolution of platform (Power BI) related issues and access-related activities including workplace access, report access and including app level access via Azure AD group.
Worked on connecting multiple data sources to power bi including (Dataverse, ODBC, SQL Server, Oracle. etc) and having good knowledge on authentication methods for each data source.
Experience on creating new gateway Data Source Name (DSN) under the gateways to carry out the scheduled refresh.
Promoting workspaces to premium capacities and monitoring the capacity usage and to identify datasets impacting capacities.
Pinpointed and fixed performance bottlenecks in Power BI reports, optimizing DAX queries and reducing report load times by 40%, enhancing the end-user experience across various platforms.
Created multiple KB articles to reduce the ticket count and providing guidance for users.
Refined scalable data models, integrating structured and unstructured data, resulting in improvement in data processing speed and delivering real-time, actionable insights.
Scheduling weekly calls with Power BI developer to guide them best practices for developing a good data model and accessing the enterprise gateway and training to business user’s on how to user Power BI dashboards and self-service capabilities.
Set up Power BI subscription, applying incremental refresh to business users with pre- defined filter’s according to requirements.

Summary

Overview

Work History

Senior Analyst (Power BI Developer & Admin)

Power BI Developer

Education

M.Tech - Embedded Systems

Skills

Certification

Accomplishments

Timeline

Senior Analyst (Power BI Developer & Admin)

Power BI Developer

M.Tech - Embedded Systems

Similar Profiles

John Jethro E. GanzonJohn Jethro E. Ganzon

Prerana JadhavPrerana Jadhav

Ritika RaoRitika Rao

Jimmy HernandezJimmy Hernandez

Anil Kumar SawAnil Kumar Saw