- Designed and implemented a data warehouse model, incorporating a hybrid approach.- Leveraged PostgreSQL and PL/pgSQL to create and manage complex functions and procedures, enhancing the performance and reliability of the data warehouse. - Developing ERDs (Star/Snowflake) using Lucidchart for various domains such as recruitment, food delivery, and healthcare.- Practicing in key topics of PostgreSQL such as creating physical tables, setting security permissions, creating roles, and granting/revoking permissions, as well as performing advanced analytics.- Maintaining the database structure by creating triggers, custom functions, and views to ensure data consistency and integrity.- Analyzing the database and identifying valuable business metrics (retention and conversion rates, ARPU), creating SQL queries for them, and visualizing the results in Excel and Power BI. - Developing business reports to highlight the benefits of implementing a database and to specify any problems with data storage.- Performing step-by-step database modeling from conceptual to infological and physical models to ensure optimal database design.- Utilized Power BI to create interactive and role-specific reports with RLS settings, leveraging DAX for advanced data modeling and calculation.- Leveraged AWS Glue for ETL jobs, to transform and load data into the data warehouse, and Redshift for storing and querying data.- Developed data pipelines in AWS, using a combination of S3, Lambda, and Step Functions, providing robust, serverless data engineering solutions.- Leveraged knowledge in Selenium and TestRail to automate and manage the testing process, providing frequent reports on data quality.- Implemented data warehouse testing strategies to ensure the correctness of ETL processes, data integrity, data accuracy, and performance, creating TTR (test result reports).

- receiving, cleaning, and preparing data from client using Python to help data scientists build credit scoring model that evaluates the ability of a potential borrower to repay the loan;- building out the data and reporting infrastructure from the ground up using Tableau and SQL to provide real-time insights into the product, marketing funnels and business KPIs for online service;- analysing 100% of purchase funnel analytics, customer churns, retention rates, lifetime valuations, and channel performances in order to help the loss-making company be profitable;- conducting a regression analysis and determined the correlation between price and other parameters of real estate properties to build automated system for anomalies and fraud detection;- utilising Microsoft Excel to create from scratch and visualize an annual budget report to develop an improved company financial strategy;- using Python(Pandas) and Google Sheets evaluated and visualized current trends on the public catering market for investors and provided recommendations on opening a brand new restaurant chain;- using SQLite and Tableau determined and analyzed current level of NPS for telecom company.