Friday, November 20, 2009

Interview questions for business analyst


Interview questions for business analyst


Interview Question: Can you tell me about a time when you discovered a more efficient way to do a work task?
Interview Answer Guide: Job seeker should be able to identify a time where he/she was having difficulty with a work task, found a way to rectify the faults and work more efficiently.

Interview Question: Tell me about a task that really tested your analytical abilities?
Interview Answer Guide: Job seeker should mention a time where he/she had to use reason and logic to resolve a problem. Job seeker may have analyzed all the relevant information and created a good, effective solution.

Interview Question: Tell me about a tricky situation for which you found a very simple solution? 
Interview Answer Guide: Job seekers answer should show that they are a problem solver, that they can analyze all the information, and come up with a solution.

Interview Question: Have you ever been in a real dilemma at work? What did you do to get out of it?
Interview Answer Guide: You should hear answers that show the job seeker has sound analytical skills to solve a problem; analyzes problems in great detail to come up with a solution.

Interview Question: Tell me about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Interview Answer Guide: Job seeker should be able to explain how they can compile facts and figures for preliminary analysis; derive relevant facts and information from the study of this data.

Interview Question: Can you tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Interview Answer Guide: Job seeker should have the character to admit mistakes. Also clarify: Were the steps he took correct? More importantly, has he/she learned from this mistake?


This page contains sample interview questions for business analyst. Although you never know what type of questions a business analyst may be asked on an interview, these are the type of questions that give many business analysts problems. 

It is very important to be prepared for an interview. During the course of an interview, you may be asked 30 questions or more. Just one bad answer can stand out and cost you the job. Make sure you are well prepared and have good answers to the typical interview questions for business analyst.
We will now go over the business analyst interview questions. We also provide effective answers to these questions. 

Interview questions for business analyst

You never know what you will be asked on a job interview. The following sample of interview questions for business analyst will help you prepare. You need to be able to answer all questions truthfully and professionally. Here are the business analyst interview questions:
Q. Tell me why are you considering leaving your present job? 
A. Regardless of the reason, do not bad mouth your current employer. Negativism will always hurt you. Good answers include: “There is no room for growth at my current employer. I am looking for a company with long term growth opportunities”. “Due to a company restructuring, my entire department is relocating to Florida. I was give the option of moving, but do not wish to relocate”. “My current company is not doing well, and has been laying off employees. There is no job security there, and more layoffs are expected”.
Q. What are your goals for the future? 
A. “My long term goals are to find a company where I can grow, continue to learn, take on increasing responsibilities, and be a positive contributor”.
Q. How do you handle stress and pressure? 
A. “I find that I work better under pressure, and I enjoy working in an environment that is challenging.” “I am the type of person that diffuses stress. I am used to working in a demanding environment with deadlines, and enjoy the challenges.”
Q. We have met several candidates. Why are you the one we should hire? 
A. Give definite examples of your skills and accomplishments. Be positive, and emphasize how your background matches the job description. Mention any software packages and spreadsheet software you are familiar with. Also let them know if you have advanced knowledge of any of the software.
Q. What do you know about our company? 
A. This question is used to see if you have prepared for the interview. Candidates that have researched the company are more appealing. Companies like prepared, organized candidates.
Q. What are your greatest strengths? 
A. Be positive and honest. “My greatest strength is maximizing the efficiency of my staff. I have successfully lead numerous teams on difficult projects. I have an excellent ability to identify and maximize each of my staffs strengths.” Give examples.
Q. Tell me about your greatest weakness? 
A. It is very important to give a strength that compensates for your weakness. Make your weakness into a positive. “I consider myself a 'big picture' person. I sometimes skip the small details. For this reason, I always have someone on my team that is very detail oriented.” Another good answer: “Sometimes, I get so excited and caught up in my work that I forget that my family life should be my number one priority.”
Hopefully these typical interview questions for business analyst will help you. It is important to customize the answers for your specific background and experience.
Now that we have gone over the business analyst interview questions, you need to be aware of important resources that can make your job search easier and more thorough.

