Sergei Turivnyi

Senior Software Engineer

Gazpromneft - Digital Solutions•  December 2020 - October 2022

- Led the deployment, maintenance and integration processes of Informatica Enterprise Data Catalog and Alteryx Connect; - Examined data sources for possibilities and risks of thier integration with data catalog, and presented expert opinion to stakeholders; - Created conceptual, logical and physical data models; - Used MIMB connectors (JDBC, ODBC, etc.) and developed custom ETL pipelines to integrate data catalog with various data sources including RDBMS (MSSQL, Oracle, PostgreSQL, Cassandra), information systems (BI, ERP, Planning) and files (CSV, JSON, XML); - Configured and maintained ETL pipelines (Informatica Developer, Alteryx Designer, SQL, Python) to transfer data from data catalog to business glossary; - Used Big Data tools (Hadoop: HDFS, HBase; Apache Spark; Solr; Yarn) for storing and processing large data sets, resource management, data indexing and processing; - Deployed, configured and maintained Informatica EDC, IDQ, Agent, Developer; Alteryx Connect and SAP PD on multiple environments of Linux RHEL and Windows servers (Shell); - Configured and executed CI/CD pipelines (Jenkins, Azure DevOps) to deliver updates to PostgreSQL server; - Provided access to users and conducted technical meetings with stakeholders and vendors; - Used Jira and Confluence for team collaboration and Agile (Scrum, Kanban), Waterfall methodologies.

Software Engineer

Orimi Trade•  April 2020 - December 2020

- Modified DWH architecture and optimized its performance (indexes, constraints, etc.) using MSSQL Server; - Configured and optimized performance of OLAP Cubes by developing and creating dimensions, measures, formulas (MDX/DAX), partitions, etc.; - Wrote complex T-SQL queries and built SSRS reports; - Created ETL workflows using SSIS packages and stored procedures; - Analysed data sets for data artifacts; - Worked with Excel Pivot Tables; - Used Git for version control, Redmine for team collaboration and Agile (Kanban) methodology.

Software Engineer

KORUS Consulting•  January 2016 - March 2020

- Created objects and scripts for Oracle Hyperion Planning using Essbase and Oracle SQL, and developed ETL processes using ODI; - Deployed and maintained the TXTPlanning system, MSSQL Server, SSAS, and developed planning models using OLAP (dimensions, measures, formulas (MDX), etc.); - Wrote complex MDX and SQL queries for data analysis, created ETL workflows and Powershell scripts, and worked with Excel pivot tables; - Created modules, objects and scripts (X++) for Microsoft Dynamics AX 4.0/2009/2012 R3; - Maintained environments and communicated with stakeholders; - Used Redmine for team collaboration and Agile (Scrum, Kanban) methodology.

Software Engineer

TOPS Consulting•  January 2015 - January 2016

- Created modules, objects and scripts (X++) for Microsoft Dynamics AX 4.0/2009/2012 R3; - Maintained environments and communicated with stakeholders; - Used Redmine for team collaboration and Agile (Scrum, Kanban) methodology.