Post Job Free
Sign in

Sql Server Data Analyst

Allen, TX
April 15, 2024

Contact this candidate


Bradd Waggoner


Skills Summary:

Operating Systems:



Windows 10/2000/XP/Vista/77/8.1/10

Apple OS X

Ubuntu Linux

SUSE Linux

Chrome OS

SQL Server 2012

MS Access

Visual Studio



MS Office (Word, Excel, PowerPoint, and Access)

Libre Office

Data Junction 7.5


Microsoft Front Page

Team Foundational Services




Professional Experience:

Intouch Credit Union


Database Reporting Representative –September 2022. - Current

Database Analyst

Pulls data via access and Oracle Database

ETL procedures.

Jack Henry & Associates, Inc

Technical Support Representative September 2020 –September 2022.

Support Jack Henry Backing software.

Credit Protection Agency -Dallas, TX October 2014 – April 2020

Data Analyst/ Project Manager

Created and maintained reports using SQL Server and reporting services. (Using SQL, T-SQL and SSRS)

Used MS Access to read or modify data files. This was used to transform incoming data files into formatted data to upload to ether access or SQL Server.

Created and updated access databases used for report generation.

Updated Macros, VBA code and report queries.

For some data pulls, MS Access was used as a front end for SQ Server tables.

Completed SSRS updates generated by automated email distribution

MY main accomplishment here was taking customer reporting that had been done off the old mainframe and adapt the reports to pull from the company's new SQL server platform.

The last year at CPA, the QA department was disbanded; My department took over doing the quality control of;

The new SSIS file conversions for data upload to SQL Server. I would check the incoming file and a test upload of the data to make sure the parsing was done correctly.

When any report was written in SQL for an SSRS report, I would cross check the SQL code to make sure the requested data was being pulled form the database in the correct manor.

When a new report was created in Access, I was one who would check not only the output of the report but, the VBA code behind it to make sure the proper data was in the report.

Bank of America – Richardson, TX November 2008 – October 2014

Operations Representative - Universal Landing Zone - June 2013- October 2014

Legacy Asset Services – Business Support - August 2011 – June 2013

Data Analyst (National Database Repository)- November 2008 – July 2011

Obtained and formatted data files for upload into data repository.

Created copybooks to ensure file functionality.

Created time sensitive ad hoc jobs for various departments.

Served as primary contact for department throughout the organization.

Maintained Access database for tracking and file processing.

Developed Visual Basic Scripts to aid in file manipulation and movement as needed.

Verified the Balancing of deposits.

Quality assurance of deposit correction notices to customers.

Created and maintained reports modified from MS Access to SQL Server Reporting Services using SQL Server that were created for ad-hoc scheduling and used to keep staff updated on Mortgage needs.

CITIGROUP – Roanoke, TX July 2006 – November 2008

Data Analyst

Developed Access database for tape inventory and tracking for the media services group.

Wrote user and programmer documentation for database.

Managed mount requests, tracking, and off-site of media.

Oversaw updates to the inventory website of tape and silo status.

LIT Group – Plano, TX January 2006 – July 2006

Jr. Tech/DBA

Served as Database Administrator for Plano office.

Loaded and maintained Concordance and Attenex databases.

Set up client user log on and access rights for customer databases.

Created and maintained procedural and training manuals.

Repaired hardware and changed memory and hard drive as needed.

Responsible for customer server, help desk functions.

Experian – Automated Media Control Department September 1993 – December 2005

Data Management Assistant - October 1994- December 2005

Tape Operator - September 1993 - October 1994

Created data tracking program through Visual Basic 6 and Microsoft Access.

Department Webmaster for Company Intranet utilized Front Page and JavaScript.

Documented and published procedures for departmental functions.

Created and maintained Access database for Uploading methods and tracking.

Converted data formats for mainframe uploads using the Data Junction and Cambio.

Downloaded files from Mainframe to be sent to customers via FTP or PC media

Logged, uploaded, tracked and shipped Media thru credit system database.

Shipped and tracked customer media.

Created programs to copy, convert, format, track and delete files with Visual Basic 6.0.

Developed Access databases for Business Credit and Consumer Credit systems, Excel and Word status report forms used by the AMC department, Outlook forms for department and folders for internal and external customer requests, and the original Intranet pages for my Department using Front page and JavaScript.

Loaded computer tapes into drives

Filed tapes

Monitored jobs via TSO sessions

Silo Operations

Vaulted backup tapes

Created original documentation for offsite tape backup process

Personal Experience:

Utilize SQL Server developer’s edition

Learning via online Power BI Desktop.

Work with Ubuntu Linux 10.10 Operating System, Apple OS X Tiger and Windows (thru Windows 10)

Built 286, 486, and 586 computer

Created peer-to-peer network between 5 computers at home.

Currently learning Power BI.

Education / Other Skills:

Adult Education program for Visual Basic 6/VBA programming and Front Page 2000 – Richland College 1999 - 2001

N.T.S.U. Physical education Major, Speech Minor 1980 - 1986

Grade 8 Outdoor & Indoor United States Soccer Federation Soccer Referee

Plano Sports Authority Soccer Referee Instructor and Mentor. (2007-2017)

Contact this candidate