Banks, Financial Service Providers, and Insurance Companies

Process, protect, and forecast transaction data

The industry users Banks, Financial Services, and Insurance (BFSI) represent IRI's largest customer segment. IRI supports these companies in the expansion and protection their product portfolio with software that helps them identify trends or detect fraud faster, comply with data protection regulations, reduce software and hardware costs, and improve the quality and performance of their applications.
BFSI Problems
IRI Solution
Very Large Databases (VLDBs), which Discovery (ProfilingArchiving, MigrationReorganizationReplicationSubsetting and Security require.
Big Data Datasets, typically from mainframe SAM files, VLDBs, transaction files, HDFS, and/or weblogs, containing large volumes of financial data: Core banking and credit card processes Customer acquisition, psychographic, and retention initiatives Credit and enterprise risk reporting Claims processing and analytics Fees, loyalty program, and customer relationship management Mobile, web, and other channel analytics Tax settlement and compliance programs Batch and ETL-related operations under SLAs require faster Data Integration and Provisioning different sources for handover to COBOL programs, BI, data and spread marts, databases, and software packages.

Large data warehouses run on over-complex, 6- and 7-figure ETL tools that rely on partitioning, inefficient in-DB (or disjoint Hadoop) transformations, DB appliances, or more.

Mainframe JCL and others Sorting/Merging Utilities for migration to client/server operating systems. COBOL Sort Exit Replacement (to improve native sorting performance in the volume).
MainframeCOBOL File and Data Type Conversion as well as RDB data/DDL for application and platform migrations.
Bank account, credit card, Social Security/taxpayer/national ID numbers, and others personally identifiable information (PII), which a static or dynamic data maskingEncryption or require other security measures to comply with PCI standards or government data privacy regulations.
Applications, billing templates, database and ETL prototypes, outsourced development, and offsite benchmarking require accurate Test data, which do not require access to production tables or flat files (confidential, insufficient, or non-existent).
IRI FACT (Fast Extract) exports transaction tables to flat files. It runs with or without CoSort SortCL and bulk database load utility operations. The tools combine classic (offline) reorgs and data warehouse ETL jobs. See also IRI NextForm or CoSort, that replicate, map, and report on flat file or ODBC sources. IRI Voracity includes all of the above points, as well as data collection, sub-ordination, cleansing, masking, and master data management (MDM).

Single-Pass Data Transformations in the SortCL Program IRI CoSort and IRI Voracity, which include the following:

  •    filter and select
  •    Sort and merge
  •    join
  •    aggregate
  •    rank and segment
  •    search
  •    calculate interest
  •    pivot
  •    convert and remap

that can be run in custom billing, trend, and other reports:

  •    Batch Jobs
  •    Delta (Change Data Capture) or Slowly Changing Dimension (CDC, SCD)
  •    Descriptive analytics, i.e., detailed and summary reports with or without BIRT or KNIME visualizations.
  •    Web and XBRL formatted targets

The affordable IRI Voracity Subscription software uses proven, seamlessly integrated CoSort and Hadoop Engines for efficient transformations, in conjunction with Fast Extract and Pre-CoSorted loads. Erwin (formerly AnalytiXDS) CATfx technology automatically transforms legacy ETL jobs into more ergonomic Voracity workflows.

CoSort Can z/OS sorts be proxied seamlessly or freed on z/Linux or LUW servers Parm Conversion Tools replace, sort, merge, and select the files. The CoSort program SortCL can also replace many FILE-AID and ICETOOL functions. The CoSort libraries „acucosort“ and „mfcosort“ replace Runtime Sorts in ACUCOBOL-GT, Micro Focus Workbench, NetExpress, Server Express, and Enterprise Server.
The program CoSort SortCL can create custom reports with built-in transformations, masks, and even statistical analyses (e.g., cross-tabs, Standard deviation, Regression) can be created. Integration with BIRT and KNIME in Eclipse is particularly useful for Voracity ETL users who their results data mashups in a single operation visualize or evaluate.

The IRI Voracity platform or the included data migration product NextForm MF-ISAM and Vision can migrate to CSV and other text files, convert fields from EBCDIC to ASCII, to packed numeric, big- to little-endian, multibyte CJK to Unicode and vice-versa. They can also re-map fields and reformat record layouts, as well as migrate and replicate DB2 and other legacy DB and file formats (and DDL).

The IRI FieldShield Data masking products can find, classify, and protect PII and other sensitive data in databases and flat files using encryption, redaction, hashing, pseudonymization, randomization, and other features, while also assessing re-ID risk and creating job audit trails. IRI CellShield can find and mask data in Excel spreadsheets and IRI DarkShield can do the same for unstructured text and image files, NoSQL databases, and PDF/MS Office documents. The Data management platform IRI Voracity supports all three products.

CoSort SortCL and IRI RowGen create secure, intelligent, and referentially correct test data by generating random data types and/or randomly selecting real data from real-set files (lookup tables). RowGen includes built-in SortCL functions for manipulating and pre-sorting test data to accelerate load times.

Below are some IRI customers in:

ABN AMRO
AmBank
Colpatria Bank
Banco Credicoop
Bank of the Republic of Haiti
Development Bank
State Bank
Bank of Mexico
Bank of Welfare
General Bank
Ripley Bank
Banco Safra
Banco Santander
Bank of Abyssinia
Bank of America
Bank of Egypt
Bank of Montreal
Post Office Bank
Bank of External Trade of Algeria
Vernes Bank
Capitec Bank
C6 Bank
Cathay United Bank
China Savings Bank
Citigroup
Citizens Bank
Commercial Bank of Ethiopia
Credibanco
First National Bank
Friesland Bank
Frost Bank
Green Dot Bank
Hana Bank
Industrial Bank of Korea
Italian Popular Banks
ING Bank
Kiwi Bank
Korea Development Bank
Korea Exchange Bank
La Caixa
MyBank
N. American Savings Bank
National Australia Bank
Nedbank South Africa
Nonghyup Bank
OTP Bank
RBS
Shinhan Bank
South African Reserve Bank
Tesco Bank
TransBank
Wells Fargo
Wesbank
Woori Bank

American Stock Exchange
Charles Schwab
Daishin Securities
Dooson Capital
Fidelity Investments
Goldman Sachs
Korea Investment & Securities
Korea Stock Exchange
Koscom
Kyobo Securities
Mirae Asset
Tel Aviv Stock Exchange

ADP
Arab Financial Services
Brinks Global Services
Cagemini Services
Technology Conductor
Credit Suisse
CSC
Epsilon
Ernst & Young
Finsiel
Fiserv
First Data Resources
Getnet Acquisition
High Tech Systems
KFTC KNET
(KSSC Kuwait)
Pay-as-you-go
PicPay
Redlink Argentina
Securian
Solomon Financial Group
Sungard (FIS Global)
Windcave

ACI Worldwide
BC Card
Capital One
CartaSi
Equifax
Experian
Hyundai Card
LG credit
Lotte Card
NH Card
Prorecard
Rakuten Card
Samsung Card
Sopra Banking
Tencnocom/INDRA
Visa

Aegon
Aflac
AIG
Allianz
AXA
Citizens
DB Insurance
Farmer's Mutual Hail
Generali
Henner Group
Guardian Life
Hartford Insurance
IAG
Indianapolis Life
ING
KoreanRe
Kyobo Life Insurance
Munich Re
NRMA
Prudential
Samsung Life
Seoul General
Shinhan Life
The Hartford