Arnav Roy

Data Analyst | Change Management | Project Analytics
Detail-oriented professional with experience in change control, delay analysis, EOT claims, and cost assessments. Skilled in analyzing project data, identifying patterns, and supporting decision-making with actionable insights. Eager to leverage analytical expertise and grow in data-driven environments

PPU-IOCL Barauni

• Supported in drafting and submitting EOT claims with proper documentation.
• Conducted preliminary analysis of project delays using critical path method (CPM).
• Helped in evaluating and compiling prolongation cost reports.

Sales Data Analysis Dashboard

• Tools: SQL, Power BI
• Skills: Data Cleaning, Data Aggregation, Data Visualization
• Built a dashboard to track sales by region, product, and time.
• Queried and cleaned data using SQL (JOINs, GROUP BY, CASE).
• Created KPIs: Total Sales, Profit Margin, YoY Growth.
• Designed interactive visuals for key insights.

Customer Retention and Churn Analysis

Tools: SQL, Power BI
Skills : Cohort Analysis, Retention Metrics, Customer Segmentation

• Analyzed churn using SQL to segment and extract customer data.
• Used window functions and date logic for retention and churn metrics.
• Built a Power BI dashboard with cohort and trend visuals.
• Delivered insights to boost retention and Customer Lifetime Value (CLV).

• Secretary (Managing & Directing Club NIT Kurukshetra), Responsible for organizing the events throughout the year in Nit Kurukshetra., Leading the team of 80 Members., Member of sponsorship committee.
• Volunteer (Students Club for Social Activity), Responsible for providing free education to local children., Mentored students who got seats in top engineering college.