- Strong knowledge of SQL, PL/SQL, PostgreSQL , Microsoft SQL Server- Experience in constructing DWH both 3NF and Star / Snowflake (cleansing and normalizing source data, transformation and loading with PL/SQL procedures)- Experience in BI Tools: MS Power BI- Development of multifunctional dashboards using various data sources, editing dashboards and issuing rights to view and edit using MS Power BI- Novice skills in database migrations using AWS- Experience in test documents creation (test cases, checklists, test strategy)- Novice skills in test automation using Python- High responsibility and reliability, good team relationshipsResponsibilities: • Working with business requirements and their clarification• DB modeling (database model for layer 3 Normal Form, "Star" and Data Marts)• Building hybrid dwh (by Inmon and Kimball)• Dashboard and ETL Result testing and verification (Manual and automation testing , preparing checklists, bug reports, data mapping, data profiling, test strategy)• Developing Reports and Dashboards in Power BI Desktop• Working with flat files (.csv, .xlsx, .txt etc.)• Creating test documentation (checklist, test strategy etc.)• SQL and PL/pgSQL query optimization• Data Quality, Data Completeness, Data TransformationTools and Technologies: PostgreSQL, PL/SQL, Python, Git, AWS, Power BI, Tableau, DBeaver, Jira, PyCharm, GitHub, BitBucket

- Preparing of budget documentation- Correction of estimates, their transfer to the customer and their coordination- Work with project documentation- Price monitoring- Сooperation with related departments

Skills:- Creating of conceptual and logic models - Working with relational databases (MS SQL Server, MySQL)- Working with ETL tool (SSIS)- Working with data visualization tools (Power BI, Tableau)Achievements:- Project implementation during which:- Were created conceptual and logic models of database in diagrams.net- Was created physical database in Microsoft SQL Server- Additional data from different sources(Excel) was added to MS SQL Server via SSIS- Were built two dashboards based on the created database: first in PowerBI, second in Tableau