Oracle Business Analyst Interview Questions and Answers

Interview preparation tips for other job seekers - 1.Be confident , Open and Prepared

2.Kindly understand the question and answer relating with some of the concepts you have studied

Round: Case Study Interview
Experience: Case: A multinational firm in oil and gas segment is looking at setting up a green field plant by collaborating with ONGC India. You being one of the directors chosen to work for this partnership what are the most important factors you would look at?
Case analysis:
I divided the decisions into HR, operations, finance and marketing related decisions. Since the venture was a new one I focused on the organizational chart development and the role of director in selecting the right people for higher and middle management roles. I also talked about getting policies with regard to skill set of workers, policy on unions being in place. Talked about setting up a township and hiring a contractor for it as the location is likely to be in a remote area. Also, focused on retaining and hiring of talent.
Marketing function decisions included pricing of product (based on cost estimates of sales force) and sales force for carrying out B2B activities. Discussion on operations was the most important one in this case. I talked about the role of director in hiring a contractor and overlooking the subcontractors used. I also talked about the timelines of the project and suggested a milestone based approach with penalties to ensure that the work gets done. In addition to contract related equipment i focused on the equipment specification to match to the capacity expectations. Aggregate planning with scaling up was also suggested to make the factory operational and to sort out initial issues. I focused on the supply chain related issues to transport the end product to customers.(Suggested pipeline)
Talked about the role of cost accountant in determining the price of the end product and also focused on selecting an external auditor to oversee the accounting standards.

Structure:
Divided the case as per verticals in an organization.
A guesstimate on the number of streetlights in Lucknow was asked (He asked me to be very short in description and wanted me to use numbers at every step) .
I approached this by assuming Lucknow to be close to a rectangle in shape the dimensions being 20 x 15 Km. Then i assumed the main streets to be passing though lines joining the mid points. I assumed that these roads to be two lane and had the highest density of lights. The next part was about the streets branching out of these streets and i assumed lower density of lights here. Thus i got a series and added them up to get the number of lights.
Tips: Ask for clarifications to the interviewer if needed. Practice a lot of cases with your peers.
Be clear about "Why ABC (or any firm in consideration)‟?

General Tips: Analyze the case patiently and try not to goof up during case interviews.
Skills:
College Name: IIM Lucknow