Akhila Durgapathi
Tampa,FL
Summary
Power BI Developer with 6 years of experience in creating dynamic dashboards and reports, enhancing business insights across healthcare, insurance, and finance sectors. Expert in leveraging DAX functions and Power Query Editor for data transformation and modeling, ensuring optimized performance and decision-making. Skilled in integrating Power BI with existing systems and utilizing advanced features like Power BI Embedded and Power Automate to streamline workflows and improve user engagement.
Overview
6
6
years of professional experience
Work History
Power BI Developer
Cognitive Minds Inc
06.2022 - Current
- Develop Power BI reports from diverse data sources, enhancing data insights and decision-making
- Create interactive dashboards in Tableau, boosting user engagement and analytical capabilities
- Experience in Deploying and Monitoring ETL packages in SQL Server by job scheduling the flow of packages from Development Server to Test and Production Server.
- Proficient in optimizing SQL queries, performance tuning using SQL Profiler as well as understanding execution plans.
- Enhance Cognos reports, improving performance and user experience with interactive elements.
- Expert in generating reports using SQL Server Reporting Services (SSRS).
- Proficient in SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.
- Implement Row Level Security, ensuring data access aligns with user roles and permissions
- Troubleshoot data issues, maintaining high data quality and integrity across platforms
- Developed dynamic Power BI dashboards to streamline data visualization, leading to enhanced decision-making and operational efficiency
- Experienced in creating various reports like Tabular, Matrix, Drill down, Drill-through, Parameterized, Cascading, Conditional, Chart, Sub Reports and Deploying Reports in report server.
- Developed SQL queries for data extraction, analysis and reporting.
- Strong Knowledge in Data Analytics tools such as Power BI, Tableau etc.
- Worked in all the products in Power BI such as Power BI Pro, Embeded, Premium, and Power BI Mobile.
- Experience in Cube designing in BI Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
- Experience in creating different types of Complex Reports using SSRS.
- Collaborated with cross-functional teams to refine data strategies using Power BI, improving data accessibility and stakeholder engagement
- Implemented advanced DAX measures in Power BI, resulting in more accurate insights and improved data-driven decision-making processes
- Pioneered the integration of Power BI with existing data systems, optimizing reporting workflows and boosting analytical capabilities
- Ensured high data integrity by troubleshooting Power BI reports, maintaining accuracy and reliability in organizational data usage
- Partnered with IT teams to integrate new data sources, expanding analytics capabilities and supporting data-driven decisions
Power BI Developer
COE Software Technologies PVT LTD
09.2018 - 06.2021
- Created relationships between tables to develop tabular and multidimensional data models
- Extracted data from Excel, JSON, and databases like MySQL, and SharePoint lists
- Used DAX to create KPI's and custom calculations to automate data manipulation making it easy for stakeholders to comprehend and achieve business objectives
- Created different types of reports using Power BI desktop, like vertical and cross tab reports and dashboards
- Created Slicers and Filters in Power BI
- Working with gateways and scheduling the refresh and creating reports and dashboards
- Modified and maintained dashboards to provide real-time insights to users by selecting the appropriate visual, designing the layout, and updating the data behind the dashboards
- Troubleshoot and debug any data issues or errors that may occur during the data transformation process
- Developed data reconciliation SQL queries to validate the overall data migration
- Participated in the configuration of an on-premise Power BI gateway to refresh datasets of reports and dashboards to keep it up to date
- Scheduling the Dashboards to notify users if the underlying data in dashboard was changed
Education
Master's - Information Science
University of North Texas
Denton, TX12.2022
Bachelor's - Dental Surgery
Dr. NTRUHS
Vijayawada, Andhra Pradesh01.2018
Skills
- Power BI
- SQL
- DAX
- SSRS
- SSIS
- Tableau
- ETL
- OLAP
- Informatica
- SDLC
Timeline
Power BI Developer
Cognitive Minds Inc
06.2022 - Current
Power BI Developer
COE Software Technologies PVT LTD
09.2018 - 06.2021
Bachelor's - Dental Surgery
Dr. NTRUHS
Master's - Information Science
University of North Texas