Manager – Collections Reporting

11 hours ago

Gurgaon, Haryana, India LanceTech Solutions Pvt Ltd Full time ₹ 18,00,000 - ₹ 22,00,000 per year

Title: BI Manager- Collection Systems & Reporting (SQL/Crystal)

Location: Work from Home/Gurugram

Mandatory skills: 4+ yrs of strong experience in SQL, Crystal Reports, KPIs

Shift: Night Shift

Role Purpose

Build, maintain, and optimize reporting, KPIs, datasets, and data pipelines supporting Collections operations across Artiva RM, Ontario Reports, AS/400, and SQL-based environments.

Key Responsibilities

  • Develop and automate weekly/monthly/adhoc Collections reports (roll rates, liquidation, RPC, queue penetration, collector performance, skip-trace KPIs).
  • Build SQL datasets and reporting logic using Intersystem Caché, SQL Server, and DB2 (AS/400).
  • Develop and maintain Crystal Reports and Ontario Reports output templates.
  • Support Artiva RM reporting: data extraction, namespace analysis, Dev/Test/Prod release support.
  • Query AS/400 DB2 and integrate outputs into downstream reporting.
  • Handle skip-trace reporting and operational analytics.
  • Perform UAT for reporting/system changes and support account recovery system enhancements.
  • Manage scheduled SFTP/FTP/PGP file transfers (GoAnywhere or similar).

Technical Skill Requirements

  • SQL (Caché / SQL Server / DB2)
  • Crystal Reports (mandatory)
  • Ontario Reports (preferred)
  • AS/400 DB2 & CL commands (preferred)
  • ETL/SSIS or equivalent data extraction experience
  • Experience with Artiva RM or any Collections management system
  • Strong understanding of Collections KPIs (roll rates, liquidation, RPC, PTP, queue penetration)
  • Tools: GoAnywhere, SFTP/FTP/PGP, Excel, Access

Qualifications

  • Bachelor's degree in Computer Science or related field
  • 4–10+ years in SQL-based operational reporting
  • Experience in Collections domain preferred (Artiva/Ontario/AS400)

Interested individuals can apply here, or share the profile to

Job Type: Full-time

Pay: ₹1,800, ₹2,200,000.00 per year

Benefits:

  • Work from home

Work Location: In person

  • Manager - Collections

    1 week ago

    Gurgaon, Haryana, India Freight Tiger Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    About The RoleBeing a Collections & Credit Control Lead, you will be responsible for leading and managing the credit control and collections functions of key businesses of the company. Your primary objective will be to optimize cash flow, manage working capital, deploy collection strategies, while leading a pan India team and maintaining positive...

  • Manager COllections

    1 week ago

    Gurgaon, Haryana, India Genpact Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Ready to shape the future of work? At Genpact, we don't just adapt to change—we drive it. AI and digital innovation are redefining industries, and we're leading the charge. Genpact's AI Gigafactory, our industry-first accelerator, is an example of how we're scaling advanced technology solutions to help global enterprises work smarter, grow faster, and...

  • Collections manager B2B

    4 days ago

    Gurgaon, Haryana, India Azuro by Square Yards Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Company DescriptionAzuro by Square Yards offers seamless, tech-driven property management solutions for landlords and tenants. From tenant sourcing and rent collection to maintenance and legal support, Azuro handles all aspects of rental management. Our mission is to deliver a transparent, hassle-free experience that maximizes rental income for property...

  • National Collections Manager

    2 days ago

    Gurgaon, Haryana, India gHRig People Solutions Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    The National Collections Manager is responsible for the care, preservation, and management of a national collection of artifacts, artworks, or historical items. This role involves developing and implementing collection management policies, overseeing storage and handling procedures, and ensuring the long-term preservation of the collection. The National...

  • Collection Manager

    6 days ago

    Gurgaon, Haryana, India Airtel Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    GB.HO>Customer Experience.Collections>Collection Manager>Airtel Centre - GurgaonKey Deliverables • Ensure operational execution of Collection & Retention strategy to reduce churn and Bad debt • Ensure timely dispatch and acceptance of bills to customers and collection efficiency -90% within 0-60 bucket / 99% collection within 0-90 days •...

  • Collection Manager

    6 days ago

    Gurgaon, Haryana, India Airtel Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Airtel Business.NCR>Customer Experience.Collections>Collection Manager>Airtel Centre - GurgaonKey Deliverables • Ensure operational execution of Collection & Retention strategy to reduce churn and Bad debt • Effective Management of ARC's to ensure superior customer experience for pre& post customer • Drive Complaint reduction and increase FTR at...

  • senior manager collections

    1 week ago

    Gurgaon, Haryana, India Genpact Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Ready to shape the future of work? At Genpact, we don't just adapt to change—we drive it. AI and digital innovation are redefining industries, and we're leading the charge. Genpact's AI Gigafactory, our industry-first accelerator, is an example of how we're scaling advanced technology solutions to help global enterprises work smarter, grow faster, and...

  • AVP Collection

    4 days ago

    Gurgaon, Haryana, India Startek (Aegis Customer Support Services Pvt. Ltd.) Full time ₹ 1,20,000 - ₹ 1,80,000 per year

    Strategic & Operational LeadershipDevelop and execute collection strategies for early, mid, and late-stage delinquent accounts.Monitor portfolio performance and recommend corrective action plans to reduce NPA levels.Implement risk-based collection approaches tailored to customer segments.Team ManagementLead, motivate, and develop collection managers,...

  • Collection Manager

    2 weeks ago

    Gurgaon, Haryana, India White Force Group Full time ₹ 4,50,000 - ₹ 9,00,000 per year

    Urgent Hiring Designation - collection ManagerLocation - GurgaonSalary Budget - Upto 10 LPA Also Depends on your interview and previous salary package

  • Management Trainee Collections

    1 week ago

    Gurgaon, Haryana, India Genpact Full time ₹ 2,50,000 - ₹ 7,50,000 per year

    Ready to shape the future of work?At Genpact, we don't just adapt to change—we drive it. AI and digital innovation are redefining industries, and we're leading the charge. Genpact's AI Gigafactory, our industry-first accelerator, is an example of how we're scaling advanced technology solutions to help global enterprises work smarter, grow faster, and...