DB* Data Base Arichitech and with full project life cycle (SDLC) experience on the AS400, iSeries better known as SYS38. Projects have included data analysis, programming, testing, debugging, documentation, and end user training. Have also made hardware and software recommendations based on the needs of the clients and/orvend users users. Extensive interfacing with users at all levels, providing technical assistance as needed.

Specialize in the design and implementation of database management systems (DB2). Experienced in all aspects of AS400 iSeries System set up and tuning, all kinds of integration,web site creation and web services, many communication methods with data flowing in/out, all green screen creation asa well as creating subfiles and messaging, structuring files native and SQL, creating application libraries, securing system resources, system software/hardware upgrades and providing complete backup and support through comprehensive documentation and cross reference material.

Involved in numerous training and teaching assignments with special attention given to client needs regarding computer configuration and scheduling requirements. Courses Taught include: Advanced Micro Computer Programming, RPG Programming, ON-LINE RPG Programming, System Analysis and Design, Project Management and Management Overview of the Computer.

Hardware:IBM Power Series, IBM iSeries - AS/400, AS400 - System 36, IBM System 38, IBM System 34, IBM System 32, PC's and you can toss in keypunch on bothnIBM an HP n

Software: OS400, DB2, RPG/400, RPG II,RPGIII, RPGIV, RPG-CGI, RPGILE (RPGLE), SQL, RPGSQL, RPG Embeded SQL regular and Dynamic, stored procedures, COBOL, CGIDEV,CGIDEV2, WASDc, WebSphere, IBM Query, CL, CLP, PM/400, Aldon CMS, Hawkeye, DBU, FEU, REVUE, Lawson, JD Edwards, SAP (ALE - iDocs), MQ Series (WebSphere MQ MQM), MQ Series for SAP, HTML, JavaScript, IBM-HTTP-Server, IBM Apache-HTTP-Server, Net.Data, Mail, FTP, Mocha Soft, Client Access, iSeries Navigator, Windows(XX), Excel.

Microsoft: C#, ASP.NET, .NET.

Experience: Please note there are plenty more to add. As a consultant you receive a broad range off experience in many places.

CUNA Mutual December 2008 to March 2009

All program and system documentation of a AS400 iSeries with System 36 support and all of its functions

Document external software applications

Documentation of all DB2 Tables and Files

Marketing file download from CUNA

Marketing processes

Salesman lead processing and distribution

Agent Compensation

Member survey response procedures

Agents use of the system and applications

Internal reporting

Document all AS400 auto Job Scheduler

Plaza Associates April 2008 – October 2008 Debt Collections and Recovery Company

Changed long running end of day and end of month processes to use RPGSQL

Analyzed AS400 iSeries DB2 Data Base and logical file usage to remove outdated files

Converted Queries and Open Query Files to use embedded RPGSQL to improve performance

Created an automated log process to capture FTP file information both in and out of the AS400

Responsible for maintaining and creating RPGII, RPGIII, RPGILE and RPGSQL programs for the current software package including both batch and interactive subfile processing

Used Aldon for CMS

Used Patrick Townsend Security Solutions for Email Data File Encryption

Care Core National May 2007 – Jan 2008 Insurance Claims Processing Company

Oversaw Hardware and Software migration for two iSeries AS400s

Responsible for the OS400 upgrade from V5R2 to V5R4

Set up a backup DB2 plan to a remote tape device library

Responsible for updating and creating RPGILE and RPGSQL programs for the current software package

Created automatic Client Access file transfer into Excel

Set up auto report emailing from the AS400

Set up the Apache HTTP installation and configuration for easy access for file display

Installed and used CGIDEV for HTTP

Created stored procedures using the Client Access Wizard

Created print overlays for customer letters using the Wizard

Seiko Optical Jan 2007 – May 2007 Consultant for a Whole Sale Optical Distribution Company

Worked on JD Edwards (JDE) custom programs

Created a method to import from Excel using Client Access to Purchase Order information and created the new PO in JDE

Set up auto report emailing from the AS400

Set up the Apache HTTP installation and configuration for easy access for file display

Installed CGIDEV for program and email

Set up DHCP using the Client Access Wizard

Charmer Industries Jan 2006 – December 2006 Consultant for a Whole Sale Bottle Distribution Company

Responsible for overseeing Hardware, Software and DB2 Data migration from three iSeries AS400s and one Mainframe to a single AS400 with a backup running at a remote location. Each iSeries AS400 would be equipped with On Demand processing services

Tasked with vendor selection for running the data mirror at each location

Tasked with analyzing the current three iSeries AS400s workload using Performance Analysis Capacity Planning PM/400 and Performance Navigator to ensure each was running at best performance to suit the company’s needs and to determine what new hardware would be required in the future

Tuned the systems to ensure resources were best used and available when needed like month end processing

Tasked with Security and Apache HTTP installation and configuration

Installed and used CGIDEV

Laufer Associates 2001 - 2005 Consultant for a Full Service Logistics Company

Responsible for overseeing applications development to meet the overall needs of the company

