Karim Helemish

Data Analytics Consultant DW/BI at Oracle

• Egypt - Cairo
• My current job since June 2018

Analytics Solutions: (OCI. OAC, ADW, ATP, OAX, FAW, OTBI, OEMM)
• Oracle Cloud Infrastructure
• Oracle Analytics Cloud
• Oracle Autonomous Database
• Oracle Fusion Analytics Warehouse / Oracle Analytics for applications
Contacts
Address : Cairo, Egypt
Mobile Number : +201007703117
Address : New Cairo, Cairo
E-mail Address : kemoid@gmail.com
Linkedin : /

BI Consultant at RMGS

• Egypt - Cairo
• June 2017 to May 2018

BI Conusltant at PositiveEdge

• Egypt - Cairo
• December 2016 to May 2017

Lead Business Intelligence and Data Management Consultant at Mivors

• Egypt - Cairo
• March 2015 to November 2016

- Handle BI part of Oracle Apps, Oracle Fusion, Accounting Flex Fields, OBIEE, and OTBI.
- Data Model of Mivors BI Apps DW
- Lead a team of BI professionals; Analysts, Developers etc.
- Design and implement BI strategy and operations
- Manage a portfolio of BI projects in public/private cloud SaaS environments like Oracle Fusion.
- Analyze and Develop BI reports which covers Different Business Areas like: Finance, Accounting, SCM, HCM, procurement, GL, AP, and AR.

ETL Lead Consultant at DataGearBI

• Egypt - Cairo
• December 2013 to March 2015

- Develop ETL job to integrate SAS AML Solution into CIB Teradata FS-LDM using IBM Datastage
- Manage a team to integrate Ericsson IN CDRs to Oracle OCDM DW at Zain Saudi Arabia. - Analyze and Develop BI reports which covers Telecom Data warehouse.
- Use Oracle Communication Data Model base tables in the ETL as a target DB.

Technical Lead - Business Intelligence at citPOINT

• Egypt - Cairo
• June 2013 to November 2013

- Develop ITIDA BI governmental portal project including the Data Model and the ETL
- Provide BI/DW Training for BI team
- Developing Executive and Management Dashboards

Business Intelligence at RealData Egypt

• Egypt - Port Said
• January 2013 to May 2013

- Maintain and develop BI/DW systems in an IT projects
- Develop BI/DW on top of ERP system (Retail, Sales)

Data Warehouse Specialist at Riyadh Military Hospital (RMH)

• Saudi Arabia - Riyadh
• November 2010 to December 2012

- Maintain and develop the existing BI/DW system
- Enhance the existing Data warehouse performance to help speed up with the high tech international
variables
- Architecting the data warehousing solution and Performance Tuning
- Train BI team on data integration technology using Informatica tools to spread the ETL knowledge
across the team members
- Assist in data cleansing to enhance the delivered information accuracy

DW/Business Intelligence Developer at Tawuniya

• Saudi Arabia - Riyadh
• April 2008 to October 2010

- Maintain and develop the existing BI system
- Enhance the existing Data warehouse to help organization speed up with the high tech international
variables
- General Ledger and Sub ledger Reinsurance Financial Reporting System
- Reinsurance Reporting System
- Architecting data warehousing solution and Performance Tuning
- Maintain and develop the Notification System

DW/Business Intelligence System Developer at Intercom

• Egypt
• April 2007 to April 2008

Projects : CIB Phone Banking System, CIB POC Data Quality Assessment, Fisal Bank
Banknet Reporting System, CIB Pastdues Project, CIB Statement Document
Project.
Job Field : Database Consolidation, Management, Analysis, and Data Quality
using IBM, Business Objects, DB2, Skywire technologies
Enterprise : Intercom Enterprises for Information Technologies
Place of Work : Nasr City, Cairo Egypt
Duration : April 2007 - March 2008

Responsibilities for Job #4

- Participate in large-scale BI/data warehouse projects (ETL, Data Quality) using IBM Information Server (DataStage, QualityStage, ProfileStage), Business Objects, Crystal Report, Business Objects Data Integrator, Crystal Xcelsius, DB2 Warehouse Manager, Skywire Docucorp.

IT Specialist , OLAP Developer at General Organization for Import and Export Control (GOIEC)

• Egypt
• June 2003 to March 2007

- Query Microsoft SQL Server 2000 with Transact-SQL
- Program a Microsoft SQL Server 2000 Database
- Develop an existing business lifecycle for trade-related business needs
- Participate in testing full lifecycle data in a warehouse project
- Participate in testing a web application
- Drive schematic improvements to the reporting system
- Develop DW using MS DTS (ETL tool)
- Participate in project planning for large-scale BI/data warehouse project
- Design multi-dimensional databases (cubes) for decision support and OLAP applications
- Develop DW-project web-based reporting system
- Interact with the business users to understand the needs for analytical reports