Power Bi Business Intelligence
Resume:
Susmitha Dandamudi
Power Platform Developer
***********@*****.***
linkedin.com/in/susmitha-d-68999a1b0
Developer specializing in end-to-end business intelligence solutions and process automation. Proficient in developing Power BI solutions, including interactive dashboards with complex DAX calculations, optimized data models, and secure reporting environments. Proven to enhance business operations through automated workflows and custom applications. Combines deep expertise in Power BI dashboard development, data modeling, and report automation with strong capabilities in Power Automate workflow design and system integration. Created efficient data refresh processes, implementing approval flows. Proficient in building responsive applications with seamless Microsoft Dataverse integration.
Core Skills
Power BI (Desktop & Service), Power Apps (Canvas & Model-driven), Power Automate Cloud Flows, DAX & M Query, SQL & Database Management, Snowflake, SSAS, Microsoft Dataverse, Performance Optimization, Security Implementation. Work Experience
Data Insights Analyst Aug 2022 - Present
3M Minneapolis
● Collaborated with Manufacturing teams to help automate and process transformation using data mapping techniques.
● Created custom Power BI theme and organizational branding guidelines ensuring consistent look and feel across reports
● Extract and transform data from Snowflake using SQL queries, create optimized data models within Power BI.
● Developed multiple dashboards to minimize manufacturing waste.
● Developed Steel dashboard to automate the process and identify the gaps which saved the material cost by 20%.
● Established report optimization resulting in 40% improvement in report loading times.
● Created Power Automate workflows to send the user feedback from power bi reports to ticket board and then to the assigned manager for approval via teams/mail.
● Built custom POWER ON visuals Table Editor, Data Matrix to writeback the data to the source table through VP Service.
● Leveraged Teams, embedded Power BI apps in Microsoft Teams Channels and Meetings
● Used Copilot to explore semantic models and create a narrative rooted in the report.
● Generated personalized reports in PDF format to various recipients using Dynamic Subscriptions.
● Created Power BI Apps to serve up multiple audiences with a single app.
● Worked on both Canvas and Model driven apps with various data sources including Dataverse, SharePoint and SQL.
Senior BI Consultant Mar 2021 - Jul 2022
Med-Lab Miami
● Redo the existing reports as per the business changes.
● Developed reports to analyze the future resource requirements by region.
● Developed dashboards result in an increase in operational efficiency.
● Collaborated with cross-functional teams to identify data sources and streamline data collection resulting in a reduction in report development time.
● Improved dashboard usability by implementing interactive visualizations.
● Coordinating with different teams across organizations during post implementation validations and maintaining the daily/weekly status report in the Azure boards.
● Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
BI Consultant Jul 2020 - Feb 2021
Strike LLC The Woodlands
● Maintained tickets in Cherwell Service Management, Teams, and Azure boards.
● Migrated portal reports to power bi and published to the power bi service.
● Created reusable data models and template reports, reducing report development time by 60% and ensuring consistency across the organization.
● Developed application in PowerApps canvas using SQL, Flow. Automated SSAS tabular model cube processing using XMLA queries.
● Extracting data from multiple sources like DB2, Oracle and SQL server and transforming, cleansing, validating data and loading into destination db. Microsoft Azure SQL Database using SSIS.
● Worked with application developers to deliver data through the design of stored procedures, functions, and views.
● Built Tabular Model Cube and created Perspectives.
● Developed Power BI dashboards connecting to azure tabular cubes. Used DAX in both AAS and Power BI.
BI Developer Feb 2020 – Jun 2020
State of New York, Wellesley Cove New York
https://otda.ny.gov/programs/emergency-rental-assistance/program-reports.asp
● Developed reports to review Applications, Average funding, Number of residents, Number of households receiving assistance, Geographic data, count paid, sum paid and average paid.
● Created DAX Queries to generate computed columns. Used drill through visual to see the application count by arrears, utility, prospective.
● Developed measures using DAX to find the number of eligible households that received assistance.
● Collaborate with the database team for the new requirements and daily refresh. Used Power BI Gateways to keep the dashboards and reports up to date.
● Created Row level security with power bi and integration with power bi service portal.
● Generate daily reports and share with the OTDA team. Worked with Microsoft team on product limitations, communication limitations and tool capabilities.
● Provided continued maintenance and development of bug fixes for the Power BI Reports. BI Engineer Feb 2018 - Jan 2020
Anheuser-Busch New York
● Weekly presentation to the business users about the reports and their changes as required.
● Developed AAS models and CI/CD pipelining system to build, test and deploy. Designed and Developed new SSAS Multidimensional Models.
● Designed and Developed new SSAS Tabular Models and used DAX expressions/formulas for creating calculated measures and columns.
● Used MS Visual Studio to build tabular models. Converted SSRS reports into Power BI reports. Created DB views for reporting purposes.
● Groups, Hierarchies, sets to make summary reports and dashboards using KPI’s.
● Created data extracts in Power BI and made data refresh schedules on Power BI servers. BI Developer Nov 2016 - Jan 2018
State of Pennsylvania, Deloitte Mechanicsburg, PA
● Develop dashboards using Power BI. Generated reports for Fraud analysis for Medicare team.
● Created reports for different types of Claims and payments for Medicare team. Created dashboards for Medicare transactions team to get the failed alerts and helped end users to understand the tool limitations
● Proficient in building Star schema and Snowflake schema depending on business requirements.
● Create and modify Interactive Dashboards and create guided navigation links within Interactive Dashboards. Make use of filters locally and global accordingly.
● Experience with SSIS performance tuning using counters, error handling, event handling, rerunning of failed SSIS packages.
Education
University of Illinois Springfield, master’s in computer science, GPA: 4.8/5 Jun 2016 Vignan's University, bachelor’s in computer science May 2015
Contact this candidate