Ahmed Arafa Email & Phone Number

Kuwait City, Kw

Kuwait

• Involved in Design, develop and maintain the Data Warehouse data model and enrich it with the daily new data to support the business and management with the required analysis needed for the decision-making process using Microsoft SSIS.• Build data aggregations and consolidated data views that serve specific business areas to enhance the reporting performance and optimize the system resources and provide the business with its requirements in the specific desired time.• Creating IBM FM Models to generate reports that used by the company team members to view required data.• Building a presentation layer and a reporting layer to allow users create their own reports using drag and drop functions.• Building IBM Cognos dashboards for GM's and decision makers to be able to take the right decisions in a suitable time.• Working with different company team members and different divisions gathering their requirement to put it in a suitable format to take whatever needed actions.• Building retail and whole sale KPIs to be delivered to company team members.• Provide training to company team members on IBM Cognos to be able to build and work on it getting their own KPIs and reports.

Egypt

• Lead Egypt team. • Attend business meetings, calls with customer and other teams to get requirement. • Involved in Technical issues related to IBM Cognos. • Review test cases with testing teams to ensure that this will cover all KPIs. • Work closely with Data architect to implement Data ware house.• Work with BI team to Create IBM Cognos frame work manager model base on DWH.• Work with BI team to Design BI reports based on customer requirement.

Egypt

Job Description & Responsibilities IBM Cognos 11• Create Architecture Documents for the current Project • Create POC for any issues that facing any member of the team. • Involved with business and functional people to collect and gather requirements • Involved with team in designing and creating Data ware house. • Created List reports, cross tab reports, charts, sectional reports, & Drill through reports by using Report studio • Creating business dashboard for head managers to display banking info • Creating value prompts, Date & time prompts, Text box prompts, cascading prompts • Hide and Show the objects by using conditional blocks  Implemented java script in reports. • Involved and performed unit testing (manual testing) for the reports that have been developed. • Developed multi format reports (PDF, Word, HTML & Excel). • Creating & publishing the packages according to the business requirements. • Involved in the scheduling and deployment of the reports

Egypt

Job Description & Responsibilities • Lead Egypt team that consists of 5 resources. • Attend business meetings, calls with customer and other teams to get requirement. • Design a self-service model based on DB description to allow end user to create their own reports. • Review test cases with testing teams to ensure that this will cover all KPIs. • Work closely with customer to be sure that we meet the requirement.• Work hand to hand with team member to facilitate their tasks.

Egypt

Job Description & Responsibilities Technical team leader • Involved with business and functional people to collect and gather requirements • Created List reports, cross tab reports, charts, sectional reports, & Drill through reports by using • Report studio • Involved with team in designing and creating Data ware house • Creating value prompts, Date & time prompts, Text box prompts, cascading prompts • Hide and Show the objects by using conditional blocks  Implemented java script in reports. • Involved and performed unit testing (manual testing) for the reports that have been developed. • Developed multi format reports (PDF, Word, HTML & Excel). • Creating & publishing the packages according to the business requirements. • Involved in the scheduling and deployment of the reports

Egypt

• Create Data Model using frame work manager. • Support Cognos servers • Develop reports and dashboards. • Do promotion between different servers. • Create DB Catalog and DS creation. • Fix Problems in Reports . • set permissions to DS and reports. • Handle tickets that comes from customer with issues in Cognos servers or reports

Egypt

Job Description & Responsibilities • Involved with business and functional people to collect and gather requirements.• Involved with team in designing and creating Data ware house. • Created List reports, cross tab reports, charts, sectional reports, & Drill through reports by using • Report studio. • Creating business dashboard for head managers to display banking info. • Create income statement and balance sheet using IBM Cognos 10.2. • Creating value prompts, Date & time prompts, Text box prompts, cascading prompts. • Hide and Show the objects by using conditional blocks  Implemented java script in reports. • Involved and performed unit testing (manual testing) for the reports that have been developed. • Developed multi format reports (PDF, Word, HTML & Excel). • Creating & publishing the packages according to the business requirements.• Involved in the scheduling and deployment of the reports.

Egypt

Egypt

Egypt

BI Application Developer.1-Working With BI Data Modeling Using Framework Manager.2-Using Cognos 8 BI Studios to Build add hock Query Reports and Professional Reports.3-IBM Info sphere Data IBM Data Stage and Quality Stage.4-Tivoli Storage Manager Fastback Installation &Backup and Restore.5-DB2 Installation & Fundamentals.6-SQL Server Integration services 2005/2008.