Asım (Murat) Yurduseven

Freelance BI/DWH/ETL Specialist

Avatar placeholder
Essen, Germany

Experience

Apr 2017 - Feb 2022
4 years 11 months

Freelance BI/DWH/ETL Specialist

Akbank

  • Setting architectural standards for Informatica Power Center development teams
  • Maintenance-performance-health for DWH (Exadata) environments
  • Qlik Sense / BO reports architectural standards
  • Implementing best practices in ETL tasks
  • Documentation ETL standards on Confluence
  • Dynamic Data Masking rules for GDPR/KVKK regulations by using Informatica DDM tool
  • DWH Data model Power Designer
  • Upgrade Qlik Sense versions
  • Merge all Informatica server's repository databases on one Oracle DB
Apr 2017 - Feb 2022
4 years 11 months

Freelance DWH Architect (Anti Money Laundering)

Allianz

  • Build DWH architect to catch money laundry transactions with 100% unique data
  • Create approximately 400 ETL pipelines to get core data to DWH with Oracle PL/SQL Package/SP to feed DataMart
  • Collect Customer's money related transactional billions of data from 6 different LOB to reduce the leaks in money laundering activities to 10%
  • Redesigned customer segmentation data according to country transaction and risk groups to reduce the record multiplexing to 0
  • Calculate the risk finding algorithms over customer transaction data to reduce the risk to 2 percent
  • Accelerated Query Performance
  • Working with PO, key users, core dev teams to coordinate business development/ Agile
  • Pipeline the data with Informatica to generate alerts on ActOne tool
Apr 2017 - Feb 2022
4 years 11 months

Freelance BI/DWH Specialist

Avon

  • Migrate various data sources to DWH PostgreSQL, Greenplum with Wherescape Red
  • Convert BI-DWH(Oracle) to Snowflake project to reach many more users with fewer license costs
  • Make user role matrix
  • Making snowflake datamarts, SQL scripts for reporting environments
Apr 2017 - Feb 2022
4 years 11 months

Freelance ETL/BI Developer

MetLife

  • ETL pipelines with Informatica PowerCenter and SSIS
  • Design DWH structure
  • Design Reports/Ad-hoc query performance
  • Making QlikView/Sense, SSRS, Power BI(Dax) reports/dashboards
  • Informatica Pwc 9 to 10.4 version migration
  • Split DWH into layers, ODS, STG, DWH, DataMart
  • QlikView to Qlik Sense migration
  • Smart massage (CRM loyalty): sending company announcements email /SMS with their permission
Apr 2017 - Feb 2022
4 years 11 months

Freelance BI/ETL Developer

Turkcell

  • Maintenance BI application named Beqom- agency premium system
  • Build and maintenance SSIS ETL jobs with T-SQL
  • Designed Reports with SSRS
  • Expanded reports by business units
  • Transform Business needs to the self-service reporting platform
  • Design MSTR reports with consider MSTR model structure
  • Add new data sources into the MSTR structure
Apr 2017 - Feb 2022
4 years 11 months

Freelance ETL Developer

Vodafone

  • ETL (SQL to Oracle – Oracle to Oracle)
  • Data loading into the DWH system using ODI and Oracle PL/SQL packages
  • Maintained performance of the DWH (PL/SQL)
May 2016 - Apr 2017
1 year

Senior Application Developer / Scrum Master

AK Yatirim / Akbank

  • Developed an in-house investment application (Oracle Forms/PL/SQL)
  • Maintained FIX protocol for the stock market
  • Built a BI/DWH environment for reporting, restructured reporting flow across departments, and reduced paperwork by 85%
  • Wrote PL/SQL packages for ETL from OLTP to DWH
  • Loaded data to a 3rd-party system for banking compliance regulations
  • Scrum Master/Developer
Sep 2014 - May 2016
1 year 9 months

Health Insurance Software Developer

Allianz

  • In-house health insurance software (PL/SQL, Oracle Forms-Reports)
  • Migrated Oracle Forms to WebLogic
  • Maintained and improved PL/SQL code performance
  • Managed printing spool system for insurance contracts
  • Agile/Scrum
Apr 2013 - Sep 2014
1 year 6 months

Healthcare IT Specialist

Anadolu Hospital (John Hopkins)

  • E-Appointment: allowed patients to make appointments online
  • E-Health: enabled patients to view all lab and radiology results
  • E-Pulse: a common platform integrated with the Ministry of Health database
  • Checked and managed device-specific software for integration and management in the clinical laboratory and monitored data flow to the hospital information system
May 2010 - Apr 2013
3 years

MDM/CRM Developer

Obase Information Technology and Services

  • MDM: B2B/B2C ETL (PL/SQL/Oracle, Talend)
  • CRM (loyalty card)
  • Net Transformation Team
Nov 2002 - Oct 2009
7 years

Healthcare Software Developer

