Deloitte Project Controller Interview Questions and Answers

Q1. What is the S curve, and how do you create it in Primavera P6 and Excel?
Ans. 
The S curve is a graphical representation of project progress over time, showing cumulative costs or work completed.
• 1. Define the project scope and timeline to establish baseline data.

• 2. In Primavera P6, use the 'Earned Value' feature to track progress.

• 3. Create a cumulative cost curve by plotting actual vs. planned costs over time.

• 4. In Excel, use a line chart to visualize cumulative data points for planned and actual...read more
Answered by AI
Add your answer
Q2. What is the Spotlight feature, and how does it assist users?
Ans. 
The Spotlight feature enhances user experience by providing focused insights and streamlined navigation within applications.
• Offers contextual information based on user actions, improving decision-making.

• Facilitates quick access to relevant data, reducing time spent searching.

• Can highlight key performance indicators (KPIs) for project tracking.

• Example: In project management software, it may spotlight overdue tasks or bu
Answered by AI
Add your answer
Q3. What are (OBS) and (EPS), and how are they related?
Ans. 
OBS (Organizational Breakdown Structure) and EPS (Enterprise Project Structure) are frameworks for project management organization.
• OBS defines the hierarchy of the organization involved in the project, showing roles and responsibilities.

• EPS outlines the overall structure of projects within an organization, including all projects and their relationships.

• Example of OBS: A project team may include a project manager, engin...read more
Answered by AI
Add your answer
Q4. What is a baseline in project management, what are its types, and how can it be created in Primavera P6?
Ans. 
A baseline in project management is a reference point for measuring project performance and progress.
• Types of baselines include Scope Baseline, Schedule Baseline, and Cost Baseline.

• Scope Baseline defines the project's deliverables and work required.

• Schedule Baseline outlines the planned start and finish dates for project activities.

• Cost Baseline represents the approved budget for the project.

• In Primavera P6, a baseline...read more
Answered by AI
Add your answer
Q5. What is a network diagram?
Ans. 
A network diagram visually represents project tasks, their dependencies, and the sequence of activities.
• Illustrates the flow of tasks in a project.

• Helps identify critical paths and dependencies.

• Common types include PERT and CPM diagrams.

• Example: A construction project showing tasks like design, permits, and building phases.
Answered by AI
Add your answer
Q6. What difficulties did you face in your last project?
Ans. 
Faced challenges in resource allocation, stakeholder communication, and budget constraints during my last project.
• Resource Allocation: We struggled with limited resources, leading to delays in project milestones. For example, key personnel were double-booked.

• Stakeholder Communication: Misalignment in expectations caused confusion. Regular updates and meetings helped clarify objectives.

• Budget Constraints: Unexpected cos...read more
Answered by AI
Add your answer
Q7. What is a risk register, and what is the difference between an issue and a risk?
Ans. 
A risk register is a tool for documenting risks and issues in a project, helping manage potential problems effectively.
• A risk register lists identified risks, their impact, likelihood, and mitigation strategies.

• An issue is a current problem that needs resolution, while a risk is a potential future problem.

• Example of a risk: 'There is a chance of budget overruns due to unforeseen expenses.'

• Example of an issue: 'The proj...read more
Answered by AI
Add your answer
Q8. What was the budget for your last project, and how did you manage any delays that occurred?
Add your answer
Q9. What is an extension of time, and how did you communicate this with the client?
Ans. 
An extension of time is a formal request to prolong project deadlines due to unforeseen circumstances.
• An extension of time is typically requested when delays occur due to factors beyond the contractor's control.

• Examples include adverse weather conditions, supply chain disruptions, or changes in project scope.

• Communication with the client involves providing detailed documentation of the reasons for the delay.

• I would sch...read more
Answered by AI
Add your answer
Q10. Can you explain your role in your previous company?
Ans. 
As a Project Controller, I managed project budgets, schedules, and performance metrics to ensure successful project delivery.
• Developed and maintained project budgets, ensuring alignment with financial forecasts.

• Monitored project timelines and milestones, using tools like MS Project to track progress.

• Conducted regular risk assessments to identify potential issues and implemented mitigation strategies.

• Collaborated with c...read more
Answered by AI
Add your answer

Q1. Do you have PowerBI expertise?
Ans. 
Yes, I have expertise in PowerBI.
• Proficient in creating interactive reports and dashboards using PowerBI

• Experience in data visualization and analysis

• Skilled in connecting to various data sources and transforming data for reporting

• Familiar with DAX formulas for advanced calculations

• Certified in PowerBI is a plus
Answered by AI
Add your answer

1. One question was given to be solved in 1 hour. Question was medium level based on strings.

Q1. 1. 1:1 interview, mostly discussion around OOPS concepts and some basic dynamic programming questions.
Add your answer

1. 3 questions were given out of which any 2 needed to be solved. 1 question related to Database design and query, 2 questions related to DSA, both DSA questions were medium-hard type based on Dynamic programming and graph.
I solved one Dynamic programming question and Database question.

Q1. 1. This round was the follow up of last case study round. Interviewer gave various use cases to test on the algorithms that I had written. Some discussion related to OOPS concepts and Database design quest...read more
Add your answer

Q1. It was final discussion, mostly around cultural fit and classic HR questions. It was easy one, I'd say.
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

This test consists of two coding questions and some MCQ regarding computer fundamentals.

