World's leading management consulting firms, where bold thinking, inspired people and a passion for results come together for extraordinary impact.


National Bank of Pakistan


A Query MIS Solution is required to be developed and deployed for Financial Institution Division (FID) at the National Bank of Pakistan. The solution will be a web-based application.

The scope of the project is to automate the MIS from the point of inputting the query till the final step when the query is resolved. This MIS solution serves as a tracker through which they can track the entire journey of the queries received at FID. The process flow is defined below along with the approval cycle. Process Flow for Query MIS: In the case of Query MIS, the query received by the FID user is via email. We will have 2 options in the system through which we will convert this email into a system query. Option 1, FID user will save the email as a file and upload it to the system to create a query. In this option, the system will parse data and create queries for the user. The user will submit the created query for approval submission. Option 2, we will fetch the email from the mail server and parse it automatically to create a query in the system. The user will have to submit the created query for approval submission. Users will be able to forward this query to other persons using this portal and the system will be managing the thread against the same query. Response to the original query will also be sent through the portal. The workflow of the query is defined below:

List of features covered under this agreement include:

  • The query is raised by the system through upload/auto email parser
  • Once submitted, this query will be listed in the separate node with Pending status
  • The user will forward the query to other concerned persons and it will be sent in form of an email
  • User will be able to respond to the original query through the portal
  • FID user to update status and remarks against the listed query
  • Upon resolution, the FID user will mark the query as completed
  • User will have an option to add remarks at any time before completion

Leave comments