Project Manager

• Jan 2022 - Present

Senior Project Manager

• Feb 2021 - Jan 2022

BI SolutionProject Customer is Europe’s largest logistics service provider for returnable and reusable packaging. Product goal is to provide a standardized, sustainable, scalable enterprise-wide environment for delivery of Business Intelligence (e.g. using commercial information from various external retailers).Responsibilities:• Team recruitment, knowledge sharing and onboarding;• Team meetings facilitation (Daily Scrum, Sprint Planning, Retrospective);• Coordination of planning sessions, reviews and retrospectives of sprint;• Coordination of sprints and releases implementation;• Ensuring the team lives agile values and principles and follows the processes and practices that the team agreed they would use;• Azure DevOps boards maintenance and advanced administration, reporting on team performance;• Communication with the Product Owner and other business stakeholders;• Data modeling, data ingestion, developing and maintaining ETL packages.Environment: MS Azure DevOps, Microsoft SSIS, MS Azure, MS SQL Server, SnowflakeProject results:Creation of a team from scratch: development of team’s expertise in Cloud technologies, assistance in team members’ trainings, resources assignment to internal projects, providing internal knowledge sharing sessions. Show less

IT Project Manager

• Feb 2020 - Jan 2021

Analytical systemSolution is a set of BI technologies for analyzing the national financial information and making key financial decisions, as well as operational recommendations. Platform consists of DWH, BI tools, different web-services and calculation core.Responsibilities:• Project discovery phase, creating project charter and project plan, dealing with vendors;• Pre-sales activities participation, commercial offer creation, estimation;• Coordination, control and administration different teams of project using Scrum and Kanban methodologies;• Coordination of planning sessions, reviews and retrospectives of sprint;• Jira/Confluence maintenance and advanced administration, reporting on team performance;• Backlog and sprint boards administration using JIRA Software;• Participating in requirements sessions with Customers and Product Owners to develop a list of requirements to the System;• DWH architecture design;• Data modeling, data ingestion, developing and maintaining ETL processes for loading data into Data Marts serving for analytics, consumed by IBM Cognos Analytics.Environment:Microsoft Project, Atlassian Jira/Confluence, Microsoft Teams, IBM Cloud Pak for Data (IBM InfoSphere DataStage, IBM Watson Knowledge Catalog), IBM Cognos Analytics, IBM DB2 Warehouse, IBM SPSSProject results:The project was canceled after the first stage of implementation due to the identification of significant disagreements with the Customer. Penalties were avoided. Show less

IT Project Manager

• Apr 2019 - Dec 2020

Real-time marketing solution on Hadoop platformReal-time processing of incoming events from various sources (e.g. mobile app, internet-bank, Call-center, payment systems) on Hadoop platform and implementation of rule engine to provide individual marketing proposals using different notification channels. Responsibilities: • Coordination interaction of different teams of analytics and developers;• Coordination of planning sessions, reviews and retrospectives of sprints;• Backlog and sprint boards administration using JIRA Software;• Reporting and analysis with planning tools;• Participating in various requirements sessions with stakeholders and converting business and functional requirements into technical solutions;• Gathering and clarifying requirements;• Involvement into Data architecture design;• Developing test cases for data verification, testing data validation; • Documentation and administrator/user guides development.Environment: Atlassian Jira/Confluence, Hadoop, Nifi, Scoop, Spark, Kafka, IBM MQ, DroolsProject results:The solution was successfully developed and integrated into the existing environment of the marketing department. Individual marketing proposals using different notification channels tripled and sales grew 4%. Show less

DWH Architect / Data engineer

• Jan 2019 - Apr 2019

Data Warehouse for transport analytical system The solution includes storing dictionaries, fact and planned public transport moving information and allows applications (BI, maps etc.) make visualization of data for business decisions.Responsibilities:• Coordination and leading the team of ETL developers;• DWH architecture design;• Development of processes for extraction data according to business rules and mappings; • Creating complex SQL queries;• Reviewing ETL implementation and results, defects analysis, data validation.Environment: Pentaho Data Integration, PostgreSQL, JavaScript Show less

Team Leader / Data engineer

• Nov 2018 - Apr 2019

