Wanted: Los Angeles Job for AS400 Developer/Programmer

Information Systems professional specializing in Financial, Customer Service, Data Base Administration, Distribution, Manufacturing, Wholesale and Retail applications in the AS400 (iSeries) ERP environment.

* Excellent operations and technical hardware experience, education and abilities.
* Extensive experience with all types of software applications and AS/400 hardware configurations.
* Superior Developer and astute Business Systems Analyst with excellent Design Skills.
* Skilled in project management and the System Development Life Cycle (SDLC).
* Experienced in the enhancement and modification of legacy applications and packaged software.
* Evaluated, selected, and installed several major application software packages.
* Additionally analyzed, developed and implemented many custom enhancements and modifications.
* Developed several enterprise wide strategic plans for EDP and successfully implemented them.

PROGRAMMING SKILLS: AS400/iSeries
* Experienced with: RPG, RPGILE, RPG400, OS400, DB2, CL, CLILE, SDA, SEU, QRY(opnqryf), Query, CMS, AVR (Visual RPG/Basic), Caviar, Cobol, Fortran, Basic, Client Access, Hawkeye/Pathfinder, Aldon/Affiniti CMS, Turnover, DDS, SDA, RLU, Hawkeye, DBU, SQL, HTML, FTP, NET.DATA and many other utilities and sub-languages.
* Also Trained in: C++, UNIX, AIX, Novell
* Packaged Software and ERP applications: MAPICS, DFAS, DMS, DMASII, Lawson, JDA, PKMS
* Office Applications: Word, Excel, Access, Power Point, MS Project, Windows 95/98/2000/XP,

APPLICATIONS EXPERIENCE: Finance, Distribution, Wholesale, Retail, Manufacturing, Customer Service, Accounts Receivable (Billing and Invoicing), Order Entry, Cash Receipts, On-Line Customer Service Systems, Credit Card Transaction processing, General Ledger, Accounts Payable, A/P Check Reconciliation, Payroll Time and Attendance, Sick Leave and Vacation Accrual, Sales Analysis, Inventory Management, Inventory Control, Purchasing, Supply Chain, Receiving, Physical Inventory, Logistics, Sales and Marketing Analysis, Materials Requirements Planning (MRP - Bill of Material), Production Control and Costing (Work Orders and Shop Floor Control) and many others. I am also very experienced with SOX compliance and PCI DSS requirements.


AS/400 EMPLOYMENT HISTORY: Specializing in Financial, Supply Chain and Service applications in an AS400/iSeries ERP environment using OS400, RPG400, DB2 and Visual RPG.

• San Francisco, CA: Disability Insurance Company - Developed automated End of Day and End of Month Job stream for their AS400.
• San Jose, CA: Major Floor Covering Manufacturer – updated several AS400 MAPICS shop floor control reports and debugged some existing processes.
• Hollywood, CA: Major Movie Company - Updated AS400 legacy applications to new data base structures.

Concord , CA (3 Years 2002-05) Programmer – Sales Manager:  Self Employed. Ran a sales site on eBay selling misc. items. Also provided support for other online sales sites and eBay merchants. This period also includes some misc. part time, on call AS400 support for various companies.

Private Consulting and contract work – Northern, CA (1998 - 2003): Did Application Analysis, Project Management and Development for two companies.
* San Bruno , CA :  School Uniform Manufacturer - One year contract converting homegrown software to ASNA Visual RPG. Was fully trained in AVR. Developed a green screen RPG based materials tracking system for WIP at outside contractors. Developed a menu and object authority system written in Visual RPG and connected to the AS/400 DB2 UDB.
* Watsonville , CA : Major wholesale/retail boat supply catalog company - Started on a one year contract that turned into 2 ½ years. Converted homegrown software to be Y2K compliant. Modified hundreds of programs, screens and various other objects. Stayed on for another 1+ years providing development and maintenance programming services for company’s wholesale and retail catalog divisions. Primarily responsible for Credit Card processing but also maintained and modified their order processing systems.

Concord , CA (1997 – 1998) IS Director: Health Insurance Company. This was a hands-on position responsible for all facets of information systems. Company was using homegrown legacy systems for claims processing and health insurance eligibility. Developed an implementation plan for installing a packaged software system in addition to Y2K upgrade of current systems. Installed several PC networks communicating with the AS/400 using token ring, Ethernet and Windows NT (converted from Novel 3.12). Redesigned and implemented a multiple account check reconciliation system. Implemented a medical services provider system. Designed and implemented a basic web site and installed an e-mail system.

Private Consulting and contract work – Northern, CA (1995 - 1997): Did programming and systems analysis for five different Companies. All five companies had AS400’s.
* Concord , CA Contract Programmer/Project Manager: Major National Bank - Modified and enhanced an Inventory Asset Management system.
* Pleasanton , CA Senior Programmer: Health Insurance Capitation billing company - Developed various check processing systems.
* San Jose , CA Contract : IS Director: 1-year contract with a wireless TV cable company. Implemented an industry specific software package in a multi-site environment. Also developed a channel line up inventory and reporting system for billing.
* San Rafael , CA Contract Programmer: Short contract with a health insurance company converting a text database to Office 400.
* Pittsburg , CA Contract Programmer: Major aircraft coatings manufacturer - Performed maintenance programming for their Inventory bar code labeling system.

Vallejo, CA (7 years 1986-94) IS Director/Manager/Consultant/Software Provider: Provided outside contract services for this auto auction for 1+ years developing a custom distribution system for serialized product on a System 34, which I later converted to a System 36. I then accepted a position as General Manager responsible for Data Systems. Computerized all facets of this distribution and transportation business. After 4 years in this position returned to outside contracting. Beginning in 1992 designed and wrote a complete Auto Auction and Inventory Management System that is Y2K compliant. The new native AS/400 system consisted of every distribution and financial application and was made up of over 400 RPG programs, 800 CL programs, 200 display files, 100 physical files and 200 logical files. This multi-company system was installed on one AS400 system in Vallejo supporting over 11 locations, one AS400 system in Texas supporting over 6 locations and one AS400 system in Atlanta.

EDUCATIONAL BACKGROUND:
Diablo Valley  College - AA - Business and Computer Science
San Francisco State  University  - Pre BA - Business and Economics
Control Data Institute of Technology - Programming Certificate
Continuing management and technical education obtained by regularly attending professional seminars, conferences and Information Systems related courses.