Mirsad Puskar

Project Jaguar Landrover: Extension/Adjustment of the existing DWH

Munich, Germany

Experience

Project Jaguar Landrover: Extension/Adjustment of the existing DWH

Consors Finanz

  • Data modeling in DWH
  • Implementation of data objects and data marts
  • Definition of job chains
  • Coordination of requirements with analytics
  • Performance optimization

Create Operational data store (from scratch; 8 sources) as a basis for new CRM system and future DWH: Architect, Main developer

EIT Health

  • Support ODS implementation (incl. detailed architecture definition)
  • Operational data source with 8 sources: MS SQL DB; rest API, csv files.
  • ETL tool: SSIS, DB: MS SQL
  • Support the infrastructure decisions for data tools and CRM. Define architecture picture for the data interfaces
  • Support rule/process/role definitions for data governance (incl. definition of data catalog structure/features)
  • Analyse data quality issues and define (if possible automatic) processes for data standardisation/profiling/normalization
  • Fuzzy matching created for central objects (contact and organization)
  • Support the definition of agile team and agile project management (SCRUM) incl. DevOps standards
  • Support CRM data model definition
  • ODS data model defined
  • Support the definition of operational/maintenance processes for data topics and CRM
  • Gitea, GIT, bookstack for docu

Create central data Quality Tool (DQT) based on Oracle Apex as frontend and SSIS: Architect, Developer

EIT Health

  • Deduplication (via SQL Server: Fuzzy algorithm)
  • Matching (manual “classification” done in APEX)
  • Import/export: loading of csv file, export to Oracle / SQL Server DBs
  • Collaborative cleaning of data: 1st stage (Different users can access and transform the same dataset)
  • Technical Documentation
  • User manual and help embedded into the App
  • Data normalization with the linking of new values to standard values
  • Basic data profiling
  • Log, changes tracking
  • Basic data transformation (marked for deletion, merge fields)

Data management and governance expert

EIT Health

  • Lead the development of the whole data architecture for all central data systems (ODS, MDM, DQ, DWH)
  • Define the actions for the improvements of data quality in source systems
  • Develop architectural strategies for data modelling, design and implementation to meet stated requirements for metadata management, operational data stores and Extract Transform Load environments
  • Interface with IT and Operations teams to ensure proper coordination of efforts
  • Develop ETL data ingestion pipelines (Sources: relational databases and Rest APIs)
  • Define continuous integration/development rules and pipelines
  • Define operational setup for all central data systems (ODS, MDM, DQ, DWH)
  • Define data government rules and processes
  • Create and test physical/business data models for a variety of business data, applications, database structures and metadata tables to meet operational goals for performance and efficiency
  • Research and properly evaluate sources of information to determine possible limitations in reliability or usability

ODS extension and operation definition: Architect, Main developer

EIT Health

  • Create ETL processes which will support (if possible automatic) ODS operations
  • Define data maintenance processes for central objects/lookups and create Apex applications for Data enrichments.
  • Support ETL implementation (regular automatic job) of MDM data into ODS
  • Support implementation of CRM (CRM interface) data into ODS
  • Work on technical improvements (reengineering) in ODS
Düsseldorf, Germany

Media monitoring expert (Croatia, Kosovo)

European Institute for the Media

  • Definition of media monitoring strategy
  • Training of local media monitoring teams
  • Creation of simple software solutions for the specific media monitoring
  • Reporting of the monitoring results
Munich, Germany

Senior data management expert

Infineon Technologies AG

  • Definition and implementation of the business processes together with partner company via supplier enabling qualification
  • Installation/testing of data transfer routines together with local and partner’s IT (OpenFT, RossetaNet, MQseries, etc.)
  • Installation/programming of local data transfer routines (Shell, Perl)
  • Standardisation & optimisation of supply chain business processes
  • Definition/implementation of logistic/supply chain processes with partners (IT Part)
  • Creation/maintenance of automatic reports & analysis (LOG, Quality, Data monitoring) (Business objects)
  • Creation/implementation/maintenance of data monitoring system (Oracle - PLSQL, ASP, Business objects)
  • Data management trainer (Germany, Singapore)
  • Documentation of internal processes
  • Participation in major IT projects, leading small IT projects
Munich, Germany

LCI Data management expert

LINDE AG

  • Data management activities (data consistency, optimization, reporting, etc.) for projects Ruwais 2 and Ruwais 3
  • Technologies: Oracle, MS Access, SQL, VB, Jasper Reports
Munich, Germany

B2B - Test Data Transfer Cleanup (Project leader)

Lantiq GmbH

  • Data format and data structure definition
  • Data flow definition
  • Middleware implementation with subcons (automatic data transfer)
  • Data conversion and loading (ETL) in current DB (LINUX, Oracle)
  • Support business regarding Data system integration documentation
Munich, Germany

B2B Supplier integration IFX (Project co-leader)

