Viewpoint Spectrum Consulting
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
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
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.