Mayank Hasija profile photo 1 on Tal

Mayank Hasija

Data Scientist at IBM

Gurugram

12+ years of work experience

IBM
Jul 20232 yrs 10 mosPresent

Optum
Oct 20202 yrs 9 mosJun 2023

Gurugram, Haryana, India

1Touch
Apr 20205 mosAug 2020

New Delhi, Delhi

Working as a freelance data scientist cum consultant to a startup. Implemented projects on Big data Suite of Amazon Web Services: 1. EMR-Hive/Spark 2. Quicksight 3. Hbase 4. Kafka 5. Athena Also worked on Image processing and computer vision algorithms using OpenCV.
Carlson Analytics Lab
May 20172 yrs 1 moMay 2019

Greater Minneapolis-St. Paul Area

Client: Leading Hospitality and Entertainment business in Midwest • Optimized room allocation strategy and occupancy for hotels to increase revenue. • Built static & dynamic models to predict yearly, bi-weekly, and daily demand across various worth categories of players. Built several models like Lasso Regression, Random Forest, SVM, XG Boost in Python to finalize XG Boost as the final model with lowest RMSE of 22%. Final model predicted hotel occupancy within 5% of the actual occupancy. • Segmented customers using K-Means into LOW, MEDIUM AND VIP worth category and analyzed their reservations patterns to help in identifying opportunity segments to mitigate the decline in hotel occupancy • Leveraged scraping of hotel reviews to perform sentiment analysis in python and recommended steps for improving the customer experience Client: Big 4 Consulting Firm • Identified factors for declining profitability for a personal auto insurance book using exploratory analysis, visualization and hypothesis testing • Segmented customers using K-Means clustering in R and recommended profile and risk-based pricing. • Identified branches with operational inefficiencies and poor underwriting techniques • Identified key-variables which are contributing to decline in profitability using multivariate analysis • Recommended immediate, Short term, medium term, long term actionable steps to improve the profitability • Presented results to the leadership team Statistics Final Project: • Predicted used car prices for optimum pricing e-commerce website using linear regression. Used visualization, hypothesis testing, statistical techniques for variable selection.
EXL
Aug 201610 mosMay 2017

Northampton, United Kingdom

Strategy Analytics Global Payment Acceptance division of leading UK bank at onshore (Northampton, UK): • Tracked and forecasted the sales and income generated from new merchant acquisition. • Predicted lead conversions from various marketing campaigns and monitored channel effectiveness. • Measured the effectiveness of various channels of recruitment. • Created monthly reports used by business development and sales team.
EXL
Jun 20151 yr 2 mosJul 2016

Gurgaon, India

Risk Modelling-Secured Loans for a leading UK bank: • Calibrated probability of default (PD), exposure at default (EAD) and loss given default (LGD) models to comply with Basel 3 norms. • Calculated the Risk-weighted assets of the bank’s Italy portfolio.
EXL
May 20132 yrs 2 mosJun 2015

Gurgaon, India

Distribution and Sales Analytics for a leading Life Insurance company: • Measured the performance of various business functions with respect to key performance indicators and recommended areas of improvement. • Performed root-cause analysis and hypothesis testing for identifying reasons for the drop in • the business & decline in productivity of the sales force. • Built regression models for predicting risky policies and cross-selling/up-selling opportunities. • Measured the effectiveness of incentive compensation schemes and recommended key areas of improvement. • Created reports and answered requests from various stakeholders. Premium Pricing Engine for a leading US P&C Insurance company: • Responsible for development of a premium pricing model based on attributes of the vehicle, policy and driver. • Implemented the premium pricing model in 28 U.S states by making changes according to local state laws. This tool helped to reduce the overall liability and physical damage coverage for an average policyholder by approx. 2.2% and also helped the company lower its insurance rates by up to 9.9%.

Education

UMN Carlson School of Management

Master of Science - MS, Business Analytics

UMN Carlson School of Management

20172 yrs2019
Birla Institute of Technology and Science, Pilani

Master of Science - MS, Mathematics

Birla Institute of Technology and Science, Pilani

20055 yrs2010

Join Mayank and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Mayank Hasija on Tal

Headline

Data Scientist at IBM

About

