Artur Vysotskiy

Participated in the project as a system analyst for IATA (The International Air Transport Association) were the main goal was to migrate 140 legacy monolith databases into multiple microservices but within one DWH. Created the source to target mapping and later SQL scripts for migration. Another engagement was with Novartis were I built the data marts and passed it to front-end. Technologies: · Power BI · Tableau · QlikSense · SQL · Hive · Impala · Postgres · Jenkins · Python · Jira

Started on my own the analytical project for McKinsey & Company and converted it into the full development cycle. Created the single source of truth of various insights. Integrated and ingested multiple data sources so the KPIs could be described from 360°. Increased the adoption of analytics by various teams and departments and created like a product solution which had been also implemented in another fields. Technologies: · Power BI · Tableau · Snowflake · SQL · DBT · Git · Azure Data Factory · Splunk

• Business analysis, elicitation, and elaboration of business requirements with Customer; • Data profiling and data quality checking across data layers. Finding of correct data sources and adjusting of existing pipelines; • Data modeling for new metrics / requirements and creating of ETL pipelines based on SQL / Python; • Reverse engineering of legacy systems and their preparation for data migration; • Conducted onsite workshops with the customer and proposed further action plan;

Led the strategy and operational activity of the treasury department within CIS. Developed the FX and Cash Flow strategy for the group of subsidiaries in the region. Analyzed the historical data against financial models and enriched it based on findings. Supervised the group of 5 subordinates. Technologies: · Power BI · Excel · Oracle · Oracle OBI EE Plus · SQL · Confluence · Jira

Participated in audit engagements for the hugest Oil & Gas and natural resources companies. Performed on-site visits and auditing of financial statements based on local accounting policies, IFRS, and US GAAP. · Collected financial data and analyzed trends; · Tested various financial documents and reports for accuracy and compliance; · Proposed financial adjustment to BS, PL, CF statements before sign-off; · Worked with huge volumes of raw data and automated some procedures to speed up the audit.