varun varma

Senior member of a cross-function BI/Data Engineering team delivering analytics solutions for multiple programs including Resource planning, Objective/Key Result tracking for leadership, Cost optimization, Vendor operations, and Logistics management programs. Built reliable ETL pipelines and used BigQuery, SQL, Python, and Apps Script to pull and combine data from multiple sources. Created data layers in BigQuery that reduced one-off data requests by ~30%. Delivered production dashboards in Tableau, Power BI, Looker Studio and PLX used by 100+ stakeholders. Optimized analytics data architecture, reducing execution time by over 40%.

Supported Microsoft as a client partner on software licensing analytics. Built data pipelines using Python (Pandas, PySpark) and SQL to clean, transform, and unify high-volume customer and licensing datasets. Developed analytical models to flag underutilization, compliance risk, and overspend patterns. Designed executive dashboards in Power BI and Tableau. Applied statistical techniques such as regression and hypothesis testing to validate usage patterns.

Managed SLA commitments, KPI targets, and risk management for a Top 10 BFS client. Collaborated with cross-functional teams to design solutions for functionality and scalability. Followed Agile methodology using JIRA. Debugged deployment issues and generated dashboards using Power BI, SQL and Excel VBA. Performed cost optimization for on-premises IT infrastructure and worked on digitization strategies using ServiceNow, Automation Anywhere, and Splunk, achieving 10% FTE optimization.