Особисті дані приховані

Serhii Orel
Data Engineer/Database Developer

Phone: [відкрити контакти](див. вище в блоці «контактна інформація»)
Email: [відкрити контакти](див. вище в блоці «контактна інформація»)
Skype: sergiyorel
Telegram: Serhii Orel

Summary of Qualifications
• Strong knowledge and experience with high loaded OLTP database design and building;
• Hands-on experience in writing complex SQL queries with DDL, DML (including the ability to write/debug complex stored procedures, functions, views, triggers), incidents & error handling;
• Strong experience in OLAP database (DWH) design and building, ETL process (incl. dimensional data modelling, staging);
• Prior knowledge and hands-on experience with SSIS packages creation (extracting data from OLTP database, data processing and populating into OLAP database);
• Report building in Power BI.
A highly motivated, adaptable and results-oriented individual who combines high energy 'can-do' attitude and widespread knowledge of the database engineering with strong communication, analytical and problem solving skills.

Payment industry background as a bonus.

Skills
Programming Languages/Technologies
• SQL/T-SQL
RDBMS
• MS SQL Server
• SAP (Sybase) SQL Anywhere
Methodologies
• Agile, Scrum
• Waterfall
Tracking Tools
• MS Azure DevOps
• JIRA/Confluence

Development Tools
• MS SQL Server Management Studio 10/18
• MS SQL Server Integration Services (SSIS)
• MS Power BI
Version Control Systems
• Git, MS Visual Studio(TFS)
Soft Skills
• Result-oriented
• Highly motivated & adaptable

Experience / IT related educational practice
ERC Distribution (Database Engineer)
[2022-09-15 – still working ]
Project Description:

Wide range of projects and single tasks connected with development of existing companies management system solution which covers different areas of company business activities: purchasing process and collaboration with vendors, warehouse processes, processes of sale, shipment & delivery of goods/services to customers, pricing and promo, product catalog, document flow, accounting and financial reporting (incl. P&L), service center module, etc.

Project Role:
Database/ETL Engineer

Responsibilities:
• OLTP/OLAP database design and modeling
• Writing/updating complex SQL queries (incl. creating /debugging stored procedures, functions, as well as tables, views, triggers) within OLTP database
• ETL process and solution engineering and SSIS packages creating
• Experience with web service standards (JSON, XML), SQL Server tools (like Profiler)
• Modify databases according to requests, and conduct tests.
• Troubleshoot and resolve database usage issues and malfunctions.
• Interaction with the cross functional team actively to understand the requirements and translate to DB work items.

Project Team Size:
5-7 team members

Tools & Technologies:
SQL Server Management Studio (SSMS), MS Visual Studio, SQL Server Integration Services (SSIS), MS Azure DevOps
Experience / IT related educational practice
SoftServe IT academy (Database Developer Internship)
[2022-03-23 – 2022-07-12]
Project Description:

The purpose of the project was to create a system that could satisfy business needs of online store “Apple Store”.
Project Role:
DB Developer

Responsibilities:
• OLTP/OLAP database design
• Creating tables, stored procedures, views, triggers, functions
• ETL engineering
• Creating SSIS packages
• Creating reports in Power BI
Project Team Size:
9 team members

Tools & Technologies:
SQL Server Management Studio (SSMS), Visual Studio, SQL Server Integration Services (SSIS), Power BI, Jira, Confluence, GIT
Project Description:

JSC «Raiffeisen Bank», JSC «Piraeus Bank», JSC «Alfa-Bank», JSC «UkrgasBank», Payment card product owner
[2006-10-11 – 2022-09-12]
Payment industry professional with extensive 15 years experience in card product/project management at international banks (Raiffeisen Bank, Piraeus Bank, Alfa-Bank and UkrgasBank).
Project Role:

Product manager/owner
Responsibilities:
• Hands-on experience in consumer and commercial payment card products creating/launching;
• Projects planning/prioritization and implementation;
• Card strategy development/execution, P&L management, budget management;
• CBA analysis of new card product implementation;
• Creation of reports & data analytics for business decision making (using SQL statement);
• Payment card business change management, development of new business processes/procedures concerning payment card selling/supporting;
• Preparation and delivery of business requirements, test scenarios, cases under agile and waterfall methodologies, analytical support for new card products/services implementation;
• Experienced in end-to-end process of transformation projects from requirements gathering through to post-delivery support including static and financial data migrations;
• Direct experience in Card business, Project management, Digital business, SME banking, PI banking. Strong skills in Risk management, Sales, Core/Back-end banking systems and Regulatory issues;
• Successful implementations of products, software systems and complex applications;
Project Team Size:
20 team members

Tools & Technologies:
SAP (Sybase) SQL Anywhere, MS Excel, MS Project, MS Visio, Banking Core systems.

Languages
English (Intermediate)

Russian (Fluent)

Ukrainian (Native speaker)

Education
Kyiv National University of Trade and Economics (2002 – 2007)
Higher education, Specialty: Banking, Master of Banking.

SoftServe IT academy Internship (March, 2022– July, 2022)
Specialty: Database Developer

Additional education (courses, trainings, certifications)
Certificate: Series UE № 8821/2022
(Click to verify https://career.softserveinc.com/uk-ua/certification/verification)

Certificate: Transcript ID#:14300183
2022-07-06

Courses:
Coursera «SQL Basics for Data Science Specialization (Offered by University of California, Davis)»

Hobbies
Si-fi books, Swimming /Gym, Cooking