Andy Collins, My Chief Information Officer

Providing Senior IT Leadership and Direction for your small Ventura area business

Home
Social Media Marketing Se
Free Info
Services
In the News
Testimonials
About Us
Summary
Andy Collins Resume (CV)
Rates
History
Contact Us
FAQ
Site Map
Andy Collins Resume (CV)
 
Summary:
25 years providing solid IT leadership. A technology change expert,
from new network infrastructure to new ERP and software solutions.  Experience in programming, systems analysis and design, database conversion, report writing, training users, managing vendors, software and hardware maintenance on personal computers, servers, network switches and routers, and telephony switches. Interface with technical and non-technical users. Project manager designing full systems and specific application programs, ERP software selections and implementations. Someone who will find the most cost effective resources to meet your information technology needs.
 
Experience:
Apr. 2006 to Present
Independent Consultant,
Ventura / Camarillo / Moorpark / Santa Barbara, CA and Austin, TX
CONSULTANT

Support various small to mid-sized companies. Managed systems supporting 100 users, 6 Windows 2000 servers, 1 AIX server, & 1 Linux server, to systems supporting 65 users with 3 Windows 2003 servers, Web servers, FTP servers and attached VPN clients, down to a small wireless network of 3 computers, 1 Window 98 computer, 1 Apple Macintosh and one WinXP laptop, to systems in between running Windows Terminal Server with Active Directory.

• Secured a company’s PCI Certification
• Wrote up their Security Policies
• Helped them pass an IT audit
• Managed and supported an entire network move while upgrading it, adding a new Exchange Server, cabled entire office to support Shoretel phone system using VOIP, without interruptions
• Supported an active call center during their busiest time 
   in company’s history, with no disruption of service
   (includes telephony support, downloading and
    importing 2,000 orders from the web in that 3 week
    window)
• When the main Exchange Server went down, brought it
   back up over a holiday weekend before users logged
   back on (with hands on help, delegated help, and vendor
   support)
• Initiated and had installed a full Image Server of all
   images (large PSD files) used in Catalogs going back 7
   years
• Wrote up proposals for
        New ERP system
        Power protection
        Redundant server in the Distribution Center
        Help Desk personnel
        Telephone Bill reduction, eliminating 12 unused lines
            and lowering long distance rates
• Worked with a web person to bring on an outbound e-
   mail service, providing data extractions, ftp, and backup
   support for a 600,000 e-mail address database.
• Inventoried servers and disk drive space
• Inventoried user SQL queries and permissions
• Wrote SQL, Access, & Excel reports for users. Provided
   the systems analysis and report writing
• Worked on installation and training in SAP Business 1
• Set up a wireless network
• Performed data cleansing in SAP Business One
• Performed business analysis for Internet marketer
• Secured 16 #1 search terms on Google for a company in their target niche market
 
2003 to Mar. 2006
Bamboo Pipeline, Camarillo, CA
TECHNOLOGY MANAGER

Led company in creating IT and programming ideas and implementing them during rapid growth from being a $4MM distribution company w/ 8 users to $10MM with 4 locations and 35 users. Also provided leadership in evaluating ERP Software selection.

• Implemented MS terminal server environment by
   bringing in a new server and new computers running
   Windows 2000 and Windows XP to access remote UNIX
   Server and Windows 2003 Server.
• Managed and brought in new computer technicians and
   experts at lower costs than prior contractors saving the
   company 40% over the original contracts.
• Ported computer systems and phone system to a new
   office without disruption of service, in addition to
   supervising new office build out, buying and
   coordinating new furniture installation, installing the
   cabling, bringing in the phones and the computers with
   multiple vendors. All work was done on schedule.
• Responsible for the company's web maintenance, which
   included full quoting and order processing over the
   Internet.
• Added new backup procedures which made it quicker to
   recover.
• Added electronic faxing in and out.
• Provided remote access for modem access, in people's
   houses, and from the Orange County, Northern
   California and Nevada facilities.
• Initiated, designed, and implemented a non-stock
   database.
