A Biography of Andrew Trefethen

Andrew Trefethen started his career as a young adult at the Boeing Company in Seattle, Washington. After many successful software development projects, Andrew was asked to manage new software initiatives as project manager. With 15 years and more of managing software development projects in mainframe, client server and web projects, Andrew has the experience of engagements in projects with direct reports numbering from 2 to 30.
Andrew has been married for over 37 years and has a family of five children. He is civic minded and has served the public in many capacities. Andrew has served in the local Boy Scouts of American organization as scoutmaster, committee chairman and treasurer. Andrew currently serves on the board of directors for the Edelweiss Home Owners’ Association as architecture committee chairperson that involves negotiating with homeowners seeking improvements to their properties while enforcing architectural standards for the neighborhood.
Andrew performs timely project assessment reports that include (a) on-site gap analysis of project plan critical task completion state relating to extant issues, (b) identification of significant risks and critical items, (c) review of talents, tasking and issues via interviews with technical and business personnel, (d) formulation to bridge gaps and identify paths to completion of project, (e) dissemination of vital information among key stakeholders, project resources, and external vendors and (f) manage inventory status. 
As necessary, Andrew works with stakeholders and subordinates to garner approval of strategic roadmaps to ensure alignment with the organization’s strategic goals. Andrew ensures communication between subject matter experts, stakeholders and supervisors. In addition, he closely monitors all resources, scope creep, task completion, and remaining tasks as needed to complete the project, while leading, guiding, encouraging and making necessary adjustments to resources and schedules.
Andrew has graduated with honors from college with a degree in Marine Engineering and a degree in Information Technology. His grade point average was 3.9. Currently Andrew is earning his master’s degree in business administration. With one year remaining in his course of study, he has a 3.8 grade point average. To date, his course of study has included management economics, managing the business enterprise, finance and accounting, transformational leadership, human capital development and is currently taking strategic implementation and alignment.
Andrew is a high energy person with the ability to manage his time, lead his team and motivate those around him. He expects the best from people, provides opportunities for growth, communicates well and gets the job done. Please consider Andrew Trefethen for your management needs.

Resume for Andrew Trefethen

EDUCATION:

Earning Master in Global Business Administration

Bachelor’s Degree in Information Technology
Degree in Marine Engineering

TRAINING:

CPR Certified
Groupwise Administration
Microsoft Windows Internals
Novell Network Administration
UNIX Operating system clustering

PROFESSIONAL EXPERIENCE:

Manager of networks and specialized software. Project manager for product selection, evaluation teams, purchase and administration.

The software tools utilized included Novell, Solaris, Windows 2003, Windows XP, Windows Vista, Apple OSX, Microsoft Office, GroupWise, Cumulus, VBrick, CommVault, Dreamweaver, ColdFusion, MS Project, MS FrontPage, Oracle and SQL Server.

As consulting project manager I follow the sales person to demonstrate directory and meta-directory technical solutions, and to provide leadership for web services development and implementation at client sites. Instrumental in large account sales and management with enduring positive customer and business associate relationships. Provide customers with training on product and product upgrades as needed. Enabled and sustained communication proficiency between technical and non-technical personnel.

The software tools utilized included SDLC methodology, Visio, SQL Server, Directory and Meta Directory Services, MS Access, MS Office, ASP, HTML, LDAP, X.500 and PKI.

As project manager and implementation engineer of directory and meta directory services for the professional services department, I implemented the software and connected local and remote databases at customer sites.  We would go into the customer’s facilities, and meet with them to determine their information infrastructure.  I would document their affected processes and show how we could utilize our software to save them millions of dollars.  I led discussion groups, made presentations, gathered requirements from the users, created project plans, managed changes to requirements, requests for revisions, and supervised personnel. 

The software tools utilized included SDLC methodology, Oracle, DB2, Visio, SQL Server, Directory and Meta Directory Services, MS Access, MS Office, ASP, HTML and LiveContent.

As Manager of Data and Research Design, I designed and developed several projects at this client site.  I managed enterprise projects and project managers, created policies and procedures, made presentations, gathered requirements from the users, developed software, initiated change control. Built effective communication, collaboration and cooperation among software team.

Created new production reports and increased production of existing reports.  Initiated HEDIS proportional sampling reports.  Automated report request processes and placed report icons on users’ desktops.

Created the company intranet with the cooperation of each department.  

The software tools utilized at this client site included Visio, HTML, ASP, MS Access, Front Page, MS Office, MS Project, Visual Interdev, Oracle, SQL Server, SDLC methodology and Visual Basic.

Instructor for MS Project. Created projects with costs, dependencies and resources, while at the same time, taught client’s employees on the use of MS Project.

As a software developer, I developed off-the-shelf software products

SEGManager – Contact management software with a target audience of credit unions with over $10 Million in assets.  Using extensive experience with directory services, and databases, created a dynamic system that would work with different customers’ environments.  Worked closely with marketing in developing enterprise software design and requirements, meeting about and documenting changes to the initial requirements, managing developers, creating test plans and assisting in distribution of contact management software for financial institutions. Software can be reviewed at www.segmanager.com.

