OHL MIS and Reporting in Gurgaon, भारत

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.