Chandan Kumar Majhi

CHANDAN KUMAR MAJHI 📞 - , ✉️-www.linkedin.com/in/reachoutchandan SUMMARY • Results-oriented Data Analyst with strong skills in ,Python, SQL, and advanced Excel, specializing in data cleaning, transformation, and visualization. Experienced in predictive modeling, mechanized data pipelines, and actionable dashboard reporting to support strategic decisions. Passionate about applying machine learning to solve complex business challenges. • Skilled in data modeling, reporting, and automation,and data modeling to solve complex business problems. WORK HISTORY TraceLink (FreeLancer) 02/2025 – 05/2025 Project: Repository Change Log Automation Tool Python , Tkinter , Pandas , Excel , Data Visualization • Developed a Python/Tkinter-based repository change log management tool, enabling users to track, filter, and compare metadata changes across multiple Excel-based files. • Implemented dynamic filtering and reporting features 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, improving stakeholder decision-making and transparency. Pepsico (FreeLancer) 09/2024 – 02/2025 Supply Chain Cost Optimization using Machine Learning • 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. • Language used: ,Python Customer churn prediction with machine learning Problem Statement- Analyzing Customer Churn to Identify Key Influencing Factors Insights- • Conducted exploratory data analysis on 10,000+ customer records, identifying five key drivers of churn. • Cleaned and preprocessed data to achieve 100% quality and eliminate missing or erroneous entries. • Developed a classification model with an 89% churn prediction accuracy, supporting proactive retention strategies. • Visualized customer behavior and churn trends with advanced data storytelling techniques to inform business stakeholders. Language used: ,Python Libraries used: NumPy, Pandas, Matplotlib, Seaborn, and Scikit-learn SKILLS • Python • Pandas , Numpy , Matplotlib , Seaborn , Scikit-Learn • MySQL • Advanced Excel , Power-BI • Univariate Analysis , Bivariate Analysis ,Feature Engineering , Feature Selection , Imputation Method, Feature Scaling , Machine Learning ,Statistical Analysis, Predictive Modeling , Data cleaning , AI Automation , Data Analysis • Data handling , API • Jupyter Notebook, Spyder, Google Colab , Synapse , AzureML , DataBricks , Jira , Confluence EDUCATION B.Tech in Computer Science Nalanda Institute of Technology CSGP 8.4/10.0 Aug 2020-June 2024 Bhubaneswar ------------------------------------------------------------------------------------------------------ Intermediate(+2), PCM Fakir Mohan Higher Secondary School 09/2018 - 05/2020 Balasore ------------------------------------------------------------------------------------------------------ Schooling (10th) Govt U.G High School 06/2018 Bhadrak SOFT SKILLS • Teamwork • Analytical skills • Problem-solving • Critical thinking • Communication • Performance Optimization • Project Management • Attention to Detail CERTIFICATION • Complete NASSCOM certified full-stack data science from Naresh-IT. • Complete SQL from Udemy. • Complete EXCEL from Udemy. • SQL Skills Certification,Hacker Rank. • Internship Accenture North America - Data Analytics and Visualization