Asım (Murat) Yurduseven-Freelance BI/DWH/ETL Specialist
Check rate
Experience
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
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
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
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
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
Freelance ETL Developer
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)
Senior Application Developer / Scrum Master
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
- Scrum master/developer
Health Insurance 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
Healthcare IT 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
MDM/CRM Developer
Obase Information Technology and Services
- MDM: B2B/B2C-ETL (PL/SQL/Oracle, Talend)
- CRM (loyalty card)
- Net Transformation Team
Healthcare Software Developer
Ege University Unipa Software Company
- Healthcare software (Oracle Forms/Reports PL/SQL)
- Laboratory devices communicate with healthcare apps
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.
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.
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
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
Global Experience
Expertise
Qualifications
Profile
Frequently asked questions
Have questions? Find more information here.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Freelance BI/DWH/ETL Specialist
Nearby freelancers
Professionals working in or nearby Essen, Germany
