Development from scratch the front- and back-end of the CIB “Analytical Advantage” service in the REST architecture. The goal of the service is to narrow the sales funnel to improve the efficiency of communications between the Bank's client managers and CIB clients through NBS (Next Best Sale) potential prioritization.RESULTSBusiness:- attracting new customers - increasing the conversion of sales of the Bank's products by 2 times,- income increase for current customers of the Bank by 20% on average.Infrastructure/processes:- creation of instruments for analytical assessment of the CIB market for strategic and tactical business planning for 200 internal users,- creation of a process for conducting centralized and decentralized sales campaigns,- integration with the Bank's internal information systems (CRM, Credit Conveyor, EWS, analytical reports).STACKFrontend:- React.js, Typescript, Redux, GraphQL, BootstrapBackend:- Django REST, Redis, Celery, Selenium, SQLAlchemy, Pandas, Scikit-learn, DockerDBMS:- Oracle SQL, PostgreSQL, Microsoft SQL ServerOther Responsibilities:- development of the service's methodology for credit and non-credit products together with consultants from Oliver Wyman,- business logic development,- backlog maintenance and task prioritization,- machine learning models development and embedding.

• Financial Modeling, budgeting, business plan creation• Calculation of investment performance indicators • Any kind of market research, including highly specialized topics• Competitors analysis• Exchange listing analyzing/ listing process assistance • Blockchain analytics • Business development / Partnerships searching and analysis / Meeting calls conducting • Whitepaper preparation • Strategy analyzing • New products/features development, analysis of potential • Presentations preparation for top-management• Customer development / product development operations • Analytical articles writing for marketing team • Important news aggregation / real-time market watch • Treasury analytics, monitoring reports compilation • Card issuance programs analysis, whitelabel solutions analytics • Crypto trading data analytics / Product data analytics• Crypto loans system development • Working with relational databases and Google Clouds instruments (BigQuery)• Automation of workflows and analytical calculations using Python and certain libraries

• Assessment of credit deals:- analysis of financial and economic activities of the borrower and the group of companies,- analysis of collateral, building models of financial flows,- credit risk assessment,- analysis of investment projects.• Structuring of various types of credit deals (investment lending, project financing, etc.)• Presentation of credit deals on the relevant collegial bodies of the Bank.• Implementation of activities for dealing with problem debt.

- Value analysis:determination of various types (market, collateral, liquidation, etc.) of the value of the assets of organizations through the use of various approaches (income, comparative, cost) to assess the analyzed object.- Investment analysis:analysis of investment projects, calculation of key investment performance indicators (NPV, IRR, DPP, etc).- Financial Modeling:development of general, macroeconomic and special assumptions, building a financial model in MS Excel and modeling the cash flows of the object for various activities.- Conducting marketing research:analysis of the market situation and influencing factors of the analyzed object, collecting analytical articles from leading analytical agencies, information updating, info searching in news reports and other Internet resources.- Preparation of analytical reports:building presentations and reports using MS PowerPoint, MS Word and providing compliance with certain requirements for the presentation / report (color scheme, font, logic of presenting information, visual arrangement of information, wording).- Working with large data arrays:processing of massive data flows in MS Excel, effective use of built-in functions and finding key information.Large projects:- development of the lean concept for a federal subject of the Russian Federation, including analysis of the Russian and international experience in lean applying, elaboration of the methodology for introducing the principles of lean production in the private and public sectors, modeling economic effects and costs;- analysis of the most efficient use and development of a business plan for non-core energy assets of the state company;- determination of the investment value of a large pool of development projects;- building a financial model of the project of the largest food wholesale distribution center in Russia.