Purnodaya Gone

ad07ge@r.postjobfree.com

201-***-****

Melissa, TX 75454

linkedin.com/in/powerbipurna

Professional Summary

Highly motivated Power BI Developer with 6+ years of IT experience in Development of reports from various sources like SQL Server, SharePoint list, SharePoint Folders, and Excel etc.… to pull the data into Power BI desktop, ETL processing, Data Modeling, Data Visualization.

Expert skill in data migration and ETL from various data sources like Excel, SQL Server, Flat files using SSIS packages and T- SQL constructs. Monitoring, debugging and tuning ETL jobs and workflows.

Expertise in writing complex DAX functions in Power BI and created DAX queries to generate calculated columns by using Sum, IF, Divide, distinct Count and Calculate, Lookup Value Filter Functions.

Created Bookmarks as per business requirements.

Installed and configured Enterprise gateway in Power BI service.

Created Workspace for business users to view the developed reports.

Expertise in Power BI, Power BI Mobile, Power Apps and Power Automate

Expert in creating and developing Power BI Dashboards into rich look.

Created different Power BI reports utilizing the desktop and the online service and schedule refresh.

Develop the overall application architecture for projects, ensuring that the architecture is appropriate across the business domain(s), evolves to meet changing business and technology environments, and adheres to the enterprise architecture.

Assist end users with problems in installing the Power BI desktop, installing, and configuring the personal and On-Premises gateway, connecting to data sources, and adding the different users.

Worked on different levels of filters like report level, visual level filters, page level filters.

Expertise in developing KPI visualization and good hands-on experience in implementing row-level security on dashboards as per business need.

Expert in using Power BI Rest API.

Created different Power Apps Screens, Gallery, Power Apps Cards, Containers and Responsive components.

Good hands-on experience writing and modifying complex T-SQL queries, stored procedures, and Joins.

I have good hands-on experience in migration of SSRS reports to Power BI.

Experience in using salesforce, Jira, and Python data sources in Power BI.

Experience in using different cloud services Azure and Snowflake.

Made POC by Connecting data from Azure DevOps folder to Power BI.

Used the SQL task type in Azure Databricks to operate and Monitor workflow (Databricks SQL Objects)

Supported in Power BI Snowflake Integration.

Certifications:

Microsoft Certified Power BI Associate.

Education Qualification:

M.Sc. Biochemistry – Osmania University Campus Hyderabad- 2009 with Distinction.

Bachelors in Mb.B.C (Microbiology, Botany and Chemistry)- Osmania University Hyderabad-2007.

Work Authorization:

● H4 EAD (I94 Valid till April 2025)

Technical Skills:

Technologies used: Power BI Desktop, Power BI Service, Power Apps and Power Automate

ETL Tool: Power Query

OLAP Tools: Power Pivot

Reporting Tools: Power View

Database: MS SQL Server, AZURE, SharePoint (Share Point List and Share Point Folder), SSRS, SSIS and Excel

Work Experience

New York Power Authority (NYPA), WPO, NY

Power BI and Power Platform Developer

Jan 2022 – Till Now.

Project: Resiliency & Technical Compliance - IT Operation Center

New York Power Authority (NYPA), White Plains, NY Jan -2022 to Till Now

Environment: Power BI, Share Point List, Power BI Service, Power Apps and Power Automate,

● Used Share Point List source to pull data into Power BI.

● Created Invoke Custom Functions, Renamed Columns, and datatype changes in Power Query editor.

● Created report using Tables, Bar charts, Tree map, Cards, and donut charts.

● Created Dax Measures like Calculate Function, Distinct Count, Sum Function and Divide functions in the report.

● Created Power BI Mobile view report to view the developed report.

● Created Bookmarks for Power BI Mobile report.

● Used Page level Filters and Visual Level Filters as per business requirements.

● Created Tool Tip Page to see specific business requirements in Power BI Mobile report.

● Published report in the workspace for business users to view the developed reports.

● Scheduled scheduling refresh in Power BI Service and automated flow in Power Automate to refresh dataset automatically whenever new columns are added or updated columns into data source.

● Created Custom Function to convert UTC time to EST time with daylight saving.

● Created Scheduled Flow to send email reminders to specific managers whenever ticket is open for services.

● Migrated Dev Power BI reports into Production and Involved in migration of Power Apps from Dev Environment to Prod Environment

● Troubleshoot and support reports in Power BI workspaces whenever there are issues in production.

● Created documentations for Power BI reports, Migration process document from DEV to Prod, Power Apps and Power automated flows documentation.

● Created User Guide for Power BI Report, Power BI Mobile View, and Power Apps and Power Automated Flow User guide.

