Arunabha Lahiri

Junior Analyst

India 1+ yrs exp 84 · Excellent

About

Detail-oriented Analyst with 2+ years of experience in business intelligence, reporting, and data-driven decision-making across BFSI, Pharma, Energy, and E-Commerce domains. Skilled in Microsoft Excel (Pivot Tables, VLOOKUP/XLOOKUP, formulas, charts), SQL, Power BI, and Tableau for building dashboards, tracking KPIs, and performing data validation and quality checks. Experienced in translating business requirements into structured analytical tasks, conducting market and competitor research, and communicating insights to cross-functional stakeholders. PGDM in Business Analytics from XIME Bangalore, with hands-on exposure to Python, ETL/data-warehousing concepts, and Agile/Scrum delivery. Recognized for improving reporting turnaround by ~40% and maintaining 100% data accuracy across enterprise reporting cycles.

Skills & Expertise (37)

Power BI Intermediate

7.8/10

Years Exp

Tableau Intermediate

7.6/10

Years Exp

Microsoft Excel Intermediate

7.4/10

Years Exp

SQL Intermediate

7.2/10

Years Exp

Python Intermediate

6.8/10

Years Exp

Agile Intermediate

6.2/10

Years Exp

Market Research EDA Competitor Research Reconciliation ETL Data Warehousing Star Schema Snowflake Schema CRM ERP Scrum Jira Microsoft Teams Stakeholder Reporting presentations KPI Definition Data Validation Data Cleaning Statistical Analysis Basic R NumPy Pandas DAX Postgresql MySql Google Sheets Charts Formulas XLOOKUP VLOOKUP Pivot Tables

Work Experience

Management Trainee – Data Analysis & Reporting

Innovel Energy Service Pvt Ltd

Jul 2026 - Present

Perform KPI reporting validation, data-quality checks, and reconciliation across enterprise systems, ensuring accuracy for executive-level reporting.

Data Science Intern – Business Analytics & Reporting

Rubixe AI

Jul 2025 - Dec 2025

Designed and deployed 4+ Power BI dashboards and automated management reports, reducing manual reporting effort by ~40%. Applied Star/Snowflake schema data modeling to structure large (1M+) datasets for downstream BI consumption. Delivered SQL-based data extraction and business-insight summaries used in senior leadership decision-making.

Data Science Intern

Ardent Computech Pvt. Ltd.

May 2024 - Jul 2024

Analyzed customer sentiment and marketing data (95% model accuracy) to support digital marketing analytics and client reporting.

Assistant Systems Engineer – Business Analysis & Reporting

Tata Consultancy Services (TCS)

Mar 2021 - Jun 2022

Collected, validated, and reconciled data across enterprise systems, supporting 100% end-to-end validation across 6+ UAT cycles. Built management dashboards and reports in Power BI and Tableau, supporting leadership decision-making in BFSI and Pharma domains. Performed SQL-based data extraction, transformation, and validation pipelines to enable accurate, stakeholder-ready reporting. Coordinated cross-functional Agile/Scrum/Jira teams, bridging business, QA, and development to ensure on-time, quality delivery.