Sergey Kolokots, Mba Email & Phone Number

Moscow, Ru

Moscow, Russia

Data Platforms Development CenterDepartment of Analytical and Financial TechnologiesDirectorate of Information Technologies

Moscow, Russia

Data Warehouse Competence CenterInformation Systems DevelopmentInformation Technologies

Moscow, Russia

Enterprise Data Model DepartmentData Management Department (SberData)Technology Block

Moscow, Russian Federation

- Hiring and management of a team (3-4 people) of specialists in DWH and BI solutions: planning (setting tasks), evaluation of deadlines and labor costs, solutions development control, people training and development- Organization of the team's work according to Scrum principles (2 week sprints) using JIRA- Business analysis, system analysis- Defining of an organizational and technological development plan for DWH\BI- Design and development of DWH Framework- Design and development of a DWH DDS and DMA (Data Marts)- Development and documentation in the areas of data management (enterprise data model, S2T, reference data)- Development of guidelines for DWH\BI solutions- Business users consulting- MS SQL, MS Power BI, MS Power BI Server API, JIRA, Confluence

Moscow, Russian Federation

Department of Application Architecture DevelopmentDirectorate of Architecture and Quality AssuranceDepartment of Information Technologies- Development of the solution architecture in the direction of "Client credit histories" (regulatory project): individuals and legal clients

Moscow, Russian Federation

Architecture and IntegrationEnterprise Data WarehouseEnterprise Data Management DepartmentTechnical Innovations and Infrastructure- Development of the DWH data architecture and integration solutions- Setting tasks for developers of integration solutions and DWH data marts- Providing architectural supervision in the development of integration solutions for DWH- Providing architectural support for the implementation of projects at various levels related to corporate data- The work of the project team according to the principles of Scrum (2 week sprints) using JIRA- Consulting business users and BI development teams- Oracle Exadata, PL \ SQL, JIRA, Confluence, Git, Oracle Data Modeler, Oracle REST Data ServicesProject (solution architecture, development support): "Management Board" is an information and analytical panel for the Company's top management, containing all the main key indicators of operational and financial activities.

Moscow, Russian Federation

Data Warehouse Competence CenterInformation Systems DevelopmentInformation Technologies- Business analysis, system analysis- Design, development and maintenance of information and analytical solutions based on DWH (data marts, reporting, analytical cubes)- Setting tasks for developers, task cost estimating, evaluating and monitoring the deadlines for the implementation of tasks- Organization of the team's work according to the Scrum principles (2 week sprints) using JIRA- Development of technical documentation (solution architecture, developer's guide)- Employee training- Inventarization and organization of accounting of infrastructure objects DWH\BI- Consulting business users, organizing the process of centralized use of the DWH\BI infrastructure- ABS “New Athena”, Oracle, PL\SQL, MS SSRS, MS Power BI, MS SSAS, JIRA, Confluence

Moscow, Russian Federation

Chief Architect Service Department of Information Technologies- Development and agreement of enterprise it architecture solutions (primary architecture, architectural vision) in the implementation of business initiatives and projects- Consulting in the development of business requirements, expertise and agreement of functional requirements, requirements for the interaction of information systems, technical specifications, developed in the implementation of business initiatives and projects- Formation and implementation of proposals to improve the processes and tools of management of applied and information architecture, development and support of the architectural repository in the part of the catalog of data objects, corporate applications and information flows- Analysis of new products, technologies and technological solutions in the field of banking automation, organization of relevant joint working meetings with suppliers and representatives of the Bank's business units- Organization of piloting / prototyping of new products, technologies and technological solutions- Sparx Systems Enterprise Architect, JIRA, MS SQL

Moscow, Russian Federation

Department of Analytical Technologies Financial Block- Business analysis, system analysis- Development of the Financial Block data model- Design, development and maintenance of ELT processes and data marts- Consulting business users- MS SQL, MS SSIS, MS SSAS, MS SSRS, PL \ SQL, C#, ABS CFT-Bank, ABS New Athena, JIRASome projects (analytics, solution architecture, development, maintenance):- Budget Planning (MS SQL + MS Excel Add-In)- Data marts for the IFRS 9 project- Integration of a new data source "Active-Factoring"

