Power Bi Data Analyst

Seema Zore

Power BI Developer Data Analyst

+91-808******* ***********@*****.*** LinkedIn Profile Pune SUMMARY

• Having 2 years of experience in IT industry as a certified Power BI Developer.

• Good knowledge in designing the data model into complete dashboard using Power BI and SQL.

• Experience in Power BI and ability to program the DAX query and modify data for reporting as per requirements.

• Knowledge in data cleaning and modifying data as per requirement.

• Experience in developing the various types of reports using different modes of connection like import and live connection.

• Proven experience in client handling, effectively communicating project progress and requirements, and ensuring client satisfaction through tailored solutions. SKILLS

Core Skills: Power BI, Power Automate, Power App, Power BI Desktop, Power BI Service Database Management: Oracle SQL, MySQL, SQL Server Other: Azure Data Factory, Azure Data Studio, Microsoft Fabric Language: Python

Operating System: Windows 7,8,10

PROFESSIONAL EXPERIENCE

CAPGEMINI TECHNOLOGY SERVICES

Pune

Analyst

Project 1. Client (Johnson and Johnson) – Oncology Dec 26, 2023 - Present

• Developed dashboard which aimed to provide weekly sales insights across territories, districts, and regions, highlighting oncology product sales performance using Import, Direct Query, and Live Query to transform data for Business intelligence.

• Created interactive dashboards based on requirements, utilizing DAX for calculations, Power Query for data cleansing, shaping and transformation.

• Checking on accuracy and feasibility on how requirements can be achieved.

• Worked on the cosmetic and UI aspects, including Bookmarks, Toggle buttons, Dynamic titles, visual formatting, tooltips, slicers and filter pane customization to improve usability and navigation.

• Performed testing KBQs (Knowledge Base Questions) provided by the client on Copilot and documenting the results.

• Worked on Copilot by adding Synonyms for testing and enabling users to ask data-related questions within the dashboard.

Project 2. Client (Johnson and Johnson) – Staffing Tracker

• Designed and developed a Power BI dashboard to track employee details, work status, tracking demands and tagging timelines.

• Analyzing the Business requirement Document (BRD) & connected to multiple data sources including Flat Files, Share point, MS SQL Server.

• Integrated Power Automate, to trigger automated email alerts when employees approach their tagging end date.

• Applied DAX for dynamic calculations, Power Query, Data manipulation, Data Profiling, Data Cleaning and used conditional formatting to highlight critical Timelines.

• Ensured data consistency through validation checks and enhanced dashboard usability with slicers, tooltips, and custom visuals.

• Established relationships using Data modelling across multiple data sources, i.e., Staffing tracker, Production access, Skill Matrix using common keys to enable seamless data integration. Project 3. Power BI Dashboard to Monitor Business Performance

• Built an interactive Power BI dashboard with MTD, QTD, YTD sales & profit KPIs using DAX time intelligence functions with working on Live Connection Mode by connecting with Power BI Semantic Model.

• Designed star schema data model and applied Row Level security for region wise access.

• Implemented custom visuals (KPI, Bullet, Funnel, Maps) with drill down and drill through features.

• Configured scheduled refresh in Power BI Service for up-to-date reporting.

• Built a Performance Tracker to monitor Sales vs Target and Profit Margin trends.

• Used field Parameters to enable dynamic switching between Sales, Profit, and Quantity for flexible analysis. EDUCATION

Savitribai Phule Pune University Pune

B.E (Electronics and Telecommunication Engineering) CGPA – 8.53 2019 - 2023 Maharashtra State Board Education Pune

12th HSC Percentage – 68.7 2018 - 2019

CERTIFICATIONS

• (PL-300) Power BI Data Analyst Associate Certificate

• Oracle SQL – Udemy

• SQL for Data Science – Coursera

• Microsoft Power BI – Udemy

• L0 Architecture

• Industry Supply Chain

Contact this candidate