scorp7 Goto Github PK

SOCIAL PROFILES

• LinkedIn
• Medium
• Jovian

EDUCATION

Data Science Bootcamp, Jovian (View)                                                                                                                                             (May 2021 - Ongoing)
Courses: Python Programming, Statistics, Data Analysis & Visualization, Machine Learning, SQL & Analytics.
Highlights: 500+ hours of coursework, 10 coding assignments, 3 projects (Web scraping, EDA, ML).

Mumbai University, Mumbai, India 2019-2022
Bachelor’s in Computer Science (GPA: 9.95/10)

Courses: Databases & SQL, Programming with Python, Data Mining, Statistics and Probability.
Highlights: Top 2 in the class, Winner - Best Project Award (Product Comparison with Affiliation).

WORK EXPERIENCE

Business Analyst Intern - Ascent                                                                                                                                                      (July 2022 - Nov 2022)

• Gather data using SQL, create & generate reports of the same using Tableau dashboards.
• Developed a Space Optimization model in Tableau which helped in reducing the cost by 50 lakhs.
• Developed an MIS Automation pipeline using Python that converted 15 days work (manual) into 6 hrs.

Full Stack Developer Intern- Aurora Web Labs                                                                                                                             (Aug 2021- Jan 2022)

• Front End & Back End Development, Testing the System Modules.
• E-commerce, Blogging, Health Care, Library Management.
• Worked on HTML, CSS, JavaScript, Bootstrap, Jquery, Python, Django, SQL, etc.

Business Analyst & Assistant Manager - Stellar Techno                                                                                                           (April 2021- Aug 2021)

• Developed business strategy, systems, procedures to improve operational quality and team efficiency.
• Developed and maintained relationships with customers and suppliers through account development.
• Identified trends in customer marketplaces to develop valuable solutions using Excel & SQL.

PROJECTS

Forecasting Housing Prices using Machine Learning (View)

• Cleaned & analyzed UK house price dataset with 22M+ rows & 11 columns to predict house prices
• Trained Linear Models, Decision Trees, Random Forests, and Gradient Boosted trees using scikit-learn
• Achieved a minimum Root Mean Square Error of 0.2825 with tuning Random Forest model

Exploratory Data Analysis and Visualization of Spanish Rail Ticket Pricing (View)

• Cleaned & analyzed with ASL Kaggle data of 38M rows & 13 columns using Pandas & Numpy.
• Created visualizations (scatter plots, strip plot, geo heatmaps, etc.) using Seaborn, Folium & Plotly.
• In Spain people are ready to pay more for fast-moving trains over comfortable trains.

Web Scraping of Gold Price using Python (View)

• Scraped gold Price for Indian cities via "Good Return" using Requests & BeautifulSoup4 libraries.
• Built functions such as get_doc() & get_today_price() etc to scrape gold_price, difference_in_price, etc.
• Stored data consisting of 196 rows x 6 columns into "Today's_date.csv" file using write_csv() function.

Product Comparison and Cost Saving Web App using Python & Django (View)

• Developed a portal for getting the best price of a product by comparing it over available resources for free of cost.
• Customer earns a cash back each time he/she makes a purchase.

SKILLS & CERTIFICATIONS

Online Courses: Advanced Google Analytics, Machine Learning with Python, Web Designing Professionally, Face Recognition app using Python.

Skill: Python, Excel, Tableau, SQL, Pandas, Numpy, Plotly, Jenkins, Pushmetircs, Dbeaver, Html, Css, JavaScript, Django, Git, Presentation, Machine Learning, Statistics, Verbal & Written Communication.