PRANIL BHAVSAR
********@*******.*** 551-***-**** LinkedIn
EDUCATION
Stevens Institute of Technology, Hoboken, NJ May 2021
• Master of Science in Business Intelligence and Analytics GPA: 3.88 Relevant Courses: Multivariate Statistics and data Analysis; Advanced database Management, Data Warehouse and Business Intelligence; Image Processing; Cloud Computing Services, Deep learning; Query Processing; Distributed Systems KJ Somaiya College of Engineering, Mumbai, India May 2019
• Bachelor of Technology in Information Technology SKILLS
• Programming Languages: Java, Python, SQL, JavaScript, R, C, C++
• Technologies: MySQL, NoSQL, MongoDB, Amazon Aurora, RedShift, Flask, Selenium, Git, Power BI, MS Excel, Tableau, AWS
(S3, EC2, VPC)
• Machine Learning Frameworks: Keras, TensorFlow, Image Classification and text Mining PROFESSIONAL EXPERIENCE
KJ Somaiya College of Engineering, Mumbai Summer 2019 Software Engineer Intern
• The school faced high electricity charges due to not switch off electricity supply in empty classrooms and labs.
• In order to alleviate this problem, I collaborated with a team of engineers to Build a software that uses a combination of motion and human detection to automate power supply in the classroom.
• Used OpenCL library on python for the development of the software.
• We efficiently implemented HAAR CASCADE algorithm with AdaBoost training for accurate human detection.
• This implementation was cost effective as classrooms already had high resolution CCTV cameras and thus no additional hardware was required.
• The software will successfully reduce electricity consumption by 8% annually. KJ Somaiya College of Engineering, Mumbai Summer 2018 Software Engineer Intern
• The school had written attendance and the admin staff spent 4 hours every week to enter the attendance into excel and send emails to inform the guardians of the defaulters.
• To alleviate this issue, I developed software for Automating of attendance using OpenCV-Python.
• The software would count student attendance from scanned copy of the attendance sheet and export them into excel sheet.
• The software had an accuracy of 96% to map attendance to the correct student.
• Efficiently implemented an automated attendance record keeping that sends notification to guardians of the defaulters.
• Used python on the back end and Flask on the front end for admin interface.
• This project saves the admin staff 4 hours of data entering every week and accurately records attendance. Mehul Balloons, Mumbai (Jan 2017- Oct 2017)
Web Developer Intern
• Designed an E-Commerce website for the company which involved both front and back end development.
• Developed a minimal, clean design language for company’s web portals.
• Imported data from SQL Server to Power BI to generate reports.
• Used Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published reports and dashboards using Power BI.
• This website accounts for 30% of the annual sales. PROJECTS
Airbnb Price and Consumer Analysis Using Machine Learning.
• Built a pricing model that aids Airbnb hosts to predict the ideal price for their listings
• Used deep learning concepts and implemented a multi-layer Neural Network regression model along with XGBoost.
• Efficiently calculated weightage that each feature adds to the renting property which also helps host understand consumer expectations in the region.
• Contrived 92% prediction accuracy with XGBoost.
Twitter analytics to Understand effect of Covid-19 on Stock Market.
• Programmed a mechanism to analyze twitter data using twitter API to understand effect of tweets on stock market.
• Inspected twitter data and used NLKT to predict stock related sentiments and achieved 90% accuracy with low latency.
• Sentiment prediction was nearly real time as dataset was updated after every 2 seconds.
• Used tableau’s 7 KPI dashboard to display various factors.
• Improved basic Investment predictions systems by 35% to provide simple and effective solution.