Brian J Rose

Technical Skills

Professional History

Raytheon (Geologics/RTX) 2/2015-Present
Senior Software Developer – BI Reporting

Responsible for creating and maintaining reports using SSRS, Excel, and PowerPivot. Peer review SQL scripts and related code. Set up and maintain virtual machines in AWS EC2, Microsoft Azure, and VMware. Provide technical assistance and support to team members and domestic and international customer sites. Run gate meetings ensuring smooth deployments. Closed area support. Disaster recovery testing.

• Automated backups transfers to Amazon S3, reducing manual intervention and time.
• Developed streamlined code for Business Intelligence / Data Warehouse project.
• Integrated Oracle and other source data into SQL server, streamlining integration.
• Created documentation for internal and external teams, ensuring knowledge redundancy.

Community Partners, Inc (TEKsystems/CPSA) 6/2012- 2/2015
Senior Data Analyst 11/2013-2/2015
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.

• Automated output of reports using stored procedures, SSRS, and scheduling, reducing deliverable times and increasing accuracy.
• Developed self-service model for on-demand inter-departmental reports, reducing number of ad hoc requests.
• Created automated tool to monitor database availability daily, ensuring data integrity.
• Developed reports following DBHS, AHCCCS, NCQA, and HEDIS standards.
• Converted legacy Crystal Reports reports to SSRS, allowing flexible reporting.

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. Proofread all catalogs and other publications.

• 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.
• 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.
• Created FileMaker Enterprise Resource Planning (ERP/MRP) system for MNOP, replacing an unsupported aging 3rd party system.
• 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.
• 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.
• Converted existing web sites to standards-based HTML+CSS using accessible web design techniques.
• Implemented and maintained open-source PHP e-commerce web site.
• Developed automated process for calculating piece quantities and total sheets for grouped runs, eliminating manual guesswork and reducing production time.

Western Photographic Historical Society, 1999-2009
Board of Directors (3-yrs), Webmaster, Newsletter Editor

Education

Certificate – AWS AI Practitioner Challenge
Certificate – Introduction to R Programming
Northern Arizona University, Computer Science & Mechanical Engineering Studies
Central Arizona College, Engineering Studies
Canyon Del Oro High School Diploma

Awards

Eagle Scout
Outstanding Citizen of Tucson‚—Mayoral award