BOB SHETLAND
Email: **********@********.***
Address: ***** ******
City: Mission Viejo
State: CA
Zip: 92692
Country: USA
Phone: 949-***-****
Skill Level: Management
Salary Range: $90,000
Primary Skills/Experience:
See Resume
Educational Background:
See Resume
Job History / Details:
BOB SHETLAND
28402 Daroca, Mission Viejo, California 92692
Cell: 949-***-**** * **********@********.***
Professional Summary Extensive experience in leading infrastructure projects from inception to completion, bringing systems implementation to fruition. Working in multiple industries has provided keen insight and capacity to manage multiple infrastructure projects. Demonstrated success in managing projects that provide lasting value to the company's endeavors.
October 2008 - ISTA Pharmaceuticals, Inc, a Division of Bausch + Lomb
July 2012 Irvine, CA - Project Manager/Help Desk Support/Consultant
* After consulting to ISTA from Oct. 2008-Dec. 2009, accepted full-time position with the company in January 2010.
* Managed a small team of Help Desk Specialists, providing company-wide support to local Irvine users and remote sales staff.
* Led project to convert all desktops from Windows XP/Office 2003 to Windows 7/Office 2010, company move to new facilities.
* Responsibilities included staff direction, planning on day-to-day activities for Help Desk support, active support for local/remote users
o Major Projects Implemented 2008-2009
* Start-up of Liebert UPS/FPC power units
* Failover ISP - Tierzero
* NetApp Storage SAN
* Altiris Asset Management/Helpdesk System
* Conversion to SSLVPN from IPsec
o Other projects
* Exchange Permissions, DST Update, Asterisk Phone Sys., Data Center reconfigurations, ESX Virtualization, Bus. Cont. Disaster Recovery Plans, Blue Coat Web Filtering, Mimosa Archive Plans, IT Change Control
June 2006 - Shetland Enterprises
Sept. 2008 Mission Viejo, CA - Project & Technology Consultant
* Provide troubleshooting, repair, setup, of Windows and Macintosh systems, servers and networks as Customer Support Engineer for NTegrity Computer Solutions, Blytheco.
* Key player for Robert Half Technology from August 2007. Multiple engagements. Major client companies included IndyMac Bank, Cisco, Synoptek. Performed all types of troubleshooting and maintenance; Symantec AV, Norton AV, AVG. NT/W2K/W2K3 servers, Dell/HP/Compaq/clone workstations; UPS set ups, Backups - Veritas, Retrospect 7.0 Tape/Disk, NT Backup, Xcopy, Novell; Printers - HP, Toshiba, Ricoh, Xerox; Sonicwall BMR installs, server builds; XP Maint., etc.
July 2001- Solvere/NMRhealthpros
May 2006 San Clemente, CA - Project Manager/Help Desk Support/Consultant
* Started as Consultant, then Manager 3 months later, promoted to Director in 2003.
* Healthcare temp staffing, RN's, MD's, psychologists, psychiatrists for all CDCR prisons, regional surgery centers and regional hospitals. Revenue of $18M and 16 employees.
* For small company, held company-wide responsibility for IT efforts.
* Managed all systems, networks, databases, websites, external/internal security, budgets ($500K), facilities and a small staff.
* Designed and implemented an up to date Network topology from a single server using hubs to 14 servers utilizing Cisco PIX Firewall Router hardware with VPN connectivity, bridged to 4 Cisco 2950 switches with a dedicated fire-safe data center.
* Cisco-trained in all aspects of Router/Firewall/Switch technologies (IOS, OSI Network Model, ACL's, etc.)
* Successfully migrated network infrastructure from 1 to 14 MS Active Directory servers including MS Exchange 2003, workgroup servers, NAS appliances, etc. Implemented MS Group Policies for greater network security.
* Responsible for all desktop, printing and troubleshooting support for 40 employees and implemented workstation standards and policies.
* Led project to develop, design and implement a new web-based health-care recruiting software system (RetenXion) hosted by Space4Rent, Irvine, CA. Vendor - SoftwareAG USA. Java-based technologies.
* Major vendor responsibility for all aspects of network/telecom/web/security projects for the company.
* Completely redesigned and outsourced the company website from a Macintosh-based mail environment running Webstar to a Windows-based platform hosted by Blast Design Studios (Auburn, CA) using SQL/Cold Fusion.
* Successfully migrated from an analog phone system to an Avaya IP 406 network-based telecom system. Led small team to implement company intranet using Share Point technologies from a Macintosh-based workstation system.
* Responsible for managing all company facilities/administration including all office improvements and suite security using the Sonitrol Security system.
* Led project involving move of entire company from San Juan Capistrano to San Clemente in 2002. Responsible for all aspects of new location tenant improvement with multiple vendors. This was a major project, with total company downtime of one work day.
* Consolidated 12 ACT databases into 2, enhancing Sales staff productivity. Standardized and improved the database layout for more effective data entry and reporting. Led small team to completely overhaul database reporting.
February 2000 - Autobytel.com
July 2001 Irvine, CA - MS SQL DBA
* Online car buying through retail dealer networks. Revenue of $153M and 364 employees.
* Team member of the International Development Dept. Collaborated with Autobytel.com SME's and Unisys Corp. Consultants assisting in the development and implementation of a new website for Australia, including database modeling and design using Erwin. Developed Stored Procedures, and DTS packages for the Contract Management application for Australia. JATO Dynamics (Carspecs.com) was used for car data. The new SQL/COM/ASP architecture was a significant improvement over the SQL/Cold-Fusion existing websites.
* Part of small team to implement a redesign of the Canadian website, including site redesign and new car data provider JATO which greatly improved the functionality of the website. Responsible for the Canadian transition plan to convert the existing databases and website to the new Baseline Architecture.
* Team member of project to internationalize the database and website technology using SQL2000 and XML. Supported development efforts of Leverage Systems Technologies developers by managing the development environment, and developing SP's and DTS packages. Utilized MSAccess to import/export postal/geo data from 3rd party suppliers to create/update the postal/geo tables for this project.
January 1997 - Cendant Corporation
February 2000 Mission Viejo, CA - MS SQL/EDI Programmer Analyst
* Travel, real estate, hotel, vacation ownership and employee relocation services. Revenue of $2B and 2,500 employees.
* Part of team effort to move Relocation Accounting System (RAS) database and all Billing/EDI tasks to Danbury, CT, as part of Cendant Mobility's consolidation of IT divisions, resulting in properly documented support tasks and procedures, and made for effortless transition.
* Developed specialized T-SQL based scripts utilizing cursor methodology to process all RAS databases prior to consolidation/conversion from SQL Server 6.5 to 7.0, resulting in a very controlled conversion process, increased functionality and reduced costs.
* Supported the RAS database using SQL Server 6.5/7.0, responsible for DB Maintenance, Data Anomalies, Security, Backups, Restores. Also supported Development and QA environments (T-SQL stored procedures, db backups/restores, replication), resulting in user-controlled data and a smooth-flowing development environment.
* Developed/managed Electronic Data Interchange (EDI) solutions for approximately 16 major clients (AT&T, Lucent, Eaton, Swiss Bank, GTE, and Aetna) for monthly billing and accrual requirements. Client processing included managing/extending the MSAccess databases to import/export text/Excel files to create an EDI file. Involved mainframe to PC interfaces through MSAccess to GENTRAN mapping application, which ensured that Cendant Mobility's monthly EDI X12 Invoices (approx. 15MM) were transmitted in a timely fashion to our electronic trading partners.
PRIOR CAREER HISTORY
Hughes Aircraft Company
El Segundo, CA - Supervisor, Computing / Senior Programmer Analyst
* Aerospace and defense, satellites, electronics, missile technologies, approximately 64K employees.
* Supported implementation efforts for Division 1L Unix-based Accounting System. Developed program specifications, Excel Macros, Sybase Vision: Data scripts, queries, reporting. Also performed project management of four programmers, which resulted in more efficient system/program specifications and enhanced processes for the user community.
* Automated several aspects of the HP system reducing data turnaround time from monthly to weekly by implementing a company-wide employee contributions system re-host, which utilized an INFOBOT (Touch-Tone Telephone) and mainframe DB2 database for data feeds. Ad-Hoc reporting used Vison:Data (Clear Access) from the Hughes distributed HP3000 Personnel System. Developed interface with FoxPro DOS/Windows for maintaining data files to a third-party vendor.
* Converted/upgraded the existing DOS/Windows environment to a client-server based, Sybase SQL system that was used across the Hughes Business Units by implementing the RESTRAC Applicant Tracking System upgrade/conversion, with Verity software for text retrieval. This resulted in a Windows-compliant system for all corporate users.
* Provided major support for the Corporate Payroll System in all phases of maintenance, Ad Hoc reporting, database maintenance, customer support including critical job processes, on-call responsibility, problem resolution and follow-up. System/Parallel Testing for major releases. This ensured that the system was maintained, weekly payroll checks for 64,000 employees were correctly produced and system enhancements occurred in a structured manner.
* Led development and programming projects for Software Change Requests Conversion, workflow analysis, Subsidiary conversions/implementations and Bonus Payrolls. Implemented Payroll On-Line Transactions User Manuals to increase user productivity when utilizing the Online Inquiry System.
* Developed Release Standards for the Payroll System. Performed extensive Tape Management System analysis, resulting in company cost savings of $198K.
* Designed, developed and implemented an application dictionary environment for a company-wide financial redesign project using DATAMANAGER software, supporting batch and on-line environments for Corporate Payroll/Personnel. This included an interface to Excelerator-based PCs and COPYLIB/PANVALET generation for mainframe and HP3000 systems.
* Managed a staff of seven Analysts for the System Administration group. Developed new division-wide standards for naming conventions, abbreviations, and associated data administration activities, and provided major consulting, design, and technical implementation assistance in a Systems Administrator role. Co-authored and implemented a new job description family for DP documentation support personnel.
ITT Datanetics
Fountain Valley, CA - Systems Manager
* Personal computer keyboard manufacturing (Apple, IBM, etc.)
Datanetics shared mainframe environment with ITT Cannon, Costa Mesa, CA.
* Designed, developed and implemented an on-line Accounts Receivable/Order Entry/Invoicing System in conjunction with a major service vendor. Major goals were to provide real-time reporting for Receivables and Order Entry; eliminate third service bureau for Order Entry; and eliminate manual creation of orders, invoices and credit memos. Also developed policies and procedures to document manufacturing systems.
American Hospital Supply Corp./American Edwards Labs/McGaw Labs Division
Irvine, CA - Systems and Procedures Manager
* Investigated work methods addressing automated versus manual approaches and related administrative issues in Personnel, Product Support Services, and Finance. First year savings amounted to 30K+.
* Led the implementation of the Corporate Order Entry System (OES) documentation. This project involved developing new policies and procedures for the OES encompassing Sales Orders, Credit Memos and Billing Only Work Sheets, Sales Shipping Orders, and Cash Applications.
* Wrote and implemented 55 company-wide policies and procedures in the areas of Traceability, Product Recall, Credit and Accounts Receivable, and Manufacturing Operations. Performed a systems study of the Order Entry System implementation. Redesigned and re-implemented two company-wide manual systems: Forms Administration and Information Services Project Requests.
Education Cal Poly Pomona, Pomona, CA
BS - Business Administration, Business Systems & Programming
BOB SHETLAND Page 4
(Continued)