← В ленту

Портфолио

KPMG New Zealand

Data Architect / Senior Manager / Team Lead

Zag (former Soltius NZ Ltd)

BI Consultant

SAP

Technical Support Consultant

Скиллы

Alteryx
Analytics
AWS
Azure
Business Analysis
Business Intelligence
Business Objects
Business Requirements
Consulting
Data Analysis
Data Architect at Metlifecare
Database Administration
Database Design
Databases
Data Migration
Data Warehousing
dbt
Enterprise Software
HANA
Integration
Java
Kimball Methodology
Machine Learning
Matillion
Microsoft SQL Server
Netezza
Oracle
Oracle DB
Performance Tuning
PL/SQL
Power BI
Python
Requirements Analysis
SAP
SAP BusinessObjects
SAP BusinessObjects Enterprise
SAP Data Services
SAP Information Steward
Snowflake
Solution Architecture
SQL
SQL Server
SQL Server Integration Services (SSIS)
Tableau

Опыт работы

Data Architect
12.2020 - 09.2021 |OSS Group
New Zealand consultancy firm • Architecture and design of analytical solutions using Talend product stack. Implementing Data Quality strategies with Talend DQ components. • Designing and developing data integration pipelines on Snowflake for one of the biggest insurance companies in New Zealand. Translating business requirements to data product solution design. • Designing and developing data integration Cloud solutions: AWS
Data Architect
2020 - 2021 |Metlifecare
Metlifecare is one of New Zealand's largest retirement village providers owning and operating 32 retirement villages • Architecture design and implementation of new data platform: cross-cloud solution (GCP, Azure) based on Snowflake using Fivetran as main data integration tool. • Data modelling and development using dbt • Designing solution to accommodate data coming from 10+ source systems (Dynamics Finance, CRM, GA4, Marketo, Care systems, Finance systems, custom data sources)
Data Architect / Senior Manager / Team Lead
2017 - 2020 |KPMG New Zealand, http://kpmg.co.nz/
.
KPMG International Cooperative is a multinational professional services network, and one of the Big Four accounting organizations. • BI / Data Engineer team lead on various tax, audit, advisory projects • Designed, architected and implemented Cloud DWH solution on Snowflake (AWS) using custom developed ETL orchestration framework (Python). • Team Lead of automated cloud BI solution development on Azure using Databricks, Azure Data Factory and Power BI • Designed and implemented data integration processes and Cloud based DWH solution (GCP BigQuery) supporting analytical capabilities for one of the biggest NZ retailers
Senior BI Consultant
2016 - 2017 |Qrious Ltd
Consultancy firm providing cloud based analytical solutions and services. • Spark / Skinny DWH ETL Development: AWS Matillion on Redshift • Architecture design and implementation of DWH solution using SSIS / SQL Server for national branch of a global company providing fuel card and workforce payment products and services. • Developed data integration and report delivery pipeline using AWS Redshift, AWS Lambda and GCP spreadsheets for NZ Streaming Service.
ETL Developer
2014 - 2016 |2degrees Mobile, https://2degreesmobile.co.nz/
.
Telecommunications provider that operates in New Zealand. • ETL development: SAP Data Services. DWH migration: Oracle to Netezza.
BI Consultant
2014 - 2016 |Zag (former Soltius NZ Ltd), https://www.zag.team/
.
One of the NZ leading consultancy firm specializing on SAP and cloud based analytical solutions. • Data migration project: 16 internationally distributed ERP systems into SAP Business Suite on HANA using SAP Data Services 4.2
Technical Support Consultant
2009 - 2011 |SAP, https://www.sap.com/
.
Multinational software corporation that makes enterprise software to manage business operations and customer relations. • Provided technical expertise on SAP BO Reporting tools: Webi, Deski, Crystal, XCelsius, Universe design. • Deployed and configured complex environments (SAP BusinessObjects Enterprise 3.x, 4.x). • Developed workarounds for products bugs and limitations (SAP BusinessObjects product stack). • Worked as a Functional Expert for Delivery of Onsite and Remote Services for top-tier customers.
Oracle DBA Team Lead
2005 - 2008 |East Line Group, https://www.dme.ru/en/
.
An airport infrastructure business in Russia. It operates in Domodedovo International Airport near Moscow. • Led few migration projects from various DBs to Oracle. • Responsible for managing DBA team supporting critical airport systems. • Designed and implemented company DB backup and disaster recovery strategies. • Was responsible for Oracle DB performance tuning.
Oracle Developer / DBA
2003 - 2005 |National Department of Education, https://depobr.gov35.ru/
.
Information centre of the department of education provides technical support of Russian Unified State Exam. • Modelling and implementing DWH solution • Developing ETL pipelines in PL/SQL
DBA
2001 - 2003 |Sberbank, https://www.sberbank.ru/en/
.
State-owned Russian banking and financial services company headquartered in Moscow. Largest bank in Russia and Eastern Europe, and the third largest in Europe. • Administering multiple SQL Server and Oracle databases for the regional Sberbank branch

Образование

Informatics and Computer Engineering (Бакалавр)
Vologda State Technical University (Russia)

Языки

АнглийскийСвободно владею