• development and optimization of complex SQL queries, creating tables, views, directories, functions, triggers (dbForge, PL / SQL Developer);• creating analytical reports, interactive dashboards, complex data samples combining different systems, client documents (print forms) in Oracle BI Publisher;• creating a data warehouse (discussion of architecture, creating tables, developing views, preparing ETL requirements / quality control solutions);• deploy objects to the productive environment;• decomposition of task to developers and solutions quality control;• approval of implemented functionality with stakeholders;• identifying, collecting, documenting and analyzing stakeholders requirements;• writing functional requirements, technical specifications, user manuals;• participation in resolving issues (analyzing, identifying the causes of occurrence, helping and advising developers to reproduce the error, agreeing on the best way to solve the issues).

• identifying, collecting, documenting and analyzing customer business requirements;• writing technical specification documents for the automation of banking products/services in CRM bpm’online (BPMN business process modeling, create partitioning, edit pages, dictionaries, setting access rights, describing integration with external web services, setting up printed forms, analytics reports);• task decomposition to developers and solutions quality control• Resolving project issues with support teams

Organization and control of work on technology retail business (retail business, mortgage business, small business, managing a team of 10 people) in terms of:• development functional requirements and technical specifications for the automation of banking products/services in the Core Banking System;• setting of banking products/services in the Core Banking System (setup, testing, implementation);• creation/optimization of business processes that describe the sale and support of banking products/services.• verify that the existing functionality of new releases the Core Banking System;• development and updating of intra-normative documents, the Core Banking System Manuals, recommendation letters, and test training materials for employees of sales outlets;• creation and updating of the product register, the library standards of banking products.

Organization and control of works for retail business processes in terms of:• development, implementation, support, optimization and monitoring of sales of banking products and services for non-trading operations (cash foreign exchange operations, purchase and sale of precious metals, transfers through money transfer system, intra-bank transfers without opening an account, operations with travelers cheques, automation of operations lease a safe deposit box);• development and updating of intra-normative documents, contracts with partners;• business process automation (development of technical specifications, testing, optimization, and implementation);• development of advertising messages (concepts, posters, leaflets, press releases, comments);• seminars for employees of the regional branches of the bank.Organization and control of cash foreign exchange operations:• cash foreign exchange operations (setting rates, management of open position, reporting, interaction with sales outlets, maintaining a database of regular customers);• development and updating of intra-normative documents, reporting forms;• calculation, distribution and analysis of the results of cash foreign exchange operations;• automation of cash foreign exchange operations (development of specifications, testing, implementation);• Department budgeting process.