Sql Server Data Analyst
Resume:
Bradd Waggoner
********@******.***
Skills Summary:
Operating Systems:
Software:
DOS
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
VB6
VBA
MS Office (Word, Excel, PowerPoint, and Access)
Libre Office
Data Junction 7.5
Cambio
Microsoft Front Page
Team Foundational Services
Concordance
Attenex
Citrix
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