Guilherme Pereira

Data Analyst - Environmental Engineer - AI/ML

Enter Portfolio
Guilherme Pereira

Guilherme Pereira

Caltech '23 AI/ML student.

Nova School of Science and Technology '21, M. Environmental Engineering.

I have completed a Master's in Water and Wastewater treatment but my present passions are Data, AI/Machine Learning and Computer Science.
My interests include data analysis,data visualization, artificial intelligence, machine learning and computer vision.

Completed a Post Graduate in Artificial Intelligence and Machine Learning.

I’m currently working as a Data Analyst at AQUASIS, a pioneer in Portugal specializing in the development and implementation of innovative technological solutions to address complex engineering challenges. In my role, I am responsible for updating and maintaining the application database, ensuring seamless connections between servers and databases, and troubleshooting any issues that arise. I’m also leading a project to migrate a report from QlikView to Power BI, where I am building the entire ETL pipeline to streamline data processing and enhance reporting capabilities.

Caltech

  • Post Graduate Program in AI and Machine Learning

IronHack

  • Data Analytics Bootcamp

NOVA School of Science and Technology

  • Master's in Water and Wastewater Engineering
  • Bachelor's in Environmental Engineering

Skills

Below are some of my skills, and I'm perpetually seeking opportunities to expand my knowledge.

Computer Vision, OpenCV/OpenGL

I have applied my knowledge to create systems that seamlessly combine OpenCV and Tesseract OCR. This integration enables the comprehensive detection, recognition, and extraction of car license plate numbers from images or video frames. I am adept at handling challenges such as varying lighting conditions, plate orientations, and background complexities, ensuring the robustness of the implemented solution. I've done a project Car Plate detection, utilizing OpenCV and Tesseract OCR.

Machine Learning, Artificial Intelligence

I successfully developed and implemented a diverse range of projects, showcasing proficiency in machine learning and predictive analytics. Two notable projects include Water Potability App, Sales Prediction Model. Throughout these projects, I showcased a holistic understanding of the end-to-end data science process, from data exploration and preprocessing to model development, deployment, and user interaction. My ability to effectively translate complex machine learning concepts into practical and impactful applications reflects my commitment to delivering data-driven solutions with tangible business value.

Tableau, Power BI

I have demonstrated proficiency in Power BI and Tableau, focusing on creating impactful dashboards that convey insightful information. I successfully developed several dashboards, each addressing distinct domains. Some of the projects developed are the Melbourne Real Estate Dashboard, Lisbon Parking, London Crime. In my role at BNP Paribas , I played a crucial part in the development of a Dealogic dashboard using Power BI, focused on providing a comprehensive overview of bank rankings based on deals made.

Python

I bring experience in leveraging Python for diverse applications, including data analysis, machine learning, and web scraping. My key competencies include proficient in using Python's data manipulation libraries such as Pandas and NumPy to clean, transform, and analyze large datasets efficiently. Web scraping using Python frameworks such as BeautifulSoup, I possess comprehensive knowledge of both supervised and unsupervised learning algorithms.

HTML, CSS

In summary, my experience in web design spans the creation of this website/portfolio , as well the design of a user interface for the Water Potability App. My proficiency extends to the personalized customization of websites through the modification of HTML and CSS code. And understanding the logic behind the construction of websites using HTML and CSS, fundamental to web development.

C++

During my internship at Azorean Aquatic Technologies I worked with Arduino that uses a variant of the C++ programming language. The code is written in C++ with an addition of special methods and functions. During one year I worked in the project Underwater Microcontroller, writing C++ code to interface with the Arduino microcontroller and attached sensors in order to collect data.

Microsoft Excel

I possess advanced proficiency in Microsoft Excel, with a focus on leveraging its features for data analysis, dashboard creation, and ensuring data quality.I bring extensive expertise in the development and implementation of Excel-based data control files for corporate investment banking at BNP Paribas, a prominent French bank.

Git

Proficient in using version control systems like Git for collaborative development, enabling efficient code management and tracking of project iterations.In summary, my bootcamp experience equipped me with a solid foundation in using Git commands for version control. My GitHub profile stands as a testament to my commitment to collaborative development, effective project management, and adherence to Git best practices.

SQL

Completion of the MySQL Bootcamp on Udemy has equipped me with a strong foundation in SQL and relational database management. This knowledge is being actively applied in the development of a web app, emphasizing the practical utilization of skills gained during the course.

Portfolio

Personal Projects

Here you can observe a selection of the projects I have completed.

During my leisure hours, I persist in developing personal projects, harboring numerous ideas eagerly awaiting manifestation.

To see more of my projects...

Visit My GitHub  

Papers


Timeline

A short summary of my work experience and education.

~