Chandan Nath

Senior Data Analyst · GenAI · SQL · Python

Rourkela, Odisha, India

@chandannath22807913

0 followers

Looking for jobs Open to relocating

About

Results-driven analytics professional with 9+ years of experience in manufacturing and operations, with strengths in data analytics, business intelligence, SQL, Python, Tableau, and ETL automation. Experienced in building automated insight-generation pipelines using Generative AI and LangChain, developing dashboards, and improving operational visibility and reporting efficiency.

Experience

Assistant Manager

Shri Mahavir Ferro Alloys Pvt. Ltd. · Rourkela, India

Jan 2022 – May 2026

Built end-to-end Tableau dashboards for production and operations KPIs using SQL and Python, reducing report turnaround from 2 days to same-day and improving executive visibility by 30%. Conducted root cause analysis on machine and production data using Python and SQL, reducing unplanned downtime by 15% and saving an estimated ₹8–12L/year in lost production costs. Automated weekly and monthly reporting workflows using Google Apps Script and ETL pipelines, eliminating 15+ hours of manual effort per week across a team of 5. Built a Generative AI-powered steel plant energy monitoring pipeline using LangChain, analyzing 35,040 data points and automatically delivering AI-generated insights and five analytical charts to Slack with zero manual intervention. Designed and deployed a Paperless Factory Analytics System across 3 departments, replacing manual data entry and improving data accuracy by 25% with real-time tracking. Built structured ETL pipelines consolidating data from 4+ operational sources, reducing data preparation time by ~35% and improving reporting reliability and governance. Delivered variance analysis across cost and production metrics using advanced Excel and Python, directly contributing to a 10% reduction in operational costs over 12 months.
IT Senior Executive

Shri Mahavir Ferro Alloys Pvt. Ltd. · Rourkela, India

Feb 2017 – Dec 2021

Developed custom operational tracking tools using AppSheet and Google Sheets for logistics, production, and inventory management, improving reporting speed by 20% across 3 operational teams. Reduced data inconsistencies by 30% by designing and enforcing data validation and cleaning frameworks across key operational datasets used by 50+ daily users. Built production and inventory dashboards used daily by operations managers, cutting time-to-insight from hours to under 15 minutes and supporting faster procurement decisions. Trained 20+ cross-functional staff on analytics tools and dashboards, improving data adoption and reducing dependency on IT for routine reporting by ~40%. Delivered weekly business insight reports to senior management covering production scheduling, logistics, and inventory, enabling data-driven decisions that improved operational efficiency by 20%.

Education

2010

Bachelor of Technology

Purushottam Institute of Engineering & Technology

Computer Science · 2006 – 2010

Computer Science · 2006 – 2010

Skills

8 to 10 years

SQL Python Business Intelligence Dashboard Development

2 to 5 years

KPI Tracking Data Cleaning Data validation Data Storytelling Root Cause Analysis

<3 months

LangChain etl pipeline Data Modeling Data Wrangling Decision Support Prompt Engineering Statistical Analysis Process Optimization AppSheet No-Code App Development Generative AI (ChatGPT, Copilot, Gemini)

Tools / apps / platforms

2 to 5 years

Slack Tableau Google Sheets Microsoft Excel Google Apps Script

<3 months

Google Colab

Courses & certifications

Professional Certificate Program in Data Analytics & Generative AI · IIT Guwahati – E&ICT Academy · 2026

Explore the Broxer community

💬 Q&A Ask about roles, salaries and interviews — and help others. 👥 Circles Join discussions on skills, companies and industries. 📰 Feed Follow updates and insights from the community.