Senior
Resume:
Medhat Ahmed
College Station, TX 77840
*.****@***.***.**
******.***************@*****.***
EXPERIENCE
National Bank of Egypt, Egypt Senior Business Intelligence and Enterprise Data Warehouse
July 2012 - PRESENT
DAAD, collaboration with ITI, Egypt SharePoint Developer
July 2011 - February 2012
GFK, Egypt Quantitative and Qualitative Analyst
January 2011 - July 2011
EDUCATION
Cairo University, Faculty of Computers and Information, Egypt Preliminary Masters Computing degree
September 2012 - January 2014
Enrolled in pre-master program which is a step forward to be prepared for my master’s degree.
Main courses: Big Data (Hadoop and Hive), TOGAF Framework, Data Management in Bioinformatics, Advanced Distributed Databases, SOA and Web Services, Topics in Enterprise Systems and Architectures, and Advanced Information Systems Engineering.
Kimball University, IL, USA Data Warehouse and Business Intelligence Lifecycle in Depth
June 2015 - June 2015
Knowing the whole cycle of implementing successfully data warehouse/ BI environment from the early stage of project planning, go through business requirement, development, up to deliver end to end solutions.
Cairo University, Faculty of Computers and Information, Egypt B.Sc. computer science
September 2007 - June 2011
Major: Data Management, and Information systems GPA: 3.17
Minor: Decision Support and Operational Research
PROJECTS
FATCA Reporting Senior BI Developer
Extract the required data of U.S. Citizens customers who own account(s) in the bank to apply taxes and deliver the standards reports related to FATCA compliance to Central Bank of Egypt (CBE) which are revised by CBE and passed to U.S. government.
Design and develop the reports and dashboards according to the standards agreed.
Regulatory Reporting for Basel I, II & III Senior BI Developer
Extract the required data, and deliver the standards reports to Central Bank of Egypt (CBE) which are revised by CBE and passed to Basel Committee on Banking Supervision.
Credit Cards Segments Behaviors Dimensional Modeler & BI Developer
Build the dashboards, reports, and KPIs to analyze the credit cards payments, interests, fees, statuses, issuance, and closure reasons of existing credit cards, how much owned customers spend on monthly basis.
Providing 360º business views from different perspectives such as Gender, Income Salaries, Demographic Info, Age Bracket, which merchants the customers usually use their cards.
Customers' and Accounts' Data Cleansing Dashboard Senior BI Developer
Speed up the acquisition process of useful information to deliver the desired results.
Design and develop the reports, dashboards to help the business users in validating and cleansing all the customers and accounts corrupt or inaccurate data.
Credit Card Data Mart Dimensional Modeler
Study the ACI worldwide credit, debit, and prepaid cards source system.
Combine the business needs with data availabilities.
Design and develop ETL mapping, procedures, and schedule.
Participate in building the Credit card data mart model layer.
Kick the marketing team campaigns for customers according to data extracted.
Point of Sales (POS) Tracking Dimensional Modeler
Coordinate activities with data source application owner to ensure integration and data integrity. Build up the logical and physical models according to the business needs.
Build the dashboard to analyze the on-us merchant categories, how much our customers spend on both on-us, and off-us merchants, optimize the interchange fees based on transactions behaviors.
Salesperson’s Targets and KPI BI Developer
Build BI solution, KPI and Scorecards to monitor the sales person's activities and performances; Moreover, Recommend suggestion actions to increase their performances and the bank profitability.
Payroll Companies Portfolio Dashboard BI Developer
Evaluate business requirements and data understanding.
Develop the phases of the RBD.
Create the dashboard and related reports analyses to help the business users to take the right decisions and actions on the appropriate time.
Assets and Liabilities Portfolio Analysis ETL & BI Developer
Build the physical tables and the relationships between them. Create the dashboard to analyze all the assets and liabilities from different perspectives.
Certificates of Deposit – Operational Data Store (ODS) ETL Developer
Understanding the core banking data sources. Design and develop the data warehouse schemes. Extract, Transform, and Load valuable data from multiple homogeneous and heterogeneous operational databases into single source of data (ODS), providing 360º business views.
Siebel CRM CRM Developer
Create routing rules, smart scripts, and assign the users according to their roles and responsibilities.
SKILLS
Core Competencies
●Oracle Business Intelligence Enterprise Edition (OBIEE 11g)
●BI administration tool (RPD)
●BI Publisher
●Security model
●Weblogic DAC
●Oracle Data Integrator 11g
●Siebel CRM
●Unix
●Expert level knowledge of Oracle SQL
Areas of Strength
●Hard worker and team player
●Delivering on deadlines
●Self motivation and learning
●Able to work under pressure
●Excellent communication skills
●Good analytical thinking
AWARDS
IBM Predictive Analytics Specialist
Kimball Group Datawarehouse and BI lifecycle in Depth.
LANGUAGES
●English: Fluently read, written and very good spoken IELTS: overall band 6
●Arabic: Native
●German: Elementary.
VOLUNTEERING
●CISV
Contact this candidate