You are currently browsing the Chetan Shah’s Blog weblog archives for August, 2008.
- AML (14)
- Foundation (4)
- Personal Finance (21)
- Technology (22)
- 7 Dec 2009: Move securities to Roth Account
- 28 Nov 2009: Leverage Checksum to determine identical files
- 4 Oct 2009: CAMS Certification Preparation
- 30 Aug 2009: Section 311 etc. (ACAMS Notes)
- 24 Aug 2009: FATF Membership Points (ACAMS Notes)
- 22 Aug 2009: Internet Casinos and Prepaid Cards/E-Cash (ACAMS Notes)
- 5 Aug 2009: Spousal IRA
- 15 May 2009: Buying Call Options.
- 7 Jan 2009: Watchlist filtering white paper
- 31 Oct 2008: Autonumber in Microsof Excel (works after inserting rows)
Archive for August 2008
OFAC/SDN Watchlist Software Application Axiom #5
25 Aug 2008 by Chetan Shah.
Watchlist Scanning applications which have the capability of reporting “alerts” should consolidate alerts arising from the same “Entity” from different watch list as 1 alert rather that reporting the same entity multiple times.
This will eliminate duplicate work as multiple analysts can work on the same entity if she is reported more than once due to the fact that she is on different watchlists.
Posted in AML | No Comments »
Database Metadata Information Leverage
11 Aug 2008 by Chetan Shah.
Cannot stress the importance of an upto date database metadata information for an application or a suite of applications which exchange data amongst each other.
Metadata information can be leveraged in following ways :
- Impact Analysis
Application sourcing data from upstream application and/or sourcing data to downstream application can hugely benefit by having a metadata repository. It will enable the application owners to easily identify the producers and consumers and hence enable them to perform impact analysis.
- Data Reuse
As a byproduct of meta data harvesting exercise, the application owners will easily be able to identify redundant data (data which is sourced more than 1 once for a suite of applications)
- Documentation
Rather than dedicating time to create database documentation, any metadata tool will enable you to export html and publish it on your intranet possibly on sharepoint or wiki site which are easily searchable.
- Consolidation of Load Process
In an organization having a suite of applications, more often than not there are disparate data load batch processes executing to fetch data (from data warehouse let’s say). Metadata harvesting exercise will enable the application owner to identify and potentially consolidate the batch process on a single platform (etl tools like informatica)
Posted in Technology | No Comments »
