Nayan D. Gajara
Pune
Summary
Certified SQL Developer and Data Analyst with proficiency in data analysis tools including SQL, Python, and Excel. Strong analytical skills with experience in statistical data analysis, data visualization, and database management. Adept at creating comprehensive reports, developing predictive models, and collaborating with crossfunctional teams to enhance data processes and drive strategic decision-making. Demonstrates attention to detail and excellent communication skills in presenting complex data insights to stakeholders.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Data Science Intern
Meritshot
12.2023 - 03.2024
- Conducted SQL-based data analysis to interpret complex data sets and identify trends and patterns, supporting strategic decision-making
- Prepared comprehensive reports and visual presentations of analysis findings for stakeholders, effectively communicating insights to business leaders
- Collaborated with cross-functional teams to improve data collection and processing methods, enhancing data integrity and accessibility
- Assisted in designing and maintaining databases using SQL to ensure data accuracy and streamlined operations
Data Science Intern
Bharat Intern
09.2023 - 11.2023
- Developed and implemented SQL queries and data collection systems to optimize data quality and reporting efficiency
- Provided regular updates and insights to project managers regarding data trends and project success metrics, aiding in data-driven decision-making
- Assisted in creating data-driven strategies for improved product development and engineering processes, leveraging analytical skills to enhance business outcomes
Data Analyst Intern
Gamaka Intellectual Machines
01.2023 - 04.2023
- Company Overview: London, UK
- Utilized Python and SQL for data analysis to extract insights and build predictive models, supporting operational efficiency
- Created dashboards and visualizations using Tableau and Power BI to communicate data trends and findings to stakeholders, enhancing data comprehension
- Gained experience in HTML, CSS, and JavaScript for content design and management, contributing to effective communication strategies
- London, UK
Programmer Analyst Trainee
Cognizant Technology Solutions
02.2022 - 06.2022
- Created test plan and test strategy
- Involved in designing of automation testcases using selenium webdriver, Java, TestNg, maven and Jenkins
Education
Full Stack Diploma - Data Science &AI
Gamaka Artificial Intelligence Solutions
Pune, MH01.2023
B. E - Civil Engineering
Dr. D. Y. Patil Institute of Engineering Management& Research
Pune, MH01.2022
HSC -
Shri Krishna School
Jamnagar, GJ01.2018
SSC -
Shri Gnan ganga School
Jamnagar, GJ01.2016
Skills
- Python
- SQL
- Matplotlib
- Seaborn
- Tableau
- Power BI
- Beautiful Soup
- Data Extraction
- Pandas
- Web Scraping
- Predictive Analysis
- PCA
- Text Analytics
- Strong problem solving & analytical skills
- Univariate analysis
- Bi-variate analysis
- Regular Expressions
- Scrapy Framework
- Web Crawling
- XPath
- Classification
- Regression
- Clustering techniques
- Decision trees
- CNN
- ANN
- RNN
- LSTM
- General Office
- Presentation
- Power Automate Desktop
- Data Analysis
- Strong Analytical Skills
- Attention to Details
- Report Writing
- Data Presentation
Certification
- Python Basic & Advance - Gamaka AI
- Tableau Desktop & SQL - Gamaka AI
- PowerBi Desktop - Gamaka AI
- Data Science (ML, DL) with Python - Gamaka AI
- Diploma in Full Stack Data Science & AI - Gamaka AI
- Internship Participation Certificate - Meritshot
- Internship Participation Certificate - Bharat Intern
- Internship Participation Certificate - Gamaka AI
Capstoneprojects
- EDA on Zomato Restaurant using Python, Analyzed the Zomato dataset to understand factors affecting the establishment of different types of restaurants in Bengaluru.
- Database Structure of Hospital Management System, Created database structure using MySQL, performed MySQL queries, and made an ERD showing relationships between the tables.
- KPI Dashboard using Tableau Desktop, Created a Tableau KPI dashboard to track key indicators impacting product or business performance.
- Crime Data Analysis using Power BI, Created a dynamic dashboard to visualize and analyze crime data, helping banks identify suitable locations for investment.
- Dimensionality Reduction using Machine Learning, Used PCA for dimensionality reduction on Property Price Train Dataset, achieving 85% accuracy with Linear Regression.
- Stock Prediction, Developed a stock prediction project using LSTM on Netflix Dataset.
- Titanic Classification, Created a classification model using Logistic Regression to predict survival on the Titanic based on various factors.
Disclaimer
I hereby declare that all information furnished above is true to the best of my knowledge and belief.
Personal Information
- Passport Number: Y3979761
- Date of Birth: 07/13/00
Timeline
Data Science Intern
Meritshot
12.2023 - 03.2024
Data Science Intern
Bharat Intern
09.2023 - 11.2023
Data Analyst Intern
Gamaka Intellectual Machines
01.2023 - 04.2023
Programmer Analyst Trainee
Cognizant Technology Solutions
02.2022 - 06.2022
B. E - Civil Engineering
Dr. D. Y. Patil Institute of Engineering Management& Research
HSC -
Shri Krishna School
SSC -
Shri Gnan ganga School
Full Stack Diploma - Data Science &AI
Gamaka Artificial Intelligence Solutions
Similar Profiles
Soumyadeep GhoshSoumyadeep Ghosh
Graduate Engineer Trainee at Air ProductsGraduate Engineer Trainee at Air Products
Pooja Anil SuryawanshiPooja Anil Suryawanshi
Senior Software Engineer at FIS GlobalSenior Software Engineer at FIS Global
Pratik UparePratik Upare
Staff Engineer at Nagarro SoftwareStaff Engineer at Nagarro Software
Sheetal KarwaSheetal Karwa
QA Lead at Value Add Softtech Pvt. Ltd.QA Lead at Value Add Softtech Pvt. Ltd.
Siddharth R BhardwajSiddharth R Bhardwaj
Data Science & Data Engineering Intern (MLOps) at IntersectIQData Science & Data Engineering Intern (MLOps) at IntersectIQ