JOHN SCOTT COTTON
2619 Little Elm Trail
Cedar Park, Texas 78613
(512) 258-2350
jcotton@io.com
EXPERIENCE
-
MANAGER OF INFORMATION SYSTEMS
UNIVERSITY OF TEXAS SYSTEM ADMINISTRATION
EMPLOYEE GROUP INSURANCE (EGI)
June 1994 to Present
-
Have been the lead systems analyst of EGI department since its inception.
Responsible for recommending, designing, developing and implementing
eligibility, enrollment, reconciliation and billing systems.
Responsible for defining, assigning, scheduling and reviewing projects.
Responsible for defining positions, hiring, managing, supervising,
and training technical, client support, and administrative staff
for the operations of the information systems and the eligibility
and enrollment functions.
Recommend, develop, and communicate policy and procedures for day to day
operations of eligibility and enrollment functions of UT Components,
EGI IS, and vendors.
Performed evaluation and implementation of new insurance vendors.
Lead Joint Application Development Team, UTTouch Resource Group, and
Group Insurance Resource Team.
Either perform or supervise the design, development, and implementation
of mainframe, Internet, web browser, and interactive telephone systems.
Propose, design (usually with teams), and implement new standards,
methodology and formats for data sharing.
Responsible for determining and implementing data security methodology
using password and encryption techniques.
Make hardware recommendations for department workstations and IVR system.
Enrollment processes include personalized Coverage Option Letters to
members, PIN number authorization and maintenance, Confirmation
Statements, Evidence of Insurability processes, nightly transmission
of selections to and/or from components, and real time updates for
components on the same MVS system.
Extensive programming with NATURAL and JCL.
- Recipient of U.T. System Administration 1996 Employee Excellence Award.
- COMPUTER PROGRAMMER II
UNIVERSITY OF TEXAS SYSTEM ADMINISTRATION
SYSTEM PERSONNEL OFFICE March 1992 to June 1994
-
Served as department lead for information systems.
Maintenance and analysis of outdated and limited workers’ compensation system.
Proposed, designed, developed, and implemented overhaul of workers’ compensation system:
1) Organized a sixteen component JAD users group via video conferencing and e-mail;
2) Supervised four member information systems team.
3) Created modules to allow component access to claims, payment transactions, and account balances;
4) Created new transaction posting module with automated account reconciliation;
5) Created procedures to allow remote office to print from MVS mainframe using postscript programming and the Internet;
6) Created table-driven command, menu, authorization, and help system.
Served as department contact for 10 components.
Served as analyst for campus wide program printing software.
Created annual reports and claims analyses
(including standard deviation reports of different claim elements)
to assist insurance actuary in setting new workers’ compensation rates.
- SYSTEMS ANALYST
UNIVERSITY OF TEXAS AT AUSTIN
UTILITIES DEPARTMENT May 1989 to March 1992
-
Programming in NATURAL, COBOL, and JCL on MVS mainframe.
Development and implementation of new processes for batch transaction
posting for the long distance, calling card, collect call, telephone
service and equipment billing systems.
Development of reports detailing components’ long distance telephone trunk
and switch usage, including a busy hour analysis.
Responsible for maintenance and enhancements of on-line and batch applications.
Creation of a comprehensive telephone trunk analysis.
Re-design and re-write of the long distance bills.
Maintenance of tape datasets of long distance telephone call records.
Resource for HyperCard and Microsoft Excel.
Member of Data Processing Information Center.
Upgraded campus wide program printing software.
- COMPUTER PROGRAMMER / SERVICES ASSISTANT
UNIVERSITY OF TEXAS AT AUSTIN
DATA PROCESSING DEPARTMENT April 1988 to May 1989
-
Development and implementation of reporting system using Microsoft Excel macros.
Programming with dBase to manage and update multiple databases and print reports and vouchers.
Development of HyperCard system to monitor all microcomputer connections.
Participated in the development of a new departmental accounting program by
evaluating, debugging, and writing help documentation for and teaching the
Report Writer.
Programming in NATURAL.
- PROJECT MANAGER
HERITAGE NORTH JOINT VENTURE September 1985 to September 1987
-
Duties consisted of marketing, accounting, and supervision of and for a
140 acre real estate development.
Evaluated and awarded construction contracts.
Supervised and scheduled subcontractors.
Supervised administrative assistant.
Worked with the City of Longview on right of way dedication and participation.
- ASSISTANT SUPERINTENDENT AND PROJECT CLERK
CRESTBROOK JOINT VENTURE May 1984 to September 1985
-
Performed all bookkeeping services, generated all purchase orders and checks,
vouchers, bank draws and maintained the construction budget for a five
million dollar apartment complex from ground breaking through grand opening.
Construction inspections.
Provided personal analysis and mediation in contract disputes.
- HEAD SWIM COACH
AUSTIN COLLEGE, CONTINUING EDUCATION January 1982 to May 1984
-
Taught competitive swimming and sportsmanship part time while attending college.
- ASSISTANT SUPERINTENDENT
VIKING CONSTRUCTION COMPANY May 1980 to September 1981 (Summers)
- Assisted in supervising two commercial office construction projects.
Solicited and reviewed bids.
EDUCATION
BACHELOR OF ARTS IN BUSINESS ADMINISTRATION
AUSTIN COLLEGE, SHERMAN, TEXAS January 1984
SOFTWARE EXPERIENCE
NATURAL, ADABAS, NATURAL PROCESS, JCL, dBase, Microsoft Word,
Microsoft Excel, Microsoft Access, Microsoft Project, Word Perfect,
Lotus123, Canvas, ABC Flowcharter, ABC SnapGraphics, AmiPro,
Approach, Online Speech/2, Dos, OS2, Windows, COBOL, HTML, Unix,
C Shell, Perl, PostScript, Novell Netware, Atlas GIS