Keywords
Skills
As a data and analytics engineer I worked with various dwh technologies (Snowflake, Teradata, SAP Hana, SQL Server, Oracle), ETL/ELT pipelines languages (like SQL, Python, Bteq, Stored Procedures, C#, PowerShell, REST API, Jinja recently), and ETL/ELT tools (DBT, Data Stage, AbInitio, Informatica PowerCenter, getting familiar with Databricks and Coalesce). I have also performed many optimizations for SQL code, physical/logical data model, or load sequence. I have also trained and lead a group of data engineers. In the analytics environment I am skilled in tools like MicroStrategy or Metabase.
As a data modeler I worked with Erwin and SAP Power designer for modeling semantic/business logical and physical layers for BI or data science usage. I have good knowledge of Kimball, Inmon or Data Vault modeling techniques, and follow new trends like Unified Star Schema.
As a data architect I took part of re-designing of a data warehouse for Data Vault architecture, worked with various scheduling tools (like ActiveBatch, AbInitio, Control-M, recently getting familiar with Airflow), implemented Data Quality Governance end-to-end (testing, DQ dashboard, Monitoring), or supported migration projects from legacy systems to new platforms.
Project history
- Delivery of performance-optimized construction in data marts
- Conception, modeling, implementation, and further development of data warehouse
- SQL development for Teradata and Snowflake.
- Support of the business consultants with technical questions
Azure, Snowflake, Teradata, AbInitio, ActiveBatch, MicroStrategy, Confluence, JIRA, SQL, BTEQ, Python
1. DWH Efficiency Project
- Various architecture and design improvements
- Redesign ActiveBatch implementation
- Support work on new DWH architecture
2. Implementation of Data Quality Governance for Business Intelligence organization
- Implement Data Quality Management process
- Setup and configure data quality monitoring tool (BigEval)
- Setup analytical reports and data quality metrics
BiGeval, MS SQL Server (SSMS), Cognos Apparo Fast Edit, Power BI, Metabase, C#, PowerShell, Rest API, ActiveBatch, JIRA, Confluence
analytics and reporting.
Main tasks:
* data analysis and business documentation
* data modelling and mapping
* SQL coding
Teradata, MicroStrategy, AbInitio, SAP Power Designer, Jira
transformations for given metrics. This was a European Central Bank requirement.
Teradata, Statistics
Nordea internal regulations), regulatory (like FinRep, or IFRS9), and management reporting (like
Customer Profitability or Management KPIs) data aspects. I have also accomplished many optimization
tasks for SQL and Teradata technology usage.
My positive attitude, good communication and friendly personality allowed me to created good
relationship during projects to many co-workers and client employees. The good relationship was very
important for me, as most of the time I worked remotely.
* Delivered end-to-end architecture solution proposal for credit risk analysis tools
* Provided deep data analysis at all data warehouse layers (stage, integration, access) for new
reporting tools and migration projects
* Managed team of 5-10 off-shore ETL developers
* Mentored junior consultants
* Designed and modeled access layers
* Created data mapping documents to be used by ETL developers
* Technology Advisor for developing Semantic Layers
* Optimized SQL code, load procedures, physical data model, logical data model, space consumptions
using various techniques and technology features.
* Developed various load procedures for Shared Business Semantic Layer (Star data model) from
Teradata LDM (3NF model)
Teradata, Essbase, Business Objects, SAP Hana, Data Stage, Jira, MS Office tools
* DW Architecture for BI applications
* SQL development
* Semantic Layer/Application LDM and PDM design
project planning.
* Provided for Microstrategy product suite and its underlying technologies.
* Developed relationships with Microstrategy customers and partners
* Solved problems reported while using Microstrategy product suite through analytical
troubleshooting abilities.
* Prioritized and communicated product defects and enhancements to development teams
Analytics, Oracle Business Intelligence, Bea WebLogic, Oracle WebLogic, Fast Radar, Control-M,
Informatica PowerCenter.
* Managed communication between all projects' stakeholders
* Created and improved Change and Release Management processes for BI technologies
* Coordinated Change and Release Management procedures based on ITIL methodology