Python Data Science Developer
private
Total years of experience :23 years, 2 Months
Developing Data Science (Knowledge Based) Irrigation System using Tkinter, SQLite, Mongodb, PostgreSQL, Python, Pandas, Numpy, Matplotlib, xlsxwriter.
Preparing and teaching big data track courses and data science track courses
By next July I will have started teaching
1- Mongodb
2-Statistics using Python
3-Data Preprocessing (wrangling ) using python
4- Machine Learning using python
4- Business Statistics using Excel
5-Forecasting using Excel
6- Data Mining
7- Business Modelling and Simulation using Excel
8- Introduction to Columnar Big Data Apache Cassandra
9- Mongodb Express Angular Node fullstack course
10- Mongodb Express React Node fullstack course
11- Big Data Analytics
Project Management
Systems Analysis and Design
Creating the Repository
Building Answers & Dashboards
Building BI Publisher Reports
Building the Data Model and Report Layout
Results Verification & validation.
Delivering OBIEE and ODI courses
Teaching the following courses:
Data Science and its Applications in Biological and Agricultural Domains: Beginner (March 2017- April 2017)
Data Science and its Applications in Biological and Agricultural Domains: Intermediate (July 2017- August 2017).
Data Science and its Applications in Biological and Agricultural Domains: Advanced (December 2017- Jan 2018).
upgrading UMIS
Auto-advising subsystem
Auto-bifurcation subsystem
Improving reporting subsystems
a. Statistical reports
b. Graphical reports
c. Demographical reports
d. Decision Support reports
e. Data Mining reports
• Duties & Responsibilities:
Responsible for a couple of projects News Portal System (NPS) and the demo of Mobile Application for manager both projects were delivered for Lafarge - Egypt.
• NPS Project
Collecting system requirements from customer.
Introducing system proposal and functional properties.
Coordinate software project management plan tasks externally with the customer and internally with the developers.
Writing Software Requirement Specifications delivered internally.
Revising the database design.
• Mobile Application Project demo
Gathering the system requirements.
Introducing the system demo proposal to the customer and the assigned Indian company to perform the demo.
Building artificial data for the demo.
Fresh database instance, patches and upgrade installation
Weblogic sever, Weblogic portal, JDeveloper, SOA, OBIEE, and Informatica installation
Oracle products troubleshooting
Database backup/recovery, performance tuning, running scripts and start/stop services.
Building BI Publisher Reports
Building the Data Model and Report Layout
Testing & validating the results
Data migration using SQL Developer
• 30% of preliminary studies on Analysis and Design of e-learning qualitative research tool introduced
• 20% of preliminary studies on e-learning qualitative research tool introduced.
• 80% of data mining course taught.
• Supervising all data mining and qualitative research activities.
I ) Siebel, OBIEE, and database monitoring, troubleshooting, diagnostic.
II) Progress after joining Oracle (all the products I have already installed it on Windows 2003 before joining Oracle)
I have installed the following Oracle product on Oracle Enterprise Linux (Unbreakable):
II.1) Database 10g, 11gr1, 11gr2, XE.
II.2) Application Server 10g
II.3) Weblogic 11g
II.4) Oracle Warehouse Builder 10g, 11gr1, 11gr2.
II.5) Hyperion and Essbase 11g.
II.6) Oracle Data Integrator 11g.
II.7) SOA 10gR3.
II.8) Oracle Buisess Intelligence Enterprise Edition 11g.
II.9) Discoverer 10g
II.10) JDeveloper 11g
II.11) Oracle product that I have been self-studying its installation Siebel, Discoverer 11g, Weblogic portal and SOA 11g.
II.12) Database upgrade from 10.2.0.1 to 11.2.0.3 (9 versions upgrade) 32 and 64 bits.
II.13) Database patchset installation on 10 and 11 releases.
III) installing Oracle Solaris 10.
III.1) Oracle database installation is under investigation.
IV) I have installed the following Oracle products on Windows 2008:
IV.1) SOA 11.1.1.6
IV.2) ESB 11.1.1.6
IV.3) OBIEE 11.1.1.6
IV.4) Informatica PowerCenter 9
• 60-70% of taught technologies applied in their own projects.
• Install the training environment for the trainees.
• 1-2 student(s) in each group taught how to install.
• Installing Oracle Siebel Server (Public Sector) and Oracle SOA (self studying on Windows 2003). Installing Siebel client on Windows XP.
• Launching the usage of many software that converting document files into multi-formats (CHM, PDF etc.).
• 50% of Informatique IT documentation performed.
• Initiated the technical writer department in Informatique IT.
• Reverse engineering used to generate 90% of documentation because most systems do not have SRS and SDD documentations.
• 40% of Informatique projects’ documentations written (16 projects).
• Five BI Projects created HRMS, Sales, E-Sales, SCM, and CRM Projects.
• 80-85% of taught technologies applied in various projects.
• The most important achievement that it was the first-time for graduation project students in this College succeeded to apply these modules in their projects and to enhance their projects level.
Teaching Java for GUC students- Department of Engineering & Materials Science.
• Shared the constructing of MSA websites.
• From zero course uploaded to 380 courses uploaded out of 500 courses.
• More than 200 Instructors (MSA staff members) taught how to upload their course materials.
• Sharing in construction of MSA e-Library (not complete).
• Sharing in the preparation of Courses Program of Faculty of Biotechnology and Faculty of Pharmacy (Faculties Regulations).
• Investigating in Quality Management(CMMI, and SPICE).
• 100% User Manual revision.
• 40% Technical guide revision.
• Decrement 60% of data loss by backup.
• Decrement 50% of computer troubleshooting by enhancing users’ awareness.
• Revising 16 M. Sc. and Ph.D. theses.
• Revising 3 researches have been published in global journals.
• Revising all ACGEB projects’ annual reports.
Thesis entitled “Classification of Various Non-seasonal and Seasonal Forecasting Methods Based on Data Patterns”. Studies have been focusing on building forecasting models using C++, Matlab and Excel, evaluating forecasting accuracy measurements, relative indexes, performance monitoring, comparison between various models, Solver minimization. Forecasting models comprise moving average models, exponential smoothing models, and regression models. Forty methods were developed and 33 Historical Egyptian datasets were used. =================================================== PUBLICATION Accepted and Under Publishing 1. A. A. Warraquiy, Amira Hosny, I. H. A. Fattah , A. A. Badr Applying Time Series Analysis Using Various Forecasting Methods on Monthly Based (Seasonal) Data of Egypt Journal of Economics and Commerce 2. A. A. Warraquiy , Amira Hosny , Ismail H. A. Fattah , A. A. Badr Applying Time Series Analysis Using Various Forecasting Methods on Agricultural Yearly Based (Non-Seasonal) Data of Egypt Journal of Economics and Commerce 3. A. A. Warraquiy , Amira F. Hosny , I. H. A. Fattah, A. A. Badr Classification the Effect of MS Solver on Track Signals of Time Series Based on Data Pattern The second International Conference on Engineering and Technology (ICET 2014) held in April 2014 in GUC. ICET 2014 is technically sponsored by the IEEE. Future Publication 4. A. A. Warraquiy , Amira F. Hosny , I. H. A. Fattah , A. A. Badr Applying Time Series Analysis Using Various Forecasting Methods on Monthly Based (Seasonal) Data of Egypt without using Solver 5. A. A. Warraquiy , Amira F. Hosny , I. H. A. Fattah, A. A. Badr Applying Time Series Analysis Using Various Forecasting Methods on Agricultural Yearly Based (Non-Seasonal) Time Series Data of Egypt without using Solver 6. A. A. Warraquiy , Amira F. Hosny , I. H. A. Fattah, A. A. Badr Effect of using Solver on Track Signals of Trading Monthly Based (Seasonal) Data of Egypt
Separate Course - Business Studies Division with Grade B-
Official course
Official course
1- 11i Inventory Management Fundamentals 2- 11i Inventory Purchasing Fundamentals 3- 11i Inventory Order Management Fundamentals
Non official course
Official course
Official course
Official course
GPA=4 IUs= 12 1) Computer Graphics with grade “A-” 2) Introduction To Information Systems “A” 3) Information Systems: Theory and Practice “A” 4) Database Design “A” 5) Project Management “A” * Computer Graphics is not calculated. Because it is CS course but not IS course.
Oracle SQL/PL , Developer , and Designer . IUs =13.5
GPA = 3.8 Instructional Units = 65
International Language Institute, Heliopolis Branch, Cairo (a Branch of International House, London, England).
International Language Institute, Heliopolis Branch, Cairo (a Branch of International House, London, England).
International Language Institute, El Sahafeyeen Branch, Cairo (a Branch of International House, London, England).
International Language Institute, Heliopolis Branch, Cairo (a Branch of International House, London, England).
International Language Institute, Heliopolis Branch, Cairo (a Branch of International House, London, England).