Prof. Hernan Molina

Taking clear stakeholder briefs, sourcing data, building, testing and verifying analytical results. Use exception reporting, data mining, behavioral and trend analysis techniques. Deliver insightful financial crime management reporting using Power BI, Tableau, Microsoft BI stack and SAS. Developing continuous improvement in analytical capabilities and business KPI’s, extracting data from enterprise DataWarehouse, Oracle, SQL DB, Azure. Using SSAS and SSIS to improve current Fraud cube and Microsoft Azure

- Analysis, design, developing and deployment of reports, KPI's & dashboards in Microsoft Power BI. - Gathering and documenting requirements with internal customers and translate into insight to enable better business decision making. - Liaise across business units & stakeholder groups to understand key business requirements; - Analysis and design of Datawarehouse using Microsoft BI stack(SSIS,SSAS,SSRS).

Consult, advise and solve problems related to Data, reporting and BI solutions. Analysis, design, develop and deployment ETL’s to build a Data-Warehouse with open-source tools such as MySQL and Pentaho Data Integration. Create and improve existing reports and dashboards in Microsoft Power BI, data quality. Collect and analyze data from different third-parties providers to derive insights and turn data into actionable information for business consumption.

Analysis, design, develop and deployment reports & analytics with visualization tools like Tableau and Power BI, also OWB & OBIEE. Interpretation and presentation of reporting and other metrics to customers, deliver insights and analytics to stakeholders. Analyze business requirements and use data to identify opportunities for business improvement. Generate queries and create store procedures and PL in Oracle and SQL server to maintain information updated and assuring data quality.

Use Microsoft SSAS, SSRS, SSIS, SQL server, Oracle. Support and maintain Data Warehouse, design and develop ETL, reports and cubes. Documentation process supports entering production projects or changes. Analysis, design, modelling, presentation and reporting capability, presenting analysis and reports to customers to help them to improve decision takes. Gathering requirements and liaise between BI users and architecture and development team to translate business requirements into data models.

Analysis, validation and specification requirements for customers. Maintenance and analysis CRM applications, management of SQL Server. Functional and non-functional testing. Design Data warehouse, DataMart, dashboard, and reports with Pentaho. Use IBM Cognos 8 suite with Report Studio, Analysis Studio, Query Studio. Documentation process to support entering production projects or changes and writing and modifying T-SQL scripts for data extraction and testing data

Postgraduate focused in Information Systems. That specialist topic covers the acquisition, storage, transformation and analysis of data and information within a business setting. Also include Data Mining, machine learning, artificial intelligence, business Intelligence and Data science.