Senior Consultant

• Apr 2022 - Present

Contract Position – Data Design. Responsible for detailed and iterative analysis of business requirements, and formalization of Data and Process designs for various data integration needs to fulfill client’s adherence to IRFS17 standard. Technologies used daily: Snowflake DB, Wherescape 3D for LDM modelling, data source mapping and model PDM->LDM model conversion rules. Lucid charts for detail process and workflow diagrams Contract Position – Data Design. Responsible for detailed and iterative analysis of business requirements, and formalization of Data and Process designs for various data integration needs to fulfill client’s adherence to IRFS17 standard. Technologies used daily: Snowflake DB, Wherescape 3D for LDM modelling, data source mapping and model PDM->LDM model conversion rules. Lucid charts for detail process and workflow diagrams

Software Architect / BI Team Lead

• Oct 2020 - Apr 2022

BI back-end architecture for a national project of consolidated analytics. Designed initial solution and helped to incrementally expand DataVault 2.0 metodology as the core approach of consolidating data from various elements of Slovak government with respect to consolidated analytics and decision support based on data. Day-to-day cooperation with of BI analysts and ETL developers, also hands-on ETL development. Helping MIRRI (Ministry of Investments, Regional Development and Informatization of the Slovak Republic) with overall BI vision and Data Architecture. People management of a small BI team in Slovakia IT. Technologies used daily: Talend DI, SQL, REST, Oracle 19c EE, IBM Cognos 11.2. Show less

Senior Data Analyst

• Aug 2020 - Sep 2020

Analysis and development of internal SSIS ETL processes and some reports in Microsoft Power BI. Analysis and development of internal SSIS ETL processes and some reports in Microsoft Power BI.

Data Services, Enterprise BI

• Aug 2019 - Jul 2020

Day-to-day support of Business Analysts with technical analysis and solution designs, frequent use of Pentaho PDI, SQL, REST, SoapUI technologies. Most notable project: Designed corporate Data Vault 2.0 for a major corporate alternative payment processing system SA and lead an ETL team to implement. Practical Experience with Oracle Exadata HCC dynamic partition swapping - implemented as part of regular ETL refresh process. Day-to-day support of Business Analysts with technical analysis and solution designs, frequent use of Pentaho PDI, SQL, REST, SoapUI technologies. Most notable project: Designed corporate Data Vault 2.0 for a major corporate alternative payment processing system SA and lead an ETL team to implement. Practical Experience with Oracle Exadata HCC dynamic partition swapping - implemented as part of regular ETL refresh process.

Senior BI Architect / Strategy Consultant

• Feb 2017 - Aug 2019

Primary focus: BI Leadership, Data and ETL Architecture at IKEA Sweden, Order Fulfilment Analytics area. Completed projects: IBM Sterling Adaptive Data Warehouse ETL processes conversion to IBM InfoSphere DataStage; co-lead and co-developed IKEA Order Fulfillment Dashboard (front-end and back-end); Completed POC for IKEA universal ODS data integration layer using DataVault 2.0 methodology. On an ongoing basis involved with cross-teams Analytics leadership. Helping with formulating client’s visions while adhering to the best industry standards. During this engagement also active in helping IBM Slovakia with various pilot, proposal and presales activities. Show less

Senior Data Architect - Consultant

• Oct 2016 - Dec 2016

Contract Position – Data Architect. Redesigned and conformed corporate Food Sales and Energy Sales Data Marts upon detailed business requirements for a major company (20k+ employees) This was my last Canadian contracting position before moving to Slovakia. Contract Position – Data Architect. Redesigned and conformed corporate Food Sales and Energy Sales Data Marts upon detailed business requirements for a major company (20k+ employees) This was my last Canadian contracting position before moving to Slovakia.

Information Management Lead

• Feb 2016 - Oct 2016

