Vishal Raghuwanshi
Bangalore
Summary
Process-oriented data analytics professional with 4 years of experience, currently working at Rapido. By utilizing my proven skills in Metabase, Presto SQL, MySQL, R, Python, and MS Excel. I have excelled in gathering, analyzing, interpreting, and presenting crucial findings from all types and sizes of datasets. I am eager to further implement my skills and experience across multiple industries such as E-commerce, Transportation, CRM, Retail and improve my data analysis experience by working in a detail-driven data team.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
Rapido
Bangalore
04.2020 - Current
- Built various dashboards in Metabase using SQL to help the teams understand the data better and monitor KPIs to analyze the growth or decline in various aspects of the company.
- Built various passes to meet the customer needs, which helped in increasing customer retention and their RPC (rides per customer).
- Created an end-to-end product called “Take A Break” in which, out of all the available captains (drivers) for an order, we move the captains who miss a lot of orders to the bottom of the captain list and improve the process of matching the right captain with the right customer.
- Performed a detailed analysis using SQL and Python and helped conclude the performance of the product called “My Route Booking” in which captains get only the orders towards their home location.
Data Analyst
Cartesian Consulting Pvt Ltd
Bangalore
06.2018 - 03.2020
- Developed customer insights for India’s largest bus aggregator to help their marketing team with business decisions & also provided data required for effective forward planning, campaign management, and customer strategy.
- Consistently achieved CRM & Marketing Objectives of improving Customer Retention & Repeat, Reducing Churn Rate, Campaign responses, Lift and Incremental revenue using statistical techniques such as RFM methodology, Linear Regression, Logistic Regression etc.
- Build Churn Model using Random Forest Technique to predict probable churn customers and send them relevant communications to reduce the churn rate.
- Performed sentiment analysis on the customer feedback data to find out the public opinions of the brand.
Education
B. Tech - Metallurgical And Materials Engineering
National Institute of Technology
Tiruchirappalli05.2018
Skills
- SQL
- Metabase
- Python
- Pyspark
- R
- Microsoft Excel
- JIRA
- Confluence
- Data Analysis
- A/B Testing
- Predictive modeling
- Statistical Analysis
Accomplishments
- Trouble Shooter Award: Received this award for helping team members and stakeholders in solving various complex data (sql query) and business problems. (Feb 2021)
- Rapido Spot Award: Received “Thank You” award for helping colleagues in building important dashboards and visualizations for their respective verticals. (Mar 2021)
Internships
Data Analytics Internship - IIM Lucknow (Jun 2017 - Jul 2017)
- Learned the basic operations of R language like exploratory data analysis, and data visualization techniques.
- Performed exploratory data analysis to draw insights from a data set of information on titanic's passengers and Built a logistic regression model to predict the survival possibility of the passengers in the R language.
Languages
Hindi
Native language
English
Proficient
C2
Certification
- Python for Data Science and Machine Learning - Udemy (Dec 2019)
Timeline
Senior Data Analyst
Rapido
04.2020 - Current
Data Analyst
Cartesian Consulting Pvt Ltd
06.2018 - 03.2020
B. Tech - Metallurgical And Materials Engineering
National Institute of Technology
Similar Profiles
Philippe RollinPhilippe Rollin
Store Supervisor at RapidoStore Supervisor at Rapido
Nitin Kumar CNitin Kumar C
Associate Operation Manager at RapidoAssociate Operation Manager at Rapido
Dileep Nagubandi/Experience:6Years SDET/QADileep Nagubandi/Experience:6Years SDET/QA
Senior SDET at RapidoSenior SDET at Rapido