Asım (Murat) Yurduseven

Consultant

Essen, Deutschland

Erfahrungen

Apr. 2017 - Feb. 2022
4 Jahren 11 Monaten

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 Jahren 11 Monaten

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 Jahren 11 Monaten

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 Jahren 11 Monaten

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 Jahren 11 Monaten

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 Jahren 11 Monaten

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 Jahren 11 Monaten

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)
Mai 2016 - Apr. 2017
1 Jahr

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
Sept. 2014 - Mai 2016
1 Jahr 9 Monaten

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 - Sept. 2014
1 Jahr 6 Monaten

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.
Mai 2010 - Apr. 2013
3 Jahren

ETL Developer

Obase Information Technology and Services

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

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

Zusammenfassung

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.

Sprachen

Türkisch
Muttersprache
Englisch
Verhandlungssicher
Deutsch
Grundkenntnisse
Spanisch
Grundkenntnisse

Ausbildung

Ege University

Computer Technology and Programming

Gazi University

Master · Management Information Systems · Türkei

Anadolu University

Bachelor · Business Administration · Türkei

Zertifikate & Bescheinigungen

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)