● Design and develop new QlikView dashboards that are based on complex SQL queries - Vertica,MySQL, and Hadoop on the script side. Creating mini data marts in terms of QVD files using ETL processes.
● Qlikview server management and support (Server and Publisher).
● Definition of KPIs, Dimensions, and Measures. - Data Analysis and Data Visualisation.
● Performance improvements for existing Qlikview applications.

Senior BI Specialist

● Leading and development of Qlikview to Tableau conversion project.
● Helping the Anadolu Insurance BI team about errors and performance issues in Qlikview.
● Training Jr. BI Consultant.


Senior BI Consultant

● Tableau mobile and desktop dashboard design, development, sustain, and optimization using Agile and Scrum methodology.
● User access and permission request management, subscription 
 management, and scheduling jobs for dashboards.
● SQL query optimization and Data Blending for Tableau dashboards and worksheets from various data sources like Teradata, MS SQL Server, Spatial (Map) files, etc.
● Quickly adapting business requirement changes to applications.
● Creating, changing, and adapting custom map applications using shape files.
● Helping and mentoring for Qlikview development, design, and sustain for Pepsico.
● Training Jr. BI Consultant.

BI Consultant

● Preparing reports and queries from ERPs (Dynamics AX and SAP) and other applications using the related technologies in the direction of requests from business units.
● Development, implementation, maintenance, and sustain of QlikView / Qlik Sense Dashboards.
● Create DWH like star schemas in the Qlikview environment using data integration processes.
● Qlikview server management and support (Server and Publisher).
● Working closely/one-on-one with non-technical colleagues working in different group companies and industries like metals, logistics, foods, automotive, etc

BI Specialist

 I am highly skilled with the script side of it. Not only I can write Qlikview's own query language effectively but also can use some programming techniques like loops, variables, etc. I can help you write very complex formulas including Set Analysis or variables with parameters on the front side. I have strong visualization expertise that I can create some graphs that is not exist in Qlikview natively. I can help you create PDF reports that can be scheduled. I also have server side expertise that I can help your QMC problems. 

I can help you query various database systems since I have experience with querying many DBMS platforms like MySQL, Teradata, Vertica, MSSQL, Hadoop, etc.

I have a very large experience spectrum with Tableau. I can help you install it from scratch or I can help you organize your user security settings in the management console. I also can help you create beautiful dashboards. Shortly, ask me anything about Tableau.

I have done a couple of proof of concept jobs with Qlik Sense. I am highly skilled with the script side of it since they are same as Qlikview. I can help you write very complex formulas including Set Analysis or variables with parameters on the front side.

Personal details

İlyas Ç.

Summary

Technical skills

Work Experience

Education