Konstantin Lofichenko

- Designed, developed, and maintained scalable data pipelines supporting an Identity Graph platform for customer identity resolution and customer intelligence - community detection logic.
- Designed and implemented the Neo4j graph data model to represent complex customer identity relationships and enable identity resolution at scale.
- Developed and optimized Cypher queries, graph traversals, and

- Led a team of 5 developers delivering financial calculation and reporting solutions.
- Coordinated project planning, task allocation, and delivery to ensure projects were completed on schedule.
- Designed and implemented ETL processes for extracting and loading financial data from multiple source systems.
- Developed data transformation logic using Microsoft SQL Server and stored procedures to s

- Designed and implemented enterprise Data Warehouse solutions on SAP BW.
- Developed data models for retail and corporate banking domains including loans, deposits, savings accounts, repos, and treasury.
- Defined ETL rules for extracting, transforming, and loading data from multiple banking systems.
- Partnered with business users to ensure data quality and reporting accuracy.
- Developed SAP BE

- Participated in the implementation of Kamakura Risk Management for enterprise risk analysis.
- Gathered business requirements and prepared Business Requirement Documents (BRDs) for market risk, credit rating, and provisioning processes.
- Designed ETL workflows for loading data from banking systems into the risk platform.
- Extended the application database schema to support custom reporting req

- Participated in the implementation of an enterprise Data Warehouse based on Oracle dimensional modeling.
- Performed source system analysis and data mapping across core banking, retail, card processing, lending, deposits, and payment systems.
- Designed ETL mapping specifications for IBM DataStage development.
- Conducted data quality analysis and validation throughout the ETL lifecycle.
- Desig

- Developed Oracle PL/SQL solutions as part of a CRM implementation project for Deutsche Bank.
- Designed and implemented database objects including tables, views, packages, procedures, triggers, and indexes.
- Built ETL processes to import data from external systems using SQL*Loader and custom PL/SQL.
- Produced functional and technical specifications for database components.
- Collaborated close