ERMAN SEZER

Contact : Ereteam Analytics HR: Sumru Tuncer

E-Mail : adixqy@r.postjobfree.com

Phone : 973-***-****

Address : * ****** ***, ********** ** 07054

Tools & Skills

IBM Information Server ( DataStage, QualityStage, Information Analyzer, Business Governance Catalog, Fasttrack) (Certified, Advanced Level)

IBM Data Replication (CDC)

IBM Cognos

PLSQL (Advanced)

ODI

SAP DS

Alteryx

Pentaho

Tableau

Oracle BI

Talend

Microsoft SSIS

Microsoft Power BI

Jira

Requirement Gathering

IBM Data Architect

IBM BDW ( Banking Datawarehouse Model)

IBM IDW ( Insurance Datawarehouse Model)

SAP Power Designer

Informatica Power Center

Work Experience

After working on Turkey’s different leading consultancy companies (as consultant, manager, data architect), I am now working on Ereteam Analytics as Data Consultant in NJ. I am open to consultancy positions as Data Architect, ETL Architect, ETL Developer ( IBM Datastage, Informatica, ODI, PLSQL, Pentaho, DWH Trainer( IBM Information Server, IBM Data Replication (CDC), IBM Netezza), BI Developer ( IBM Cognos, Tableau, Microstrategy). Ereteam Analytics New Jersey - 01.08.2020

Data Consultant

I am working on Ereteam Analytics now as Data Consultant and sharing my experiences on New Jersey area after having 15 years of Data Consultancy experience in Istanbul and international companies.

Data & Data İstanbul - 25.07.2019 – 31.07.2020

DWH Manager

After developing, managing DWH and BI projects on different sectors and on Turkey’s leading consultancy companies, I am now working on Data&Data as DWH Manager. As an IBM Information Server certified trainer,

Projects

Ray Insurance – New Datawarehouse Project

Avivasa – Data Migration Project

Energy Exchange İstanbul ( Exist) – New DWH Project GTech İstanbul - 18.02.2019 – 23.07.2019

DWH & BI Manager

Head of DWH Teams and BI Teams

Technical Head of Insurance R&D Projects

As a DWH & BI Manager, I am managing the DWH and BI teams through Team Leaders. I am responsible of project success, budget, profitibility of the teams and the unit. I am making strategy plans with the board. As a Data Architect and Solution Manager, I am working on the project wherever I think the team needs my help.

Projects

Ministry of Energy and Natural Resources DWH Project – Setting DWH & BI environment for 7 branches of Ministry and deploying reports and dashboards.

Acıbadem Insurance – Re-engineering DWH Project.

Anadolu Hayat Emeklilik – DWH Project

Cosmetica – DWH Reengineering

Sabancı Holding – Dashboard Support

Tekfen Holding – DWH Support

Datamind İstanbul - 17.04.2017 – 11.02.2019

Solution Manager

Head of Data Engineering Team

Head of Datamind Istanbul Branch

R&D Project Manager

Pre-Sales Manager

As a Solution Manager, I am managing Datamind Istanbul Branch. Datamind is focusing on Datawarehouse projects, Data Mining Projects, Big data projects and its own R&D projects. I am making strategy plans with the board and leading the team, deciding projects, planning the budget, making and following Project plans, building relationships, solving problems in general. Projects

The Ministry of Transport, Maritime Affairs and Communications – Enterprise Datawarehouse Project

Groupama Insurance – Data Quality Project

Groupama Insurance – Enterprise Datawarehouse Project

ICA- Third Bosphorus Bridge and Northern Marmara Highway – Datawarehouse Project

Tredaş - Analytical Approach - Modelling Weather-Related Failures of Overhead Distrubiton Lines

Millenicom – Churn Analysis

Groupama Insurance - Fraud Dedection

ING Bank Turkey – Data Lake

OSIS Consultancy İstanbul - 11.04.2011 – 13.04.2017 Senior Information Management Consultant

OSIS, as a premium partner of IBM, is working for all processes for IS. Pre-Sales, POCs,POTs, - presentations, and projects & post-sales, consultancy. Projects

Halk Bank- Datawarehouse Project-Performance Consultancy

Ziraat Bank Datawarehouse ETL Support

İş Bank - SPSS Data Netezza Integration Project

Eczacıbaşı Intema - MDM Data Quality & QualityStage Data Quality Project

Anadolu Insurance- ETL Project

Aksigorta-CDC Project

Anadolu Hayat Emeklilik- Datawarehouse ETL Consultancy

Boyner Retail- Datawarehouse Project (Netezza-Datastage)

Boyner Holding Company- ETL Project

Boyner Holding Company- MDM Data Integration Project

İETT- New Datawarehouse Project

İETT- SAP Migration ETL & Data Quality Project

Turkcell- Budget Project

Novartis- Reporting & ETL on Datawarehouse Project

Migros- B2B ETL Project

Migros-Şok ETL DataWarehouse Project

Sampaş- ETL Project & Consultancy

İstanbul Metropolitan Municipality- ETL DWH Project Intellica Consultancy İstanbul – 23.02.2010 – 31.03.2011 BI Developer & Consultant

BNP Paribas-TEB(Turkish Economy Bank) New Datawarehouse project using IBM BDW and Oracle Data Integrator

BNP Paribas-TEB(Turkish Economy Bank) ETL Project using PL/SQL

Türkiye İş Bankası – IBM Information Server DataStage Consultancy and Education SOFTTECH İstanbul - 20.10.2008 – 16.02.2010

BI Developer

Extract data from different databases (DB2, ORACLE, SQL Server, COBOL Flat Files)

Transform extracted data, based on project requirements.

Load transformed data to target database for use of different purpose

Provide data for Data warehouse

Analyze the business requirements

Projects:

- CRM Lead Project ETL design

- Branch Target and Actual Reporting ETL processes

- Balanced ScoreCard Project

- Designing ETL processes for IT development teams

- Implementing ETL structures for different banking products (Invoice payment, Credit Cards, Loans etc) among source system to open systems. Sabri Özel Tekstil İstanbul - 10.08.2006 - 12.12.2006 Database and Software Specialist

Provide technical information about the software package (Nebim Winner)

Installation of ERP Software

Provide reports using SQL scripts

Technical presentation of software package

Educational Background

Master Bahçeşehir University- 2015 Management of

Information Systems

University İstanbul University – 2006

Computer Engineering

Courses

08/2019 IBM ETL Datastage Certification

02/2017 IBM Data Quality

09/2018 IBM CDC

03/2015 IBM Netezza

11/2016 Oracle ODI

10/2016 Oracle University Advanced PL/SQL

08/2015 Introduction to Oracle Database for Experienced SQL Users – Istanbul 09/2015 Software Engineering(.NET,MS SQL SERVER)

Contact this candidate