Customer Service Quality Assurance

David W. Sherwood

Objective:

Seeking a position in the Information Systems field that will allow me the opportunity to apply and expand my training, experience, and qualifications as a Senior Programmer/Systems Analyst to provide analytical and technical solutions to business opportunities.

Experience:

Vision IT 3031 W. Grand Blvd., Ste.695, Detroit, MI 48202

Assignment: Avery/Dennison 50 Pointe Dr, Brea, CA 92821

From 10/2007 to 07/2008 and from 04/2009 to 12/2009

Contract Systems Analyst/Programmer

Program support/enhancements to ILS logistics package on AS/400.

Strong knowledge of AS/400 RPG, RPGLE, COBOL, CL, SQL (including embedded SQL), DB2, DBU and WRKDBF (DBU like application).

Responsible for support of IMS/DSRP (Data Solutions Requirements Planning) software running on the PCs located in the plants. Software is FoxPro 2.6 & 7.0. Duties also included working with customer to define, design, code, test and implement enhancements and support production issues.

Use of PCAnywhere to access remote PC for support and analysis of IMS/DSRP.

Additional knowledge of PC applications Microsoft Word/Access/Excel, Lotus Notes, Visio, Client Access (Emulation and File Transfer).

Apex Systems, Inc 4100 Newport Place, Suite 810, Newport Beach, CA 92660

Assignment: Western United Insurance (aka CSAA)

From 10/2005 to 10/2006

Contract Systems Analyst/Programmer

Responsible for support of SIS reporting on the AS400 in RPG & RPGLE. Duties also included working with Quality Assurance staff to define, design, code, test and implement SIS Reporting enhancements and interfaces with other systems/applications.

Supported Forms Generation using Optio on AS400.

Experience using Aldon, a Change Management tool.

Experience using Hawkeye/Pathfinder.

International Management Sys. 4640 Admiralty Wy, Ste 1101, Marina del Rey, CA 90292

Assignment: ConAgra Grocery Foods Group

From 08/1998 to 07/2005

Contract Systems Analyst/Programmer

Responsible for support of BPCS on the AS400 using RPG/RPGLE, CL, SQL (including embedded SQL), DB2. Duties also included working with internal & external customers to define, design, code, test and implement BPCS enhancements and interfaces with other systems/applications.

Supported ConAgra designed Manufacturing System, written in COBOL in an SSP SYS/36 Environment on an AS400.

Worked with EDI extracts and interfaces to other AS/400s, mainframes and network servers.

Worked with Y2K Team to determine year 2000 impact on systems, to design, test and implement required Y2K modifications on SSP SYS/36 Systems.

Beech Street Corp/Healtheon 173 Technology, Irvine, CA. 92618

From 06/1994 to 08/1998

Senior Systems Analyst

Responsible for interaction with internal/external customers and I.S. team members to define, design, code, implement new systems and/or enhancements to current systems solving medium to complex level business needs.

Strong AS/400 COBOL, RPG/400, and AS/400 CL knowledge. Also knowledge of SQL, SYNON, Sylvon (Change Management), DBU and DB2.

Knowledgeable in many PC software packages, including Microsoft Word, Excel, Access, Word Perfect 5.X/6.X, Lotus 1-2-3, and dBase IV.

AS/400 Systems include Claims Repricing, Provider Maintenance, and Invoicing.

Worked on EDI extracts and interfaces to other AS/400s, PCs and network servers.

Worked with Y2K Analysis Team to determine year 2000 impact on systems.

Responsible for design, coding, testing, implementation and maintenance of systems/programs solving medium to complex level business needs.

AS/400 Systems include Utilization Management (Outpatient) and the PPO Provider.

R. H. Donnelley (Donnelley Info. Pub.) 691 S. Parker St. Orange, CA. 92668

From 03/1986 to 03/1994

Lead Programmer

Responsible for design, coding, testing, implementation and maintenance of systems/programs solving medium to complex level business needs.

Systems include Credit/Collections, Customer Service, Payroll/Commissions, Sales/Marketing, and Publishing Support systems on IBM PC (and compatible), Novell LANs (ver 2.13 and 3.11), SYS/36, AS/400 and IBM 3090 mainframe.

Assisted Accounts Payable on use of the McCormick and Dodge Accounts Payable system.

Programming languages used were COBOL, RPG/400, Clipper/dBase III & IV, Natural 2.2, OCL, CL and JCL. Also knowledge of Physical/Logical files on the AS/400 and ADABAS 5.1 on IBM 3090.

Knowledgeable in many PC software packages, including Lotus 1-2-3, Quatro Pro, Paradox, Word Perfect, Microsoft Word, Harvard Graphics, dBase IV and Corel Draw.

Performed Tech Support duties of installation/upgrade of equipment and software as needed. Recommended purchase of equipment and software.

Trained users (individual and small groups) on equipment and software usage as needed.

Operations Manager:

Responsibilities included - daily operation tasks on the AS/400, SYS/36, Novell LANs and the 3274/3745 communications equipment. Also responsible for recommending, purchasing, installation, and upgrade of equipment, software, cabling and communications needs for the business.

Worked on planning/installation of cabling/electrical needs and transportation/installation of equipment when corporate office moved to new location.

Assisted in setup of new communication network (via T1, fractional T1, 9600 and 56 kb lines) between corporate office in Orange, 6 satellite offices (in LA, Orange, San Bernadino and San Diego Counties) and the company Data Center on the east coast. Systems linked to the network were the Novell LANs, AS/400, SYS/36 and the IBM 3090 using an IBM 3745 Communications Controller, IBM 3174/3274 Controllers. Knowledge of MSRJE on the AS/400 and SYS/36.

Setup of ArcNet and Token Ring LANs with 50+ users.

Supervised operation and tech-support staff.

Education:

Control Data Institute Anaheim, CA.

Computer Programmer/Operator 1981

Rancho Santiago College Santa Ana, CA.

Programming Courses 1981-1984

Cerritos College Cerritos, CA.

RPG/400 Course 1994

References: Available upon request.

Contact this candidate