Data Analyst Social Media

Mihir Solanki

***************@*****.***

Metro Vancouver, BC, Canada www.linkedin.com/in/mihirso 778-***-****

https://github.com/mihirsolanki1811

WORK EXPERIENCE

G. H. Patel College of Engineering & Technology – Assistant Professor & Trainee Lecturer, Gujarat, India; June. 2017 to May 2023

Teaching undergrade and post-grad students (Data Computing and Designing, Operations Management), guiding students for project work and dissertation.

In-charge of Computing and designing lab, department library, Web-maintenance team, Central print media and departmental social media coordinator

UG syllabus design committee member

Research and publications of cases in the field of “Lean”, “Six Sigma”, “MCDM - Optimization’.

Vemun Business Solutions – Data Analyst, Rajasthan, India, June 2016 to May 2017

Collecting, cleaning, and analyzing large datasets, ensuring data accuracy and consistency for key business performance metrics using tools as MS Excel and SQL.

Developing and maintained interactive dashboards to track KPIs and providing actionable insights to support business strategy and decision-making.

Collaborated with cross-functional teams to support data-driven initiatives, contributing to process improvements and enhancing overall reporting efficiency by automating data workflows.

Parul Institute of Engineering & Technology – Lecturer, Gujarat, India; Jan. 2013 to Aug. 2014

Conducting lectures in diploma studies, Department ERP Coordinator, Sports Coordinator

EDUCATION

University Canada West; Vancouver, BC, Canada, MBA (Data Analytics) GPA: 3.60 Jan 2025

Relevant Coursework: Quantitative Reasoning & Analysis, Business Analytics, Predictive Analytics, Machine Learning Tools & Techniques, Cloud Computing Techniques (Excel, Python, Tableau, AWS, SQL)

Gujarat Technological University; Ahmedabad, India Master of Engineering (Industrial Engr.) GPA: 9.5 July 2016

Gujarat Technological University: Ahmedabad, India Bachelor of Engineering (Mechanical Engr.) GPA 7.8. July 2012

RELEVANT COMPUTER SKILLS

Microsoft Excel: Advanced Formulas, VBA & Macros, Pivot Tables, Conditional Formatting.

SQL, Python

Tableau, Microsoft Power BI, Minitab

CERTIFICATION & COURSEWORK

Full Stack Data Analytics V2 (6 months Boot Camp, 2025 February)

SQL Foundation: iNeuron

Python for Data Science: IBM

Mastering Microsoft Power BI: Mindluster

Agile Scrum: Career Sprints

Lean Six Sigma Green Belt

PROJECT WORK

Loan Sanction Prediction Analysis

Analyzed a dataset of 3699 loan applicants, focusing on data cleaning, descriptive, and diagnostic analysis to understand loan approval and rejection factors.

Performed data imputation for missing entries using central tendencies and conducted correlation analysis using scatter plots and heat maps.

Explored relationships between variables such as annual income, loan amount, and CIBIL score, revealing key factors influencing loan decisions.

Developed a logistic regression model to predict loan sanctioning outcomes, achieving 92% accuracy in predictions.

Credit Card Limit Approval Analysis

Analyzed a dataset of 13,000 credit card holders using Python, focusing on data cleaning and feature engineering to predict eligibility for credit limit enhancements. Developed and evaluated two models—an artificial neural network and logistic regression—achieving 87% accuracy. Conducted thorough correlation analysis and applied feature engineering to optimize model performance.

Mihir Solanki

Contact this candidate