Data Analyst

Professional Summary

Core Competencies

Advanced Excel

• Complex Functions: VLOOKUP, XLOOKUP, INDEX-MATCH, SUMPRODUCT, Nested IF, Array formulas
• Data Analysis: Pivot Tables, Power Query, Power Pivot, What-If Analysis, Solver, Scenario Manager
• Automation: VBA Macros, User Forms, Automated MIS Reports, Data Validatio
• Visualization: Dynamic Charts, Conditional Formatting, Heat Maps, KPI Trackers
• Database Integration: Import/Export from SQL, Access, ERP/CRM Systems
  

Power BI

• Data Modeling: Relationships, DAX (Measures & Calculated Columns)
• Data Transformation: Power Query (ETL), Data Cleansing, M Language
• Visualization: Interactive Dashboards, Drill-Through Reports, Slicers, Bookmarks, KPI Cards
• Integration: SQL, Excel, SharePoint, Azure, Google Analytics & Other Sources
• Reporting: MIS Dashboards, Sales/Financial Reports, Forecasting Models
• Security & Governance: Row-Level Security, Workspace Management, Report Sharing & Publishing
  

Professional Highlights

• Delivered end-to-end Power BI dashboards for leadership, reducing reporting turnaround time by

  70%

• Automated Excel reporting workflows using VBA, Power BI
• Integrated multiple data sources (Excel, SQL, ERP) into Power BI for centralized reporting
• Designed and deployed dashboards for

  Academics, Sales, Finance, and Operations

  with real-time updates and drill-down capability

Certifications

• Microsoft Certified: Data Analyst Associate (Power BI)
• Microsoft Office Specialist (MOS) Excel Expert
• Advanced Excel & Power BI Certification (Udemy / Coursera / LinkedIn Learning)
  

Soft Skills

• Strong Analytical & Problem-Solving Ability
• Data Storytelling & Business Communication
• Collaboration with Cross-Functional Teams
• Training & Mentoring Skills