João Pedro Santos
Business Intelligence Consultant at BI4ALL- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Inglês Limited working proficiency
-
Espanhol Limited working proficiency
-
Português Native or bilingual proficiency
Topline Score
Bio
Experience
-
BI4ALL
-
Portugal
-
Information Technology & Services
-
200 - 300 Employee
-
Business Intelligence Consultant
-
Dec 2018 - Present
Projects: - Crédito Agrícola: Manutenção correctiva e evolutiva do Reporte CRC ao Banco de Portugal. Tecnologias: Sql Server, SSIS, SSRS, DevOps - Johnson&Johnson: Desenvolvimento de processos de ETL e integração de diferentes fontes de dados. Tecnologias: Talend, AWS (Redshift, EC2, and S3) Projects: - Crédito Agrícola: Manutenção correctiva e evolutiva do Reporte CRC ao Banco de Portugal. Tecnologias: Sql Server, SSIS, SSRS, DevOps - Johnson&Johnson: Desenvolvimento de processos de ETL e integração de diferentes fontes de dados. Tecnologias: Talend, AWS (Redshift, EC2, and S3)
-
-
-
Multipessoal
-
Portugal
-
Human Resources Services
-
200 - 300 Employee
-
IT Technician
-
May 2017 - Nov 2018
-
-
-
KCS iT
-
Portugal
-
Software Development
-
200 - 300 Employee
-
Consultant
-
Apr 2015 - May 2017
Projects: - ARCTIC - SIBS: > I am DB2 developer in the Data Management Team of the project. > The team is in charge for the Physical Data Model administration. > Migration and Sincronizaction of the data and information coming from the mainframe core system to new ARCTIC system > We use technologies such as DB2, Power Designer, TFS and IBM Change Data Capture - WeDo Technologies: > Conception and development of Revenue Assurance projects, at Telco sector. > The tasks consists, essentially, on processes development to extract, transform and load client’s database information and posterior analysis to help administrators make good decisions. > We use a software suite of WeDo Technologies to develop all the processes, in parallel, also we did consultations and operations to the database using SQL - Caixa Geral de Aposentações (CGA) > Maintenance of procedures, functions and packages that are used by the CGA processes. The function in the team was, mainly, analyse the requests to fix errors or develop new features and test what has been developed. > Migration of MicroStrategy version. My task was to validate the changes in reports and dashboards. Show less
-
-
-
Inforbest Consulting
-
IT Services and IT Consulting
-
1 - 100 Employee
-
BI Consultant
-
Jan 2014 - Apr 2015
Projects: - Portugal-Telecom: > Development of ad-hoc indicators at the BI department. The performed tasks aim to respond to customer requests, using software such as Toad for Oracle, ArcGIS and Informix. - Alcatel-Lucent: > Development of Web and Mobile applications which allow the management of information errors in the Alcatel-Lucent devices, using MicroStrategy Desktop and MicroStrategy Web tools. - Banco Espirito Santo: > Web and Mobile application development for Sales Department, using MicroStrategy Desktop and MicroStrategy Web tool. Show less
-
-
-
WWS - data technologies
-
Portugal
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Consultant
-
Apr 2013 - Sep 2013
Projects: - COSEC: > Forms development to automatization of documents printing, using Oracle Reports and Oracle Forms Projects: - COSEC: > Forms development to automatization of documents printing, using Oracle Reports and Oracle Forms
-
-
-
Portugal Telecom
-
Portugal
-
Telecommunications
-
700 & Above Employee
-
Web and Application Support
-
Oct 2011 - Apr 2013
> Development and take part on the Web projects lifecycle. > Maintaining web servers (Websites, WebServices and WinServices). > Web Applications support in various Clients (Ex .: PT Comunicações and TMN). > Management of requests and incidents via Email and Remedy. > Prevention 24x7 applications and supported sites. > Development and take part on the Web projects lifecycle. > Maintaining web servers (Websites, WebServices and WinServices). > Web Applications support in various Clients (Ex .: PT Comunicações and TMN). > Management of requests and incidents via Email and Remedy. > Prevention 24x7 applications and supported sites.
-
-
Education
-
NOVA IMS Information management school
Master Degree in Information Management, Knowledge Management and Business Intelligence -
Universidade Nova de Lisboa
ISEGI, Educational Institution; Education Management industry -
Escola Universitària de Negocis de Caixa Terrassa