Ярослав

YAROSLAV SOKYRKA
[открыть контакты](см. выше в блоке «контактная информация») Lviv, Ukraine
[открыть контакты](см. выше в блоке «контактная информация») [открыть контакты](см. выше в блоке «контактная информация»)

SUMMARY TOOLS
▪ 4 years of experience in ETL development, SQL SQL SQL Server Management Studio
optimization, and BI reporting ETL IBM Cognos Framework Manager,
▪ Proven ability to automate data processing and Astera Centerprise
implement best coding practices Git Visual Studio, Azure DevOps, SourceTree
▪ Proficient in ETL workflows design and optimization DataViz Qlik Sense, IBM Cognos Analytics
and query performance improvement Office Power Point, Excel, SharePoint, Google Docs
▪ Strong expertise in MS SQL Server, Astera Agile Jira, Azure Board, Confluence
Centerprise, and IBM Cognos

TECHNOLOGIES
ACHIEVEMENTS T-SQL, ETL, Power Pivot, Git, CI/CD, Cognos SQL,
▪ Supply Chain: Developed over 50 BI reports, with VLOOKUP, DWH
clear analytical insights for business users
▪ FinTech: reduced routine data processing by 20%
▪ FinTech: Automated the detection of debit and EDUCATION
credit discrepancies National University of Lviv Polytechnic 2016-21
▪ InsurTech: Designed and optimized over 150 ETL M.Sc. – System Analysis
implementations, reducing overall processing time B.Sc. – System Analysis
by 30%

WORK EXPERIENCE VEO
Symfa BI Developer Mar 21 - Nov 21
B2B multinational stock clearance company
Data Engineer Nov 21 – Mar 25
▪ Optimized report structures, improving execution
US-based Fortune 500 insurance giant speed by 20%
▪ Implemented data quality controls, ▪ Designed custom top-management reports
decreasing reporting errors by 25% ▪ Completed training on report development and
▪ Enhanced SQL query performance, reducing data visualization in IBM Cognos Analytics
execution time of key database operations by ▪ Explored and configured data packages in IBM
15% Cognos ETL, enhancing data processing and
▪ Designed and implemented ETL solutions transformation skills
using Astera Centerprise to efficiently process
diverse data sources PWC
Data Analyst Dec 20 – Mar 21
▪ Automated ETL job monitoring, lowering Big4 multinational accounting and auditing firm
incident rates and improving process stability ▪ Automated debit and credit mismatch detection,
▪ Introduced code review standards in the minimizing manual adjustments
team, improving code quality and reducing ▪ Optimized financial data processing, reducing
technical debt analysis and file preparation time by 15%
▪ Communicated results to AVP ▪ Completed intensive training, followed by hands-on
▪ Managed version control and collaborated on experience in financial data processing
development using Git, ensuring streamlined ▪ Performed data cleaning and transformation for
code deployment accurate debit and credit balance reconciliation
▪ Validated financial data integrity by ensuring that
▪ Performed comprehensive code reviews,
the total debit equaled the total credit
improving code quality and adherence to best ▪ Loaded the processed data into Qlik for reporting,
practices analysis, and visualization