Mostafa Kadry Abdelkader

• Developed self-service, ad-hoc reports and dashboards to automate business requirements, enhancing business decisions.
• Performing pre/post campaign analysis and simulations for launching ideas.
• Created informative reports in response to the Customer Insight Team's specific business intelligence requests.

Orange is one of the leading mobile operators in Egypt with over 25 mil Subscriber.

• Construct a model using SQL and Informatica Data Stage that can be utilized to generate daily and monthly reports for the Main Promo campaign, Called 012 These reports will provide crucial insights and aid in decision making at the managerial level
• Participating in the monthly audit activities regulated by NTRA and providing requested data
• Designed and sustained data models and databases using SQL in accordance with business needs, while also ensuring their maintenance
• Collaborated with cross-functional teams to analyze customer data using SQL ; identified key trends and increased customer retention by 25% within six months
• Conducted requirements gathering and analysis sessions with clients to ensure that business needs are met
• Built dashboards and reports for clients using SAP BO.

Commercial International Bank is an Egyptian private-sector bank ,The bank serves more than 500,000 clients and has more than 6,000 employees.

• Took an active role in reporting sales incentives and regulatory reports for CBE
• Played an active role in establishing a new analytical Dimensional Model for the data warehouse
• Effectively managed the testing process of a real-time customer relationship management (CRM) system for lending by producing automated test case scripts in Excel derived from the business requirements
• Responsible of Testing The process of integrating Smart Wallet(E-Wallet) System in the Data warehouse Model to use it on several reports for all bank departments and CBE
• Reviewing Requirements Specification Document RSD And validate the model against it.

• Actively participated in the Testing Process of all Data warehouse Phases (Data-Vault / Business-Vault)
• Played role in creation and testing of designed scalable, reusable, and low maintenance Testing Queries.

• Validating the data files from source to make sure correct data has been captured to be loaded to target tables
• Collaborated with the Development and Database Modeling teams for Integration during Initial and Incremental Loads.