ERIC M. SMALL

549 Aria Drive,

Brea CA 92821

714/293-5299

esmall642@gmail.com

PROFESSIONAL EXPERIENCE

Programmer Analyst 5/1/2018 – Present

Chaffey College, Rancho Cucamonga CA Current Salary: upon Requestt

5885 Haven Ave, Rancho Cucamonga, CA 91737

· Developed and enhance Ellucian/Datatel’s ERP (Colleague) programs using UniBasic, Envision and Colleague Studio.

· Member of the Information Systems Technical team

· Install software between the various database accounts

· Support and assist in all aspects of the Ellucian Student system.

Applications Specialist III 11/23/2015 – 4/30/2018

Rancho Santiago Community College District, Santa Ana CA

2323 N. Broadway Santa Ana CA 92706

· Developed and enhance Ellucian/Datatel’s ERP (Colleague) programs using UniBasic, Envision and Colleague Studio.

· Member of the Information Systems Technical team

· Perform ad hoc Microsoft SQL server queries

· Maintain and monitor Colleagues Process Handler jobs

· Install software between the various database accounts

· Maintain Colleague User program security

· Perform system maintenance and cleanup of data within the Colleague and Unidata environment

· Support and assist in all aspects of the Datatel Student system.

Senior Consultant 8/11/2015 – 12/2016

Strata Information Group, San Diego CA

3935 Harney St # 203, San Diego, CA 92110

· Worked as a Senior Consultant on various tasks. School is converting from Datatel to Worday.

· Programmed Faculty information screen to handle new information needed by the payroll system of Workday.

· Projects completed via remote and onsite client visits

· Create comma delimited text files for export from Datatel to Workday.

· Developed and enhance Ellucian/Datatel’s ERP (Colleague) programs using UniBasic, Envision and Colleague Studio.

Technical Analyst 3/8/04 - 7/15/15

Chapman University, Orange CA

One University Drve, Orange CA 92866

· Peoplesoft programmer - Developed import and export programs using Peoplesofts Application Engine’ Peoplecode

· Member of technical team converting from Datatel's Colleague to Peoplesoft Campus Solutions

· Developed and enhance Ellucian/Datatel’s ERP (Colleague) programs using UniBasic, Envision and Colleague Studio.

· Member of the Information Systems Technical team

· Member of technical team that implemented IBM’s identity management system

· Analyze end user needs, design, develop, code and test Envision/ Colleague Studio programs.

· Create and enhance Student web enrollment programs (WebAdvisor) via Colleague Studio (development tool)

· Perform Uniquery ad hoc reports

· Perform Oracle SQL ad hoc queries.

· Install Web Advisor updates

· Install Web User Interfaces updates

· Maintain and monitor Colleagues Process Handler nightly jobs

· Install software between the various database accounts

· Maintain Colleague User program security

· Create XML extract programs to be accessed by the Blackboard system.

· Create design user downloads and uploads from third party vendors like Blackboard, salliemae, student clearinghouse and university tickets.

· Perform system maintenance and cleanup of data within the Colleague and Unidata environment

· Support and assist in all aspects of the Datatel Student system.

· Prepare detailed user and technical documentation

National and Regional Users group participation

· Former Datatel Users group (DUG) National Board member – presenter at the national conference

· Former board member of CHUGADUG – Datatel’s regional Users group – presenter at regional user conference

Senior Programmer Analyst III 3/26/96-2/27/04

University of California Irvine, University Extension, Irvine CA

PO Box 6050 Irvine CA 92616

Developed and enhanced Ellucian/Datatel ERP (Colleague) programs using UniBasic. Development and Enchanced PowerCampus ERP programs using Powerbuilder.

· Generated reports in Unibasic and Uniquery.

· Analyze end user needs, design, develop and code Unidata UniBasic software programs.

· Prepare detailed user and technical documentation.

· Designed, maintains, modifies, codes, documents, tests, trains and installed two separate student online registration system using Microsoft SQL Server, HTML ,ASP, Java Script and SQL Database stored procedures and triggers.

· Senior member of the student system implementation team. Implemented SCT Powercampus, a Microsoft SQL database application written in Powerbuilder.

· Designed, maintain, modifies, codes, documents, tests and train individuals in use of standalone applications written to enhance existing student registration system using PowerBuilder 7.0.

· Create and enhance Sybase Infomaker reports

· Create, maintain and modify existing Microsoft SQL database triggers and stored procedures

· Senior Programmer working on Datatel’s Colleague student registration system.

· Started development of a real-time Internet student enrollment application: Using Microsoft NT, IIS, Visual InterDev 6.0, Active Server Pages using VB Script, Active X Com objects and Unidata’s Object Call.

· Developed a real-time (IVR) Telephone Registration system, using Visual Basic 5.0, Pronexus VB Voice and Unidata’s Object Call.

· Analyze end user needs, design, develop and code Unidata UniBasic software programs.

· Install software vendor upgrades: Saving in-house custom changes and verifying against vendor changes.

· Create GUI-based client server programs: Using Microsoft Access and an ODBC connection with an HP Unix system.

· Trainer of new programs and enhancements

· Prepare detailed user and technical documentation.

· Instructor web page design.

Project Leader 12/93 - 3/22/96

Akzo Nobel Systems, Orange CA

434 West Meats Ave Orange CA 92665

· Lead programmer on Mechanical Software package

· Analyzed and recommend software changes.

· Designed, code software enhancements using IMS Basic.

· Trained internal support and field staff in use of software.

· Prepared internal management reports.

· Coordinated timely software releases to our clients.

· Created update scripts using Unix shell scripts and IMS Basic programs.

Software Engineer 8/92 - 12/93

Akzo Nobel Systems., Orange CA

434 West Meats Ave Orange CA 92665

· Implemented recommended software changes to a Multi-user Auto Body Repair Management System.

Software Support Analyst 8/87 - 8/92

Akzo Nobel Systems., Orange CA

434 West Meats Ave Orange CA 92665

· Provided high end hardware and software support to Body Shop and Mechanical user client base.

· Supported client base via phone and direct dial up.

· Performed online program changes to clients’ systems as required.

EDUCATION and TRAINING

San Diego State University, B.S, Business Administration/Information Systems. (May 1987)

Moorpark College, A.S. Data Processing. (June 1981)

SYSTEMS & LANGUAGES

SCO Unix and Xenix, Unidata, Windows 97, HP 9000 Unix, Microsoft SQL 7.0

Unidata, UniBasic, Uniquery, Colleague Studio, Envision, IMS Basic, IRIS Point Four,BASIC, Visual Basic 6.0, Visual Basic Script, HTML VB Script,