Oracle Teamleader
EIM
مجموع سنوات الخبرة :16 years, 4 أشهر
Main Modules
• Call center & Reservations.
• Work Shop.
• Hand Held.
• Inventory.
• Crm
• Purchase.
• Sales.
• Free zone. --from scratch
Primary Tasks are in
Reports, forms design, layout, and coding all done by me from scratch
This module work on the imports containers
Contain (chassis, spare parts) and storing this into site till
Selling it and making export invoice
This System Divided Into 3 Sub-Systems:
Call Center:
* We Receive Customer Call Then Take His Car Information And Register His Complaints Or Regular Service, Give Him Reservation Number, an Appointment And Promise Time To Take His Car From The Workshop, etc...
Hand Held:
* We Use Hand Held Scanner To Scan Car Barcode Then Chassis Information Will Display On Screen, Last Kilometer And Warranty Type, Reservation Number And Then You Can Open Job By Click Open And Then Take Car Bounds And Scratch Through Geographical Car Image.
Workshop:
* Here User Enter Job Materials, Job Operations And Engineers Working In Job, Discounts If Exists Then Print Work Shop Invoice.
There Is a Form Here Display Cars Status in Work Shop Periodically Like Ready, On Electricity Shop, Body Shop, Out, Other
* Inventory :
This System Have All Stock Transactions, Some Inquiry
Screens to Check Stock Quantity and Stock Value and etc.
* Sales : This System Have
o Sales Transactions, Reports and etc...
o Classification for Items likes A, B, C…
o Alternatives for Items and etc...
o Related with workshop system to issue materials and
Spare parts for workshop
I have participated in developing commercial Business solutions
1.Astra Financial Solution serves companies which needs financial systems.
2. Warsha serves cars spare parts companies and service centers.
Oracle 10g Developing Course. • Introduction to Oracle10g SQL (1Z0-007 Certified in progress). • Oracle 10g program with PL/SQL (1Z0-147 Certified in progress) OCA. • Oracle 10g Forms Developer (1Z0-141) OCP. • Oracle 10g Reports Developer. • Oracle 10g program with Advanced PL/SQL. Data Modeling and Relational Database Design. • Power Designer. Oracle Application Server Deployment. Attended at Syndicate of Applicators Information Technology& Training Centers (Nov2005-Sep2006). General English and Business Writing. Attended at Technology Club in Mansoura University. --------------------------------------------**------------------------------- • Very Good Command of Oracle DB 9i, and10g "SQL, PL/SQL Programming". Oracle Developer 6i, 9i, and 10g "Forms and Reports". • Good command in using Toad, Power builder. • Introduction to C & C++ Programming. • Introduction to Microsoft Certified System Engineering MCSE. • Very Good in Computer Hardware. • Internet, PC Networking, Programming, and Databases. • Very Good Knowledge to deal with different environments such as (Dos, Win98, WinMe, WinXP, Win2000 Professional, and Win2000 Server).
B.Sc. of Education. Mansoura University, Faculty of Education (Oct 2002- May 2006), Math Dept. General Grade "Good 70%".