Serge Puchnin Email & Phone Number

Berlin, De

London Area, United Kingdom

As a Senior Data Solutions Architect, I communicate with stakeholders, analyze business requirements, design and implement architecture, and manage project delivery. For instance, my proposed architecture reduced the integration time for a new data source from 2 months to 2 weeks. Thanks for using automation, data quality errors decreased from 18% to 7%. I lead technical aspects of pre-sales projects, conduct technical interviews, and provide mentorship, specializing in developing solutions for the financial sector. My past projects include:* Data Platform / Finance, USA / Azure / Snowflake / DWH / Data Modeling / Data Vault / Python / WhereScape / Power BI* Data Governance Program / Finance, Global / AWS / Snowflake / Python / Tableau* Data Catalog / Finance, UK / DG framework / AWS / Alation / Python.

For mid-sized projects where a dedicated architect role is not required, I am tasked as a Data Engineer. I lead the design and implementation of project data solutions, ensuring optimal performance and scalability.I drive cross-functional teams to gather and analyse data requirements and translate them into effective data engineering strategies.I ensure data reliability, quality, and security by managing project technical implementation and supporting data engineering best practices.As a result, I design and implement a data preparation process, shift it from batch to streaming, and reduce new ML sample processing time from days to minutes. I impove a data matching algorithm from rate of 67% to 82% accuracy rate.Projects:* Data Analytical System/ Sport, US / Azure / Databricks / Streaming / Python* Data Warehouse Management System / Traveling, US / AWS / AirFlow / Snowflake / Python / Tableau * Data Warehouse Management System/Finance US / Azure / MSSQL / dbt / AirFlow / Python / Data Vault

London Area, United Kingdom

As a data architect, I facilitated in developing various aspects of data management. Built a data integration framework to create seamless data flows between 20 different systems.Also, I developed and implemented robust data security policies to safeguard sensitive information and maintain standards of data protection. I take pride in creating canonical data models, helping over 20 data teams and ensuring a thorough and comprehensive view of data across the organization. I established integration rules for the master data management system.

Cambridge, Massachusetts, United States

* Communicated with stakeholders to develop solution architecture for database domain.* Proof of concept, specification, pre-sales preparation for 6 projects. * Developed efficient search and storage algorithms for large data projects. Reduced search time from minutes to seconds. Reduced data volume by a factor of 2.* Managed a Big Data Competence Center. Built, managed and mentored a distributed team of data engineers from 5 to 12 people.Project:* Data Analytical Platform / Healthcare, US / AWS / DataBricks / PySpark / Python* Data Analytical Platform / Life sciences, US / DataBricks / PySpark / Python* Data Platform / Life sciences, EU / AWS / Python

* Define scope, expected timeline, and engagement exit criteria as part of engagement management.* Define and implement processes and procedures for stakeholders communication to ensure data and analytics engagements produce usable and applicable outcomes.* Develop and establish data management policies framework for data products. Include data quality, and data security.* Manage 3 data development teams (up to 36 people)

* Designed database domain solution architecture* Ensuring compliance with the Data Management rules* Designed an application-level replication, data access layer, and database abstraction layer* Designed detailed architecture of a geo-distributed clustering database system with constant availability (master-master, full ACID, strict serializability)

* Design, create, optimize and maintain data models* Design data quality processes and data cleansing* Collaboration with data integration teams* Participation in activities to improve data management

* Created research algorithms of distributed systems* Designed a database engine for Apache Ignite* Designed solutions for MVCC, distributed indexes, point in time recovery, async cross DC's replication, and audited their implementations* Define non-functional and operational requirements* Performed requirement and feasibility analysis* Detailed technical and performance story design* Arranged workshops and presentations

Saint Petersburg, Russian Federation

Perform a range of database development tasks for DWH Swaps Regulatory Transaction Reporting databases (both Exadata and non-Exadata) :* Troubleshooting database-related incidents* Perform database performance tuning – Statspack, AWR, ASH & ADDM* Develop tools for performance monitoring, database check and validation * Perform database design, data modeling, database code reviews* Perform database tests for stability* Liaise with support teams for database server maintenance

Saint Petersburg, Russian Federation

Troubleshooting and performance tuning of Oracle databases.Stress testing, performance auditing of Oracle databases and hardware.Developing and implement the methods for fastest migrations of pure 24/7 production DB. Consultant to customer, engineers, support, customization teams.

Saint Petersburg, Russian Federation

Data Modeling. PL/SQL programming. ETL. Oracle ODI. InformaticaDevelop optimal database solutions to improve system quality and efficiency.Design database logical and physical models; perform capacity analysis and manage database tuning. Write and optimization complex queries, code reviews, reverse-engineering, refactoring. Maintain technical documentations.Project of migration system from Oracle technology (Oracle RDBMS, APEX) to Microsoft technology (MSSQL, dotNet).

Saint Petersburg, Russian Federation

PL/SQL programming.Highload, highly competitive warehouse project.Analyze and design data structures.SQL, PL/SQL programming, code reviews, legacy code refactoring, performance optimizing

Saint Petersburg, Russian Federation

Maintenance of the core business of the enterprise and keep SLA. Analyze and development of architecture. Designs, development, manage and coordination of software and hardware at all stages. Deep understanding of how things work and how to do them in effective way. Team management and development (up to 19 people). About 25 projects.Team lead (up to 11 functional specialists) of OEBS team. Analyze of requirements, deployment system, setting up the environment, user training.Create AIM documentation (RD050, BP080, TE040) .

Master Of Computer Science, Computer Science

Doctor Of Philosophy - Phd, Computer Science