Asım (Murat) Y.
Consultant
Experience
Apr 2017 - Feb 2022
4 years 11 monthsConsultant
Akbank
- Set architectural standards for Informatica PowerCenter development teams.
- Maintain performance and health for DWH (Exadata) environments.
- Define Qlik Sense/BO reporting architectural standards.
- Implement ETL best practices.
- Document ETL standards on Confluence.
- Create Dynamic Data Masking rules for GDPR/KVKK compliance using Informatica DDM.
- Model DWH data in PowerDesigner.
- Upgrade Qlik Sense versions.
- Consolidate all Informatica server repository databases into one Oracle database.
Apr 2017 - Feb 2022
4 years 11 monthsConsultant
Allianz
- Built a DWH architecture to detect money laundering transactions with 100% unique data.
- Developed ~400 ETL pipelines using Oracle PL/SQL packages/SPs to feed DataMarts.
- Collected billions of customer transaction records from 6 LOBs, reducing money laundering leakage by 10%.
- Redesigned customer segmentation data by country and risk group, eliminating record duplication.
- Implemented risk detection algorithms on transaction data, reducing risk by 2%.
- Optimized query performance.
- Collaborated with PO, key users and core dev teams to coordinate business development in Agile.
- Pipelined data with Informatica to generate alerts in ActOne.
Apr 2017 - Feb 2022
4 years 11 monthsConsultant
Avon
- Migrated various data sources into PostgreSQL and Greenplum DWH with WhereScape RED.
- Converted BI/DWH (Oracle) to Snowflake, increasing user reach and cutting license costs.
- Defined user role matrix.
- Created Snowflake DataMarts and SQL scripts for reporting environments.
Apr 2017 - Feb 2022
4 years 11 monthsConsultant
Freelance
- Migrated Informatica PowerCenter from version 9 to 10.4.
- Split DWH into ODS, STG, DWH and DataMarts layers.
- Migrated QlikView to Qlik Sense.
- Implemented Smart Message CRM loyalty: sending company announcements via email/SMS with user permission.
Apr 2017 - Feb 2022
4 years 11 monthsConsultant
MetLife
- Built ETL pipelines with Informatica PowerCenter and SSIS; designed DWH structure.
- Optimized report and ad-hoc query performance.
- Developed QlikView/Sense, SSRS and Power BI (DAX) reports and dashboards.
Apr 2017 - Feb 2022
4 years 11 monthsConsultant
Turkcell
- Maintained BI application Beqom (agency premium system).
- Built and maintained SSIS ETL jobs with T-SQL.
- Designed reports with SSRS and expanded them across business units.
- Translated business needs into a self-service reporting platform.
- Designed MicroStrategy reports according to MSTR model.
- Added new data sources into the MicroStrategy structure.
Apr 2017 - Feb 2022
4 years 11 monthsConsultant
Vodafone
- Performed ETL (SQL to Oracle, Oracle to Oracle).
- Loaded data into DWH with ODI and Oracle PL/SQL packages.
- Tuned DWH performance with PL/SQL.
May 2016 - Apr 2017
1 yearScrum Master/Developer
AK Yatirim/Akbank
- Developed an in-house investment application (Oracle Forms/PL/SQL).
- Maintained FIX protocol integration for the stock market.
- Built a BI/DWH environment for reporting, restructured report flow across departments and cut paperwork by 85%.
- Coded PL/SQL packages for ETL from OLTP to DWH.
- Loaded data into a third-party system for banking compliance regulations.
Sep 2014 - May 2016
1 year 9 monthsSoftware Developer
Allianz
- Developed health insurance in-house software (PL/SQL, Oracle Forms/Reports).
- Migrated Oracle Forms to WebLogic.
- Improved PL/SQL code performance.
- Managed print spool system for insurance contracts.
- Worked in Agile/Scrum.
Apr 2013 - Sep 2014
1 year 6 monthsSoftware Specialist
Anadolu Hospital (John Hopkins)
- E-Appointment: Patients book appointments online.
- E-Health: Patients view lab and radiology results.
- E-Pulse: Common platform integrated with Ministry of Health database.
- Managed device-specific software in the clinical lab and handled data flow to the hospital information system.
May 2010 - Apr 2013
3 yearsETL Developer
Obase Information Technology and Services
- MDM ETL for B2B/B2C (PL/SQL/Oracle, Talend).
- CRM loyalty card integration.
- Worked on the Net Transformation Team.
Nov 2002 - Oct 2009
7 yearsOracle Developer
Ege University Unipa Software Company
- Developed healthcare software (Oracle Forms/Reports, PL/SQL).
- Integrated laboratory devices with healthcare apps.
Data Engineer
11880
- Built end-to-end customer data pipelines in an MDM project (PL/SQL).
- Troubleshot data loads between C2C/B2C sources with job scheduler, Talend and Informatica.
- Followed Agile/Scrum practices.
Summary
Having worked on various projects for 24 years, especially with Oracle, MS SQL and RDBMS, I specialized in Business Intelligence DWH/ETL. I gained experience in many software methodologies and joined about 10 Scrum and project teams across more than 5 sectors, including Healthcare, Insurance, Banking/Finance, Retail, Stock Markets and Telecom. Working with different technologies, domains and disciplines has given me a broad perspective and the ability to think in multiple dimensions. My master’s thesis focused on data case analysis in healthcare.
Languages
Turkish
NativeEnglish
AdvancedGerman
ElementarySpanish
ElementaryEducation
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 Babok
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 Fundamentals
Acm Software
TOGAF 9.1
Bilgeadam
MicroStrategy
Obase Software
Oracle DBA
Bilginç IT
SAP BO/BW
Golive Consultant
Blue Card (EU)
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.