Cutshort logo
For Employers
PNBIL logo
Analyst
PNBIL

Analyst at PNBIL · Delhi, Gurugram, Noida, Ghaziabad, Faridabad · 0.6 - 3 years · ₹3L - ₹4L / yr · Posted 7 Dec 2021

Randstad India's logo

Analyst

at PNBIL

Agency job
0.6 - 3 yrs
₹3L - ₹4L / yr
Delhi, Gurugram, Noida, Ghaziabad, Faridabad
Skills
Financial analysis
Financial Analyst
credit analysis
credit support
mis analysis

JOB Description

A London based foreign bank has a requirement of shifting its credit MIS to back office and thus has an immediate opportunity for a contract role for the MIS function.

Job Responsibilities:

You will be required to prepare MIS based upon existing standard operating procedures (SOP).

Process

Description

ODA file

Update limits, limit expiry dates, calculate availment of limits for multi-currency OD limits, limits against FD etc

Limit Sanction statement

Preparation of list covering all the credit facilities sanctioned during the reporting month

Consolidated data

Preparation of industry-wise, country-wise data of entire credit portfolio of the bank

Credit dashboard

Pictorial representation of the credit portfolio based on various parameters

India based exposure

Reporting of India based exposure to parent bank

Real estate exposure

Add new accounts opened

Real estate exposure

Update exposure by updating the latest position of undisbursed loan amounts as on reporting date

Real estate exposure

Update value of security, cost of project, Gross Development Value etc

Real estate exposure

Add loans under process and loans sanctioned but not disbursed. Remove loans which have been disbursed.

Key risk indicators

Update the KRIs as requirement of Risk Department

Largest and second largest exposure

Select largest and second largest inflow

Restructured accounts

Reporting of accounts which have been restructured

Loan file

Instalment-wise breakup of the term loans in the credit portfolio and identification of addition of irregular accounts

Control of capital adequacy

Analysis of inflow and outflow based on proposals under process and expected repayments

Valuation, Visit, Insurance

Reporting of pending valuations, visits and insurance

IFRS 9

1. Collating information from various sources to populate respective information sheet (3c File data).
2. To assign staging to each loan account as per bank approved document.

BTL regulatory reporting

Reporting for Residential BTL Loans



The candidate should have good knowledge of Microsoft Office Suite (Excel, Word) comprising of H/V Lookup, Data Flow Charts & Graphs, Pivot Table.

Candidate having knowledge of the following will be preferred

  1. Fair understanding of credit functions

  2. IFRS 9 application – ECL, stage 1/2/3

  3. Banking products related to loans and advances TL, OD etc

  4. NPA – days past due, standard, sub standard

  5. LTV- LTC , GDV

  6. Property type – Residential, Commercial, W/H, Industrial

  7. ROI – Libor, fixed, floating

Read more
Users love Cutshort
Read about what our users have to say about finding their next opportunity on Cutshort.
Shubham Vishwakarma's profile image

Shubham Vishwakarma

Full Stack Developer - Averlon
I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.
Companies hiring on Cutshort
companies logos

Similar jobs (2)

Parkers Consulting  Ventures Pvt Ltd
Indore MP
1 - 3 yrs
₹2L - ₹3.5L / yr
MS-Excel
Accounting

Position: MIS Executive

Experience: 1–2 Years

Industry: Finance / Banking / NBFC

Employment Type: Full-Time

Job Summary

We are looking for a detail-oriented MIS Executive to manage reporting, data analysis, and business information. The ideal candidate should have a Commerce/Finance background with strong Excel and coordination skills.

Key Responsibilities

·        Prepare and maintain daily, weekly, and monthly MIS reports.

·        Collect, analyze, and validate business data.

·        Maintain Excel-based reports and dashboards.

·        Perform data reconciliation and identify discrepancies.

·        Coordinate with internal teams for timely data collection.

·        Provide accurate reports and insights to management.

·        Maintain proper records and documentation.

Requirements

·        Graduate, preferably B.Com / Finance / Commerce.

·        1–2 years of relevant experience in Finance, Banking, or NBFC.

·        Good knowledge of MS Excel and basic accounting.

·        Understanding of banking/financial products.

·        Strong communication, coordination, and analytical skills.

·        High attention to detail and ability to meet deadlines.

To Apply

HR Swati

Read more
Gurugram
3 - 8 yrs
₹1L - ₹4L / yr
Management Information System (MIS)
Account reconciliation
Advanced Excel
VLOOKUP
HLOOKUP
+6 more

Position : Executive / Sr. Executive / Assistant Manager – MIS & Reconciliation

Industry : Fintech

Job Location : Gurgaon

Experience :

  • Executive / Sr. Executive : 3–6 Years
  • Assistant Manager : 5–8 Years


Role Overview :

We are looking for a detail-oriented and analytical MIS & Reconciliation professional to manage management reporting, account reconciliations, data validation, and periodic MIS activities.

