Principal Software Engineer
Emaratech
Total years of experience :18 years, 6 Months
• Managing business intelligence solution development
• Using JIRA to follow up development activities progress
• Creating and assigning JIRA subtasks and stories
• Attending grooming sessions to align dependencies and releases
• Requirements gathering, analysis and documentation
• Participating in problem analysis and solving activities
• Participating in preparing data integration solution architecture
• Preparing technical document for ETL mappings
• Preparing technical document for data warehouse model
• Leading in data migration planning and implementation
• Participating in interactive reporting system design and development for General Directorate of Residence and Foreign Affairs - Dubai
• Leading in data warehouse and data marts modelling for General Directorate of Residence and Foreign Affairs - Dubai
•Meeting customers and gather requirement
•Requirements analysis and documentation
•Participating in problem solving activities to satisfy customer requirements
•Propose appropriate solutions to fit customer needs
•Preparing technical document for ETL mappings
•Leading in developing ETL jobs using IBM Data Stage for Saudi MOI.
•Leading in data warehouse and data marts modeling for Saudi MOI.
•Preparing technical document for data warehouse model
•Leading in data migration planning and implementation
•New models explanation to ETL and BI teams
•Partners with director to lead the strategy phase of client projects. including discovery, evaluating and recommending technical solution alternatives
•Participates in pre-project business development activities including writing proposals, estimating durations and developing price estimates for new work
•Provides technical leadership and assumes overall accountability for a successful implementation phase
•Partners with project managers and BI Developers to successfully manage client projects
•Leading in founding team for ETL and BI implementation using (DATASTAGE, OBI, ODI and GOLDENGATE)
•Leading in founding team for BIG DATA analysis using HADOOP and its vertices (SQOOP, HIVE, PIG and FLUME)
Outsourcing to Vodafone Egypt as a member of extraction team, Data Warehouse department and My responsibilities include:
•Leading in development several ETL models (Using IBM Datastage)
•Participating in development Operational Data Source systems (Using IBM Datastage, CDC)
•Reviewing and understanding the business and data requirements of the various source and destination systems involved in enterprise ETL.
•Support daily extraction issues/failures.
•Applying daily data validation process
•Support data investigation and analysis for troubleshooting issues.
•Participating in problem investigation and proposing solutions.
•Technical meeting attendance and providing technical explanation regarding raised issues
•Leading in design, development and launching interface application between Ministry of Interior and Dubai Nationality and Residence Department to exchange images (Using Oracle Developer Suite (SQL, PL/SQL))
•Participating in design, development Naturalization Application (Using Oracle Developer Suite (SQL, PL/SQL, Forms, Reports))
•Participating in development interface application between UAE and OMAN (Using IBM WebSphere Message Broker)
•Participating in design and development interface application between Ministry of Interior and Dubai Nationality and Residence Department (Using Oracle Developer Suite (SQL, PL/SQL))
•Participating in development interface application between Ministry of Interior and Emirates Identity Authority (Using Oracle Developer Suite (SQL, PL/SQL))
•Participating in development Data Migration From Sharjah Police To Ministry of Interior (Using Oracle Developer Suite (SQL, PL/SQL))
•Participating in design and development application to perform ETL operation from Ministry of Interior to State Security Department (Using Oracle Developer Suite (Using SQL, PL/SQL))
•Performing Data maintenance ((Using SQL, PL/SQL))
•Participating in problem investigation and proposing solutions
•Technical meeting attendance and providing technical explanation regarding raised issues
•Performing QA and preparing UAT.
•Support customers via telephone and onsite 24/7
•Participating in analysis and design of Stores Management System
•Participating in development stores management system (Using Oracle Developer Suite 10g (SQL, PL/SQL, Forms, Reports))
•Leading in developement data migration procedures (Using PL/SQL)
•System Implementation and training users
•Support customers via telephone and onsite
My responsibility include participating in development Telecommunication Administration & Billing System (TABS) (Using Oracle Developer Suite 9i (SQL, PL/SQL, Forms, Reports)).
•Participating development Portfolio Information Management System (PIMS) using ( Oracle Developer suite 6i (SQL, PL/SQL, Forms, Reports))
•System Implementation and training users
•Support customers via telephone and onsite
•Participating in development Monofeya University Urolog Department System
•Participating in development system for Research Department System in Cairo Chamber of Commerce
•Leading development Insurance and Reinsurance Company System
•System Implementation and Training users
•Support customers via telephone and onsite
Thesis title is "An Access Control Model for Data Warehouse". Thesis presents an enhanced authorization model. The proposed model attempts to fix known security deficiencies in Data Warehouse (DW) and On-Line Analytical Process (OLAP). The proposed methodology is concerned with increasing the flexibility of the format of security rules. Besides, it utilizes a combination of facts and dimensions to set the required permissions to accomplish a task. As an integral part of this model, new methodology for avoiding wrong security impacts is shown. Such impacts could occur by using Slowly Changing Dimension (SCD) techniques, which track time-variant dimension modifications. In addition, a new language is presented to implement security predicates of data warehouse access control model (DWACM). This language is proposed on the basis of a mix of two languages: Data Control Language (DCL) and Multidimensional Expression (MDX). It utilizes commands to control access on facts, dimensions or a combination of facts and dimensions, including hierarchy levels and measures. It is effective and sufficient to implement all security rules defined by DWACM predicates. Publication URL: http://paper.ijcsns.org/07_book/html/201010/201010029.html
B.Sc., Faculty of Computer And Information, Computer Science Dep., Zagazig University Grade: Very Good Graduation Project Grade: Excellent 100% Graduation project: Solving Land Use Allocation Problem by using new technique Gene Expression Programming (GEP) to find the best allocation of land among number of activities