Technical Support Engineer

1.

Valentyn Bochkarov
Software Engineer
2025

2.

Jun. 2017 – Jul. 2018
Jul. 2018 – Dec. 2020
Jan. 2021 – Feb. 2022
Mar.2022 - Present

3.

The Experience
4 min.

4.

Technical Support Engineer
…I Know How to Turn Error Messages into Smiley Faces
Jun. 2017 – Jul. 2018

5.

Technical Support Engineer
…I Know How to Turn Error Messages into Smiley Faces
Jun. 2017 – Jul. 2018
Jul. 2018 – Dec. 2018

6.

Technical Support Engineer
…I Know How to Turn Error Messages into Smiley Faces
- Working with technical documentation.
- Communicating complex concepts in simple terms to our users.
Jun. 2017 – Jul. 2018
- Effectively working under pressure.
- Basic understanding of IT infrastructure
- Technical documentation drafting
Jul. 2018 – Dec. 2018
- Compiling bug reports or issues reported by clients

7.

Software Test Engineer
…I Know How to Turn Bugs into Butterflies for a Smoother User Journey
Jan. 2019 – Nov. 2019
Software Test Engineer

8.

Software Test Engineer
…I Know How to Turn Bugs into Butterflies for a Smoother User Journey
Jan. 2019 – Nov. 2019
Dec. 2019 – Dec. 2020
Software Test Engineer
Lead Software Test Engineer

9.

Software Test Engineer
…I Know How to Turn Bugs into Butterflies for a Smoother User Journey
Senior Software Test Engineer
Jan. 2021 – Aug. 2021

10.

Software Test Engineer
…I Know How to Turn Bugs into Butterflies for a Smoother User Journey
Senior Software Test Engineer
Jan. 2021 – Aug. 2021
QA Automation Engineer
Sep. 2021 – Feb. 2022

11.

Software Test Engineer
…I Know How to Turn Bugs into Butterflies for a Smoother User Journey
Acquired Skills:
• Quality Assurance Expertise, validated by the ISTQB
certification
• Automation Skills
• Leadership and Mentorship
• Continuous Learning and Adaptability
• Cross-Functional Collaboration

12.

Software Test Engineer
…I Know How to Turn Bugs into Butterflies for a Smoother User Journey

13.

Personal Development

14.

Personal Development

15.

Personal Development

16.

Personal Development

17.

Software Engineer
…I Know How to Turn Programming Puzzles into User-Friendly Masterpieces
- Consumer Banking
- Corporate Banking
- Global Bank
- Investment Bank

18.

The Project
3 min.

19.

The Project
- Consumer Banking
- Corporate Banking
- Global Bank
- Investment Bank

20.

The Project
PRE-TRADE
AT-TRADE
POST-TRADE

21.

The Project
PRE-TRADE
SignalLens

22.

What does the SignalLens app do?
SignalLens

23.

What does the SignalLens app do?
Client
positions
SignalLens
Market
data

24.

What does the SignalLens app do?
Client
positions
SignalLens
Market
data
SignalLens
trade ideas

25.

How does the SignalLens app work?
SignalLens

26.

How does the SignalLens app work?
SignalLens

27.

SignalLens Technical Stack

28.

SignalLens Technical Stack

29.

SignalLens Technical Stack

30.

SignalLens Technical Stack

31.

SignalLens app Summary
SignalLens

32.

Highlighted Projects

33.

Highlighted Projects
• Optimising Data Retrieval
1 min.
• Implementing Table Partitioning
2 min.
• Moving SQL Stored Procedures to Java
2 min.
• Rule Applier Cloud Service
2 min.
• Current task
1 min.

34.

Optimising Data Retrieval
SITUATION
The application
accumulates an excessive
amount of information that
is not processed within
itself.
TASK
ACTION
RESULT

35.

Optimising Data Retrieval
SITUATION
TASK
Resolve the issue of
The application accumulates eliminating redundant and
an excessive amount of
ambiguous information for
information that is not
ourselves and our
processed within itself.
downstream clients
(services).
ACTION
RESULT

36.

Optimising Data Retrieval
SITUATION
TASK
ACTION
The application accumulates
an excessive amount of
information that is not
processed within itself.
Resolve the issue of
eliminating redundant and
ambiguous information for
ourselves and our
downstream clients
(services).
• Analyze the situation
• Conduct impact analysis
• Review upstream and
downstream
dependencies
• Adjust the code
RESULT

37.

