Summary
Overview
Work History
Education
Skills
Quote
Stewardship
Timeline
Generic
Thomas (Alan) Wilson

Thomas (Alan) Wilson

Winfield,PA

Summary

Alan is a Developer Analyst at Data Ventures, a leading provider of data-driven solutions for businesses across various industries. He has more than 40 years of experience in the information technology field, specializing in database design, management, analysis, and execution. He is an expert in SQL, ETL, and Azure Cloud, which he uses to improve, tune, and modify stored procedures for various applications and platforms, such as Spotfire, SSIS, and Node JS. He is also proficient in MS SQL Server, Jenkins, and JIRA/OPSGENIE, which he uses to develop custom procedures, add capacity to the system, and support the UI. He is a highly motivated person who believes strongly in the team concept, works well with minimal supervision, and is always eager to learn new techniques, processes, and applications. He is passionate about troubleshooting and resolving issues, creating ad-hoc reports for users, and documenting and automating processes and procedures. He is a data-driven Developer Analyst who strives to deliver high-quality solutions that meet the needs and expectations of his clients.

Overview

40
40
years of professional experience

Work History

Software Developer

AmWINS
Charlotte, North Carolina
08.2015 - 07.2016
  • Provide Tier 2 application support for existing applications
  • Accounting
  • Insurance/Binding Reporting
  • Maintenance
  • Trouble shoot and remediate issues
  • Determine area of application with the issue or error and step through the code to determine if the application is the cause or the underlying data is the issue
  • Create Ad-hoc reports for users
  • Documentation of processes and procedures
  • Documented and created template SQL scripts for correcting reoccurring data issues
  • Documented and created template SQL scripts to insert new data into the database
  • Reporting research/modifications to SSRS reports
  • Trouble shooting data issue and making modifications to various reports and or the stored procedures that collected data for the reports
  • Stored procedure modification to improve speed of accessing reports
  • Template Modification
  • Modifications to templates, adding images for signatures
  • Modifications to wording with-in templates
  • Define, design, and develop enhancements to existing applications
  • Modified configuration tables to add new links to applications
  • Modified stored procedures for process improvements
  • Participate in proof-of-concept projects in conjunction with the architecture team
  • Follow change management and release management procedures and adhere to company policies and best practices
  • Perform other duties as assigned
  • Related software
  • SQL 2012/2014
  • NET (ASPX/C#)
  • VS 2013/2015
  • Red Gate
  • TFS
  • GIT
  • Active-Batch
  • SSRS Reports

Application Developer

Bank of America
Charlotte, North Carolina
09.2014 - 08.2015
  • Monitor production process to ensure proper completion, debugging and problem resolution
  • Working with team to document system processing
  • Related software
  • SQL 2008 – Stored Procedure Creation/Modifications, Queries
  • SQL 2008 – Job Schedule Creation/Modifications
  • SSIS – Development/Modifications using BIDS.

Database Applications Developer

Conclusive Analytics
Charlotte, North Carolina
10.2008 - 12.2013
  • Primary operational / development support for EDI application
  • Monitoring the system making sure the system is up and processing and inspecting audit processes to ensure the accuracy of the data loaded
  • Creating ETL processing to manage client and third-party list data loaded into the database
  • Database updating, procedure improvement and automation
  • Reviewing and creating SSIS packages for process improvement
  • Reviewing and creating stored procedures for process improvement
  • Development of new features and services for the applications
  • Related software
  • SQL 2005/2008 – Stored Procedure Creation/Modifications, Queries
  • SQL 2005/2008 – Job Schedule Creation/Modifications
  • DTS – Modifications to existing packages and conversion to SSIS
  • SSIS – Creation/Modifications using VS2005/2008
  • VB6/ASP – Primarily code modifications of existing code

Database Marketing Manager

Austin, Texas
08.2000 - 10.2008
  • Perform complex data management and analysis for Kraft Foods Global including segmentation and analysis for the Food and Family and Comida y Famila magazines
  • Helped Kraft Foods build their subscription base to over 9 million subscribers
  • Manage multi-terabytes of client and third-party list data
  • Developed custom ETL processes to load and manipulate data being loaded for processing
  • Developed custom processes to handle address hygiene on incoming data to the database
  • Customer database design and management in a SQL Server 2000 environment
  • Database analysis, and execution of targeted marketing programs on client databases
  • Database updating, procedure improvement and automation
  • Related software
  • SQL Server 2000, SPSS, Double Take, Mailers+4
  • SQL 2005/2008 – Stored Procedure Creation/Modifications
  • SQL 2005/2008 – Job Schedule Creation/Modifications
  • DTS – Modifications to existing packages and conversion to SSIS
  • SSIS – Creation/Modifications using VS2005/2008
  • Double-Take – Merge/Purge
  • Mailers+4 – Geo-Coding and Address Hygiene

Developer Analysts

Data Ventures
Charlotte, North Carolina
07.2016
  • 20+ years of experience working with Microsoft SQL Server (currently using 2019)
  • 5+ years using Microsoft Visual Code for API configuration and modifications
  • Participate in the design and implementation of User Interface for clients
  • Design database and application structures to support business applications
  • Improving the functionality/troubleshooting issues within base code platform
  • Improving/tuning SQL stored procedures
  • Modifying and enhancing stored procedures to be consumed by applications
  • Custom SSIS/ETL development and new development – defining new tables, adding capacity to the system, developing custom procedures
  • Major SQL development - Backend SQL to support UI and Applications
  • Debug and fix bugs in the UI, service application and database utilizing logfiles and custom email processes to alerts users of errors
  • Other tools used
  • Azure Cloud – SQL Serve set up and modifications
  • Node JS – API development of routes
  • CRON-TAB Scheduling/Maintenance
  • Postman – code testing
  • Jenkins set up using groovy scripts for deployments
  • GIT for source control and deployments between tiers
  • JIRA – Project tracking
  • OPSGENIE Alert notification’s
  • Red Gate

Education

MS 2000 DB Admin/Programming -

New Horizons
Austin, TX
03.2000

Certificate Program in Object Oriented Programming - Information Technology

Mountain View College
Dallas, TX
03.1999

Associates Arts -

Eastfield Jr. College
05.1981

Skills

  • Problem-Solving
  • SQL Reporting
  • Data Warehousing
  • Quality Assurance Testing
  • Database Development
  • Performance Improvements
  • RDMS Development and SQL
  • Analytical Thinking and Problem Solving
  • Code and Quality Standards
  • Teamwork and Collaboration
  • Structured Query Language
  • Requirements Gathering
  • Data Warehousing and Analytics
  • API Development
  • Process Improvement
  • Attention to Detail
  • Software Development Tools: JIRA, Confluence
  • Debugging
  • Team Coordination
  • Technical Support

Quote

To Honor God in All We Do.

Stewardship

Missions

The Body - A Church for anybody

Oct 2009 - March 2015

  • Helping Cuban and Philippine minitsry

Finance Adminstrator

The Body - A Church For Anybody

Jan 2014 - Nov 2014

  • Team lead in coordination of the churches financials.
    Also a coordinator in teaching the Dave Ramsey Financial Peace University.

Elder / Finance Adminstrator

House of Agape

Aug 2014 - April 2021

  • Church in Rock Hill South Carolina with a mission of feeding the homeless and those in need.

Timeline

Developer Analysts

Data Ventures
07.2016

Software Developer

AmWINS
08.2015 - 07.2016

Application Developer

Bank of America
09.2014 - 08.2015

Database Applications Developer

Conclusive Analytics
10.2008 - 12.2013

Database Marketing Manager

08.2000 - 10.2008

MS 2000 DB Admin/Programming -

New Horizons

Certificate Program in Object Oriented Programming - Information Technology

Mountain View College

Associates Arts -

Eastfield Jr. College

Similar Profiles

CREATE PROFILE
Thomas (Alan) Wilson