Apoorva Akki

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.

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.

Bachelor of Engineering - Electronics & Communication Engineering - Basaveshwara Engineering College, Bagalkote, Karnataka (2023-08)