Data Analyst Power BI Python SQL Turning Data into Impact

Ashish Bonde

HOBBYS

Language Skills

Languages Level

German C1.1

English C1

Sanskrit A1

Marathi Mother Tongue

Hindi Mother Tongue

Digital Skills

Professional Experience

India

Page 1 of 2

Data Science Intern

ONLEI Technologies.

SEP. 24 – TILL DATE

Github

Octocat

Simplified

Icon

Pune, India

Created and updated installation instructions, parts catalogs, repairable parts listings, exploded diagrams, and RPG manuals for 6 Series tractors and plant care products, ensuring accurate technical documentation and streamlined publishing in downstream applications.

John Deere

Cyient

1 JUN. 21 – 31 JUL. 23

Pune, India

Technical Editor/Translator

Speed Engineering PVT LTD.

4 AUG. 23 – 19 FEB

Bastra GmbH (3-week on-site training in Germany)

Alstom (Bombardier Transport)

Updated maintenance manual for the FU Zurich and FU Basel for bogie frames. Listen to calm music Meditation

Projects:

Customer Management System GitHub

• Designed a user-friendly UI with Streamlit for seamless data entry, deletion, and modification. Pandas structured data efficiently, while MySQL Connector linked Python to the SQL database for optimized operations. Drowsiness Detection System GitHub

• In this application, Streamlit GUI handles visual data input (image/video). Deep learning models built with TensorFlow & Keras extract features, while OpenCV processes the visual input. Pillow & SciPy assist in data processing and prediction with the pre-trained model. Pygame triggers audio alarms in predefined situations. Amazon Product Review Extractor & Sentiment Analysis GitHub

• Streamlit-based GUI application that fetches HTML content using Requests, with BeautifulSoup parsing it to extract reviews. Pandas structurizes the data, while NLTK processes natural language & VaderSentiment analyzes sentiment. Plotly Express visualizes insights, providing a clear and dynamic representation of consumer opinions. AdventureWorks Sales Dashboard with Power BI GitHub

• ETL & Data Preparation: Extracted, cleaned, and prepared data from Kaggle CSV files using Power Query Editor.

• Data Modeling: Designed Star-Flake Schema with two fact and five dimension tables.

• DAX: Created calculated columns and measures for essential insights.

• Visualizations: Developed dashboards with meaningful charts for decision-making. Experienced Mechanical Engineer with 5+ years in Machining, CAD, and technical documentation analysis for Automotive and Railway Systems, including brief experience in Germany. Proficient in translating complex German technical documentation into English with precision. Developing deep expertise in data-driven insights with a strong foundation in ML, Deep Learning, Power BI, Python, and SQL.

Pune, India

Freelance Translator (German Technical Manuals)

Sep. 24 – TILL DATE

Completed a three-week technical training at Bastra GmbH, Germany, focusing on product understanding, technical writing, and CAD, while independently updating operating manuals for food processing systems.

(Language-German)

(Language-English)

(Language-German)

Hyderabad, India

Alstom

27 MAY 24 –10 SEP. 24

(Language-German)

Worked on illustration tasks due to consistent delays in the German documentation project.

Python Streamlit

Pandas

Excel SQL

Power BI

ETL

Machine Learning

Data Modelling

Jupyter Notebook

Data Analyst

+91-848******* ***************@*****.*** Pune

Volunteer Experience

ALLGEMEINE UND BERUFLICHE BILDUNG

Automotive Plastic Trim module with Catia V5

Digital Cad-training Pune, India

https://digitalcadtraining.com/contact.html

17 DEZ. 21 – 20 FEB. 22

German Language B1, B2, C1.1 (Certificate)

MMB Goethe Pune, India

4 NOV. 19 – 10 JUL. 20

https://www.goethe.de/ins/in/en/sta/pun.html

Bachelor of Engineering (Mechanical Engineering - 4 years) Pune University Pune, India

11 AUG. 14 – 1 JUL. 17

http://www.unipune.ac.in/

Diploma in Mechanical Engineering (3 years)

Government Polytechnic Sakoli Nagpur, India

1 SEP. 09 – 1 JUL. 12

https://www.gpsakoli.ac.in/

http://www.dtemaharashtra.gov.in/index.html

• Worked as Jr. Quality Trainee Supervisor for heavy mechanical processes such as drilling, milling on horizontal machining centers. Junior Quality Trainee Supervisor

Pawan Engineering Works

4 JUL. 12 – 5 AUG. 14

Pune, India

CFD Intern

A2 Research and Innovation Centre

27 JUL. 17 – 31 JUL. 18

Page 2 of2

• Worked on the Computational Fluid Dynamics (CFD) analysis of a gearbox to predict temperature rise, lubrication quality, frictional, and wind losses to increase the transmission efficiency by minimizing various losses such as frictional losses, using different types of oils. Research work published in IJSRD ISSN - 23210613 Barcode -IJSRDVSI110243 No. - 348236.

Pune, India

• Volunteer Member of Shri Sadguru Shakti Yuvak Manch, Bhugoan Pandharpur, Dist. - Bhandara.

• Founding Member and Former Vice President of Shri Sadguru Shakti Yuvak Manch, Bhugoan Pandharpur, Dist. Bhandara.

Sant Videhi Motiram Baba Atmpravartak Sansthan Rg. No.700, Bhugoan Pandharpur, Tal. -Lakhani, Dist. –Bhandara, India. Professional Experience

Pune, India

CADTrainee and Project Engineer

Mechsys Engineering Company

20AUG.18–1NOV.19

• As a project engineer, Supervised the manufacturing of bag filter units for dust separation and developed specialized tools, including holding fixtures, to optimize production.

Contact this candidate