Nannerb Solutions

Nannerb SolutionsNannerb SolutionsNannerb Solutions

Nannerb Solutions

Nannerb SolutionsNannerb SolutionsNannerb Solutions

Welcome!

We provide consulting for data connectivity, analysis and reporting as it relates to Viewpoint Spectrum Construction Software.

Viewpoint Spectrum Consulting

image36

Crystal Reports

  • Edit existing Spectrum reports
  • Create new Spectrum reports

Excel

  • ODBC Connections to Spectrum
  • Create data dumps to sophisticated reports
  • Custom Forms based on Spectrum Data

SDX

  • Create data dumps from forms that can be imported directly into SDX.
  • Custom Excel forms that talk to Spectrum through SDX behind the scenes through macros/VBA.

SQL Server

  • Tables, Views, Stored Procedures
  • Performance Tuning on your custom views to make them faster and more efficient

Dashboards

  • Any dashboard you can think of can be done! 

Experience

image37

Spectrum

  • Currently a Senior Data Analyst at Richard Industrial Group (https://www.richardig.com) since 2013 supporting Spectrum, operational reporting and analysis needs.
  • Extensive knowledge of the Spectrum SQL Database across these modules: AP, AR, DI, EK, EC, ET, GL, HR, IL, JC, PR, PO, TM, SA.
  • Support 65 Excel macro workbooks that interact with the Spectrum database, pulling and pushing data as needed.
  • Created and updated over 200 Crystal Reports within Spectrum.
  • Utilize custom C# apps for automating reports and analysis for Spectrum.

More about me

  • Data analyst for 19 years in telecom, retail, and now engineering/construction
  • Business Intelligence with Qlikview
  • Computer Science degree from Lamar University in Beaumont, Texas.
  • View my full LinkedIn profile here: https://www.linkedin.com/in/billy-brennan-bb1b90a/

Details

image38

Consulting Services

  • Since I work full time at Richard Industrial Group, I provide consulting on the side as I have time. This usually means I will work in the evenings Central Time or on the weekends.
  • Estimates are given on each SOW before any work is done. My hourly consulting rate is $120 per hour billed at the half hour. By the project pricing is also available. 
  • Gotomeeting is used for meetings if needed.
  • I do not offer consulting or training on the operational aspects of Spectrum, but do provide training as needed on how to utilize data and reporting as it relates to Spectrum.

Nannerb Solutions

  • "Nannerb" is simply my last name spelled backwards!
  • My contact information is listed at the bottom of this page.
  • Nannerb Solutions, LLC, is a Limited Liability Corporation registered in the state of Texas. Our DBA for Nannerb Solutions is registered in Jefferson County Texas.  
  • A contract will be provided for both parties to sign prior to the start of any work.  W-9 will be provided as well.
  • Nannerb Solutions, LLC, is not affiliated with Trimble, Viewpoint Spectrum or any of their affiliates in any way.
  • Customer satisfaction is our goal! If you’re not happy, I’m not happy! I will do everything possible to make sure you’re 100% satisfied with my work.

 Copyright © 2021 Nannerb Solutions, LLC - All Rights Reserved.   


Nannerb Solutions, LLC is a DBA registered in Jefferson County, Texas, and a Limited Liability Corporation registered in the state of Texas    


Viewpoint Spectrum is a registered trademark of Viewpoint and is not affiliated with Nannerb Solutions, LLC, in any way.  Viewpoint is a registered trademark of Trimble, and is not affiliated with Nannerb Solutions, LLC.     


Contact: brennanbd@gmail.com -- Phone: 409-344-0406 -- Based in Nederland, TX.