Maintenance System

MARIA Y. DOTY

***** ******* *******, ** ***** 734-***-****

ablbwk@r.postjobfree.com

SUMMARY I am an experienced Information Systems professional with a solid

background in business and management. Over twenty years of experience in

IBM AS/400, ERP, and upload and download AS/400 database file to PC.

Also, I have extensive experience in the design and maintenance of business

applications. Skills include analysis, design, development, implementation,

migration, testing, documentation, training, and user support. Experience in

Genelco insurance package, Warehouse Management System, Interface with

Border sales and invoice to Lawson financial system, JD Edwards financial

interfacing with Flint Ink home grown distribution system along with

manufacturing, forecasting and inventory control using bar coding system on

both batch and RF, expose to MAPICS and SYNON. I am proficient in

ROBOT scheduling, AS400 Query, RPG/IV, RPG/400, RPG ILE, CLLE,

Subfile, external files, external print file, journaling, Turnover CMS, DBU,

Hawkeye, and SQL programming. I am familiar with SQL server and XML

programming in AS400. Excellent on collecting requirements from users,

design specification base on the information that I collected, writing

technical specification, develop and deploy to the work force.

HARDWARE IBM AS/400 (20+ yr.), Microsoft Word, Excel, Visio and Power Point.

LANGUAGES RPG IV/400/III, RPG ILE (20+ yr.), SQL, SQL server, PL SQL, some

XML. Had training on XML, Java, and Object Oriented concept. Took

Java Script and Java programming class at Schoolcraft College.

SOFTWARE IBM AS/400: Gelenco package, Warehouse Management System,

Application Developer in Manhattan Associate WMS system, DBU, Robot,

Hawkeye, Abstract Pro, Query/400.

PC: MS Windows 2000/98/95, MS Excel, MS Word, MS

PowerPoint, Vision, Flow Charting, Lotus Notes and Compuware Change

Point.

APPLICATIONS Financials: Accounts Payable, Accounts Receivable, General Ledger, Payroll.

Distribution: Inventory Management, Order Processing, Purchasing,

Shipping.

Manufacturing Bill of Material, Material Requirements Planning, Shop Floor

Control, Planning/Scheduling, Work Center Data Collection, Warehouse

Management System. Application Developer in Manhattan Associates WMS

system. Bar Code (batch and RF).

EDUCATION Bachelor of Science in Computer Science, Madonna University, Livonia,

Michigan.

Fluent in speaking, reading and writing in Cantonese.

WORK EXPERIENCE (20+ years)

03/08 – 08/10 Programmer Analyst, Borders Group Incorporate, Ann Arbor, MI.

• Maintenance and enhancement - during this short period of time, I have

finished 17 tasks and build a good relationship with AP and inventory

personnel. I am writing in Free RPG, use user space to fill the subfile, and

binding directory with module. Program feed from AS/400 to Lawson

Financial in Unix box. Work on Warehouse Management System. Modify

script using PL SQL on unix / oracle box for reports in Lawson and Retek

System.

06/00 – 12/07 Senior Programmer Analyst, AAA Life Insurance Company, Livonia, MI.

• Direct Term project – responsible on rewrite the solicitation schedule,

modified the lead time schedule, lock box processing and new direct term

reports.

• ECM project – new product group maintenance, new group line

maintenance, new line sequence maintenance, various interface program

and new reports.

• OFAC project – new OFAC maintenance allow users to add, change,

delete batch, lines, send a single or multiply batches to the vendor site,

resend capability, allow closed batches to be purge out after x days, and

new reports.

• Club encryption and decryption project – encrypted and decrypted FTP

files to various clubs.

• House keeping issues, compliance issues, IAT issues, other projects that

not listed.

• Production maintenance support.

• Production on call support.

• Queries 400 for company users and download AS/400 db to excel spread

sheets to various departments.

05/93 - 06/00 Senior Programmer Analyst, Flint Ink Corporation, Ann Arbor, MI.

• Responsible for home grown Branch Distribution System, which includes

order fulfillment, shipping, packing slip, shipper, invoice, manufacture,

inventory using bar code (batch and radio frequency), forecasting, shop

floor, material requirement planning, various inquiries, reports.

• Rewrite Tote Tracking System and Consignment Invoicing.

• Responsible for interfacing with JD Edward financial system.

01/91 - 05/93 Data National, Novi, MI.

• Responsible for Adams Distribution System.

• Responsible for Access Accounting System.

• Custom Coding for client specification.

• Maintenance on EDI and Auto Lease.

03/89 - 12/90 Intergral Midrange/Wright Systems, Plymouth, MI.

• Performed various analysis, design, and programming tasks on an IBM

AS/400.

• Fixing SYNON programmer bugs.

• Custom coding for outside client.

04/88 - 03/89 Microtek Inc, Livonia, MI.

• Maintain and enhanced financial and distribution system.

• Automated month end processes.

07/84 - 03/88 Future Three Software, Livonia, MI.

• Maintain and enhanced automotive release packages.

• Developed new programs/reports for the accounts receivable / payable

which interfaced with MAPICS software.

• Documentation on all home grown packages.

REFERENCES Available upon request.

Contact this candidate