Dashboard creation for Personal Banking (Mortgage, Auto Loans, Attrition, Channels, Payroll Loans).

• Extraction of information from IBMi´s DB2 Core Bank database to an SQL Stage Database in SQL Server 2008.
• Creation of data transformation processes as required by the business logic and storage in a Datawarehouse repository.
• Delivery of data transformation and cleaning processes.
• Dashboard creation taking data stored in the Datawarehouse as a source and publish it to provide visibility to the business area.

Create support tools for decision-making.

• Show updated reliable and accurate information to support the business.
• The Tool must be easy to use for business users.
• The Dashboard must be able to incorporate new perspectives as required.

Using cutting-edge technology for information visualization and data analysis.

• Allows business management to identify areas of penetration for the implementation of new products.
• Actively allows the control and monitoring of products.
• Monitoring and identification of risks in the implementation of some products.
• Summary management of data and information for decision making.