ARINDAM MITRA

Analyst

Kolkata, IN.

About

Highly analytical and results-driven Analyst with 3+ years of experience transforming complex data into actionable insights and streamlined reporting solutions using Excel, SQL, and Power BI. Proven ability to define key performance indicators (KPIs), automate reporting pipelines, and ensure data integrity, consistently driving strategic decision-making and operational efficiencies across cross-functional teams.

Work

Champdany Construction LTD

|

Analyst

Not specified, Not specified, India

→

Summary

Currently serving as an Analyst, focusing on developing performance reports, defining KPIs, and ensuring data quality to drive operational improvements and efficiency.

Highlights

Developed comprehensive business performance reports in Excel and Power BI utilizing DAX and Time Intelligence functions, leading to the development and measurement of key performance indicators (KPIs) and saving 10% in manual audit time.

Collaborated cross-functionally with IT and other teams to ensure robust data quality and facilitate effective business requirements gathering for enhanced reporting solutions.

Conducted weekly performance audits for multiple mills, leveraging Advanced Excel to generate critical metrics and share insightful dashboards/reports, identifying a 5% year-over-year increase in wastages and enabling targeted interventions.

Amazon India Development Centre Pvt Ltd

|

Analyst

Not specified, Not specified, India

→

Summary

Contributed as an Analyst, optimizing operational processes, designing interactive dashboards, and automating reporting pipelines to enhance efficiency and accuracy.

Highlights

Streamlined manual audit processes by strictly adhering to Amazon's Standard Operating Procedures (SOPs), including analysis of delivery routes and geocodes, which reduced delivery time by 10%.

Designed and maintained interactive Power BI dashboards, incorporating DAX and Time Intelligence functions, and implemented monthly row-level security (RLS) across 4 Weekly Business Review (WBR) tracks.

Automated 20% of weekly and monthly reporting pipelines using Power Query, eliminating 80 hours per month of manual effort, and wrote complex SQL queries for ETL operations, significantly improving reporting accuracy.

Collaborated with diverse stakeholders to translate business requirements into actionable Key Performance Indicators (KPIs), publishing and sharing critical reports via Power BI.

Education

RCC Institute Of Information Technology, Kolkata

Kolkata, West Bengal, India
→
Bachelor of Technology (B. Tech) Applied Electronics and Instrumentation Engineering Grade:

Skills

Programming Languages

SQL, Basic Python.

Databases

PostgreSQL, Oracle.

Data Visualization & BI Tools

Power BI, Excel (Advanced Formulas, Pivot Tables), DAX, Time Intelligence.

Data Analysis & ETL

Data Analysis, KPI Development, Business Requirements Gathering, Data Quality, ETL Operations, Power Query, Performance Analysis, Metrics Generation.

Process Improvement & Operations

Standard Operating Procedures (SOPs), Manual Audits, Outlier Detection, Operational Efficiency, Process Automation.

Reporting & Communication

Business Performance Reports, Interactive Dashboards, Row-Level Security (RLS), Stakeholder Collaboration, Report Publishing.