The role will be responsible for preparing accurate and timely MIS reports, identifying and resolving reconciliation discrepancies, maintaining data integrity, and coordinating with cross-functional teams. The position will also contribute to process improvement and reporting automation initiatives.


Mandatory Skills :

MIS Reporting, Account Reconciliation, Advanced Excel (VLOOKUP, HLOOKUP, XLOOKUP, Pivot Tables, COUNTIF/COUNTIFS, SUMIF/SUMIFS), Data Analysis, Data Validation, Financial Reporting, and Discrepancy Resolution.


Key Responsibilities :

  • Collect, consolidate, validate, and analyze data from multiple sources for MIS reporting.
  • Prepare and circulate daily, weekly, monthly, and periodic MIS reports for management review.
  • Perform account, transaction, and ledger reconciliations and investigate discrepancies.
  • Identify data mismatches, exceptions, and reconciliation breaks and ensure timely resolution.
  • Maintain high standards of data accuracy, completeness, and integrity across reporting activities.
  • Coordinate with Finance, Operations, Business, and other internal teams to collect and validate required information.
  • Maintain and update MIS dashboards, trackers, and reporting formats as required.
  • Support audit requirements by preparing relevant reports, reconciliations, schedules, and supporting documentation.
  • Ensure adherence to defined reporting processes, controls, and timelines.
  • Identify opportunities to improve reporting processes and reduce manual efforts through automation and standardization.
  • Assist in developing and maintaining automated MIS reports using advanced Excel and other relevant tools.
  • Track key operational and financial metrics and highlight significant variances or exceptions to management.
  • Maintain proper documentation of reports, reconciliation workings, processes, and controls.


Key Performance Indicators / Success Criteria :

  • Accuracy and timely submission of MIS reports.
  • Timely completion and accuracy of account/transaction reconciliations.
  • Effective identification and resolution of discrepancies and exceptions.
  • Data integrity and adherence to reporting standards.
  • Quality of coordination with cross-functional stakeholders.
  • Reduction in manual reporting efforts through process improvement and automation.
  • Timely support for audits and management reporting requirements.


Mandatory Skills :

Advanced Excel

Strong hands-on experience with Microsoft Excel, including :

  • VLOOKUP / HLOOKUP
  • XLOOKUP
  • COUNTIF / COUNTIFS
  • SUMIF / SUMIFS
  • Pivot Tables
  • Conditional Formatting
  • Data Validation
  • IF / Nested IF
  • INDEX-MATCH
  • Data cleaning and consolidation
  • Large-data-set handling and analysis

MIS & Reconciliation

  • Strong experience in MIS preparation and management reporting.
  • Hands-on experience in account / transaction / ledger reconciliation.
  • Ability to identify, analyze, and resolve data discrepancies.
  • Good understanding of data validation and reporting controls.


Preferred / Additional Skills :

  • Basic knowledge of Macros / VBA.
  • Experience with Tally ERP 9 or similar accounting/ERP tools.
  • Basic understanding of accounting principles and financial transactions.
  • Exposure to reporting automation and process improvement.
  • Experience working with large volumes of financial or transactional data.
  • Good analytical and problem-solving skills.
  • Strong communication and stakeholder coordination skills.


Educational Qualification :

Minimum Qualification :

  • Bachelor's degree in B.A. / B.Com or equivalent.

Preferred Qualification :

  • B.Com
  • B.A.
  • MBA – Finance / Accounting


Ideal Candidate Profile :

The ideal candidate should have strong hands-on experience in MIS reporting, reconciliation, Excel-based data analysis, and management reporting, preferably within the Fintech, BFSI, financial services, payments, or transaction-driven environment.

The candidate should be highly detail-oriented, comfortable working with large datasets, capable of independently identifying discrepancies, and proactive in improving reporting and reconciliation processes.

Read more
Why apply to jobs via Cutshort
people_solving_puzzle
Personalized job matches
Stop wasting time. Get matched with jobs that meet your skills, aspirations and preferences.
people_verifying_people
Verified hiring teams
See actual hiring teams, find common social connections or connect with them directly.
ai_chip
Move faster with AI
We use AI to get you faster responses, recommendations and unmatched user experience.
Did not find a job you were looking for?
icon
Search for relevant jobs from 10000+ companies such as Google, Amazon & Uber actively hiring on Cutshort.
companies logo
companies logo
companies logo
companies logo
companies logo
Get to hear about interesting companies hiring right now
Company logo
Company logo
Company logo
Company logo
Company logo
Linkedin iconFollow Cutshort
Users love Cutshort
Read about what our users have to say about finding their next opportunity on Cutshort.
Shubham Vishwakarma's profile image

Shubham Vishwakarma

Full Stack Developer - Averlon
I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.
Companies hiring on Cutshort
companies logos