American Express Senior Business Analyst Interview Questions and Answers

Q1. Design an order management system
Ans. 
An order management system to streamline the process of receiving, tracking, and fulfilling customer orders.
• Define user roles and permissions for accessing and managing orders

• Create a user-friendly interface for entering and tracking orders

• Integrate with inventory management system to ensure accurate stock levels

• Automate order processing and notifications to improve efficiency

• Generate reports on order status, sales tre
Answered by AI
Add your answer
Q2. Data points involved in the order management system
Ans. 
Data points in an order management system include customer information, order details, payment information, shipping details, and order status.
• Customer information (name, address, contact details)

• Order details (products, quantities, prices)

• Payment information (payment method, transaction ID)

• Shipping details (shipping address, tracking number)

• Order status (pending, processing, shipped, delivered)
Answered by AI
Add your answer
Q3. Trade life cycle
Add your answer

Q1. Tell me about something you failed at
Add your answer

Sql python puzzle moderate level

Q1. Overall was good. Sql excel pivots were aske
Add your answer

Q1. Date function are asked frequently
Add your answer
Q2. Rank function as well
Ans. 
The rank function is used to assign a rank to each row within a partition of a result set.
• Rank function is used in SQL to assign a rank to each row within a partition of a result set

• It is commonly used in scenarios where you want to rank data based on certain criteria

• For example, you can use the rank function to rank sales data by region
Answered by AI
Add your answer

Q1. Tell me something about yourself
Add your answer

Q1. First round was related to domain.
Add your answer

Q1. Second round was mostly related to the Business Analysis experience.
Add your answer

Q1. Professional Introduction
Add your answer
Q2. Detail explanation about current assignent.
Ans. 
My current assignment involves analyzing business processes and identifying areas for improvement.
• Conducting interviews with stakeholders to understand current processes

• Analyzing data to identify bottlenecks and inefficiencies

• Developing recommendations for process improvements

• Collaborating with cross-functional teams to implement changes

• Monitoring and measuring the impact of process improvements
Answered by AI
Add your answer
Q3. Compentency questions
Add your answer
Q4. Difference between Defect and Bug
Ans. 
Defect is a deviation from requirements while Bug is a coding error.
• Defect is a problem in the software that does not meet the requirements or specifications.

• Bug is a coding error that causes an unexpected result or behavior in the software.

• Defects are caused by incomplete or incorrect requirements, design flaws, or miscommunication.

• Bugs are caused by mistakes in the code, such as syntax errors or logical errors.

• Defect...read more
Answered by AI
Add your answer

Q1. Detailed explanation about current assignment.
Add your answer
Q2. Competency questions.
Add your answer
Q3. Software Development Life Cycle
Ans. 
Software Development Life Cycle (SDLC) is a process followed by software development teams to design, develop, and test high-quality software.
• SDLC consists of several phases including planning, analysis, design, development, testing, deployment, and maintenance.

• Each phase has its own set of activities and deliverables that must be completed before moving on to the next phase.

• SDLC models include Waterfall, Agile, and De...read more
Answered by AI
Add your answer
Q4. Questions around Jira
Add your answer

Q1. Basic accounting Education Experience Reliving date CTC
Add your answer
Q2. Exit reason enquiry , Why choosen standard chartered
Add your answer

Q1. Investment related and journal entries...
Add your answer
Q2. Ex employment experience
Add your answer
Q3. Reason for exit in pervious employment
Add your answer