Q1. 
Kevin and His Cards Problem Statement
Kevin has two packs of cards. The first pack contains N cards, and the second contains M cards. Each card has an integer written on it. Determine two results: the tot...read more
Ans. 
Find total distinct card types and common card types between two packs of cards.
• Create a set to store distinct card types when combining both packs.

• Iterate through each pack and add card types to the set.

• Find the intersection of card types between the two packs to get common card types.
Answered by AI
Add your answer
Q2. 
Allocate Books Problem Statement
Given an array of integers arr, where arr[i] represents the number of pages in the i-th book, and an integer m representing the number of students, allocate all the books ...read more
Ans. 
Allocate books to students in a way that minimizes the maximum number of pages assigned to a student.
• Iterate through all possible allocations of books to students.

• Calculate the maximum number of pages assigned to a student for each allocation.

• Return the minimum of these maximums as the result.
Answered by AI
Add your answer

Round duration - 40 minutes
Round difficulty - Easy

It was a technical round that is based on DSA and computer fundamentals.

Q1. 
Reverse Linked List Problem Statement
Given a singly linked list of integers, return the head of the reversed linked list.
Example:
Initial linked list: 1 -> 2 -> 3 -> 4 -> NULL
Reversed link...read more
Ans. 
Reverse a singly linked list of integers and return the head of the reversed linked list.
• Iterate through the linked list and reverse the pointers to point to the previous node instead of the next node.

• Use three pointers - prev, current, and next to reverse the linked list in O(N) time and O(1) space complexity.

• Update the head of the reversed linked list as the last node encountered during the reversal process.
Answered by AI
Add your answer
Q2. 
Sort 0 1 2 Problem Statement
Given an integer array arr of size 'N' containing only 0s, 1s, and 2s, write an algorithm to sort the array.
Input:
The first line contains an integer 'T' representing the n...read more
Ans. 
Sort an array of 0s, 1s, and 2s in linear time complexity.
• Use three pointers to keep track of 0s, 1s, and 2s while traversing the array.

• Swap elements based on the values encountered to sort the array in-place.

• Time complexity should be O(N) and space complexity should be O(1).
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

This was an online aptitude round on the Talview platform which we can give from our Home. To attempt this test, we have been given a window of 12-24 hours. It was a proctored online test. The round consisted of 60 aptitude questions in 60 minutes of time without any negative marking. The aptitude test consisted of various questions of Logical Reasoning, Mental Ability, Data Interpretation Questions, Numerical Reasoning.

Q1. 
Matrix Transpose Problem Statement
Given a matrix MAT, your task is to return the transpose of the matrix. The transpose of a matrix is obtained by converting rows into columns and vice versa. Specificall...read more
Ans. 
Transpose a given matrix by switching rows and columns.
• Iterate through the matrix and swap elements at [i][j] with [j][i].

• Create a new matrix to store the transposed values.

• Ensure the dimensions of the transposed matrix are reversed from the original matrix.
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

This was a video interview round taken immediately after the Aptitude test, it was a proctored round on Talview platform. This round consisted of 8 questions, we have to answer each question in the span of 3 mins and 10 secs were given for reading the question, our audio and video was being recorded while answering those questions. Our soft skills were being judged in this round. The questions basically consisted of HR questions and Guesstimates

Round duration - 120 minutes
Round difficulty - Hard

This round was the case study round, in this round, we were provided a case study which we had to solve in 1 hour using pen and paper and had to share the answers of the case study questions in a PDF format to the HR, the questions were related to market share, advertisement strategies, and can be easily solved using basic mathematics. After this, there was be a one-to-one interview on Zoom Platform in which the interviewer will ask you to describe your approach for every question you have solved in the case study, they will not ask for the exact answer, all they ask is about your approach that you have used to solve a particular problem and the way you explain it. They may or may not ask some guesstimates or puzzles as well in this round. The interviewer was very friendly and he gave me hints as well if I was stuck somewhere.

Round duration - 60 minutes
Round difficulty - Hard

The next round was the Behavioral interview round, in this round, the interviewer asked me about my projects and some guesstimates or puzzles. This round was for 1 hour. The interviewer was very friendly and helpful, she helped me if I was stuck somewhere, she kept me calm during the interview process.

Q1. How many people do you estimate watched Ramayana/Mahabharat during the first month of the Covid lockdown in 2020?
Add your answer

Round duration - 40 minutes
Round difficulty - Hard

The fit round was my final interview round, in this, you will meet the manager/Principal from the company. They will basically check whether you are fit for the organization. They ask about the projects I have done in college/internships. Some basic questions like what are your strengths and weaknesses, why do you want to join the company and some guesstimates or puzzles as well.
On-campus, the behavioral and fit interview rounds were combined into one.
This round was of 40 minutes and the interview was taken on Zoom, the interviewer was helpful and sweet.

Q1. How many pizzas are sold in one day in Pune?
Ans. 
The number of pizzas sold in Pune in one day varies depending on factors like day of the week, weather, events, etc.
• The number of pizzas sold in Pune can range from hundreds to thousands in a day.

• Factors like day of the week (weekend vs weekday), weather (rainy vs sunny), events (festivals, holidays) can impact the sales.

• Popular pizza outlets in Pune like Domino's, Pizza Hut, etc. contribute to the overall sales.

• Data f...read more
Answered by AI
Add your answer