Jordi Florensa

Analytics in CRM Department. Selection the customers (using ETL with Oracle SQL or SAS) with the best propensity to buy (calculated from propension models using R or Python) following commercials needs and send them to our commercial Managers. Reporting all campaigns analyzing contacts and sales doing dynamics reports with QlikSense or Tableau. Also, creating automatic process of all this reports using Airflow ( for ETL ) and Nprinting (for Tableau).

Adaptation and implementation of the methodological approach in project management and Business Intelligence services. Development of models and their industrialization through the tools: R, SAS, SQL, ORE and ODI. Implementation of Machine Learning to develop GBM models.

- Project in Gas Natural Fenosa optimizing the commercial routes through R and Tableau. Use of the Google API in R.

-Project in Generalitat de Catalunya. Analyzing the students from enrolling until they are titled / left / are studying, using R. Performing a DashBoard using Shiny and R.

-Operations analyst. Functional in the implementation of Solvency II in VidaCaixa. P / L SQL. Reporting of Pillar III and calculation of Pillar I SCR using the tools: ORACLE SQL Developer and Excel.