MIS Executive

Role: MIS Executive – Collection Process

Job Purpose

The MIS Executive will be responsible for managing, analyzing, and presenting data related to collections. The role involves preparing daily/weekly/monthly reports, monitoring collection performance, identifying gaps, and supporting the operations team with actionable insights to improve recovery efficiency.

Key Responsibilities

• Collect, consolidate, and validate daily collection data from different sources (CRM, billing system, Excel, etc.).

• Prepare and publish MIS reports (daily, weekly, monthly) on collection performance.

• Track bucket-wise, product-wise, and region-wise collection status.

• Monitor overdue accounts, payment patterns, and portfolio aging.

• Generate dashboards and presentations for management review.

• Ensure accuracy and timeliness of reports shared with Operations, Finance, and Management teams.

• Automate recurring reports using Excel formulas, Pivot Tables, Macros, Power Query, or SQL (as applicable).

• Coordinate with collection teams to understand data requirements and provide analytical support.

• Highlight gaps, variances, and trends in collection performance.

• Support audits and compliance requirements by providing required data and reports.

Skills & Competencies

• Strong expertise in MS Excel (VLOOKUP, HLOOKUP, Pivot Tables, Conditional Formatting, IF/IFS, Index-Match, Charts, etc.).

• Knowledge of Power BI / Tableau (added advantage).

• Ability to work on SQL / Access / Google Sheets for data extraction and analysis.

• Analytical mindset with attention to detail.

• Good communication skills for interacting with operations and management.

• Ability to work under pressure and meet reporting deadlines.

Education & Experience

• Graduate (B.Com / BBA / B.Sc / Any Graduate with good MIS skills).

• 1–3 years of experience in MIS/Reporting, preferably in Collections / BFSI / BPO domain.

• Fresher with strong Excel knowledge may also be considered.

• It is a Full Time Back Office / Data Entry job for candidates with 1 - 2 years of experience.

More about this MIS Executive job

1. What is the eligibility criteria to apply for this MIS Executive job?
   Ans: The candidate should be Graduate and above and above with 1 - 2 years of experience of experience
2. How much salary can I expect for this job role?
   Ans: You can expect a salary of ₹20000 - ₹25000 per month that depends on your interview. It's a Full Time job in Bangalore.
3. How many working days are there for this MIS Executive job?
   Ans: This MIS Executive job will have 6 working days.
4. Are there any charges applicable while applying or joining this MIS Executive job?
   Ans: No, there is no fee applicable for applying this MIS Executive job and during the employment with the company, i.e., ALLSIGNS.
5. Is it a work from home job?
   Ans: No, it’s not a work from home job and can't be done online.
6. How many openings are there for this MIS Executive role?
   Ans: There is an immediate opening of 1 MIS Executive at ALLSIGNS
7. Who can apply for this job?
   Ans: Both Male and Female candidates can apply for this Back Office / Data Entry job.
8. What are the timings of this MIS Executive job?
   Ans: This MIS Executive job has 09:00 सुबह - 06:00 शाम timing.