Power Bi Data Analyst

SUMMARY

Results-driven Data Analyst and Power BI Developer with 6.7 years of expertise in Business Intelligence, Data Modelling, and Dashboard Development. Skilled in transforming raw data into actionable insights, optimizing reporting workflows, and enhancing decision-making through advanced analytics. Adept at designing intuitive Power BI solutions, leveraging DAX and Power Query for automation and efficiency. Strong background in the automobile manufacturing industry, delivering strategic analytics that drive operational excellence and business growth. Recognized with industry awards for innovation in data analytics and automation. TECHNICAL SKILLS Project & Management Skills Domain Expertise

• Power BI (Desktop / Service)

• DAX (Data Analysis Expressions)

• Power Query (M Language)

• Data Modelling (Star, Snowflake Schema)

• Power Automate

• SQL

• Report Automation

• Excel

• Project Management

• Stakeholder Management

• Resource Management

• Process Improvement

• Finance

• Sales & Service

• Registration

• Strategic Sourcing

• Inventory Management

• Accounts Receivable

CERTIFICATIONS

Microsoft Certified: Data Analyst Associate (PL-300)

Agile Project Management Certification

Data Excellence Champions Program (DECP) Certification PROFESSIONAL EXPERIENCE

Designed and developed interactive Power BI dashboards and reports, leveraging DAX and Power Query to deliver insights.

Perform data cleansing and transformation using Power Query (M language) to ensuring 100% accuracy and reliability in reports.

Build a self-service dashboard resulting in a 40% increase in data-driven decision making.

Reduced report development time by 50% by implementing best practices.

Improved dashboard usability by implementing interactive visualizations resulting in a 20% increase in user engagement.

Collaborated with stakeholders to identify critical data sources, streamlining data collection and reducing report development time By 25%.

Provided technical leadership throughout the full lifecycle of data visualization projects, from discovery to delivery.

Developed Account Receivable Dashboards, improving receivable, Inventory Funding Stock tracking, and Retail visibility management.

Created Registration Market Share Analysis dashboards for business teams, enabling competitive analysis of Tata Motors vs. other OEMs, supporting strategic decision-making.

Created and implemented Accounts Receivable Analytics, automating receivable and improving Receivable on Time (ROT) performance from 75% to 95%.

Conducted data analysis and created data visualizations to support strategic planning and operational improvements.

Created data models and optimized data flows using Power Query and DAX to enhance performance and usability of Power BI reports.

Worked closely with business stakeholders to gather requirements, define KPIs, and deliver custom reporting solutions aligned with business goals.

* Registration Market Share Insights Project Domain: Registration Analytics Role: Data & Business Analyst Technologies: Power BI (DAX, Power Query, ETL, Data Modelling, RLS), Power Apps, Excel, Dataflow, SharePoint, SAP, Office 365, Vahan site. Key Contributions & Business Impact:

Led end-to-end development from requirement gathering to deployment & maintenance.

Developed Power BI dashboards with DAX, RLS, and Daily Market Share tracking.

Automated ETL pipelines using Dataflow and SharePoint, Schedule Refreshes.

Conducted root cause & receipt consumption analysis, improving Retail and Market share and Process Optimization.

Incorporated OEM wise zone wise data views along with last month Vs current month comparison to deliver actionable insights.

Enable comprehensive analysis through various filter and drill down capabilities to support strategic decision making. Project:-

Power BI Developer Data Analyst Business Analyst TATA MOTORS – Jan- 2019 - Present SWAPNIL DAMDHARE

Microsoft Power BI Developer / Data Analyst / Business Analyst Pune, MH, India +91-940******* *****************@*****.*** https://www.linkedin.com/in/swapnil-damdhare

* Accounts Receivable Analysis Domain: Finance & Procurement Analytics Role: Data & Business Analyst Technologies: Power BI (DAX, Power Query, Data Modelling, RLS), Excel, Power Automate, SAP, SharePoint

Key Contributions & Business Impact:

Developed the Accounts Receivable Dashboard, providing tracking of Dealer-wise receivable & outstanding amounts, enhancing financial visibility and decision-making.

Designed Business Area Wise Receivable & Outstanding Reports, leading to improved fund allocation and supporting strategic financial planning.

Implemented Inventory Funds Analysis, optimizing working capital utilization and ensuring efficient payment processing.

Conducted Overdue & Due Aging Analysis, reducing overdue payments by 15%, improving Dealer relationships, and mitigating financial risks.

Developed Day-wise Receivable & Outstanding Reports, supporting daily cash flow meetings, ensuring timely fund availability.

Expended Day-wise Stock & Retail Reports, Visibility daily Stock and Retail trends, ensuring timely Stock availability.

Enhanced Stock Analysis, visibility into nearby location availability provided valuable insights, leading to a 25% improvement in retail performance and overall business growth

Recognized with the UBS Forum Award for improving Accounts Receivable Analytics, driving efficiency in fund management and reducing working capital stress.

Key Achievements:

Recognized at UBS Forum for driving innovation and efficiency in Accounts Receivable analytics. EDUCATION

PG-MCA – Pune University, 2018

Bachelor of Computer Science – SRTMU Nanded, 2015

Contact this candidate