Taras K. — DB Architect

Expertise in Database Development.

Last verified on August, 2023

Core Skills

SQL

Bio 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.

Technical Skills

Programming Languages	Python, VBA
.NET Platform	VBA
Data Analysis and Visualization Technologies	ETL, Tableau
Databases & Management Systems / ORM	Microsoft SQL Server, PostgreSQL, SQL
Cloud Platforms, Services & Computing	AWS
Amazon Web Services	AWS EC2, AWS Lambda, AWS RDS (Amazon Relational Database Service), AWS S3
Deployment, CI/CD & Administration	Ansible, CI-CD Pipeline
iOS Libraries and Tools	Combine framework
Virtualization, Containers and Orchestration	Docker, Terraform
QA, Test Automation, Security	QA
Platforms	SAP, SAP HANA
Other Technical Skills	My Requests65

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 – [email protected]
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

How to hire with Upstaff

1

Talk to Our Talent Expert

Our journey starts with a 30-min discovery call to explore your project challenges, technical needs and team diversity.

2

Meet Carefully Matched Talents

Within 1-3 days, we’ll share profiles and connect you with the right talents for your project. Schedule a call to meet engineers in person.

3

Validate Your Choice

Bring new talent on board with a trial period to confirm you hire the right one. There are no termination fees or hidden costs.

Why Upstaff

Upstaff is a technology partner with expertise in AI, Web3, Software, and Data. We help businesses gain competitive edge by optimizing existing systems and utilizing modern technology to fuel business growth.

Real-time project team launch

<24h

Interview First Engineers

Upstaff's network enables clients to access specialists within hours & days, streamlining the hiring process to 24-48 hours, start ASAP.

x10

Faster Talent Acquisition

Upstaff's network & platform enables clients to scale up and down blazing fast. Every hire typically is 10x faster comparing to regular recruitement workflow.

Vetted and Trusted Engineers

100%

Security And Vetting-First

AI tools and expert human reviewers in the vetting process is combined with track record & historically collected feedbacks from clients and teammates.

~50h

Save Time For Deep Vetting

In average, we save over 50 hours of client team to interview candidates for each job position. We are fueled by a passion for tech expertise, drawn from our deep understanding of the industry.

Flexible Engagement Models

Custom Engagement Models

Flexible staffing solutions, accommodating both short-term projects and longer-term engagements, full-time & part-time

Unique Talent Ecosystem

Candidate Staffing Platform stores data about past and present candidates, enables fast work and scalability, providing clients with valuable insights into their talent pipeline.

Transparent

$0

No Hidden Costs

Price quoted is the total price to you. No hidden or unexpected cost for for candidate placement.

x1

One Consolidated Invoice

No matter how many engineers you employ, there is only one monthly consolidated invoice.

Ready to hire Taras K.
or someone with similar Skills?

Book a call with Taras K.

Start Hiring