{"id":10782,"date":"2020-09-11T08:43:23","date_gmt":"2020-09-11T08:43:23","guid":{"rendered":"https:\/\/bluetab.net\/regulatorio-calculo-del-capital\/"},"modified":"2020-09-11T08:43:23","modified_gmt":"2020-09-11T08:43:23","slug":"regulatory-capital-calculation","status":"publish","type":"post","link":"https:\/\/bluetab.org\/en\/2020\/09\/regulatory-capital-calculation\/","title":{"rendered":"Regulatory Capital Calculation"},"content":{"rendered":"<p>In the context of the implementation of a risk-based supervisory methodology known as the Comprehensive Supervisory Framework (MIS for its initials in Spanish),\u00a0<b>we collaborated<\/b>\u00a0with a leading Spanish financial institution\u00a0<b>to integrate the risks that could affect the institution and enable the construction and full evaluation of its corporate risk profile<\/b>\u00a0by bringing together all the information from the local entities that make up the financial group.<\/p>\n<p>The contribution of the bank\u2019s assets is monitored monthly for this purpose. A variety of corporate extraction, transformation and loading processes are performed to do this, providing a solution to budget team reporting times, due to the latent need of users to automate their reporting process, and translating their Excel Macro into a Spark\/Scala process.\u00a0<\/p>\n<p>Outstanding within the evolution are the performance improvements and upgrading of the corporate Big Data platform for better organisation and management of parameters, transformation of the source tables to dashboards and migration of tables to a common module called \u201ccommon data\u201d.<\/p>\n<p>This project has its own data governance processes, providing for pre-ingestion approval and a series of technical and functional validations performed in the platform landing layer. The Business layer accessed by users is supplied with two tables (as the numerator and denominator of the budgets).\u00a0<\/p>\n<p>Data reporting is performed with MicroStrategy and the ETL process is based on Scala\/Spark technology.<\/p>\n<p>SUCCESS STORIES<\/p>\n<p>\t\t\t\t<a href=\"https:\/\/bluetab.net\/en\/calidad-del-dato-de-la-informacion-de-seguros\/\"><br \/>\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bluetab.net\/wp-content\/uploads\/2020\/11\/Calidad-seguros-300x165.jpg\" title=\"Calidad-seguros\" alt=\"Calidad-seguros\" \/>\t\t\t\t<\/a><\/p>\n<h2 ><a href=\"https:\/\/bluetab.net\/en\/calidad-del-dato-de-la-informacion-de-seguros\/\">Quality of insurance information data<\/a><\/h2>\n<p>Our client is a major financial institution with presence mainly in Europe and America; among the three largest insurers in the market in Mexico and also a leader in the regions where it operates. It has undertaken a digital transformation&hellip;<\/p>\n<p>\t\t\t\t<a href=\"https:\/\/bluetab.net\/en\/leading-multinational-in-beverage-sales-and-distribution\/\"><br \/>\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bluetab.net\/wp-content\/uploads\/2020\/09\/science-in-hd-oono0llxzrm-unsplash.jpeg\" title=\"\" alt=\"Foto por Science in HD en Unsplash\" \/>\t\t\t\t<\/a><\/p>\n<h2 ><a href=\"https:\/\/bluetab.net\/en\/leading-multinational-in-beverage-sales-and-distribution\/\">Leading multinational in beverage sales and distribution<\/a><\/h2>\n<p>Optimisation of Supply Chain processes.Our client is a Mexican multinational leader in the beverage sales and distribution sector, with a major establishment in America and recently acquired by a US group. In its continual optimisation process, it has embarked on&hellip;<\/p>\n<p>\t\t\t\t<a href=\"https:\/\/bluetab.net\/en\/multi-brand-ndwh\/\"><br \/>\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bluetab.net\/wp-content\/uploads\/2020\/09\/halacious-tzc3vjpck-q-unsplash-scaled.jpeg\" title=\"\" alt=\"Foto por Halacious en Unsplash\" \/>\t\t\t\t<\/a><\/p>\n<h2 ><a href=\"https:\/\/bluetab.net\/en\/multi-brand-ndwh\/\">MULTI-BRAND NDWH<\/a><\/h2>\n<p>mong the emerging operators in the telecommunications business, there has been an initiative that allows a single entity to integrate several commercial brands, integrating the processes common to all of them and making them as efficient as possible.So, for the&hellip;<\/p>\n<p>\t\t\t\t<a href=\"https:\/\/bluetab.net\/en\/data-warehouse-unificado\/\"><br \/>\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bluetab.net\/wp-content\/uploads\/2020\/09\/nasa-q1p7bh3shj8-unsplash-scaled.jpeg\" title=\"\" alt=\"Foto por NASA en Unsplash\" \/>\t\t\t\t<\/a><\/p>\n<h2 ><a href=\"https:\/\/bluetab.net\/en\/data-warehouse-unificado\/\">Unified Data warehouse<\/a><\/h2>\n<p>The telecommunications sector has always been a very dynamic sector. In this sense, they have always had an urgent need to analyze their information in a convergent and unique way.To this end, an agile end-to-end collaboration has been consolidated with&hellip;<\/p>\n<p>\t\t\t\t<a href=\"https:\/\/bluetab.net\/en\/modelo-global-de-supervision-bancaria\/\"><br \/>\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bluetab.net\/wp-content\/uploads\/2020\/09\/bernard-hermant-ihcshrzxfs4-unsplash-scaled.jpeg\" title=\"\" alt=\"Foto por Bernard Hermant en Unsplash\" \/>\t\t\t\t<\/a><\/p>\n<h2 ><a href=\"https:\/\/bluetab.net\/en\/modelo-global-de-supervision-bancaria\/\">Global model of banking supervision<\/a><\/h2>\n<p>Banks must meet a growing volume of complex and granular reporting requirements. The methods used to collect reporting data are not fully harmonized, often leading to redundancies, overlaps, and inconsistencies in the resulting data sets. In this context there is&hellip;<\/p>\n<p>\t\t\t\t<a href=\"https:\/\/bluetab.net\/en\/informacion-de-proveedores-de-mercados-de-banca-corporativa\/\"><br \/>\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bluetab.net\/wp-content\/uploads\/2020\/09\/jason-pofahl-6aqy7po1ls0-unsplash-scaled.jpeg\" title=\"\" alt=\"Foto por Jason Pofahl en Unsplash\" \/>\t\t\t\t<\/a><\/p>\n<h2 ><a href=\"https:\/\/bluetab.net\/en\/informacion-de-proveedores-de-mercados-de-banca-corporativa\/\">Corporate banking market supplier information<\/a><\/h2>\n<p>Within our context as a benchmark technology partner in the Data field in the Corporate Investment Banking area for one of the leading Spanish financial institutions operating in the principal markets globally; a collaborative technology approach is being developed to&hellip;<\/p>\n<p>\t\t\t\t<a href=\"https:\/\/bluetab.net\/en\/regulatory-capital-calculation\/\"><br \/>\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bluetab.net\/wp-content\/uploads\/2020\/09\/william-iven-damhwsryp9c-unsplash-scaled.jpeg\" title=\"\" alt=\"Foto por William Iven en Unsplash\" \/>\t\t\t\t<\/a><\/p>\n<h2 ><a href=\"https:\/\/bluetab.net\/en\/regulatory-capital-calculation\/\">Regulatory Capital Calculation<\/a><\/h2>\n<p>En el contexto de la implementaci\u00f3n de una metodolog\u00eda de supervisi\u00f3n basada en riesgos conocida como Marco Integral de Supervisi\u00f3n (MIS) realizamos una colaboraci\u00f3n con una de las principales entidades financieras espa\u00f1olas, integrando los riesgos que pueden afectar a&nbsp; la&hellip;<\/p>\n<p>\t\t\t\t<a href=\"https:\/\/bluetab.net\/en\/investment-and-corporate-banking-regulations\/\"><br \/>\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bluetab.net\/wp-content\/uploads\/2020\/09\/stephen-phillips-hostreviews-co-uk-em37ks8wjjq-unsplash-scaled.jpeg\" title=\"\" alt=\"Foto por Stephen Phillips - Hostreviews.co.uk en Unsplash\" \/>\t\t\t\t<\/a><\/p>\n<h2 ><a href=\"https:\/\/bluetab.net\/en\/investment-and-corporate-banking-regulations\/\">Investment and Corporate Banking Regulations<\/a><\/h2>\n<p>In this field, we are involved in major Big Data lake developments, where the main users are the regulatory and risk departments associated with the growing need in the area to comply with the various standards and regulatory frameworks demanded&hellip;<\/p>\n<p>\t\t\t\t<a href=\"https:\/\/bluetab.net\/en\/psd2-regulations\/\"><br \/>\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bluetab.net\/wp-content\/uploads\/2020\/09\/mari-helin-ilsnkt1imxe-unsplash-scaled.jpeg\" title=\"\" alt=\"Foto por Mari Helin en Unsplash\" \/>\t\t\t\t<\/a><\/p>\n<h2 ><a href=\"https:\/\/bluetab.net\/en\/psd2-regulations\/\">PSD2 regulations<\/a><\/h2>\n<p>PSD2 is a European regulation on digital payment services. This system facilitates payments throughout Europe with greater security as well as offering a banking service adapted to new technologies. With it, the importance that the world of &#8216;APIS&#8217; or &#8216;Application&hellip;<\/p>\n<p>\t\t\t\t<a href=\"https:\/\/bluetab.net\/en\/retail-banking-regulations\/\"><br \/>\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bluetab.net\/wp-content\/uploads\/2020\/09\/rupixen-com-q59hmzk38eq-unsplash-scaled.jpeg\" title=\"\" alt=\"Foto por rupixen.com en Unsplash\" \/>\t\t\t\t<\/a><\/p>\n<h2 ><a href=\"https:\/\/bluetab.net\/en\/retail-banking-regulations\/\">Retail Banking Regulations<\/a><\/h2>\n<p>A regulatory project to respond to\u00a0Spanish Royal Decree-Law 19\/2017, on basic payment accounts, transfer of payment accounts and comparability of commissions, for customers to be able to compare products more easily and move within the Union, benefiting from an internal&hellip;<\/p>\n<p>\t\t\t\t<a href=\"https:\/\/bluetab.net\/en\/escritorio-remoto-virtual\/\"><br \/>\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bluetab.net\/wp-content\/uploads\/2020\/09\/allie-goupqaau9qo-unsplash-scaled.jpeg\" title=\"\" alt=\"Foto por Allie en Unsplash\" \/>\t\t\t\t<\/a><\/p>\n<h2 ><a href=\"https:\/\/bluetab.net\/en\/escritorio-remoto-virtual\/\">Virtual remote desktop<\/a><\/h2>\n<p>Because there is no integrated CRM for corporate banking that contains customer data, opportunities, visits and all customer relationship information, this generates the need for this project with the aim of providing global multi-entity coverage.Bluetab is developing the part corresponding&hellip;<\/p>\n<p>\t\t\t\t<a href=\"https:\/\/bluetab.net\/en\/infraestructura-omnichannel\/\"><br \/>\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bluetab.net\/wp-content\/uploads\/2020\/09\/alvaro-reyes-qwwphwip31m-unsplash-scaled.jpeg\" title=\"\" alt=\"Foto por Alvaro Reyes en Unsplash\" \/>\t\t\t\t<\/a><\/p>\n<h2 ><a href=\"https:\/\/bluetab.net\/en\/infraestructura-omnichannel\/\">Omnichannel infrastructure<\/a><\/h2>\n<p>A Spanish multinational banking group asked us to provide its various group entities with an infrastructure with the necessary data to construct its customer\u2019s \u201cjourney\u201d.\u00a0This solution will make it possible to analyse the customer journey from start to finish, i.e.&hellip;<\/p>\n<p>\t\t\t\t<a href=\"https:\/\/bluetab.net\/en\/360-customer-vision-model\/\"><br \/>\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bluetab.net\/wp-content\/uploads\/2020\/09\/you-x-ventures-bzqu01v-g54-unsplash-scaled.jpeg\" title=\"\" alt=\"Foto por You X Ventures en Unsplash\" \/>\t\t\t\t<\/a><\/p>\n<h2 ><a href=\"https:\/\/bluetab.net\/en\/360-customer-vision-model\/\">360\u00b0 customer vision model<\/a><\/h2>\n<p>We are the primary Big Data platform partner to one of the leading global financial institutions in technology. In the framework of our collaboration, the various group entities are provided with an infrastructure with the data necessary to build the&hellip;<\/p>\n<p>\t\t\t\t<a href=\"https:\/\/bluetab.net\/en\/explotacion-y-reporting-de-un-sistema-informacional\/\"><br \/>\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bluetab.net\/wp-content\/uploads\/2020\/09\/nathan-dumlao-af2qimux3yu-unsplash-scaled.jpeg\" title=\"\" alt=\"Foto por Nathan Dumlao en Unsplash\" \/>\t\t\t\t<\/a><\/p>\n<h2 ><a href=\"https:\/\/bluetab.net\/en\/explotacion-y-reporting-de-un-sistema-informacional\/\">Information system exploitation and reporting<\/a><\/h2>\n<p>One of the leading Financial Institutions in the Spanish domestic market decided to perform a split of the services of its new information platform with the aim of ensuring technical-functional understanding of the various layers, as well as to ensure&hellip;<\/p>\n<p>\t\t\t\t<a href=\"https:\/\/bluetab.net\/en\/datalake-sector-utilities\/\"><br \/>\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/bluetab.net\/wp-content\/uploads\/2020\/09\/charles-deluvio-pjah2ax4uwk-unsplash-scaled.jpeg\" title=\"\" alt=\"Foto por Charles Deluvio en Unsplash\" \/>\t\t\t\t<\/a><\/p>\n<h2 ><a href=\"https:\/\/bluetab.net\/en\/datalake-sector-utilities\/\">Utilities sector Data Lake<\/a><\/h2>\n<p>Within the digital transformation process, the option was taken to build a Data Lake to serve various departments in a cross-cutting manner.Bluetab has developed a Data Lake in AWS for a leading Spanish energy companies, which gets its data from&hellip;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the context of the implementation of a risk-based supervisory methodology known as the Comprehensive Supervisory Framework (MIS for its initials in Spanish),\u00a0we collaborated\u00a0with a leading Spanish financial institution\u00a0to integrate the risks that could affect the institution and enable the construction and full evaluation of its corporate risk profile\u00a0by bringing together all the information from [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":4378,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"elementor_header_footer","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[20],"tags":[22],"class_list":["post-10782","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-casos-2","tag-data-fabric-2"],"acf":[],"_links":{"self":[{"href":"https:\/\/bluetab.org\/en\/wp-json\/wp\/v2\/posts\/10782","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bluetab.org\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bluetab.org\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bluetab.org\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bluetab.org\/en\/wp-json\/wp\/v2\/comments?post=10782"}],"version-history":[{"count":0,"href":"https:\/\/bluetab.org\/en\/wp-json\/wp\/v2\/posts\/10782\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluetab.org\/en\/wp-json\/wp\/v2\/media?parent=10782"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluetab.org\/en\/wp-json\/wp\/v2\/categories?post=10782"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluetab.org\/en\/wp-json\/wp\/v2\/tags?post=10782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}