Power Bi Data Analyst

Arvind Chaurasia

+1-512-***-**** *******.***@*****.***

Professional Summary

Experienced Data Analyst with 7+ years of expertise in Business Intelligence across industries.

Proficient in SQL for data processing, and transformation.

Expertise in BI & Visualization tools such as Tableau (Dashboards, Scorecards), and SSRS for generating insights and stakeholder reporting.

Experienced in designing and developing interactive reports and dashboards in Power BI, leveraging Power Query and DAX for data modeling and performance optimization.

Solid understanding of campaign analytics, A/B testing, customer segmentation, and marketing performance metrics to drive data-driven decisions.

Adept at collaborating with cross-functional teams, working with stakeholders, and presenting data insights for strategic decision-making.

Strong knowledge of SWOT analysis, data profiling, data cleaning, and performance optimization to improve data accuracy and reliability.

Technical Skills

BI and Database Skills: Power BI, DAX, Power Query, Tableau, SQL (SQL Server, MySQL)

Tools & Platforms: Azure Synapse, Snowflake, Power Automate, Power Apps, SharePoint, Python, R

Soft Skills: Financial Planning, Reporting, Compliance, Stakeholder Management, Analytical Thinking, Communication Skills, Mentorship & Training.

Professional Experience

USAA Minneapolis, MN Dec 2023 – Present

Data Analyst

Responsibilities:

Compared large datasets using Power BI and Excel to identify discrepancies and ensure data accuracy.

Assisted team members with account receivables by analyzing financial workflows and providing actionable recommendations.

Developed automated processes for data refresh schedules and incremental loads in Power BI Service.

Collaborated with stakeholders to understand the impact of company-owned stores on accounting processes.

Created technical documentation for business analysis workflows and trained junior analysts on best practices.

Designed and maintained advanced Power BI dashboards to visualize KPIs and improve decision-making across departments.

Created optimized DAX measures for complex calculations and performance tuning.

Developed scalable data models and pipelines to support analytics workflows.

Automated data refresh schedules and incremental loads for real-time reporting.

Led governance initiatives for Power BI deployment, including security protocols and role-based access controls.

Collaborated with business teams to identify reporting needs and deliver actionable insights.

Extracted and transformed large datasets from SQL databases and cloud platforms for visualization purposes.

Integrated Power BI with Azure Synapse and other enterprise tools to streamline data accessibility.

Environment: Microsoft Excel, Power BI, DAX, MS Excel, SQL, Dashboard, Python

Morgan Stanley Mumbai, India Sep 2021 – Aug 2023

Data Analyst

Responsibilities:

Designed and developed interactive Power BI dashboards to visualize KPIs and improve decision-making processes.

Designed interactive dashboards in Power BI to visualize KPIs and support decision-making.

Implemented governance protocols for secure data handling across multiple departments.

Created optimized DAX measures for complex calculations and performance tuning.

Extracted and transformed large datasets from SQL databases and integrated data pipelines for analytics workflows.

Automated data refresh schedules for real-time reporting using Power BI Service.

Implemented governance protocols for Power BI deployment, ensuring security and role-based access controls.

Collaborated with business teams to identify reporting needs and deliver actionable insights.

Created ad-hoc reports including YTD, YOY analysis for financial operations using Power BI.

Maintained SharePoint pages for data visualization projects and ensured compliance with quality standards.

Environment: SQL, Power BI, Python, SWOT Analysis, Data Modeling, Dashboarding, Business Intelligence, Stakeholder Management.

Gridlex India Jun 2017 – Aug 2021

Analyst

Responsibilities:

Developed and optimized Power BI dashboards using advanced data modeling techniques, including star schema and snowflake schema, for enhanced performance and usability.

Applied various data transformations in Power Query, such as conditional splits, derived columns, and aggregations, to prepare datasets for visualization.

Created calculated columns and DAX measures to support complex business logic and improve reporting accuracy.

Designed relationships between fact and dimension tables in Power BI to ensure seamless data navigation and filtering.

Wrote SQL queries to retrieve and manipulate large datasets for integration into Power BI reports.

Built parameterized reports in Power BI to allow dynamic filtering based on user inputs.

Automated data refresh schedules and incremental loads using Power BI Service for real-time analytics.

Collaborated with stakeholders to understand key KPIs and deliver actionable insights through interactive dashboards.

Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.

Created reports to retrieve data using Stored Procedures that accept parameters.

Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.

Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.

Environment: Oracle SQL Server, Power BI, Microsoft Office, KPI, DAX.

Education

Kent State University Kent, Ohio

Master of Science in Business Analytics

Chhattisgarh Swami Vivekananda Technical University Bhilai, India

Bachelor of Engineering

Contact this candidate