Willson Thomas Email & Phone Number

Greater Atlanta Area

Provide business analysis, requirements, design, and development of the Resource Management (finance), Operations and base system components for the Reserve Component Application Software (RLAS) project. Duties include customer relations, business analysis, writing requirements documents and design documents, developing software prototypes, database design, stored procedures development and SQL Reporting Services reports. Additional duties include quality assurance, technical support and user training for the entire suite of applications.• Provided business analysis, wrote requirements, designed and developed (including database tables and stored procedures) a funding control system for Electronic Based Distance Learning inactive duty training for the Army Reserve. Application written in multi tier VB6 ActiveX control accessing MS SQL database. The system actively controls the execution of funds to ensure that annual budget limits are not exceeded. This system allows the Army Reserve to maintain a high percentage of fund execution.• Provided business analysis, wrote requirements, designed and developed (including database tables and stored procedures) a funding control system for Permanent Change of Station (PCS) individual orders for the Army Reserve. Application written in multi tier VB6 ActiveX control accessing MS SQL database. The system actively controls the execution of funds to ensure that annual budget limits are not exceeded. This system allows the Army Reserve to maintain a high percentage of fund execution.• Designed and developed a C# .NET interface to select PDF files stored in MS SQL and have them retrieved, compressed and streamed to the user workstations.• Provide business intelligence reporting, ad hoc database analysis and research, stored procedure performance analysis and stored procedure rewrites to optimize performance.• Provided business analysis and project planning for migrating VB6 ActiveX multi tier application to C# .NET.

Greater Atlanta Area

Provide business analysis, requirements, design, and development of the Resource Management (finance), Operations and base system components for the Reserve Component Application Software (RLAS) project. Duties include customer relations, business analysis, writing requirements documents and design documents, developing software prototypes, database design, stored procedures development and SQL Reporting Services reports. Additional duties include quality assurance, technical support and user training for the entire suite of applications.• Provided business analysis, wrote requirements, designed and developed (including database tables and stored procedures) a system to create, review and submit pay transactions to an external pay system. Application written in multi tier VB6 ActiveX control accessing MS SQL database. System improved pay accuracy to 99 percent. This application allowed the Army Reserve to close all but one pay office providing millions in savings.• Provided business analysis, wrote requirements, designed and developed (including database tables and stored procedures) a funding control system for all funded orders created for the Army Reserve. Application written in multi tier VB6 ActiveX control accessing MS SQL database. The system actively controls the execution of funds to ensure that annual budget limits are not exceeded. This system allows the Army Reserve to maintain a high percentage of fund execution.• Migrated over 50 Crystal and Active reports to MS SSRS. 25 of the reports have a C# .NET front end with Ajax callbacks and Java script to provide user friendly report screening selection options accessing MS SQL database.• Provide business intelligence reporting, ad hoc database analysis and research, stored procedure performance analysis and stored procedure rewrites to optimize performance.• Provided business analysis, project planning, SQL Scripts for software and data migrations plans to consolidate 10 databases to one.

Greater Atlanta Area

Provided business analysis, requirements, design, and development of the Resource Management, Training, Operations and base system components for the Reserve Component Application Software (RLAS) project. Responsibilities included customer relations, business analysis, writing requirements documents and design documents, developing software prototypes, database design, and stored procedures development. Additional duties include quality assurance, technical support and user training for the entire suite of applications. • Migrated workstation based application written in PC FOCUS to an ActiveX/DCOM/SQL multi tier environment. This enabled the 13 regional commands to have complete visibility of all business activity of all subordinate commands in real time.• Designed data replication plan to a central database to allow the Army Reserve to have visibility of all business activity of all subordinate regional commands in near real time.• Provided business analysis to detail security requirements for user access integration with Army Reserve network logons. Designed and developed system to manage user access.• Provided business analysis, wrote requirements, designed and developed (including database tables and stored procedures) a control to combine multiple order writers into one integrated process. Application written in multi tier VB6 ActiveX control accessing MS SQL database.• Migrated over 50 reports from FOCUS to Crystal and Active Reports• Provided business analysis, wrote requirements, designed and developed (including database tables and stored procedures) controls and processes to export and import data for multiple external accounting and payroll systems.

Greater Atlanta Area

Responsible for all aspects of development including: analysis meetings with the clients, writing proposals, project planning, staffing needs, database development and review, system integration, user interface (menus or windows), application coding, quality assurance testing and client training. Other specialties include application optimization and project management.

Mba, Finance

Bs, Finance

Activities and Societies: Crew, Lacross