With SQL and QlikSense, the big data is analysed and reported by using high optimized complex queries;The passes and violation passes by Bridge and Motorway (Malkara to Çanakkale)Customer loyality tableCall centre and law offices performance tablePreparing SMS and notice sending data for violation passes.Preparing reconciliation data of General Directorate of Highways.Verifiying data with Toll Collection System and SAPBank reconciliationsVisualization the analysed dataCreating executive dasboards to summarise the actual passes, violation passes and payments.Creating internal website on company server to follow up passes, violation passes and payments.Via the website, the relevant information is viewable for related departments among the company.

With SQL and PowerBI, the big data is analysed and reported by using high optimized complex queries;Worked for Istanbul Smart Cities Project (designing bike rental system at Karaköy)Vakıf Emeklilik Customer Value and Behavior Segmentation