Fernando Soares

Background

About Fernando Soares

Senior Data Engineer (06-2018/-)- Online Commerce Fashion Retailer ETL data pipelines re-engineering in order to adapt legacy code (Ms SSIS) running in SQL Server databases into Spark+Python data pipelines. The orchestration was done by using Apache Airflow to schedule and control the execution of each step of the data pipeline (execution of scripts, logging execution, visualisation of the workflow thought DAGs) Tecnologies: Hadoop cluster, HDFS, Hive, Impala, Spark, Python, Airflow, Jira, Jenkins, GIT, Google BigQuery Senior Consultant (04-2017/06-2018)- Company of foodservice business Development and maintenance of multiple data pipelines ETL processes, that included: Integration from multiple sources (DB2, Oracle, MySQL, CSV and XLS files) into SAS datasets and SAS LASR Server; User support and training.Setup and maintenance/support of and SAS applications. Tecnologies: SAS VA; SAS Enterprise Guide; SAS Management Console; SQL; PL SQL; SAS Programing Manager of IT Department (06-2012 / 04-2017) Manage a SAP ERP project that includes CO, FI, SD, MM, PP, ABAP developments and its integration with a mobile sales software(MSS Mobile). Suport all the IT needs of the company from software to hardware. Consultant (07-2010 / 05-2012) Creation of Oracle BI EE reports to support production and maintain a cleaner interface and access to information conveyed to employees of the Caixa Geral de Depósitos Consultant (01-2010 / 06-2010) Creation of an application in APEX technology, for Incentive Points for workers of a bank. Consultant (05-2009 / 01-2010) Installation and maintenance in various health centers, Statistics Module of the Medical Support System, which provides the medical indicators in the area of Primary Care. Consultant (12-2008 / 04-2009) Implementation of Financial Reporting in Oracle Business Intelligence Suite. The scope of the project lay in the collection and consolidation of accounting information of 124 companies in the group.