Yash Mudliar

YASH MUDLIAR MALE, DOB: SEPT 15 , 1995 TH Contact  : -- PROFESSIONAL SUMMARY & SKILLS: Result driven business analyst with over 4+ years of work experience and an MBA from IIM Mumbai and proven expertise in portfolio analytics, credit risk monitoring and dashboard automation within the BFSI sector. Demonstrated success in managing 200+ crore lending portfolios, improving NPA ratios and enabling data-driven decisions through power bi and excel. Adept at translating complex data into actionable insights and collaborating with cross-functional teams to drive performance. Skills: Data Integrity, Data Visualization, Data Mining, Business Impact Analysis, Data Manipulation WORK EXPERIENCE (24 MONTHS) Kotak Mahindra Bank Limited Sr. Manager - Business Analytics Jun 2024 – Present Project Title: Collection Analytics  Synthesized Predictive collection models for Bucket 1 customers based on 80+ variables using XGBoost technique  Devised Allocation strategy for Bucket 1 customers using Payer segmentation devised from New Gen Model scores  Automated MoM report generation codes of KPI metrics, Model Monitoring and Test Control Analysis on Python Methodology  Designed Bucket 1 Power BI Dashboard for CC portfolio with 200+ cuts to track & gain insights from YOY metrics  Coordinated with business, risk and other stakeholders to devise Offus-Dashboards and analysis to track real time performance of Kotak CC and PL customers outside the bank  Synthesized Pre and Post Due Model has a Gini of 75 and 67 which is an uplift of 45 points and 17 points respectively Deliverables  Introduced Self cure segment with 60% population distribution and increased Digital Allocation from 17% to 44% in Post Due Project Title: Credit Card Analytics Manager - Business Analytics Jul 2023 – May 2024  Identified risky customer segments by spends and payments pattern using a Local Outlier Factor (LOF) model Methodology  Optimised CD Loan PAPQ Base using Decision Trees reducing FEMI to 4% from 12% with only 22% base reduction  Formulated all my SQL codes based on macros to reduce runtime and also to reduce the manual intervention in reports  Refined the SQL codes into Python and reduced codes runtime by 80% of Revenue metrics (e.g.Fees,Charges,Interests) Deliverables  Designed the Risk Dashboard for Credit card portfolio with 35+ variable cuts to monitor real time delinquency metrics SUMMER INTERNSHIP (2 MONTHS) Kotak Mahindra Bank Limited Business Analytics Apr 2022 – Jun 2022 Project Title: STP Analysis of Credit Card customers  Conducted Value Stream mapping of the current credit card products and benefit programs of the company  Used Chi square test and Correlation coefficient analysis to examine the interdependence of the 18 data variables Methodology  Executed Machine Learning’s Data Normalization technique to convert 8950 data points into dataset for Python software  Analysed data using K-means Clustering and Principle Component Analysis thereby Improving Net Promoter Score (NPS)  Suggested marketing strategies for clusters, avoiding poor branding and adding value to overall risk assessment process Deliverables  Theorized Competitive Benchmarking With 12 Competitors and Suggested 5+ Modifications through Plan of Action (POA)  Deciphered Product Cross-Selling based on Customer Transactions containing various Key Performance Indicators (KPIs) WORK HISTORY (24 MONTHS) Orange City Water Pvt ltd. Junior Engineer – Operations Oct 2017 – May 2019 Project Details: Handling Operations and Maintenance team at 120 MLD WTP  Handled inventory, monitored supplies and equipment as per ABC & VED Analysis to reduce inventory costs  Executed and analysed root cause analysis (RCA) & 5-WHY Analysis for breakdowns improving uptime by 1hr/day Roles &  Computed Preventive Maintenance (PM) data mining using MS Excel to create automated notifications on SAP PM Responsibilities  Energy saving and Cost Analysis of the project for feasible and economic implementation of idea  Directed and supervised contract labour for on-site fabrication & erection work maintaining 100% safety compliance  Introduced 5S system in plant which led to effective utilisation of space and easy to track record of assets Achievements  Secured Most Creative Award for formulating MIS reports on Labour Man-hours, increasing team efficiency by 10%  Synthesized a recycle system for saving around 1 MLD of water and brought the losses down to 0.5% JDS Electrotech Trainee Engineer - Operations May 2017 – Sep 2017 Project Details: Managing the Operations team of Plant  Revised Preventive Maintenance (PM) schedule while reducing equipment downtime by 15%  Developed and implemented operational shift chart to reduce operators overtime occurrences by 20% EDUCATION Year- Degree PGDIE B.E (Mechanical) Institute IIM Mumbai (formerly, NITIE) YCCE, Nagpur %/CGPA 8.65 8.59 Remarks Distinction Distinction PROFESSIONAL COURSES Certifications Analytics Tools  Business Intelligence Analyst Course  Complete SQL Bootcamp for Business Analysis  MS Excel, Power BI, SAS Viya, Sandbox  Statistics for Data Science and Business Analysis  Microsoft Power BI Desktop for Business Intelligence  Python, SQL