Nicolau Pais

Data Engineer Consultant at BiLD Analytics
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Portugal, PT

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 1 ratings
  • (1)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

Jorge Granja

Nicolau is an excellent person and outstanding professional. He has strong expertise developing IT solutions. He is very focused and energetic in everything he does, resulting in great overall quality on his work. Nicolau is also pro-active and has a very high set of technical skills relating to Data Integration and Business Intelligence. One of the best aspects is the ability to learn a new skill or tool when needed. For all those reasons I recommend him to any IT Project/Company.

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • United Kingdom
    • IT Services and IT Consulting
    • 200 - 300 Employee
    • Data Engineer Consultant
      • May 2019 - Present

      At Bild Analytics we believe that the power of data can positively impact our customers and employees. We are a data driven organization with a young and passionate team. Website: https://bildanalytics.ai/ At Bild Analytics we believe that the power of data can positively impact our customers and employees. We are a data driven organization with a young and passionate team. Website: https://bildanalytics.ai/

    • Portugal
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Azure Data Engineer and Co Founder @ LogicalJupiter LDA
      • Mar 2019 - Present

      We provide outsourcing, staffing, consulting and workforce solutions across Europe, USA and India within areas of IT, healthcare, life sciences. Logical Jupiter Believes in Integrity and Inclusion through our Diverse Workforce. Contact us now ✉ info@logicaljupiter.eu www.logicaljupiter.eu www.logicaljupiter.com www.logicaljupiter.in We provide outsourcing, staffing, consulting and workforce solutions across Europe, USA and India within areas of IT, healthcare, life sciences. Logical Jupiter Believes in Integrity and Inclusion through our Diverse Workforce. Contact us now ✉ info@logicaljupiter.eu www.logicaljupiter.eu www.logicaljupiter.com www.logicaljupiter.in

    • Portugal
    • Utilities
    • 700 & Above Employee
    • Data Engineer Consultant
      • Jul 2020 - Oct 2022

      EDP ​​is the largest energy distribution and production company in Portugal. With the expansion of Renewable Energies, the amount of data has increased immensely, and as such the migration to Big Data tools was planned. The intention is to change the entire data ingestion framework for cloud services like Azure, AWS. EDP ​​is the largest energy distribution and production company in Portugal. With the expansion of Renewable Energies, the amount of data has increased immensely, and as such the migration to Big Data tools was planned. The intention is to change the entire data ingestion framework for cloud services like Azure, AWS.

    • Denmark
    • Food and Beverage Services
    • 700 & Above Employee
    • Data Analyst
      • May 2019 - Jul 2020

      Project: PVM Variance Tracker Carlsberg Group started their Data Analytics practice in Lisbon with the goal of receiving data from the PAN European (10+) countries where the business operates. A Cloud-based solution using Microsoft Azure was implemented. I've been Collaborating with different departments and working with several Stakeholders in the organization. Performed Activities: ▪ Created ETL scripts and Pipelines in Azure Databricks (ensuring homogeneous blend to… Show more Project: PVM Variance Tracker Carlsberg Group started their Data Analytics practice in Lisbon with the goal of receiving data from the PAN European (10+) countries where the business operates. A Cloud-based solution using Microsoft Azure was implemented. I've been Collaborating with different departments and working with several Stakeholders in the organization. Performed Activities: ▪ Created ETL scripts and Pipelines in Azure Databricks (ensuring homogeneous blend to existing environments) to standardize and categorize the incoming data, in order to calculate the PVM. ▪ Used Azure DataFactory v2 to orchestrate all the PySpark and Scala scripts with parameters, to allow parallel runs and maximize the performance and get statistics about the flow. ▪ Automating existing and new Interfaces. ▪ Help users troubleshooting on data loading issues, and created error handling mechanisms. ▪ Suggested Ideas for enhancements. ▪ MS SQL Server 2019, MS Cosmos DB were the primary databases used to store all the data. ▪ SCRUM was the project management methodology. ▪ Release management was performed using Azure DevOps. ▪ User Identity Management, roles and permissions in MS SQL Server ▪ Metadata Management Tools and Techniques: MS Azure, PySpark, MS SQL Server 2019, MS Cosmos DB, SCRUM, MS Azure DevOps, MobXtreme Show less Project: PVM Variance Tracker Carlsberg Group started their Data Analytics practice in Lisbon with the goal of receiving data from the PAN European (10+) countries where the business operates. A Cloud-based solution using Microsoft Azure was implemented. I've been Collaborating with different departments and working with several Stakeholders in the organization. Performed Activities: ▪ Created ETL scripts and Pipelines in Azure Databricks (ensuring homogeneous blend to… Show more Project: PVM Variance Tracker Carlsberg Group started their Data Analytics practice in Lisbon with the goal of receiving data from the PAN European (10+) countries where the business operates. A Cloud-based solution using Microsoft Azure was implemented. I've been Collaborating with different departments and working with several Stakeholders in the organization. Performed Activities: ▪ Created ETL scripts and Pipelines in Azure Databricks (ensuring homogeneous blend to existing environments) to standardize and categorize the incoming data, in order to calculate the PVM. ▪ Used Azure DataFactory v2 to orchestrate all the PySpark and Scala scripts with parameters, to allow parallel runs and maximize the performance and get statistics about the flow. ▪ Automating existing and new Interfaces. ▪ Help users troubleshooting on data loading issues, and created error handling mechanisms. ▪ Suggested Ideas for enhancements. ▪ MS SQL Server 2019, MS Cosmos DB were the primary databases used to store all the data. ▪ SCRUM was the project management methodology. ▪ Release management was performed using Azure DevOps. ▪ User Identity Management, roles and permissions in MS SQL Server ▪ Metadata Management Tools and Techniques: MS Azure, PySpark, MS SQL Server 2019, MS Cosmos DB, SCRUM, MS Azure DevOps, MobXtreme Show less

    • United Kingdom
    • Telecommunications
    • 700 & Above Employee
    • ETL Developer
      • Mar 2018 - Apr 2019

      Project: LITE (LowCost Incentive Technology Enterprise), Cairo - Egypt & Budapest - Hungary LITE Project had a multi-country dimension within Vodafone Group. The Commission Business project implemented using different approaches in each country to provide a unified view. Extensive travel was necessary as a part of the implementation process. Performed Activities: ▪ Designed and implemented BI and Data Integration solution. ▪ Led a team of eight persons in two connected… Show more Project: LITE (LowCost Incentive Technology Enterprise), Cairo - Egypt & Budapest - Hungary LITE Project had a multi-country dimension within Vodafone Group. The Commission Business project implemented using different approaches in each country to provide a unified view. Extensive travel was necessary as a part of the implementation process. Performed Activities: ▪ Designed and implemented BI and Data Integration solution. ▪ Led a team of eight persons in two connected projects namely, Commissions Automation and Commissions Reporting. ▪ Coached junior consultants and partnered with staff members. ▪ Developed Validation and Calculation Workflows using Alteryx Designer for new and existing Commission schemes. ▪ Improved and maintained the Processing Hierarchy for executing Workflows within the same Primary Channel, Distribution Channel, and Portfolio. ▪ Prepared documentation to demonstrate how data flows through all the stages. ▪ Monitored and audited SQL changes for every release and hotfix. Tools and Techniques: Putty, FileZilla, VM Ware Player, MS SQL Server 2017, Xshell 4, MS Visio, GIT, OwnCloud, Cygwin, Alteryx Designer. Show less Project: LITE (LowCost Incentive Technology Enterprise), Cairo - Egypt & Budapest - Hungary LITE Project had a multi-country dimension within Vodafone Group. The Commission Business project implemented using different approaches in each country to provide a unified view. Extensive travel was necessary as a part of the implementation process. Performed Activities: ▪ Designed and implemented BI and Data Integration solution. ▪ Led a team of eight persons in two connected… Show more Project: LITE (LowCost Incentive Technology Enterprise), Cairo - Egypt & Budapest - Hungary LITE Project had a multi-country dimension within Vodafone Group. The Commission Business project implemented using different approaches in each country to provide a unified view. Extensive travel was necessary as a part of the implementation process. Performed Activities: ▪ Designed and implemented BI and Data Integration solution. ▪ Led a team of eight persons in two connected projects namely, Commissions Automation and Commissions Reporting. ▪ Coached junior consultants and partnered with staff members. ▪ Developed Validation and Calculation Workflows using Alteryx Designer for new and existing Commission schemes. ▪ Improved and maintained the Processing Hierarchy for executing Workflows within the same Primary Channel, Distribution Channel, and Portfolio. ▪ Prepared documentation to demonstrate how data flows through all the stages. ▪ Monitored and audited SQL changes for every release and hotfix. Tools and Techniques: Putty, FileZilla, VM Ware Player, MS SQL Server 2017, Xshell 4, MS Visio, GIT, OwnCloud, Cygwin, Alteryx Designer. Show less

    • Portugal
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • BI Consultant
      • Mar 2018 - Feb 2019

    • Portugal
    • IT Services and IT Consulting
    • 100 - 200 Employee
    • BI Consultant
      • Sep 2017 - Mar 2018

      Project: COOP – Cooperative Alliance of Kenya & Entel – Chile and Peru Performed Activities: ▪ Performed setup and configuration of the DB and BI tools. ▪ Performed performance tuning activities in both back-end scripts and front-end reports ▪ Defined roll-out process and support architecture ▪ Analyzed different source system data and developed Informatica mappings to load them into data warehouse. ▪ Developed PL/SQL packages and procedures to avoid extensive… Show more Project: COOP – Cooperative Alliance of Kenya & Entel – Chile and Peru Performed Activities: ▪ Performed setup and configuration of the DB and BI tools. ▪ Performed performance tuning activities in both back-end scripts and front-end reports ▪ Defined roll-out process and support architecture ▪ Analyzed different source system data and developed Informatica mappings to load them into data warehouse. ▪ Developed PL/SQL packages and procedures to avoid extensive computation during ETL loads. ▪ Developed a custom Java plugin to capture and share overall process statistics and share details to ▪ Application Owner via email at the end of the entire process consisting of some predefined metric. ▪ Project management was performed using Jira and weekly status meetings were organized to discuss ongoing progress and upcoming activities based on priorities. ▪ Developed file watcher using Unix shell scripts to ensure on-time initiation of the batch process. Tools and Techniques: Putty, FileZilla, VM Ware Player, Oracle SQL Developer, TOAD, MS Excel, MS PowerPoint, GIT, OwnCloud, Cygwin, JIRA, Informatica PowerCenter, OBIEE, Java Show less Project: COOP – Cooperative Alliance of Kenya & Entel – Chile and Peru Performed Activities: ▪ Performed setup and configuration of the DB and BI tools. ▪ Performed performance tuning activities in both back-end scripts and front-end reports ▪ Defined roll-out process and support architecture ▪ Analyzed different source system data and developed Informatica mappings to load them into data warehouse. ▪ Developed PL/SQL packages and procedures to avoid extensive… Show more Project: COOP – Cooperative Alliance of Kenya & Entel – Chile and Peru Performed Activities: ▪ Performed setup and configuration of the DB and BI tools. ▪ Performed performance tuning activities in both back-end scripts and front-end reports ▪ Defined roll-out process and support architecture ▪ Analyzed different source system data and developed Informatica mappings to load them into data warehouse. ▪ Developed PL/SQL packages and procedures to avoid extensive computation during ETL loads. ▪ Developed a custom Java plugin to capture and share overall process statistics and share details to ▪ Application Owner via email at the end of the entire process consisting of some predefined metric. ▪ Project management was performed using Jira and weekly status meetings were organized to discuss ongoing progress and upcoming activities based on priorities. ▪ Developed file watcher using Unix shell scripts to ensure on-time initiation of the batch process. Tools and Techniques: Putty, FileZilla, VM Ware Player, Oracle SQL Developer, TOAD, MS Excel, MS PowerPoint, GIT, OwnCloud, Cygwin, JIRA, Informatica PowerCenter, OBIEE, Java Show less

    • Database Developer and System Manager
      • 2014 - 2017

      Project: Pokemon Map in Real Time Performed Activities: As a Back-End Developer, developed a custom engine using Python, Java and Postgre SQL DB, aimed at providing locations on a map where pokemon game related artifacts could be found in the vicinity within Portugal. Responsible for the database maintenance and data integrity, ensuring industry standard coding guidelines related to database development. As a Front-End Developer, developed and published a website to… Show more Project: Pokemon Map in Real Time Performed Activities: As a Back-End Developer, developed a custom engine using Python, Java and Postgre SQL DB, aimed at providing locations on a map where pokemon game related artifacts could be found in the vicinity within Portugal. Responsible for the database maintenance and data integrity, ensuring industry standard coding guidelines related to database development. As a Front-End Developer, developed and published a website to provide real-time accurate data access to Pokemon gamers. Developed web service using Node.js to ensure seamless communication between website and database via REST API. Implemented user management authentication system and captured personal statistics of all gamers to provide a custom user experience. Tools and Techniques: PostgreSQL, Python, REST API, Node.js, Java, Unix, VPS, Putty, Bootstrap, Flask

    • Information Technology System Network Administrator
      • 2012 - 2014

      Project: LAN Party game server configuration Performed Activities: As an IT System Administrator, installed, configured, and provided support to Local Area Networks (LAN). Maintained network hardware and associated firmware. Performed network monitoring to ensure high availability and defined scheduled jobs for network maintenance and software upgrades. As a Business Analyst collected all the business requirements and developed a business intelligence solution for a… Show more Project: LAN Party game server configuration Performed Activities: As an IT System Administrator, installed, configured, and provided support to Local Area Networks (LAN). Maintained network hardware and associated firmware. Performed network monitoring to ensure high availability and defined scheduled jobs for network maintenance and software upgrades. As a Business Analyst collected all the business requirements and developed a business intelligence solution for a gaming community working with SQL, unix servers and xml programming. Categorized individual gamer interests to provide more suggestions on purchases of prospective games based on the statistics. Implemented an a data capture mechanism using JAVA and MS Excel. Objects maintenance with SQL scripts (create, alter, drop tables, tablespaces, indexes). Tools and Techniques: ETL, SQL, Unix, Python, Git, VPS, Putty, WinSCP, JAVA, MS Excel

    • Independent IT Developer
      • 2008 - 2012

      - Developed a business intellegence solution for a gaming community working with PL/SQL unix servers and xml programming. - Collaborate with cross-functional teams to design solutions and ensure that data entry, retrieval, change and delete functions meet the better aproaches - Strong analytical skills with high attention to detail and accuracy - Experience implementing process improvements in ETL applications - Oracle objects maintenance with SQL scripts (create, alter, drop… Show more - Developed a business intellegence solution for a gaming community working with PL/SQL unix servers and xml programming. - Collaborate with cross-functional teams to design solutions and ensure that data entry, retrieval, change and delete functions meet the better aproaches - Strong analytical skills with high attention to detail and accuracy - Experience implementing process improvements in ETL applications - Oracle objects maintenance with SQL scripts (create, alter, drop tables, tablespaces, indexes) - XML and bash Scripting

Community

You need to have a working account to view this content. Click here to join now