Dalia Hassan Abbas

Address: Bank Masr towers, tower 5, entrance A, Khatem El-Morsaleen street, Giza, Egypt T: +20 35 62 10 32

M: +**-**-**-**-**-**

E-mail: adboyg@r.postjobfree.com

EDUCATION

Oct 2016–Present Masters of Business Information Systems, Thesis:”Adaptive framework for enhancing customer relationship management in banking sector”

Advisors: Prof. Yehia Helmy and Dr. Nabil Salah

Helwan University, Egypt

Sept. 2013–June 2014 9 Month Diploma of data warehousing, ERP department, Information Technology institute (ITI),

Ministry of Communications and Information Technology (MCIT), Smart Village Branch, Giza, Egypt.

http://www.iti.gov.eg/Admission/PTPprogram/intake36/DWHtrack Graduation Project: “Footfall Analytics Smartkit–Vodafone Partnership” This project uses the core data from communication services providers

(CSPs) that can be used to know the number of subscribers in a certain location, i.e. Footfall, subscriber's location, places s/he frequently visits, demographics and contacts Tools & Technologies: SAS, Weka, GoogleMaps, Java script, PHP, css3, Oracle and Ajax Oct. 2009–July 2013 Bachelor of Business Information System Helwan University, Egypt.

“Excellent with honors”, Rank: 9th, GPA: 3.81/4.00 Graduation Project: “Have you ever been!” – Android mobile application Grade: Excellent – Advisor: Dr. Mohammed El-Gazzar PROFESSIONAL EXPERIENCE AND TRAINING

April 2019 – Present Senior Software Application Engineer, Automation and Tooling Department, Data science team, Valeo Egypt, F22 Building, Smart Village Cairo - Alexandria Desert Rd, Giza Governorate

Projects:

PIMS(Product Information Management System)

Tools: Informatica power center, Oracle Database.

Role:

o Developing the ETL maps to extract data from the source system and transform it to create catalogs data.

o Understand the ETL specifications and build the mappings, sessions and Workflows as per requirement of business to create catalogs data.

o Handle data validation issues and new requirements. o Participating in creating informatica power center support process.

o Prepare needed documentation.

July 2014 – April 2019 Banker A, Information Technology Department, Management Information Systems (MIS) Team,Cairo Bank (Banque du Caire), Youssef Abbas branch, 6 Doctor Mostafa Abou Zahra st., Nasr City, Cairo, Egypt Projects:

OFSAA (Oracle Financial Services Analytical Applications) Tools: Informatica power center, Oracle Business Intelligence Enterprise (OBIEE), Business objects,OFSAA application, Oracle Database, Sybase Database and Weblogic

Role:

o Developing the ETL maps to extract data from the core banking system and load it into the Source staging tables. o Understand the ETL specifications and build the mappings, sessions and Workflows as per requirement of business to implement the logic in OFSAA staging tables.

o Handle data validation issues and new requirements. o Create and maintain Business Objects and OBIEE reports. o Support some issues in OFSAA application.

OFSAA run automation

OFSAA run consists of multiple workflows that run sequential by IT Team but that waste time and effort. Automating run of OFSAA workflows to run in consecutive way in order to save time and effort by run only two workflows rather than run seven workflows. Tools: Informatica power center, Oracle Database and Sybase Database

Role:

o Create two workflows for Core system.

o Convert all source and target workflows to worklets. o Include worklets in workflows to run in right sequence and test. o Handle all issues done when workflows run interrupted or task failed.

o Solve problems that were disturbing the OFSAA Monthly run.

Support required reports for Banque du Caire departments Tools: OBIEE, Business objects, Oracle Database and Sybase Database

Kondor system (treasury system)

Tools: Unix, java, Kondor system and Sybase Database

Kondor integration application

Java application integrate Kondor system with core banking system at end of day.

Tools: Unix, Java,Sybase Database and Oracle Database

FileNet (archiving system)

Tools: FileNet Enterprise Manager, Websphere and DB2

Moody's IFRS9(Analytics Risk Perspectives The Convergence of Risk, Finance, and Accounting)

Tools: Business objects and Oracle Database (optimize sql to be able to load 60 months data in 15 working days)

Payroll and Pension application

Java application that extract mobile number of pension and payroll customers with specific format to send SMS when pension or payroll is in account.

Tools: java eclipse and Oracle Database

Survey application

Tools: java eclipse and Oracle Database

Framework application

Java application built to change only xml files in order to create java application code,data base table and forms

Tools: java eclipse and Oracle Database

Banque du Caire software library

Store all source codes of applications, forms of change request and UAT, materials of courses taken, soft copy of forms such as vacation form.

Summer 2013 Intern, Bank Misr, El Mesaha Square Branch, Dokki, Giza, Egypt Checks and bills, Customer Service Departments

Summer 2011 Intern, Cairo Bank (Banque du Caire), Giza branch, Giza, Egypt Customer Service Department

TECHNICAL SKILLS

Administration

• TeraData administration.

• Oracle Database administration.

• Red Hat Administration.

Data Warehouse and Database

• TeraData Logical Design.

• TeraData Physical Design.

• Oracle 11g Software.

Business Intelligent Tools

• Oracle Business Intelligence Enterprise (OBIEE).

• Business Object (BOBJ)

ETL Tools

Informatica, and SAP Netweaver BW.

Programming Languages

C++, PHP, ABAP, SAS, Java, MYSQL, PL/SQL, XML, HTML, XHTML, and Bash Shell. COURSES

Secure coding training presented by Secure Misr at Egyptian Banking Institute.

Finance at ABC student activity at Cairo University.

PHP web development and communications skills at KIT training center.

General English courses at AUC.

Core ALM Online Training.

Informatica Performance Tuning and Optimization Techniques.

Informatica Power center Administration.

Safety First.

LANGUAGE SKILLS

Arabic: Native, English: Excellent.

EXTRACURRICULAR ACTIVITIES

Member in we-BIS student activity.

Member in Sakyet El-Sawy cultural center.

Volunteer at RESALA Charity Association.

HOBBIES

Practicing yoga, listening to music, Reading and interested in makeup. PERSONAL INFORMATION

Date of birth: 26/05/1992

Nationality: Egyptian

Marital Status: Single

Contact this candidate