Data and Financial Analyst
Hi! I'm Illia, nice to meet you. I am Financial Analyst with 2+ years of expirience. My task is to solve real economic problems using BI instruments, programming and mindful analysis.
Hi! I'm Illia, nice to meet you. I am Financial Analyst with 2+ years of expirience. My task is to solve real economic problems using BI instruments, programming and mindful analysis.
Role: Financial Analyst
Responsibilities: financial modeling, company valuation, FS analysis, investment analysis
Role: Auditor (A1)
Responsibilities: company audit, work with excel, corporate finance and accounting
Specialization: Economic Cybernetics
Master's Degree
Specialization: Foreign Economy
Bachelor's Degree
Proficinecy in Microsoft Office:
- Excel: XLOOKUP, index and match, data validation, conditional formatting, pivot tables, what-if analysis, Goal Seek and Solver, Forcast Sheet, Regression and Correlation;
- Word and Power Point.
Interactive dashboards in Power BI:
- DAX Functions: Calculate, Sum, Sumx, Count, Average, Filter, Removefilters, Keepfilters, Switch, If, Iferror, Isfiltered, Iserror and others
- Power Query, Data Modeling, Python scripts, Color Theory
Experience with:
- Financial modeling and FS analysis (vertical and horizontal analysis, financial ratios);
- Company valuation (Times-Revenue, First Chicago and Berkus Methods, Post-money valuation, Scenario Analysis,);
- Business plan creation (including NPV, IRR and MIRR calculation).
Using Python for:
- Datta mining (Requests, BeautifulSoup4);
- Data analysis (Pandas, NumPy, Scikit-learn);
- Data visualization (matplotlib, seaborn, plotly).
In addition, I have some expirience with SQL, HTML and CSS.
Basic knowledge of:
- Econometrics (linear, non-linear and multiple regression models; multicollinearity and autocorrelation; MSE, RMSE, MAE, MAPE);
- Portfolio Management (Modern theory, asset alocation, portfolio performance evaluation, investment strategies);
- Accounting, AB tests, KPI & PPI.