Працював в 6 компаніях 7 років 11 місяців
IT - консалтинг / Послуги / Виробництво устаткування, Банки, Фінансові послуги, IT, Інше
Business Intelligence Analyst Within Billing Department
Parimatch Tech
IT - консалтинг / Послуги / Виробництво устаткування
1 рік 11 місяців
03.2021 - 02.2023
- analyzed key trends in billing transactions
- applied statistical methods to analyze & interpret transactional data
- developed metrics for scenarios and triggers
- calculated and reported financial metrics that reflected profitability and cost margins for payment systems and payment merchants
- applied deviation analysis to project transactions conversion rates behavioural patterns
- monitored transactions conversion rates across 9 regions
- developed reports and dashboards using Power BI and Tableau
- analyzed SQL databases using MySQL and AWS Athena
- set up automated data extraction and connection between databases and Tableau
- automated data extraction with Python
- created business requirements documentation (BRD) for the DevOps team
Internal Auditor
ПроКредит Банк / ProCredit Bank / ProCreditBank
Банки
1 рік 4 місяці
10.2019 - 02.2021
- assessed the effectiveness of a bank's risk management activities, compliance with local state regulations as well as with policies provided by the bank's stakeholders, and its internal control-environment
- analyzed the bank's key performance indicators, took part in the design process of tests on the efficiency of core banking operations
- monitored external and internal audit reports
- designed tests and facilitated control activities on the efficiency of non-banking operations such as marketing, procurement, storing & security, etc
- designed and implemented control procedures according to the internal and external risk matrices
- developed recommendations based on findings identified within processes of assessment and testing
- discussed with the process owners further actions needed to close deficiencies
- followed up on the previous findings
- prepared and presented reports that reflect the audit's results
- visualized data using MS Excel Pivot Tables and charts
- prepared ad-hoc reports for team members
Senior Investment Analyst / Senior Capital Markets Researcher
TaaS
Фінансові послуги
7 місяців
03.2019 - 10.2019
- сonducted industry research for potential investment or product launch
- performed research on emerging technologies applications, including digitalized assets, security tokens, ICO; DLT, AI, and IoT technologies;
- analyzed and evaluated investment projects
- wrote market/industry research papers
- analyzed companies' financials (balance statements)
- calculated project KPIs (NPV, IRR, ROI, etc)
- analyzed companies' whitepapers
- reached out to external vendors aiming to conduct a survey
- developed questionnaires for each particular interviewee
- participated in SEO
- performed due diligence and KYC checks
- watched and analyzed emerging technology trends, news, companies, deals, mergers, and acquisitions
Data Engineer
GlobalLogic Ukraine
IT
6 місяців
08.2018 - 02.2019
- performed data management and data integrity-related tasks
- investigated data integrity issues using MySQL
- implemented database corrections in accordance with the investigation results
- performed minor-difficulty graphic design tasks
- worked with strict deadlines and weekly-based sprints
- performed manual data-matching tasks
- performed content management system algorithm analysis
Rec&Proof Analyst within Trustee Department
Citibank Europe PLC Poland Branch (Warsaw)
Банки
1 рік 1 місяць
07.2017 - 08.2018
- provided loan administration services for syndicated facilities
- monitored upcoming loan events on a daily basis
- ensured that all events are handled in accordance with documentation - reviewed and actioned all cash and stock exceptions on a daily basis
- prepared daily statistics and reports upon clients' requests as well as for the team
- visualized the data using MS Office tools
- chased counterparties aiming to retrieve missing documentation
- handled daily inquiries from clients and internal teams
NYSE Stock Trader
SmartGroup
Інше
2 роки 1 місяць
05.2014 - 06.2016
- developed trading strategies and executed trades
- determined market sentiment via research, valuation, and data analysis
- provided key parties with daily trading information
- made an average monthly profit of 0.5%
- had an average position volume of 3000 shares
- worked with Fusion DMA and Takion trading platforms, Esignal charting software
Ключова інформація
- Data analysis: I possess strong analytical skills which allow me to analyze complex data sets, identify trends and turn raw data into actionable insights. Also, I am capable of analyzing multidimensional data using OLAP techniques such as pivot tables and drill-down analysis. Statistical analysis: I extensively use both descriptive statistics and inferential statistics to analyze operational data. I am familiar with the basic properties, such as the mean, median, mode, range, moving average and standard deviation. I can also derive estimates about data populations, and probability distribution as well as test hypotheses. I know how to use regression analysis to identify patterns, relationships, and trends in data, i. e. correlation, causation, etc.
- Data warehousing and database management: I am familiar with the ETL process (including data cleaning, data integration, data transformation, and database normalization), and data modeling (creating tables, fields, and relationships between them). I can define hierarchies and perspectives in data sets, define relationships cardinality (star and snowflake schemas), and connect data from multiple sources to analyze holistic performance across the entire data model.
- Data visualization and business intelligence tools: I have experience building custom interactive dashboards and reports with the help of MS Excel, Power BI, Tableau, Looker, and Salesforce; having the most exposure to the first two ones.
I am an Excel Power User. I can compile reports using complex nested formulas referring to different sheets in the Excel workbook or other workbooks, pivot tables, and charts. I also know how to work with the properties of dynamic arrays. I can record and adjust macros with VBA to automate Excel tasks, I have a general familiarity with variables & datatypes, control structures, procedures & functions, objects & their properties, and event handling. Working with large data sets I know how to use Power Pivot and Power Query to group & aggregate data, pivot / unpivot & transpose, merge & append queries, connect to different sources (files, SQL servers, PDFs, and Web applications), shape data at the source, set up indexed connections or keys and filter flows. I have deep knowledge of the DAX scripting language and syntax, apart from common DAX functions I am able to write nested Iterator and Time Intelligence functions. As a Power BI user, I can create more complex and informative visuals such as cards, maps, R, etc.
I have general knowledge and understanding of the Tableau scripting language (TCL), I can create mediocre complexity visuals, connect to data sources and perform minor data manipulation tasks. I am also acquainted with the Looker scripting language (LookML), I am able to do all above mentioned using Looker plus automating workflows. - SQL: I have experience working with MySQL Workbench and AWS Athena. I write advanced SQL queries to analyze datasets, create views, and manipulate data using functions & operators. I know how to use subqueries and temporary tables to handle multi-step data problems and I am able to analyze data across multiple tables with JOIN statements. I can also create logical and physical data models, normalize data, and sometimes optimize database performance.
- Macroeconomic analysis: I hold a master`s degree in macroeconomics taught in English. I can analyze macroeconomic trends; I understand the laws of supply and demand, concepts of monetary and fiscal policies, inflation, labor force, factors of production, and economy types.
- Financial analysis & business valuation: I have experience working with financial analysis ratios (EPS, P/E, ROE, ROA, Quick ratio, WACC, etc), having worked as a stock trader I have screened through multiple companies` financials to determine if the stock market price corresponds to its intrinsic value. Throughout my carrier, I have built and analyzed cash flow and P&L statements for various types of businesses including the banking sector. Also, I am aware of key methods of investment analysis (NPV, IRR, ROI, etc) and business valuation, such as market cap, times revenue method, earnings multiplier, DCF, book value, and liquidation value.
- Communication and presentation skills: I can present data insights to stakeholders clearly and concisely. I have experience in pitching my ideas, ad-hoc reports, and research findings to management using complex interactive dashboards and charts embedded into a PowerPoint presentation.
- Project Management: I am used to working in Agile and Scrum environments, having weekly sprints, engaging in face-to-face interactions between cross-functional team members, and reporting on daily meetings.
Навчався в 2 закладах
Lazarski University
International Business Economics
Warsaw, 2018
Kyiv National Economic University named after V. Hetman
Macroeconomics, Management and Administration
Kyiv, 2016
Володіє мовами
Англійська
вільно
Може проходити співбесіду на цій мові
Може проходити співбесіду на цій мові
TOEFL - 97 points
Французька
базовий
Польська
середній
Може проходити співбесіду на цій мові
Може проходити співбесіду на цій мові
Російська
рідна
Може проходити співбесіду на цій мові
Може проходити співбесіду на цій мові
Українська
рідна
Може проходити співбесіду на цій мові
Може проходити співбесіду на цій мові
Кирило
Кирило
Business Intelligence Analyst
Київ
повна зайнятість, проектна робота
Оновлено 2 роки тому