Billy Brennan Email & Phone Number

Nederland, Tx, Us

Beaumont/Port Arthur, Texas Area

- Systems Administrator and Analyst for Trimble Viewpoint Spectrum construction software which includes around 100 users. - Manage operational reporting for Richard Industrial Group for all departments, including accounting, project controls, payroll, Human Resources, procurement, senior leadership, and field personnel.- Facilitate data capturing, reporting and process flows for a variety of departments through complex Excel macro-enabled workbooks utilizing VBA and Spectrum SDX SOAP transactions, which eliminated paper processes and reduced overall time required for processing.- Develop and maintain reporting in Crystal Reports within Spectrum, having designed over 200 custom reports.- Primary data analyst for Spectrum and SQL Server. - System Administrator for Qlikview and Power BI tools, having created multiple applications based on Spectrum data for HR, senior leadership and accounting.- Created and manage data feeds from our benefits administrator to Spectrum through c# which eliminates keying errors and manual entry of data transfers for employee benefits.- Expert level on the following Spectrum technologies: SDX (both the Excel-add in and custom programming), direct data access to Spectrum SQL server, and dashboards.- Performed the initial system conversion from JD Edwards to Spectrum in November 2014.

Nederland, Texas, United States

Provide consulting services related to data and reporting for Trimble Spectrum Viewpoint. This includes Crystal Reports, SSMS, SQL query and stored procedures, Spectrum dashboards, automated Excel macro reporting, SDX API development, and anything else related to Spectrum data and reporting! Check out my web site at http://www.nannerb.com.

Beaumont/Port Arthur, Texas Area

- Manage the data warehousing and BI projects, include requirements gathering, evaluating vendors, product research, platform recommendation, and ongoing support of selected platforms.- Manage the QlikView BI platform (Desktop, Publisher, Server and Access Point) and SQL Server software for the company, including user administration, application design and delivery, and server management on Windows 2008 R2 servers.- Manage production scorecard, dashboard and traditional reporting, complex SQL projects and ad hoc data requests for all business units including retail sales, store operations support, warehouse and delivery, credit granting, collections, accounting and executives.- Provide and maintain metadata documentation for data sources across all company databases.- Design and conduct routine company training for utilizing querying tools on the iSeries systems and Qlikview platforms.- Provide extensive reporting and data mining directly for executives, and serve as data SME for all analysts within the company.- Serve as liaison between business units and MIS department for data from legacy iSeries AS/400 systems and cloud-based operational and production systems.

Dallas And Beaumont, Texas

- Manage the delivery of reporting and data infrastructure needs for 10k users on multiple platforms including Business Objects, Sharepoint, custom web apps, file shares, email and Excel.- Client Project Manager for multiple projects serving as the interface between IT and business for data and reporting needs.- Member of the AT&T Business Intelligence board.- Manage the creation, design, implementation and ETL support of multi-terabyte data warehouses on multiple platforms across the company, including Teradata, SQL Server, DB2, and Ingres.- Serve as a Subject Matter Expert for my department for SQL on the Teradata and SQL Server platforms- Oversee the usage of BI software for delivery of data within the department. Specifically this included Business Objects XI 3.1 using WebIntelligence, Rich Client, Designer and CMS for user management. SharePoint 2007 Standard is also used for file repository of reports and managing incoming data requests.

Houston, Texas Area

Managed 14 IBM AIX servers, printers, and networking for the bill print group in Houston, Texas, that printed 30M bills a month.

Beaumont/Port Arthur, Texas Area

Support all desktops, laptops and servers for the Beaumont/Port Arthur, Texas Market for Southwestern Bell.

Port Arthur, Texas

Manually enter all patient charges, run system backups on the weekends, and provide desktop support for PC's in two hospitals.

Bachelor Of Science, Computer Science

Computer Science And Religion

Education record