Northern Trust Operating Services Senior Business Analysis Consultant Interview Questions and Answers

Q1. SQL joins and cte
Add your answer
Q2. Jira software operation
Ans. 
Jira software is a project management tool used for tracking issues and managing tasks.
• Jira allows users to create and track issues, assign tasks, and prioritize work.

• Users can customize workflows, create dashboards, and generate reports.

• Integration with other tools like Confluence and Bitbucket is possible.

• Example: Creating a new issue, assigning it to a team member, and tracking its progress.
Answered by AI
Add your answer

Q1. How many years exp
Add your answer
Q2. What domain have you worked? Did you work in finance project?
Add your answer

Q1. Normal work did in past
Ans. 
Performed data analysis, requirement gathering, process improvement, and documentation in past roles.
• Conducted data analysis to identify trends and insights

• Gathered requirements from stakeholders to understand business needs

• Improved processes by identifying inefficiencies and proposing solutions

• Documented findings, requirements, and processes for reference
Answered by AI
Add your answer
Q2. And what are my aspirations
Add your answer

Q1. Case Study on increasing attrition rate
Add your answer
Q2. How did you create value for your client
Add your answer

Q1. Trade life cycle investment banking
Add your answer
Q2. Agile methodologies frame work
Add your answer

Technical interview cum hr interview

Q1. Basic Introduction and work experience
Add your answer

Q1. In depth discussion about the job role and requirements
Add your answer
Q2. Why choosing this role and skills you have
Add your answer

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. Requirement analysis
Add your answer
Q2. Agile methodology
Add your answer

Q1. Ba process daily
Add your answer

Q1. Questions overall on work experience
Add your answer
Q2. Technical questions on skills mentioned
Add your answer

Q1. Resume Discussion thorough
Add your answer
Q2. Resume Discussion Thorough
Add your answer