This is Eric's portfolio

Hi there! Thanks for checking out my work!
You can learn more about me and take a look at some of my past projects below.

Scalable NoSQL Database Design for E-Commerce

• Designed and implemented a scalable NoSQL database using Amazon DynamoDB.
• Optimized data modeling with denormalization and sharding for performance and scalability.
• Automated database setup and data ingestion using Python (Boto3).
• Published project code and documentation on GitHub.

IBM Data Engineering Capstone Project

• Designed and implemented MySQL and MongoDB data platforms.
• Automated MySQL-to-PostgreSQL data transfers.
• Implemented a data warehouse using a star schema and performed various queries.
• Loaded data into IBM Cognos Analytics and created dashboards.
• Implemented an Airflow pipeline for web server log analysis.
• Applied PySpark for search term analysis and integrated a sales forecasting model.

YouTube Channel Sentiment Analysis Tool

• End-to-end data processing solution that encompasses data retrieval, analysis, containerization for scalability, and dashboard development.
• Designed and implemented a data pipeline to fetch comments from the YouTube API, process and analyze their sentiment using TextBlob.
• This project utilized Python, the YouTube API, Streamlit, Flask and Docker.

Influenza Syndrome Data ETL

• Created a script that utilizes Python to consume an API for notifications of influenza-like illness in the state of Paraná, Brazil and to insert the data into a local PostgreSQL database.
• The ETL pipeline retrieves the data in JSON format, formats it and loads it into a local PostgreSQL database.

Flask CRUD API + Docker

• Developed a Flask-based API for patient data management, supporting CRUD operations and interacting with a local PostgreSQL database.
• Employed Docker containerization to ensure consistent and scalable deployment of the Flask application.

About me

I'm Eric Schmidt, a Data Engineer based in Brazil with extensive experience designing and deploying scalable data pipelines and modern data solutions. Currently at Wiley, I lead initiatives that modernize financial data systems and drive actionable business insights through innovative cloud-based architectures.

My career spans diverse environments—from driving pipeline development at Wiley, a global publishing powerhouse with a billion-dollar revenue and an international team focused on financial data, to thriving in the fast-paced innovation of Brazil’s EdTech startup, Fluency Academy, and further honing my expertise at major financial institutions like Bradesco and fintech software innovators such as Softpar and Ingeteam.

Grounded by a bachelor's degree in Electronics Engineering, I combine a strong technical foundation with hands-on expertise in scalable pipeline design, OLAP data modeling, and event-streaming architectures. I work proficiently with tools such as AWS Glue, Python, Snowflake, and Airflow, among others.

Programming & Scripting: Python, SQL, Bash.
Databases: Snowflake, Oracle, PostgreSQL, MySQL, MongoDB, and SQLite.
Tools: AWS (Glue, Lambda, S3), Airflow, Docker, Kubernetes, Linux, pytest, Git, and WSL2.

Fluent in Portuguese and English, with intermediate proficiency in German, I thrive in international, cross-functional teams where effective communication is key to success.

Let's connect