INTERVIEW QUESTIONS FOR BUSINESS ANALYST



This page contains sample interview questions for business analyst. Although you never know what type of questions a business analyst may be asked on an interview, these are the type of questions that give many business analysts problems. 

It is very important to be prepared for an interview. During the course of an interview, you may be asked 30 questions or more. Just one bad answer can stand out and cost you the job. Make sure you are well prepared and have good answers to the typical interview questions for business analyst.
We will now go over the business analyst interview questions. We also provide effective answers to these questions. 

Interview questions for business analyst

You never know what you will be asked on a job interview. The following sample of interview questions for business analyst will help you prepare. You need to be able to answer all questions truthfully and professionally. Here are the business analyst interview questions:
Q. Tell me why are you considering leaving your present job? 
A. Regardless of the reason, do not bad mouth your current employer. Negativism will always hurt you. Good answers include: “There is no room for growth at my current employer. I am looking for a company with long term growth opportunities”. “Due to a company restructuring, my entire department is relocating to Florida. I was give the option of moving, but do not wish to relocate”. “My current company is not doing well, and has been laying off employees. There is no job security there, and more layoffs are expected”.
Q. What are your goals for the future? 
A. “My long term goals are to find a company where I can grow, continue to learn, take on increasing responsibilities, and be a positive contributor”.
Q. How do you handle stress and pressure? 
A. “I find that I work better under pressure, and I enjoy working in an environment that is challenging.” “I am the type of person that diffuses stress. I am used to working in a demanding environment with deadlines, and enjoy the challenges.”
Q. We have met several candidates. Why are you the one we should hire? 
A. Give definite examples of your skills and accomplishments. Be positive, and emphasize how your background matches the job description. Mention any software packages and spreadsheet software you are familiar with. Also let them know if you have advanced knowledge of any of the software.
Q. What do you know about our company? 
A. This question is used to see if you have prepared for the interview. Candidates that have researched the company are more appealing. Companies like prepared, organized candidates.
Q. What are your greatest strengths? 
A. Be positive and honest. “My greatest strength is maximizing the efficiency of my staff. I have successfully lead numerous teams on difficult projects. I have an excellent ability to identify and maximize each of my staffs strengths.” Give examples.
Q. Tell me about your greatest weakness? 
A. It is very important to give a strength that compensates for your weakness. Make your weakness into a positive. “I consider myself a 'big picture' person. I sometimes skip the small details. For this reason, I always have someone on my team that is very detail oriented.” Another good answer: “Sometimes, I get so excited and caught up in my work that I forget that my family life should be my number one priority.”
Hopefully these typical interview questions for business analyst will help you. It is important to customize the answers for your specific background and experience.
Now that we have gone over the business analyst interview questions, you need to be aware of important resources that can make your job search easier and more thorough.

Be a Better Needs Analyst

Question:
What is the last thing a needs analyst should be expected to do?
Answer:
Read minds.
In today's business market, analysts must have strong communication and technical skills, proficiency in the use of time-tested assessment instruments, and a fair amount of ingenuity. If they possess these qualities and have a firm commitment from their client, they will not need be clairvoyant.
Successful needs analyses rely on good strategies and the support of the client organization. This is the ideal foundation for beginning a needs study. Effective analysts can start out with a clear focus: to find the right problem and the right solution.
The classical approach to determining needs or problems is identifying the discrepancy between the desired and actual knowledge, skills, and performance (and specifying root causes). That difference is the training need. A variety of methods including interviews, observations, questionnaires, and tests may lead to identifying needs.
Using these methods effectively involves accurate gathering, analyzing, verifying, and reporting of data. Critical competencies for the analyst's role include the following:
  • understanding organizational structure, power, culture, and communication systems
  • understanding the factors that contribute to and hinder group and individual changes in organizations
  • identifying the knowledge and skills necessary to perform jobs; assessing individuals' abilities
  • using technology (such as computers, Webbased training, the Internet, intranets, CDRom) to assist training and evaluation
  • observing and describing behavior objectively
  • developing sound data collection and analysis methods
  • processing, synthesizing, and forming appropriate conclusions about the data
  • providing constructive feedback
  • designing presentations and communicating information, recommendations, suggestions, and ideas
