Ralph B. Sherwin

211 Loft Lane (# 83), Raleigh, NC  27609

(919) 676-8670               rbsherwin@nc.rr.com

Business Consulting / Project Management

Application Development: Full Life Cycle

Technical Writer and Training Facilitator

Database Analysis and Design

1/06-8/06  New York Central Mutual – Consulting / Contract Programming

Develop an application to validate data in successive stages of data warehouse development.  The application involves building a SQLServer2005 database containing Transact SQL commands and other descriptive data.  Stored procedures execute tabled SQL commands dynamically producing a results table with all validation requests, timestamps and validation output allowing the tracking/auditing/reporting of all data validation requests.  Also, using Kalido to define data warehouse objects, develop query definitions and Excel “shops”, as well as defining basic universe(s).   Finally, using Business Objects to customize generated universes while transferring knowledge and defining standards.     

3/05-12/05 UNC Chapel Hill – Consulting / Contract Programming

Enhance JAVA / XML / Oracle / IDMS Student Awards application. Design, code, and test modifications, which allow business units to track and maintain all student financial awards using web app spanning mainframe and Unix platforms. Enhancements are designed to eliminate need for manual monitoring of individual accounts and prevent financial over exposure of business units by applying university accounting standards to all student award processes. 

2004-PRESENT Cyntex, Inc – Independent Consulting / Contract Programming

Analyze business operations with a focus on system efficiencies and improvements.  Control oversight and planning of computing, web, application, and database environment for the company.  Provide direct technical and training support to users and maintain the internal technology infrastructure.  Consult and advise Directors regarding the adoption of technology as they develop and deploy their business initiatives. 

2002-2004 - Wake County Public School System – Contract Programming

System tuning and troubleshooting of COBOL, IDMS, ADS/O of mainframe student information system interfacing with NCWise Oracle database and UNIX / SQL applications.  Batch and on-line application analysis, design, development, implementation, and optimization of processes on UNIX and Mainframe platforms.  Manage staff and operational aspects of the legacy system.  Responsible for all data reporting requirements to state and federal governments.

2001-2002 - N C State University – SAS Programmer / Hardware and Network Technical Assistance

Develop SAS / EXCEL / VISUAL BASIC system to track and analyze statistics for the North Carolina Treatment Outcomes and Program Performance System (NC-TOPPS), for NC Division of Mental Health.  Construct physical and logical system of network servers, UPS, backup/recovery units and software, and control systems to upgrade current network structure.  Assist in development and troubleshooting of Windows NT systems running on desktop and server systems. 

Ralph B. Sherwin                                                              Page 2

1996-2001 - American Management Association – Senior Application Developer

Member of Oracle Enterprise analysis/implementation team, using PL/SQL, JAVA, Oracle Forms, WEBDB, Developer and UNIX scripts to develop batch and on-line order entry processes, Oracle iStore, membership and A/R applications.  Full project life-cycle responsibility for UNIX vendor package used to control all aspects of On-Site training offerings. Coordinate with vendor, business units and operations for delivery of all needs, modifications and enhancements. Develop on-line and batch interfaces to COBOL / CICS / IDMS, DB/2, VSAM, and UNIX corporate platforms including CIS, CASH, A/R, G/L, INVOICE, MEETING and Course Materials PRODUCTION systems.

1985-1995                                                                                                      INDEPENDENT CONSULTING

American Management Association --Using COBOL / CICS / IDMS, and DB/2 develop Time & Attendance System interfacing with Payroll.  Maintain batch and on-line legacy A/R systems.

Plain English, Inc. -- Co-author Windows/DOS training manual selling 500,000 copies.  Coordinate and drive design and development of interactive multi-media products using Pagemaker.  Produce public training seminars of Microsoft Office products.  

Goldman Sachs and Company -- Technical team lead converting active brokerage portfolio system to multi-currency using COBOL, CICS, ADS/O, IDMS and VSAM.

Goldman Sachs and Company -- DBA Help Desk member resolving all database and application problems and questions.  Support included: IDMS, ADS/0, DC COBOL, and CICS applications, Central Version, backup, restore, and database recovery.

J Aaron Division of Goldman Sachs – Full project life cycle responsibilities with COBOL / ADS/O / IDMS / VSAM Commodities System, including database analysis and redesign.

Goldman Sachs and Company – Design and determine database standards and DBA procedures for first, and all successive IDMS database systems.  Full project life cycle responsibility for COBOL, ADS/O, and IDMS system used to determine Customer Credit / Exposure. 

Canon Corporation – Full project life cycle responsibility for COBOL / CICS / IDMS inventory system controlling copier rentals and leases.

Chase Manhattan Bank -- Develop enhancements to COBOL / CICS / IDMS Pension Trust application.  

Brown Brothers, Harriman – Federal requirements consulting.  Performance tune an on-line COBOL / CICS / ADS/O / IDMS Portfolio Management System.  Teach staff effective techniques for solving database and application problems. 

Paine Webber – Manage development of first application using IDMS database and ADS/A.  Design application security. 

N.B.C. – Full project life cycle responsibility of the company's first successful IDMS / ADS/0 application.  The system functions as an on-line scheduler for satellite transponders, which carry television news features.

Main, Hurdman & Co-Partners – Profitability analysis of two COBOL / CICS / IDMS subsystems.  Develop and present management finance statistics.

1984-1985 - C.G.A. COMPUTER ASSOCIATES - STAFF CONSULTANT

 Metropolitan Life Insurance Co.: design through implementation of financial and audit trail portions of a COBOL / CICS / ADS/O / IDMS  on-line Quotation Tracking System.

 Merrill, Lynch, et al: conversion of file structures from ISAM to VSAM in a management reporting system.

1983 - S.I.A.C. - STAFF PROGRAMMER / ANALYST

Design, code, and implement COBOL / IDMS Municipal Bond Processing System.

1982 - MERRILL, LYNCH, et al - STAFF PROGRAMMER / ANALYST

In-house consultant to data security.  Design, code and implement enhancements to company COBOL Stock Records System. 

1976-1982 - BLUE CROSS and BLUE SHIELD of GNY - STAFF PROGRAMMER

Technical team member of Utilization Review Statistical Analysis System and a Medical/Surgical Claims Processing System using COBOL.

Ralph B. Sherwin                                                              Page 3

EDUCATION:     Charter Oaks College BA

LECTURING:    

Sarah Lawrence College - Technical solutions to non-profit problems, June – July, 1993.

Plain English Booklets, Inc. - Course Facilitator for Windows and Windows Application courses, 1991 - 1993.

Clinton Community College - Introduction to Word ’97, Introduction to Windows, October - December, 1999.