Lantiq GmbH

  • Establish automatic logistical data exchange (Idocs for PO, PO confirm, shipinfo, WIP)
  • Establish automatic data transfer of test data and e-maps
  • Data conversion (based on SAP PI/XI) of IDOC files used for automatic lot creation
  • SFTP/FTP setup
Munich, Germany

BizTalk middleware (Program manager)

Lantiq GmbH

  • Align installation requirements with external partner and local IFR team
  • Support project manager and align activities between different teams (IFR, external partner, project manager, etc.)
  • Setup test and productive flows (MDM→SalesForce; BI, SalesForce<->XML Filer)
Munich, Germany

EBS Replacement Feasibility Study (Project team member from IT side)

Lantiq GmbH

  • Define Lantiq specific requirements regarding new test data DB and application
  • Identify potential software providers
  • Evaluate potential software providers offers, create requirement profiles
  • Define pilot candidates
  • Decide which software will be taken (as pilot outcome)
Munich, Germany

EBS replacement - PDF solutions: New test data DB (Oracle) and frontend (Tibco Spotfire) (Project leader)

Lantiq GmbH

  • Support installation of Application (dataPower)
  • Prepare requirements documentation
  • Define project team and coordinate with carve out activities
  • Setup Data Loading/Preprocessing (ETL) together with software provider
  • Standard Reports/scheduled jobs creation (based on Tibco Spotfire)
  • Conduct administration training
  • Organize end user training (worldwide)
  • Data migration (from old to new database)
  • Setup future IT operations for PDF Solutions
Munich, Germany

EWIS – electronic wafermap integrated system (Project leader, SAP based solution with 6 modules)

Lantiq GmbH

  • Inbound module (with integrated data monitoring)
  • E-map content module (content check, one setup per basic type and site). Only validated maps will be sent to the next site
  • Outbound module (with enabled partial delivery capability)
  • User interface (e-map hunter)
  • Reporting module
  • Archiving module (Saperion)
Munich, Germany

Enterprise Architecture Management (Project leader)

Lantiq GmbH

  • Mapping Biz Functions to IT applications
  • Logical data flow charts per functional domain
  • Document IT infrastructure and link to functional applications
  • Biz evaluation of current tool support
  • IT Roadmaps / needs for action list
Munich, Germany

IT carve out project (team member)

Lantiq GmbH

  • Central contact for all manufacturing/BI IT topics
Munich, Germany

Master data management: Implement Master Data Process & System (Project leader)

Lantiq GmbH

  • Provide MDM based on Microsoft MS-SQL 2012 Master Data Services
  • Configure master data entities comparable to existing prototype
  • Support definition of corporate LQ taxonomy and register => Check (unique) and clear nomenclature
  • Preparation of sample data for each MDM entity
  • Integrate MDM with SAP ERP master data elements: Material Master, Bill of Material, Source list, Purchase Info Record, Quota Arrangement, weekly/daily loads
  • Define Access Control to MDM
  • Support data stewards in loading and cleansing master data objects
  • Implement and manage MDM round table and change management process with data stewards (CR process)
  • Provide necessary MDM Base for product cost calculation
Munich, Germany

Middleware replacement: IBM WebsphereMQ and Fujitsu OpenFT (Project co-leader)

Lantiq GmbH

  • Analysis from existing middleware connections and scripts
  • Setup and configuration of the new middleware environment incl. accessibility for external partners
  • Switch of middleware environment from Infineon to Lantiq
Munich, Germany

Product cost calculation (Project leader)

Lantiq GmbH

  • Calculate product cost forecast as input to product margin reporting
  • Automatic computation of future product cost on FGR Level in order to feed the product margin reporting process based on consistent master data, future price roadmaps from PUR, yield plans from PT, production/supply plan from SC (SAP ERP MRP)
  • Provide reports about historical material movements and production plan per vendor, per technology, per material and product hierarchy in qty and value USD
  • Provide cost (purchase prices and yield) overview per possible manufacturing flow in one sheet
  • Support production cost analysis (based on volumes from supplier; taken the in-/out qty + EOL etc. into consideration)
Munich, Germany

SAP2Cloud (Project member)

Lantiq GmbH

  • Unix/Linux data/scripts migration
  • Label printer: SAP/Unix installation/setup

Clearing reports and performance reporting for real time campaigns: Product Owner/manager

Payback GmbH

  • Define final requirements for clearing reporting and performance reporting
  • Process optimization analysis
  • Improve communication with customers

Data analytics platform (Programmatic Exports, AdServer teaser evaluation): Product Owner/manager

