Fernando Gonsallo

• • Mission 1: Decision-making projects - Reporting: development in Power BI with advanced indicators (DAX language), Development in SAS for projects (soliciting the business for tool and methodology to use and development in SAS).

• • Mission 2: Data Crunching - Oracle / Amazon-redshift database querying in SAS/SQL (on local & VM environment), One-off and recurring extractions on provident data, Responsible for the automation and run of recurring extractions on broker contract contributions.

• • Mission 1: Run and Development - Automation of reporting with SAS and SQL: loading then aggregating all inputs, then passing to VBA to get the final report in Excel format, Maintenance of existing systems, Querying Teradata databases, Taking on ancillary reporting topics for Savings.

• • Mission 2: Migration of projects from SAS to Python (visual code interface) & Automation of recurring needs on Python.

• • Mission 3: Data Crunching - Business Assets Project (Extraction of data from Teradata and restitution in reporting format).

• • Mission 1: Run and Development - Ensure the update and automation of existing systems using SAS, SQL, PYTHON, and ARCGIS.

• • Mission 2 Data Viz and ETL - Creation of maps using ArcGIS PRO: an important step to view data consistency from a spatial perspective, Production of data via ETL (ESRI) then creation of .bds extensions from the Installshield virtual machine by updating metadata and Python formulas: the objective being to create a product installation disk, Project development, Writing and presentation of technical supports.

• • Mission 3: Taking on new projects, Autonomous handling of various projects (including the creation of a polygon of postal codes in the metropolitan area), Writing and presentation of technical supports for annual GIS conferences visible to all clients or prospects.