Pulkit Gupta

About Pulkit Gupta

I am a Senior Analytical Engineer with 14+ years of experience building analytics platforms that turn complex data into trusted, decision‑ready insights.My work sits at the intersection of analytics engineering, Microsoft Fabric, and applied AI, designing Lakehouse‑first architectures, governed semantic models, and AI‑assisted analytics that scale from analysts to executives.In recent roles, I’ve led enterprise analytics modernization initiatives on Microsoft Fabric, creating reusable Bronze/Silver/Gold data layers and centralized semantic models that standardize business metrics across teams. I’ve enabled Copilot and Data Agent–driven insights to reduce manual reporting effort and accelerate time‑to‑insight.I specialize in:Analytics Engineering (business logic, metrics, semantic modeling)Microsoft Fabric (Lakehouse, Dataflows Gen2, Pipelines, Notebooks)SQL, DAX, and KQL for analytical workloadsAI‑assisted analytics (Copilot enablement, Data Agents, GenAI summaries), Prompt EngineeringGovernance, security, and production‑ready Dev / Pre‑Prod / Prod analyticsI work closely with stakeholders and leadership, translating ambiguous questions into clear KPIs, reliable metrics, and analytics systems that leaders actually trust and use.

Experience

1. Senior Technical Lead Senior Analytical Engineer

   HCLTech

   Nov 2021 — Present · Bellevue, WA, US

   Senior Analytical Engineer leading analytics modernization initiatives with a focus on Microsoft Fabric, analytics engineering, and AI‑assisted insights. Responsible for designing governed analytics platforms that translate complex data into trusted, decision‑ready metrics.Key ContributionsLed analytics engineering and modernization efforts on Microsoft Fabric, designing lakehouse‑first architectures and curated semantic models that standardized business metrics across teams.Built reusable Bronze / Silver / Gold analytics frameworks, enabling consistent transformations, metric definitions, and scalable onboarding of new analytical use cases.Designed and operationalized semantic models optimized for analytical workloads, ensuring business logic lives centrally and supports both BI and AI‑assisted consumption.Enabled AI‑assisted analytics using Fabric Copilot and Data Agents, allowing stakeholders to generate summaries, trends, and insights without manual analyst dependency.Partnered closely with business stakeholders and leadership to translate ambiguous questions into clear KPIs, executive dashboards, and analytical narratives.Established Dev / Pre‑Prod / Prod analytics workflows with governance, security (RLS), and controlled promotion of analytical logic.Acted as the analytics design authority—reviewing metric definitions, ensuring data quality, and maintaining trust in executive reporting.

Education

• Lovely Professional University

  B.Tech, Electronics & Communication

  2007 — 2011

• Illinois Tech Stuart School of Business

  Master of Business Administration, Business Analytics

• Great Lakes Institute of Management

  PGPBABI

  2017 — 2018

• Lovely Professional University

  Bachelor of Technology, Electrical, Electronics and Communications Engineering

• Shivedale public school

  Senior Secoundary, PCM

  2005 — 2007

Skills

• Business Intelligence
• Secondary Data Analysis
• Microsoft Sql Server
• Sql
• Data Analysis
• Crystal Reports
• Mysql
• Web Design
• Pl/Sql
• Php
• Project Management
• T-Sql
• Ssrs
• Sdlc
• Javascript
• Html 5
• Databases
• Software Development
• Html
• Web Development
• C++
• SEO
• Business Analysis
• Ssis