RUCHA VELANKAR
Insights, Lead
Mumbai
Summary
Achievement-driven Analyst; offering with over 12 years of rich & extensive experience in solving business problems by exploring data, providing insights, and improvements with the help of analytical, statistical & machine learning techniques
Overview
13
13
years of professional experience
5
5
years of post-secondary education
Work History
Assistant Vice President
TU CIBIL
07.2022 - Current
- Leading my team to effectively transition from generating reports to creating Insights
- Collaborating, conceptualizing and implementing analytics solutions to answer strategic business questions using credit bureau data to provide valuable insights.
- Worked on Sachet products – Decision trees specific to different credit products to profile high risk borrowers basis past credit behavior. This helped members sharpen underwriting policies better by identifying the riskiest 5% segment. Clients were able to identify better swap-in and swap-out opportunities.
- Managed a team of 6 to handle 30+ different clients – ranging from large private banks, public banks to traditional NBFCs to Fintech's.
- Developed a product to understand recovery amounts from NPA over a period of time.
- Led migration to GCP of all custom insights activities with meticulous tracking of efficiency as well as issue. India was the first region to make the switch and our team played a key role in transferring our work to the new platform.
Associate Quantitative Analyst
JP Morgan Chase
02.2017 - 07.2022
- Playing a key role in improving contact centre efficiency through statistical data analysis
- Performing Repeat Caller Analysis: effectively understanding the trends and patterns in data based on different KPI’s and developing a statistical model to identify key variables impacting repeat callers for Credit Cards; resulting in a save of 29 FTE's per annum.
- Coordinating with business stakeholders to incorporate business aspects of the data in the modelling phase
- Actively involved in Match Pair Analysis for identifying cross sell opportunities to Consumer Banking Customers, improving campaign efficiency by 17%.
- Identifying non escalated complaints using the e-mail data; utilizing support vector machine methodology in Python, developing a model to categorize e-mails into non-escalated complaints for improving customer satisfaction & reducing complaints. Reduction in complaints by 11%.
- Monitoring pilots for the new software introduced to improve contact centre operations
- Executing the end-to-end analytics for the pilots from deciding the Sample size to the selecting the test & control populations for AB testing
- Creating reports and dashboards
- Executing call centre demand mitigation analysis for digitally active customers wherein identifying opportunities where calls by self-servicing customers can be eliminated completely also supporting digital teams improve customer experience through insights gained from data
- Delivering strong solutions for building Chase Auto Spend Behaviour Personas: Based on the credit and debit spend patterns of existing ultra-luxury & mainstream vehicle owners in Chase Auto, identifying potential Chase Auto customers for marketing campaigns
- Using Random Forest technique used to segregate potential customers into Ultra-luxury vs Mainstream
- The solution also helped the marketing team to build a targeted campaign to maximize the ROI on the marketing budget
Data Scientist
Asterii Analytics (FCB Ulka)
06.2012 - 01.2017
- Prepared dashboards to monitor & track various KPIs for different brands and categories
- Monitored various campaigns to lead baby products’ branch of a reputed company
- Identified performance gaps from the tracker and drill down to ascertain the areas of concern
- Performed on-field research to find gaps in the tele-calling process of a company selling consumer durables, thereby improved CRM activity
- Analyzed the impact of different marketing strategies for a major pharmaceutical company to identify key effective Marketing Spends
- Effectively worked on basic market mix modelling to find the effective media mix for brands using in-house tools
- Worked on TGI (Target Group Index Data provided by IMRB) to segment different user profiles for various brands
- Played a key role in Social Media Analytics: Built queries to extract relevant data from Sysomos, analyzed social media data to understand the social media buzz and sentiment regarding the brand/category that is to be studied
- Actively participated in preparing for various pitches across different verticals
- Created automation processes for database maintenance using Excel VBA
Education
M.Sc. - Statistics
University of Mumbai
Mumbai 07.2010 - 06.2012
B.Sc. - Statistics
Ramnarain Ruia College
Mumbai 06.2007 - 04.2010
Skills
- Business & Data Analyst
- Data Analytics & Visualization; Tableau
- Data/Predictive Modelling
- Team Leadership & Stakeholder Management
- Quantitative & Statistical Analysis
- Consulting & Issue resolution skills
- SAS E Guide; SQL; Alteryx
- Python; Pyspark
- MS Excel, MS PowerPoint
Additional Academic Qualifications
Institute of Actuaries of India
- CT-1: Financial Mathematics
- CT-3: Probability & Mathematical Statistics
- CT-4: Models
- CT-6: Statistical Models
- CT-7: Business Economics
- CT-9: Business Awareness Module
Institute & Faculty of Actuaries, UK
- CT-2: Financial Reporting
- CT-5: Contingencies
- CT-8: Financial Economics
Awards & Recognition
TU CIBIL:
- WOW Award for Collections Recovery Analysis, Q4-22,
- WOW Award – for supporting Cloud Migration, Q3-24,
- Spot Award for supporting Cloud migration, Q3-24,
JP Morgan Chase
- Champions of Chase Award for effective demand mitigation, Q3 2018
- JPMC Customer First Champion, 2018
- Star of the Quarter Award, Q3 2019
- JPMC Innovation Champion, 2019
FCB Ulka
Provided strong support in one of the Projects for the Baby Products’ Company has won:
- Gold at the EMVIES (Media awards) in 2014
- Bronze at the EFFIES in 2014
Timeline
Assistant Vice President
TU CIBIL
07.2022 - Current
Associate Quantitative Analyst
JP Morgan Chase
02.2017 - 07.2022
Data Scientist
Asterii Analytics (FCB Ulka)
06.2012 - 01.2017
M.Sc. - Statistics
University of Mumbai
07.2010 - 06.2012
B.Sc. - Statistics
Ramnarain Ruia College
06.2007 - 04.2010
Similar Profiles
ASHOK PARAMESHWARANASHOK PARAMESHWARAN
AVP- Emerging Accounts at TransUnion CIBIL LimitedAVP- Emerging Accounts at TransUnion CIBIL Limited
Pratik JhaveriPratik Jhaveri
Assistant Vice President - Sales at TransUnion CIBIL LimitedAssistant Vice President - Sales at TransUnion CIBIL Limited
ISHAN CHAUDHURIISHAN CHAUDHURI
Intern at Transunion CIBILIntern at Transunion CIBIL