Chandan Kumar

Data Analysis and Visualization:

• Proficient in MS Excel (advanced functions, Pivot Tables, Power Query) for in-depth analysis, trend identification, and reporting.
• Skilled in creating Power BI dashboards and reports to present business-critical data in an interactive and easily digestible format for stakeholders.
• Proficient in DAX query for cleaning the data set.

SQL and Database Management:

• Expertise in writing complex SQL queries to extract, transform, and load (ETL) data from relational databases (MySQL, SQL Server).
• Comfortable with data cleansing and manipulation techniques, ensuring data quality and integrity across all stages of analysis.

Python & Data Science Libraries.

• Strong proficiency in Python, with a focus on Pandas and NumPy for data manipulation, statistical analysis, and exploratory data analysis (EDA).
• Hands-on experience in automating repetitive data tasks and conducting advanced analyses using Python-based libraries.

Big Data Analysis with PySpark:

• Familiar with PySpark for handling and processing large-scale datasets, optimizing data pipelines, and running distributed computations in a big data environment (Hadoop, Spark clusters).

Data Analysis and Visualization:

• Proficient in MS Excel (advanced functions, Pivot Tables, Power Query) for in-depth analysis, trend identification, and reporting.
• Skilled in creating Power BI dashboards and reports to present business-critical data in an interactive and easily digestible format for stakeholders.
• Proficient in DAX query for cleaning the data set.
• Comfortable with data cleansing and manipulation techniques, ensuring data quality and integrity across all stages of analysis
• Preparation of daily planning, weekly planning.
• RM planning, billet cutting plan, hot mill process sheet, finishing mill process sheet.
• Making of daily production reports, bundling report, hot mill production report and monthly report.
• Daily stock report maintaining and checking system vs. actual, rejection.
• WIP follow-ups, customer urgencies.
• Support the production team by accurate delivery of orders and giving accurate information on inventory situation.
• Responsible for production planning for all operations and controlling production planning.
• Raw material cutting planning as per customer requirement.
• Taking physical stock at regular intervals and updating physical vs. system WIP.
• Reporting to– Manager- PPC.
• United Seamless is a Seamless Pipe manufacturing unit used in the Oil & Gas exploration and distribution industry. US manufactures Drill pipe, Casing pipes, Line pipes, Coupling Pipes of Size range 114 mm to 356 mm used in oil exploration with annual capacity of 350,000 MT. United Seamless is API 5CT, API 5L licensed company with API Q1 & ISO 9001:2015 QMS Certifications.