Andrey Korabelnik, Principal Architect

Andrey Korabelnik

Principal Architect

Deutsche Boerse AG/Frankfurt Stock Exchange, STOXX

Location
Germany - Frankfurt am Main
Education
Master's degree, Mathematical Methods and Operations Research for Economics,
Experience
23 years, 6 Months

Share My Profile

Block User


Work Experience

Total years of experience :23 years, 6 Months

Principal Architect at Deutsche Boerse AG/Frankfurt Stock Exchange, STOXX
  • Germany - Frankfurt am Main
  • My current job since April 2019

Responsibilities:
- Designed and developed calculation engines for rule-based Selection and Weighting of constituents in stock exchange indices.
Tech stack: Oracle, SQL and PL/SQL
- Designed and implemented Reference Data loading processes.
Tech stack: Oracle, SQL and PL/SQL
- Engineered rule-based index composition processes for DAX/MDAX, STOXX, and bonds indices.
Tech stack: Oracle, SQL and PL/SQL
- Developed calculation processes for Index close value, Market Capitalization, and Adjusted prices based on Corporate Actions (split, merge, dividend) for various index families.
Tech stack: Oracle, SQL and PL/SQL
- Designed and developed an engine for forecasting future index composition based on predicted Corporate actions.
Tech stack: Oracle, SQL and PL/SQL
- Created a set of introspection tools to streamline troubleshooting of the index composition process.
Tech stack: Oracle, SQL and PL/SQL
- Established a Google Cloud Platform Python service application for index composition processes.
Tech stack: Google Cloud Platform, Python, sqlite, flask, google.cloud, functions_framework, pyparsing
- Established a Google Cloud Platform Python service application for corporate actions processing.
Tech stack: Google Cloud Platform, Python, Cloud SQL, fastapi, docker, cloud_run, htmx

Key Achievements:
- Pioneered universal rule-based Selection and Weighting engines, enabling highly scalable domain-agnostic item selection and weighting from customer-provided data. Implementation of the engines led to up 30 times faster performance and easier maintenance of processes.
- Led the redesign of composition rules for the DAX 40 index, resulting in improved performance and reduced calculation times from hours to minutes.
- Successfully revamped the STOXX Indices composition process, resolving performance issues and reducing calculation time for more than 15 thousand indices to less than a minute.
- Initiated the Corporate Actions 90-day Forecast project, optimizing calculation efficiency for STOXX indices composition forecasts. The process is fully automated and provides three quarters forecast for 15 thousand indices in matter of minutes.
- Developed introspection tools to empower non-technical teams to monitor index constituent selection decisions, alleviating the need for extensive technical analysis.

Product Owner at Standard Chartered
  • Singapore - Singapore
  • February 2018 to March 2019

Responsibilities:
- Gathered and analysed requirements.
- Compiled an initial backlog of requirements.
- Led release and sprint planning.
- Ranked, estimated, and prioritized detailed requirements.

Database Developer at Klarna (Banking)
  • Sweden - Stockholm
  • March 2018 to June 2018

Responsibilities:
- Developed ETL processes and supported database procedures.
Project: Product and Valuation Control toolkit Development

Software Developer at ponturo AG
  • Germany - Frankfurt am Main
  • June 2017 to February 2018

Customer: SAP Headquarters, Walldorf, Germany
Role: Software Developer
Responsibilities:
− Developed components for SAP Smart Accounting for Insurance.

Data Architect at Standard Bank of South Africa
  • South Africa - Johannesburg
  • March 2012 to May 2017

Data Architect at a Standard Bank project

Responsibilities:
- Designed a Data Warehouse (DW) for generating reports, dashboards, and cubes for bank subsidiaries in Africa, the central office, and external systems.
- Gathered DW and report requirements.
- Managed and controlled the DW implementation, documentation, and rollout.

