Curriculum Vitae a

Sérgio Fernandes

Personal Data

Email:adx1tc@r.postjobfree.com Phone: +351-********* Linkedin: https://www.linkedin.com/in/sergioafernandes1975 Skype: sergiofernandes.1975 Birthdate: 25/04/1975 Nationality: Portuguese

Address: Portugal Languages: Portuguese, Spanish, English, French (Intermediate ++) and German (B1– intermediate) Academic Skills

2006-2008 – Post graduation in Finance, IDEFE / ISEG, Lisbon, Portugal; 2002-2004 - Master in Computer Science Engineering, Portugal– Lective part with final grade B; 1993-1998 – University Degree in Computer Science Engineering, Portugal, final grade of 15/20 (B); MOOC – Massive Online Courses

2018 – Machine Learning A-Z™: Hands-On Python & R In Data Science, Udemy 2018 – Data Science Specialization, Johns Hopkins University, Coursera 2014 – Supply Chain and Logistics Fundamentals, MITx – CTL.SC1.x, EDX 2014 – General Game Playing, Machine Learning, Stanford University, Coursera Professional Experience

JUN 2022 to SEP 2022– Senior Consultant – Accenture / Montepio SAS / SQL Senior Consultant. The project was managed using SCRUM and was partioned in small intervention projects (Called ITR) each of them counting as a project for the implementer. All environment was SAS Based. Methodologies: SCRUM

JUN 2021 to MAY 2022– Business Intelligence Consultant – PrimeIT / Whitestar Asset Solutions WhiteStar Asset Solutions is migrating their Operational System to a new one. As well as all reporting associated with Operational System. The project is to migrate all reports using as base reporting code used by previous Operational System reports. Therefore this means writing SQL Code based in old SQL Code using new and old data model.. Methodologies: SCRUM

AUG 2018 to OCT 2018 – SAS Consultant – SOGETI / EUROSTAT - Luxembourg SAS Programmer for Eurostat project. Eurostat has a big SAS DataBase where all statistics were stored. Therefore new developments should be in line with such DataBase. Worked closely with Business Owners on Requirements gathering for new developments. Methodologies: Waterfall; Rapid Warehousing Methodology JUN 2014 to JUL 2016 – Technical Analyst BI/SAS (SCM/BEX) – Swarovski TRIESEN - Liechtenstein SAS specialist – maintenance of existing SAS programs and developing of new Data Integration Jobs; Support on installation of SAS 9.4;

VBA/Microsoft Excel programming and maintenance of existing programs. Run forecast process collecting data in Excel from globally distributed Swarovski Offices (VGs) and read/integration of this data in SAS repository to be used by other applications and Business users;

SAP BW queries – simple queries maintenance;

SAP ERP – checking data on SAP ERP system and download of data from such systems; Methodologies: Data Warehousing; Kimball; Rapid Warehousing Methodology; JAN 2013 to JUL 2013 SAS Senior Consultant at BeoBank through Mainsys - BRUSSELS, reporting to Partner/PM Worked as Senior DataWarehouse / Business Intelligence Consultant for BeoBank Corporate Data Warehouse using UNIX and SAS 9.3 technologies:

Perform design workshops on dimensional modelling and Master Data Management (design and build of unified view of customer and branches data for example) with Client Project Management and SPOC; Requirements Gathering;

DW setup – define main streams of DW ETL Architecture: SAS Libraries; ETL Audit SAS macros; Job dependencies and requirements for scheduling;

Performance test / proof of concept of SAS against SQL Server legacy Data Mart; Implementation of some core Data Integration Studio Jobs in order to team post roll-out; Prototypes and demonstrability of functionalities of SAS OLAP, Web Report Studio, Portal and Stored Procedures. Methodologies: Data Warehousing; Kimball; Rapid Warehousing Methodology; SEP 2010 to FEB 2011 – BI Senior Consultant – GMV Portugal - LISBON, reporting to Head of “Transport and Mobility” and Member of the Board

BI Consultant for European Maritime Safety Agency DataWarehouse and Geographic Information System Project. Requirements gathering and design corporate data model to support a centralised and unified view of EMSA ships data sourced in several systems and ah-hoc files from Business Analysts;

Build ETL jobs using Oracle PL/SQL;

Build reports using Business Objects web intelligence; Assist Project Director.

