Manish Singh

Project: DCR – Digital, Channel & Retail Management System

Domain: Sales & Distribution

Role: Manual Tester / Support Analyst

Project Description:

DCR (Digital, Channel & Retail) is a centralized system developed for managing and tracking primary, secondary, and tertiary sales of mobile devices and accessories. It covers the entire sales flow — from distributor onboarding to shop creation, IMEI sales tracking, scheme management, and retailer-wise performance monitoring.

The platform supports multiple roles including DBR (Distributor), Sub-Dealer, Retailer, Promoter, BM, ASM, and RSM, with a focus on data transparency, live reporting, and hierarchy-based access.

Key Modules Tested:

• Shop Creation & Mapping – Adding retailers and mapping them with DSE, ASM, BM.
• Scheme Management – Uploading scheme files (primary, secondary, RSA attendance) and validating rebate calculations.
• IMEI Sales Tracking – Validating the flow of IMEI from primary to secondary and tertiary sale levels.
• Return Management – Testing return flow logic and verification against IMEI Return Query.
• Report Validation – Cross-checking live vs D-1 sales data, user vs system mapping, and SmartView comparison.
• FOL Rebate Module – Uploading FOL rebate files and pushing amounts post finance verification.

Responsibilities:

• Designed and executed test cases for DCR modules (scheme upload, user mapping, shop creation).
• Validated IMEI lifecycle (activation, sale, return) against sales reports.
• Raised and tracked defects using JIRA, worked closely with dev team for resolution.
• Supported finance and sales teams by providing issue analysis and data correction.
• Participated in UAT and supported live rollouts for new DCR features and reports.

Impact:

• Ensured accurate and timely sales tracking across 3 brands (Itel, Tecno, Infinix).
• Helped reduce scheme upload errors and IMEI mismatches through proactive validations.
• Improved cross-team communication between business and IT teams for DCR process flows.

1. Insurance Claim Management System

Domain: Insurance

Project Description:

A web-based platform that allows customers to file, track, and manage insurance claims, and lets internal agents review, approve, or reject claims.

Responsibilities:

• Reviewed business requirements and created test scenarios.
• Designed and executed test cases for modules like claim filing, document upload, claim history, and approvals.
• Performed functional, regression, and system integration testing.
• Logged defects using JIRA and coordinated with developers.
• Tested workflows for different user roles (Customer, Agent, Manager).

2. Healthcare Data Analytics Portal

Domain: Healthcare / Analytics

Project Description:

A reporting dashboard used to analyze patient records, claim approvals, and hospital performance metrics using real-time data from different data warehouses.

Responsibilities:

• Validated data accuracy between front-end UI and backend (SQL queries).
• Wrote test cases for report filters, graphs, and role-based access.
• Performed UI, data integrity, and cross-browser testing.
• Worked closely with the BI team to verify report visualizations.

3. Billing and Invoicing System

Domain: Finance / Operations

Project Description:

A system used by EXL clients to generate invoices, apply discounts, and track payment status for B2B transactions.

Responsibilities:

• Created and executed test cases for billing generation, invoice download, and tax calculations.
• Validated email notifications and report exports (Excel, PDF).
• Ensured system handled large volumes of invoice data without performance issues.