The software tools utilized at this client site include Visio, HTML, iPlanet Directory Services, Netscape Directory Services, SDLC, C#, ASP, DB2, Oracle, SQL Server, MS Access, Visual Basic, VBA, VBScript, InstallShield, MS Office.

Sales Engineer: traveled to customer sites for pre-sales software demonstrations, and post-sales software set-up of enterprise project management software. Software tools included SQL Server, Directory Services, Visio, HTML, ASP, MS Project 98, MS Office 97.

As project manager, I directed the development of the SPOTS system.  Coordinating the efforts of 5 technical resources, we created a reporting and tracking system for all K-12 educational, apprenticeship, pre-employment training, technical preparation and work place basics activities.  The system assisted in raising the educational level of disadvantaged employees by teaching them how to read, write and acquire cognitive skills.

The skills utilized at this client site included Visio, Directory Services, Oracle, HTML, ASP, SDLC methodology, Visual Basic 5.0, MS Access 97, Office 97, SQL Server, MS Project, MS Team Manager, MS Front Page, and Visual Interdev to create the SPOTS system,

As project manager, I directed the development of three major projects at this client site:

EDI Project - Coordinating the efforts of 3 insurance vendors, 10 network vendors, 7 technical staff, and 15 users, to begin EDI with Aetna 's new trading partner, California Choice.

PAMS Project - Managed 10 users, 12 technical people and 3 testers. From requirements gathered from the users, developed software proposal, functional specifications, detail specifications and project schedule for a provider audit and member survey system to meet NCQA standards, with costs and schedules for a hardware/software solution. Hardware includes dockable notebooks, Compaq 4500R and an IBM RS6000 as database servers. MS Access for data modeling and system prototyping. Visual Basic with 3rd party tools for rapid development, utilizing SQL Server as the database. Internet Web site development.

Sales Support Project - Integrated Dun & Bradstreet files with ACT, a contact manager from Symantec. Also, I was responsible for coordinating resources for hardware placement, as well as software, training and support.

The software tools used at this client site included Visio, HTML, ASP, SDLC methodology, Microsoft Project, Visual Basic, Microsoft Access, SQL Server, Oracle, Windows 3.11, Windows NT and Win95, Desktop DBA and ACT. 

Sales Engineer – Visio, HTML, ASP, Microsoft Word, MS Project, MS Publisher. Created proposals for a multi-million dollar software development project. 

As project manager, I directed the development of one major project at this client site:

Log Reporting Ad Hoc System. This system recorded the weight of trucks entering and leaving the yard. Supervised the activities of 4 technical people.  This was a data warehouse project for decision support activities. Project included user-definable reporting, user-definable graphs, utilizing "hot spots" with drill-down capability, stored procedures, and a help system. This was an event driven program written in Microsoft Access, linking to Oracle on a UNIX platform.

The software tools used at this client site include Visio, Visual Basic, Microsoft Access, Oracle 7, Oracle Workgroup 2000, Unix, Windows NT, Windows 3.11 and Win95. 

PowerBuilder, Sybase, SQL Server, Transact SQL, DBArtison, ERWIN case tool, Windows NT. Developed the maintenance scheduling system for APS nuclear power plant, utilizing PowerBuilder and Sybase. The system features system administration functions and user functions in several windows and reports. This is a data warehouse project for decision support activities. The reports include Gantt charts and graphs for visual impact. Created the logical, physical and final design of the database. Created and populated the tables of the database. Created views and stored procedures to support the PowerBuilder Development team.

Wrote the interface program between the mainframe DB2 database and the DB2/2 database on OS/2. Used Visio, OS/2, DB2/2, Cobol II, DB2, SQL, SPUFI, QMF, IBM Utilities, JCL, Fileaid, Visual Basic/Access, MicroFocus COBOL, MicroFocus Workbench, DB2/2 on OS/2, Visual Basic/Access on windows 3.1, and PowerBuilder on windows 3.1.

As project manager, I directed the development of five major projects at this client site:

Invoice Tracking System.   The Invoice Tracking System was developed to track the costs, bidding, presentation and cash disbursements of contracts for construction projects in the ARCO refinery at Carson , California . This is a data warehouse project for decision support activities. The system had approximately 200 users, with 10 screens and 30 reports. The system was password protected, and each user was allowed access to only the areas of their responsibility.

Construction Forms Automation - The Construction Forms Automation system was developed to reduce the amount of paper work that the construction staff had to copy and fill out. The system automated over one hundred reports, each requiring parts of similar data. The system included data entry, reporting, and recording. The system was secured by user-level passwords.

AFC Cash Flow graphing system
Master Cost Report by AFC System.
Turnaround Control system 

The AFC Cash Flow Graphing system, the Turnaround Control system and the Master Cost by AFC system were all similar applications for different parts of the refinery. Each one analyzed existing spreadsheet data and created graphs. This was a data warehouse application, allowing drill down capability for specific information, or roll-up summarization for low and middle management reporting. Since the system analyzed existing spreadsheets, there were no data entry windows for this application. Several kinds of reports were to the user on-screen or on paper, as requested.

