Customer: Cloud computing platform.Project Role: Lead Data Engineer; Cloud solution engineer.Projects: Corporate BI, Marketing analytics.Responsibilities:• Design and implementation of Declarative Data Warehouse framework. Implementation of declarative ETL approach helped significantly improve code quality and increase performance of Analytics team. Switch from Pentaho ETL to declarative ETL development helped analytics to fully focus on SQL logic instead of development in GUI.• Database performance tuning, performance and cost management. Declarative Data Warehouse framework collect performance and cost metrics for all operations performed during data loading and transformation. This metrics helped to detect most expensive queries and optimize them. Average monthly cost for GCP project reduced from 500+ thousands of dollars per month to 20-30 thousand per month.• Implementation of CI/CD practices. Declarative ETL approach helped to implement code review practices on a project and increased a speed of code delivery from development to production environments from week to couple days.• Designed ML model for prediction of technical support tickets counts. This model helped to optimize a workload of internal technical support team and to plan an optimal team headcount growth.• Designed and implemented solution for automatic scan of team’s repositories and network folders for any hardcoded passwords and password files.• Implemented a data clusterization for analysis of text-like information about expenses during employee’s business trips.• Prepared code for public opensource version of Declarative Data Warehouse framework.https://github.com/google/grizzly

Customer: Investment BankProject Role: Team lead; Lead DataBase developer.Projects: Risk&Analysis database development.Responsibilities:• Transformed database development team to database development as a service provider. This transformation helped to save DB/ETL expertise and to provide DB and ETL development service for different customer projects.• Designed DataBase architecture for AXIS_IFRS9 (international financial reporting system) and AXIS_SAPRec (SAP reconciliation) projects.• Improved of database release processes. Implemented CI\CD practices (cross code review, early release build and deployment, integration testing etc) that reduced amount of issues on a project and significantly improved code quality.• Automated database deployment process. Migrated database code to SSDT solution that minimized time and effort required for database release build and deployment.• Improved CREDS-to-QMART ETL process. Switch to SSIS increased speed of data loading and reduced CROSS databases dependencies.• Designed and implemented database housekeeping functionality that reduced disk space usage and improved overall database performance.• Implemented full cycle testing for DataBase and ETL components (unit, performance, integration, security, environment, deployment)• Designed Universal Quick Uploader tool that reduced amount of SSIS packages for support from 400+ to 30. And decreased time required for development of ETL solution in SSIS.• Organized people relocation and knowledge transfer to Prague office. Assisted Project team with screening and finding the right technical candidates for the team and on-boarding them. • As a TechLead participated in project and delivery management activities. Communicated with customer BAs and users, clarified requirements, defined pitfalls, hidden risks and constraints in requirements that could impact projects delivery. • Participated in Database Assessment committee as expert.

Customer: investment bankProject Role: Senior DataBase developer.Projects: CreditRiskIT database development.Responsibilities:• Designed and implemented integration solution for data migration from Basel2 into Basel3 environments. Integration solution contains ETL components and PowerShell scripts for files structure transformations.• Designed and implemented ETL solution for upstream and downstream data processing.• Implemented ETL regression and DataBase performance testing for EAR and QMART projects. Implementation of regression and performance testing helped to minimize amount of project cross dependencies errors and helped to “GO-LIVE” couple months before deadline.• Provided development support during system "Parallel run" and "GO-LIVE" stage.

Customer: Ukrainian retail and corporate banks.Project roles: Team lead; Senior DB developer.Projects: Automatic Bank System "Scrooge-3", Scrooge AnalyticsResponsibilities:• Development and support of Automatic Bank System (Scrooge3).• Maintained a projects documentation.• Designed and implemented integration solutions for data exchange between different banking systems and financial services.• Implemented Factoring Management module.• Designed and implemented Tax Accounting and Financial Analytics modules. Integrated tax reporting with a core of automatic bank system. Implemented functionality for automatic tax reports generation on a base of bank balance. Such integration reduced a risk of penalties for financial organizations.• As a member of delivery team successfully migrated data from banks internal systems into ABS "Scrooge 3" in 10+ Ukrainian banks (UkrGasBank, PUMB, UniversalBank, VTB ...).• During financial crisis of 2008 participated in stabilization of Rodovid Bank and liquidation of UkrPromBank. During bank liquidation procedure transferred all deposit data to RodovidBank.

Technologies: C#, C++, GDI+Responsibilities: development of algoritms for human face detection in visual images, refactoring of existing code and portating it on .Net, development of software for image preparation for follow recognition.