Headline

Final year Student at IIT(ISM) Dhanbad

About

Data enthusiast with strong skills in Python, SQL, and Excel, focused on transforming raw data into meaningful insights through structured analysis. Experienced in data cleaning, exploratory data analysis (EDA), feature engineering, statistical analysis, and visualization, with a strong interest in uncovering patterns, identifying trends, and supporting data-driven decision making. Through academic projects and independent work, I have analyzed complex datasets to derive actionable insights using tools such as Pandas, NumPy, Matplotlib, and SQL, while applying analytical thinking to solve real-world problems. I enjoy working with large datasets, building clear visualizations, and translating analytical results into understandable insights. Alongside my data analytics journey, I am currently a final-year Petroleum Engineering student and completed an internship at Oil and Natural Gas Corporation Limited at the Institute of Reservoir Studies, where I analyzed multi-decade reservoir datasets to evaluate field performance and estimate key reservoir parameters using analytical tools such as MBAL and Excel. I am particularly interested in applying data analytics across complex technical domains, while continuing to expand my skills in data analysis, problem solving, and insight generation.

Location

Kalyan

Work experience

Summer Intern at Oil and Natural Gas Corporation Limited (ONGC), May 2025 - Jun 2025 · 2 mos, Ahmedabad, Gujarat, India, Examined large-scale production, injection, and pressure data from 20+ wells to identify performance trends. Built structured analytical workflows using MS Excel on 50+ years of historical data to estimate key performance metrics, conduct time-series analysis and support data-driven decision making. Generated evaluation studies for recovery performance and translated findings into clear, actionable visual reports.

Head Industrial Relations at SPE IIT (ISM) Student Chapter, Apr 2024 - Mar 2025 · 1 yr, Dhanbad, Jharkhand, India

Moderator at SPE IIT (ISM) Student Chapter, May 2023 - Apr 2024 · 1 yr, Dhanbad, Jharkhand, India

Relations at SPE IIT (ISM) Student Chapter, May 2023 - Apr 2024 · 1 yr, Dhanbad, Jharkhand, India

Winter Trainee at Oil and Natural Gas Corporation Limited (ONGC), Dec 2024 - Dec 2024 · 1 mo, Ahmedabad, Gujarat, India, Acquired practical knowledge of surface facilities, reservoir optimization (MBE, DCA), and well-logging techniques for formation analysis through field visits and studies at ONGC Ahmedabad Asset. Explored reservoir properties and Enhanced Oil Recovery (EOR) methods, during lab visit at the Institute of Reservoir Studies (IRS)

Moderator at FIPI IIT (ISM) Student Chapter, May 2023 - Apr 2024 · 1 yr, Dhanbad, Jharkhand, India

Industrial Relations at FIPI IIT (ISM) Student Chapter, May 2023 - Apr 2024 · 1 yr, Dhanbad, Jharkhand, India

Education

Bachelor of Technology - BTech, Petroleum Engineering, Indian Institute of Technology (Indian School of Mines), Dhanbad

HSC, PCM, kendriya vidyalaya

Public links

github: https://github.com/dhairyag22