E-mail: alex@dwhdev.com
Location: Kyiv, Ukraine
Telegram: https://t.me/otarabanovskyi
Date of birth: 05.08.1980
OLEKSANDR TARABANOVSKYI
GOAL
To obtain position of Data Architect
SKILLS &
EXPERIENCE
SUMMARY
10+ years of software development experience;
Team management/leadership;
SDLC, Scrum;
Database development: DWH, OLTP;
DBMS: Oracle, Postgres, MS SQL (all services), Sybase IQ, SAP HANA;
ETL development: INFORMATICA, MS SSIS, SAP BODS;
Business Intelligence; Data mining (SSAS);
Reporting development (MS SSRS, Oracle Apex, Cognos);
Programming languages: T - SQL, PL/SQL, UNIX shells, Python;
Version Control System: SVN, GIT, TFS;
Operating systems: Windows, Linux;
Strong knowledge of bank domain;
English – Intermediate.
JOB
EXPERIENCE
Diceus, DWH Architect / Team Lead
February 2019 – present
Project: Data Warehouse for BI Reporting and downstream systems of large retail bank. Full
cycle delivery, starting from high-level requirements definition and through to detailed
technical design and implementation.
Role: DWH Architect / Team Lead.
Responsibilities:
DWH Architecture design
DWH frameworks design and implementation
Integration with upstream/downstream systems
SDLC the best practices driving and implementation
Architecture/Code review
Backlog management / Sprint planning
DWH main frameworks implementation
CI implementation
Generation proposals for project extension, delivery scope planning
Technologies:
DBMS: Oracle
Languages: PL/SQL, Python, Unix shells
BI: OBI EE
Page 2
Bus: Oracle Advanced Queueing
VSC: GIT
Reporting systems: Oracle BI
JOB
EXPERIENCE
National Health Service of Ukraine, DWH Architect / Team Lead
December 2020 – November 2022
Project: Data Warehouse for BI Reporting and interfaces for external systems. Full cycle
delivery, starting from high-level requirements definition, DWH architecture and interfaces
design and implementation.
Role: DWH Architect / Team Lead
Responsibilities:
DWH Architecture design
DWH frameworks design and implementation
Integration with upstream/downstream systems
SDLC the best practices driving and implementation
Architecture/Code review
Road maps creation/Project scope planning
Backlog management / Sprint planning
DWH main frameworks implementation
CI implementation
Generation proposals for project extension, delivery scope planning
Technologies:
DBMS: PostgreSQL
Languages: PG/SQL, Python
BI: OBI EE
VSC: GIT
REPORTING SYSTEMS: ORACLE BI
JOB
EXPERIENCE
Infopulse, BI Software Engineer / Team Lead
April 2016 – August 2018
Project: Data Warehouse and BI Reporting for one of the worldwide known audit Big Four
companies providing audit, tax, consulting, and financial advisory services. Full cycle
delivery, starting from high-level requirements definition and through to detailed technical
design and implementation.
Role: BI Software Engineer/ Tech Lead.
Responsibilities:
Delivering code covered requested functionalities
Integration of delivered functionalities
SDLC issues investigation
Technologies:
DBMS: SAP HANA
ETL: SAP BODS
Reporting systems: Analysis for MS Excel
JOB
EXPERIENCE
Luxoft Ukraine, Software Engineer / Team Lead
December 2012 – November 2015
Page 3
JOB
EXPERIENCE
May 2015 – November 2015
Project: Database for exception reporting of large investment bank. Dynamic start-up with
an evolution design. Full cycle delivery, starting from high-level requirements definition and
through to detailed technical design and implementation.
Technologies:
DBMS: Oracle
Languages: PL/SQL
VCS: SVN, GIT
Role: Team Lead
Responsibilities:
Team management / leadership;
Communication with customer;
Requirement gathering and analysis, team scope preparation;
Architecture / technical design;
Tasks decomposition and assignment.
December 2012 – May 2015
Project: Data Warehouse for regulatory reporting of large investment bank. Full cycle
delivery, starting from high-level requirements definition and through to detailed technical
design and implementation.
Technologies:
DBMS: Oracle
Languages: PL/SQL, Unix shells
ETL: Informatica
BI: Cognos
Bus: JMS, MQ
VCS: SVN, GIT
August 2014 – May 2015
Team: Support Level 3 Development Team
Role: Group Manager
Team Responsibilities: Development support level 3 for Production environment (issues
investigation, root cause analysis and remediation, steps planning; bug fixing).
Personal Responsibilities:
Backlog analysis;
Production issues investigation;
Bug fixing;
Mentoring;
Technical consulting.
April 2013 – August 2014
Team: Automation & Maintenance
Role: Team Lead
Page 4
Team Responsibilities:
Automation of checks and analytical / notification reports:
o Business flows End-To-End checks;
o Automation of workflows checks, analytical reports and target
notifications by result;
o Automatic checks for data consistency in Trade Data Warehouse;
Ad-Hoc business solutions for customer (Development contingency).
Personal Responsibilities:
Team management / leadership;
Software delivery for internal and external product owners;
Requirement gathering and analysis, team scope preparation;
Tasks decomposition, sprints planning, backlog grooming;
Architecture / technical design;
POCs preparation;
Code and documentation review.
December 2012 – April 2013
Team: Operation DEV
Role: Database/ETL Developer
Team Responsibilities: Development support for all non-prod environments
Personal Responsibilities:
Technical design documentation writing;
Development support for non-production environments;
Daily checks: data consistency in Trade Data Warehouse, workflows
issues investigation;
Environment health reporting for customer.
JOB
EXPERIENCE
First Ukrainian International Bank, Tech Lead
February 2011- December 2012
Project: CRM data warehouse for retail business, analytical solutions and reports for
marketing campaigns.
Team: Customers analytics and cross-selling
Role: Technical Lead
Responsibilities:
DWH architecture design
Sync processes design
Technical design and development: DWH, OLAP, ETL, Reports
Analytical business solutions on DWH (portfolio analysis; P&L
analysis; marketing campaigns creation)
Technical consulting
Mentoring
Page 5
Technologies:
DBMS: Microsoft SQL Server, Sybase IQ
Languages: T/SQL
Reporting systems: MS SSRS
Data mining: MS SSIS
Bus: SQL Server Service Broker
JOB
EXPERIENCE
VAB bank, Database/ETL/Reporting Developer
March 2008 – February 2011
February 2009 – February 2011
Project: Global Data Warehouse (basic customers: retail/corporate risks, liquidity risks,
finances, treasury, economic security), analytical reporting portal on DWH.
Team: Analytical systems, IT Department
Role: Database/Reporting Developer
Responsibilities:
DWH design and development;
Performance tuning;
Requirement gathering and analysis;
Reporting development;
Ad-Hoc reports development
Technologies:
DBMS: Oracle
Languages: PL/SQL, Delphi
Reporting systems: Oracle Application Express
March 2008 – February 2009
Project: OLTP database for Management and Information System (MIS) of retail risks.
Online highlighting of loan risks and credit portfolio analysis.
Team: DEV team, Retail risks department
Role: Database/ETL Developer
Responsibilities:
OLTP database design and development;
Performance tuning;
Requirement gathering and analysis;
Reporting development;
Ad-Hoc reports development
Technologies:
DBMS: Microsoft SQL Server (all services include Full-text search)
Languages: T/SQL
Reporting systems: MS SSRS
ETL: MS SSIS
Version Control Systems: Team Foundation Server
Page 6
JOB
EXPERIENCE
the Kharkov linear productive management of main gas pipelines, Software Engineer
April 2004- March 2008
Role: Software Engineer.
Responsibilities:
Standalone applications development by request
System administration
Technologies:
Languages: Borland Delphi 7, VBA
DBMS: Oracle
OS: Windows Server 2003 (Active Directory)
JOB
EXPERIENCE
Khartep, Developer
March 2003- April 2004
Projects: software development for the systems of automatic control, introduction of the
systems of automatic control (domains: Metallurgical Industry, Subway, Chemical Industry).
Role: APCS Developer
Responsibilities:
Delivering code covered requested functionalities
Integration of delivered functionalities
Development of frameworks for QA automation
Technologies:
Languages: C++ Builder, Simplicity Plant/Machine edition, Fix,
LabView, Step 7
EDUCATION
National Technical University “Kharkov Polytechnic Institute”
1997 - 2003
Specialist Diploma in Automated Process Control System (APCS)
Luxoft Internal Trainings
2012 - 2015
7 Step to Leadership
Software development methodologies
Informatica Power center Level 1
Java Level 1,2
LANGUAGES
English – Intermediate, Russian – Native
PERSONAL
SKILLS
Leadership - The ability to establish a team effort that promotes working
towards a common goal.
Creative Thinking - Ability to look outside the box
Personal Credibility - Takes responsibility for actions
Results Oriented - Achieves goals in a timely
Page 7
Risk Management & Assessment - Taking action to evaluate and minimize
risks to a project
Empowers Others - Gives employees confidence