nicolagg.github.io

Nico’s Data Engineering Portfolio

Hello! I’m Nico, a Data Engineer with a passion for transforming raw data into actionable insights. This portfolio provides an overview of my certification and some personal projects that I’ve worked on.

🛠 Personal Projects

1. Uniswap interaction
   Extracting token information and retrieving/storing price data in a database.
2. DexBot
   DexBot is a Telegram bot designed to facilitate cryptocurrency trading on Dexs
3. Backtesting Trading Strategies with Jupyter Notebook

📜 Professional Certificate in Data Engineering

• Institution: Massachusetts Institute of Technology
• Duration: 01.12.2022 - 05.07.2023
• Certification: Certificate

🎓🌟 Course Highlights:

1. Module 7 Project: Building a Model to Predict Housing Prices
2. Module 8 Project: ETL, Analysis, and Visualization
3. Module 12 Final Assignment: Using Various Databases for Containerization
4. Module 13 Final Assignment: Applying CDC to Databases on Different Platforms
5. Module 15 Final Project: Creating a Books Web Application
6. Module 16 Project: Real-Time Bus Tracking Web Application with Data Analysis
7. Module 17 Final Assignment: Performing ETL Using NiFi
8. Module 18 Final Assignment 18.1: Writing a Java Program to Access the Hadoop Database
9. Module 19 Final Assignment 19.1: Processing Big Data with Spark and Airflow
10. Module 23 Project: Scraping to Data Visualization: A Dockerized Airflow Data Pipeline
11. Module 24
    • Project 24.1: Streaming Live Data to ThingsBoard
    • Project 24.2: Analyzing Live Streaming Data Using ThingsBoard
    • Project 24.3: Constructing a Web Server Using Kafka

Skills Acquired:

Data Processing & Engineering

• ETL (Extract, Transform, Load) processes
• Containerization of databases
• Real-time data streaming and processing
• Data pipeline construction

Databases & Storage

• SQL: Querying and database design
• Database design and management
• Data warehousing

Programming & Scripting

• Python (specifically for data manipulation and ML applications)

Tools & Frameworks

• NiFi for ETL tasks
• Spark for big data processing
• Airflow for data workflow management

Other

• Parallel computing with Pandas, NumPy, and DASK
• Web Sockets for streaming data

📫 Contact Me

Feel free to reach out to me for collaboration, questions, or just a chat!

• LinkedIn: Nicolas Lagger

---

👨‍💻 Thank you for visiting my portfolio.