Methodologies: Data Warehousing; Kimball; PMP/PMI; SEP 2009 to AUG 2010 – BI Senior Consultant – Sharevalue - LISBON, reporting to CEO/Owner Coordinated several Performance Management implementations and implemented enhancements to the product in the Reporting side as well as participated in an internet Sharepoint project.

Advisoring and Performance Management Workshops with C Level users; Project Management and Requirements Gathering;

Implementations in Sharepoint (focused on BI) and Microsoft SSIS, SSAS, SSRS and T-SQL; Integration of all Performance Management (BSC) and Performance Evaluation data (HR) creating the corporate HR view of employee. Methodologies: Data Warehousing; Kimball; Performance Management; PMI; MAY 2005 to SEP 2008 – Senior Consultant – SAS Portugal - LISBON, reporting to Professional Services Manager Started the involvement as Senior Consultant for Professional Services Department, participating in several DW/BI and Budgeting and Control

(SAS Financial Management Solution) projects. In 2008 was promoted to Technical Account Manager in which role continued to develop SAS Consultancy but below Customer Care and Quality Improvement Department. Tasks also included coordination and mentoring of Consulting teams. As a SAS Consultant also provided SAS training courses to clients. SAS implementations including Master Data Management, from design and, following Kimball, to integrate all the data in a simple, unified, holistic and sometimes centralised view of corporate data. Project and Team Management;

Requirements Gathering;

SAS 9 technology mentoring;

SAS 9 technology Workshops;

Steering committees meetings coordination and presentations – at C level; Assist the creation of a Business Intelligence Competency Center for an Insurance company; SAS courses monitor in Data Integration Studio, Data Flux and Macros Methodologies: Data Warehousing; Kimball; Performance Management; PMI; BICC; NOV 2004 to MAR 2005 – Business Intelligence Consultant – Novabase Portugal - LISBON, reporting to Project Manager Requirements gathering and mapping to PL/SQL procedures in use at the Bank; Dw and reports implementations using SQL Server and Microstrategy. Methodologies: Data Warehousing; Kimball;

FEB 2004 to AUG 2004 – SAS Senior Consultant – Morgan Stanley NY through GaleonSoftware - MADRID, reporting to Morgan Stanley Project Manager and Galeonsoftware CEO/Owner Worked as SAS Consultant and team leader (Spanish team) in Morgan Stanley Global Anti-Money Laundering project. Team leadership

SAS implementations – BASE, Macro, STAT, Arrays, WA, Intranet, Portal, Enterprise Guide. Methodologies: Data Warehousing; Kimball; PMI;; Anti Money Laundering; OCT 2002 to SEP 2003 – Teacher (Assistant) – ESCE / Setubal Politehnical Institute - SETUBAL, reporting to each Class Owner Worked as teacher for the following classes: Information Systems Audit; Organizational Multimédia; Computers and Operating Systems Architecture; Programming Languages; and Informatics. OCT 1998 to SEP 2002 – SAS Senior Consultant – SAS Portugal - LISBON, reporting to Pre-Sales Manager, DM/CRM BU Manager and Professional Services Manager

Engaged SAS as Technical Consultant and assumed several roles during the four years of collaboration, including SAS Consultant, Data Mining Consultant and CRM Solution Designer and Architect. In common the fact that in each project he participated he usually was responsible by the solution delivered, i.e., doing the pre-sales, design it and coordinate implementation business and technically.

Pre-Sales

SAS Projects from design to implementation including reporting side SAS Workshops

Project Management

SAS courses monitor including WA, BASE, STAT, Macros, SQL, DataFlux, Enterprise Miner and Data Mining theories, Enterprise Reporter.

Methodologies: Data Warehousing; Kimball; Data Mining – SEMMA; PMI; MAR 1998 to AUG 1998 – BI and Data Mining Trainee – NCubo (Now Altran Group) - LISBON, reporting to CEO/Owner University training post where developed data mining and OLAP projects. Methodologies: Data Warehousing; Kimball; Performance Management; PMI; Certifications

SAS Platform Administration for SAS 9

SAS Certified Data Integration Developer for SAS 9 SAS Advanced Programming Exam for SAS 9

SAS Base Programming for SAS 9

ITIL v3 Foundation

Prince2 Practitioner – Project Management

Prince2 Foundation– Project Management

SCRUM Master

70-448 – Microsoft SQL-Server 2008 – Business Intelligence Development and Maintenance; Professional Training

2022 – PowerBI, PrimeIT, 32 hours

2015 – SAS Administration, SAS London, 32 hours

2010 - Project Management, GMV – 24 hours

