Ishan Ladhani

Data Analyst

Edelweiss Group•  May 2018 - Present

Worked as a Data Analyst for various projects 1. Rejection Inference : The project aim was to check the performance of rejected applications for SME Lending unit. 2. DSA (Direct Selling Agents) Profiling : Analyzed data and created a dashboard to present state, city and date wise drill down analysis of Brokers performance based on approval rate, amount disbursed and delinquency rate 3. Geo Location Mapping of RMs (Regional Managers) : Created a dynamic web application facilitating users to visualize the location of RMs 4. Framework to anonymize data for external vendors : Developed script to mask the original numbers of Credit Unit & Bureau to issue to vendors for analysis 5. Procurement Analysis : Created an engine which provides continuous insights to executives regarding expenditure data of entire Edelweiss Group 6. Web Application for Effective Data Visualization : Constructed a dynamic web application for REAP (Real Estate Asset Purchasing) unit to facilitate administrators a. o visualize the projects and agents data b. o extract and spot agents situated nearby the projects selected c. o locate and identify opportunities(people interested in property) on Google Maps 7. Market Research and Data Extraction : Explored various zero EMI service providers & extracted information of their partner stores along with the product types 8. Vendor Selection Workbook : Created a workbook consisting of filters for comma-separated multiple category variables using VBA 9. SEBI (Securities and Exchange Board of India) Survey Analysis : Presented insights regarding investment behavior of people across India

Derivatives Trader

Edelweiss Group•  July 2017 - April 2018

STIR (Short Term Interest Rate) Trader  • Worked as a global derivative trader in Global Markets unit trading agreed-upon STIR – EURIBOR futures • The role was to take short term trades in outrights, spreads and fly using technical skills and market research • Traded on Stellar Trading Systems