Apoorva Akki

Program Analyst — Power BI · Power Query · DAX · Data Modeling · SharePoint · SQL · Advanced Excel

Talent

MumbaiMember since May 25, 2026

Power BI DesktopPower BI ServiceDAXCALCULATETOTALYTDRANKXDIVIDEPower QueryTable RelationshipsRow-Level SecurityWorkspace AdministrationDashboard DeploymentPower BI ProceduresSharePointAzureSQL DatabasesExcel FilesSQLStored ProceduresAdvanced ExcelPivot TablesVBA MacrosXLOOKUPProject AnalysisProject ControlsOwnership AttitudeDATEADDFILTER

Hire this person

Send a job offer directly to this candidate

Power BI DesktopPower BI ServiceDAXCALCULATETOTALYTD

About

Proactive Power BI Developer with 2+ years at Tata Consultancy Services independently delivering end-to-end dashboards and project analysis reports for engineering and sales program portfolios. Expert in Power BI Desktop and Service — advanced DAX, Power Query (M), workspace administration, Row-Level Security, and Power BI Procedures documentation. Proven record of connecting diverse data sources (SharePoint folders, Azure, SQL, files) and translating internal and external stakeholder requirements into creative, presentation-ready visuals.

Agile delivery mindset with strong ownership attitude, consistently meeting SLA commitments through quality, timely deliverables across program-level engagements.

Experience

Power BI Developer / Data Analyst - Tata Consultancy Services Ltd.

Mumbai, India

(2024-04)

Connect and consolidate data from SharePoint folders, Excel files, SQL databases, and Azure into unified Power BI models using advanced Power Query (M) transformations — eliminating 5-day manual data collection cycles and enabling same-day reporting across 3 client accounts.
Establish primary key logic and define table relationships across star-schema data models, building validated fact/dimension joins that improved downstream report accuracy to 99.2% and ensured data integrity across all program deliverables.
Administer Power BI Service workspaces for 3 client environments — managing gateway configurations, scheduled dataset refreshes, and Row-Level Security roles, while authoring project-specific Power BI Procedures that standardise reporting across the program portfolio.
Deliver 15+ interactive dashboards independently across agile sprint cycles using advanced DAX (CALCULATE, TOTALYTD, RANKX) and creative, presentable visuals — cutting stakeholder reporting turnaround from 5 days to same-day and reducing manual effort by 40%.
Drive requirements-gathering meetings with internal and external stakeholders by proactively identifying project analysis needs and translating them into program KPI dashboards tracking targets and milestones — receiving direct client commendation for quality and clarity.
Optimise project analysis workflows using Advanced Excel (Pivot Tables, VBA Macros, XLOOKUP) and SQL stored procedures — demonstrating ownership attitude by maintaining dashboard schedules and consistently meeting all SLA commitments with quality, timely deliverables.