Asım (Murat) Yurduseven
Consultant
Experience
Apr 2017 - Feb 2022
4 years 11 monthsConsultant
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 monthsConsultant
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 monthsConsultant
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 monthsConsultant
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 monthsConsultant
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 monthsConsultant
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 monthsConsultant
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 yearScrum 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 monthsSoftware 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 monthsSoftware 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 yearsETL 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 yearsOracle 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)
Similar Freelancers
Discover other experts with similar qualifications and experience