SUMMARY:

• Proficient experience in Data Modeling methodologies, data management, data analysis, data mapping and data profiling, managing the modeling process from conceptualization to logical model and then produce physical models.
• Highly experienced in Telecommunication and ERP industries.
• Expert on resolving complex problems and issues involved in data architecture activities.

TECHNICAL SKILLS:

• Excellent working knowledge of: Teradata SQL assistant and Teradata Administrator tools
• Experienced in PL SQL
• Experienced in R.
• Experienced in ETL tools (Data Stage)
• Experienced in Ericsson charging systems, BSCS IX billing systems, Siebel system.
• Perfect command of most MS Office applications (MS Excel, Access, Word…etc.)
• Perfect command of English and Arabic. Basic knowledge of French

PROFESSIONAL EXPERIENCE:

Confidential

Data analyst

Responsibilities:

• The role aims to perform analysis on HCSC members and claims for vendors’ partnership, creating data mapping documents and developing data extracts using Teradata SQl Assistant.

Confidential

Sr Data Modeler

Responsibilities:

• Analyzing business requirements and writing HLD and LLD documents.
• Writing mapping documents from source to target databases
• Customizing Teradata data models, developing scripts and stored procedures
• Performing Quality Assurance functions across departmental teams.
• Performing data analysis and design, and creates and maintaining large logical and physical data models.
• Participated in creating the model for integrating Ericson Data system (CS5 version) into Confidential Data Warehouse using Teradata Logical Model for Telecom Industry and Erwin tool.
• Managed complete integration of Ericsson CS3 and CS5 flows into Data Warehouse starting from gathering business requirements, building models, providing assistance in ETL processes till delivery.
• Analyzed business requirements for customers’ Data traffic usage KPIs and created required data mappings and business/data transformation logic documents for Ericsson CS5 systems.
• Built model for integrating Sim Card Inventory system within Data Warehouse using Teradata Logical Model and Erwin tool.
• Analyzed KPis required after full integration of Siebel Loyalty, Siebel event and Siebel campaign management modules into Data warehouse, built mapping documents.
• Extracted and Modeled Confidential Sales Distribution system which includes the acquisition module and the accounting module using Erwin and PL SQL and supervised its integration process within Data Warehouse.
• Participated in availing Ericsson CS5 new business features and formats in the Data Warehouse; delivered the customization needed in EMM flow and mapping documents for both logical data model and reporting layer using Teradata LDM and Erwin.
• Analyzed Confidential solution documents during swap of Ferma to Ericsson charging system, delivered mapping documents for both CLDM and BI layers.
• Participated in implementing Teradata model while revamping DWH from Oracle to Teradata; reviewed the business rules in mapping documents and participated in reviewing data checks across the two data warehouse platforms (Oracle, and Teradata).
• Loaded data from various data sources into Teradata production platform using BTEQ scripts while revamping DWH from Oracle to Teradata.
• Built views as base BI layer for Siebel Loyalty, Campaign management Dashboard using Teradata Sql Assistant.
• Developed set of reports to act as a backup to Ericsson Charging system platform using Teradata SQL assistant.
• Participated in designing a set of quality check routines to assure the quality of ETL process and daily loading using BTEQ scripting.
• Developed views as base BI layer for Sales Chain Management dashboard using Teradata SQl assistant.

Confidential

ETl developer

Responsibilities:

• Developed jobs for loading Roaming traffic into Data warehouse using Datastage.
• Developed jobs for loading Prepaid billing traffic into Data warehouse using Datastage.

Confidential

Senior Programmer

Responsibilities:

• Developed and maintained modules for library database using PowerBuilder 7. Examples include: cataloging module, search module, Marc and Z39 modules.
• Participated in development of assets software systems.
• Developed new features such as report generator, Interface modifier using PowerBuilder 7

Confidential

Senior Programmer

Responsibilities:

• Analyzed the requirements needed by Siro Misr Factory and developed Production Planning, Material Planning, Product Costing, Sales and Inventory modules using PowerBuilder 7
• Worked as a consultant in the Development Office in “ Confidential ” to maintain their Fund Raising Program and created reports including all Donors' data, this reporting tool is implemented in all offices in Egypt and New York City.
• Analyzed the requirements needed and developed Sales, Purchase, Inventory and Item Packing modules of “ Confidential ” for office furniture using Power - builder 6.5.
• Developed Sales, Production Planning and Inventory modules of “ Confidential ” for packaging & adhesives materials using Power-builder 6.5.
• Developed Sales and Inventory modules of “ Confidential ” for electrical products using Power-builder 6.5.
• Participated in development of Receivables and Payables modules of “ Confidential ” using Power-Builder 6.5.
• Built all the modules of “ Confidential ” company including the Geographical module, sales module and structural module.
• Participated in automation of the departments of the “ Confidential” in Alexandria including the Warehouses department - Production department using Power-Builder 6.5.
• Participated in Automation of the departments of “ Confidential ” for insurance and reinsurance services using PowerBuilder 7