Talk to sales Try for Free
Abhishek Kumar Gupta

Abhishek Kumar Gupta

Summer Intern

Followers of Abhishek Kumar Gupta2000 followers
location of Abhishek Kumar GuptaDallas, Texas, United States

Connect with Abhishek Kumar Gupta to Send Message

Connect

Connect with Abhishek Kumar Gupta to Send Message

Connect

  • Timeline

  • About me

    Senior Analyst | MS in Data Science & Analytics | Indian Institute of Technology (IIT)

  • Education

    • University of Oklahoma – Gallogly College of Engineering

      2018 - 2019
      Master of Science - MS Petroleum Engineering 3.73/4.0

      Relevant Courses:1.) Intelligent Data Analytics2.) Data Mining3.) Financial Engineering Analytics4.) Advanced Analytics and Metaheuristics5.) Database Management System6.) Data Structures7.) Advanced Numerical and Statistical Methods 8.) Bayesian Statistics.Practicum Project

    • Indian Institute of Technology (Indian School of Mines), Dhanbad

      2010 - 2014
      Bachelor of Technology (B.Tech.) 8.4/10

      Activities and Societies: Kartavya, Concetto'13, Prakram'12,

  • Experience

    • Vedanta Resources Limited

      Jun 2013 - Jul 2013
      Summer Intern

      • Made diagnostic plots out of given database to analytically identify problems and provided recommendations for improvement

    • Vedanta Resources Limited

      Jul 2014 - Aug 2017
      Operations Analyst

      • Monitored and analysed data through multiple sources and built in dashboards for daily analysis• Analyzed, maintained and performed data analytics on a huge database with records over 15 years and helped improve production by 15% • Presented the summary analysis through different Data Visualization techniques, Dashboards to the team members every week to take informative decisions reducing the operational costs by 20%. • Cross functional team interactions for the successful implementation of the identified opportunities.• Preparing weekly Line of Business (LOB) reports• Provided training/mentoring to new members of the team and interns on several technical aspects and day to day to job functions. • Monthly Production allocation, Quarterly Performance Reports (QPR) preparation, reporting to queries and data required for the business partners reporting while maintaining all the database Show less

    • University of Oklahoma

      Aug 2017 - Dec 2019
      Graduate Research Assistant

      • Designed and conducted experiments researching the current trends in Energy industry.• Obtained continuous data (per second frequency over the period of 10-60 days) using VBA based software. • Continuously monitored the trends and performed data analysis.• Presented my research work to Consortium meetings.

    • Xyant Services

      May 2019 - Jul 2019
      Jr. Data Analyst (Summer Intern)

      • Designed a prototype of the software meeting company objectives and their customer requirements. • Set up cloud services (IaaS, PaaS, SaaS) using AWS EC2 and developed program using Jupyter notebook and R studio. • Developed a software using Python for Exploratory Data Analysis (EDA), Data Visualization, Pattern Recognition and Recommendation. • Conducted Data analysis and prepared dashboards using power BI to communicate analytical observations effectively.• Added different features like Natural Language Processing (NLP), Text Analytics, Missing Data Handling, Outlier Detection, summary and analysis for different kinds of dataset. • Different techniques including KNN, Mean Imputation, Regression Imputation were implemented for missing data handling.• Statistical summary including Mean, Median, Mode, Variance, Standard Deviation, Quantile, Percentile etc., of numeric attributes were provided.• Text analytics of words, pdf or text data to identify the text sentiments and provide text keywords through visualization like WordCloud, Bar graphs & charts.• Successfully tested the program using different datasets like New York city job postings, UFO sightings, good read books, Australian election tweets etc., obtained through Kaggle.com• Packages used: NumPy, Pandas, SciKit-learn, Matplotlib, nltk, RegEx, wordcloud Show less

    • PCI Energy Solutions

      May 2020 - now

      • Senior Analyst

        Jan 2023 - now

      • Analyst

        May 2020 - Dec 2022

  • Licenses & Certifications

  • Honors & Awards

    • Awarded to Abhishek Kumar Gupta
      Going Extra Mile (GEM) Award - Jul 2017 Awarded "Going Extra Mile (GEM) award" in recognition to my dedicated efforts during Polymer Injectivity Test as a Production Optimization engineer in the Bhagyam asset of Cairn.
    • Awarded to Abhishek Kumar Gupta
      Going Extra Mile (GEM) Award - Apr 2016 Awarded “Going Extra Mile (GEM) Award” in recognition of my dedicated efforts during my stint in Mangala asset of Cairn.
    • Awarded to Abhishek Kumar Gupta
      Pat on the back Cairn Oil and Gas Apr 2015 Awarded “Pat on the Back” for my contribution to the successful execution of Polymer start-up of Mangala Field.
    • Awarded to Abhishek Kumar Gupta
      Merit cum Means Scholarship Government of India May 2010 • Recipient of the "Merit cum Means" scholarship for the 4 consecutive years throughout my Undergraduate studies.

  • Volunteer Experience

    • Student Volunteer

      Issued by The Big Event at The University of Oklahoma on Mar 2018
      The Big Event at The University of OklahomaAssociated with Abhishek Kumar Gupta

    • Class Teacher

      Issued by Kartavya on Aug 2010
      KartavyaAssociated with Abhishek Kumar Gupta