Simran Tibrewal

Data Analyst | Business Intelligence & Analytics Consultant

Delhi, NCR 5+ yrs exp 90 · Outstanding

About

Data Analyst / Analytics Consultant with 5+ years of experience collecting, cleaning, and analysing data from multiple source systems to surface trends, monitor KPIs, and support business decision-making. Skilled in building dashboards and reports (Power BI, Tableau, Excel) that translate complex datasets into clear, actionable insights for stakeholders. Strong track record in data validation, quality management, and reconciliation to ensure accuracy and consistency across reporting systems, along with hands-on SQL-based data extraction (SQL Server, MySQL) and Python. Experienced collaborating cross-functionally with management, project teams, and clients to deliver data-driven recommendations and reporting solutions.

Skills & Expertise (17)

Dashboard Development Advanced

8.5/10

Years Exp

Power BI Advanced

8.5/10

Years Exp

Microsoft Excel Advanced

8.5/10

Years Exp

SQL Advanced

8.0/10

Years Exp

Data Visualization Advanced

8.0/10

Years Exp

Data Reconciliation Advanced

8.0/10

Years Exp

SQL Server Advanced

7.5/10

Years Exp

Statistical & Trend Analysis Advanced

7.5/10

Years Exp

KPI Reporting Advanced

7.5/10

Years Exp

Root Cause Analysis Advanced

7.5/10

Years Exp

Cross-Functional Collaboration Advanced

7.0/10

Years Exp

Stakeholder Management Advanced

7.0/10

Years Exp

Python Intermediate

7.0/10

Years Exp

Tableau Intermediate

7.0/10

Years Exp

Performance Tracking Advanced

7.0/10

Years Exp

MySql Intermediate

6.5/10

Years Exp

Data collection

Work Experience

Consultant

Capgemini

Apr 2022 - Aug 2026

Extracted and cleaned SQL server data, identifying trend and data issues to support business recommendations. Analysed large, complex datasets to identify trends, patterns, and data issues, translating findings into business recommendations. Built and maintained multiple dashboards and reports in Power BI and Excel dashboards reducing analysis time and errors. Design and apply data validation and quality-checking logic across reports, pricing sheets, and project documentation to ensure accuracy, integrity, and consistency. Perform data reconciliation across source systems, investigating and resolving discrepancies before reports reach stakeholders. Validated and reconciled reporting data across source systems to improve accuracy and consistency.

Software Implementation & Data Analyst

Orchid Technical Consultancy P Ltd.

Jan 2021 - Feb 2022

Developed industry-specific dashboards and pivot reports using SQL, BI tools, and Excel, transforming raw business data into actionable reporting outputs. Built reporting logic with complex SQL queries and business calculations to support recurring analysis and reporting needs. Mapped and analysed business data across systems to develop spreadsheets, pivot reports, and analytical solutions. Validated dashboards and reports against source-system and Tally ERP data, identifying mismatches and improving data reliability through root cause analysis. Performed ongoing data cleaning, validation, and quality checks to maintain consistency across analytical outputs. Supported rollout of BI reports and dashboards for management and client use, and presented findings directly to stakeholders.