Legal MIS Executive

KRA/Responsibilities :

1. Maintaining Payment file on daily basis and sending to concerned departments and agents.

2. Preparing Total Collection V/s Allocation MIS agent and region wise on daily basis.

3. Preparing Overdue MIS agent wise and region wise on daily basis.

4. Preparing Performance MIS agent wise on daily and weekly basis.

5. Preparing Bounce Analysis MIS on weekly basis

6. Preparing Presentation Trend Report on weekly basis

7. Preparing Reconciliation Due vs Presentation Report on weekly basis

8. Managing Arbitration, Execution, Sarfaesi and Sec-34 MIS on google sheet

9. Preparing Legal Reports as per requirement

10. Writing google script as per requirement for different Teams

Requirements:

· Any Graduation

· Should have Knowledge of Legal & VBA (Macro programming)

· Should have Knowledge of important Functions like VLOOKUP, HLOOKUP, INDEX, MATCH, OFFSET etc.

· Should have Knowledge of advance level MS excel.

Note: Test has to complete/pass for interview

Job Types: Full-time, Permanent

Pay: ₹15,000.00 - ₹25,000.00 per month

Benefits:

• Health insurance

Education:

• Bachelor's (Preferred)

Experience:

• MIS: 2 years (Preferred)
• Microsoft Excel: 2 years (Preferred)
• LEGAL BACKEND: 1 year (Preferred)

Work Location: In person