Taras K. DB Architect
Database Development
Summary
- Experienced in driving the project from scratch in the financial and pharmaceutical fields.
- Working with data modeling of the DWH structure as well as integration of DWH with the third-party data providers, and ETL tasks. Successful in the architecture definition and infrastructure selection for clients.
- Advanced English.
Experience
DWH Architect
Dec 2019 – now
Responsibilities:
- DB structure design and development based on customer interaction (incl. tables, stored procedures, views,
roles and users, etc.) - ETL design and development (extracting data from public sources as well as from the customer systems based on other DBs). Data loading was realized in parallel threads from the multiple sources
- DataBase/ETL maintenance
- Data monitoring via a custom solution
- DB Performance tuning (Stored procedures and SQL scripts optimization, indexes, tables partitioning, Data loading in parallel threads, etc)
Senior Software Engineer (SAP HANA and BODS), Infopulse
Jan 2016 – Nov 2018
Responsibilities:
- SAP HANA modeling (tables, stored procedures, functions, table-functions, CDS objects, indexes, partitions, replications, etc.) Information contained in this CV is confidential, intended for a specific individual and purpose, and is protected by law. IntellectEU – www.intellecteu.com – pmo@intellecteu.com
- Implementing data models with SAP HANA using an attribute, analytical and calculation views, analytical and SQL privileges
- Data loading and replication into/from SAP HANA via Business Object Data Services
- Implementing performance tuning techniques in SAP HANA
- Technical solutions provided to fulfill business requests using SAP HANA
- Financial reports development using AO and Tableau
- View Dumpers and Validation tools development using VBA
SQL/Report Developer, Dio-soft
May 2014 – Oct 2015
Responsibilities:
- Sensitive investment banking reporting migration/development in Jasper report and Actuate
- Development and performance tuning of SQL procedures and functions
- Dynamic and multi-source reports developed, report combination analysis/ implementation, system clean-up, report/stored procedure optimization
- Page-Perfect migration, multiple output formats
- Undocumented legacy code analysis, refactoring, communicating hidden logic, combine-ability, issues, and caveats to BA/QA, and direct/aided communication with Business Client/Prod Support. Layout, Business logic, financial and mathematical analysis of the migrated reports
- Report Cleanup, improvements, and combination of similar legacy reports
- Full set of Investment reporting migrated, including service and system reports
ABAP developer, Blitz Inform
Jul 2013 – May 2014
Responsibilities:
- Reports(views) development using ABAP language based on customer requirements
CRM-Analyst, Raiffeisen Bank Aval
May 2012 – Jul 2013
Responsibilities:
- Participation in analytical Data Mart development
- SQL scripts for clients target group creation which were used for CRM campaigns commitment
- SQL scripts for analytical report
- Participation in the development and further support of web applications, which is part of the operational CRM system in the Bank
- Operational CRM system update with urgent data
Education
Kyiv National Taras Shevchenko University. Master's degree, Applied Mathematics.
2006 - 2011