Primary objective was to introduce to the company to the Internet using IBM’s suite of WebSphere products on the IBM iSeries (AS400) platform which enabled the successful competition and launch of website for the sales force and customers to utilize reporting and distribution of on demand data

Responsible for the creation of all web (HTML/RPGILE-CGI) functions on the IBM iSeries (AS400)

Applications moved to the web include Customer Ocean Shipment Summary Status, Customer Air Summary Shipment Status, Booking Status, House Bill Status, Container Status, Status by Reference, Customer Purchase Order/Item/SKU Search and Summary Display and View all Open Customs Information

Instrumental in bringing the Internet to the company, involving hardware and LAN connections

Working with the AS400 i5 (Power5) in RPGILE and DB2 to write data to the IFS for direct import into EXCEL

Worked on proof of concept of Net.Data but later changed to HTML/RPGILE-CGI for web applications

Client used Synon and I had to make changes so that some applications would work on the web

Set up and installed IBM-HTTP server, Mail, Apache, WAS and Domino

Installed CGIDEV

Sharp Electronics 1999 - 2001 Major Consumer Electronics Company Project Leader/Consultant

Responsible for enabling SAP to communicate with the AS/400 using MQ Series, MQ Series for SAP and ALE

ABAP programmer. Created ABAP programs and iDocs to send delivery and purchase order information from SAP to the AS/400

Created RPG programs to receive the deliveries and purchase orders.

Created RPG programs to send warehouse delivery order status information from the AS400 to SAP

Created ABAP programs to receive and process iDocs.

Created triggers on the AS400 DB2/DB400 data base for use with MQ Series

Full SDLC project life cycle development of SAP and the AS/400

Instrumental in moving all Distribution Centers/Warehouses from Point-to-Point leased lines to the company LAN/Frame

Helped with the installation of a new AS/400 that consolidated all Distribution Centers/Warehouses into one system using the Performance Tools, Performance Navigator and PM/400

Company is a multi-facility multi-divisional manufacturer and distributor

Strategic Business Systems 1997 - 1999 Internet Specialist for Consulting Company

Responsible for technical support on Internet applications

Helped with setting up all Internet connections at customer locations

Helped with ISP selection, router installation, firewall setup and AS/400 configurations

Carl Zeiss 1984 -1996 Major Optics and Microscope Company Project Leader/Consultant

Responsible for extensive modifications and rewrites to Lawson's distribution software. Applications involved were: Order Entry, Inventory and Inventory Control, Production Control, Invoicing, A/R, A/P, Credit Memos, Sales Analysis and Labor Distribution

Project Leader on the implementation of JD Edwards integrated financial software

Created an ad hoc EDI system to communicate with parent company and manufacturing facility in Germany

Full project life cycle development of numerous custom applications. Among them were commissions, sales analysis, a system which provided automatic notification of orders and sales through download to email, and a back order management system

Instrumental in bringing the Internet to the company, involving hardware and LAN connections

Company is a multi-facility multi-divisional manufacturer and distributor of high-end medical equipment

KW Control Systems 1982 - 1984 Major Power Company Programmer Analyst

Responsible for the development and support of a wide variety of application systems

Interfaced heavily with users and performed analysis, design, coding and implementation of systems as well as interfaced IBM PC/XT's for on-line access

Developed projects included Personnel/Payroll, Financial including A/R, A/P and Taxation, Sales Analysis, Commissions and System Security

Involved on a Data Collection System (IBM Series/1) for Work Orders, Cost Center and Production Analysis Applications

AIMS Associates 1978 - 1982 Consulting Company Sr. Associate

Participated in a broad range of systems and programming projects for clients of this software firm.

Provided technical assistance to users including the modification of existing programs, operating systems and applications

Designed and implemented customized programs and applications based on user requirements.

Systems experience included Order Entry, Inventory Control, Production Control, Invoicing, Work Orders, Payroll/Personnel, Labor Distribution, A/R, A/P, and Sales Analysis

Coded in both COBOL and RPG

Headed a Facility Management contract to assist and direct the complete revamping of the Data Processing Department for a major consumer goods company

Responsibilities included systems analysis, systems and data base design, programming, testing, debugging and system security along with complete documentation and the scheduling and training of personnel

Aided in the conversion of approximately 800 batch programs from an IBM System 3 Model 15D and RPG II to a System 38 and RPG III.

Converted the client's on-line programs, which, in most cases, required major rewriting of logic. Completed the conversion one month ahead of schedule

Subsequently, completely rewrote an on-line Manufacturing System, which was running on the System 38. This was completed with a high degree of end user satisfaction

Implemented an on-line A/P system for the Accounting Department

Education:

AAS - Fulton Montgomery Community College

Graduated with a 3.85/4.00 Cm Laude in Business Data Processing

Other: Internet Savvy. HTML, FTP, WWW, TELNET, IRC

Member of AOL

NON-IS Related Positions

New York Telephone Company

New York Air National Guard - Public Affairs - Retired

USAF - Armed Forces Radio and Television Service

References furnished upon request.

Contact this candidate