OHL MIS and Reporting

MIS and Reporting

Location: Gurgaon
Experience: 3–5 Years
Work Mode: 100% Work From Office
Shift: Night Shift

Role Summary

We are looking for an MIS and Reporting professional with strong expertise in MS Excel, VBA, data analysis, financial modeling, and reporting. The role will focus on managing collections data, developing reports and dashboards, analyzing trends, and providing actionable insights to improve collections performance and efficiency.

Key Responsibilities

• Monitor and manage collections data from multiple sources.

• Ensure accuracy and completeness of data in collections management systems.

• Develop and maintain databases and reports for B2B collections.

• Generate regular and ad-hoc reports on collection performance, outstanding receivables, and aging accounts.

• Analyze collection trends and identify issues and improvement opportunities.

• Prepare and present reports highlighting key metrics, trends, and actionable insights.

• Evaluate existing collections processes and recommend improvements.

• Implement and monitor new processes and tools to improve collections efficiency.

• Work with IT and Finance teams to integrate and automate collections systems.

• Support the development of collection strategies and policies.

• Ensure compliance with company policies and applicable regulations.

• Maintain accurate records and documentation for audits and regulatory reviews.

Required Skills

• Advanced MS Excel

• VBA / Macros

• MIS Reporting

• Data Analysis

• Financial Modeling

• DBMS

• Dashboard & Reporting

• Collections Analytics

• Data Management

• Process Improvement

• Advanced Excel

• Analytical Skills

Preferred Knowledge

• OTC (Order-to-Cash) Lifecycle

• B2B Collections

• Collections / Accounts Receivable processes

Candidate Profile

• Strong analytical and problem-solving skills.

• Ability to interpret complex data and identify trends.

• Strong attention to detail and data accuracy.

• Good communication and presentation skills.

• Ability to work with Finance and IT teams on reporting and automation.

Important Information

• 100% Work From Office (WFO).

• Night shifts are applicable by default.

• Ex-TCS employees are not eligible to apply.

• PAN and Date of Birth (DOB) are required for profile creation.