• Finished implementation of a hand-held plant inventory
   system.
• Responsible for data conversion from FACTS software to
   SAP Business One, using Excel, Access and Data
   Transfer Workbench. Transferred to SQL Server 2000.
• Designed a label system that made off loading and
   reloading trucks more efficient.
 
1998 to 2003
Consolidated Foundries, Paramount, CA
CORPORATE IS DIRECTOR

During company being bought out, promoted to Corporate IS Director. Company acquired 3 other facilities going from $30MM in sales to $90MM. Grew this consolidated manufacturing company’s network from 60 users in 1 location to 250 users in 4 locations in 24 months time.

• Directed company wide assessment for new MRP/ERP
   software
• Project Manager for the Y2K initiative.
• Maintained 4 sites over WAN running Windows NT
   using CITRIX Metaframe and Terminal Server over T1
   VPN, Frame Relay, and ISDN comprising machines
   running AIX, Windows NT, Windows 9x.
• Supervised technical staff of 10 which included
   contractors when needed.
• Developed a MRP/ERP Assesment Matrix now used by
   US Government procurement divisions.
 
1989 to 1998
PAC Foundries, Port Hueneme, CA
MANAGER OF INFORMATION SYSTEMS

Managed a team of 3 programmers for this $24MM manufacturing company that had 400 employees including 60 users in 2 locations. Provided systems analysis and design for all programming delivering a fully robust accounting, order entry, production tracking system in COBOL and converted same system to INFORMIX.

• Cut over 4 systems (payroll, purchasing, accounts
   payable and general ledger) in 1 weekend.
• Organized, directed, and provided systems analysis for
   conversion of TI 990 COBOL order estimating, sales,
   production tracking, and accounts receivable system to
   IBM RS/6000 running AIX with INFORMIX database
   and SQL report processing.
• Delivered conversion on remaining 4 modules when an
   “expert” contractor could only deliver 1 module that 
   worked only 1 week.
• Extracted data from the above botched payroll system
   back into the old system in 1 week, in time to meet 
   payroll with no delays.
• Designed and wrote most of the purchasing module,
   stocking function, and sales reporting system.
• Designed 2 different program generators that wrote
   COBOL code from specifications or file FD's.
• Reduced computer maintenance costs by $1290 per mth. • Added telephony and company faxing responsibilities
   taking the $2,500 per month bill down to $800.
• Added company's Internet presence, designed,
   programmed (HTML) and maintained company’s home
   page.
• Added bar-coding interface to production control
   module. Included systems analysis, design, overseeing
   programming team, and implementation.

Education:
Cal State University Northridge, Northridge, CA
B.S., Recreation, Minor: Business Administration


IT Skills:
Operating Systems:
Windows 2003 Terminal Server, Windows XP, Windows 2000, Windows NT 4/Terminal Server, 95/98, Windows 3, CITRIX Metaframe, AIX (UNIX), DNOS, DX10.
• Databases:
SQL Server 2000, 7.0, 6.5, Informix 4, C-ISAM, KIF, Access, Excel, Dbase II.
• Programming Languages:
Access, Visual Basic (VBA), Informix 4GL, SQL, HTML, COBOL, TI Sort/Merge.
• MRP/ERP Software:
SAP Business One, FACTS Distribution, Controller +, Quick Books, MRP9000 (Intuitive Manufacturing), Conversion from COBOL to Informix.
• Networking:
MCSE+I Training

Industries:
Manufacturing (Make-to-Order & Make-to-Stock)
• Aerospace
• Wholesale Distribution
• Retail
• Construction Trades & Contracting
• Restaurants
• Direct Sales & Direct Marketing
• Cataloguing
• Internet Sales/E-Commerce
• Government
• Non-Profit
• Financial Services

Concluding Statement:
You’ll enjoy my ownership mentality, where I look towards using Information Technology to build your company’s profits and reduce your expenses. You’ll also benefit from my honesty and integrity, my sense of humor, and the fact that I'm a quick learner and can think of many creative solutions.