Worked on Python, NX, etc., transformed raw data files provided by the client
into a structured, application-ready state for further use
Used Python's os module to automate traversal through nested folder
hierarchies, and searched zip files
Utilized the zipfile module to extract the contents of zip files, dynamically
creating output directories based on file extensions
Deployed PyMuPDF to process PDF files, extract embedded attachments
(.prt, .csv, .igs, .stp, .log), and organize them into folders by their extensions
using os
Automated error handling for corrupt zip files, using detailed reports for client
follow-up on invalid datasets
Used tqdm to display real-time progress for operations on large datasets
Integrated Tkinter to design simple graphical interfaces for enhancing user
interaction during file processing tasks
Automated recursive searches for specific part files across nested directories
used the .NET Framework library (System, System.IO) and C#
CAD automation for conversion of PRT files to JT files in Siemens NX by
configuring tessellation parameters for multi-level LOD outputs, balancing
model accuracy using PvtransManager, NXOpen API, and C#
Airbus:
VBA Scripting (macros) for auto renaming of tree structure of CAD model by
taking input from excel
Collaboration with all the departments to understand their workflows,
documentation, and analyze inter-departmental data flows in the aircraft
manufacturing industry
Requirement analysis for PLM, based on understanding of the organization's
needs via the above study
Identified and Documented Process Inefficiencies: Used data analysis to
uncover inefficiencies, bottlenecks, and potential improvements across
workflows, providing actionable insights to streamline operations
Developed PLM Requirements Based on Data-Driven Insights: Defined
critical requirements for PLM software by analyzing organizational needs and
mapping functional requirements for digitalization
Other Projects:
Model detail part in CATIA for airbus, quality check for their part
Read and understand the engineering drawing of Boeing to find out the
optimum stock size for their detail parts.
Education
Master Of Technology - Manufacturing Engineering
Indian Institute of Technology
July 2022
Skills
95/
Bold Profile
SKILLS
Data Engineering:
PySpark, Pandas, NumPy
SQLAlchemy, SQL, MySQL
ETL
Python:
PyMuPDF, Matplotlib
Seaborn, Plotly, zipfile
PyPDF2, shutil, os, tqdm
Pillow, tkinter
VBA scripting:
Macros in CATIA, MS Office
NX VB Journal, and NET, C#
Advanced Excel:
VLOOKUP, HLOOKUP
INDEX-MATCH, Pivot Tables
Pivot Chart, Power Query
And advanced text functions
(TEXT, LEFT, MID, FIND, etc)
Logical functions (IF
IFERROR), and statistical
Functions (SUMIFS
COUNTIFS, AVERAGEIFS)
Power BI, Tableau
Accomplishments
I have worked on Python, Pandas, Numpy, SQL, Seaborn, Matplotlib, VBA(Macros), NX VB Journal
I
have worked in Aerospace industry for 2.5 years on Project Management, Automation
Documentation, Cross Collaboration
I have hands-on proficiency on Pyspark, .NET
My ambition is to
switch to IT field completely
1
Time Series Analysis (S&P 500 Stock Market Case Study)
Brief: Analyzed historical stock data to observe price changes, calculate moving
averages, study Apple's closing price trends, perform resampling, multivariate analysis
for correlations, and assess stock relationships
Skills:
Data Analysis: Pandas, NumPy for time-series processing
Statistical Analysis: Correlation and resampling techniques
Visualization: Matplotlib, Seaborn for trend analysis
Programming: Python for data manipulation and analysis
Sales Data Analysis (E-Commerce Case Study)
Brief: Analyzed monthly sales trends, identified top-performing cities and products,
examined sales trends of popular products, and analyzed products frequently sold
together
Skills:
Data Aggregation: Pandas for grouping and filtering
Visualization: Seaborn, Plotly for comparative insights
Business Analysis: Identifying trends and patterns in sales data
Python Libraries: Itertools for co-occurrence analysis
Sentiment and Textual Analysis of YouTube Comments
Brief: Analyzed viewer sentiments and engagement on YouTube videos by examining
comment data
Focused on sentiment polarity (positive/negative), frequent words, and
emoji usage patterns
Skills Used:
Data Collection: Using YouTube Data API or web scraping tools
Text Preprocessing: Removing special characters, tokenization, and stop-word
removal
Sentiment Analysis: Pre-trained models like TextBlob
Emoji Analysis: Extracting and analyzing emoji usage and sentiment patterns
Word Cloud Generation: Using Python libraries like WordCloud
Visualization: Matplotlib, Seaborn, or Power BI for interactive dashboards.
Production Officer at TATA ADVANCED SYSTEM LIMITED(TATA Aerospace & Defence)Production Officer at TATA ADVANCED SYSTEM LIMITED(TATA Aerospace & Defence)