KEREM ERBOKE

**** ********* **. ********, ** L*H 1K4

Tel: 647-***-**** ● aczc1q@r.postjobfree.com ● www.erboke.net ● https://ca.linkedin.com/in/keremerboke

VBA - C# - SSRS - SQL - XAML

Quality focused professional with 10+ years of global experience in 24/7 environments, in multi-national companies like PwC, G4S and Colgate Palmolive as Business Intelligence architect, System Analyst, ERP Consultant, Application developer. Proven ability across various positions to create and deliver solutions that cut costs, improves access, reduce downtime and aid users. Comfortable operating in a wide range of platforms and environments.

CORE COMPETENCIES

SSRS

QlikView Dashboard design

C#.Net / VB.Net

SQL

Advanced Excel

WPF

QlikView Management Console

Troubleshoot management

XAML

ASP.Net

Business Intelligence Tools

qvExcel

EDUCATION and TRAINING

POST-SECONDARY

Business Intelligence Program, Humber College (2016)

.Net Development Bridging Program, Humber College (2016) (88/100 GPA)

Master’s Degree (MSc.), System Analysis – Istanbul Technical University (90/100 GPA)

Bachelor of Science (BSc.), Meteorology Engineering – Istanbul Technical University

CERTIFICATIONS

MTA 98-361 Development Fundamentals (2016)

MTA 98-364 Database Fundamentals (2016)

VOLUNTEERING

Website design for immigration agency: Design Immigration, Mississauga, 2016

http://www.designimmigration.com/

Marketing mass mailing technological support for Halton Jazz Singers, Oakville, 2016

TECHNOLOGY SUMMARY*

Operating Systems: Windows 7+, Ubuntu 8+, AIX v4.3

Programming Languages: C# v5, VB.Net, ASP.Net, VBA, LN 4+

Framework: .Net 3.5, MVC, ORM (EF v6)

Database: SQL, Lotus Notes 7

Foundations: WPF, XAML, Winfoms, Webforms

Server: Windows 2012, SQL Server 2012, QlikView v11

Internet: HTML v4, JavaScript, CSS, Bootstrap

Reporting: QlikView v11, MS Report Definition, SSRS, DTS (prev. version of SSIS), rdlc, SSIS

Applications: IDE VisualStudio 2008+, MS Office (Visio, Excel, Access, PowerPoint, Outlook), MRM (Mobile Resource Monitoring)

ACCOMPLISHMENTS

Work with consultant team for MS Navision vertical module implementations

Developed Dashboards for different G4S clients in QlikView v11 by pulling the data from different SQL servers

Created Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.

Took active role during the data pruning processes

Developed of SSIS Packages for integrating data using OLE DB connection from Excel, CSV, flat file, Text Format Data

Wrote complex SQL queries involving multiple tables

Routine Report development for multiple LoS in SSRS and excel (sumifs, index, ADO connnections)

Developed an Timesheet application by using XAML and C#

Re-designed business workflows by creating .Net reporting applications

Built own ETL applications to transform/load data between different sources

Created tournament application for FBVTT sports club (VBA and VB.net)

Developed report applications in C# for MS Navision v5.5 and QlikView v11

Used qvExcel for quick report development

QMC (QlikView v11 management console) operations including license management

Prepared CED reports in IFS (ERP) using Excel VBA and macros

Deep ODBC and OLEDB knowledge

Developed HR Performance Management Workflow System for Europe region and won a global award

EMPLOYMENT SUMMARY

Fisher and Ludlow, Software and BI developer, Burlington 2016 -

Contributions:

•Redesigning an application written in XAML and C#

•Development of new functionalities in ERP system by using WiSys SDK

•SSRS report development by using best practices

•Landing page design by using WPF and C#.Net

•Several different ASP .Net application

•ETL operations by using SSIS data move from flat files to SQL Server

•TFS implementation for 5 users

•VBA development for financial reporting

•Monthly report submission

DYNACARE, Temporary Contractor (IT Analyst), Toronto 2016 (3 Months)

Contributions:

•Developing a landing page UI with bootstrap and JS for SSRS reports

•Working for SCCM to implement of 2008 and 2012 servers compliance

•Using ShowUI module to provide GUI of PowerShell script (v3+ and Xaml in v5)

•Working as a member of application support team by providing administration of FreeDocs Healthcare document management system and DTS data mapping

G4S, IT Manager, Istanbul 01/2013 – 05/2015

Job scope: Management of ERP and Helpdesk and report supporting. Management of MS Navision modules and projects for Cash In Transit and Cash Centre operations. Working with 3rd party developer companies working on ERP implementation projects

Contributions:

•Developed MS Navision v5.5 reports using QlikView v11, Excel VBA and SQL development tools

•Report developments and online queries for end users

•Used SSRS to create KPIs and Scorecards to provide CIT measures and financial values

•Developed custom reports to analyze Cash in Transit operations using T/SQL

•Designed Business Continuity and Disaster recovery policies and procedures

•BI infrastructure implementation by using QlikView v11

•Developed ERP reports using QlikView v11 and additional development tools

•Completed global IT reporting on time every month, managed licenses, managed servers

•QlikView v11 dashboard project for 3rd party Bank companies

•Created different type of reports such as Matrix reports, Sub reports and Charts using SSRS.

•QlikView v11 Dashboard design for YKB and Halk Bank (They accessed dashboards by using browsers)

HABBOUSH GROUP, IT Manager, Istanbul 09/2009 – 12/2012

(A global energy and infrastructure development, management and project financing firm)

Job scope: Supporting of IT in Turkey, Dubai and Iraq. Planning and controlling IS systems and ERP and reporting supports. Created .Net applications and reports, using existing ERP data and creating relations between different data sources by using C# and Excel objects.

Contributions:

•Development of financial reports by using Excel VBA

•Imported data from different sources into SQL Server

•Financial data extraction from IFS (ERP) (http://www.ifsworld.com/ca)

•Analyzed financial data in IFS(ERP) by creating simple SQL queries

•Prepared business reports in IFS (ERP)using Excel VBA and macros

•Created Web Parts in SharePoint to show various reports generated from Excel

•Developed stored procedures using T-SQL and used them in C# applications

PwC– GTS Team Leader, Istanbul 11/2001 – 06/2009

•DECS implementation between SQL server and Lotus Notes for an interactive web design

•DTS (SQL server 2000, older version of SSIS) usage for TimeSheet management

•Accounting system support for quick partner income and tax queries

•HR system implementation migration file conversions

•Development of SQL dbs and maintenance

•Responsible for regional reporting

•Supported team for SQL development providing raw data for analysis purpose to CRM.

•MS CRM implementation ( taken active role to move data from LotusNotes to MS CRM)

Contact this candidate