Shivangi Kansara

+91-910******* adlna2@r.postjobfree.com Surat, Gujarat www.linkedin.com/in/shivangikansara PROFILE SUMMARY

Motivated and results-driven Analyst with a proven track record in data analytics and process mapping. Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency.Drives business effectiveness through making recommendations based on data findings.

ACADEMIC CREDENTIALS

PG Diploma in Data Science I IIIT-Bangalore & UpGrad I CGPA 3 / 4 June 2020 - Present A comprehensive 11-month program taught by Industry experts and IIITB faculty; 7 case studies & projects; 400+ hours of academic learning & 30+ hours of industry mentoring. Consistently scored >80th percentile on all projects for data management, statistics, and predictive analytics courses

PG Diploma Management in Marketing I CGPA 4/5 June 2017 - June 2019 Institute of Technology and Management (ITM), Mumbai

B.E in Electronics & Communication I CGPA 7.74/10 June 2012 – June 2016 Sarvajanik College of Engineering & Technology (SCET), Surat KEY PROJECTS

Predictive Lead Scoring Analysis for Detect Company: Build the logistics regression model to analyze the promising leads which are most likely to get converted into paying customers. Analyzed the data through Data Validation, EDA, building a Model and Model Predictions on Test data set with the ball-park estimator as 80% of the conversion rate and was able to achieve 79% of precision value for the test data.

RSVP Movies Analysis: A demonstrated end-to-end analysis for the production company using SQL, as the company is planning to release the movie for a global audience. Analyzed the data of the past three years of the movies that have been released and suggested the inferences which will help the company to appropriate steps to start the new project. WORK EXPERIENCE

Key Account Manager, OYO Hotels & Homes Pvt Ltd, Mumbai Aug. 2019 – Jan. 2020

Analysis of the data of past travel history through advanced excel skills using Vlookup & Hlookup techniques and cater to the demand of corporates clients. Client relationship management for 12 Corporate accounts by regular meeting, providing end- to-end services by maintaining the database and keeping them updated through reports and graphs which helped to generated 10-12 Lakhs monthly revenue for the company. Enterprise Sales Manager, OYO Hotels & Homes Pvt Ltd, Mumbai Jan. 2019 – July 2019

Responsible for OYO Hotels and Homes Pvt Ltd offline channel sales and up-sell various solutions related to corporate accommodation & MICE. Providing Service Delivery, Relationship Management &Retention to the on-boarded corporates. INTERNSHIP

Business Analyst, Med Tour Easy, Remote Feb. 2021 – Mar. 2021

During this period, I have experienced the hands-on working of a Business Analytics Professional and worked under the supervision of a project mentor & developed the project entitled “Classify Suspected Infection in Patients” using R in Jupyter Notebook.

Marketing Analyst and Trainer, Titan Company Ltd, Mumbai Apr. 2018 – Aug. 2018

Analyzed and maintained reports and charts for the stores using Excel and VBA, which helped the company to achieve Google reviews across the region with a jump of 301.47% which was an all-time high in the country for the West region of over 100 stores through training, mentoring, and motivating over 1000 store employees. KEY SKILLS

• Machine Learning Modelling Techniques • Analytics Languages: R (Intermediate), Python (Introductory)

• Visualization tools: Tableau, Power BI • Software Tools: Anaconda, Jupyter Notebook, Microsoft Office & MySQL

• Hypothesis Testing • Statistics & Exploratory Data Analysis

• Databases: MySQL Join’s (Outer, Inner, Left, and Right), Database creation, UDF's, Stored Procedures, NoSQL- MongoDB ACCOLADES

Awarded Best Key Account Manager in Mumbai hub.

SQL for Database Administrator – DataCamp.

Completion of Toolkit Program for Data Science -IIIT B & UpGrad.