Ege University Unipa Software Company

  • Healthcare software (Oracle Forms/Reports PL/SQL)
  • Laboratory devices communicate with healthcare apps
Essen, Germany

CRM-MDM Specialist

11880

  • Performed End2End customer data pipelines in MDM project (PL/SQL)
  • Troubleshooted data load between C2C/B2C various data source with ETL jobs (Job scheduler, Talend, Informatica)
  • Achieved Agile/Scrum

Summary

After working on different projects for 24 years, especially in Oracle, MS SQL and RDBMS, I improved myself in Business Intelligence Dwh/ETL field.

I worked on many software methodologies. I had the opportunity to get involved in about 10 Scrum and project teams in more than 5 different sectors. Some of them are Healthcare, Insurance, Banking/Finance, Retail, Stock Markets, Telecom. Working with different technologies, domains and disciplines has given me an extremely broad perspective and the ability to think in different dimensions.

My master thesis is on data case analysis on healthcare.

Skills

  • Oracle: Pl/sql, Sql Tuning, Db Administrator, Oracle Forms-reports, Apex, Ebs
  • Microsoft Ms Sql Server, T-sql, Bi: Ssrs, Microstrategy, Qlikview, Powerbi, Sap Bo/bw
  • Etl: Informatica, Informatica Iics, Ms Ssis, Odi, Talend
  • Agile/scrum Master, Pmp-pm, Ms Project
  • Delphi, Office, Windows, Unix
  • Html, Css, Js, Php, Tfs, Git, Svn, Java, Eclipse, Visual Studio

Languages

Turkish
Native
English
Advanced
German
Elementary
Spanish
Elementary

Education

Anadolu University

Bachelor, Business Administration · Business Administration · Eskişehir, Turkey

Gazi University

Master, Management Information Systems · MIS-Management Information Systems · Ankara, Turkey

Ege University

Computer Technology and Programming · İzmir, Turkey

Certifications & licenses

Scrum Master

Scrum.org

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Similar Freelancers

Discover other experts with similar qualifications and experience

Peter Langheinrich
Peter Langheinrich

Zoho Consulting and Development

View Profile
Torsten Glunde
Torsten Glunde

BI consultant

View Profile
Jörg Trappschuh
Jörg Trappschuh

Database Expert and Software Developer

View Profile
José Côco
José Côco

Business Analyst / Process Manager

View Profile
Andreas Flegel
Andreas Flegel

CRM Consultant, BI Expert, Project Manager, Coach

View Profile
Henning Uiterwyk
Henning Uiterwyk

Senior Expert Data Governance, Master Data Quality and Data Migration

View Profile
Nikolay Tonev
Nikolay Tonev

Senior Cloud Data Architect

View Profile
Mariano Filiberto
Mariano Filiberto

SAP Business Intelligence Solution Architect / Team Lead Core Program

View Profile
Marek Werulik
Marek Werulik

Data Management Solution Architect

View Profile
Petru Kisalita
Petru Kisalita

Architect & Technical Team Lead & Senior Developer

View Profile
Alex Odesser
Alex Odesser

Contractor

View Profile
Basem Elasioty
Basem Elasioty

Head of Cloud & AI

View Profile
Münevver Yilmaz
Münevver Yilmaz

SAP FI/CO Lead Consultant

View Profile
Alexander Zhirov
Alexander Zhirov

Senior Data Architect & Data Engineer

View Profile
Stephan Fabisch
Stephan Fabisch

Project Management and Project Coordination (interim)

View Profile
Paul Webster
Paul Webster

Architecture Consultant (Freelance)

View Profile
Patrick Von der gönna
Patrick Von der gönna

Senior Director, Retail Media

View Profile
Rosemarie Fryzowicz
Rosemarie Fryzowicz

Freelance Management Consultant in the Construction Industry

View Profile
Zana Ali katilmis
Zana Ali katilmis

Independent Consultant for IT Transformation in the Financial Services Sector

View Profile
Nikolaus Jäger-grassl
Nikolaus Jäger-grassl

Integration Architect

View Profile
Stefan Corsten
Stefan Corsten

SSIS Development

View Profile
Luca Demmel
Luca Demmel

CTO & Co-Founder

View Profile
Kai Kramer
Kai Kramer

Chatbots for Tax and Legal Texts

View Profile
Martijn Imrich
Martijn Imrich

Founder and CEO

View Profile
Carsten Leschik
Carsten Leschik

Business / Functional Analyst and Oracle Developer DWH

View Profile
Bodo Clausen
Bodo Clausen

Managing Director

View Profile
Florian Otte
Florian Otte

Interim CTO

View Profile
Ralph Elsäßer
Ralph Elsäßer

Geoinformatics Specialist, Digitalization Expert

View Profile
Vitali Haberkorn
Vitali Haberkorn

Power BI Expert

View Profile
Simon Stegelmeier
Simon Stegelmeier

Cloud Data Platform Product Owner & Project Manager

View Profile