Monday, November 5, 2007

Business Systems Analyst Responsibilities

Business Systems Analyst Responsibilities


Job Responsibilities

  • Act as a strategic partner between the business community and IT development teams to resolve functional and technical issues related to business applications, to troubleshoot data or transaction issues, and to review opportunities to leverage new functionality
  • Drive efficiency and operational improvement through business process definition, system alignment, and optimization of standard business application functionality.
  • Identify gaps between the current deployment of applications and future requirements that have evolved due to organizational growth, changes, or strategy. Translate business requirements into system definitions and solutions.
  • Lead cross-functional efforts to address business process or systems issues
  • Analyze requests or requirements for application patches or upgrades to determine impact to business and integrated systems
  • Comprehensive project management of new business application initiatives, performing requirements gathering, development effort estimates, resource management, gap analysis, implementation configuration, scope control, testing, training and end-user support, according to project methodology
  • Work with business community to document functional test scenarios, test plans, and end-user acceptance testing criteria


  • Participate in technical design sessions, working with technical resources, to provide insight during solution development
  • Identify and communicate project risks and recommend solutions
  • Designing, interpreting, or using complex logical data and object models to guide technical design decisions and overall business applications strategy
  • Provide support during period close and other major financial milestones of the company
  • Provide ad hoc data queries or reports to the business for analysis (using TOAD, Hyperion, or other query tools)
  • Promote use and acceptance of project methodology and documentation standards

Qualifications Requirements

  • Deep business applications experience (including Oracle Financials, Purchasing, Inventory, BOM, and Order Management)
  • Strong financial accounting knowledge and industry experience
  • Full analytical capability based on understanding of technical architecture and query tools
  • Exceptional leadership, written and oral communication, and meeting facilitation skills
  • Experience in software implementations, requirements gathering, systems analysis, and functional design
  • Ability to communicate effectively with both business and technical staff to convey complex ideas both verbally and in written form
  • Ability to quickly grasp concepts relating to customizations that have been designed and developed.
  • Ability to translate business requirements into high-level and detailed functional specifications.
  • Exposure to various project management methodologies and their application to cross-functional project work.
  • Demonstrated success in leading a team, with both functional and technical resources, to address cross-functional issues
  • CPA or related background a plus

Business analyst interview questions

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. Can you 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. 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 business analyst’s. 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.”

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”.

Hopefully these typical business analyst interview questions will help you. It is important to customize the answers for your specific background and experience.

Now that we have gone over the interview questions for business analyst, you need to be aware of important resources that can make your job search easier and more thorough.

What can a Business Analyst do differently than project मेनेजर?

A project/program manager, as the name suggests, is mostly concerned with the progress of the entire project and taking care of the project members. This includes cost management (invoicing, billing), time management (scheduling), risk management (project closure) and similar things.

A business analyst is mostly concerned with gathering and documenting business requirements (application requirements) and communicating them to the development and test teams.

Hope this clarifies your question.

Business analyst interview questions

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. Can you 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. 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 business analyst’s. 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.”

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”.

Hopefully these typical business analyst interview questions will help you. It is important to customize the answers for your specific background and experience.

Now that we have gone over the interview questions for business analyst, you need to be aware of important resources that can make your job search easier and more thorough.

Monday, May 14, 2007

The Secrets of Great Due Diligence

The Secrets of Great Due Diligence

This is in continuation of self-study material, I have searched during my exploration of new ideas and knowledge base. My intention is just to compile related material at one place for everyone.
Food for Thoughts.



With Thanks:
A Harvard Business Review excerpt.



Sealing the deal is the easy part. But first comes due diligence. Here's how to calculate your target's stand-alone value.


Deal making is glamorous; due diligence is not. That simple statement goes a long way toward explaining why so many companies have made so many acquisitions that have produced so little value. Although big companies often make a show of carefully analyzing the size and scope of a deal in question—assembling large teams and spending pots of money—the fact is, the momentum of the transaction is hard to resist once senior management has the target in its sights. Due diligence all too often becomes an exercise in verifying the target's financial statements rather than conducting a fair analysis of the deal's strategic logic and the acquirer's ability to realize value from it. Seldom does the process lead managers to kill potential acquisitions, even when the deals are deeply flawed. [...]

What can companies do to improve their due diligence? To answer that question, we've taken a close look at twenty companies—both public and private—whose transactions have demonstrated high-quality due diligence. We calibrated our findings against our experiences in 2,000-odd deals we've screened over the past ten years. We've found that successful acquirers view due diligence as much more than an exercise in verifying data. While they go through the numbers deeply and thoroughly, they also put the broader, strategic rationale for their acquisitions under the microscope. They look at the business case in its entirety, probing for strengths and weaknesses and searching for unreliable assumptions and other flaws in the logic. They take a highly disciplined and objective approach to the process, and their senior executives pay close heed to the results of the investigations and analyses—to the extent that they are prepared to walk away from a deal, even in the very late stages of negotiations. For these companies, due diligence acts as a counterweight to the excitement that builds when managers begin to pursue a target.

