1. Analyzing tips received by taxis in ChicagoLink: https://github.com/ezulex/mtrendoTaxi/tree/master/chicago_taxiFunctionality: This project is designed to analyze tips received by taxis in Chicago using open data from BigQuery. Specifically, the project focuses on: - Identifying the three taxis that received the most tips in April 2018. - Calculating the percentage change in tips for these taxis by month. - Uploading the results to Google Sheets for easy viewing… Show more 1. Analyzing tips received by taxis in ChicagoLink: https://github.com/ezulex/mtrendoTaxi/tree/master/chicago_taxiFunctionality: This project is designed to analyze tips received by taxis in Chicago using open data from BigQuery. Specifically, the project focuses on: - Identifying the three taxis that received the most tips in April 2018. - Calculating the percentage change in tips for these taxis by month. - Uploading the results to Google Sheets for easy viewing and analysis. Technologies: Pandas, dbt, SQL, BigQuery, dotenv.2. ChatGPT Telegram botLink: https://github.com/ezulex/TinderBoltFunctionality: a Python bot that combines the convenience of Telegram and the power of ChatGPT. You can ask ChatGPT about everything, create an attractive Tinder profile, generate interesting messages for dating, and even chat on your behalf.Technologies: Python, httpx, dotenv, openai, telegram.3. Researching of customer support dataLink: https://github.com/ezulex/freshdeskAnalyticsFunctionality: integration with the support department ticket management system, saving to a database and further processing for hypothesis testing and analytics.Technologies: Python, NumPy, Pandas, matplotlib, SQLite. Show less

- Integrated external data sources via API or from CSV, JSON files in Python (Pandas)- Created and modified views for analysts using DBT (PostrgreSQL, Greenplum, MySQL)- Designed new tables in the database, designed ER diagrams, followed the principle of Data Vault modeling- Wrote SQL queries for ad-hoc tasks (CTE, window functions, query plans, optimizations)- Automated ELT pipelines with DAG (Apache Airflow)- Monitored the load in Grafana- Documented code in… Show more - Integrated external data sources via API or from CSV, JSON files in Python (Pandas)- Created and modified views for analysts using DBT (PostrgreSQL, Greenplum, MySQL)- Designed new tables in the database, designed ER diagrams, followed the principle of Data Vault modeling- Wrote SQL queries for ad-hoc tasks (CTE, window functions, query plans, optimizations)- Automated ELT pipelines with DAG (Apache Airflow)- Monitored the load in Grafana- Documented code in Confluence- Used git for teamwork Show less