Brian J Rose

Eagle Scout
Outstanding Citizen of Tucson‚—Mayoral award

BJR IT Consulting, 1995-2012

Independent IT Consultant

• Perform Mac/PC repairs & maintenance.
• Web site maintenance.
• Database design and maintenance.
• Newsletter setup and management.
• Networking.

TM International, (DBA: Tattoo Mfg., MNOP, Print Expressions, et al.), 1995-2012

Database Administrator, System/Network Administrator, Graphic Artist, Webmaster

Created and integrated numerous databases into an Enterprise Resource Planning (ERP/MRP) database system. Designed and maintained multiple web sites. Consolidated databases of three merged companies into one database system. Trained employees on how to get the most out of the databases they used. Maintained heterogeneous hardware and software environment comprised of Macintosh, Windows, and Windows Servers. Maintained Active Directory, DNS, DHCP, switches and cabling, multiple web sites, 300+ domain names, and shipping systems. Implemented and maintained Epicor ERP/MRP database and developed Microsoft SQL Reporting Services and Crystal Reports. Maintained color-corrected proofing printers, multiple RIPs, and Adobe graphics software.

• Converted existing web sites to standards-based HTML+CSS using accessible web design techniques.
• Created FileMaker Enterprise Resource Planning (ERP/MRP) system for MNOP, replacing an unsupported aging 3rd party system.
• Developed computerized method for creating white and adhesive plates for tattoo production, eliminating time-consuming manual cutting of film and increasing accuracy of plates.
• Handled phone, computer, and database consolidation during merger of three companies.
• Installed new network switches and cabling, increasing speed and reliability of network applications.
• Implemented and maintained open-source PHP e-commerce web site.
• Created new FileMaker ERP/MRP system for Tattoo Mfg., replacing three existing ordering systems and a paper based system to meet the needs of the combined companies.
• Developed process for calculating piece quantities and total sheets for grouped runs, eliminating manual guesswork and reducing production time.
• Integrated ERP/MRP system with Clippership and FedEx shipping software, eliminating manual re-entry of addressing data and tracking numbers. Provided salespeople with real-time shipping info to handle customer inquiries. Automated tracking info emails to customers nightly, reducing calls to customer service.
• Integrated ERP/MRP system with MS SQL Server on multiple web sites to transfer orders, eliminating manual re-entry of customers' orders and reducing errors and time.
• Developed inventory management system, eliminating the need for tracking inventory via many spreadsheets and reducing errors.
• Migrated new acquisition division's M.O.M. ERP/MRP to existing ERP/MRP system.
• Worked as part of a core team to implement Epicor ERP/MRP system and migrate existing ERP/MRP, allowing sales forecasting and Materials Resource Planning.
• Trained coworkers on and maintained the US Govt. Automated Export System, ensuring regulatory compliance and reducing international shipping delays.
• Integrated USPS shipping software with ERP/MRP system, increasing web sales with lower shipping costs.

Western Photographic Historical Society, 1999-2009

Board of Directors (3-yrs), Webmaster, Newsletter Editor

Northern Arizona University, Computer Science & Mechanical Engineering Studies
Central Arizona College
Canyon Del Oro High School

Available upon request.