04/07/2024 updated
OE
100 % available
Informatiker
Cairo, Egypt
Germany +2
info: Germany, Austria, Switzerland
AS400 IBM Iseries IBMi DB2 SQL Oracle Mysql MSSQL TSQL PlSql VB.net C# VB6
Name: Othman Mohammad Ahmad Emara.
Tel. : +2 01554052218 E-mail: OTH125@yahoo.com
 Educational Level
University Degree: B.Sc. of Communication & Electronics Engineering.
University: Tanta. Grade: good. Grade OF Project: Excellent.
Graduation Project: Wireless Local Area Network: WLAN. Graduation Year: 2001.
Spoken Language: English Degree: very good.

Experience
Visual C.V. <<< click here + press ctrl to see my video on YOUTUBE
Proof of work remotely ability https://www.youtube.com/watch?v=B9u-OI44860&t=83s
Current job: CEO and Founder of Control Soft
Also IT manager at VTCTanta http://www.vtctanta.me.pn
Responsible for all deployed plans and new developments related to IT field.
Giving IT courses / Maintains the web site / Developing in Java / Kotlin
Past job: Senior Analyst in KFH Bank starting from 15/6/2010 tell 31/7/2013:
Responsibilities:
Analysis-design-deploy at SDID (System Developing & Integration Dept.). at KFH Commercial Sector , where we always have innovation for financial products in Car leasing , Home building , helping customers acquiring many diverged Assets
Responsible for all deployed plans and new developments .
The Environment was TDD , where we-each quarter-put new version of the programs ,which was including changes in CRM , leasing , All diverged financial products ,All were full programmatically controlled using our in-house developed programs ( called EazyWay) .
Applying department’s needs (use cases).
Daily work was to assist USE case makers (BCD business consultant dept. ) in collecting current business logic from the program , helping them in Use Cases design ,UML modeling & Case-changes /Impact studies. Then object oriented coding the UseCase following scrum / agile meeting instructions until give the code/database changes to the test department , after that the use case fluctuate between SDID dept (my dept) and (Test Dept) fixing their test bugs found if any, then attending all user test (all grades Key /normal / agressive user) until getting UAT . then as per the quarter schedule the new code go with the database scripts changes to the deploy dept .
All code changes is documented in many things like Jira , Versioning tools (CVS , SVN , Visual SourceSafe ), database changes are well documented .
KFH web site having MVC- ASP architect where all developers from all sectors (Banking – Commercial – Real state ) understand and can consume its encrypted web services .
Developing in VB6, VB.net , Java and C# extracting business logic, making modifications, can be in many cases applying whole use case (professional in developing / debugging in VB6 , VB.net ,Java and C# see last two minutes of my video as proof of complex application that use many tools ).
Managing projects related to data warehouse- data migration-BI.
Applying regulations of Kuwait Central Bank (we must obey the CBK for regulations relating to funds given to Syrians or Aged Kuwities > 60 ..etc).
Used Databases SAP-Oracle-AS400.DB400- SQL server – DB2
Manage large code-base of VB6 , VB.net , Java and C# all flavors related to many projects deployed.
Past job: AS400 system expert: analyst/ Programmer /admin in CTS: Computer Troubleshooters company –a company of GFC: Gulf Franchises Company (Kuwait) in the period 2008/1 till 15/6/2010 (work at Mercedes Benz Agent in Kuwait)
http://www.cts.com.kw also http://www.technology-solved.com/international/
Responsibilities: All tasks of AS400/DB2 Programming & Administration
Study impacts of programs amendments, changing them, testing (with the help of experienced users), put live …applying alone all SDLC.
Integrate the AS400 system with other systems by making VB6 , VB.net , Java and C# programs …samples below (professional in developing / debugging using VB6 , VB.net ,Java and C# making programs to manipulate bulk data, integrating databases / systems, ADO connection to DB /ODBC professional in VB6 , VB.net , Java and C#).
Develop new PGMS and maintains old written in RPG, RPGLE, SQLRPGLE, RPGII (S36), RPG400, CL, CLLE, COBOL, , SQLCBLLE CBL36, Embedded SQL, VB.net / Java / C# using SEU and ,
SQLRPGLE Rational Developer for system i and Microsoft visual studio.
SQL / RLU / Qry400 / DFU /IDIS all modules, programs expert .
Professional in all kinds of AS400 tools SDA, DDS, RLU, Strsql, Qry400, DFU, #Gsort…etc
Deal with flat files & RDB files, Database Mining and Business intelligence.
Prepare reports of decision making.
End of year process (database tasks) & stock counting administration (running programs/reports).
Fix daily problems -Making Tape Backup/Restore of libraries, directing of spool files to printers, watching files/ Database size ...all admin tasks.
Company scope : parts retail / car service/ car repair claims (the solo Mercedes car agent …ie. exclusive commercial / passenger cars)
http://mercedesbenzme.com/kuwait/en also http://www.bisherkazemi.com/company.html
Past job: computer engineer in Nassem co-op super market in Kuwait in the period 2005/9 to 2008/1
Responsibilities: All the tasks of IT Dept. manager including:
EDP of more than 60 POS (retails Sales) , PLU update , all daily tasks , maintenance , gathering data.
End of year process (database tasks) & stock counting administration (running programs/reports).
SQL2000 server Data Base administration & maintenance & tape backup.
Making Oracle 6i reports / VB6 , VB.net / Java and C# programming (expert level).
Company Scope: All goods Retails FMCG (CPG) & others http://www.naseemcoop.com/
Universal Certifications:
1) ICDL (International Computer Driving License).
2) AS/400 RPG IV (aka RPGLE or RPG ILE) Programmer.
3) IBM Certified Solutions Expert – DB2 UDB V7.1 USER.
4) CIW410 (Certified Internet Webmaster) HTML / WEP developing
Familiar with these operating systems:
• iSeries & AS400 Systems(IBM OS/400 System).
• Microsoft operating systems (server & pc versions of windows).
• Ubuntu Linux (server & pc versions).
• Z/os &OS390.
Familiar with these Databases and already wrote visual basic programs that deal with:
• DB (AKA DB2/400 or DB400) under AS400 and Z/os.
• Oracle :professional in writing PL/SQL procedures & Toad ,reporting tools -oracle 6i-11g.
• DB2 UDB.
• SQL server (Microsoft) : administration /Backup , writing T-SQL.
• Mysql.
Other qualifications:
Deep experience with data base design ,databases integration in compliance with business logic.
ERP applications experience; solved many integrations problems using coding techniques.
User passion oriented & high troubleshooting skills.
Trained on Z/os & OS390 and already made Cobol programs on it.
Understand of business logic in many environments (Retail/Automobile service, warranty and claims).
Experienced in VBA.
Professional in reporting tools specially oracle 6i-Crystal report (starting from 7- Seagate version- tell visual studio combined version).
Trained at IBM for six months (900 hour program).
Have a valid Kuwaiti / GCC (Gulf) driving license.
What can I do /Guide team to do? Just watch this https://www.youtube.com/watch?v=B9u-OI44860&t=83s
1. Extracting business requirements from users/managers making [Use cases] demonstrating new modifications / requirements in any AS400/ .net / Oracle forms system.
2. Extracting current business logic deeply stored in any AS400/ .net / Oracle forms, system. Demonstrating the current logic / ambiguous action of any module.
3. Modify any AS400/ .net / Oracle forms ,MVC (in ASP or PHP) even complete ERP system/modules/ programs to comply with new use cases.
4. Enhance any current system making dayend / monthend / year end Automated / easier / rich in reports / less error prone.
5. Save any deadly stopped dayend/ month end (AS400 program hang). with all reports given ( not by truncating any branch / reports but by FIXing it giving all reports , none is missing because of no code truncations… data / reports saved & all fixed ).
6. Integrating windows systems / PCs with AS400/ .net / Oracle forms ERP systems; giving windows interface for AS400 cored database. Or
7. Integrating windows systems / PCs with AS400/ .net / Oracle forms ERP systems by making two simultaneously integrated databases (one of them is AS400 cored databaseDB400 other is Oracle / DB2 /MySQL/ MS SQL Server); giving windows interface for AS400 cored database in order to build complete Data Warehouse.
8. Migrating all AS400 Database data to other database (writing SQL scripts( TSQL / PL SQL) / coding necessary programs).
9. Professional in developing in VB6 , VB.net ,Java and C# (Debugging /New developments expert in using the VB6 visual studio adding watches or using ctrl Break , also the same in Visual studio vb.net /C# 2013 ).
10. Professional in using JIRA adding complete task, complete descriptive text.
11. Familiar in using version control softwares, source safe all versions,GIT, tortoise SVN/ CVS, winmerge , other developer tools integrating it with JIRA.
12. Professional in reports VB6 using Seagate crystal report7 / or MS word bookmarks
13. Expert in web services ,Json,XML, Gradle , Maven,Ant, encryptions and Joomla php MVC .
14. Expert in developing using HTML , manipulating XML data and VBA coding.
15. AS400 systems administration tasks expert also with few keystrokes can identify which user running which program causing system hang (database record release waiting )
16. Haveing experience making SSIS ,SSRS ,SSAS , ETL packeges .
To summarize can do anything in coding/integration / programing related to any AS400 platform /Windows platform (Using VB6/ VB.net /C# in any farme work versions starting from VS2003 or .NET 4.0+) / AS400 database / Windows platform databases ( MySQL / Oracle/MSSQL expert in PLSQL / TSQL / SQL) see my old YouTube video for details also see pictures below.
Trained in IBM for 900 hours .
AS/400 Programming Track
Courses, Course Pre-requisites & International Certification Tests
Course Code Course Name Hours Prerequisites Intr. Possible Certification Tests
Prosoft - 1IF General IT Courses 119
Prosoft - 2NF Internet Fundamentals 28 General IT Knowledge
Prosoft-2WPAF Networking Fundamentals 28 Prosoft -1IF
Programming Language Concepts 35
Web Pages Authoring Fundamentals 28 Prosoft - 1IF
Advanced IT Courses 35
IBM-CZ 12 Introduction to Data Structure and Algorithms 35
Programming Courses 84
Prosoft-5OOAD OO Analysis and Design 42
Prosoft-5JPF Java Programming Fundamentals 42
DSS / BI Courses 84
IBM - CF03 DB2 FAMILY FUNDAMENTALS 42
IBM - CF12 SQL WORKSHOP 42
AS400 Core 322
OL29 AS/400 System Operator 42
OL49 AS/400 Concepts and Facilities WorkShop 49 IBM-EP50
OL20 AS/400 Control Language Programming WorkShop 49 IBM-MM15
OL62 DB2/400 Coding & Implementation 28
OL37 Accessing the AS/400 Application Using SQL 28
OL86 RPG IV Programming WorkShop 49 IBM AS/400 266
OL88 RPG IV Advanced Topics WorkShop 49
OL38 Developing AS/400 Application using SQL 28
Management 35
IBM-EP50 Project Management Principles using MS Project 21 General Business Knowledge
IBM-MM15 Principles of Marketing Management 14 General Business Knowledge
Total Training Hours 679
Project Duration 221
Total Track Hours 900
International Certification IBM Certified Specialist - AS/400 RPG IV Programmer
Name: Othman Mohammad Ahmad Emara.
Tel. : +2 01554052218 E-mail: OTH125@yahoo.com
 Educational Level
University Degree: B.Sc. of Communication & Electronics Engineering.
University: Tanta. Grade: good. Grade OF Project: Excellent.
Graduation Project: Wireless Local Area Network: WLAN. Graduation Year: 2001.
Spoken Language: English Degree: very good.

Experience
Visual C.V. <<< click here + press ctrl to see my video on YOUTUBE
Proof of work remotely ability https://www.youtube.com/watch?v=B9u-OI44860&t=83s
Current job: CEO and Founder of Control Soft
Also IT manager at VTCTanta http://www.vtctanta.me.pn
Responsible for all deployed plans and new developments related to IT field.
Giving IT courses / Maintains the web site / Developing in Java / Kotlin
Past job: Senior Analyst in KFH Bank starting from 15/6/2010 tell 31/7/2013:
Responsibilities:
Analysis-design-deploy at SDID (System Developing & Integration Dept.). at KFH Commercial Sector , where we always have innovation for financial products in Car leasing , Home building , helping customers acquiring many diverged Assets
Responsible for all deployed plans and new developments .
The Environment was TDD , where we-each quarter-put new version of the programs ,which was including changes in CRM , leasing , All diverged financial products ,All were full programmatically controlled using our in-house developed programs ( called EazyWay) .
Applying department’s needs (use cases).
Daily work was to assist USE case makers (BCD business consultant dept. ) in collecting current business logic from the program , helping them in Use Cases design ,UML modeling & Case-changes /Impact studies. Then object oriented coding the UseCase following scrum / agile meeting instructions until give the code/database changes to the test department , after that the use case fluctuate between SDID dept (my dept) and (Test Dept) fixing their test bugs found if any, then attending all user test (all grades Key /normal / agressive user) until getting UAT . then as per the quarter schedule the new code go with the database scripts changes to the deploy dept .
All code changes is documented in many things like Jira , Versioning tools (CVS , SVN , Visual SourceSafe ), database changes are well documented .
KFH web site having MVC- ASP architect where all developers from all sectors (Banking – Commercial – Real state ) understand and can consume its encrypted web services .
Developing in VB6, VB.net , Java and C# extracting business logic, making modifications, can be in many cases applying whole use case (professional in developing / debugging in VB6 , VB.net ,Java and C# see last two minutes of my video as proof of complex application that use many tools ).
Managing projects related to data warehouse- data migration-BI.
Applying regulations of Kuwait Central Bank (we must obey the CBK for regulations relating to funds given to Syrians or Aged Kuwities > 60 ..etc).
Used Databases SAP-Oracle-AS400.DB400- SQL server – DB2
Manage large code-base of VB6 , VB.net , Java and C# all flavors related to many projects deployed.
Past job: AS400 system expert: analyst/ Programmer /admin in CTS: Computer Troubleshooters company –a company of GFC: Gulf Franchises Company (Kuwait) in the period 2008/1 till 15/6/2010 (work at Mercedes Benz Agent in Kuwait)
http://www.cts.com.kw also http://www.technology-solved.com/international/
Responsibilities: All tasks of AS400/DB2 Programming & Administration
Study impacts of programs amendments, changing them, testing (with the help of experienced users), put live …applying alone all SDLC.
Integrate the AS400 system with other systems by making VB6 , VB.net , Java and C# programs …samples below (professional in developing / debugging using VB6 , VB.net ,Java and C# making programs to manipulate bulk data, integrating databases / systems, ADO connection to DB /ODBC professional in VB6 , VB.net , Java and C#).
Develop new PGMS and maintains old written in RPG, RPGLE, SQLRPGLE, RPGII (S36), RPG400, CL, CLLE, COBOL, , SQLCBLLE CBL36, Embedded SQL, VB.net / Java / C# using SEU and ,
SQLRPGLE Rational Developer for system i and Microsoft visual studio.
SQL / RLU / Qry400 / DFU /IDIS all modules, programs expert .
Professional in all kinds of AS400 tools SDA, DDS, RLU, Strsql, Qry400, DFU, #Gsort…etc
Deal with flat files & RDB files, Database Mining and Business intelligence.
Prepare reports of decision making.
End of year process (database tasks) & stock counting administration (running programs/reports).
Fix daily problems -Making Tape Backup/Restore of libraries, directing of spool files to printers, watching files/ Database size ...all admin tasks.
Company scope : parts retail / car service/ car repair claims (the solo Mercedes car agent …ie. exclusive commercial / passenger cars)
http://mercedesbenzme.com/kuwait/en also http://www.bisherkazemi.com/company.html
Past job: computer engineer in Nassem co-op super market in Kuwait in the period 2005/9 to 2008/1
Responsibilities: All the tasks of IT Dept. manager including:
EDP of more than 60 POS (retails Sales) , PLU update , all daily tasks , maintenance , gathering data.
End of year process (database tasks) & stock counting administration (running programs/reports).
SQL2000 server Data Base administration & maintenance & tape backup.
Making Oracle 6i reports / VB6 , VB.net / Java and C# programming (expert level).
Company Scope: All goods Retails FMCG (CPG) & others http://www.naseemcoop.com/
Universal Certifications:
1) ICDL (International Computer Driving License).
2) AS/400 RPG IV (aka RPGLE or RPG ILE) Programmer.
3) IBM Certified Solutions Expert – DB2 UDB V7.1 USER.
4) CIW410 (Certified Internet Webmaster) HTML / WEP developing
Familiar with these operating systems:
• iSeries & AS400 Systems(IBM OS/400 System).
• Microsoft operating systems (server & pc versions of windows).
• Ubuntu Linux (server & pc versions).
• Z/os &OS390.
Familiar with these Databases and already wrote visual basic programs that deal with:
• DB (AKA DB2/400 or DB400) under AS400 and Z/os.
• Oracle :professional in writing PL/SQL procedures & Toad ,reporting tools -oracle 6i-11g.
• DB2 UDB.
• SQL server (Microsoft) : administration /Backup , writing T-SQL.
• Mysql.
Other qualifications:
Deep experience with data base design ,databases integration in compliance with business logic.
ERP applications experience; solved many integrations problems using coding techniques.
User passion oriented & high troubleshooting skills.
Trained on Z/os & OS390 and already made Cobol programs on it.
Understand of business logic in many environments (Retail/Automobile service, warranty and claims).
Experienced in VBA.
Professional in reporting tools specially oracle 6i-Crystal report (starting from 7- Seagate version- tell visual studio combined version).
Trained at IBM for six months (900 hour program).
Have a valid Kuwaiti / GCC (Gulf) driving license.
What can I do /Guide team to do? Just watch this https://www.youtube.com/watch?v=B9u-OI44860&t=83s
1. Extracting business requirements from users/managers making [Use cases] demonstrating new modifications / requirements in any AS400/ .net / Oracle forms system.
2. Extracting current business logic deeply stored in any AS400/ .net / Oracle forms, system. Demonstrating the current logic / ambiguous action of any module.
3. Modify any AS400/ .net / Oracle forms ,MVC (in ASP or PHP) even complete ERP system/modules/ programs to comply with new use cases.
4. Enhance any current system making dayend / monthend / year end Automated / easier / rich in reports / less error prone.
5. Save any deadly stopped dayend/ month end (AS400 program hang). with all reports given ( not by truncating any branch / reports but by FIXing it giving all reports , none is missing because of no code truncations… data / reports saved & all fixed ).
6. Integrating windows systems / PCs with AS400/ .net / Oracle forms ERP systems; giving windows interface for AS400 cored database. Or
7. Integrating windows systems / PCs with AS400/ .net / Oracle forms ERP systems by making two simultaneously integrated databases (one of them is AS400 cored databaseDB400 other is Oracle / DB2 /MySQL/ MS SQL Server); giving windows interface for AS400 cored database in order to build complete Data Warehouse.
8. Migrating all AS400 Database data to other database (writing SQL scripts( TSQL / PL SQL) / coding necessary programs).
9. Professional in developing in VB6 , VB.net ,Java and C# (Debugging /New developments expert in using the VB6 visual studio adding watches or using ctrl Break , also the same in Visual studio vb.net /C# 2013 ).
10. Professional in using JIRA adding complete task, complete descriptive text.
11. Familiar in using version control softwares, source safe all versions,GIT, tortoise SVN/ CVS, winmerge , other developer tools integrating it with JIRA.
12. Professional in reports VB6 using Seagate crystal report7 / or MS word bookmarks
13. Expert in web services ,Json,XML, Gradle , Maven,Ant, encryptions and Joomla php MVC .
14. Expert in developing using HTML , manipulating XML data and VBA coding.
15. AS400 systems administration tasks expert also with few keystrokes can identify which user running which program causing system hang (database record release waiting )
16. Haveing experience making SSIS ,SSRS ,SSAS , ETL packeges .
To summarize can do anything in coding/integration / programing related to any AS400 platform /Windows platform (Using VB6/ VB.net /C# in any farme work versions starting from VS2003 or .NET 4.0+) / AS400 database / Windows platform databases ( MySQL / Oracle/MSSQL expert in PLSQL / TSQL / SQL) see my old YouTube video for details also see pictures below.
Trained in IBM for 900 hours .
AS/400 Programming Track
Courses, Course Pre-requisites & International Certification Tests
Course Code Course Name Hours Prerequisites Intr. Possible Certification Tests
Prosoft - 1IF General IT Courses 119
Prosoft - 2NF Internet Fundamentals 28 General IT Knowledge
Prosoft-2WPAF Networking Fundamentals 28 Prosoft -1IF
Programming Language Concepts 35
Web Pages Authoring Fundamentals 28 Prosoft - 1IF
Advanced IT Courses 35
IBM-CZ 12 Introduction to Data Structure and Algorithms 35
Programming Courses 84
Prosoft-5OOAD OO Analysis and Design 42
Prosoft-5JPF Java Programming Fundamentals 42
DSS / BI Courses 84
IBM - CF03 DB2 FAMILY FUNDAMENTALS 42
IBM - CF12 SQL WORKSHOP 42
AS400 Core 322
OL29 AS/400 System Operator 42
OL49 AS/400 Concepts and Facilities WorkShop 49 IBM-EP50
OL20 AS/400 Control Language Programming WorkShop 49 IBM-MM15
OL62 DB2/400 Coding & Implementation 28
OL37 Accessing the AS/400 Application Using SQL 28
OL86 RPG IV Programming WorkShop 49 IBM AS/400 266
OL88 RPG IV Advanced Topics WorkShop 49
OL38 Developing AS/400 Application using SQL 28
Management 35
IBM-EP50 Project Management Principles using MS Project 21 General Business Knowledge
IBM-MM15 Principles of Marketing Management 14 General Business Knowledge
Total Training Hours 679
Project Duration 221
Total Track Hours 900
International Certification IBM Certified Specialist - AS/400 RPG IV Programmer