Back to Developers
Arunabha Lahiri

Arunabha Lahiri

Junior Analyst

India $10/hr 1+ yrs exp 94 · Outstanding

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 (52)

Pivot Tables Advanced
8.0/10
3
Years Exp
Excel Advanced
8.0/10
3
Years Exp
AWS Advanced
8.0/10
3
Years Exp
Power BI Advanced
8.0/10
3
Years Exp
Python Intermediate
7.8/10
3
Years Exp
Data Validation Intermediate
7.8/10
3
Years Exp
Data Cleaning Intermediate
7.8/10
3
Years Exp
Forecasting Intermediate
7.5/10
3
Years Exp
Report Automation Intermediate
7.5/10
3
Years Exp
ETL Intermediate
7.5/10
3
Years Exp
VLOOKUP Intermediate
7.5/10
3
Years Exp
Azure Intermediate
7.5/10
3
Years Exp
XLOOKUP Intermediate
7.5/10
3
Years Exp
ELT Intermediate
7.5/10
3
Years Exp
Tableau Intermediate
7.5/10
3
Years Exp
Pandas Intermediate
7.5/10
3
Years Exp
NumPy Intermediate
7.5/10
3
Years Exp
KPI Tracking Intermediate
7.5/10
3
Years Exp
Microsoft Excel Intermediate
7.4/10
2
Years Exp
SQL Intermediate
7.4/10
3
Years Exp
Postgresql Intermediate
7.2/10
3
Years Exp
MySql Intermediate
7.2/10
3
Years Exp
Cloud Analytics Intermediate
7.0/10
3
Years Exp
SQL Server Intermediate
7.0/10
3
Years Exp
Power Query Intermediate
7.0/10
3
Years Exp
scikit-learn Intermediate
7.0/10
3
Years Exp
Scrum Intermediate
7.0/10
3
Years Exp
Agile Intermediate
7.0/10
3
Years Exp
Transformation Intermediate
7.0/10
3
Years Exp
validation Intermediate
7.0/10
3
Years Exp
Statistical Analysis Intermediate
7.0/10
3
Years Exp
Data Warehousing Intermediate
7.0/10
3
Years Exp
GCP Intermediate
7.0/10
3
Years Exp
DAX Intermediate
7.0/10
3
Years Exp
Stakeholder Collaboration Intermediate
7.0/10
3
Years Exp
Snowflake Schema presentations Stakeholder Reporting Microsoft Teams Jira ERP CRM Formulas Star Schema Reconciliation Competitor Research Market Research KPI Definition EDA Basic R Google Sheets Charts

Work Experience

Management Trainee – Data Analysis & Reporting

Innovel Energy Service Pvt Ltd

Jul 2026 - Present

Domains: Energy Services & Manufacturing ● Perform SQL-based KPI validation, data reconciliation, and executive-level reporting across enterprise ERP systems for remote/asynchronous stakeholder teams.

Data Science Intern – Data Analytics & Reporting

Rubixe AI

Jul 2025 - Dec 2025

Domains: Sales, Marketing, Operations, AI/ML Analytics ● Delivered sales, marketing, and operations analytics using SQL (MySQL/PostgreSQL) and Python, extensively leveraging AWS (SageMaker, S3, EC2) for cloud analytics, with hands-on exposure to Azure and GCP. ● Built time-series forecasting models (up to 99.9% accuracy) with Power BI retention dashboards (+17.6% strategy effectiveness); automated recurring reporting via Power Automate, cutting manual effort ~30%.

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 – Data Analysis & Reporting

Tata Consultancy Services (TCS)

Mar 2021 - Jun 2022

Domains: BFSI, Global Pharma, Enterprise Systems ● Extracted and queried data across MySQL, PostgreSQL, and SQL Server to support cross-functional business, finance, and operations reporting. ● Performed data validation, cleansing, and reconciliation, ensuring 100% UAT/API accuracy across 6+ cycles for confidential BFSI & Pharma datasets. ● Built and automated Power BI/Tableau dashboards and KPI reports for business and finance stakeholders, reducing manual reporting effort by ~30%. ● Documented datasets, reporting standards, and BRD/FRD requirements while collaborating with product, tech, and operations teams in Agile/Scrum sprints.

Education

PGDM – Business Analytics - Xavier Institute of Management & Entrepreneurship (XIME)

2023 - 2025 · India

B.Tech – Computer Science Engineering - Meghnad Saha Institute of Technology

2016 - 2020 · India

Certifications

Google Advanced Data Analytics

Coursera · 2025

Microsoft Power BI Data Analyst

Coursera · 2025

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 9/15
💰 Rate 5/5
🏆 Certs 5/5
Verified 5/5
Total Score 94/100

Profile Overview

Member sinceAug 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation