Senior Analyst Interview Questions
24K
Senior Analyst interview questions shared by candidates
How would you handle an irrate internal customer during a business meeting?
2 Answers↳
I would definetly keep my cool and act very professional and say... I understand your concerns. Please send me your issues in an email and I will make sure I set up a conference call so we can discuss them in further detail. Less
↳
Good indication of behaviors that are common in this organization. No job is worth total humiliation. Less
What would you do if you were told to just reproduce an existing report for requirements?
1 Answers↳
ie as a system analyst you need to evaluate the report, determine if there is an existing report that would meet needs, determine what within existing report is used and how to determine what true requirements are Less
How has your previous experience prepared you for a role like this?
1 Answers↳
Working with my previous employer required high levels of critical thinking and ultimately decision making. Having that accountability has prepared me to have a level of autonomy to complete day to day functions working hand in hand with teammates, but requiring little assistance. Less
Tell me a time when you had to influence clients to follow a different course of action.
1 Answers↳
I explained the context for my client's initial inclination and how I persuaded them to adopt a different alternative through case studies, data and postulating how their selection would impact their users in the future (creative visualization). Less
CASE: Cross-selling Credit Insurance to Cardholders direct mail: .50, 1% response rate, avg balance $1000, 5% claim insurance, etc. Profitable? How make more profitable? What if response rate doubled but claims doubled? Make chart of profit curve, what does it mean if..., etc.
12 Answers↳
Thanks for your response and guidance. I knew the revenue is monthly, but i thought claim rate is also monthly and hence calculated profit for each credit insurance sold per month. In light of your clarification Profit per card insurance per year = (10*12)-50-50 = 20$ per year If we chose to calculate per month, we will need to consider monthly claim rate as (5/12) and also amortize the marketing expense over next 12 month. Profit per card insurance per month = 10-(50/12)-(50/12)= (20/12)$ per month The profitability equation (per card per year) = 120x-10xy-50 For calculating any of the break even rates (x or y assuming 1 is known), 120x-10xy-50 = 0. For graph, P = 120x-10xy-50 Let me know if my analysis/answer is accurate and up to the mark. Thanks a lot for all your guidance. Less
↳
@ ghachla: The response rate is 1% that is 1 out of 100. I assumed 100 people are sent the mail. Hence the response rate is 1. As for the claim rate, the people who don't respond can't make claims. So out of the people who respond, the claim rate is 5% (i.e 1 person responds in 100 and out of that 1, 0.05 make the claim); Or to make it more clearer, if we assume 10000 people are sent the mail, 100 respond (because of the 1% response rate) and 5 out of the 100 make claims (because of the 5% claim rate). Less
↳
Looks like I left out the price of the insurance: customers would pay 1% of monthly balance for insurance. Less
The company is losing 1 million subscribers every month. What are the possible reasons for losing subscribers? Given the company is losing subscribers at this pace, how long can the company continue, until it starts making loss?
10 Answers↳
25 months
↳
12Bn Rev Per year 9BN cost per year Customer Loss per year = 1million *12 months = 12 million customers Revenue per customer per year = 36 + 7*12 = $120 Each year, company looses 1.44BN. = (12 million *120) To make a loss, company must loose 3BN 3BN/1.44BN = 2.083 years 2.083 years = 25 months. Less
↳
25 months doesn't sound right... Revenue: $12 billion Costs: $9 billion Profit: $3 billion Customer lost/month = 1 million Revenue lost/month = (36/12 + 7) = $10 * 1 million = $10 million Break even = $3 billion / $10 million = 300 months 300 months / 12 = 25 years The only way I can see 25 months is if we assumed Ad Revenue is Annual and CANNOT be broken down to month average/customer. In that case Annual Revenue/Customer = 36 + (7 *12) = $120/customer Total lost revenue/month = 120 * 1 million = 120 million Breakeven = 3 billion / 120 million = 25 months Less