About The Client

The Client is a leading Asian financial institution, operating across more than 13 countries. The bank offers a comprehensive suite of financial services to retail and wholesale clients, including deposits, loans, cards, insurance, foreign exchange, and wealth management solutions.

Business Challenges

  • As a large banking group, the client manages a complex data ecosystem with numerous in-house and vendor applications serving the financial needs of diverse client segments. All generated and collected data adheres to strict banking regulations for secure storage.

  • To enhance their data analytics capabilities and strengthen the surrounding data ecosystem, the client sought a skilled partner. Additionally, the client requires 24/7 on-site support to empower their data team to perform a wide range of activities.

What did we do?

  • Deployed our data analytics experts’ team on various levels and skill sets which include ETL developers, ETL Testers, DevOps, Technical PM & Delivery Managers, System Analysts, Data visualization, Bigdata, Hadoop & Full Stack Developers.
  • Our team has quickly learned the client’s process and adapted with their work culture and started delivering the various key data projects for various regions.

  • Today, our 65+ team members work with 29 different data teams and deliver values in the data domain.

  • In addition to data operations, our consultants support various non-data initiatives across the bank, including AML, Temenos implementation, Neoxm, Cards, Core Banking application support, and other critical banking functions.

  • Created and supported multiple data platforms and solutions, including Regulatory Data Mart (FATCA), Retail Data Mart, Operational Data Mart, Analytical Data Mart, and Reporting Data Mart.

  • Supported Customer Segmentation initiatives and data feeds to the Credit Engine.
  • Supported a Data Lake that consumes approximately 15,000 files daily, enabling the Analytics team to access more frequently refreshed data.

  • To support this initiative, we have dedicated HR professionals to support all our onsite team on various points (Travel, Visa, EP, Payroll, insurance and payroll).

Business Outcome:

  • Our team has strengthened the client’s data team and improved the various data activities.
  • Helped Customer complete the major data migration, integration with new data systems & successfully supported various vendors & downstream applications for data management and changes around it. (Development, SIT, UAT & Prod releases)

  • Enabled the client to move from monthly data availability to more frequently refreshed data for analytics, supporting faster and more current insights.

  • Strengthened regulatory, retail, operational, analytical, and reporting capabilities through the development of specialized data marts.

  • Supported critical banking functions beyond data operations, helping extend technology support across multiple business and application areas.

Tools & Technologies:

ETL Informatica, Teradata, Cloudera, IBM AS400, RPGLE, ALDON, UNIX, SQL, Python, Oracle, Unix/Linxs,GIT, Big data, Hadoop, MS Dynamics CRM, Ruby, Chef, Data Warehouse, Data Modeling, BI, SAS, Teradata, Qliksense, QlikView.

Related Case Study