The successful acquirers we studied were all consistent in their approach to due diligence. Although there were idiosyncrasies and differences in emphasis placed on their inquiries, all of them built their due diligence process as an investigation into four basic questions:

  • What are we really buying?

  • What is the target's stand-alone value?

  • Where are the synergies—and the skeletons?

  • What's our walk-away price?

[Here] we'll examine each of these questions in depth, demonstrating how they can provide any company with a solid framework for effective due diligence. [...]

Once the wheels of an acquisition are turning, it becomes difficult for senior managers to step on the brakes.

What is the target's stand-alone value?
Once the wheels of an acquisition are turning, it becomes difficult for senior managers to step on the brakes; they become too invested in the deal's success. Here, again, due diligence should play a critical role by imposing objective discipline on the financial side of the process. What you find in your bottom-up assessment of the target and its industry must translate into concrete benefits in revenue, cost and earnings, and, ultimately, cash flow. At the same time, the target's books should be rigorously analyzed not just to verify reported numbers and assumptions but also to determine the business's true value as a stand-alone concern. The vast majority of the price you pay reflects the business as is, not as it might be once you've won it. Too often the reverse is true: The fundamentals of the business for sale are unattractive relative to its price, so the search begins for synergies to justify the deal.

Of course, determining a company's true value is easier said than done. Ever since the old days of the barter economy, when farmers would exaggerate the health and understate the age of the livestock they were trading, sellers have always tried to dress up their assets to make them look more appealing than they really are. That's certainly true in business today, when companies can use a wide range of accounting tricks to buff their numbers. Here are just a few of the most common examples of financial trickery used:

  • Stuffing distribution channels to inflate sales projections. For instance, a company may treat as market sales many of the products it sells to distributors—which may not represent recurring sales.

  • Using overoptimistic projections to inflate the expected returns from investments in new technologies and other capital expenditures. A company might, for example, assume that a major uptick in its cross selling will enable it to recoup its large investment in customer relationship management software.

  • Disguising the head count of cost centers by decentralizing functions so you never see the full picture. For instance, some companies scatter the marketing function among field offices and maintain just a coordinating crew at headquarters, which hides the true overhead.

  • Treating recurring items as extraordinary costs to get them off the P&L. A company might, for example, use the restructuring of a sales network as a way to declare bad receivables as a onetime expense.

  • Exaggerating a Web site's potential for being an effective, cheap sales channel.

  • Underfunding capital expenditures or sales, general, and administrative costs in the periods leading up to a sale to make cash flow look healthier. For example, a manufacturer may decide to postpone its machine renewals a year or two so those figures won't be immediately visible in the books. But the manufacturer will overstate free cash flow—and possibly mislead the investor about how much regular capital a plant needs.

  • Encouraging the sales force to boost sales while hiding costs. A company looking for a buyer might, for example, offer advantageous terms and conditions on postsale service to boost current sales. The product revenues will show up immediately in the P&L, but the lower profit margin on service revenues will not be apparent until much later.

To arrive at a business's true stand-alone value, all these accounting tricks must be stripped away to reveal the historical and prospective cash flows. Often, the only way to do this is to look beyond the reported numbers—to send a due diligence team into the field to see what's really happening with costs and sales.

That's what Cinven, a leading European private equity company, did before acquiring Odeon Cinemas, a UK theater chain, in 2000. Instead of looking at the aggregate revenues and costs, as Odeon reported them, Cinven's analysts combed through the numbers of every individual cinema in order to understand the P&L dynamics at each location. They were able to paint a rich picture of local demand patterns and competitor activities, including data on attendance, revenues, operating costs, and capital expenditures that would be required over the next five years. This microexamination of the company revealed that the initial market valuation was flawed; estimates of sales growth at the national level were not justified by local trends. Armed with the findings, Cinven negotiated to pay £45 million less than the original asking price.

Getting ground-level numbers usually requires the close cooperation of the acquisition target's top brass. An adversarial posture almost always backfires. Cinven, for example, took pains to explain to Odeon's executives that a deep understanding of Odeon's business would help ensure the ultimate success of the merger. Cinven and Odeon executives worked as a team to examine the results of each cinema and to test the assumptions of Odeon's business model. They held four daylong meetings in which they went through each of the sites and agreed on the most important levers for revenue and profit growth in the local markets. Although the process may strike the target company as excessively intrusive, target managers will find there are a number of benefits to going along with it beyond pleasing a potential acquirer. Even if the deal with Cinven had fallen apart, Odeon would have emerged from the deal's due diligence process with a much better understanding of its own economics.

Of course, no matter how friendly the approach, many targets will be prickly. The company may have something to hide. Or the target's managers may just want to retain their independence; people who believe that knowledge is power naturally like to hold on to that knowledge. But innocent or not, a target's hesitancy or outright hostility during due diligence is a sign that a deal's value will be more difficult to realize than originally expected. As Joe Trustey, managing partner of private equity firm Summit Partners, says: "We walk away from a target whose management is uncooperative in due diligence. For us, that's a deal breaker."