Moscow, Russian Federation

BI Systems Development DepartmentBI Center Financial Block- Business analysis, system analysis of the data warehouse of the Financial Block- Design, development and maintenance of data marts- Technological development of analytical solutions (OLAP) and management reporting (mobile BI)- Consulting business users- Employee training- Oracle Exadata, PL\SQL, MS SQL, MS SSAS, MS SSRS, MicroStrategy BI Suite, JIRASome projects (analytics, solution architecture, development, maintenance):- Client analytics (corporate and mass segments): data marts and analytical cubes (MS SSAS), Excel BI Dashboard- Mobile BI for the Bank's Management Board

Moscow, Russian Federation

Data Warehouse Competence CenterBanking Technologies Development Department- Business analysis, system analysis- Design, development and maintenance of ETL\ELT processes and data marts- Automation of management reporting- Technical documentation- Consulting business users- Employee training- Oracle, PL \ SQL, SAP Sybase IQ, Informatica Power Center, MS SSRS, ABS CFT, JIRA, IBM Banking Datawarehouse Data ModelSome projects (analytics, solution architecture, development, maintenance):- Technological connection of JSC "BINBANK Credit Cards" (system analysis and management of the development of ETL\ELT processes for uploading data to SAS Marketing Automation)- Automation of management reporting (overdue debt, deposit portfolio, collection)- Data marts for Risks Department (system analysis and ETL\ELT processes development)

Moscow, Russian Federation

Data Warehouse Competence CenterDepartment of Information Technologies- Business analysis, system analysis- Design, development and maintenance of ETL\ELT processes and data marts- Automation of management reporting- Automation of business processes based on the corporate portal and DWH- Consulting business users- Employee training- Technical documentation- ABS Diasoft 5NT, MS SQL, MS SSAS, MS SSRS, SQL, Diasoft MasterBalance, Comita, simple, Credit Registry, JIRASome projects (analytics, solution architecture, development, maintenance):- Automation of export of credit histories of clients to the credit bureaus (Credit Registry)- Automation of reporting on the loan portfolio (RAS, IFRS)- Automation of currency control- Automation of reporting on unified formats of electronic banking messages (ED207, ED211, ED273)

Tver, Russian Federation

Software Development DepartmentDepartment of Information Technologies- Business analysis, system analysis- Design, development and maintenance of ETL\ELT processes and data marts- Automation of business processes and management reporting for project managers and clients of the company- Development and maintenance of internal application software (C#, ASP.NET)- Technical documentation- Consulting business users- Employee training- C#, MS SQL 2005, MS SSAS, MS SSRS, ASP.NET, SVN, Avaya CMS (ECHO, CDR), Avaya CCE (Express Contact Center), Avaya PDS (Predictive Dialing System), VICIDIAL (Open source outgoing call system), OTRS (Open Ticket Request System)Some projects (analysis, architecture, development, support):- Financial reporting automation for project «Tinkoff Credit Systems»- Call-center specialist operational automated workplace for project «Ozon»- OTRS custom reporting automation- Inbound and outbound management reporting automation (Moscow Exchange, OJSC «Aeroflot», LaRedoute, Toyota, Lexus, NADOM Group, Yves Rocher, Cetelem, Nissan Russia, Citibank, Motorola, Tinkoff Credit Systems, GE Money Bank, Chartis (AIG), Media-Markt Saturn, Philips Russia, OJSC «Sberbank», BusinessCar, Ozon, etc.)

Tver, Russian Federation

- Military service (Military Prosecutor's Office of Tver Garrison)- Transferred to the military reserve with the rank of «Junior Sergeant»

Tver, Russian Federation

Methodology and Information Technologies Center- In-house software development and III level support- Installation programs development- Technical documentation- Users support- MS SQL, Delphi, Macrovision InstallShieldSome projects\tasks (development, support):- Automated system «Electronic Passport of correctional institution and prison»- Automated statistical system database migration from MS Access to MS SQL Server

Mba (Banking Management)

Mba (Information Management, Cio)

Mathematician (Computer Security)