Bob Wagner

320 Valley #13
Seattle, WA 98109-4146
(206) 281-9847
Email: bob.wagner1@comcast.net

 
Analyst/Programmer Position
(Detailed Description from Xerox)
 
This section will discuss the items that are necessary for the position related to supporting Harmony directly, and all the associated systems as related to Bob Wagner's position in the Xerox Business Services Pacific North Operation.
 
General Areas of Position

This section lists the current generalized areas of the job position and the related systems/programs.
 
  • Harmony - The redesign, upgrade, maintenance, support, documentation, and technical design. The design has been entirely based upon customer requirements, and user input. Harmony is the only system that allows chargeback reports to be produced in various sorts based upon customer requirements and calculates the taxes as related to each of those sorts.
     
  • CentreWare Account Management System (CWAM) - This system is designed by the XConnect Development Team and designed using the latest web data technology (.NET). This system is set up to allow multiple users access to a SQL Server Database for tracking Assets in various accounts. My role in this system is identifying the proper server, attaining the server from a vendor, overseeing and implementing the system, and then will be maintain the system, the server that is housing the system and act as a liaison between the office and the developers for future upgrades in that system. The developers are excited to see an office take this system on, as they want to roll this out to all of Xerox as a tool for tracking Assets. Additionally, my tasks will involve creating links between the CWAM and Harmony. Eventually, through working with this system, possibly migrate Harmony to the SQL Server and apply some of the .NET technology to Harmony.  
     
  • Virginia Mason Copy Center - Redesigned a billing database used by the Virginia Mason Copy Center that is used to produce billing for the copy center and provide the customer with billing chargeback reports.  
     
  • Panasonic Copy Center - Created a database that tracks the Panasonic job tickets for billing according to the customer chargeback requirements and allows for coupling unrelated charge units to other units to limit the amount charged according to impression minimums.  
     
  • NT Servers - Responsible for maintaining the NT servers in the office. EDS does not support the NT servers unless by a time and materials basis, so my responsibilities include the maintenance of the servers, maintenance of the virus protection, and updates as related to upgrades that become available. Additionally, all Web/FTP and Internet settings and usage is my responsibility and keep current according to current practices relating to security. Servers currently maintaining: L603_NT1, Webx, L603_WB1, and Usasac1hmapp (Southcoast).  
     
  • PNO Website - Designed and maintain the PNO Website for the Pacific North Operation. This includes all associated offices, including any requests for changes, additions, etc.  
     
  • User Support for All of the PNO Users - Provide computer user support for PNO that usually relates to the use of Microsoft Access. There are occasions the support is related to general computer use but not normally, however in cases where I can assist and save some EDS charges for service I'll be utilized.  
     
  • Database and Microsoft Access Consulting - Basically this involves the situation where any Access database that is being used, when it comes to any advanced programming, or advanced questions on how to utilize Access those questions and tasks are routed to me to handle.  
Normal Tasks Performed by Time period

This is a listing of the tasks performed normally by time period.
 
Daily  
 
  • Email - Reading email and responding to questions and concerns of the users regarding any of the systems listed above. Taking care of any of those issues as quickly as possible, because most concerns regard an immediate need.  
     
  • Backup - Checking backups of the database(s) for Harmony on the NT1 server, which includes the backend and GeoCodes database. The check is to ensure that the database is healthy (performing a compact and/or repair) on the database) and ensuring that the backup is completed successfully.
     
  • Support Phone Calls - Responding to phone calls by the users regarding any of the systems listed above, and immediately addressing the issue, regardless of the scope of the issue being presented. Phone calls regarding these systems are usually from users that have encountered a situation that they have not encountered before, and the call is not considered closed until the issue has been resolved to the satisfaction of user and myself.
     
  • Current Project - Current project would be anything relating to any of the systems listed above. In the case of a Harmony Project it would include the design, programming and implementation processes to get the changes requested by the users, management, or Xerox systems completed. The project time also includes testing for errors as much as possible before releasing a final version to the users. Projects are not always ran in cycles of: This project first then this project, etc. Sometimes there are multiple projects being worked on at the same time. All time spent on the projects are balanced to provide the best possible product while still meeting the required deadlines.  
     
  • Training - If the project load is low, time is spent on learning some of the new technologies that will be utilized to further enhance the systems listed above.
Weekly  
 
  • Virus Protection - All the servers must be updated with the latest available Virus Protection DAT files. The servers are NOT covered by EDS and must be solely supported by the PNO personnel. This is a mandatory item on the list because viruses can cause massive amounts of financial loss due to data loss.  
     
  • Server Checks - Checking the servers to ensure that they are running properly, rebooting the servers, etc. In most cases the servers are working properly.
On Demand  
 
  • User Password Changes - If a user has trouble connecting to the NT1 or WB1 Servers their passwords must be updated. Usually the "opened exclusively by another user" message occurs and indicates that the network password has been changed.  
     
  • Support Calls - These are on demand most definitely, although listed on the daily. A support call always means that whatever task is being performed at the time must be dropped and the user must be addressed. This could mean anything from just pointing out some missing data to taking everyone out of the system, compacting and repairing a database, and in some extreme cases the support call will identify the need to make programmatic changes to any one of the systems listed above.
Persons Worked With


Assist Users with:  
 
  • Creation of Queries  
  • Creating Reports  
  • Determining reason a report is not producing the expected results  
  • Assisting with methods to reduce time needed perform task  
  • Checking for data errors  
  • Explaining processes for using the various systems  
  • Using their computers  
Assist Managers with:
 
  • Creating reports that can be used for Account Review
  • Creating reports for corporate data requirements  
  • Assisting in determining the best methods to collect and report data  
  • Assist in determining the best method to process data at on-site locations  
  • Assist with databases that have been written by others  
Assist Management with:  
 
  • Determining which data can be used for providing corporate required data from the systems that we have.
  • Assisting in implementing electronic processes  
  • Assisting in the determination of the least expensive; most comprehensive methods of data collection  
  • Reviewing other method of data collection processes for comprehensive utility and usability for the operation