Ярослав

YAROSLAV SOKYRKA
[open contact info](look above in the "contact info" section) Lviv, Ukraine
[open contact info](look above in the "contact info" section) [open contact info](look above in the "contact info" section)

SUMMARY TOOLS
▪ 5+ 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, Power BI, 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 DAX, 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
EVOPLAY BI Developer Mar 21 - Nov 21
B2B multinational stock clearance company
Data Analyst Jul 25 – Aug 26
▪ Optimized report structures, improving execution
International iGaming platform speed by 20%
▪ Owned payment provider routing across ▪ Designed custom top-management reports
regions, maintaining and improving AR for ▪ Completed training on report development and
trust, front and FTD traffic data visualization in IBM Cognos Analytics
▪ Built Power BI dashboards on top of ▪ Explored and configured data packages in IBM
production databases, consolidating statistics Cognos ETL, enhancing data processing and
for reporting and analysis transformation skills
▪ Prepared weekly, monthly and quarterly
reviews in Excel for stakeholders PWC
Data Analyst Dec 20 – Mar 21
SYMFA Big4 multinational accounting and auditing firm
BI Developer Nov 21 – Mar 25 ▪ Automated debit and credit mismatch detection,
US-based Fortune 500 insurance giant minimizing manual adjustments
▪ Optimized financial data processing, reducing
▪ Designed and implemented ETL solutions
analysis and file preparation time by 15%
using Astera Centerprise to process diverse ▪ Completed intensive training, followed by hands-on
data sources experience in financial data processing
▪ Implemented data quality controls and ▪ Performed data cleaning and transformation for
automated ETL job monitoring, improving accurate debit and credit balance reconciliation
process stability ▪ Validated financial data integrity by ensuring that
▪ Introduced code review standards in the the total debit equaled the total credit
team, improving code quality and reducing ▪ Loaded the processed data into Qlik for reporting,
technical debt analysis, and visualization