Results 1 to 11 of 11
  1. #1
    Join Date
    Jan 2010
    Posts
    4

    Unanswered: Bank fraud detection scenario

    Hi all,

    I am working as a dba in a small bank and I got an assignment to develop an in-house tool for detecting fraud scenarios. I know the technical part of manipulating multiple data sources and mining data, but do you happen to know what tests/scenarios the banks use to detect fraud across all types of transactions (e.g. deposits, cards, online banking, employee fraud, wire and ACH etc)? Thanks.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Start small.

    How would you detect it WITHOUT a fancy in-house application?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You need to ask your auditing department what tests they want implemented, as a developer you should focus on how to do what the user wants done, not on determining what you think the user wants you to do.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #4
    Join Date
    Aug 2009
    Posts
    262
    This question already reside in ORACLE forum .

    why is it being asked in both database forums of oracle and sqlserver?

  5. #5
    Join Date
    Jan 2010
    Posts
    4
    Thanks for the advice. We have no auditing department. That is way I was doing more than a developer job.

    This assignment was given to me with a tight deadline, I thougt that someone might have already implemented such types of fraud scenarios. Have any of you coded such tests/scenarios?

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Yes, I've done several of them for small banks and S&L organizations, and worked on two major banks fraud detection systems. Unfortunately, just about everyone that has done so is forbidden by contract to discuss the details because banks don't really want people to know just how they detect that kind of problem! ')

    Sorry, I can answer specific questions on how to do things, but I can't discuss the general ideas of what to do.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  7. #7
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Quote Originally Posted by rhodesian View Post
    Thanks for the advice. We have no auditing department. That is way I was doing more than a developer job.

    This assignment was given to me with a tight deadline, I thougt that someone might have already implemented such types of fraud scenarios. Have any of you coded such tests/scenarios?
    Well you could try going to one of the on-line sites for programming fraud detection/prevention software. May be of use for more specific types of programming audit tools.

  8. #8
    Join Date
    Jan 2010
    Posts
    4
    Hi Pat, I am aware of what you are saying. Would you discuss this in private?

    savage_roxy@yahoo.com

  9. #9
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    No, I'm sorry I can't.

    I'd suggest contacting your state board of governors or your FDIC contact. They could provide detailed information that I can't.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  10. #10
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Here is some handy code for detecting bank fraud:
    Code:
    ....where LastName = 'Phelan'
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  11. #11
    Join Date
    Jan 2010
    Posts
    18
    You need to get the business to define the rules.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •