1) Administration, Support and Project enchantments of all banking IT environments: DEV, QA, UAT, PROD consisting of application, middleware and database servers for the core banking software: - sizing, user management, log archiving - backup/restore (IBM TSM) - release process support and automation - migration project to the new DR infrastructure - Performance Tuning (Zabbix) and Monitoring: - identify issues, provide solutions, define and optimize processes and tools - development of the maintenance jobs and scripts (SQL Agent, Power Shell, Bash, Perl, DB2 SQL, T-SQL) - Administration and Integration between different software components: • Diasoft backend/WINTEL; • Diasoft middleware/WINTEL • IBM DB2 + Federation Server/RHEL, • IBM Web Sphere AS, MQ • IBM Cognos/RHEL, • IBM DB2 9.7/RHEL, • MS SQL 2005/2008/WINTEL, • Active Directory, • Etc - Incident and service request management - Cooperation with vendors and external support teams (PMR, consulting, tasks) and with infrastructure team. 2) Cooperation with contractors. Task definition, quality and process control, candidates interview. 3) Participation in IT projects as technical expert or architect: - analisys and migration to the new remote access platform, alternatives: Citrix XenApp; XenDesktop; Vmware Horizon; Juniper VPN, etc - extension of licensing agreements - author of a number of documents in IT compliance area (processes definition to achieve Corporate Compliance Standards)

Key responsibilities include: • Client and subcontractor interaction • Requirements elicitation, definition and management • Architectural/conceptual design • Effort estimation and initial project planning, trade-off analysis and cost-benefit analysis • Management of small teams • Interfacing between various functional teams (HW, SW, etc) and project managers • Detailed project planning of all FS work packages • Progress estimation and updates to project plans • Testing and qualification of FS designs

Assignments: ------------------------------------------------------------------------------------------------------ • Audit of all database solutions based on MS SQL Server and Sybase ASE, including development, support and implementation phases & workflows. • Audit of DB-dependand informational systems, including development, support and implementation phases & workflows. ------------------------------------------------------------------------------------------------------ List of Applications and Informational systems: ------------------------------------------------------------------------------------------------------ • Trading platforms for: Spread Betting, Contract For Difference, Forex • platforms: Metatrader 4 (C++ API & MS SQL 2005); Arial (.Net & MS SQL); in-house: Java Enterprise & JBoss & Apache Tomcat & Sybase ASE 12.5 & MS SQL 2005/2008; Web-clients - .Net & MS SQL 2005/2008) ------------------------------------------------------------------------------------------------------ Results and achievements: ------------------------------------------------------------------------------------------------------ • Identified core reasons of the common problems (low control over development and support, IT strategy, dependency on the people with the key knowledge of IS, poor documentation, missing practices and standards, difficulties in estimation and successful implementation of the decommission and migration projects). • Developed recommendations for mitigation plan; simple and quick workflow solutions leading to significant quality improvements. • Participated in the development of IT strategy. • Developed the following documentation: o Development and support workflow for the existing and new IT solutions (in cooperation with the infrastructure team) o Development and support workflow for the existing and new Database solutions (in cooperation with the DBA team) for MS SQL and Sybase ASE. • Developed set of tools for automation around database development, testing and release processes. • Performed technical audit and achieved significant improvement of database performance based on MS SQL and Sybase ASE - including DB structure, coding and configurational changes. • Developed database "good practices" and standards for Sybase ASE и MS SQL. • Developed DB release workflow tools and DBA automation tools, including maintanance and release scripts. ------------------------------------------------------------------------------------------------------

• Remediation project for major legacy datasource application based on Sybase ASE: Migration of Dataflows from old - expensive in support and complicated in managment technologies, like Sybase Replication, FTP, etc to centralasied data hubs: • Requirements elicitation and definition • Architectural/Conceptual design • Effort estimation and initial project planning • Interfacing between various application teams and project managers • Detailed project planning of FS work packages • Progress estimation and updates to project plans • High-level (architecture) design and allocation of requirements • Detailed FS design and documentation • Data mapping and transformation between various datasources • Development of the middle tier server side application for the new dataflow. Main functions: • messages consuming, parsing, mapping and persistence (multithreaded msgs consuming at high rates) • multiple threaded messages/events processing (multithreaded msgs processing) • load balancing capabilities for the consuming and processing of the big number of parallel message flows with high rates ~350 msg/sec (the requirement was confirmed during stress tests) • designed and developed in Java (JMS, HTTP, XML, SSL) and MS SQL 2005 (T-SQL, stored procedures).

Key responsibilities include: • Database administration and development. DBA process improvements incl. automation development. • Client and subcontractor interaction • Requirements elicitation and definition • Architectural/Conceptual design • Effort estimation and initial project planning, trade-off analysis and cost-benefit analysis • Management of small teams (SW Engineers) • Interfacing between various functional teams (HW, SW, etc) and project managers • Detailed project planning of all FS work packages • Progress estimation and updates to project plans • High-level (architecture) design and allocation of requirements • Detailed FS design and documentation • Testing and qualification of FS designs • Experienced in confidential data rules (Закон о персональных данных, ФСТЭК, Закон №152-ФЗ) Key succeeded projects: 1) IT, design and media support in ZAO “Don Stroy” branding campaign year 1998, including promo-sites development. 2) Design, development and implantation of fault-tolerance data storage access network based on Novell Netware OES 2.0, incl. clustering and mirroring services for ”Sheremetyevo Customs”: a.2 HP ProLiant mid class – cluster members b.2 HP ProLiant low class – Novell OES iSCSI storage in mirror 3) Design, development and implantation of the Infrastructure of consolidated servers managed by VMware 3 with VMotion and HA functionality for ”Sheremetyevo Customs”: a.4 HP ProLiant mid.class b.optical switch QLogic 8 ports c.2 HP MSA 2012fc in mirror 4) Developed and implanted database performance tests and tuning tool set for MS SQL 2003, Oracle 9 and Firebird database engines for ”Sheremetyevo Customs”. 5) Design and development of CRM solution for “Logistic Service” company.

- Participated in development and support for the online trading system (server side) based on Sybase ASE, Java (JMS) on Oracle Solaris/Linus platforms. - Performed database audit of server configuration affecting key performance indicators. - Performed optimization tuning (server configuration + T-SQL + complex stored procedures). - Installed Sybase ASE monitoring tools. - Participated in various integration projects (Sybase ASE, Orcacle, IBM DB2).

- Main technical role in the successfull transition of client projects from on-site to off-shore team. Knowledge transfer, coaching. - MS SQL Server/Sybase ASE DBA and DB developer tasks including DB code reviews; - Design of development workflow for the off-shore team; - Database design process development; Developing T-SQL parser utility using GNU BISON. - Design and development of the database logical/physical models for web-portal (based on 450 pages of specifications), inclusing triggers and stored procedures. - Participated in a number of development projects as a technical leader or system architect. Platforms/technologies: MS SQL Server/MS Windows; Sybase ASE/AIX/HPUX; .Net; J2EE

2'nd level support of factory applications including small changes projects on Tandem; COM/DCOM platforms.

Design, implement and support SW (Insurance and Accounting fields). - Designed and implemented thin client application for sending/parsing of bills from medical units: IBM WebSphere AS/Studio 5.0 - Servlets/JSP, Perl, MS FoxPro, IBM DB2/400, - Responsible for SW deployment on a number of projects: 1. SUN Systems migration from ISAM to Oracle / 2. Migration from SUN Payroll to HRB Oracle system - Designed internal inventory control application

Design Engineer in Network Management Systems R&D - Sybase ASE 12.5 / Visual C++ / Er/Studio / XML / XSL / Perl / Java - Database design & performance tuning - XML-enabled database metadata management - C++/Java database access libraries - Database design process development - Database replication&backup maintenance

- Developed database for quality management of supply systems: (MS SQL Server / VB, ADO) - Oracle DB design for MChS ERP system - Provided test management of e-business applications of company's partners written in IBM DB2/WebSphere/Java; - Designed functional specifications and system architecture specifications for one of subsystems of Automated Informational System for Quality Management (AIS 'Quality') 'Internal audits', based on ISO 9001:04:2000 standards. - Participated in different kind of seminars: technical, product presentation, etc

- Developed database for automated support of core business processes: IBM DB2 UDB 5.2 / MS Access / ODBC / LotusScript / VBA / DAO - Provided migration from old applications to the new developed system - Participated in development of Intranet internal Web-site, with direct access to developed database: Lotus Web Go / OS/2, Windows NT / IBM Net.Data 1.0 / JavaScript, Perl, IBM REXX - Provided overall system performance tuning and security management - Provided system integration with servers based on Lotus Domino and office applications