Gustavo L.

Experience

• 

  BANKING, INSURANCE, TRANSPORT, TELECOMMUNICATIONS, INDUSTRY AND COMMERCE

  Jul 1987 - Sept 2011

  SENIOR TI PROJECT MANAGER / CONSULTANT

  • Assist different business areas. Coordinate the technical team (+30 p).• Provide information on: clients, products, rates, transportation, routes, accounting; business risks and opportunities; order logistics, distribution, storage, sale and delivery of vehicles and spare parts.• Design and build analytical models, data queries, extraction, transformation and loading processes, dynamic and paginated reports, and corporate applications. Import variables from various sources and formats. Create dynamic dashboards and obtain key performance indicators (KPIs).• SQL, PL/SQL, SQL Server, Oracle, DB2, PowerBuilder, COBOL, JCL, Control-M, Visual Studio, ETL, SSIS, SSAS, SSRS, DWH, Excel, VBA, MS Power BI, OBI environment. Show less

• 

  POPULAR BANK (SPAIN)

  Sept 2011 - May 2018

  SENIOR BI PROJECT MANAGER / CONSULTANT

  • Collect financial information from clients and commercial performance of offices, using OLAP models, to prepare dynamic dashboards (dashboard and KPIs).• Manage user requests. Coordinate the design and construction of the DWH, ETL processes, PL/SQL queries, OLAP cubes and BI reports. Report results to Management.• SQL, PL/SQL, DB2, Oracle, SQL Server, SSAS, SSIS, SSRS, Excel, VBA, ETL, OBI, MS Power BI, Microstrategy, KPI, DWH, OLAP environment.

• 

  SANTANDER BANK (SPAIN)

  May 2018 - Jan 2020

  SENIOR BI PROJECT MANAGER / CONSULTANT

  • Obtain statistics on products marketed by the entity and contracting channels. Identify potential clients by evaluating risks and business opportunities.• Coordinate data analysis, construction of ETL processes, PL/SQL queries and OLAP models in the DataWarehouse, to feed predictive models. Design and publish dashboards and KPIs.• PL/SQL environment, DB2, Postgre, Oracle, SQL Server, SSIS, SSAS, SSRS, Excel, VBA, ETL, MS Power BI, Microstrategy, QlikVew, KPI, DWH, OLAP.

• 

  MINISTRY OF INDUSTRY AND TOURISM (SPAIN)

  Jan 2020 - now

  SENIOR BI PROJECT MANAGER / CONSULTANT

  • Manage and invoice 100% of the service of the awarded contracts (+1.2 M €/year). Collaborate in the preparation of offers.• Attend: 1 Computer Science Area (SGTIC), 3 Business Areas (SSCC) and 33 Departments (OETs).• Successfully lead the Technical Team (11 p: 2 CO, 3 AF and 6 AP). Know and control +35 projects in 7 Information Systems: ANALIZA, DATATUR, ESTRATUR, MARKETUR, DIMCOM, DATAJIRA and INFRACOM.• Manage the IT equipment inventory of +36 offices, deployment and maintenance projects, and budgets.• Provide statistics on tourism indicators: searches and reservations for trips and accommodations, means of transport, expenses and consumption, advertising marketing, promotional activities, surveys, employment, origin and destinations, tourist profile, etc.• Implement BI Architecture. Create User Stories. Design DWH models, SSAS cubes, ETL processes and dashboards and KPIs. Publish BI reports to the cloud. Manage Sprints, team and user meetings, and Steering Committees.• Implement ML Architecture, in CDP of SGAD, to generate predictive models with Turespaña's turistic sector variables.• SQL Server environment, SSIS, SSAS, SSRS, ETL, .Net, API Rest, DWH, PLSQL, DAX, SFTP, Gateway, MS Power BI, KPI, Excel, JIRA, SCRUM, AGILE, KANBAN, SharePoint, Azure DevOps. Show less