Competitions

CAT Prep

Upskill

Placements

MBA Co'26

RTI Response

Rankings

Score Vs. %ile

Salaries

Campus Tour

1024^2 and more - Internship Experience at Standard Chartered Bank

Jun 18, 2014 | 4 minutes |

Join InsideIIM GOLD

Webinars & Workshops

Compare B-Schools

Free CAT Course

Take Free Mock Tests

Upskill With AltUni

CAT Study Planner

1 Day to CAT 2024 (All the best)

Participants: 26

Final 2 Days to CAT 2024 Test-44

Participants: 380

Final 3 Days to CAT 2024 Test-43

Participants: 317

Final 4 Days to CAT 2024 Test-42

Participants: 355

Final 5 Days to CAT 2024 Test-41

Participants: 372

Final 6 Days to CAT 2024 Test-40

Participants: 351

Final 7 Days to CAT 2024 Test-39

Participants: 345

Final 8 Days to CAT 2024 Test-38

Participants: 317

Final 9 Days to CAT 2024 Test-37

Participants: 328

Final 10 Days to CAT 2024 Test-36

Participants: 290

Final 11 Days to CAT 2024 Test-35

Participants: 508

Final 12 Days to CAT 2024 Test-34

Participants: 336

Final 13 Days to CAT 2024 Test-33

Participants: 298

Final 14 Days to CAT 2024 Test-32

Participants: 279

Final 15 Days to CAT 2024 Test-31

Participants: 367

Final 16 Days to CAT 2024 Test-30

Participants: 298

Final 17 Days to CAT 2024 Test-29

Participants: 312

Final 18 Days to CAT 2024 Test-28

Participants: 343

Final 19 Days to CAT 2024 Test-26

Participants: 338

Final 20 Days to CAT 2024 Test-26

Participants: 307

Final 21 Days to CAT 2024 Test-25

Participants: 253

Final 22 Days to CAT 2024 Test-24

Participants: 268

Final 23 Days to CAT 2024 Test-23

Participants: 180

Final 24 Days to CAT 2024 Test-22

Participants: 227

Final 25 Days to CAT 2024 Test-21

Participants: 226

Final 26 Days to CAT 2024 Test-20

Participants: 278

Final 27 Days to CAT 2024 Test-19

Participants: 232

Final 28 Days to CAT 2024 Test-18

Participants: 235

Final 29 Days to CAT 2024 Test-17

Participants: 247

Final 30 Days to CAT 2024 Test-16

Participants: 283

This is an entry for Summer Saga 2014 contest from XLRI Jamshedpur "1048576" has been my WhatsApp status for 2 months now. It is nothing but the maximum no. of rows in an excel sheet I have worked on, and the opportunity obviously came as a part of the project. In an internship which involved working with huge data, product planning, customer handling, process improvement and market research, there was no facet of the MBA  gamut left untouched. Project title: Portfolio retention management, Mortgage Products (Standard Chartered Bank, India) Portfolio attrition is a burgeoning issue in the Indian banking market. With RBI pushing for a transparent market by discouraging loan pre-closure penalty and switch fees balance transfer and frequent rate bargaining in the Indian loan  market has become commonplace. The aim of the project was to reduce the same. Due to confidentiality clause, I wouldn't be able to discuss the project in detail, but I'll try to broadly cover most of it: Creating a customer profile: As a bank, we had an idea of the customer attrition in terms of broad numbers but we didn't know if customers of a particular profile were churning more than the others. I developed a customer profiling model using statistical tools (eg. ANOVA, T-test using SPSS) and achieved two prominent profiles which we focused on. Data Analysis: With a lot of data on different kinds of attrition and customers involved, I did a thorough seasonality analysis followed by customized product planning to make the customer sticky to the proposition. Pilot Project 1: As a part of the project I devised a whole new dimension in retention by using sales and reaching the customer at a personal level with customized offers after a series of negotiations. Pilot project 2: To catch a customer at a nascent stage of dissatisfaction, I implemented a model using CIR enquiries raised in consultation with TransUnion Software Co. The project is expected to impact Training: Since a lot of changes had been initiated in a  short period of time, different teams had to be trained regarding the same. So, with the help of a couple of my team members I designed the training module which was implemented by the bank's training team. Impact: In a span of two months a direct impact of more than INR 700 Million could be seen as a result of these changes. Also, it is expected to bring down customer churning by another 20% in the coming months. Presentation: The presentation won applause from top management and I got selected for the CEO Hall of fame (3 out of a batch of 37 interns did). It was an amazing experience as this was the first time in my life that I was presenting to a board, and man that board room was intimidating. They were very receptive of the recommendations and changes and suggested me to get these implemented in other departments too. Getting an iPad and an individual photo with the CEO was the icing in the cake! Amazing people: None of what I could learn and do would have been possible without the awesome team I had. Every product manager I came across helped me with new insights. Each and every nuance of every little change was discussed in detail before being implemented. The best part was that they made me feel belonged to the place and task. And yes, we had some great team-parties! Surprise Surprise!: A very important lesson that I learnt during the course of the internship was that the theoretical aspects that are being taught at a B-school (and often ridiculed by students while in the process) can help one establish solid results, form models and develop end-to-end process changes. In a Banking project I could use things taught in marketing research, finance, accountancy, management information systems and even operations. Akshay Tiwari, a PGDBM student from XLRI, Jamshedpur has a passion for writing and has appeared in editorials of several leading dailies including The Hindu. He blogs at http://akshay-tiwari.blogspot.in/