Rohan Kumar Dalai

Gorakhpur

Summary

Result-oriented Data Analyst with 3+ years of experience in data storytelling, business intelligence, and infrastructure monitoring. Skilled in Power BI, SQL, and Python, with a proven track record of delivering stakeholder-ready dashboards, optimizing reporting workflows, and solving business problems through data. Former Infra Support Engineer with deep experience in system log analysis and KPI tracking. Currently pursuing a PG Certificate in Data Analytics & Generative AI from IIT Guwahati. Adept at turning raw data into business insights using modern tools and automation.

Overview

years of professional experience

Certification

Work History

Data Analyst

Freelance / Projects

05.2023 - Current

Delivered interactive dashboards with DAX-based KPIs, slicers, and drilldowns using Power BI.
Built Python ETL scripts that reduced manual report generation by 40%.
Extracted insights from structured datasets using PostgreSQL/MySQL and advanced SQL (joins, window functions, CTEs).
Created churn prediction and segmentation models using scikit-learn (logistic regression, clustering).
Integrated prompt engineering to generate automated executive summaries and reports.
Worked on datasets from HR, retail, and aviation industries to solve real business use cases.

Software Engineer - Infra Support

Hexaware Technologies

06.2021 - 04.2025

Managed L1-level monitoring and support of critical systems (Linux/Windows) using AppDynamics.
Configured agents, created alerts, and monitored application performance KPIs.
Performed root cause analysis on ticket trends and improved uptime through early warning reports.
Automated Excel reporting using scripts and converted reports into dashboards (Power BI).
Coordinated with L2/L3 teams to analyze infrastructure incidents and downtime metrics.

Education

B.Tech - Computer Science & Engineering

Lovely Professional University

Phagwara, Punjab

08-2020

Skills

Data Analysis: Power BI, Tableau, SQL, Excel
Programming: Python, Pandas, NumPy, Seaborn
Reporting: Dashboard Design, KPI Tracking, Data Cleaning, Storytelling

Analytics: Predictive Modeling, Clustering, Logistic Regression, Time Series
Monitoring: AppDynamics, Linux/Windows Logs, Root Cause Analysis, SLA Tracking
Cloud & Tools: Azure (AZ-900), Git/GitHub, Jupyter, VS Code

Websites

Certification

PG Certificate in Data Analytics & Generative AI, IIT Guwahati & Coding Ninjas, 2024-2025
AZ-900: Microsoft Azure Fundamentals
Google Analytics for Business, Google Skillshop
Adobe Analytics Fundamentals, Adobe Learning

Languages

English

Hindi

Timeline