● Created Documentation of Power BI reports and migration process of Dev to Production.

● Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Project: ITBCM – DR Gap Analysis

New York Power Authority (NYPA) White Plains, NY Mar-2022 to Nov-2022

Environment: Power BI, Share Point Folder (Excel File), Power BI Service.

● Used Share Point Folder source (Excel File) to pull data into Power BI.

● Created report using Matrix Table, Bar Charts, Slicers, Cards and Pie Charts.

● Created Dax Columns, Dax Measures. In the Power Query editor Renamed Columns, Remove Duplicates, Filtered Rows, and datatype changes.

● Using a query editor in Power BI performed certain operations like Merge queries from different tables and Unpivot the columns and Transpose.

● Created Visual level Filters as per business requirements.

● created Legends and Bookmarks for Gap status.

● Developed and published reports into Power BI service.

● Created workspace for business users to view the developed reports.

● Scheduled scheduling refresh in Power BI Service.

● Created documentation for DR Gap analysis report.

● Troubleshoot and support reports in Power BI workspaces whenever there are issues in the report.

● Participated in project planning sessions with project managers, business analysts and team

members to analyze business requirements and outline the proposed solution.

Deloitte, New York, NY

Power BI Developer

Mar 2017 - 2021.

Project: CU of Colorado - Deloitte, New York Mar-2020 to Dec-2021

Environment: SQL Server, SSIS, SSRS Power BI, Power BI Service.

● Requirement gathering, gap analysis and understanding the business requirements and building the relationships between the various data sets in power pivot.

● Business walkthrough of requirements, development, unite testing and UAT, documentation.

● Performed data changes suitable for better modeling and visualizations.

● The results were converted into various visualizations like donut chart, Pie chart and Bar graph, and water fall charts and Card Visualizations.

● Created different filters like visual level filters and page level filters and report level filters as per reporting needs.

● Created bookmarks, drilldown, drill through and parameters based on customer requirement.

● Created measures for DPMO, Overall Previous month Quality percentage, Overall Current month quality percentage and Quality percentage for every auditor, calculations using DAX.

● Specified users to access reports at data set Row Level Security (RLS).

● Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers and jobs.

● Designed and populated specific tables, databases for collection, tracking and reporting of data,

● Built SSIS packages to extract, transform and load data to data warehouse.

● Created and automated SSRS reports.

● Migrating SSRS report to Power BI.

● Diagnosed and addressed operational data issues.

● Publishing reports to Power BI server and providing access to required team lead on Monthly Basis.

● Specified Scheduled refresh for the report based on customer instructions. Generated alerts when customer required point reached.

● Created App spaces for easy visualization of the reports as per the client requirement.

Project: SIEMENS Deloitte – New York Jan -2018 to Dec- 2021

Environment: Power BI, SQL Server, Power BI Service.

● Participated in requirements meetings and scrum calls to understand the report requirements.

● Used power query / query editor for data transformation as per the reporting needs.

● Created data model in power pivot by establishing the relationship between the tables.

● Enhanced the data model by creating new columns and new measures using DAX.

● Developed at least two - three visual options for each report for discussion with stakeholders and customers.

● Created hierarchies and drilldown reports.

● Created Microsoft power BI dashboards in power BI service using reports.

● Installed and configured data gateways to refresh and schedule refresh the dataset.

● Managed access of reports, dashboards and data for individual users using roles.

● Implemented row level security as part of security.

● Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers and jobs

● Used organized Gateways in Power BI Service to connect SQL Server to Report.

● Provided continued maintenance and development of bug fixes for the existing and new power BI reports.

Project: Auto Mation Deloitte New York Mar -2017 to Dec-2021

Environment: Power BI, SSIS, Power BI Service.

● Understand requirements, analyzing systems and source databases like SQL server and flat files.

● Performed data changes suitable for better modeling and visualizations.

● Generated different reports and dashboards for data showing business of different line of business

across different geographical locations for clients.

● Created different visualizations using column charts, bar charts, line charts and pie charts, maps,

tree maps and highlights, etc.

● Creating weekly and monthly, quarterly, yearly KPI and so many kinds of reports as per my business

needs depending on the client requirements.

● Implemented drill down and bookmarking options and parameters wherever required.

● Constructing or ensuring appropriate data model before report development involved in data modeling

for dashboard design.

● Implemented star schema & snowflake schema.

● Developed and deployed quality T-SQL codes, Views, functions, triggers as per business requirements.

● Built SSIS packages to extract, transform and load data to data warehouse.

● Participating and contributing to team meetings for sharing new knowledge.

● Scheduling the reports on a weekly and monthly basis as per the client requirements.

Contact this candidate