Data Warehouse for BI systems of financial companyData warehouse with stored Customer’s information from multiple sources (databases, xml and xlsx files, web-services).Responsibilities: • Participating in various requirements sessions with stakeholders and converting business and functional requirements into technical solutions, along with supporting materials such as designs, models, specifications and reports;• Coordination of international team daily activities, fix pack deployments and infrastructure upgrades;• Data architecture design;• Development and maintaining processes to extract data from multiple sources, planning process load;• Creating complex SQL queries to support ETL development.Environment: Talend Data Integration, Oracle, MS SQL Server, MS Excel, 1C Show less

Team Leader / Data engineer

• Sep 2018 - Mar 2019

Billing system for provider of digital services (Internet and TV)Billing system for provider of digital services that allows to keep and to control financial and technical information, as well as equipment information.Responsibilities: • Coordinate and support planning, approval of detailed design, development, integration, programming, testing, documentation, training and operation of the System;• Development and maintaining processes to extract data from multiple sources and load into the System;• Complex SQL queries development and performance tuning;• Creation of stored procedures and functions;• Exploratory analysis of data sources;• Developing Data Mappings.Environment: Pentaho Data Integration, Oracle, Firebird, MySQL, MS Access, MS Excel Show less

Data Engineer

• Sep 2018 - Nov 2018

Visual analysis studioThe project is an automated system for recording, processing and analyzing information about financial suspicious transactions to special control. Responsibilities: • Development of ETL processes for loading data from various sources;• Performing Data Analysis and developing Data Mapping documents;• SQL queries development and optimization;• Creation of stored procedures and functions using PL/SQL;• Involvement in designing and preparing scenarios, plans, test cases.Environment: Pentaho Data Integration, Talend Data Integration, Oracle Show less

Data engineer

• Feb 2017 - Aug 2018

Data Warehouse for Budgeting and financial planning systemSolution consolidates and centralizes financial information, which can make finance managers to easier produce more accurate budgets and perform “what-if” scenarios for analysis. The goal of the project is to create data warehouse to collect the information from multiple sources and to upload data to IBM Cognos TM1 model for further analytics.Responsibilities:• Developing and maintaining ETL processes and loading to Data Marts;• Databases schema design; • Creation of stored procedures and functions;• SQL queries development and optimization;• Scheduling of loading processes;• Developing test cases for data verification, testing data validation; • Communicating with the Customer, including requirements discussions and status reporting;• Documentation and administrator/user guides development.Environment: Pentaho Data Integration, MS SQL Server, IBM Cognos TM1, MS Excel Show less

Business Intelligence Analyst

• Feb 2017 - Aug 2018

Budgeting and financial planning systemSystem allows to present data on budget implementation based on data generated from the financial and accounting system, according to the scheme applied by a particular entity and at the defined level of data aggregation. Customer is able to create a budget structure through defining budget cells and type-cost items, as well as budget plan for a defined period. The goal of the project is to develop a complex model to cover the forming of Annual Budget and Progress Plan forms.Responsibilities:• Communicating with the customer to develop a list of requirements to the System;• Connection configuration to Customer’s software for historical data export/import;• Development of generic data model using IBM Cognos TM1 Architect and Performance Modeler;• Analyzing financial data to identify relationship between operations and payment trends;• Defining data requirements and report layouts for the business to review;• Development, and implementation TM1 Applications for Financial Planning and Budgeting models with complex rules, creation rules to transfer data between cubes;• Using TM1 rules editor to create and edit rule for various calculations.Environment:IBM Cognos TM1, IBM Cognos Performance Modeler, MS Excel Show less

Senior Client Services Manager

• Jan 2014 - Feb 2017

Responsibilities: • Managing organizational sales by developing a business plan that covers sales, revenue, and expense controls; • Meeting planned sales goals; • Setting individual sales targets with the sales team; • Tracking sales goals and reporting results; • Overseeing the activities and performance of the sales team; • The ongoing training of sales managers; • Developing sales team through motivation, counseling, and product knowledge education; • Promoting the organization and products. Show less

Manager of Sales

• Jun 2011 - Aug 2013

Responsibilities: • Building and maintaining client relations; • Meeting and exceed KPIs and sales targets; • Following organisation policies and regulations that affect the Sales department; • Proactively pursuing new business and sales opportunities. Responsibilities: • Building and maintaining client relations; • Meeting and exceed KPIs and sales targets; • Following organisation policies and regulations that affect the Sales department; • Proactively pursuing new business and sales opportunities.

System and Network Administrator

• Mar 2011 - Jun 2011