What this means is that skilled analysts are now among the most important professionals in the training, development, and performance fields. Technological advances and expanding industries continually create new workplace training requirements, increasing the demand for skilled analysts and accurate assessment methods. With unrelenting budget cuts hitting training departments, today's trainers have bigger jobs, yet correspondingly smaller budgets than they did in the past. For many organizations, a sound needs analysis is essential to a return on training investment dollars and reduces the risk of funding inappropriate programs.
This issue of Info-line will help you improve your needs analysis techniques, paying special attention to administering interviews and questionnaires. It provides a beginning for the trainer who wants to conduct, report, and justify effective needs assessments.

Conducting the Needs Analysis

As with any analysis, there are procedures to be followed in order to produce a useful product. Here are six basic steps to help you focus your needs analysis.

Step 1: Define Your Objectives

Determine your purposes and objectives for the analysis. These factors are the bases for management planning and development decisions. Some objectives for conducting a needs analysis are as follows:
  • Distinguish employees who need training.
  • Identify performance problems, deficiencies, and the root causes.
  • Determine whether training is the best solution to the problems.

Nailing Down Needs Assessment

Across the nation trainers hear words like these:
Brad, in just a little over five weeks, our new blockbuster sandwich will be available to the public in 2,600 stores and franchises across the nation. I want to be certain that this sandwich is done right everywhere. It has to taste exactly the same in Boise and Boston. That's where you come in. Get some training ready to go so that our people know how to make that sandwich and make it good. Start with a needs assessment. But don't spend too long before you start writing that training.
Wilma, see that box over there? It's full of illustrated manuals that pretty much describe how the new system will work. Well, actually, that documentation is for the hospital, which is one-third our size, but the vendor swears that we'll be able to use it here. And here's Sharon Murray's number. She is the vendor rep who can help you out. We need this course and we need it fast. No time for a whatchamacallit, a needs assessment, this time.
The phrase needs assessment is everywhere, and everywhere it means something different. That makes it difficult to learn about, challenging to do well, and nearly impossible to explain to a skeptical colleague.
Fortunately there are some things about needs assessment that most experts recognize:
  1. It comes at the beginning of any systematic approach to training, prior to teaching anybody anything in any setting or technology.
  2. It is done to understand more about a performance problem—some gap between what is happening and what ought to be happening. This means that needs assessment is the systematic search for details about the difference between optimal and actual.
  3. There is a lot of verbal support for the idea of needs assessment, far more than for the time and resources it takes to do it well. When people want trainers to solve problems, they want them solved yesterday. If a needs assessment stands between the problem and a snappy new course, then needs assessment is suspect.
  4. People who conduct needs assessments usually do so using in-person and telephone interviews and questionnaires. Training literature clearly presents the leading characteristics of these two techniques: ease of data analysis, anonymity, opportunity to follow up responses, and cost.
  5. Needs assessments usually ask for people's feelings. The inquiry should focus on what sources feel is causing the performance problem and whether or not the trainees could perform successfully under pressure. Training resources should not be used on problems that better supervision or powerful incentive plans can dispatch.
  6. Training and therefore needs assessment is not about performance problems as much as it used to be. Now it is about new systems and technologies, necessitating expanded ways of understanding the situation before training.
