Summary
Overview
Work History
Education
Skills
Projects
Awards
Languages
Timeline
Generic

Ritik Saxena

Noida

Summary

At TechnipFMC, I excelled as an Associate Data Analyst, mastering SQL, Python, and Power BI to deliver transformative data insights and interactive dashboards across global regions. My analytical prowess and effective communication skills led to significant data-driven decisions, showcasing my ability to turn complex data into actionable intelligence.

Overview

1
1
year of professional experience

Work History

Associate Data Analyst

TechnipFMC
Noida
10.2023 - Current
  • Serve as data analyst for procurement team.
  • Responsible for managing all data analytics tasks.
  • Developed interactive dashboards utilizing Power BI and DAX Query language.
  • Demonstrated proficiency in managing PostgreSQL, MySQL using advanced SQL skills.
  • Developed expertise in Snowflake data warehouse solutions.
  • Skilled in Python with expertise in data-related libraries including Pandas, Numpy, Matplotlib, Seaborn and Plotly.
  • Directed comprehensive data analysis across several regions such as North America, France, APAC, and Noida.

Education

10th Class -

St Mary's convent sr. sec school
Amroha, UP
03.2016

12th Class - PCM

St Mary's convent sr. sec school
Amroha, UP
03.2016

JEE Prep. -

Allen Career Institute
Kota, Rajasthan
03.2016

Btech - IT

Ajay Kumar Garg Engineering college
Ghaziabad, UP
03.2016

Skills

  • SQL
  • Python
  • DAX
  • Power BI
  • Pandas
  • NumPy
  • Matplotlib
  • Plotly
  • Seaborn
  • Excel

Projects

  • Capacity Utilization Dashboard.

Head Count & Capacity Utilisation real time dashboard, Professional Project, In my organisation currently I am working on a capacity utilisation dashboard, where my focus is to find real time capacity utilisation of every employee according to their processes., I am using Snowflake data warehouse for gathering the data of different processes with the help of SQL., I import data in Power BI, do data cleaning, restructuring dataset and then I have built one to many relationships between all the datasets via common dataset., I have used DAX query language for creating calculated columns and calculated measures., After I finished all the backend part I designed a dashboard for the director.

Apart from this project, I have worked over 30 projects related to data analytics in TechnipFMC.

  • Apple Iphone sales dashboard.

 Apple Iphone sales dashboard, Personal Project, I have done data analysis using Python, I gathered the raw uncleaned CSV data using Pandas, I cleaned that data using Pandas, performed some data manipulations in the dataset and with the help of Plotly library I have created its interactive visuals., And so far I have worked on 30 projects of data analytics in my organisation and apart from that I have developed my personal projects as well using Python, SQL, Power BI.

Awards

  • Testdome GOLD certification in MS Excel.
  • Udemy Certification in Power BI
  • TPC Global Certificate
  • NPTEL ELITE Certificate
  • SELP Certificate
  • Certification in python

Languages

  • Hindi
  • English

Timeline

Associate Data Analyst

TechnipFMC
10.2023 - Current

10th Class -

St Mary's convent sr. sec school

12th Class - PCM

St Mary's convent sr. sec school

JEE Prep. -

Allen Career Institute

Btech - IT

Ajay Kumar Garg Engineering college
Ritik Saxena