Bob Depperschmidt Email & Phone Number

Clifton Park, Ny

Supporting the System i, central processing site, of the New Jersey WIC program on a contract through CMA Consulting Services Inc.DUTIES: Provide expertise in complex environments within the System i RPG technologies. Support for new development, change, or maintenance. Support requests come from our clients at the New Jersey WIC program. Individual requests have resulted in a range from changing 80% of the system to reporting information on one individual. Requests are for these major areas financial information, banking transactions, fraud detection in New Jersey and neighboring states, caseload, nutrition, vendors, and federal government.SKILLS: OPERATING SYSTEMS: i5/OS, Windows XP DATABASES, TABLES/FILES: DB2, DDS and DDL Tables, Positional flat files, XML files and Comma separated variable length files LANGUAGES: SQLRPGLE, RPG Free, RPGLE, Stored procedures, Sub-Files HARDWARE/PLATFORMS: Two IBM System i Boxes – development and production, PC’s TOOLS/UTILITIES: Programming Client Access, PDM, SEU, RLU, SDA, Eclipse Data Base/Utilities iSeries Navigator, Run SQL Scripts, QM Query Manager for the AS/400, STRQM Interactive Structured Query Language, Query, WRKDBF (Work with Database File), DFU (Data File Utility), FTP – EDI – PDF FTP scripts (PC) and FTP programs (iSeries), Keys Mail (e-mail package) and Spool-a-matic (e-mail package) Windows Word, Excel, Outlook, Microsoft Visio Drawing

7268 S Tucson Way, Centennial, Co 80112-3920

Supported Bradley Petroleum’s private business entity with over 500 employees and is a petroleum distributer. Bradley Petroleum owns/operates over 45 convenience stores with locations throughout Colorado, Wyoming & New Mexico for at last 40+ years.DUTIES:Provided sole support for Bradley petroleum’s AS/400, local area Network and phone system. Maintenance and new development programming needs for the Scot POS System, which was used for 48 different retail locations which spanned three different companies including Bradley Petroleum, Sav-O-Mat & Service Oil throughout Colorado, Wyoming & New Mexico. Responsible for the highly complex data transfer process to USTMAN for the analysis of the possibility of ground contamination as per mandatory State guidelines. Responsible for reporting of data to functional users, system improvements to the profit and loss statements, Accounts Receivable, Accounts Payable, Payroll, Taxes & Fuel Tracking Programs.SKILLS: OPERATING SYSTEMS: i5/OS, Windows XP DATABASES, TABLES/FILES: DB2, DDS, Positional flat files, XML files and Comma separated variable length files LANGUAGES: RPGLE, Stored procedures, Sub-Files HARDWARE/PLATFORMS: IBM System i, PC’s TOOLS/UTILITIES: Programming Client Access, PDM, SEU, RLU, SDA Data Base/Utilities iSeries Navigator, STRQM Interactive Structured Query Language, Query, DFU (Data File Utility) FTP – EDI – PDF FTP programs (iSeries) Windows Word, Excel

450 S 4Th Ave., Brighton Co 80601

Supported AS/400s on the Adams County contract through Systems & Computer Technology Corp.DUTIES: Provided expertise for the initial implementation and continued support of JD Edwards World system for JD Edwards’ HR & Payroll modules that supported roughly 1600 in-house employees. Included were EDI transmission for five separate health insurance customers and SCT. Delivered training on JDE World Writer to County employees.SKILLS: OPERATING SYSTEMS: OS/400, Windows 98/NT DATABASES, TABLES/FILES: DB2, DDS, Positional flat files, Comma separated variable length files LANGUAGES: RPG/III, RPG/IV, RPG400, RPGLE Stored procedures, Sub-Files with help screens, CLLE, DDS HARDWARE/PLATFORMS: AS/400 (Application System/400), IBM System i, PC’s TOOLS/UTILITIES: Programming Client Access, PDM, SEU, RLU, SDA Data Base/Utilities iSeries Navigator, STRQM Interactive Structured Query Language, Query, DFU (Data File Utility), OPNQRYF (Open Query File) Windows Word, Excel

1400 W 64Th Ave Denver, Co 80221

Supported a trucking companyDUTIES: Provided second shift operations support on the AS/400.SKILLS: OPERATING SYSTEMS: OS/400, Windows 98/NT LANGUAGES: CL, CLP HARDWARE/PLATFORMS: AS/400 (Application System/400), PC’s TOOLS/UTILITIES: Programming PDM Data Base/Utilities Query Windows Word, Excel

Denver Colorado

Supported 3rd Party administrators’ of credit cards DUTIES: Provided operations support on the first the System 38 and then migrated to the AS/400.SKILLS: OPERATING SYSTEMS: OS/400, Windows 98/NT LANGUAGES: CL, CLP HARDWARE/PLATFORMS: AS/400 (Application System/400), PC’s TOOLS/UTILITIES: Programming PDM Data Base/Utilities Query Windows Word, Excel

Northglenn Colorado

Developed application screens utilizing MS DOS and Norton Utilities for PCs. Responsible for daily and system backups and the management the computer tape library. Assisted in resolving VAX 11/785 system hardware, software and programming problems. Supported printer activities by assisting users, monitoring print jobs, controlling print queues and interfacing PCs with printers. Provided minor VAX 11/785 maintenance. Assisted in the training and user support on VAX/VMS and PC: applications, communication/file transfer interface, XENIX system administration and DOS. Responsible for the installation and maintenance of PC’s utilizing Norton Utilities, Spin Rite, QA Plus, DOS, WordPerfect, Lotus 123, Harvard Graphics, and Dbase III Plus. Responsible for wiring Terminals, PCs, and printers to the VAX.

Higher education, assisted students with there computer lab assignments

Manufacturing and testing of phone systems

Assembling and testing computer hardware

Aas, Computer Programming For Business

Activities and Societies: Honor Society Member, Phi Theta Kappaassisted students with there computer lab assignments

Certificate, Electronics