Nikola Ilic
Selbstständig, Independent Data Platform Consultant and Trainer, Data Mozart
Salzburg, Österreich
Über mich
I'm making music from the data! #PowerBI and #SQLServer addict. Passionate about Data Analysis, Data Modeling, and extracting knowledge from raw data. Extensive experience in the Banking business and the Online Gaming industry, combined with broad IT knowledge. Curious by nature, always motivated to learn the latest technologies and tools and work with talented people. Blogger @ https://data-mozart.com, speaker, Data Engineering, and Business Intelligence enthusiast, interested in mining useful information from structured and less structured data. True football/soccer and Barca fan! Microsoft Data Platform MVP and Pluralsight author.
Werdegang
Berufserfahrung von Nikola Ilic
Bis heute 2 Jahre und 3 Monate, seit März 2022
Independent Data Platform Consultant and Trainer
Data Mozart
7 Monate, Sep. 2021 - März 2022
Manager Analytics
Avanade Deutschland GmbH - ein Joint Venture von Accenture & Microsoft
*Working with complete MS BI stack (SSIS, SSRS, SSAS) in highly complex environment (millions of transactions on daily basis) *SQL Server 2008R2, SQL Server 2016, PowerBI, SSIS, SSAS, SSRS *Developing various business reports for all departments within the company *Creating ETL processes by gathering data from different sources, transforming it and populating the Data Warehouse *Optimizing queries and writing stored procedures for best database performance
6 Monate, Apr. 2016 - Sep. 2016
Database Developer
Ticketmaster/Bakson
* Working with Oracle 11g database in high volume and complex OLTP system for the largest online ticketing system in the world * Writing complex queries, stored procedures and functions in PL/SQL * Creating ETL processes (data extraction, transformation and loading into the database) * Working with MicroStrategy Developer tool for creating complex business reports * Agile development using Scrum methodology
9 Monate, Aug. 2015 - Apr. 2016
SQL & Business Intelligence Developer
AXA Insurance
* Working with MS SQL Server 2008R2 and MS SQL Server 2012 in rapidly growing and fast changing business environment * Writing complex queries, stored procedures, UDF-s and finetuning database performance * Involved in creating ETL processes and datawarehousing * Using complete MS SQL Server BI stack (SSAS, SSIS, SSRS) to fulfill various business requirements * Creating OLAP cubes and preparing diverse reports for all business departments within the company
1 Jahr und 11 Monate, Okt. 2013 - Aug. 2015
Senior Assistant in Chargeback Unit
Postal Savings Bank, j.s.c.
* Responsiible for analysing chargebacks regarding different kind of situations; * Analysis of daily, monthly and quarterly reports generated by processor company, data elaboration and preparing internal reports for Department; * Analysis of individual chargeback cases and acting according to Operating rules of international credit card systems; * Involved in creating internal procedures and rules regarding all kind of client's chargebacks
7 Jahre und 10 Monate, Jan. 2006 - Okt. 2013
Senior Associate in Risk Control and Fraud Prevention Unit
Postal Savings Bank, j.s.c
* Responsible for analysis of suspicious transactions, unusual cardholder's “behaviour” in using credit cards; * Part of the team for creating educational materials for representatives of law enforcement and police; * Communication with representatives of international credit card companies (Visa, Master Card), other banks and clients; * Analysis of reports, generated by vendor, data extraction and preparing internal reports for Department;
9 Monate, Mai 2005 - Jan. 2006
Senior Associate
Postal Savings Bank
Main activities and responsibilities: * Responsible for records of new credit cards applications; * Responsible for credit cards retained in ATMs – analysis of reasons for retaining, communication with clients and other banks regarding these issues
Ausbildung von Nikola Ilic
3 Jahre und 1 Monat, Sep. 2012 - Sep. 2015
Information technology
High School of Electrical Engineering and Computing of Applied Sciences - BSc.
Information Technologies, OO Programming, Databases... Final Thesis: "Implementing OLAP techniques in analyzing usage of credit cards"
Sprachen
Englisch
Fließend
Deutsch
Gut