Payback GmbH

  • Define final requirements for data analytics use cases (DWH (Oracle), Smart data platform (Hadoop), Onedata platform (based on Spark)
  • Define the basis for agile project management

Data quality and data dependency monitoring: Product Owner/manager

Payback GmbH

  • Define final requirements for data quality monitoring and data lineage in DWH (Oracle) and Smart data platform (Hadoop)
  • Data model definition

Weather data integration for real time campaigns: Product Owner/manager

Payback GmbH

  • Define final requirements
  • Clarify the internal processes for external APIs (first use of external APIs for DWH team)

DWH Operation stabilization: Lead Architect

ProSiebenSat.1 Applications GmbH

  • Define stabilization activities
  • Define architecture changes
  • Support infrastructure and ETL adjustments

Data Stage (ETL tool) migration (Internal project leader; Quality assurance/Test manager)

ProSiebenSat.1 Applications GmbH

  • Move from IBM DataStage 8.1 to IBM DataStage 11.3 (Prepare/Plan Migration, HW/OS installation, Install DataStage Service & Engine Tier, Migration, Deployment to Production, Performance comparison, Deploy to DEV, Deprovisioning DS 8.1)

MediaFacts – ProMefo replacement (TV coverage and rating analysis system): Technical Lead

ProSiebenSat.1 Applications GmbH

  • IS/SHOULD analysis for Backend and Middleware part
  • Create logical data model
  • Define future system architecture
  • Support requirements analysis (IT counter apart)
  • Technical lead for all 3 modules (Frontend/Middleware/Backend)
  • Member (IT counter apart) of tool/partner decision team

Profil replacement (Frontend replacement of MS OLAP based Sales Information System): Technical Lead

ProSiebenSat.1 Applications GmbH

  • Main counter apart for all technical topics/issues
  • Define final architecture (Backend: SSAS/new Frontend: Arcplan/user rights DB: MS SQL DB)
  • Support requirements analysis (IT counter apart) and backend/frontend mappings
  • Coordinate development activities
  • Create authorization concept (matrix)
  • Member (IT counter apart) of tool/partner decision team
  • EUT for Admin Console

Project Pharos – Data integration framework (Hadoop, Spark, Spark SQL, Scala, Hive, MID Innovator, Data vault): Product Owner/

ProSiebenSat.1 Applications GmbH

  • Product owner tasks for new data integration platform (via Jira)
  • Data model definition for the first use cases (from Landing Zone till Raw Vault)
  • EUT and quality assurance
  • Project architecture decisions
  • Hard/soft rules definition
  • Define Continues Integration process and setup

Project Pharos – Rough architecture concept for new data integration platform (Data Lake(Raw Lake, Standard Lake) & DWH(Raw

ProSiebenSat.1 Applications GmbH

  • IS/SHOULD requirements analysis
  • Architecture model definition with the requirements and concerns
  • Business use cases: ratings and selection
  • Roadmap definition
  • PoC: Data Vault on Spark (Spark, Spark SQL, Scala, Hive)

Sales/CRM Reporting - PortfolioCheck/CustomerFactSheet (Internal project leader/Requirements analyst)

ProSiebenSat.1 Applications GmbH

  • End User requirements analysis
  • Create a prototype based on 20 main customers
  • Create detailed interface specifications and define transformation rules (Sales Force (CRM), ProCommit (Commitment system, Informix DB), Nielsen data (Advertising/Programming monitoring), Oracle DB)
  • Support development phase, EUT, TRR/PRR
  • Quality assurance
  • Create End Reports (Business Objects)

Staging implementation: Extend existing DWH: Technical Lead/Project Lead

ProSiebenSat.1 Applications GmbH

  • Define requirements and final architecture
  • Review Solution design
  • Coordinate project/development activities with external development team
  • EUT definition and execution

Union DB (UDB: Central DWH) Project: Phases 6-12

S-Kreditpartner

  • Requirements analysis
  • Creating user stories and implementation tickets
  • Technical conception and design of the data model and the ETL pipelines
  • Development of ETL processes
  • Application development
  • Quality assurance and testing
  • Second level support
  • Documentation of work results

Sales Funnel subproject in project for new Analytics platform: Product Owner

Volkswagen AG

  • Preparation and Participation in PI Planning
  • Maintaining the team backlog
  • Iteration planning
  • Accepting stories
  • Define requirements
  • Understand enabler work
  • Pushing epics through an agile whole process
  • Prepare legal prerequisites together with respective departments/teams
  • Check data point availability
  • Consult technical translation from business requirements

Summary

  • Very strong analytical and data skills
  • Still ready to learn new things every day
  • Agile development experience
  • Able to work independently
  • Very good team player
  • Ability to see “big picture” and define data strategy

Languages

Croatian
Native
English
Advanced
German
Advanced

Education

Oct 1993 - Jun 1998

University of Zagreb

Dipl. Engineer · Mathematics · Zagreb, Croatia

Certifications & licenses

Apache Spark for Data Engineering

Exasol Developer Training

Scrum Product Owner Training

Tableau Basics Training

MID Innovator Information Architect

Basics of digital business analytics

Big Data with Hadoop

Data Vault 2.0 Boot Camp

Lantiq Leading as an Expert Program

Salesforce admin basics

MS SharePoint 2010 – MS SQL 2008 - Business Intelligence

PDF data power admin training