Rajat Saxena

Operations Associate

United Kingdom15 yrs 5 mos experience
Highly Stable

Key Highlights

  • Developed centralized Power BI dashboard ecosystem.
  • Built real-time ODS pipeline for live KPIs.
  • Achieved 30% faster decision-making through streamlined reporting.
Stackforce AI infers this person is a Business Intelligence expert with a focus on SaaS and data-driven decision-making.

Contact

Skills

Core Skills

Business IntelligenceData Analytics

Other Skills

Power BIAzure CloudSQL ServerSSRSSSISDAXData IntegrationAzure Data FactoryETLData ScienceSQLSSASProblem SolvingPython (Programming Language)Software Development Life Cycle (SDLC)

About

As a Business Intelligence Lead at EXL, I’m driving high-impact data analytics initiatives for global clients by building scalable, secure, and business-aligned reporting solutions. My role focuses on delivering insights that improve operational decisions, reduce manual reporting overhead, and bring clarity through powerful visual storytelling. 🔹 Key Responsibilities: Leading end-to-end BI delivery: from requirement gathering to report deployment using Power BI, SSRS, and ADF Designing and maintaining semantic models, ensuring consistency and reusability across reporting solutions Creating ODS (Operational Data Store) environments to support near real-time analytics Developing parameterized Paginated Reports and DAX-rich dashboards aligned to business KPIs Optimizing SQL queries, stored procedures, and data models for performance and scalability Collaborating across time zones with business users, architects, and C-level stakeholders to deliver actionable insights 🏆 Major Achievements at EXL: Developed a centralized Power BI dashboard ecosystem of a major Data Integration/ Org Ecosystem, integrating data across multiple business verticals Built a real-time ODS pipeline using Azure Data Factory and SQL Server to feed live operational KPIs Standardized reporting through advanced DAX logic, improving dashboard reusability and reducing turnaround time Enabled data-driven decisions at leadership level through clean semantic layer modeling and business metric definitions 📌 Tech Stack: Power BI – Dashboards, Paginated Reports, DAX Optimization, Power BI Service Microsoft Fabric – Advanced Capabilities, Data Governance, Premium Configuration, Data Lake, ETL, ELT Azure Cloud – ETL Pipelines, Cloud Integrations SQL Server – Advanced Queries, Stored Procedures, Tuning SSRS & Semantic Modeling – Metadata Reports, KPI Frameworks SSIS - ETL, ELT, Data Migration Technical Solution Desin, Functional Requirement, Technical Requirement, Pre Sales Technical Activities This role allows me to bring together technical expertise and business acumen, ensuring that data solutions translate directly into business value.

Experience

15 yrs 5 mos
Total Experience
7 yrs 2 mos
Average Tenure
1 yr
Current Experience

Exl

Manager Business Intelligence Analytics

Jun 2025Present · 1 yr · United Kingdom · Remote

  • With over 15.5 years of hands-on experience in Business Intelligence and Data Analytics, I specialize in building strategic, scalable, and insight-rich solutions that drive decision-making, improve operational efficiency, and support digital transformation.
  • 🚀 I’ve recently joined EXL where I lead high-impact analytics initiatives for global clients—delivering solutions that go beyond dashboards and into true business enablement.
  • 📊 From creating enterprise reporting platforms and real-time dashboards to developing semantic models and ODS systems, I focus on building secure, high-performance, end-to-end BI ecosystems.
  • 🔧 Key Areas of Expertise:
  • Power BI – Dashboards, Paginated Reports, DAX Optimization, Power BI Service
  • Azure Cloud – ETL Pipelines, Cloud Integrations
  • SQL Server – Advanced Queries, Stored Procedures, Tuning
  • SSRS & Semantic Modeling – Metadata Reports, KPI Frameworks
  • SSIS - ETL, ELT, Data Migration
  • 🏆 Success Snapshot:
  • Delivered 50+ Power BI & SSRS reports across Retail, Insurance, Aviation, and E-commerce
  • Achieved 30% faster decision-making through streamlined reporting
  • Automated workflows, cutting reporting effort by 40%
  • Developed forecasting models that helped clients save significantly in operational costs
  • 📌 Latest Highlight at EXL:
  • Designed ODS for a leading Insurance Projects, integrating real-time data streams.
  • Built semantic models + KPI dashboards as a unified analytics layer
  • Standardized report logic with advanced DAX and parameterized reports
  • 🌍 Global Collaboration:
  • I’ve worked closely with cross-functional and international teams—translating business requirements into insightful data stories for stakeholders, architects, and leadership teams.
  • 💡 Belief:
  • Data isn’t just numbers—it’s a narrative. I believe in turning raw data into actionable insight that reveals opportunities, solves problems, and drives growth.
  • Let’s connect if you’re passionate about meaningful analytics or need help driving your BI transformation journey.
Power BIAzure CloudSQL ServerSSRSSSISBusiness Intelligence+1

Awc software

Business Intelligence Architect

Jun 2016Jun 2025 · 9 yrs · Noida, Uttar Pradesh, India · On-site

  • I have over 14.8 years of experience working in data science. Currently, I work as Senior BI Developer, improving products and services for our customers by using advanced analytics, standing up big-data analytical tools, creating and maintaining models, and onboarding compelling new data sets.
  • In my current role, I am leading a team to derive data insights and enhance customer experience by leveraging Microsoft BI capability.
  • Previously, I was the MSBI Developer at PepsiCo, where I analyzed data from some of the biggest enterprise.
  • Competencies: Business Insights & Reporting, Data Analytics, Data processing, Data Visualization, Business Intelligence Tools (MSBI), Data Strategy, Database Architecture & Warehousing and Data Management, Tableau, Qlikview and PowerBI.
  • Technical Skills: SQL, SSIS, SSAS, SSRS, PowerBI, Azure Adf, TFS, GitHub
Data SciencePower BISQLSSISSSASBusiness Intelligence+1

Pepsico

2 roles

Database Developer

Mar 2011Jun 2013 · 2 yrs 3 mos

Problem SolvingDAX

Business Intelligence, Analytics and Data Warehouse Solution

Aug 2009Jan 2015 · 5 yrs 5 mos

Problem SolvingDAX

Education

Dr. A.P.J. Abdul Kalam Technical University

Bachelor of Technology (B.Tech.) — COMPUTER SCIENCE AND ENGINEERING

Jan 2004Jan 2008

Raghuveer Sahai Inter College, Aligarh

Intermediate — PCM

Jan 2001Jan 2003

Raghuveer Sahai Inter College, Aligarh

High School — PCM

Jan 1999Jan 2001

Stackforce found 100+ more professionals with Business Intelligence & Data Analytics

Explore similar profiles based on matching skills and experience