About Me
Senior Data Analyst / Senior Analytics Engineer with 9+ years of experience delivering Power BI and BI solutions across telecommunications, engineering, and business operations. Skilled in Power BI, DAX, Power Query, SQL…
Senior Data Analyst / Senior Analytics Engineer with 9+ years of experience delivering Power BI and BI solutions across telecommunications, engineering, and business operations. Skilled in Power BI, DAX, Power Query, SQL, BigQuery, dimensional modeling, data validation, and executive KPI dashboards. At Tech Mahindra, I integrate and reconcile multi-source marketing and sales data, improve dashboard performance, maintain governed metrics, and support senior leaders with reliable reporting. Earlier, I built reusable Power BI models, scorecards, compliance reporting, and automated KPI workflows. I collaborate closely with stakeholders, mentor junior analysts, and am open to relocating to Dubai.
Experience
Senior Data Analyst
<p>Client: Brightspeed (US Telecom), Marketing & Sales Analytics</p><p> Modelled call-centre and order data from several source systems into a star schema that ties each order to its channel and agent.</p><p> Slowly changing dimensions keep the history accurate.</p><p> Reconcile platform-reported campaign and email numbers with backend order data in SQL, and run custom SQL checks and Datafold diffs, so a wrong number is caught before it reaches a leadership dashboard.</p><p> Cut executive report refresh time by about 85%.</p><p> The dashboards were aggregating raw data live; moved that work into pre-aggregated, date-partitioned BigQuery tables built with CTEs and refreshed by scheduled queries.</p><p> Built the real-time sales dashboard in Looker Studio that 25+ senior leaders use, including the CEO, CMO and CTO.</p><p> It compares hourly and daily numbers with a trailing 3-day average, so a regional team can spot a dip and act on it the same day.</p><p> Maintain the LookML semantic layer, so every team pulls a metric from the same definition.</p><p> Changes go through Git branches and pull requests, and models and metric definitions are documented in Confluence.</p><p> Rebuilt a legacy Excel competitive-insights workbook (subscribers, wire centres, overbuilder competition) in SQL and Looker.</p><p> Along the way found a join fan-out bug that had been inflating several measures, and fixed it.</p><p> Currently building a Python pipeline that pulls social performance data from the Sprout Social API into BigQuery, next to the other channels.</p><p> It handles authentication, GET and POST requests, timeouts, pagination and JSON parsing.</p><p> Use Gemini in BigQuery to write SQL faster.</p><p> Also brought Conversational Analytics into Looker Studio, which lets non-technical leaders query governed data in plain English instead of waiting on an ad-hoc request.</p><p> Help junior analysts get started on the team: walking them through the data models and reviewing their SQL and DAX before it goes into shared reports.</p><p> Own the marketing dashboard: CAC, LTV, ARPU, ROAS, CPO, churn and net adds in one view, fed by GA4, SEMrush share of search, Talkwalker and internal order data.</p>
<p>Satellite & Engineering, Business Intelligence<br>
Re-modelled slow Power BI reports onto a star schema with reusable DAX measures, moving source clean-up into Power Query, and added row-level security (RLS) so each team saw only its own data.<br>
Gave business users drill-through, bookmarks, tooltips and field parameters.<br>
After that they could explore the data on their own instead of raising requests.<br>
Built pixel-perfect paginated reports in Power BI Report Builder for formal print and PDF distribution.</p>
Analyst-II
<p>Replaced manual Excel reporting with Power BI dashboards and KPI scorecards for the weekly, monthly and quarterly reviews.<br>
Power Query shaped the raw extracts, and Power Automate flows handled refresh alerts and report distribution.<br>
Turned raw operational data into audit-ready compliance reports, using complex SQL with multi-table joins, aggregations and validation logic.<br>
Wrote BRDs and technical design documents, working with business stakeholders to pin down requirements before anything was built.</p>
Senior Executive
<p>Created Power BI dashboards and KPI reports for leadership; the sales team used them to find new business opportunities.<br>
Brought CRM data into Power BI to follow each order's status after the sale, with custom visuals built to the business team's requirements.<br>
Handled technical documentation and coordinated with onshore teams to deliver on tight deadlines.</p>
Engineer
<p>Automated quarterly KPI reporting on contract wins and project pipeline in Power BI, saving around 10 hours of manual work a week.<br>
Cleaned and consolidated project data from multiple sources and maintained reporting in Oracle Primavera EPPM.</p>
Senior Data Analyst
<p>Client: Brightspeed (US Telecom), Marketing & Sales Analytics</p>