Scribd Logo
Upload

Welcome to Scribd!

  • 14 views

    Financial Fraud Detection System[1][1]

    Uploaded by

    aribashafaqatali

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Financial Fraud Detection System[1][1]

    Uploaded by

    aribashafaqatali
    14 views16 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    14 views16 pages

    Financial Fraud Detection System[1][1]

    Uploaded by

    aribashafaqatali

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 16

    Financial Fraud Detection System

    Session: 2022 – 2026

    Submitted by:
    Saba Shahdin 2022-CS-112
    Ariba Shafaqat 2022-CS-113
    Wajeeha Javed 2022-CS-136
    Momina Rashad 2022-CS-137
    Ghania Khan Niazi 2022-CS-156

    Submitted to
    Sir Khaldoon

    Department of Computer Science


    University of Engineering and Technology
    Lahore Pakistan
    Description:
    The Financial Fraud Detection System is a comprehensive solution designed
    to identify, analyze, and mitigate fraudulent activities within financial transactions. This
    project integrates data analysis, visualization, and reporting tools to provide stakeholders with
    actionable insights for fraud prevention and detection. Leveraging a combination of database
    management, ETL processes, data analysis algorithms, and user interface development, the
    system aims to enhance the security and integrity of financial operations.

    Objectives:
    The objectives of the Financial Fraud Detection System are:
     Develop a robust database schema to store relevant financial data, including
    transaction records, budget allocations, audit logs, and fraud alerts.
     Implement Extract, Transform, and Load (ETL) processes to extract data from
    multiple sources, transform it into a suitable format for analysis, and load it into the
    database.
     Utilize data analysis techniques to identify patterns, anomalies, and potential instances
    of fraud within financial transactions.
     Creating interactive dashboards and reports using Power BI to visualize and explore
    the analyzed data, providing stakeholders with actionable insights.
     Developing a user-friendly C# application to serve as a frontend interface for
    interacting with the system, including data input, report generation, and fraud alert
    management.
     Integrate all components of the system to ensure seamless data flow, analysis, and
    visualization, facilitating effective fraud detection and prevention.

    Components:
     Database Schema: The database schema encompasses tables for storing information
    related to departments, personnel, partners, transactions, payments, audits, fraud
    alerts, and audit logs.
     ETL Processes: ETL processes are implemented to extract data from various sources,
    transform it into a suitable format, and load it into the database, ensuring data
    integrity and consistency.
     Data Analysis: Data analysis techniques, including statistical analysis, machine
    learning algorithms, and anomaly detection, are employed to identify fraudulent
    patterns and behaviors within financial transactions.
     Power BI Reports: Interactive dashboards and reports are created using Power BI to
    visualize and explore the analyzed data, enabling stakeholders to gain insights into
    financial trends, anomalies, and potential fraud indicators.
     C# Application: A user-friendly C# application is developed to provide stakeholders
    with an intuitive interface for interacting with the system, including data input, report
    generation, and fraud alert management.
     Integration: All components of the system are integrated to facilitate seamless data
    flow, analysis, and visualization, ensuring that stakeholders can effectively leverage
    the system for fraud detection and prevention.

    Techniques used for Fraud Detection:


    Rule based and anomaly detection techniques using SQL queries are used to detect fraudulent
    activities.

    Data Dictionary:
    Wireframes:
     Home Page

    Figure 1: Home Page

     Sign In

    Figure 2: Sign In
     Auditor

    Figure 3: Auditor

     Audit

    Figure 4: Perform Audit

     Credit Card
    Figure 5: Credit Card

     Cheque

    Figure 6: Cheque

     Invoice and Transaction Pattern


    Figure 7: Invoice and Transaction Pattern

     Fraud Alerts

    Figure 8: Fraud Alerts


     Audit Result
    Figure 9: Audit Result

    Power BI Dashboard:

    Figure 9: Power BI Dashboard

    SSMS:
    ER Diagram:

    Figure 10: ER Diagram

    You might also like