Years Experience System
Resume:
Eskandar (Alex) Mekhoubat
Los Angeles, CA 90025
Telephone: 310-***-****
EMAIL *********@*****.***
Objective: AS/400 Senior Programmer/System Analyst or Project Leader.
Education: B.S in Mathematics - California State University Fresno
Programming
Languages: RPG /400 - 20 years experience - Excessive knowledge of Sub-files and
split sub-files,
CL programming - 20 years experience
RPG IV ILE - 10 year experience - Procedure, program, service program
DB2/UDB - 10 years experience - SQL, Store Procedure and Function
Cobol Dos/
Vs system 370 - 5 years experience
PLI Dos/
Vs system 370 - 5 years
Packages: J.D. Edwards R/7.3 - 9 years
Visual basic 6 – working as a hobby at home
Knowledge of: IBM Websphere - development (created some programs)
Oracle - forms and reports, Oracle PL/SQL and Oracle database express edition
Experience: 12/1998 – 12/2008
Transtar/Tiernay Metals
Programmer Analyst/Senior System Analyst
Reason for leaving: Transtar contracted out IT
• Introduced and started writing all new development in RPG ILE and assisted other programmers on the two AS/400 System V5R1, V5R2 with JDE/R7.3. One is serving all U.S. branches, one in the UK serving the European branches.
• Used DB2/UDB SQL interface to all programming I/O interface instead of AS/400 native I/O
• Write DB2/UDB user functions and procedures to facilitate updating of our database table or producing reports on the regular basis
• Developed a new sales order system for the European branches due to introduction of new lines of produces for tubing. The system includes cut to size, pick, pack, and shipped confirmation.
• Developed an end of the month reporting system for both branches which mails the accounting group on the first day of every month (17 reports). The system included: year to date roll, forward of inventory transaction, and sales of materials for the last 24 months.
• Designed and wrote an Inventory Cycle count system used by all branches on the basis of month end and auditor request.
• Electronic transfer of supplier order and forecast system
• Designed and developed a system to receive supplier orders on the daily basis and the forecast for material required on the weekly basis. The system includes receiving of orders on the company server
• Facilitated the daily processing of data. This includes the transfer of shipment information. Aide in the dissemination of 6 types of record formats for communication between the two companies IT. Also, insure receipt of electronic forecast report from suppliers for requested materials, which is sent to purchasing.
• Assisted users with their daily problems and question through the help desk
• Use SQL language to produce quick reports for management on demand and mail them as excel format
1997- 1998
Bugle Boy Industries
Programmer Analyst/Senior System Analyst
Long commute
• Due to expansion of the company’s warehouse in Georgia, analyzed existing systems and programs for modification.
• Rewrote new physical inventory system, allocation, and cancellation of customer’s sale order system.
• Modified NMC new version of Accounts Receivable (250 programs, CL, DSPF files) for Y2K compatibility as well as all Cl programming for upgrading of systems due to file name changes user requests for new programs.
1995-1997
Dental clinics (family business)
• Expanded package by writing subsystem in basic language for Novell 3.12/DOS operating system, automation of many manual daily activities and electronic claim transfer to insurance company (this language is similar to QBASIC), appointment register, and recall systems.
1986 - 1995
Polgate/Bagir industrial company at Tel-Aviv
Senior System Analyst
• Rewrote many of existing systems under S/38 including Physical inventory, purchasing, and materials replacement for production lines.
• Responsible for 62 stores for files transfers between PC and AS/400.
• Developed system of data transfer to UK branch office, thus eliminating duplicated data entry in UK office.
REFERENCES WILL BE FURNISHED UPON REQUEST
Contact this candidate