Data Analyst Power Bi

Yash Baseriya

Data Analyst

Mumbai, India **************@*****.*** +917*********

Data Analyst with 3+ years of experience specialising in Power BI, data visualisation, and business intelligence. Proficient in Power Query, DAX, SQL, and Excel, with a strong ability to transform raw data into actionable insights through interactive dashboards and reports. Known for delivering data-driven solutions, supporting strategic decisions, and collaborating effectively with stakeholders to meet business objectives.

TECHNICAL SKILLS

BI & Visualisation: Power BI Desktop, Power BI Service, DAX, Data Storytelling, Report Scheduling, Row-Level Security Data Handling: Power Query (M), Multi-Sheet/File Merging, Header Correction, Table Appending, Field Standardization Via Mapping Tables, Data Cleansing, Unpivoting

Data Modelling: Star Schema, Bridge Tables (many-to-many), Mapping Tables, Relationship Management Languages & Tools: SQL, Performance Analyzer, DAX Studio, Excel, PowerPoint, SharePoint, Documentation (BRD, UAT, Closure Documents)

WORK EXPERIENCE

Data Analyst Infosys BPM Pvt Limited. June 2022- Present

• Designed, developed, and maintained Power BI dashboards and reports using SQL Server and Power BI’s Star schema.

• Automated reporting processes, improving efficiency and data accuracy by leveraging Power Query, DAX, and Excel.

• Provided end-to-end BI solutions, including data extraction, modelling, visualisation, and performance optimisation.

• I contribute to documentation, including Business Requirement Documents (BRD) and Closure Reports, ensuring clear communication of requirements and project outcomes.

• I collaborate closely with business analysts, project managers, data engineers, and QA teams to deliver solutions that align with business objectives and drive informed decision-making. PROJECTS

Supply Chain Analytics – Banking Bank of America Power BI

• Designed real-time reporting solutions to track advance payments to suppliers and interest collection from buyers, improving financial transparency.

• Developed 20+ interactive Power BI dashboards, reducing manual reporting efforts by 40% and enhancing real-time supply chain monitoring.

• Optimised data modelling using a Star Schema architecture, leveraging aggregations, indexing, and efficient DAX calculations to enhance query performance and reduce report load time by 35%, enabling seamless analysis of multi-source transactional data.

• Deployed Power BI reports with refresh and self-service analytics, cutting manual efforts by 40% and speeding decisions. Enforced RLS for supplier-specific access, ensuring compliance and data security.

• Collaborated daily with US-based stakeholders via email and evening meetings, refining requirements and aligning dashboard insights with key business objectives, accelerating project delivery by 25%. Gallagher Sales Report Gallagher Group Ltd, New Zealand Power BI

• Developed interactive Power BI dashboards, integrating data from SQL Server and Excel, improving report accessibility by 40%.

• Optimised data models and implemented query reduction techniques, reducing report load time for datasets with 200k + records.

• Created 10+ advanced DAX measures, including YoY Growth (+18%), enhancing sales trend analysis by 25%.

• Implemented RLS for user groups, ensuring compliance with data security policies and controlled data access.

• Identified top 10 performing sales agents, leading to an increase in sales efficiency and a revenue boost of $500K through targeted strategies.

• Automated report scheduling in Power BI Service, reducing manual reporting efforts by 80% and distributing reports to 50+ stakeholders.

EDUCATION

Sipna College of Engineering and Technology, Amravati 06/2017 – 07/2021 Bachelor of Engineering (B.E) – CGPA: 9.8

ADDITIONAL INFORMATION

• Languages: English, Hindi, Marathi

• Hobbies: Learning new technologies, Exploring data-driven insights, Reading about AI advancements

Contact this candidate