These areas of accord provide little solace to people like Wilma and Brad who need to know what needs assessment is, why it is important, and how to do it. It is not just one act like sending out a survey. It is several stages of assessment, using several techniques, each of which gets you closer to knowing what is going on, and why.
Needs assessments are used to discover the following things:
Optimal performance Both of the trainers described above need to seek out the details of what constitutes excellent performance.
Actual performance How well is each employee performing? How have middle managers conducted their performance appraisals? New systems and technologies involve little examination of current, actual performance. These training needs assessments will be based primarily on information about optimals.
Attitudes on subject, skills, or technology This search is crucial for training design. Will Wilma walk into the hospital training center and be greeted with hostility? Do middle managers believe that the old appraisal system was perfectly adequate? Are they confident of their ability to master a computerized behavioral rating scale?
The cause or causes of the problem There are still those old-fashioned performance problems caused by poor incentives, motivation, skills, knowledge, or work environment. Which of these is the obstacle in Wilma's situation? Needs assessment must tell you that.
Trainers perform needs assessments until they know, in detail and conclusively, the nature of the mission (optimal minus actual); the attitudes or feelings; and the causes of problems. The search for information varies, depending on what got you started: a performance problem, or a new task, system, or technology.
Allison Rossett

  • Secure the support and commitment of management in the process of building and evaluating effective training programs.
  • Generate data that will be useful in measuring the impact of the training program.
  • Provide specific recommendations for training programs: scope, methods, frequency, cost, and location.
  • Decide priorities for the upcoming year and for long-range strategic planning.
  • Justify spending to top management by determining the value and cost of training. Calculate the difference between "no training" costs (the expenses incurred or monies lost by continuing with the same problems) and the costs of the training solution.

Step 2: Identify the Necessary Data

A thorough needs assessment requires information to identify:
  • the need
  • the solution
  • the population requiring training
  • the strategies for delivering training
Know the nature and quantity of the information you require for a useful assessment study. You may need opinions, attitude surveys, financial statements, job descriptions, performance appraisals, work samples, or historical documents from the company's archives.

Step 3: Select Data Collection Method

Choose or design a method for gathering data. Use various combinations of the following methods, alternating between their structured and unstructured versions: interviews, questionnaires, observation, group discussion, key consultation, work samples, records, reports, and tests.
Base-structured or formal assessment methods on the necessary data as outlined in step two and also on a comparison of each method's degree of effectiveness for gathering the data. Validate all instruments (questionnaires, surveys, and so forth) used in this approach.

Step 4: Collect the Data

If you are dealing with a sample or study group, administer the questionnaires, conduct the interviews, observe performances, and so forth.

Step 5: Analyze and Confirm the Data

Compare the new data with past years' information and analyze to uncover problems and related trends or patterns. Confirm results and check for accuracy by consulting with the persons who originally provided the information.

Step 6: Prepare the Final Report

Point out problems, needs, weak areas, and recommend strategies for improvement. Using tables, graphs, and other support data for findings, design a clear and interesting presentation with well-written materials and attractive visuals. Some presentation skills are also necessary. Refer to Info-lines No. 8410, "How to Prepare and Use Effective Visual Aids"; No. 8606, "Make Every Presentation a Winner"; and No. 9409, "Improve Your Communications and Speaking Skills".



Agile Development

Agile Development

  1. What does Agile mean?
  2. Can you explain Agile modelling?
  3. What are core and supplementary principles in Agile modeling?
  4. What is the main principle behind Agile documentation?
  5. What are the different methodologies to implement Agile?
  6. What is XP?
  7. What are User Stories in XP and how different are they from requirement?
  8. Who writes User stories?
  9. When do we say a story is valid?
  10. When are test plans written in XP?
  11. Can you explain the XP development life cycle?
  12. Can you explain how planning game works in Extreme Programming?
  13. How do we estimate in Agile?
  14. On What basis can stories be prioritized?
  15. Can you point out simple differences between Agile and traditional SDLC?
  16. Can you explain the concept of refactoring?
  17. What is a feature in Feature Driven Development?
  18. Can you explain the overall structure of FDD project?
  19. Can you explain the concept of time boxing?
  20. When to choose FDD and when to choose XP?
  21. What is SCRUM?
  22. What does product owner, product back log and sprint mean in SCRUM?
  23. Can you explain how SCRUM flows?
  24. Can you explain different roles in SCRUM?
  25. Can you explain DSDM?
  26. Can you explain different phases in DSDM?
  27. Can you explain in detail project life cycle phase in DSDM?
  28. Can you explain LSD?
  29. Can you explain ASD?

