Data Scienctist / Analyst
Resume:
Sahil Rajpal
**************@*****.*** +91-998******* Rajasthan, India
linkedin.com/in/sahilrajpal121 github.com/sahilrajpal121 kaggle.com/sahilrajpal121 EDUCATION
Indian Institute of Technology Madras (IITM) 2021 - 2024 BS, Data Science and Applications (CGPA: 8.54/10)
Courses: Databases & SQL Programming Python Business Analytics Modern Application Development Artificial-Intelligence Software Engineering Software Testing Deep Learning Data Visualization Design Design Thinking Big Data
Nosegay Public School, Ganganagar, Rajasthan 2020 - 2021 XII - PCM (Marks Percentage: 86%)
WORK EXPERIENCE
Data Scientist Intern - Syngenta (April 2023 - March 2024)
● Wrote efficient SQL queries on complex DBMS to gather the required data for multiple use cases.
● Worked closely with team and SMEs to deliver on multiple analytics-driven business projects.
● Successfully built and deployed 10+ dashboards using Next.js and Asynchronous Flask on AWS Lambda. Conducted workshops to teach the same.
● Led the end-to-end sales forecasting project using Machine Learning-based predictive modeling with an average R2 score of 0.75 for 15+ AMEA countries with different business dynamics. PROJECTS
Gajendra Circle - IITM BS Alumni Application (View)
● An ongoing design initiative for an Alumni application based on the concepts of Karmic Design Thinking.
● Worked collaboratively in a team to create human-centered designs catering to 10000+ students.
● Conducted Empathize interviews to understand the pain points of potential users and built a Figma prototype.
● Conducted Test Interviews for the Figma prototype and reiterated the application design based on feedback. Students' Dropout Prediction (View)
● Three-category classification task (dropout, enrolled, and graduate) using weighted F1-score as the scoring function.
● Worked with an anonymized dataset of students and predicted whether the student would drop out with a 0.76 weighted F1 score.
● Ran 10000+ combinatory trials with different kinds of models with sampling and scaling techniques.
● Cross-validated all the trials and further accomplished feature selection.
● Built a Histogram-based Gradient-boosted Boosted Classifier to predict whether the student would drop out. Song Popularity Prediction (View)
● Predicting song popularity using the audio's technical features such as audio valence, loudness, liveness, etc.
● Preprocessed the dataset that contained missing values using Imputer techniques (LGBMImputer).
● Handled Imbalanced data using Undersampling techniques such as SMOTE and TomekLinks.
● Searched for the best hyperparameters by running Optuna trials on the XGBoost model.
● Predicted song popularity with a score of 0.57 AUC using a tuned XGBoost model. Voter Turnout Analysis (View)
● Performed a thorough analysis of the worker community’s voting data
● Ranked 4th best project in the class
● Demonstrated the distinguishing factors of voting behavior based on demographics and other significant barriers.
● Employed the use of correct aesthetics and storytelling methods to explain the analysis TicketShow - A Vue web app (View)
● Web app for Booking Movie Tickets based on Vue.js, Flask, SQLite, SQLAlchemy, Bootstrap
● CRUD for Users, Venues, and Bookings with appropriate database relationships.
● Implemented app security using JWT authentication and client and server-side validations.
● Implemented batch jobs to send daily and monthly reminders by mail.
● Implemented cache functionality to efficiently retrieve frequently called requests. ACHIEVEMENTS
.
● Finished runner-up from 250+ participants and won a cash prize of Rs. 10000 in an analytics competition hosted by Sri Ram College of Commerce.
● Finished in the top 50 and won a cash prize of Rs. 5000 in a runs prediction competition for IPL matches by IITM SKILLS & CERTIFICATIONS
Online Courses: Intermediate Machine Learning Time series Data Visualization Data Cleaning Skills: SQL Numpy Pandas Python Excel Scikit-learn Flask Data analysis Data Manipulation Data Modeling Machine Learning AWS Git Deployment PowerBI Automation References
Srinivas Chidumalla
Head, P&S CoE, Digital and Transformation, AMEA
Syngenta
********.**********@********.***
Contact this candidate