The software tools used at this client site Visio, Superbase, Sybase, MS Access, Visual Basic, Power Builder and DBA Desktop.

Converting existing EIS (Employee Information System) to the Tesseract personnel system. Utilizing the Tesseract report writer, and Tesseract table manager to create interfaces and bridge files to enhance Tesseract's capabilities. Used Visio, Cobol II, SDF, CICS, DB2, SQL, SPUFI, QMF, IBM Utilities, JCL, Fileaid, Viasoft. The Personnel Reporting System was developed utilizing Powerbuilder and the Watcom SQL database Engine.

As a project manager, I directed the development of two major projects at this client site:

Secondary Loan Marketing System – This software was utilized to market mortgage loans to other banks.  It features automatic updates to the program files with the latest FNMA & FHLMC requirements at the time of delivery.  Also, the COBOL programs were revised from printing on a mainframe printer, to print on an HP laser jet,

Conversion of the Secondary Loan Marketing System – At the beginning of my tenure, the Secondary Loan Marketing System resided on an IBM Mainframe.  It was decided by management that this system should reside on a PC based server, networked by Novell.  The code was converted into MicroFocus COBOL that ran on a PC.

The software tools utilized at this client site included Visio, SDLC methodology, TimeLine, MS Project, HP PDL, IBM COBOL II, MicroFocus COBOL, CSP and VSAM.

Programmer Analyst revising COBOL programs for additional report requirements. IBM
3090, HP Laserjet. VSAM, DB2, Visio.

As a Senior Programmer Analyst for the On-line EDI Inventory Order Entry System, enhanced batch and CICS/VSAM on-line COBOL II programs. Modified JCL, PROCS and SORTS. Changed file lengths and added a new IMS database. Developed new PSB's, DBD and linkage programs. Used TSO/SPF, COBOL, DataXpert and IMS Xpert on an IBM M/F, Visio.

As a project manager, I directed three major projects at this client site:

Converting legacy DOS-VSE JCL to MVS-XA JCL.  Capitol Records upgraded their computers to newer hardware.  This conversion was necessary to take advantage of the automatic scheduling software.  Hundreds of JCL procedures were examined and upgraded using CLIST edit macro tools, to accelerate the JCL re-writing process.  It was found that many of the JCL procedures could be run simultaneously.  The revisions to the JCL procedures were made with this in mind, and a significant reduction in production processing time was realized.  As a result, a nightly back up of data was initiated.

Implementing CA7/CA11, an automated scheduler.  Every JCL that was upgraded for automation was tested.  A sample production run was created to test all of the JCL procedures, to ensure a seamless production upgrade.

Re-writing COBOL programs to prevent record locking.  As the JCL was upgraded for automation, it was discovered that the possibility existed for record locking in the DB2 database.  The record locking possibility was removed by re-writing some COBOL programs.  The SQL code was examined and revised where necessary.

Software tools utilized at this client site were SDLC methodology, CLIST, IMS/DB, CICS, COBOL, DB2, JCL, DYL280, and VSAM.

As a Programmer Analyst, maintained long distance calls billing and invoicing COBOL II programs. Ran the help desk and distributed work among programmer/analysts. Balanced toll reports to test accuracy of programs. Used COBOL, CICS, VSAM, DYL280, IBM Utilities, DB2, IDCAMS, CAPEX, CLISTS, SQL, JCL, DYL280, IBM PC.

As a Systems Consultant, designed, installed and tested PC-MOS network. Installed multi-user, RM COBOL. Used IBM PC, MS-DOS, PC-MOS, COBOL, network internals.

Sales Engineer, responsible for the support of the customers, communications between marketing and development, sales literature, and attending trade shows. Created budgets and scheduled software projects and resources. Set policy for development standards and quality assurance to promote responsibility by each member of the development team.

As project manager, I directed the development of two major projects at this client site:

Test Data Creation – I directed the efforts of 20 non-technical resources to create and enter test data for the Factory Acceptance Test, shown below.

Factory Acceptance Test - I directed the efforts of 5 technical and 20 non-technical people in creating and conducting the factory acceptance test plan.  This project was to indicate to Alpharel that the document scanning and storage system matched the specifications required by the apple computing company. 

The software tools used at this client site were XENIX, MS-DOS, C, DBASE, JCL, VSAM, COBOL, CICS, INTERTEST and ORACLE.

As project manager, I designed and directed the development of one major project at this client site:

The Westin Hotel Frequent Guest System – Managing 5 technical people, designed and developed of 5 technical people.  After gathering requirements from the users, utilized SDLC to manage the development of the Westin Hotel frequent guest software development project.

The software tools utilized during this project include COBOL, DB2, SQL and VSAM. 

s
Programmer/Analyst. System analysis, software development and software maintenance on IBM main frames and PC computers at Washington Dept of Retirement and Boswell Hospital .

Programmer/Analyst. Development of the on-line planning system. IBM 360, 4300, VMS, MVS, COBOL