Asım (Murat) Yurduseven

Consultant

Essen, Germany

Experience

Apr 2017 - Feb 2022
4 years 11 months

Consultant

Akbank

  • Setting architectural standards for Informatica Power Center development teams.
  • Maintenance-performance-health for DWH (Exadata) environments.
  • Qlik Sence /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 QlikSence versions
  • Merge all Informatica server's repository databases on one Oracle DB.
Apr 2017 - Feb 2022
4 years 11 months

Consultant

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. By this way we have managed to reduce the leaks in money laundering activities to 10%
  • Redesigned customer segmentation data according to country transaction and risk groups. Thus, we reduced the record multiplexing to 0.
  • Calculate the risk finding algorithms over customer transaction data. With these calculations, the risk was reduced 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

Consultant

Avon

  • Migrate various data sources to DWH PostgreSQL, Greenplum with Wherescape Red
  • Convert BI-DWH (Oracle) to Snowflake project. We reached 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

Consultant

Freelance

  • Informatica PWC 9 to 10.4 version migration
  • Split DWH into layers, ODS, STG, DWH, DataMart
  • QlikView to QlikSence migration
  • Smart massage (CRM loyalty): sending company announcements email/SMS with their permission
Apr 2017 - Feb 2022
4 years 11 months

Consultant

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
Apr 2017 - Feb 2022
4 years 11 months

Consultant

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

Consultant

Vodafone

  • ETL (SQL To Oracle – Oracle to Oracle)
  • Data load to DWH system with ODI and Oracle PL/SQL packages
  • Maintain for performance of DWH (PL/SQL)
May 2016 - Apr 2017
1 year

Scrum Master/Developer

AK Yatirim/Akbank

  • Developed In-House Investment Application (Oracle Forms/PL/SQL)
  • FIX protocol (stock Market) for maintenance
  • Built a BI/DWH environment for reporting and restructured reporting flow among the departments and cut down paperwork by 85%.
  • Coded PL/SQL packages for ETL OLTP To DWH
  • Load the data to 3rd party system about banking compliance regulations
Sep 2014 - May 2016
1 year 9 months

Software Developer

Allianz

  • Health Insurance In-house software (PL/SQL, Oracle Forms-Reports)
  • Migrate Oracle Forms-WebLogic
  • Maintenance PL/SQL codes performance improving
  • Control printing spool system for insurance contracts
  • Agile/Scrum
Apr 2013 - Sep 2014
1 year 6 months

Software Specialist

Anadolu Hospital (John Hopkins)

  • E-Appointment: Patients can make appointments online
  • E-Health: Patients can view all lab/radiology results
  • E-Pulse: common platform integrated with the Ministry of Health Database
  • Checking and managing the software specific to the devices used for the integration and management of the devices in the hospital clinical laboratory and the data flow to the hospital information system.
May 2010 - Apr 2013
3 years

ETL 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

Oracle Developer

Ege University Unipa Software Company

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

Data Engineer

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.

Languages

Turkish
Native
English
Advanced
German
Elementary
Spanish
Elementary

Education

Ege University

Computer Technology and Programming

Gazi University

Master · Management Information Systems · Turkey

Anadolu University

Bachelor · Business Administration · Turkey

Certifications & licenses

Scrum Master

Scrum.org

Business Analyst Fundamentals

Bilgeadam

IFINSEC

IFINSEC

IIBA Advanced Babook

Bilge Adam

Java

Bilge Adam

MS 10990- Analyzing Data with SSRS

BilgeAdam

MS 20761 Querying Data with SQL

Bilge Adam

Microsoft Excel (Advanced)

Bilge Adam

Microsoft Excel (Expert)

BilgeAdam

Professional Scrum Fundamental

Acm Software

TOGAF 9.1

Bilgeadam

MicroStrategy

Obase Software

Oracle Dba

Bilginç IT

SAP BO/BW

Golive Consultant

Blue Card (EU)