American Express Business Planning Analyst Interview Questions and Answers

Interview preparation tips for other job seekers - please select my profile

Interview preparation tips for other job seekers - Be Calm and composed and go through your resume properly.
Revise SQL, SAS, and Python if you are targeting a role in the business intelligence unit of axis bank

Interview preparation tips for other job seekers - Prepare few Guesstimates before going to the interview. Also it would benefit If you can provide an experience with the analytical tools you have mentioned in the resume. It really helps.

Round: Test
Experience: The coding question was:
Given a binary string containing 0's and 1's. You can split the string such that each partition should be a exponential of 5 (1,5,25,625...). You were asked to return minimum number of partition for the given string such each partition is exponential of 5. If no such partition exists return -1.
Examples: '101101101' Ans: 3 (101, 101, 101)
'111' Ans: 3 (1,1,1)
10101 Ans: -1
Tips: For MCQ's prepare DSA, OS and Networking. For DSA you can refer to cormen
For Coding question practice on either geeksforgeeks or from any of the coding platforms like hackerrank
The shortlist was mainly dependent on coding question
Duration: 1 hour 30 minutes

Round: Puzzle Interview
Tips: Do lot of puzzles from heard on the street, -----/ , Try to search for more. It will be helpful in other interviews as well

Round: Technical Interview
Tips: Practice algorithm section from geeksforgeeks. There are lot of standard problems. The given questions were slightly modified version of standard problems

Round: Technical Interview
Tips: For this round you need to be well prepared with your projects and resume.

College Name: IIT Madras

Round: Resume Shortlist
Experience: CGPA 6 Above shortlisted

Round: Technical Interview
Experience: DSA, Analytics, Business Knowledge

Round: Technical Interview
Experience: Project, DBMS, OOPS, DW, Probability, Puzzles

Round: Test
Experience: Test was consist of two sections
1.Quant
2.Aptitude
Tips: Since initial shortlisting was based on Test so focus on Quant and Aptitude
Duration: 40 minutes
Total Questions: 30

Round: Interview
Experience: Tested communication skill for the purpose of client interaction.

Round: Interview
Experience: Asked Questions relating to resume. the first part of the 2nd round was mostly on my intern,the profile of which matched with what they were looking for.Data mining ,Data analyst etc.they went in depth about my intern and asked every detail of how i proceeded in getting the final results. second part focussed on PAYPAL .
Tips: They didn't expect the candidate to know everything about PAYPAL but it is always good to know about the company as much as you can before attending the interview.

Round: Interview
Experience: They looked at the approach and tried to push us to the limits.
The most important factor is how you approach the problem and not if you end up with result then there was other question,they tested the approach even for that one.
Tips: Preparation on guesstimate and case studies will help you deal with question like that.

Skills: Communication skill, Problem solving skill
College Name: IIT MADRAS

Round: Case Study Interview
Experience: Q: Give me five steps to estimate the number of traffic lights in Bombay.
Me: I will divide the city into equidistant lines, both vertical and horizontal; sort of a mesh. Then I would take vertical and horizontal rectangles i.e. the rectangles which fall on length and breadth of the city. Starting with the horizontal ones I would try to estimate the number of roads going from east to west in each rectangle(depending on the type of area: residential, commercial or a highway) Similarly I would try to estimate the number of roads going from north to south in each vertical rectangle. Now I have the average number of roads per unit length and per unit breadth. Now, I can calculate the average number of roads intersecting per rectangle. Now if I have the data, I can also use the traffic density data to further improve my estimate, i.e. whether the traffic light is required in that rectangle or not.(depending upon the traffic density)
Q: Lets say that golden quadrilateral gets completed tomorrow. What would be its impact on the sales of Ashok Leyland?
Me: Sir, they would increase, as more and more traffic will shift from railways to roadways as the average time taken by road will decrease.
Q: If I say that the sales will decreases by road, the truk will make the same number of trips in less amount of time, thereby rendering overcapacity in the road transport market therefore the sales will decrease.
Me: (I actually didn't let him complete, I interrupted him in between and said that I got the logic)
Tips: Don't try to overstate the facts.

Skills:
Duration: 3
College Name: IIM Lucknow

Interview preparation tips for other job seekers - Be confident and prepare your resume well