BI Leadership and hands-on development on various BI projects ranging from Data Modeling and ETL to Visualizations implementations utilizing wide IBM Cognos suite of tools. Further improved my proficiency in IBM Infosphere family of products via various pre-sales and POC activities. Client’s sample: Edmonton Public School Board, CAE (Canada Defense contractor) BI Leadership and hands-on development on various BI projects ranging from Data Modeling and ETL to Visualizations implementations utilizing wide IBM Cognos suite of tools. Further improved my proficiency in IBM Infosphere family of products via various pre-sales and POC activities. Client’s sample: Edmonton Public School Board, CAE (Canada Defense contractor)

Sr. Data Integration Specialist

• Dec 2015 - Feb 2016

Setting out corporate-wide standards for InfoSphere DataStage development and hands-on lead development of improvements to Daily Marks Warehouse data feeds. Created universal delta oriented ETL framework for the company for other teams to follow, 4+ different major data sources and IBM Netezza as the target. Setting out corporate-wide standards for InfoSphere DataStage development and hands-on lead development of improvements to Daily Marks Warehouse data feeds. Created universal delta oriented ETL framework for the company for other teams to follow, 4+ different major data sources and IBM Netezza as the target.

Senior Business Analytics Consultant (Independent)

• Jan 2014 - Feb 2016

Independent BI Consultant

• Jun 2013 - Dec 2015

Daily hands-on development (IBM Data Stage + almost all of IBM Cognos 10.2.1 toolset) to Data Architecture and Application Design best suited for various needs of the client. Most notable recent project: Scoping, Modeling and Implementing P2 CS Land System as part of Corporate Data Warehouse, ETL via IBM Data Stage (125 Staging tables + 55 DM tables), using Cognos Framework Manager 10.2.1 to facilitate bridged many-to-many relationships, using FM determinants to handle aggregates. The challenge was based in making IBM Cognos Self Serve/Ad-Hoc analytic tools to properly navigate in a non-star/many-to-many schema. Show less

IBM BI Implementation Practice Lead at Penn West Exploration

• Jan 2012 - Jun 2013

Architectural and hands-on involvement in improving client's overall Business Intelligence footprint. Focused on IBM Cognos/Oracle technologies. Responsible for Various Cognos and Data Modeling related work at the client site, Directly Involved in corporate Data Vault architecture and responsible for its implementation (used SAP Power Designer, Oracle PL-SQL Scripting, Oracle Chains) Architectural and hands-on involvement in improving client's overall Business Intelligence footprint. Focused on IBM Cognos/Oracle technologies. Responsible for Various Cognos and Data Modeling related work at the client site, Directly Involved in corporate Data Vault architecture and responsible for its implementation (used SAP Power Designer, Oracle PL-SQL Scripting, Oracle Chains)

Owner / Independent IBM Cognos Consultant

• Mar 2011 - Dec 2011

Principal Consultant

• Jun 2008 - Feb 2011

BI Consultant on various projects or innitiatives: • Client: Ecomm911, Vancouver BC, Canada (December 2010 – January 2011)Converted an existing Cognos Series 7 solution into IBM Cognos Express. Daily use of TM1 TI processes and rules, Report Studio, Excel Perspectives, sourcing MS SQL Server • Client: Westjet, Calgary, Canada (October 2010 – November 2010)TM1 9.5.1 Development, Implemented Westjet Profitability model in IBM TM1, Daily use of TM1 TI processes and rules • Client: Taqa, Calgary, Canada – former Primewest Energy (July 2008 – September 2010)BI Technical Architect. Optimization of an existing ETL process populating a local data warehouse with Oil industry related data, including sources like Cognos Planning, Qbyte, flat files. Developed several Cognos Powerplay cubes. Daily use of Cognos Data Manager, Transformer, Framework Manager, Oracle Analytics SQL • Advisory/Leadership capacity on other existing Newcomp BI projects Show less

Senior Technical Consultant

• Sep 2004 - Jun 2008

