Nishant Sharma

Nishant Sharma

Senior Data Analyst & BI Developer
India
English, Hindi

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…

Experience

Senior Data Analyst

Tech Mahindra · New Delhi , Delhi , India
Dec 2022 - Present · 3 years 11 months

<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>

SES · Luxembourg
Dec 2022 - Jun 2023 · 6 months

<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

BMTG Advisors India Pvt. Ltd.
Jul 2020 - Dec 2022 · 2 years 5 months

<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

ECIL Rapiscan Limited
Mar 2018 - Jul 2020 · 2 years 4 months

<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

Texmaco Rail & Engineering Limited
Nov 2016 - Feb 2018 · 1 year 3 months

<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

Tech Mahindra
Jul 2023

<p>Client: Brightspeed (US Telecom), Marketing & Sales Analytics</p>

Skills

Power BI DAX Power Query Power Automate row-level security Power BI Report Builder self-service BI executive KPI dashboards SQL CTEs window functions query optimisation performance tuning dimensional modeling star schema slowly changing dimensions data warehousing ETL ELT multi-source data integration partitioned tables data validation testing Datafold Git GitHub Jira Confluence Agile Scrum BRD TDD Google BigQuery Google Cloud Platform Looker LookML Looker Studio Python requests REST APIs pandas Microsoft Copilot Gemini in BigQuery stakeholder management mentoring Advanced Excel pivot tables lookups data cleaning Oracle Primavera EPPM
Report this Profile?