I have finished my Masters in Business Analytics at the University of Minnesota, Carlson School of Management. I have 8 years of work experience in Banking analytics, Insurance analytics and Consulting. I have strong domain knowledge of Banking and Insurance. Cross-functional expertise across risk analytics, customer analytics, marketing analytics, strategy analytics, demand forecasting. Demonstrated ability to work across diverse teams and with business stakeholders. Onsite experience of working with different clients as well as international exposure in UK. Technical skills: - Exploratory Data analysis - Predictive analytics - Financial Analytics - Data visualization and Storytelling Software Tools: SQL, Python, R, SAS, Unix, Rapid Miner,MS Excel Data Visualization : Tableau, Power BI Big Data platforms - Pig, Hive, Spark, Hadoop, AWS Database & Platforms: MySQL, Hadoop, AWS Machine Learning : Supervised techniques: Linear Regression, Logistic Regression, K Nearest Neighbor, Decision Trees, Support Vector Machines, Ensemble Methods (Random Forest, Gradient Boost, XGBoost), Neural Networks Unsupervised techniques: Clustering(K Means, K Prototypes, DBSCAN, Hierarchial Clustering, Gaussian Mixture Models), Association rules, Latent Dirichlet Allocation, Principal Component Analysis, Topic Modelling Personal interests: Playing chess, carrom, table tennis, cricket, and traveling. Email: hasij001@umn.edu

Location

Gurugram

Work experience

Data Science Consultant at IBM, Jul 2023 - Present · 2 yrs 10 mos

Data Scientist at Optum, Oct 2020 - Jun 2023 · 2 yrs 9 mos, Gurugram, Haryana, India

Freelance data scientist at 1Touch, Apr 2020 - Aug 2020 · 5 mos, New Delhi, Delhi, Working as a freelance data scientist cum consultant to a startup. Implemented projects on Big data Suite of Amazon Web Services: 1. EMR-Hive/Spark 2. Quicksight 3. Hbase 4. Kafka 5. Athena Also worked on Image processing and computer vision algorithms using OpenCV.

Analytics Student Consultant at Carlson Analytics Lab, May 2017 - May 2019 · 2 yrs 1 mo, Greater Minneapolis-St. Paul Area, Client: Leading Hospitality and Entertainment business in Midwest • Optimized room allocation strategy and occupancy for hotels to increase revenue. • Built static & dynamic models to predict yearly, bi-weekly, and daily demand across various worth categories of players. Built several models like Lasso Regression, Random Forest, SVM, XG Boost in Python to finalize XG Boost as the final model with lowest RMSE of 22%. Final model predicted hotel occupancy within 5% of the actual occupancy. • Segmented customers using K-Means into LOW, MEDIUM AND VIP worth category and analyzed their reservations patterns to help in identifying opportunity segments to mitigate the decline in hotel occupancy • Leveraged scraping of hotel reviews to perform sentiment analysis in python and recommended steps for improving the customer experience Client: Big 4 Consulting Firm • Identified factors for declining profitability for a personal auto insurance book using exploratory analysis, visualization and hypothesis testing • Segmented customers using K-Means clustering in R and recommended profile and risk-based pricing. • Identified branches with operational inefficiencies and poor underwriting techniques • Identified key-variables which are contributing to decline in profitability using multivariate analysis • Recommended immediate, Short term, medium term, long term actionable steps to improve the profitability • Presented results to the leadership team Statistics Final Project: • Predicted used car prices for optimum pricing e-commerce website using linear regression. Used visualization, hypothesis testing, statistical techniques for variable selection.

Analytics Consultant at EXL, Aug 2016 - May 2017 · 10 mos, Northampton, United Kingdom, Strategy Analytics Global Payment Acceptance division of leading UK bank at onshore (Northampton, UK): • Tracked and forecasted the sales and income generated from new merchant acquisition. • Predicted lead conversions from various marketing campaigns and monitored channel effectiveness. • Measured the effectiveness of various channels of recruitment. • Created monthly reports used by business development and sales team.

Lead Assistant Manager at EXL, Jun 2015 - Jul 2016 · 1 yr 2 mos, Gurgaon, India, Risk Modelling-Secured Loans for a leading UK bank: • Calibrated probability of default (PD), exposure at default (EAD) and loss given default (LGD) models to comply with Basel 3 norms. • Calculated the Risk-weighted assets of the bank’s Italy portfolio.

Senior Business Analyst at EXL, May 2013 - Jun 2015 · 2 yrs 2 mos, Gurgaon, India, Distribution and Sales Analytics for a leading Life Insurance company: • Measured the performance of various business functions with respect to key performance indicators and recommended areas of improvement. • Performed root-cause analysis and hypothesis testing for identifying reasons for the drop in • the business & decline in productivity of the sales force. • Built regression models for predicting risky policies and cross-selling/up-selling opportunities. • Measured the effectiveness of incentive compensation schemes and recommended key areas of improvement. • Created reports and answered requests from various stakeholders. Premium Pricing Engine for a leading US P&C Insurance company: • Responsible for development of a premium pricing model based on attributes of the vehicle, policy and driver. • Implemented the premium pricing model in 28 U.S states by making changes according to local state laws. This tool helped to reduce the overall liability and physical damage coverage for an average policyholder by approx. 2.2% and also helped the company lower its insurance rates by up to 9.9%.

Education

Master of Science - MS, Business Analytics, UMN Carlson School of Management

Master of Science - MS, Mathematics, Birla Institute of Technology and Science, Pilani