Andrey Galkin Email & Phone Number

Participated in projects for large banks in various roles.2020-present.Project: Data warehouse development project for TOP-3 bankRole: Data Engineer Team LeadStack: SAS, Teradata, OracleMy activities as a team leader included: Team building and development Task allocation and prioritization ETL process development Code Review In addition to major activities to implement new repository objects, a formed and implemented a new approach in loading large volumes of initial solutions, which as a result significantly reduced the amount of labor at this stage of work. 2019-2020Project: Managed ServicesRole: Data EngineerStack: Teradata The main activities on this project were finding bottlenecks in the processes of loading data into the storage and refactoring of non-optimal processes. Along with these activities the mechanism of data compression automation was developed. This mechanism offered optimal compression on volume/performance ratio.

Participated in various projects as lead developer and team leader.The most significant projects: Project for a major oil company. Revision of operational risk management system. Role: Team Lead \ Lead Data Engineer. Implementation of SAS Marketing Optimisation at a large telecom company. Role: Lead Data Engineer Development of data marts for a large telecom operator Role: Lead Data Engineer All projects included requirements gathering and analysis, data mart design and preparation of documentation.

Москва, Москва, Россия

Migration of retail risk block reporting to a new data warehouse:1) Financial justification of resource pool adjustment2) Tasking the Analytical Development Department3) Collection of requirements from users of reports4) Design of data marts5) Control of data quality

Took part in several projects in various roles:2015-2016Project: BI dashboardsRole: Team LeadStack: SAS, Teradata, Oracle, MS SQL, MS SSAS (Tabular mode), MS SSIS, SharePoint, PowerViewThe project included: Refinement of data marts, taking into account the peculiarities of the BI tool Coordinating with the customer the appearance of analytical panels Developing a mechanism for loading data from DWH onto the BI-server Development of additional data marts for the implementation of role-based access to the data.Project: Automated bonus calculation systemRole: Fullstack DeveloperStack: MS SharePoint, C#, JavaScript, MS SQLOur team was responsible for developing a web-client integrated with the sharepoint portal.The development process included close collaboration with analysts and UI designers.2014-2015Project: Migration of reporting delivery system from SAS portal to SharePoint portalRole: Fullstack DeveloperStack: SAS, Teradata, Oracle, MS SQL, SharePoint, C#, JavaScriptMigration of reporting delivery system client functionality from SAS-portal to SharePoint-portal was performed within the project.The main activity included rewriting part of the modules from SAS Base/Macro to C# and JavaScript.Project: Automated system for subscription to reportsRole: Team Lead \ ArchitectStack: SAS, OracleThe project involved development and implementation of an automated system of subscription to reports which allowed to minimize the role of the support service in the process of granting end user access rights to the reports.2012-2014Project: Development of reporting on the data marts layerRole: ETL Team Lead \ Senior ConsultantStack: SAS, Teradata, VBScriptDeveloped and integrated with reporting delivery system more than 120 objects on the data marts layer.2011-2012:Project: Development of detailed data layer objects Role: ConsultantStack: SAS, TeradataDevelopment of ETL-processes

Lead Analyst Preparing reports: portfolio volumes, dynamics, P&L, plastic cards, conversion transactions reporting, competitor banks reporting Finding and substantiating data anomalies. Reporting automation Staff training After modification of reporting processes, the time of regular monthly reports preparation was reduced by three timesAnalyst Trainee At the initial stage, my main tasks were immersion in banking issues and mastering data processing and analysis tools.

Москва, Москва, Россия

I was tasked to design and develop a project management system that would take into account the peculiarities of the 3d-production studio. In this system, the project was a DAG, in the nodes of which the project activities were located. Each project activity was represented by a node of its own type with its own settings. The system also supported role-based access.Stack: Java + MySQL

Москва, Москва, Россия

Took part in the development of individual modules of the banking system: Cash management Futures Invoices

Москва, Москва, Россия

In close cooperation with the finance department, which also acted as a customer, I developed a system of consolidation of RAS with US GAAP. Since I was the sole developer, I was responsible for all phases of the work: Collection and clarification of requirements Development Implementation Preparation of documentation and training of employees This development allowed us to reduce the time spent on the task of consolidation from 5 days to 1 day.