Mirsad Puskar - Project Jaguar Landrover: Extension/Adjustment of the existing DWH

Go to Website

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

German

Advanced

English

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

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Similar Freelancers

Discover other experts with similar qualifications and experience

Philipp Grunert