← В ленту
Регистрация: 16.11.2023

Портфолио

T1Cloud

- Analytical reports system elaboration, using Power Query. - Automatization sales reports and billing reports. - Keeping product catalogue in SalesForce. Started managerial accounting design (MS Power BI Dashboard) for top-brass.

Technoserve

- B2B products analysis, weak points, new ideas to impact sales and raise life cycle. - Formation and update investment cases by every product conception. - Consulting product managers in law, financial and economical questions. - Risk analysis of investments: scenarios model, its sources and find ways to avoid’em. - Analytical reporting system development, business requirements for IT. - Product KPI control for budgets executions. - Participate in elaboration and implementation of the product strategy.

Vimpelcom

1. Estimation of retail loyalty programs productivity. 2. Monitor and analyze efficiency of promotion and churn retention campaigns. 3. Prediction their efficiency and influence on total department KPI results. 4. SQL requests (Oracle, MySQL) and elaboration of reports (and presentations) also in SAS (BI). 5. Involved in projects for extending functionality of analytical systems, compiled requirement specifications for IT developers.

Скиллы

1C-Bitrix24
Business analysis
Confluence
Metabase
MS Excel
MySQL
Oracle
OrangeCRM
PostgreSQL
Power Pivot
Power Query
Reporting, dashboards
Reporting, dashboards
SalesForce
SQL
Visio

Опыт работы

Business Analyst
с 06.2021 - По настоящий момент |T1Cloud
MS Power, BI Dashboard
- Analytical reports system elaboration, using Power Query. - Automatization sales reports and billing reports. - Keeping product catalogue in SalesForce. Started managerial accounting design (MS Power BI Dashboard) for top-brass.
Product Analyst
08.2016 - 05.2021 |Technoserve
.
- B2B products analysis, weak points, new ideas to impact sales and raise life cycle. - Formation and update investment cases by every product conception. - Consulting product managers in law, financial and economical questions. - Risk analysis of investments: scenarios model, its sources and find ways to avoid’em. - Analytical reporting system development, business requirements for IT. - Product KPI control for budgets executions. - Participate in elaboration and implementation of the product strategy.
Director General
11.2013 - 08.2016 |Microfinancial Company
.
Launched start-up payday loan service. 1. Managing campaigns to raise awareness, promotion measures, organization of events to promote services (ATL n BTL: in media, POS-products, Direct-marketing, sales and loyalty stimulation). Campaigns efficiency estimation. 2. Compiling and working with business plan, financial feasibility and viability analysis. 3. New products and services development. Reason for dissolution: worsening economic situation, shrinking microfinance institutions, lack of investments and prospects.
Business analyst and sales support manager
01.2011 - 09.2013 |Orange Business Services
Business Analysis
I was a part of Easy Office project team (service for Small and Medium Businesses). 1. Economic model of products business-analysis, planning and prognosing business KPIs (Balanced Scorecard), creation of reporting system and presentations in English. Realty investments analysis, efficiency post-analysis. P&L of the product line, LTV, ARPA, ARPU analysis. Business processes elaboration and integration. New value-added customer services implementation (Smart-IVR, Customer portal). 2. CRM and ERP sales support with reporting, business processes development, formation of databases and analytical reporting. Reasons for dismissal: closure of the project, disbandment of the Department.
Analyst / Trader
05.2009 - 12.2010 |Mini-fund in Russian stock exchange
Financial Analyst
- Financial market research (also CNN and Bloomberg). - Effects of macroeconomic events on prices. - Using wide range of mathematical models of prognosis. - Selected Programmed automating trading systems. - Doubling assets in 1,5 years. Reasons for dismissal: Multiple growth of tax burden, closure of the fund, new offer from Orange.
Expert of loyalty programs estimation
10.2008 - 06.2009 |Vimpelcom
SQL, Oracle, MySQL
1. Estimation of retail loyalty programs productivity. 2. Monitor and analyze efficiency of promotion and churn retention campaigns. 3. Prediction their efficiency and influence on total department KPI results. 4. SQL requests (Oracle, MySQL) and elaboration of reports (and presentations) also in SAS (BI). 5. Involved in projects for extending functionality of analytical systems, compiled requirement specifications for IT developers. Reasons for dismissal: new opportunity in stock trading, using statistics, big data field.
Head of analysis and reporting group
01.2005 - 10.2008 |Russian Development Bank
Marketing, Analysis
- Head of analysis and reporting group (November 2006 - October 2008) - Marketing and Product Development Department (February 2007 – October 2008) 1. Sales analysis, preparation of their P&L and common- financial reports. 2. Regional statistics accumulation for reporting, wide researches of banking industry situation. 3. Dual collaboration with retail as well as corporate product groups. 4. Developed management reporting by retail and corp.business volumes. Internal DBMS, ABS “Bankir”. 5. Customer base segmentation, target audience definition. Supported product line development and was involved in banking products promotion programs. 6. Collaborated with IT Department to enhance analytical system functionality. 3 staff members. - Analysis and reporting group chief deputy. - Retail marketing Department (November 2006 – January 2007) Developing management reporting by retail business. 2 staff members. - Senior specialist (February 2006 – November 2006) 1. Researching retail products, optimal location for branches. 2. Target group discovering, advertisements and promotions analysis, efficiency estimation. 3. Retail banking products sales analysis and prognosis. 4. Gathering data from external sources. Quantitative researches. 5. Support new products and services development. Customers database and target audience definition. - Leading specialist. Retail marketing department, researches group. (January 2005 – January 2006) 1. Aggregation primary and secondary data. 2. Reporting of retail banking business. Quantitative analysis. Sales and portfolio predictions. Reasons for dismissal: sanitation of RBR, new offer from Vimpelcom
Marketing Analyst
12.2003 - 12.2004 |ASKOM
Business analysis, Marketing analysis
- Distribution of spare parts for tractors, combines and hung equipment. - Business analysis and reporting. - Organized exhibition participation. - Media planning and advertising. - Market researches, full marketing activities. - Marketing analyst. Sales analysis (ABC, XYZ), SWOT analysis, reasons of deviations, recommendations. - Quantitative and qualitative sales forecasting. - Competitors’ activity. - Sales promotions, pricing and assortment policy. Reasons of dismissal: Offer from Russian Development Bank
Manager of Marketing Researches and Financial Analysis Department
03.2001 - 07.2003 |Uzbekinvest
.
- Trade Promotion activity. Assists local companies in integration to the international markets and provides foreign companies to enter national market. - Investment projects commitment. 1. Manager. Methodology of Marketing Researches and Document Quality Management Department (November 2002 – July 2003) - Methodologies and standards of enterprise for marketing researches implementation, Business-plans and Technical-Economic Basis development. - Responsible for finalizing projects, communication with foreign customers and banks. 2. Manager Senior Assistant. Marketing Researches and Financial Analysis Department (May 2002 – October 2002) - Business plans and Economic Proves for investment projects realization and finalizing. - Searching investors. - Financial and marketing analysis preparation and prognosis. - International markets research. Marketing "field" and desk researches. SWOT analysis. 3. Manager Assistant. Marketing Services Department (March 2001 – April 2002) - Involved in investment projects and business plans development; also in global marketing researches. - Duties included correspondence, document translations, interpretation in meetings.

Образование

Management, Marketing, Economics
1996 - 2000
Tashkent State Technical University

Дополнительное образование

Course Stream and Commands
По 08.2023
VTB
Course SQL
По 12.2019
Sololearn
Course Python Core
По 12.2017
Sololearn

Языки

АнглийскийВыше среднего