Aurora Adair

Data Analyst

Delhi 0+ yrs exp 81 · Excellent

About

Detail-oriented Data Analyst fresher with a background in Mechanical Engineering and hands-on experience in data analysis through academic and real-world projects. Skilled in Python, SQL, Excel, and Power BI for data cleaning, analysis, reporting, and dashboard creation. Strong analytical mindset with internship experience and a Pre-Placement Offer (PPO) from LTTS.

Skills & Expertise (38)

MS Excel Advanced

7.0/10

Years Exp

Excel Advanced

7.0/10

Years Exp

Python Intermediate

6.5/10

Years Exp

SQL Intermediate

6.5/10

Years Exp

Pivot Tables Intermediate

6.5/10

Years Exp

Power BI Desktop Intermediate

6.5/10

Years Exp

Pandas Intermediate

6.0/10

Years Exp

Conditional Formatting Intermediate

6.0/10

Years Exp

Index-match Intermediate

6.0/10

Years Exp

VLOOKUP Intermediate

6.0/10

Years Exp

XLOOKUP Intermediate

6.0/10

Years Exp

Pivot Charts Intermediate

6.0/10

Years Exp

Interactive Dashboards Intermediate

6.0/10

Years Exp

Dashboard Development Intermediate

6.0/10

Years Exp

Data Visualization Intermediate

6.0/10

Years Exp

Data Cleaning Intermediate

6.0/10

Years Exp

Exploratory data analysis Intermediate

6.0/10

Years Exp

NumPy Intermediate

6.0/10

Years Exp

MySql Intermediate

6.0/10

Years Exp

Tableau Intermediate

6.0/10

Years Exp

Hypothesis Testing Intermediate

5.5/10

Years Exp

Matplotlib Intermediate

5.5/10

Years Exp

Data Storytelling Intermediate

5.5/10

Years Exp

Statistical Analysis Intermediate

5.5/10

Years Exp

Regression Analysis Intermediate

5.5/10

Years Exp

Data Transformation Intermediate

5.0/10

Years Exp

ETL Processes Intermediate

5.0/10

Years Exp

DAX Intermediate

5.0/10

Years Exp

Power Query Intermediate

5.0/10

Years Exp

MongoDb Intermediate

5.0/10

Years Exp

Predictive Analytics Intermediate

5.0/10

Years Exp

K-Means Clustering Intermediate

5.0/10

Years Exp

MySQL WorkBench Power BI GitHub Git Orange Data Mining Google Colab

Work Experience

Graduate Engineer Intern

Larsen & Toubro Technology Services (LTTS)

Jan 2022 - May 2022

Developed a gantry loader system for CNC turning machines, focusing on mechanical design and process logic optimization. Utilized CAD and CAE tools to analyse component feasibility and motion sequences for system. Awarded a Pre-Placement Offer (PPO) for demonstrating high technical proficiency and a systematic approach to problem-solving.