Sangam Kumar | Data Analyst at Adani Cement

Sangam Kumar

Data Analyst at Adani Cement

Based in Bengaluru, Karnataka

About

Passionate about uncovering insights from a large volume of data to drive key business decisions.

Skills

Projects

CardSense - Personal Finance Analytics Platform

CardSense is an end-to-end personal finance analytics platform that automates the extraction, transformation, and analysis of credit card transactions. It converts unstructured PDF statements into structured insights and delivers actionable analytics through a dashboard.

Mitron's Bank - Analysis For New Credit Card Launch (Codebasics Resume Project Challenge)

The objective of this project is to analyze the data and provide actionable, data-driven recommendations to guide Mitron Bank in tailoring the new credit cards to customer needs and market trends.

AtliQ Grands - Analysis In Hospitality Domain (Codebasics Resume Project Challenge)

This project offers a comprehensive analysis of AltiQ Grands hotel properties.It aims to deliver actionable insights and strategic recommendations to boost revenue and market share, emphasizing the importance of data-driven decision-making in the hospitality industry.

Analysis Of Bank's Loan Portfolio

Data-driven decision-making is crucial for the success of any bank. This report details a comprehensive bank loan portfolio analysis, providing key insights for monitoring and evaluating lending activities.

A Comprehensive Analysis Of Indian Premier League using SQL

In this project, I analyzed over one million rows of IPL data stored in a MySQL database with 21 tables. By writing 30+ advanced SQL queries, I uncovered insights into batting, bowling, and team performance, identifying top scorers, best captains, and key match conditions.

A Comprehensive Study Of Covid-19 Pandemic In India

This project provides a comprehensive study of the COVID-19 pandemic in India, including state-wise data, and analyzes the impact of significant events such as lockdowns, election rallies, vaccination drives etc.

Experience

JUL 2025 - PRESENT

Data Analyst at Adani Cement

● Performed data cleaning, transformation, and analysis using Advanced Excel and Power Query to standardize operational datasets for a multi-plant logistics data migration. ● Built Power Query based automated workflows to consolidate and transform datasets from multiple sources, reducing manual processing time by 40–50% and improving reporting efficiency. ● Analyzed operational data to propose Freight and PTPK structures, improving data linearity and consistency, while collaborating with cross-functional teams to validate datasets before migration.

FEB 2025 - JUL 2025

Freelance Analytics Engineer

● Designed, built, and deployed an ETL pipeline on a Linux-based AWS EC2 instance using Python and Pandas to extract data from 5+ APIs, transform it, and load it into a MySQL database. ● Automated the entire ETL workflow to run hourly by creating and scheduling Apache Airflow DAGs, ensuring timely and reliable data update. ● Developed interactive dashboard in Looker Studio, scheduled automated email reports, and set up role-based access control for secure and targeted insights delivery.

OCT 2024 - MAR 2025

Operations Analyst at Licious

● Analyzed operational KPIs such as SLA, drift, and sequence compliance using Power BI and Excel, identifying inefficiencies and improving SLA breaches and FEFO loss by 6%. ● Built automated reporting workflows by integrating Metabase data with Excel (Power Query & M language), reducing manual effort by 20+ hours per month and improving reporting accuracy. ● Performed exploratory data analysis on logistics and inventory data to uncover trends and optimize route planning and inventory control processes.

Education

2019-2023

B.TECH

Gurukula Kangri Vishwavidyalaya, Haridwar, Uttarakhand

2016-2018

Intermediate

S.U College, Nalanda, Bihar

2016

Matriculation

Kiddy Convent High School, Patna, Bihar