Business Domain: Document Management, Atomic Energy.Responsibilities:- Systems Analyst role: developed and implemented an Enterprise Data Warehouse (EDW) to support document reporting processes; created detailed documentation for processes, systems, and training materials.- Data Engineer role: optimized complex queries to improve database performance and ensure efficient data retrieval and processing; conducted thorough analyses to identify and rectify data inconsistencies and errors.- Project Manager role: turned around a struggling project, bringing it back on track within three months, created a framework for managing bugs and feature requests, streamlining the development process.- Leadership role: managed and mentored a team of new analysts, providing training and guidance to develop their skills and ensure project success.Achievements:- Spearheaded the recovery of a high-profile project, meeting critical deadlines and budget constraints.- Implemented best practices for data management, significantly improving system performance and reliability.

Business domain: Banking, ETL developmentResponsibilities:System Analyst Role: ETL process design (planning and architecting the flow of data from diverse sources to databases), Code prototyping (crafting SQL prototypes for ETL processes), Business requirements extraction (liaising with stakeholders and participants to derive key project requirements) Achievements:- Redesigned/optimized the ETL process for credit limit dynamic managing system.- Provided the framework for testing, training and onboarding new analysts.

Part-time consulting jobBusiness domain: GameDevhttps://store.steampowered.com/app/2568780/Empolicy/Responsibilities: - Conceptualization and idea review- Data Analysis- QA

Business domain: Legacy ModernizationResponsibilities:- Systems Analyst role: design of framework for onboarding new system analysts and managing project-related information, technical data, and resources; Pre-sale/proposal preparation (ASML HFI Conversion project); Legacy DB migration.

Business domain: Identity managementResponsibilities:- Analytics Lead role: strategy development for data analysis and reporting (obtaining and validating goals, translating them to metrics, developing ways to calculate these metrics), ownership over all analytics related subjects within Operations (from initial requirements gathering to development of visualizations (Tableau/Excel) and documentation)- Systems Analyst role: design of data pipelines and reports generation & distribution.- Data Engineer role: ETL process development.- BI Analyst role: dashboard development (Tableau), search for insights, ad-hoc reporting, training of users, etc.- Data Analyst role: development of tracking and performance measurements for Machine Learning systems (Confusion Matrix analysis).- Leadership role: leading and coaching of BI Analysts and Data Engineers.Achievements:- Delivered ETL process for ML system training, including Data Labeling pipeline (SW and process): https://flowconf.ru/talks/6b84a5f6b9eb4786bb02bf3e2cc742d7/ .- Designed the process of report generation - CM and OCR accuracy reports (Excel, Tableau).- Created documentation of existing DWH data structures and processes.- Provided MVP of World ID's database.

Business domain: national track & trace systemResponsibilities:- Systems Analyst role: design of the national track & trace digital system (Chestny ZNAK, 100s of billions of events and unique goods) Analytics subsystem (ETL processes for DWH, data cleaning, DataMart development, documentation, training and coaching of analysts and developers, code review), development of in-house reporting system (both front- and back- end, including REST-API methods).- Data Engineer role: DWH and DataMart creation, ETL process development.- BI Analyst role: dashboard development (Apache Zeppelin, Redash, JasperReports, MS Power BI, Tableau, in-house reporting system), search for insights, ad-hoc reporting, testing of 3d-party reports, training of users, etc.- Data Analyst role: report generation from Big Data (Python, Spark), search for errors (breaks) in goods logistics, etc.- Leadership role: leading and coaching of BI Analysts, Data Analysts and Business Analysts working on Analytics subsystem development.Achievements:- Designed Analytics subsystem (Spark, Apache Zeppelin, MS Power BI, Tableau, Redash).- Delivered new software: BI tools suite for the national track & trace digital system.- Provided Data Mart of national track & trace digital system (production, stock balances, logistics, sales).

