Civil Engineering Data

VRUSHABH D. CHAMATE Mobile: +91-959******* Email: *****************@*****.***

Linkdin : https://www.linkedin.com/in/vrushabh-chamate-787224234za ACADEMIC DETAILS

Year

Degree / Exam

Institute

GPA/Marks 2017-2020

2015-2017

B.E in Civil Engineering

Diploma in Civil Engineering

R.T.M.N.U.

M.S.B.T.E.

8.56/10

71.88

2015

2013

HSC

SSC

Jagdamba Jr. Science College,Yavatmal

Netaji Vidyalaya, Ralegaon

53.24

69.9

Project & Case Study: Drone Delivery System – I worked on Drone Delivery System on Operational Feasibility & Financial Feasibility.

Operational Feasibility: Used Problem Solving Skills to Analyze and Break the Problem into smaller Chunks, Provided Delivery Hubs Across defined Areas so that the Operations, Radius of delivery and Sales should Increase.

Financial Feasibility: Used the Data provided and Calculated Different Areas and Created a Spreadsheet With The help of Functions and Formulas in Excel to find Out No. of Drones required, No. of Hubs Required, Cost of Drones, Maintenance Cost, Flight time, cost of Operations and Derived Insights Whether the Feasibility is having a profitably or not.

Tableau: Proficient in Dash boarding and understanding charts in Tableau. Ability to drill down data and understanding various Levels of Detail in the Report, Analyzed Data to create Sales and Profit Using Tableau.

SQL (Structured Query Language) Successfully Analyzed Real Time Airline Database case study and solved Queries using Joins, Case statements, Window function with 90% accuracy.

Solved Real time Covid Vaccine Distribution and Profit & Storage Problem using Solver.

Recency-Frequency-Monetary (RFM) Analysis using Statistics and Tools like Advance excel and pivots.

Visualized Real Time Food Company Data and Created Dashboard/Report by creating Metrics using PivotTable, Charts and Diagram with 100% accuracy.

Advanced MS Excel to solve real time problem case studies using Functions and Formula like Sumifs, Countifs Vlookup, Hlookup, Index and Match with 100% accurate results. SKILLOVILLA (May 2022 - Oct 2022): Data Analytics (MS Excel, SQL, Tableau, Microsoft PowerBI,Problem Solving And Analytical Python.)

Managed Technical Event Wheel-Spin 2018-2019 as an Event management Head in our College.

Member of Bridge Making committee in Wheels-Spin event 2018-2019 in College

Analyzed the Weight Distributions and Drilled down the Problem Faced in the prototype of bridge

Organized ‘AALEKHAN’ a Wall Painting competition with collaboration of Municipal Council Wardha

Cricket : Interuniversity Team Player from 2018-2020.

Winner, of ‘IGNITE’ 2019 which was Model making Competition and Secured 2nd Price.

Winner, of ‘BuildCON’ NEEV 2019 Held in Shri RamdeoBaba College of Engineering, Nagpur and Secured 1st price.

Participated in ‘CameraSHY’ 2018 a photography Competition.

Proficient in SQL

Proficient in Advanced Microsoft Excel

Proficient in Tableau

Proficient in Microsoft Power BI

Good in Statistical and Problem Solving skills

Excellent Data Visualization Skills

Excellent Critical Thinking, Presentation and Communication Skills PROJECTS

CERTIFICATIONS

POSITION OF RESPONSIBILITY

AWARDS AND ACHIEVEMENTS

KEY SKILLS

Contact this candidate