Sambhav Bhansali

Detail-oriented Business Systems Analyst Intern with six months of experience at Zscaler, specializing in gathering business requirements and streamlining workflows. Proficient in Salesforce, Jira, and Agile methodologies, delivering impactful solutions through collaboration with cross-functional teams. Committed to leveraging Gen AI tools to enhance operational efficiency. Passionate about robotics and football, combining analytical skills with creative problem-solving.

• SQL (Intermediate) (Credential ID: 36ef16c6deaf) by HackerRank Jul 2024
• Python basics for Data Science (Credential ID: 0b2e7e07a9fa4c8dbbb66fecf1a03caf) by EDX Jun 2024
• Mastering Github Fundamentals (Credential ID: g4a4LL3ZGJ) by Meta Craftlab Jun 2024
• IBM Introduction to Data Science (Credential ID: 214ab9b2d12d4308871ac9eece5f2fa) by EDX May 2024
• IBM Introduction to Cloud Computing (Credential ID: 0f2ae4be6b6c41c28a99cdbd4b8e61c4) by EDX May 2024

Road Traffic Prediction Model, Developed a traffic volume prediction model using Python, pandas, NumPy, Scikit-learn, and seaborn., Conducted data preprocessing to handle missing values, encode categorical variables, and scale features., Evaluated performance with Mean Absolute Error (MAE) and R-squared (R2)., Achieved high accuracy, aiding urban planning and transportation management., Armbot using RaspberryPi, Integrated hardware components, software algorithms, and practical applications to create a robotic arm mounted on a mobile chassis., Used a cost-efficient Raspberry Pi and a flexible robotic arm to build an accessible and educational robotics model that is around 40% cheaper than alternatives., Potential applications include automation, manufacturing, and healthcare., Pizza Sales Analysis using SQL Aug 2024 - Sep 2024, Developed and executed complex SQL queries to analyze key performance metrics, including revenue distribution, most popular pizza types, and order frequency, driving data-driven decision-making for sales strategies., Designed and implemented a relational database model that categorized data into basic, intermediate, and advanced queries, enabling a detailed exploration of sales data and contributing to improved operational efficiency., Streamlined sales data management by organizing and analyzing large datasets, making it easier to identify top-selling pizzas, peak sales times, and overall business performance, ultimately helping to enhance sales strategies by up to 50 percent, Power BI Data Visualization Project: Premier League 2024 Analysis Jun 2024 - Jun 2024, Leveraged Power BI to analyze the Premier League 2024 dataset, focusing on expected goals and total goals., Designed interactive dashboards with filters for Dates, Referees, and Captains to enhance data exploration., Developed key visualizations including average possession by teams and goals for vs. expected goals by formation. Demonstrated strong skills in data visualization, interactive reporting, and football analytics through comprehensive analysis.

Smart India Hackathon 2023 Grand Finalists by Ministry of education Dec 2023, Our team developed an advanced drone-based surveillance system for ships navigating port areas, specifically focusing on the Cochin port., We created a Drone on Drone Tech equipped with a custom Transponder system to effectively monitor and track ships in real-time.

• Armbot using Raspberry Pi on ICONSTEM 2024 Apr 2024
• The project showcases the innovative use of Raspberry Pi in robotics, highlighting its potential in advancing automation and technology integration

• Volunteer Learning Links Feb 2023 - Apr 2023 Pune
• We conducted session planning and tinkering sessions for government school students, enhancing technical project completion rates by 30% positively impacting over 100 students' educational experiences, and gaining positive feedback from all of them.
• Reverb (Cultural Fest) Event Head Feb 2023 - Feb 2023 Pune
• Organized and managed a three-day FIFA tournament, attracting over three hundred participants and increasing community engagement by 40% by introducing prizes for the top three players.