Power Bi Business Intelligence
Resume:
Sreelatha Mudigondla
********@*******.***
SUMMARY
Around 8 years of IT experience in Database Design, Development and business intelligence of Microsoft SQL Server, Power BI, Tableau, SSIS, SSRS with various business domains like Health, Technology, Education domains.
Worked with .net team in order to generate Embed tokens, Report Id’s, Object Id’s and Group Id’s and Embedded Power BI reports and individual Tiles Securely on web page.
Created complex reports using Power BI Desktop and Published to Power BI Service and created Dashboards using Reports in Power BI Service.
Create interactive dashboards and reports that allow stakeholders at all levels to track claims metrics in real time
Analyze customer feedback and claims resolution times to improve customer satisfaction.
Combine and analyze claims data from multiple sources to present a unified view of the claims process.
Set up KPIs (Key Performance Indicators) to measure claim trends, efficiency, and costs.
Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
Ability to work with various types and stages of software development life cycle (SLDC) process including Analysis, Design, Development, Testing and Implementation.
Created Dataflows in Power Apps Dataverse and maintained refresh schedules, also performed various transformations in Power Query.
Installed and Upgraded Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
Set up visualizations to monitor metrics like "Claim Resolution Time", "Approval Rate", and "Average Payout".
Experience in creating data models and DataMart’s based on user requirements and available data fields.
Worked on motion chart, Bubble chart, and drilldown analysis using Tableau desktop. Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, report design and monitoring of system usage.
Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
EDUCATION:
B. Tech (Computer Science and Engineering) from JNTU- Hyderabad in 2013
EXPERIENCE:
Anthem, Atlanta, GA Jun 2022 - Present
Power BI Developer
Created look up tables and imported fact table from Sql Server and designed the data model.
Designed and documented the entire Architecture of Power bi POC
Designed and Optimised SQL code in order to pull necessary columns and improve data loading.
Set up visualizations to monitor metrics like "Claim Resolution Time", "Approval Rate", and "Average Payout".
Created Cross- filter relationships and maintained Row- Level Security for Embedding Power BI reports for Customers.
Worked with Azure team to get necessary Permissions for Application to Access Reports
Set up KPIs (Key Performance Indicators) to measure claim trends, efficiency, and costs.
Utilized RLS and maintained Security for End- Users while Embedding Reports to Customers.
Installed and configured Enterprise gateway and Personal gateway in Power bi service.
Scheduled Automatic refresh and scheduling refresh in power bi service.
Created visualizations to track Medicaid enrolment trends overtime, broken down by demographics such as age, gender, disability status, and income level.
Extracted and integrated claims data from multiple sources, including Electronic Health Records (EHR),
Billing systems, and Medicaid Databases.
Created reports to track and analyze the most common reasons for claim rejections.
Designed summary reports for executives and department heads that provide high-level insights into claims performance, revenue impact, and arears for improvement.
Designed interactive dashbords providing a comprehensive view of total claims, processed claims, denied
Claims, and pending claims.
Designed dashbords to help compliance teams monitor adherence to Medicaid policies and regulations.
Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
Created Index Keys in look up tables and maintained relationships in order to improve the performance of reports
Used Power Query Editor to manipulate data for data analysis and business intelligence.
Created complex DAX Queries in order to meet the business requirement of conditional hiding of data, created conditional columns and measures
Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
Created SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.
Embedded Individual Tiles into Application, also worked on Embedding complete Report using Report ID
Enabled Query Caching in Power BI Service to meet SLAs for Performance of the report
Environment: Power BI Embedded, ORACLE, PL/ SQL Developer, SSIS, SSRS, SQL, Power BI Desktop, Windows 10, MS Word, MS Excel, C#, Visio, DAX Studio, AWS RedShift, AWS Snowflake, Medicaid data standards(HIPAA compliance).
Kohler, WI Jan 2021- Jun 2022
Power BI Developer
Developed Power BI model used for financial reporting of P & L and Headcount.
Created interactive filters,parameters,and calculations for dashboard and worksheets in tableau.
Designed and documented the entire Architecture of Power bi Poc
Using Power Query Editor built high quality analysis on well organised data to free from errors.
Expertise in writing complex DAX functions in Power BI and Power Pivot.
Automated Power Query refresh using power shell script and windows task scheduler.
Installed and configured Enterprise gateway and Personal gateway in Power bi service.
Scheduled Automatic refresh and scheduling refresh in power bi service.
Worked on all types of transformations that are available in Power bi query editor
Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
Creating data blending in case of merging two different datasets using Tableau
Developed Excel PowerView, Power Query and PowerPivot dashboards for data analysis
Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point.
Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
Created SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.
Environment: Power BI, SQL Server 2012, SSMS, SSIS, SSRS, SSAS, T-SQL, Tableau, Power BI, Windows 7, MS Word, MS Excel.
Caterpillar, KY Jul 2019 – Dec 2020
Power BI Developer
Gathering business requirements from various users of different Departments.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Effectively used data blending feature in tableau.
Defined best practices for Tableau report development.
Build the Power BI reports by cleaning the DATA.
Administered user, user groups, and scheduled instances for reports in Tableau.
Executed and tested required queries and reports before publishing.
Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
Provided support for Tableau developed objects and understand tool administration.
Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
Created Custom Hierarchies to meet the Business requirement in Tableau.
Environment: Tableau Desktop 8.1, Tableau server / Administrator, SQL Server 2012, MS Access.
Vinfosoft Solutions, Hyderabad, India May 2014 – Jul 2016
SQL BI Developer
Created Database Objects – Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
Actively involved in Normalization (3NF) and De-normalization of database.
Scheduled Jobs and Alerts using SQL Server Agent.
Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
Generated custom and parameterized reports using SSRS.
Utilized SSIS to get data from Source databases and to transform, data cleanse and loaded into Destination tables.
Created various visualizations like waterfall, funnel, matrix visualization, scatter plots, combo charts, gauges, cards and KPI.
Optimized SQL queries for improved performance and availability.
Ensured Data Recovery, Maintenance, Data Integrity and space requirements for physical Database.
Used query statements like sub queries, derived tables to insert the data depending on the requirement into the tables.
Environment: SSMS, SQL Server 2012, SSIS, Access DB Engine, Visual Studio, SSRS
Contact this candidate