Brian J Rose

[email protected]

Technical Skills

Programming:T-SQL • MDX • SSRS • VB • VBA • FileMaker • Epicor • HTML • CSS • Perl • RPL • PHP
Applications:HealthTrio xpress • Microsoft SQL Server 2000-2012 • Microsoft Visual Studio 2008-2012 • SharePoint • Microsoft Access • Microsoft Office (Word, Excel, PowerPivot, PowerPoint, Outlook) • Crystal Reports • FileMaker • Epicor • Adobe CS (Photoshop, InDesign, Illustrator, Acrobat) • OpenOffice • LibreOffice • Google Apps • SpiceWorks • Google Adwords • Google Products • Google Webmaster Tools
Operating Systems:Windows • Windows Server • Mac OS X • Linux
Networking:Macintosh and Windows setup • installation • networking • security • DNS

Professional History

Community Partners, Inc, (TEK Systems/CPSA), 6/2012-Present
Senior Data Analyst 11/2013-Present
Utilization Data Analyst 6/2012-11/2013
Responsible for developing and documenting monthly and quarterly government regulatory and internally required statistical analysis and reports using SSRS, Excel, and PowerPivot. Rewrote SQL scripts into stored procedures. Lead analyst for NTXIX SMI project. Dimensional modeling and testing of Business Intelligence / Data Warehouse project using Agile methodology. Provide technical assistance and mentoring to team members.
TM International, (DBA: Tattoo Mfg., MNOP, Print Expressions, et al.), 11/1995-3/2012
Database Administrator, System/Network Administrator, Graphic Artist, Webmaster
Created and integrated numerous databases into an Enterprise Resource Planning (ERP/MRP) database system. Consolidated databases of three merged companies into one database system. Implemented and maintained Epicor ERP/MRP database and developed Microsoft SQL Reporting Services and Crystal Reports. Trained employees on how to get the most out of the databases they used. Designed and maintained multiple web sites. 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. Maintained color-corrected proofing printers, multiple RIPs, and Adobe graphics software.
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, Engineering Studies
Canyon Del Oro High School


Eagle Scout
Outstanding Citizen of Tucson‚ —Mayoral award