Key achievements:
- Established a DW for producing reports in Africa and the central office, offering accurate, reliable, and highly available data.
- Improved DW performance, reducing loading times from 3-4 hours to 1-2 minutes.
- Reduced storage usage by approximately 5 times without sacrificing accuracy.
- Enabled parallel loading of DW structures.
- Ensured scalability to accommodate data from various countries and days without
performance degradation.
- Simplified DW data structures for ease of use by developers with basic SQL skills.
- Implemented data quality control with pre-conditions and post-conditions.
- Designed an adaptable architecture to accommodate new requirements and data sources seamlessly.
- Established thorough auditing of the DW data loading process.
- Documented DW structures and reports for efficient management and testing.

Lead Software Engineer at a Standard Bank project

Responsibilities:
- Designed, developed, and rolled out calculation engines for Impairments, Cost Centre Segmentation, Effective Interest Rate, and Average Balances.
- Generated posting files for SAP with calculation results.
- Sourced data for QlikView and Business Planning and Consolidation.
- Gathered calculation requirements and collaborated with data providers.
- Provided support for the calculators.

Key Achievements:
- Engineered calculators capable of running massively in parallel.
- Created a set of reports for end users to verify calculation accuracy independently.
- Designed calculators for flexibility in making calculation changes without major design modifications.
- Implemented data quality control with pre-conditions and post-conditions.
- Ensured a thorough audit of the calculation process.

Performance Achievements:
- Impairments calculator: Achieved calculations in under 1 minute, meeting the bank's expectations.
- Cost Centre Segmentation calculator: Reduced calculation time from 3 hours to 2 minutes.
- Effective Interest Rate calculator: Reduced calculation time from 2 hours to 10 seconds.
- Average Balances calculator: Reduced calculation time from 2 hours to 10 seconds.

Project Manager, Team leader, Lead Database Developer at PROGNOZ
  • Russian Federation - Perm
  • July 2000 to October 2011

Responsibilities:
- Led a 10-member design, development, and support team for BI solutions using an agile-like methodology.
- Acted as the liaison with clients to gather BI solution requirements and communicated these requirements to the development team.
- Implemented and supported BI solutions.
- Trained and integrated new team members.
- Designed and developed databases for BI solutions.
- Created ETL procedures.
- Troubleshooted performance issues in the database segment of BI solutions.

Key achievements:

- Developed and supported software for cost calculations of a large energy company with approximately 300 users.
- Designed, developed, implemented, and supported a BI solution with a web interface for data analysis for another large energy company with around 500 users.
- Designed, developed, implemented, and supported a BI solution with a web interface for data collection and analysis for a large steel company with 100 users.
- Contributed to the design and development of databases used in the projects, encompassing
auditing, master data management, data warehousing, OLAP engines, ETL procedures,
calculations, security, and document flow systems.

Education

Master's degree, Mathematical Methods and Operations Research for Economics,
  • at Perm State University
  • June 2002

Specialties & Skills

Software Development
Cloud Computing
Business Analysis
Software Design
Database Design
MASTER DATA MANAGEMENT
AUDITING
CALCULATIONS
MANAGEMENT
SQL (PROGRAMMING LANGUAGE)
DATA ANALYSIS
DATA COLLECTION
WAREHOUSING
DATA WAREHOUSING
Database Design
Database Architecture
Google Cloud Platform
Oracle Database
Technical Documentation
Performance Tuning

Languages

English
Expert
German
Intermediate
Russian
Native Speaker

Training and Certifications

Oracle PL/SQL Developer Certified Associate (Certificate)
Date Attended:
September 2010
Oracle Advanced PL/SQL Developer Certified Professional (Certificate)
Date Attended:
April 2011
Oracle Database 11g Administrator Certified Associate (Certificate)
Date Attended:
February 2018
Oracle Certified Expert, Oracle Database 11g Release 2 SQL Tuning (Certificate)
Date Attended:
June 2016
Google Cloud Certified Professional Developer (Certificate)
Date Attended:
December 2023
Valid Until:
December 2025
Google Cloud Certified Professional Architect (Certificate)
Date Attended:
January 2024
Valid Until:
January 2026