DEDUPE-IO

Project Overview

DEDUPE-IO is an enterprise-level rules-based application engineered to evaluate customer eligibility for new services, significantly reducing fraud and credit risk through automated high-risk profiling and real-time validation systems.

🔐 Secure Authentication

Role-based user authentication system with encrypted password storage and session management.

🎯 High-Risk Profiling

Rules-based engine to evaluate customer eligibility and reduce fraud through weighted risk assessment.

⚡ Real-Time Validation

Integrated validation with billing systems using comprehensive weighted checklists.

📊 Automated Scorecards

Generates definitive eligibility scorecards (Green/Red signals) based on multiple risk factors.

📈 CAF Tracking

Automated Customer Application Form detail tracking for team performance MIS and reporting.

🔍 Advanced Deduplication

Multi-criteria search engine with bulk processing for efficient data management.

Installation Guide

System Requirements

✅ Microsoft Access 2016 or later
✅ Windows 10/11 Operating System
✅ 2GB RAM minimum (4GB recommended)
✅ 500MB free disk space on D: drive
✅ Microsoft Excel for export features
✅ D: drive must be available for application operation

Step 1: Extract to D: Drive (Mandatory)

Important: Download and extract DEDUPE_IO.zip directly to D:\ - this will automatically create the complete folder structure at D:\DEDUPE_IO\ with all supporting files.

Step 2: Launch Application

Navigate to D:\DEDUPE_IO\ and double-click DEDUPE-IO.accde to launch the compiled application.

Step 3: Use Demo Credentials

Default login credentials are displayed on the login screen:

👨‍💼 Admin Access: Credentials shown on login form
👥 Demo Users: Multiple test accounts available
🔓 No approval required for new account creation
🚀 Ready-to-use with sample data

Step 4: Explore Enterprise Features

Begin with the Dashboard to access all modules including Risk Profiling, Customer Management, Liquidation Tracking, and Reporting systems.

Application Screenshots

Click on any screenshot to view in full size

Login & Authentication

Dashboard Overview

TTSL Database Deduplication

Risk Assessment Calculator

CAF New Entry Form

UTM Blacklisting Database

Liquidation Data Entry

SOID Liquidation Database

TCL Database Deduplication

User Account Creation

Admin User Management

Task Management System

Enterprise Features

🎯 High-Risk Profiling & Eligibility Engine

Rules-Based Evaluation

Engineered application to evaluate existing customer eligibility for new services, reducing fraud and credit risk.

Real-Time Validation

Integrated validation with billing systems using comprehensive weighted checklists and business rules.

Weighted Risk Assessment

6-month payment history, outstanding debt, FMS abuse, safe custody status analysis for accurate profiling.

📊 Automated Reporting & Tracking

Eligibility Scorecards

Generates definitive eligibility scorecards with Green/Red signals based on comprehensive risk analysis.

CAF Detail Tracking

Automated Customer Application Form tracking for team performance MIS and management reporting.

Liquidation Management

Comprehensive liquidation data entry and tracking system for financial management.

🔧 Technical Capabilities

Data Deduplication

Advanced algorithms to identify and manage duplicate customer records across TTSL, TCL, and retail systems.

Blacklisting System

UTM blacklisting database with pattern matching and advanced search capabilities.

User Management

Complete admin user management system with role-based access control.

Technical Architecture

Frontend

MS Access Compiled Database (.accde)
Custom UI Forms & Controls
Event-Driven VBA Programming

Backend

MS Access Database Engine
ADO/DAO Data Connections
SQL Query Optimization

Integration

Excel Automation & Reporting
File System Operations
Email Notification System

Package Structure

Extracting DEDUPE_IO.zip to D:\ will create this complete structure:

D:\DEDUPE_IO\
│
├── 📄 DEDUPE-IO.accde (Compiled Application)
├── 📁 DEDUPE_IO_Files\ (Screenshots & Documentation)
├── 📁 DEDUPE_IO\ (Supporting File Structure)
│   ├── 📁 ICONS\ (Application Icons & Resources)
│   ├── 📁 EXCEL_OUTPUT_RESULT\ (Automated Reports)
│   ├── 📁 EXCEL_INPUT_TEMPLATE\ (Import Templates)
│   └── 📁 MACRO_TEMPLATES\ (Processing Templates)
├── 📄 User_Manual.pdf
├── 📄 Technical_Guide.pdf
└── 📄 README.txt

Note: All file paths and dependencies are pre-configured for immediate use after extraction to D: drive.