Rajat Singh

Business Data Specialist

Gurgoan 3+ yrs exp 81 · Excellent

About

No bio added yet

Skills & Expertise (24)

Power BI Intermediate

7.0/10

Years Exp

Excel Intermediate

7.0/10

Years Exp

Python Intermediate

6.5/10

Years Exp

MS SQL Server Intermediate

6.5/10

Years Exp

Google Sheets Intermediate

6.5/10

Years Exp

ETL Intermediate

6.0/10

Years Exp

Cross Team Collaboration Intermediate

6.0/10

Years Exp

Data Validation Intermediate

6.0/10

Years Exp

Google Looker Studio Intermediate

6.0/10

Years Exp

Root Cause Analysis Intermediate

5.5/10

Years Exp

DAX Intermediate

5.5/10

Years Exp

Data Modelling Intermediate

5.5/10

Years Exp

ELT Intermediate

5.5/10

Years Exp

Data Warehousing Intermediate

5.0/10

Years Exp

MySql Intermediate

5.0/10

Years Exp

Agile Methodology Intermediate

5.0/10

Years Exp

Azure Data Factory Beginner

4.5/10

Years Exp

Postman Beginner

4.5/10

Years Exp

Snowflake Beginner

4.5/10

Years Exp

LookML Beginner

4.0/10

Years Exp

Machine Learning Beginner

4.0/10

Years Exp

RLS Beginner

4.0/10

Years Exp

Git Beginner

4.0/10

Years Exp

Verint Beginner

4.0/10

Years Exp

Work Experience

Business Data Specialist

Telus Digital

Dec 2024 - Present

Designed and optimized scalable ETL pipelines using MS SQL Server, Power BI, Google Looker Studio, Excel and Google Sheets automating enterprise reporting and reducing manual effort by 45%. Performed data validation and quality checks across interconnected Google Sheets, Verint, Byteworks and Power BI, tracing discrepancies to source-level issues and ensuring accurate downstream reporting. Built scalable performance measurement frameworks and dashboards tracking workforce KPIs including Csat score, Shrinkage, Absenteeism, Workforce Performance etc, improving operational efficiency by 25–30%. Optimized data models and large-scale SQL and Google sheet datasets using DAX, data clustering, and Performance Analyzer in Power BI, cutting report load times by 15–20% and boosting performance for high-volume enterprise data. Conducted root cause analysis (RCA) on KPI anomalies and data discrepancies, collaborating with Operations and Data Engineering teams to resolve issues and maintain data integrity across reporting workflows. Delivered executive data storytelling and performance reporting, translating complex operational metrics into actionable insights and recommendations for senior leadership.

Data Analyst

Relay HumanCloud India Pvt. Ltd.

Jun 2023 - Nov 2024

Developed and automated end-to-end ETL pipelines and data models using Python, REST APIs, SQL Server, and Power BI, integrating CRM (Bullhorn) data into a centralized data warehouse supporting analytics for a US healthcare client environment. Engineered an incremental data ingestion framework using timestamp-based extraction in Python reducing API processing by 70% while improving pipeline scalability, reliability, and data freshness. Built executive financial and operational data products in Power BI covering Revenue, P&L, MoM/YoY growth, forecasting, billable hours, and Account Manager performance, improving management decision-making efficiency by 30–40%. Developed a geospatial analytics solution using Google Geocoding API and Haversine analysis, improving recruiter productivity by 40–45% through data-driven candidate matching. Delivered a senior management financial KPI dashboard connected to QuickBooks with DAX-driven P&L forecasting (weekly, monthly, yearly) improving executive decision-making efficiency by 30%.