Asım (Murat) Yurduseven
Consultant
Erfahrungen
Apr. 2017 - Feb. 2022
4 Jahren 11 MonatenConsultant
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 MonatenConsultant
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 MonatenConsultant
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 MonatenConsultant
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 MonatenConsultant
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 MonatenConsultant
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 MonatenConsultant
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 JahrScrum 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 MonatenSoftware 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 MonatenSoftware 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 JahrenETL 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 JahrenOracle 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)
Ähnliche Freelancer
Entdecken Sie andere Experten mit ähnlichen Qualifikationen und Erfahrungen.