Optimising Data Retrieval
SITUATION
The application accumulates
an excessive amount of
information that is not
processed within itself.
TASK
Resolve the issue of
eliminating redundant and
ambiguous information for
ourselves and our
downstream clients
(services).
ACTION
RESULT
• Reduced the volume of
transmitted information
Analyze the
• Decreased memory
situation
usage
• Conduct impact analysis
• Accelerated serialization
and deserialization
• Review upstream and
processes
downstream dependencies
• Reduced the need for
• Adjust the code
unnecessary networking
interaction

38.

Implementing Table Partitioning
SITUATION
TASK
ACTION
RESULT

39.

Implementing Table Partitioning
SITUATION
Tables containing data
from files quickly grow in
size
TASK
ACTION
RESULT

40.

Implementing Table Partitioning
SITUATION
TASK
Tables containing data from
files quickly grow in size
Implement table
partitioning based on the
date of the record.
ACTION
RESULT

41.

Implementing Table Partitioning
SITUATION
Tables containing data from
files quickly grow in size
TASK
ACTION
• Convert existing tables
into partitioned tables
• Create a table displaying
information about
Implement table partitioning
partitions
based on the date of the
• Modify processes for
record.
handling file data
• Modify the functionality of
the cleaner
• Update autosys jobs
RESULT

42.

Implementing Table Partitioning
SITUATION
Tables containing data from
files quickly grow in size
TASK
ACTION
RESULT
• Convert existing tables into
partitioned tables
• Improved the efficiency
• Create a table displaying
of the data cleanup
Implement table partitioning information about partitions
• Simplified execution plan
based on the date of the
• Modify processes for
for queries
record.
handling file data
• Optimized data
• Modify the functionality of
management system
the cleaner
• Update autosys jobs

43.

Moving SQL Stored Procedures to
Java
SITUATION
TASK
ACTION
RESULT

44.

Moving SQL Stored Procedures to
Java
SITUATION
The challenge of
incorporating a new client
into a set of SQL
procedures.
TASK
ACTION
RESULT

45.

Moving SQL Stored Procedures to
Java
SITUATION
TASK
The challenge of
Transfer logic from stored
incorporating a new client into
procedures to Java at the
a set of SQL stored
application level.
procedures.
ACTION
RESULT

46.

Moving SQL Stored Procedures to
Java
SITUATION
The challenge of
incorporating a new client into
a set of SQL stored
procedures.
TASK
ACTION
Transfer logic from stored
procedures to Java at the
application level.
• Define data formats for
configurations
• Organize configurations
into tables
• Migrate logic to Java
• Conduct testing
RESULT

47.

Moving SQL Stored Procedures to
Java
SITUATION
The challenge of
incorporating a new client into
a set of SQL stored
procedures.
TASK
Transfer logic from stored
procedures to Java at the
application level.
ACTION
• Define data formats for
configurations
• Organize configurations
into tables
• Migrate logic to Java
• Conduct testing
RESULT
Procedures
became more flexible and
easy to configure
• Adding a new client
became a straightforward
process
• Testing became easily
manageable, facilitating
efficient result
comparison

48.

Rule Applier Cloud Service
SITUATION
TASK
ACTION
RESULT

49.

Rule Applier Cloud Service
SITUATION
Duplicating code
responsible for rule
application
TASK
ACTION
RESULT

50.

Rule Applier Cloud Service
SITUATION
TASK
Duplicating code responsible
Extract the rule application
for rule application
logic into a separate
service functioning
autonomously in the cloud
environment
ACTION
RESULT

51.

Rule Applier Cloud Service
SITUATION
TASK
ACTION
• Identify differences and
commonalities in rule
Duplicating code responsible
application
for rule application
Extract the rule application
• Develop a configuration
logic into a separate service
table
functioning autonomously in
• Create a standalone Spring
the cloud environment
Boot application
• Configure the cloud
environment
RESULT

52.

Rule Applier Cloud Service
SITUATION
TASK
ACTION
RESULT
• Identify differences and
commonalities in rule
Duplicating code responsible
application
Successful
for rule application
Extract the rule application
• Develop a configuration
elimination of code
logic into a separate service
table
duplication
functioning autonomously in
• Create a standalone Spring • Enhanced management
the cloud environment
Boot application
of rule application
• Configure the cloud
environment

53.

Current task
SITUATION
Develop a new workflow
TASK
ACTION
RESULT

54.

Current task
SITUATION
TASK
Develop a new workflow
• Check for the presence
of data that meets certain
parameters in two
different tables.
• Extract data and perform
computations
• Store results
ACTION
RESULT

55.

Current task
SITUATION
Develop a new workflow
TASK
ACTION
Create all
• Check for the presence of
necessary tables
data that meets certain
Implement
parameters in two different
application logic using
tables.
Spring Boot
• Extract data and perform
Write tests
computations
Configure
• Store results
autosys
RESULT

56.

Thank you for your attention!