Summary
Overview
Work History
Education
Skills
Strengths
Certification
Languages
Timeline

Rajat Kumar

Data Analyst
Bengaluru

Summary

Adaptable and technology-driven data analytics professional with 2 years of experience in asset risk modeling. Skilled in informing strategic decision-making, driving operational efficiency, reducing costs, and lowering risks. Proficient in leveraging analytical tools and critical thinking to collect, manipulate, and validate data from primary and secondary sources. Able to interpret and present complex information to stakeholders in easily understandable terms. Excels in comparing analysis results against set plans to monitor performance and develop remedial plans and interventions when necessary.

Overview

3
3
years of professional experience
6
6
years of post-secondary education
2
2
Certifications

Work History

Integrity Engineer

ExxonMobil Services and Technology Pvt. Ltd.
6 2022 - Current
  • Guided decision-making by collecting, interpreting, and presenting quality data in a clear, timely manner.
  • Synthesized reporting by engineering key performance indicator (KPI) dashboard via Microsoft Power BI and SEEQ and presented them in the Leadership Meeting held in Houston, Texas.
  • Modeled risk for more than 200 assets by analyzing inspection data and presented it to the business team to help facilitate the mitigation of the identified risks.
  • Facilitated the design of various dashboards to help monitor the process data, which resulted in cost optimization of $1M.
  • Used predictive modeling to generate missing data sets and use them to gain insights on inspection data quality, in order to optimize the cost and process.
  • Generated $6M in cost deferrals by taking an initiative of data analysis on cost spent on Preventive Maintenance of Assets vs. Failure rate to optimize the maintenance cycle.
  • Updated and maintained databases by gathering and validating data from primary and secondary resources, while optimizing statistical efficiency and accuracy through utilization of data collection systems and strategies.
  • Managed the day-to-day dealings with service providers through effective communication and setting expectations.
  • Responsible for the overall quality and efficiency of the Service Provider team.
  • Boosted performance by 20% on behalf of the business team by recommending process improvements based on insights gained from in-depth data analytics.

Data Analyst Intern

ABCD
2021.12 - 2022.05
  • Conducted exploratory data analysis on the NYC Airbnb market using Python, R, and SQL.
  • Cleaned, processed, and visualized large datasets to identify patterns and trends in Airbnb listings, including pricing, location, and property types.
  • Built predictive models to analyze factors influencing booking rates and user satisfaction.
  • Utilized data visualization tools, like Power BI, to create interactive dashboards and reports.

Education

Bachelor of Technology - Mechanical Engineering

National Institute of Technology, Jamshedpur, India
2018.07 - 2022.05

Senior Secondary -

Chinmaya Vidyalaya, Bokaro Steel City, India
2016.03 - 2018.05

Skills

SQL + Python

Strengths

Analytical Thinking

Experienced in breaking down complex problems into small, manageable parts, resulting in a comprehensive solution.


Effective Communication

Skilled in translating complex data into clear, understandable insights for stakeholders to  guide decision-making.

Certification

Complete SQL Bootcamp, Udemy

Languages

English
Advanced (C1)
Hindi
Bilingual or Proficient (C2)

Timeline

Data Analyst Intern - ABCD
2021.12 - 2022.05
National Institute of Technology - Bachelor of Technology, Mechanical Engineering
2018.07 - 2022.05
Chinmaya Vidyalaya - Senior Secondary,
2016.03 - 2018.05
Integrity Engineer - ExxonMobil Services and Technology Pvt. Ltd.
6 2022 - Current

Complete SQL Bootcamp, Udemy

SQL Certification, Hackerrank

Rajat KumarData Analyst