Hi, I’m Chandan Kumar Majhi, a results-oriented Data Analyst proficient in Python, SQL, and advanced Excel. I specialize in data cleaning, transformation, and visualization to drive strategic decisions, and I am passionate about applying machine learning to solve complex business challenges and build scalable data pipelines and dashboards. I thrive on turning data into actionable insights that support stakeholders and improve processes. I have hands-on experience delivering analytics across supply chain optimization and customer analytics, with a focus on reproducibility and clear storytelling. I enjoy collaborating with cross-functional teams, continuously learning new techniques, and turning data into meaningful impact for business success.

Chandan Kumar Majhi

Hi, I’m Chandan Kumar Majhi, a results-oriented Data Analyst proficient in Python, SQL, and advanced Excel. I specialize in data cleaning, transformation, and visualization to drive strategic decisions, and I am passionate about applying machine learning to solve complex business challenges and build scalable data pipelines and dashboards. I thrive on turning data into actionable insights that support stakeholders and improve processes. I have hands-on experience delivering analytics across supply chain optimization and customer analytics, with a focus on reproducibility and clear storytelling. I enjoy collaborating with cross-functional teams, continuously learning new techniques, and turning data into meaningful impact for business success.

Available to hire

Hi, I’m Chandan Kumar Majhi, a results-oriented Data Analyst proficient in Python, SQL, and advanced Excel. I specialize in data cleaning, transformation, and visualization to drive strategic decisions, and I am passionate about applying machine learning to solve complex business challenges and build scalable data pipelines and dashboards. I thrive on turning data into actionable insights that support stakeholders and improve processes.

I have hands-on experience delivering analytics across supply chain optimization and customer analytics, with a focus on reproducibility and clear storytelling. I enjoy collaborating with cross-functional teams, continuously learning new techniques, and turning data into meaningful impact for business success.

See more

Work Experience

Repository Change Log Automation Tool Developer at TraceLink
February 1, 2025 - May 1, 2025
Developed a Python/Tkinter-based repository change log management tool to track, filter, and compare metadata changes across multiple Excel-based files. Implemented dynamic filtering and reporting to monitor data model evolution across daily, weekly, monthly, and yearly ranges, enhancing metadata traceability. Automated schema extraction and JSON validation with WinMerge integration, ensuring version control and reducing manual review effort by ~30%. Optimized data handling with Pandas, supporting on-demand exports of change logs to Excel with clear formatting and conditional styling. Visualized daily engagement metrics with Matplotlib dashboards to improve stakeholder decision-making and transparency.
Customer Churn Prediction with Machine Learning at Pepsico
September 1, 2024 - February 1, 2025
Conducted exploratory data analysis on 10,000+ customer records, identifying five key drivers of churn. Cleaned and preprocessed data to achieve high quality and eliminate missing or erroneous entries. Developed a classification model with 89% churn prediction accuracy to support proactive retention strategies. Visualized customer behavior and churn trends to inform business stakeholders.
Supply Chain Cost Optimization using Machine Learning at Pepsico
September 1, 2024 - February 1, 2025
Engineered a Random Forest regression pipeline to forecast freight and storage costs, achieving an RMSE of approximately 170 for improved cost estimates. Supported data-driven routing and warehouse decisions that enabled more cost-effective supply chain operations. Systematized feature engineering and model evaluation processes to ensure consistent and reproducible results.

Education

B.Tech in Computer Science at Nalanda Institute of Technology
August 1, 2020 - June 1, 2024
Intermediate (+2) PCM at Fakir Mohan Higher Secondary School
September 1, 2018 - May 1, 2020
Secondary Education (10th) at Govt U.G High School
January 11, 2030 - June 1, 2018

Qualifications

NASSCOM certified full-stack data science
January 11, 2030 - December 1, 2025
SQL Skills Certification
January 11, 2030 - December 1, 2025
Excel Certification
January 11, 2030 - December 1, 2025
SQL Skills Certification, HackerRank
January 11, 2030 - December 1, 2025
Internship Accenture North America - Data Analytics and Visualization
January 11, 2030 - December 1, 2025

Industry Experience

Software & Internet, Professional Services, Education