Business domain: Edtech marketplaceResponsibilities:- Systems Analyst role: reporting system design, ETL process development.- Data Engineer role: DWH creation, ETL process development.- BI Analyst role: dashboard development (sales, customers, LTV, KPIs, etc), search for insights, ad-hoc reporting, business planning, etc.- Data Analyst role: fraud detection, customer and seller base segmentation, etc. - Marketing Analyst role: market research, CPA, ROAS, retention, marketing campaigns results, CXM, etc.Achievements:- developed and supported a new in-house BI-system (Postgresql/Matomo/Greenplum/PHP/Apache Zeppelin/MS Power BI tech stack).- provided data insights for management.- using data and models assisted PMs and CMO to develop products: provided insights, helped to steer clear of negative-income projects, designed better specifications for solutions (e.g. Ed Tech products).

Business domain: FinTech (online payment service) Responsibilities:- BI Analyst role: dashboard development (sales, customers, finance, KPIs, etc), search for insights, development of business plans and forecasts, etc.- Product Analyst role: development of B2C and B2B products (Yandex.Checkout, bank cards, ApplePay, mobile app, etc), design of product financial models (e.g. integrations of payment aggregator with online marketplaces, delivery services, gas stations) search for insights (search for new metrics, customer base segmentation, etc). - Marketing Analyst role: market research, retention, CPA, ROAS, etc.Achievements:- developed and supported new dashboards (OLAP-cubes, Grafana, MS Power BI).- designed business models for products (used in planning and forecasting).- using data and models assisted PMs to develop products: provided insights, helped to steer clear of negative-income projects, designed better specifications for solutions (e.g. Fintech products).

Responsibilities:- Systems Analyst role: reporting system and DWH design, website and digital banking platform development. - BI Analyst role: dashboard development, search for insights, ad-hoc reporting.- Marketing Analyst role: market research, retention, CPA, ROAS, CXM, etc. - Financial Analyst role: retail banking financial models, plans and projections, risk management, financial reporting, business planning, etc.- Leadership role: leading and coaching of BI Analysts, collaboration with other departments. Achievements:- developed a continuously evolving system of regular reports.- forged a valid business strategy for Retail business.- successfully redesigned website & Online banking system.- provided on-demand business intelligence insights.

Responsibilities:- headhunting of software developers and analysts.

Responsibilities:- Process Improvement Manager role: bank-wide business process management and improvement (documenting system details, cost assessment, measuring company waste, process restructuring, planning and implementing change), collaborating with participants from other departments.- Systems Analyst role: BPM tools development, bank product development. - Marketing Analyst role: market forecasting. - Financial Analyst role: cost management, bank product modelling, etc.- Leadership role: leading and coaching of Process Improvement Analysts, managing collaboration with other departments.Achievements:- managed to lower cost of Retail banking (credits, remittances, checks, cards, etc.) processes by more than 40%.- designed a forecast of retail banking customer behavior in Russia for 2013-2014 (forecast accuracy was 99%). - provided cost allocation for all banking products, including B2B.

Responsibilities:- Systems Analyst role: reporting system and DWH design, digital banking platform development, design and development of software solutions for Retail business.- Project Management role: development and launch of i.bspb.ru digital banking platform.- BI Analyst role: dashboard development, search for insights, ad-hoc reporting.- Financial Analyst role: retail banking financial models and projections, risk management, financial reporting, business planning, etc.- Leadership role: leading and coaching of BI Analysts, collaboration with other departments.Achievements:- developed a constantly evolving system of regular reports.- implemented a robust Retail Business planning system: Strategy - Financial Plan - Business Plan – Personal KPIs.- designed and launched software solutions for Retail Business (ATM network management, Cash management, other B2C&B2B services management).- digital banking platform i.bspb.ru successfully launched.- provided data for bank’s successful IPO.

Responsibilities:- Business Analyst role.- Software development role: C++, SQL, PL/SQL.- QA role.- Technical writer role.Achievements:- Global CRM (customer relationship management system)- Global Energy (electrical energy sales management system)- Global Transport (automobile transport management system)