Rajat Saxena — Operations Associate
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.
Stackforce AI infers this person is a Business Intelligence expert with a focus on SaaS and data-driven decision-making.
Experience: 15 yrs 5 mos
Skills
- Business Intelligence
- Data Analytics
Career Highlights
- Developed centralized Power BI dashboard ecosystem.
- Built real-time ODS pipeline for live KPIs.
- Achieved 30% faster decision-making through streamlined reporting.
Work Experience
EXL
Manager Business Intelligence Analytics (1 yr)
AWC Software
Business Intelligence Architect (9 yrs)
PepsiCo
Database Developer (2 yrs 3 mos)
Business Intelligence, Analytics and Data Warehouse Solution (5 yrs 5 mos)
Education
Bachelor of Technology (B.Tech.) at Dr. A.P.J. Abdul Kalam Technical University
Intermediate at Raghuveer Sahai Inter College, Aligarh
High School at Raghuveer Sahai Inter College, Aligarh