Luis Alberto Jaramillo Sevilla

Experience

• 

  RICARDO PEREZ S.A.

  Oct 2006 - Jun 2008

  OFICIAL DE COMERCIALIZACION

  1.Encargado de la extracción y análisis de información de las bases de datos dePost Venta Ricardo Pérez S.A. (Taller y repuestos) para las diferentes solicitudes delas áreas de las empresas.2.Creación de presentaciones para la junta directiva sobre los indicadoresprincipales de repuestos y taller.3.Reportes para la alta gerencia y sucursales de Ventas de repuestos y mano deobra vs Presupuesto, utilidades, márgenes de ventas, inventario, costos, producciónde talleres y mecánicos, eficiencia de los talleres, confección del presupuesto deRepuestos.4.Apoyo en la confección de presupuestos de ventas de las sucursales de taller yrepuestos. Show less

• 

  CITI BANK

  Apr 2009 - May 2011

  MANAGMENT INFORMATION SISTEM

  1.Responsible for the administration of the bank's lost portfolio database (cards andretail) in the assignment of accounts and measure the recovery and efficiency ofthis portfolio.2.Analyze and report the productivity (outbound and inbound calls, contacts,efficiency, incentives) of the collection plant by manager.3.Preparation of delinquency and portfolio reports for the bank's different products(cards and retail).4.Regional reports from Citi Panama's collections area.5. Presentation of the Board of Directors, analysis of the active portfolio of cardsand retail,6. Preparation of queries in SQL and Business Object, SAS, audit and fraud reports.7. Creation of querys in Data wharehouse.8. Support in the creation of new collection strategies. Show less

• 

  DREAMTECH

  Jun 2011 - Nov 2014

  CERTIFIED SAP BUSINESS ONE CONSULTANT – HEAD OF BUSINESS INTELLIGENCE

  1.Implementer and administrator of the SAP ON HANA database engine andplatform.2.Programming of Querys and storage procedures (Sql Server, Hana Studio) for thepreparation of reports and analysis of information in Crystal Report, Qlikview and BI,on sales analysis, inventory turnovers, purchases, production, etc. and printingformats (invoice, credit notes, purchase order, etc.) for the company's customers.3.Preparation, analysis and audit of financial reports such as income statement,balance sheets, general ledger, financial ratios, movement of accounting accounts,project executions, expenses, bank reconciliations, cash flow, deposits, collections,delinquencies.4.Provide support in the administration of the implemented databases and modulesof the SAP system in the clients.5.Provide training in the use of SAP software and its modules to end users.6.Teach courses in Sql Server, Crystal Report, Visual Intelligence, SAP HANA andCrystal report server oriented to SAP.7.Assist in the planning, development and implementation of SAP in companies.8.Attention to incidents and support tickets regarding the operation of the SAPsystem.9.SAP HANA Database Administrator.10.Coordinate and distribute the functions of the reporting area and print formatswith the work team. Show less

• 

  BANISTMO

  Nov 2015 - Feb 2017

  BUSINESS BANKING AND GOVERNMENT RISK ANALYST

  1.Moody's Platform Manager (Risk Analyst) who analyzes the financial risk offinancial clients.2.Analysis of regulatory reports of the Superintendence of Panama, AT03 and AT12.3.Preparation of portfolio analysis reports of the bank's business and governancesegment.4.Internal database administrator of the risk, business banking and governmentarea.5.Business line of credit reports.6.Reports of guarantees associated with business loans.7.Projects to improve the data of the bank's portfolios and credit systems.8.Board of Directors presentations.9.Reporting and analysis of information related to the area of compliance.10.Manage access to business credit management information.11.Development and implementation of strest testing (risk analysis Show less

• 

  CAJA DE AHORROS.

  Feb 2017 - Nov 2017

  MANAGERIAL INFORMATION MANAGER

  1.Delinquency reports and the bank's credit portfolio.2.Preparation of credit atoms and guarantees (AT03 and AT12) for theSuperintendency of Banks.3.Calculation of the classification and regulatory reserve of the credit portfolioaccording to agreement 4-2013 of the SBP.4.Credit approval management reports.5.Reports of inconsistencies for the maintenance of the quality of the information ofthe bank's credit portfolio.6.Reports of inconsistencies for the maintenance of the quality of the information ofthe guarantees assigned to the bank's credit portfolio.7.Assignment of campaigns for portfolio maintenance.8.Attention to various requests for information to the credit managementdepartment.9.Attention and reports on regulatory issues of the SBP.10.Reporting and management of punished corporate portfolio.11.Follow-up of the findings of the Superintendence of Banks (SBP). Show less

• 

  MULTIBANK.

  Nov 2017 - Dec 2019

  OFFICER COMPLIANCE

  1.Regulatory reports for the superintendence of banks.2.Transactional analysis of liability accounts due to possible unusual movements ofthe same.3.Risk ratings of the bank's customer portfolio.4.Monitoring the data quality of the bank's systems.5.Manage compliance DWH.6.DGI regulatory projects (FATCA and CRS).7.Implementation of an alert model for deviation of the account's transactionalprofile.

• 

  CAJA DE AHORROS

  Jan 2020 - Mar 2024

  FINANCIAL RISK OFFICER

  1.Leader of the Covid impact moratorium project, implementation, monitoring andfollow-up.2.Calculation of the NIFF Reserve of the bank's loan portfolio.3.Analysis of the loan portfolio, delinquencies and reserves.4.SBP Regulatory Reports.5.Database analysis.6.Analysis of income and compliance with quotas of credit portfolios.7.Information requirements of the databases of the bank's main systems.

• 

  Multibank Panamá

  Sept 2022 - now

  TECHNOLOGY COMPLIANCE OFFICER

  1.Administrator of the transactional monitoring tool Monitor Plus. Configuration andparameterization of conditions, rules, tables, queues, pivot tables and users of thetool, implementation of transactional alert models such as risk matrix of the bank'scustomers, access to the tool's database for generation of transactional analysisand reports of the tool.2.Database analyst of the DHW of the bank for the design and extraction ofinformation through querys in sql server. Portfolio reports of liabilities, loans,customers, segment analysis, etc.3.Regulatory reports to the SBP. Atom of risk factors.4.Implementation and configuration of transactional alerting model for transactionalSMT banks.5.Projects to improve the transactional monitoring tool. Profile Deviation Models,Adaptive Alerts, SMT Alerts, and Customer Risk Matrix.6.Updating internal lists in name scanning tool against lists called Bridger. Show less