Russian Federation 125057 Moscow Leningradskiy PR-kt d. 75 sq. 352 +7 (964) 703-9468, +7 (499) 157-7829
Alferov Andrey Gennadievich
The purpose Of obtaining the position of data analyst \ team leader
Professional skill
Certificates
Project management methodologies and technologies
Project management tools: MS Project, MS Project Server, HP Project Portfolio Management Center
Data analysis tools and technologies
Technology: DWH, RDBMS (MS SQL Server, Oracle, IBM DB2)
Analytical reporting platforms: SAP BusinessObjects, MS Analysis & Reporting Services, JasperReports
Data analysis tools: R Studio, RapidMiner, Octave, Python Notebook (Anaconda)
Programming languages: R, Python, SQL( T-SQL, PL\SQL), C++, Java
CRISP-DM data analysis methodology
Technology of reporting on the results of data research (Data preparation, Exploratory Analysis, Reproducible Research, Data Storytelling)
Statistical data analysis methodologies (cluster, factor, regression, variance analysis) and machine learning (regression, decision trees, neural networks, nearest neighbor, support vector machines, etc.))
Business systems planning and modeling methodologies
Modeling tools: MS Visio, ARIS
Methodologies and tools for designing software systems
UML, MS Visio, Enterprise Architect, Sybase Power Designer, CA ErWin
It project management methodologies
PMBOK , RUP, SCRUM
Knowledge of specific subject areas
Banking, financial accounting, insurance( reinsurance), retail
Foreign language
English (reading, written-fluent, spoken-good)
Coursera Machine Learning by Stanford University
Coursera Data Science Specialization by Johns Hopkins University
Experience
2015 October-2016 Sberbank
Project manager
Formation of business requirements for the product
Re-engineering of existing and development of new business processes
Coordination of a team of business analysts
The preparation of financial-economic justification
Coordination of project parameters with the relevant departments
Preparation of project status reports and presentations for management
Preparation of documentation for the tender for selection of supplier
The management of back-log of product within the SCRUM process
2013 April-2015 PJSC ROSBANK (Societe Generale Group)
Chief analyst QCD
Analysis of the needs of the business units in Analytics reporting
Development of reports and universes in SAP BusinessObjects, data uploads on request
Analysis of business requirements, development of functional specifications, technical specifications, test scripts within the framework of projects and applications for change
Functional testing of system functionality
Development of accompanying documentation and preparation of release documentation packages
Portfolio management applications for functional changes to the QCD
Preparation of preliminary estimates of work for incoming projects (Project Approval Forms)
Management of 3rd line support QCD
To develop standards for the development of reports and universes
Analysis and resolution of incidents and work orders within the 3rd support line
November 2010 – March 2013, OJSC JSCB ROSBANK (Societe Generale Group)
Senior project Manager \ reporting analyst
Analysis of business requirements for analytical reporting
Development of analytical reports and ad-hoc data uploads
Managing the stream of data migration from bszhv ABS to ROSBANK ABS in the project of bszhv it systems migration to the target it platform of ROSBANK
Managing the migration project to the new version of SAP BusinessObjects
Project management for implementation of mandatory reporting for the head office (Paris)
2007 July-2010 October JSC JSCB “bszhv” (Societe Generale Group)
The head of the group report authoring
Personnel management (recruiting, efficiency control, competence development)
Portfolio management reporting
The development of reports and printed forms
Control of all stages of development (from registration of new requirements to release)
Organization of interaction with the Bank's divisions
Organization and control of the support process for the developed functionality (3rd line)
Management transition project 302-P from it
2006 December-2007 June LLC CEO Consulting (www.ceoconsulting.ru)
project manager
Personnel management (recruiting, efficiency tracking, etc.))
Project management for the creation and implementation of an operational control system of stocks of ZAO NPK Katren:
Organization of the system development process
Managing interaction with the customer
Participation in pre-sale preparation and sales process of the company's products and services:
Preparation and demonstration of presentations
Negotiations with the customer
2004 January-2006 November Microtest holding (www.microtest.ru)
project manager
Personnel management (recruiting, efficiency tracking, etc.))
Development and implementation of internal corporate standards
Project management of creation of the 1st pilot of the universal integration platform (EAI standard):
Competitive analysis of existing products
Development of functional requirements for the product
Development of the system architecture
System development management
Project management of creation and implementation of financial management system of Microtest Holding:
Participation in pre-sale preparation: development and demonstration of presentations
Collection, analysis and structuring of end-user system requirements
Reengineering of existing business processes in the field of financial accounting
The formation and protection specification for the system
Development of the system architecture
Organization and management of the system development process
Management of sub-contractors: third-party organizations and freelancers
Management implementation and maintenance of the system
Project budget management
Preparation and reporting on project progress
The project implementation of it software audit of the Pension Fund TNK-BP:
Participation in negotiations with the customer
The formation of project requirements (TOR)
Audit: interviews with system users, analysis of technical implementation, documentation and system maintenance process
2002 January-2003 December Konnect Soft Ltd. Moscow development office (www.konnectsoft.com)
head of office
Personnel management (recruiting, development of motivation system, etc.))
Development and implementation of internal corporate standards
Office budget management
project manager
Management of content management publishing system development-CMS:
Analysis of business requirements and develop requirements specifications
Part in the development of the overall architecture of the system and designing the individual components of the system (such as MS Visio)
Decomposition and task to developers and track their performance
Development and tracking of project budget and plan (MS Project, MS Project Server)
Risk management
The introduction of a system of bug tracking (FogBUGZ)
Implementation of two system components (VC++, ATL, OLE DB, Windows Shell)
Organization of testing (preparation of test plans, auto test specification)
Deployment management and support systems at customer
2001 may-2001 December Konnect Soft Ltd.
leading developer
Analysis, design and implementation of content publishing system components on CD-ROM (VC++ 6.0, MFC)
Analysis, design and implementation of business logic component (VC++ 6.0, ATL) and web interface of content publishing system on Web (ASP, VBScript, JavaScript, DHTML)
2000 September-2001 may
Moscow Reinsurance Company “Moscow Re " (www.moscowre.ru)
Director of technical Department
Analysis of business processes in the company and setting tasks for developers
Formation of IT budget of the company
Managing the work of technical support specialists and system administrators
May 1999 – September 2000
Moscow Reinsurance Company “Moscow Re”
Engineer
Deploying a workflow system based on MS Exchange Server and MS SQL Server
Development of data synchronization component in MS SQL Server and MS Exchange Server based on MAPI (VC++ 6.0, MAPI, ADO)
Technical support
Local network administration
1998 December-1999 may
Pic User Association
Developer
Implementation of COM interface for GIS component and integration into graphical interface
Education 1994-2000
Moscow Engineering Physics Institute - faculty of Cybernetics
Specialty engineer-mathematician
Personal data Age-38 years, is single. Driver's license, passport.
Hobbies Of technology and model of machine learning, big data analysis, statistical data analysis (Data Science).