2010 - Software Engineering Course, GMV – 16 hours 2010 - Business Objects Web Intelligence e Designer, GTBC – 8 hours 2007 – SAS Financial Management Solution 4.4 training for Consultants – 24 hours; 2006 - SAS xIS Training (Insurance, Banking and Telco Intelligence Solutions), Heidelberg – 24 hours; 2004 – Query and Reporting using SAS Enterprise Guide, SAS New York – 8 hours; 2002 - Complete Project Management – Instituto de Formação Prisma – 35 hours; 2002 - Advanced Project Management – SAS/EMEA, Heidelberg, Germany – 28 hours; 2002 - SAS/Campaign Management Component training for consultants – SASUK, Marlow, UK – 35 hours; 2001 - Introduction to Project Management – SAS/EMEA, Heidelberg, Germany – 28 hours; 2001 - SAS/Campaign Management Component training for pre-sales consultants – SAS/EMEA HQ, Heidelberg, Germany – 28 hours; 2000 - Warehouse Architecture, including MDM – SAS/EMEA, Heidelberg, Germany – 21 hours; 2000 - CRM Workgroup - SAS/EMEA, Heidelberg, Germany; 2000 - Churn Management - SAS/EMEA, Heidelberg, Germany – 21 hours; 1999 - Workgroup Reporting Solutions – SASD, Copenhagen, Denmark; 1999 - SAS Enterprise Reporter, Paris, France – 14 hours; Main Conferences Attended

2015 – SAS Forum Switzerland

2014 - Big Data and Security in Europe Challenges and Opportunities, Brussels, 21st January 2014 2013 – Int. Niels Bohr Conference, “An Open World – Science, Technology and Society”), Copenhagen, 4-6 Dec 2013 – PRINCE2 FORUM 2013 (third edition) - Implementing PRINCE2, Brussels, 28th November 2013 – element61 SAP Business Analytics Day 2013, Brussels, 28th November 2013 – SAS Analytics 2013 Conference with Ralph Kimball, Brussels, 12th November 2013 2013 – SAS Analytics 2013 Conference, London, 19 & 20 of June 2011 – SAP Business Analytics Forum, Lisbon

2007 – SAS Forum Portugal

2006 – SAS Forum Portugal

2005 – SAS Forum Portugal

2005 – SAS User Group International (SUGI), Lisbon, Portugal 2002 – SAS Europe User Group International (SEUGI), Florence, Italy 2001 – SAS Forum Portugal

2001 – CRM and Data Mining workshop with Gordon Lignoff, ISG, Lisbon, Portugal 2001 – SAS Europe User Group International (SEUGI), Paris, France 2000 – SAS Forum Portugal

2000 – Business Intelligence event with Bill Inmon, Novabase, Lisbon, Portugal 2000 – SAS Europe User Group International (SEUGI), Dublin, Ireland 1999 – SAS Forum Portugal

1998 – SAS Forum Portugal

DOMAINS OF KNOWLEDGE / INTEREST

DW Architecture including Master Data Management and creation of central repositories of data that integrates all relevant data on organization, standardize it and unifies it through a central repository which serves as Master Data Source for other applications. Data Quality using BASE SAS, SQL or other tools like DataFlux. Data Mining, SAS STAT and R.

SAS TECHNOLOGY:

SAS OLAP CUBE STUDIO, SAS Information Map Studio, SAS Portal and SAS Web Report Studio SAS Stored Process (owns certification)

SAS Management Console (owns certification)

Data Integration Studio and DataFlux (owns certification) SAS Macro, BASE, STAT, SQL, arrays (owns certification - advanced) SAS Enterprise Miner and SAS Enterprise Reporter and Enterprise Guide SAP

SAP Material Management, including orders and billing management SAP/BW for queries and reporting

Business Objects XI R3 web intelligence

Business Objects Xcelcius

Business Objects Designer

MICROSOFT SQL SERVER 2005 – 2008 - 2012

Microsoft PowerBI

Master VBA and Microsoft Excel

Microsoft SQL Server Data base (owns certification) SSIS, SSAS, SSRS and T-SQL (owns certification)

Microsoft Sharepoint and BI Add ins for Sharepoint 2008 DATABASES

Oracle 11i; SQL Server; My Sql; Postgres

DOMAINS OF INTEREST

INFORMATION MANAGEMENT

DW ARCHITECTURES AND PERFORMANCE OPTIMIZATION

BIG DATA

Statistics and Machine learning

Contact this candidate