Mayurkumar Surani
Data Analyst
Chennai
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
7
7
years of professional experience
7
7
years of post-secondary education
3
3
Certifications
5
5
Languages
Work History
Data Analyst
HDFC Bank
9 2022 - Current
- Understand Business Challenges from different business departments i.e
- Finance, Operations, Sales, Top Management etc
- Coordinating with Cross Functional Team to gather business requirements
- Data Extraction and data Manipulation from various data sources using MS SQL & Python
- Analysing the Risk percentage of a customer/Predicting customer behaviour
- Developed and maintained data warehouses and data marts to support business operations.
- Customer Segmentation and Profiling, Product Cross Selling and Sentiment and Feedback analysis
- Preparing Business Presentations to Summarize Data Analysis.
- Maintained up-to-date knowledge of industry trends and advancements in data analytics, enhancing the adaptability of solutions provided.
- Enhanced business efficiency by identifying trends and patterns in complex datasets.
- Deployed predictive analytics models to forecast future trends.
- Resolved complex business challenges by leveraging statistical modeling techniques and machine learning algorithms.
- Data Transformation - create a data transformation pipeline to clean and standardize incoming data & Enrich the data with additional attributes.
- Data Processing - Design and implement a batch pipeline to aggregate
- Data Quality & Validation - Implement automated data validation checks to ensure the integrity of incoming data
- Data Documentation - Document the data Schemas for the customer database to facilitate data analysis.
Sr Officer - Customer Service
TFL QUINN INDIA PVT LTD
08.2018 - 08.2022
- Preparing Dashboard for Customer Product Mix using Power Bi
- Preparing monthly / quarterly / annual Sales Report for India Region
- Preparing Data Cleaning, Data Pre-Processing and Predictive Analytics Model Building derive Business insights
- Handling commission & rebate agreements
- Manages complete sales cycle in SAP from PO to Cash collection.
- Held monthly meetings to create business plans and workshops to drive successful business.
- Creating Data Analytics DashBoards for Product Mix and Sales Forecasting using Power BI , Python
- Preparing Data cleaning and Product Sales Reports using SQL & Python
- Preparing Customer Product recommendation reports to boost sales'
Sales Executive
Krishna Petrochemicals
12.2016 - 11.2017
- Preparing customer invoices for despatches, Sales Forecasting
- Coordinating with Production & Warehouse team to streamline business operations.
Education
Data Science for Business Excellence & Innovation - Data Science
Indian Institute of Management
Nagpur, India 05.2021 - 05.2022
Post Graduate Program in Business Administration ( PGPBA MBA ) - undefined
Indo German Training Centre
Chennai, India 08.2014 - 05.2016
BE Mechanical - undefined
Government Engineering College Surat
Surat, Gujarat 08.2007 - 05.2011
Skills
- PYTHON
- R
- MYSQL
- TABLEAU
- POWER BI
- ALTERYX
- PANDAS
- NUMPY
- PLOTLY
- MATPLOTLIB
- ALGIBRA
- STATISTICS
- PCA
- CLUSTERING
- REGRESSION
- CLASSIFICATION
- GITHUB
- TENSORFLOW
- MACHINE LEARNING
- NLP
- BUSINESS COMMUNICATION
- DATA ANALYSIS
- GAP ANALYSIS
- DATA STORY TELLING
- DATA VISUALIZATION
- DATA WRANGLING
- DATA PRE-PROCESSING
- SCIKIT-LEARN
- DATA ANALYTICS
- PREDICTIVE ANALYTICS
- SEGMENTATION
- NATURAL LANGUAGE PROCESSING
- AWS EC2
- SWOT Analysis
- Pyspark
- GCP
Certification
Advance Learning Algorithms by Andrew Ng- Stanford Online-Coursera (06/2022)
Accomplishments
- Best Performance Award for 2021- Customer Service
- Rewarded as best performance award 2021 for excellence customer service
- Implemented Machine Learning Solution for EMI Sourcing Merchants in Bank which added ~150 crore business in year
- Implemented ML customer personal loan recommendation which added ~200 crores personal loan business in bank
Stackoverflow
stackoverflow.com/users/17341247/mayur-surani
Projects
- Creating Data Transformation, Data Processing and Validation ,Quality and Query Optimization and Data Documentation using Pyspark.
- Developed Merchant discount pricing strategy model using machine learning models to optimize bank profit and improve business volume and float income.
- Developed and deployed EMI sourcing merchants to offer EMI facility to add business volumes of merchants and hence increase float balance and business income. It has reported ~150 crores EMI business volume in FY2023-2024.
- Developed personal loan recommender system to source loan accounts with existing customer base & reported ~ 200 crores of personal loan disbursed in FY2023-24.
- House Price Prediction of California, USA, A project having housing datasets of California and needs to predict median price of house Exploratory Data Analysis of Brazilian Online Marketplace -OLIST and Sales predictions, Performed EDA and gain business insights of Olist Online Marketplace from 2016-19 & predicted sales for next 3 months
- Online Product Recommendation for BigBasket Market Place, Performed Data Cleaning, Pre-Processing of Big-basket Customer datasets and created ML Model for Product Recommendation using Machine Learning Techniques in Python Model suggests - if person buys one products, there are chances that he/she might buy other products. Therefore, sales can be leveraged
- Gold Price Prediction for Indian Market (03/2022), Using Forecasting Models and Python Libraries, predicted Gold price of Indian Market for next 10 months with respective to independent variables such as Crude Oil Price, Repo Rate, INR to USD rate, Interest Rate, Sensex(BSE) & Dollar Index Best Forecasting Model predicted 91.2% accurate Gold Price with six independent variables
Timeline
Data Science for Business Excellence & Innovation - Data Science
Indian Institute of Management
05.2021 - 05.2022
Sr Officer - Customer Service
TFL QUINN INDIA PVT LTD
08.2018 - 08.2022
Sales Executive
Krishna Petrochemicals
12.2016 - 11.2017
Post Graduate Program in Business Administration ( PGPBA MBA ) - undefined
Indo German Training Centre
08.2014 - 05.2016
BE Mechanical - undefined
Government Engineering College Surat
08.2007 - 05.2011
Data Analyst
HDFC Bank
9 2022 - Current
Similar Profiles
KAMALA SUBRAMANIANKAMALA SUBRAMANIAN
Senior Vice President and Unit Head at HDFC Bank Limited, HDFC BankSenior Vice President and Unit Head at HDFC Bank Limited, HDFC Bank
Vignesh HanglurVignesh Hanglur
Deputy Manager at HDFC LTD/ HDFC BANK LTDDeputy Manager at HDFC LTD/ HDFC BANK LTD
Ramesh GollaRamesh Golla
Sr. Corporate Agency Manager at HDFC Life Insurance Company Limited (HDFC BANK)Sr. Corporate Agency Manager at HDFC Life Insurance Company Limited (HDFC BANK)