Asım Yurduseven - Freelance BI/DWH/ETL Specialist

Q: Where is Asım based?

Asım is based in Essen, Germany .

Q: What languages does Asım speak?

Asım speaks the following languages: Turkish (Native), English (Advanced), German (Elementary), Spanish (Elementary) .

Q: How many years of experience does Asım have?

Asım has at least 19 years of experience. During this time, Asım has worked in at least 11 different roles and for 10 different companies . The average length of individual experience is 2 years and 8 months . Note that Asım may not have shared all experience and actually has more experience.

Q: What is Asım's latest experience?

Asım's most recent position is Freelance BI/DWH/ETL Specialist at Akbank .

Q: What companies has Asım worked for in recent years?

In recent years, Asım has worked for Akbank , Allianz , Avon , MetLife , and Turkcell .

Q: Which industries is Asım most experienced in?

Asım is most experienced in industries like Healthcare , Insurance , and Banking and Finance . Asım also has some experience in Cosmetics , Telecommunication , and Information Technology .

Q: Which business areas is Asım most experienced in?

Asım is most experienced in business areas like Information Technology , Business Intelligence , and Marketing . Asım also has some experience in Product Development and Project Management .

Q: Which industries has Asım worked in recently?

Asım has recently worked in industries like Banking and Finance , Insurance , and Cosmetics .

Q: Which business areas has Asım worked in recently?

Asım has recently worked in business areas like Business Intelligence and Information Technology .

Recommended expert

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

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Healthcare, Insurance, Banking and Finance, Cosmetics, Telecommunication, and Information Technology.

Healthcare

Insurance

Banking and Finance

Cosmetics

Telecommunication

Information Technology

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Information Technology, Business Intelligence, Marketing, Product Development, and Project Management.

Information Technology

Business Intelligence

Marketing

Product Development

Project Management

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

Statistics

Experience

Total positions 12

Experience in Healthcare 8.5 y

Avg length 3 y 7 m

Longest experience 6 y 11 m

Global Experience

Countries worked in 1 (Germany)

Primary country Germany

Expertise

Recent roles Freelance BI/DWH/ETL Specialist, Freelance DWH Architect (Anti Money Laundering), Freelance BI/DWH Specialist

Main industries Healthcare, Insurance, Banking and Finance

Main business areas Information Technology, Business Intelligence, Marketing

Qualifications

Highest degree Master

Certifications earned 1

Profile

Created

October 2023

Last Update

August 2024

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Asım based?

Asım is based in Essen, Germany.

What languages does Asım speak?

Asım speaks the following languages: Turkish (Native), English (Advanced), German (Elementary), Spanish (Elementary).

How many years of experience does Asım have?

Asım has at least 19 years of experience. During this time, Asım has worked in at least 11 different roles and for 10 different companies. The average length of individual experience is 2 years and 8 months. Note that Asım may not have shared all experience and actually has more experience.

What roles would Asım be best suited for?

Based on recent experience, Asım would be well-suited for roles such as: Freelance BI/DWH/ETL Specialist, Freelance DWH Architect (Anti Money Laundering), Freelance BI/DWH Specialist.

What is Asım's latest experience?

Asım's most recent position is Freelance BI/DWH/ETL Specialist at Akbank.

What companies has Asım worked for in recent years?

In recent years, Asım has worked for Akbank, Allianz, Avon, MetLife, and Turkcell.

Which industries is Asım most experienced in?

Asım is most experienced in industries like Healthcare, Insurance, and Banking and Finance. Asım also has some experience in Cosmetics, Telecommunication, and Information Technology.

Which business areas is Asım most experienced in?

Asım is most experienced in business areas like Information Technology, Business Intelligence, and Marketing. Asım also has some experience in Product Development and Project Management.

Which industries has Asım worked in recently?

Asım has recently worked in industries like Banking and Finance, Insurance, and Cosmetics.

Which business areas has Asım worked in recently?

Asım has recently worked in business areas like Business Intelligence and Information Technology.

What is Asım's education?

Asım holds a Master in MIS-Management Information Systems from Gazi University, a Bachelor in Business Administration from Anadolu University and a Bachelor in Computer Technology and Programming from Ege University.

Does Asım have any certificates?

Asım has 1 certificate: Scrum Master.

What is the availability of Asım?

Asım is immediately available part-time for suitable projects.

What is the rate of Asım?

Asım's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.