Power Bi Developer/Analyst

Deepika Poleru

Power BI developer/Analyst

E-mail: *************@*****.***

Cell: 214-***-****

PROFESSIONAL SUMMARY:

I have a total of 3 years of work experience, in BI Reports, Data Analysis, Design, Implementation, Administration, and Support of Business Intelligence using Power BI, SQL Server and Data maintenance.

Expertise in Power BI, Power BI Pro, Power BI Mobile.

Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh. Create and share dashboards based on reports in Power BI desktop.

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

Proficient in SQL with hands on experience in Snowflake, SQL Server for Data Query and Analysis

Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, dimensional modeling and reporting tools.

Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.

Skillful in ETL - Extraction Transformation Loading using Power BI dataflow.

Proficient in developing parameterized reports, chart, graphs, linked reports, drill-down reports using Power BI.

Strong Dashboard design experience and passionate practitioner of effective data visualization.

Created various visualizations (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI

Hands-on experience in writing calculated columns and measures using DAX.

Experience in error handling, debugging, fixing coding issues, and troubleshooting production problems.

Developed Power BI reports using Time intelligence such as Year To Date (YTD), Month To Date(MTD), same period last year.

Hands-on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions.

Experience in publishing Power BI Desktop reports to Power BI service.

String experience in Power Query to acquire data from various source systems such as Snowflake, SQL Server, SharePoint, Excel, ServiceNow, Jira

Experience in interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.

Actively participated in requirement gathering and planning sessions to understand software enhancement needs and define testing strategies aligned with Agile methodologies.

Developed comprehensive UAT plans, outlining test scenarios and acceptance criteria in collaboration with business users and stakeholders.

TECHNICAL SKILLS

Reporting Tools: Power BI Desktop/Service

Database: Snowflake, SQL Server, Oracle DB

Languages: DAX, SQL, Python, R

ETL Tools: DBT(Data Build Tool), Power Query, Power BI Dataflow, SQL

Cloud: Microsoft Azure SQL Server, Snowflake, SharePoint

MS office: MS Excel, Word

Data Modeling Tools: Power BI data modelling

Applications: ServiceNow, Jira

EDUCATION

Master of business Administration

Bachelor of Science

PROFESSIONAL EXPERIENCE

Client: Autodesk, San Jose, CA August2022 – Jun 2024

Role: Power BI Developer//QA/Client Relations

Environment: Power BI Desktop, Power BI Service, Snowflake, Azure SQL Server, DAX, Excel, SharePoint

1.Project Goal: The Project Objective is to create “Service Health Dashboard” using Power BI. This dashboard helps business users to

Evaluate product-related issues, incidents, and their impact on customers.

Examine the average time taken to resolve issues.

Assess the severity of the issues.

Analyze the frequency of repeat incidents.

Responsibilities:

Engaged with stakeholders to thoroughly understand their needs and translate them into clear, actionable technical requirements. Facilitated regular meetings to ensure alignment and address any emerging issues promptly.

Designed and created standardized prototypes for dashboards, ensuring consistency in format and functionality.

Utilized APIs to pull data from multiple sources such as Incident Application and JIRA

Developed a range of dashboards and reports using Microsoft Power BI, enabling real-time data analysis and visualization. Tailored reports to meet specific user requirements, enhancing decision-making capabilities.

Created various visuals in Power BI, including scatter plots, slicers, text boxes, line charts, tables, and pie charts. These visuals provided intuitive and interactive data representations, facilitating better data analysis and insights.

Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.

Created “Drill through” for users to navigate from aggregated to detailed data between the pages with the filters.

Developed comprehensive test cases to validate Key Performance Indicators (KPIs), ensuring that the dashboards and reports met the predefined metrics and performance standards. Conducted thorough testing and validation to ensure data accuracy and reliability.

Worked with the admin team to configure Power BI Gateway connections. Set up automated data refresh schedules.

Oversaw the change request process, ensuring that all modifications were accurately implemented and thoroughly tested. Maintained open communication with users throughout the process, providing support and updates until the reports were successfully deployed.

Provided support and resolved refresh failures when they occurred

Created Power BI Dataflows in Power BI Service

Implemented best practices to improve performance and overall responsiveness of dashboards and reports.

Applied Row-Level Security (RLS) to protect sensitive data, ensuring that users only had access to the information relevant to their roles.

Demonstrated expertise in writing Data Analysis Expressions (DAX) functions, utilizing these powerful formulas to perform data calculations and transformations within Power BI.

2.Project Goal: The Project Objective is to create “EDH Qualtrics Data Analysis” using Power BI. This dashboard helps business users to

Evaluate customer survey feedback.

Identify survey responses lacking sales representatives or Autodesk contact information.

Assess survey response times.

Locate customers who haven't finished the survey.

Responsibilities:

Worked closely with stakeholders to get requirements and translated them into technical specifications.

Extracted data from Snowflake accessing database views.

Created dashboards and reports using Microsoft Power BI, enabling real-time data analysis and visualization.

Created data visualization using various visuals such as Bar chart, Column Chart, Gauge, Pie Chart, Slicers, and Line charts for users to perform interactive data analysis.

Created comprehensive test cases to validate Key Performance Indicators (KPIs). Conducted rigorous testing to ensure data accuracy.

Collaborated with the admin team to configure Power BI Gateway connections and establish automated data refresh schedules.

Provided assistance and resolved refresh failures promptly.

Implemented best practices to enhance dashboard and report performance.

Created measures using Data Analysis Expressions (DAX) functions, and used them to perform data calculations and transformations.

Client: Thomson Reuters, Ann Arbor

Job Title: Data entry clerk

Duration: Sep 2019 – March 2020

Summary of the responsibilities:

Cross verify Salesforce data with EMS and Flash systems, and mark firm as archive if it is not active in EMS and Flash systems

Identify firm details through internet, and categorize if a firm is corporate or tax professional

Cleaned and validated customer demographics, and segmentation in EMS and Salesforce applications

Cleansing customer location information to provide valid data to sales team

Contact this candidate