Олександр

Alexander Kiliushyk CV
My GitHub: https://github.com/Tr0ub1e
Programming on Python 3, MySQL, C#, SQL Server (T-SQL) (2016-2019),
Vertica

Skills:
• Have practice with Python 3 (2 years)
• Working with DWH – writing ETL procedures, fixing ETL,
investigation due to client’s request (find broken claim, wasted account,
mismatch amount, etc)
• Have worked with OLAP cubes – wrote MDX queries, created a
calculated measures, added a new dimention.
• Have experience with Columnstore databases, SSRS reports (setuping,
building), SSAS, SSIS package, creating multithread load to DWH from
client’s database
• Setted-up ETL process, know how to optimize some queries
• Upper-Intermediate English
• Have practice with programming on C# and MySQL (1 year)
• Know how to prepare and visualize data (Pandas, NumPy,
mathplot/pyplot)
• Know Scrum, Kanban, XP, program lifecycle, software development
methodologies.
• Have experience with parsing and working with data from Web
• Have intermediate knowledge of math
• Have low-level OOP

Contacts:
• [открыть контакты](см. выше в блоке «контактная информация»)
• @Tr0ub1 (Telegram)
• [открыть контакты](см. выше в блоке «контактная информация»)

Companies:
• Eva (Retail domain) – as a Strong-Junior Data Engineer (November 2022
– now)
- Fixing DWH, re-writing stored procedures from T-SQL 2016 to T-SQL 2019
- Compressing databases from 2TB to 500GB
- Changing data schema, compressing & providing optimizations for
Columnstore tables, setted-up partitioning
 - Troubleshooting – found a problem with server’s disks (was a huge queue),
found that SQL Server Instance does not have enough RAM for correct work,
another cases with parallelism, memory grant, etc.
- Creating data load from APIs (Python or via SQL Server)
- Wrote a few “.DLL” on C# for SQL Server (Assembly)
- Fixing a large user’s SQL queries which produce high load for SQL Server
Instance

• MedeAnalytics (healthcare domain) – as a Junior BI Engineer (June 2021
– November 2022)
- Investigating healthcare business logic and providing solutions for
missmatches
- Implementing reports, data logic, etс
- Conversations with US BAs & clients
- Performed OLAP solutions for client's requests with sophisticated logic or
special business requirements
- MDX calculations for measures
- Dimensions with calculated members
- Optimized SQL procedures for client's data warehouse

About me:
I am working as a BI Engineer for a 2 years and I am looking to get a
new experience as a BI / Data Engineer. In my GitHub you can see my pet
projects. If you want send to me test task or project – I can do it. If I meet your
requirements – please send me an answer.