• Client: Viterra, Regina SK (Jan 2008 – July 2008)Lead Data Warehouse Architect; Data Modeling Analysis and Architecture of a brand new Data Warehouse using IBM Rational Architect for logical and physical schemas design after 2 companies merger. • Client: Fiskars, Madison WI, USA (Nov 2007)Technical Advisor; Cognos 8.2 multi-server production installation and tuning and Cognos 8 BI Demo project.Optimization of existing PowerPlay 7.3 Cubes (2GB size decreased to 150 MB) with Cognos 8 drill-through into Cognos 8 Report Studio report. Custom Framework Manager modeling • Client: University of Calgary, Canada (Oct 2006 – July 2007)On-site Cognos support, Business Analysis, Modeling & BI applications development. Trusted Agency Reports Development using Cognos 8 RS (MDX) with Powerplay cube as a data source focusing on performance (thousands of Report Studio reports runs were submitted in a short time, 1.4 seconds per report run). • Client: Forzani Group (Dec 2005 – Sept 2006)On-site Cognos support, Modeling, ETL & BI applications development. Using Cognos Decision Stream 7.1 (DS) for development of new summary fact tables and fact feeds for client’s large cubes with full • Client: Amgen Canada (Sept 2004 – Dec 2005)Analysis, Modeling, ETL and Application Development using SQL Server DTS for ETL, sourcing Siebel (Oracle based) Pharmaceutical Field Sales Activity data; Physical model design in SQL server 2000. Developed several Cognos PP cubes with Drill-through to Reportnet 1.1 MR1 (14 multi-sectioned (multi-query) reports). Security Using Cognos Macro language (VB) to build cubes on the fly with any combination of APEX and CLOAK. Other: • Navantis, Toronto-ON, Canada; custom development of Cognos 8 single-sign-on with client’s custom WEB application, via Cognos 8 SDK - done in C# .NET • Boeing, Seatle-WA, USA; on-site Framework Manager and overall Cognos BI corporate architecture 360. • Teaching official Cognos in-classroom Courses Show less

Senior BI Consultant

• 2006 - 2007

Intermediate BI technical analyst

• Feb 2002 - Sep 2004

· Multidimensional Analysis and Reporting (Cognos PowerPlay 6.61, IWR 6.1; Cognos 7.2 with Architect, NCR Teradata ver. 2R5 as data source (tables with billions of rows)) · ETL Development – Mainframe (JCL - 6 months) – involved in large scale corporate Data Model change, Physical Data Model design (3 months – SQL Server) · Microstrategy 7i (7.51 latest) administration and development - 1.5 year in total · Microstrategy 7.5 corporate architecture active involment (1 year in total) · Multidimensional Analysis and Reporting (Cognos PowerPlay 6.61, IWR 6.1; Cognos 7.2 with Architect, NCR Teradata ver. 2R5 as data source (tables with billions of rows)) · ETL Development – Mainframe (JCL - 6 months) – involved in large scale corporate Data Model change, Physical Data Model design (3 months – SQL Server) · Microstrategy 7i (7.51 latest) administration and development - 1.5 year in total · Microstrategy 7.5 corporate architecture active involment (1 year in total)

BI Technical Analyst

• Mar 2001 - Feb 2002

- Custom Entrust PKI implementation for WEB Applications - Cognos PowerPlay and Impromptu WEB Enterprise environment with Microsoft IIS Server on NT - Cubes and reports development (PowerPlay, Impromptu, CrystalReports) - Main support of Applix Enterprise Application, Helpdesk - Call Centre Module - SQL, Visual Basic, C++ - Custom Entrust PKI implementation for WEB Applications - Cognos PowerPlay and Impromptu WEB Enterprise environment with Microsoft IIS Server on NT - Cubes and reports development (PowerPlay, Impromptu, CrystalReports) - Main support of Applix Enterprise Application, Helpdesk - Call Centre Module - SQL, Visual Basic, C++

Network Admin

• 1999 - 2000