Six Sigma

Six Sigma

  1. What is six sigma?
  2. Can you explain the different methodology for execution and design process in SIX
  3. sigma?
  4. What does executive leaders, champions, Master Black belt, green belts and black belts
  5. mean?
  6. What are the different kinds of variations used in six sigma?
  7. Can you explain the concept of standard deviation?
  8. Can you explain the concept of fish bone/ Ishikawa diagram?
  9. What is Pareto principle?
  10. Can you explain QFD?
  11. Can you explain FMEA?
  12. Can you explain X bar charts?
  13. Can you explain Flow charting and brain storming?

CMMI

CMMI

  1. What is CMMI?
  2. what’s the difference between implementation and Institutionalization?
  3. what are different models in CMMI?
  4. Can you explain staged and continuous models in CMMI?
  5. Can you explain the different maturity levels in staged representation?
  6. Can you explain capability levels in continuous representation?
  7. which model should we use and under what scenarios?
  8. How many process areas are present in CMMI and in what classification do they fall in?
  9. What the difference between every level in CMMI?
  10. what different sources are needed to verify authenticity for CMMI implementation?
  11. Can you explain SCAMPI process?
  12. How is appraisal done in CMMI?
  13. which appraisal method class is the best?
  14. Can you explain the importance of PII in SCAMPI?
  15. Can you explain implementation of CMMI in one of the Key process areas?
  16. Explanation of all process areas with goals and practices?
  17. Can you explain the process areas?

Software process

Software process

  1. What is a Software process?
  2. what are the different cost eleme nt involved in implementing process in an organization?
  3. What is a model?
  4. What is maturity level?
  5. Can you explain the concept of process area in CMMI?
  6. Can you explain the concept of tailoring?

Estimation, Metrics and Measure

Estimation, Metrics and Measure

  1. What is meant by measure and metrics?
  2. Which metrics have you used for tracking purpose?
  3. What are the various common ways of estimation?
  4. Can you explain LOC method of estimation?
  5. How do we convert LOC in to effort?
  6. Can you explain COCOMO?
  7. Can you explain Intermediate COCOMO and COCOMO II?
  8. How do you estimate using LOC?
  9. Can you explain in brief Function points?
  10. Can you explain the concept Application boundary?
  11. Can you explain the concept of elementary process?
  12. Can you explain the concept of static and dynamic elementary process?
  13. Can you explain concept of FTR, ILF, EIF, EI, EO , EQ and GSC ?
  14. How can you estimate number of acceptance test cases in a project?
  15. Can you explain the concept of Use Case’s?
  16. Can you explain the concept of Use case points?
  17. What is a use case transaction?
  18. How do we estimate using Use Case Points?
  19. Can you explain on what basis does TPA actually work?
  20. How did you do estimation for black box testing?
  21. How did you estimate white box testing?
  22. Is there a way to estimate acceptance test cases in a system?
  23. Can you explain Number of defects measure?
  24. Can you explain number of production defects measure?
  25. Can you explain defect seeding?
  26. Can you explain DRE?
  27. Can you explain Unit and system test DRE?
  28. How do you measure test effectiveness?
  29. Can you explain Defect age and Defect spoilage?

Costing

Costing

  1. Can you explain PV, AC and EV?
  2. Can you explain BCWS, ACWS and BCWP?
  3. What are the derived metrics from Earned Value?
  4. Can you explain earned value with a sample?