THOMAS A. BROWN

**** ***** ***** *****

Houston, TX. 77066

832-***-****

adwuli@r.postjobfree.com

Objective

To provide my extensive experience with SQL Driven Applications for the World Wide Web and Windows Environment. This will include, but not limited to, Data Insertion and Extraction (ETL) from many platforms, design tables for storing this data in a normalized and efficient manner. Create complex queries and stored procedures for inserting, updating, filtering, retrieving and sending the results to the Front-End using C# or VB.Net.

Experience Summary

Twenty + years experience with various windows and web based development projects utilizing significant data from SQL and Access databases, including hands on development and database management duties. Projects included single user windows applications, as well as high traffic e-Business web sites, supporting full B2B and B2C functionalities. Responsibilities included analyzing and defining the client’s online needs and transforming those requirements into a comprehensive online technical solution.

Development Tools and Technical Background

Operating systems: Windows 3.x/95/98/2003/2008, Windows NT 4.0, Windows 2000/XP/7,8 DOS, IBM PC-DOS, MS

Development tools: Visual Basic 4.0-6.0, MS ACCESS 97-2007, MS SQL 6.0/7.0/2000-2012, T-SQL (Stored Procedures) and database performance tuning, ETL, IIS 6/7, ASP, VBScript, JavaScript, ODBC, ADO, OLE, CDO, SMTP, HTML, XML, CSS, Visual Studio 2003-2012, Visual Interdev, MS Office 97/2000/2003/2007/2010, FrontPage, SourceSafe/Team Foundation Server.

0

WORK HISTORY

The Highered Eductaion Coordinating Board 12/6/2021 - 9/30/2022

Senior Software Developer

* Documented legacy VbCode and SQL script used to validate input files sent to my client for updating their database records. They had many clients that sent different formats. The documentation would then be used to update the older legacy code. This evolved the use of MS Excel, MSTeams, SQL server, VB code, Visual Studio, Azure, SharePoint, Azure devops and SQL management Studio.

Brown Box Financial Services. 1/15/20 - 11/16/20

Senior Software Developer

* Provided a windows form environment for an Authorize. Net interface to charge customers for their usage. C# was used for the interface thru the Authorize.net API. This code allowed the user of the program to import the user charges from the most recent billing period. That information would then be exported thru the Authorize.net server using their API.

Woodforest Bank Woodlands, Texas 8/2018 – 3/2019 (Contract)

Senior Software Developer

* Provided SQL and Excel VBA support for various internal reports. Converted some of these into SQL stored Procedures and view for use in SSRS style reports. Documented many of these using excel to detail the source of the data and translated complex excel formulas to SQL style script.

Twentieth Century Baseball Association (T.C.B.A.), Santa Barbara, CA. 4/2017-6/2018 (Remote Contract)

Senior Software Developer

* I am building a large scale flat file, to record statistics on the 40 year league history. This will include a SQL database and a C# website. The data from all 162 games for each team and season will be exported from flat files to the appropiate SQL Database tables. Stored procedures will be created to allow each teams stats for all appropriate games. All cummulative stats will be created by algorithms that match the MLB. All teams and their players can be searched and displyed by season in a dasboard by like interface using C#.

Newspaper Subscription Services (NSS), Houston, Texas 1/2017-3/2017 (Contract)

Senior Software Developer

* Provided SQL and VB.Net support for the company’s Newspaper Subscription Service Back Office Application. Sql responsibilities included T-Sql queries and stored procedures, performance tuning, ETL functions using SSIS and reporting using SSRS.

Harris County Precinct 4, Houston, Texas 2/2014 –8/2016

Senior Software Developer

* My responsibilities included, but not limited to, maintaining all SQL database objects in house. Many in-house applications had to be moved from VB win applications to .net C# web applications, along with taking Access databases to SQL Server using ETL functionallity. Database performance tuning, backup/restore, profile/tracing. Writing T-SQL Stored Procedures. One application was a uniform order and tracking system utilizing the Web. This required asp.net C#, Telerik .Net Controls and SQL databases. Telerik was used, because of its unique access to SQL data through a grid like Front-End control. These grid controls provide editing capabilities, sorting filtering and batch processing among a host of other functions. I also developed an application that could be used on company furnished ipads.

Greater Houston Partnership (GHP), Houston, Texas 7/2007 –1/2014

Senior Software Engineer

* My responsibilities include maintaining all database objects in house and on the web. GHP’s membership is maintained using an association software package called “IMIS”. IMIS uses a SQL server backend and a desktop as well as web client front-end. All members, events, committees, relationships, etc., are maintained through this software application. I have developed a .net (c#) web interface for event registrations including payments using PayPal. I’ve also created a web service for providing data to a 3rd party company providing web content and a RFP service. I have written many applications to serve our users and members. These applications have all required SQL T-SQL stored procedures and C# back-end code. I also wrote the login code using SQL authentication using GUIDs.

* In order to perform the above mentioned tasks or projects, the following SQL skills were used:

* Export data from other applications (Access, Excel, CSV and tab delimited) and import this data to SQL (ETL).

* Write complex views (T-SQL queries), using inner/outer joins and unions, to deliver specific data from multiple tables. ).

* Write stored procedures (T-SQL) using multiple input parameters, to allow user input to filter the results.

* Write MS SQL jobs to run SQL scripts (T-SQL) that will perform scheduled tasks as required.

* Design and build MS SQL tables to store related data, making use of primary key constraints, indexes and foreign key constraints when necessary.

* Develop SSRS reports to supply data in a printed document.

* Some limited SSIS was used to automate tasks.

* Performed most DBA tasks, such as backup, restore, optimize, replication and maintenance tasks.

Analysts International (Wells Fargo Contract), Houston, Texas 4/2006 –7/2007

Senior Software Engineer

* My responsibilities include client enhancements, bug fixes, deployment packages, and performance scripts. There are approximately 60 clients and each installation is unique and installed on the client’s servers within their firewall. The front end is a web based intranet, using classic asp, javascript, css, ajax and some .net. The back-end is MS SQL Server 2000 and 2005, making use of T-SQL stored procedures and user defined functions, to generate result sets for display purposes, update underlying tables, log user actions, authentication users, and send email in response to requests from the front-end. Most, if not all, front-end programming is accomplished with Visual Studio 2003 or 2005 and Visual Source Safe. SQL Analyzer is used for all database scripting. Redgate’s software is used extensively for comparing database structure, as well as data.

IAG: Information Advisory Group, Houston, Texas 10/2005 – 4/2006

Senior Software Engineer

* I am currently responsible for the monitoring and troubleshooting of several existing websites. I am also responsible for the design and development of any and all new online websites. These responsibilities include SQL Server database design and scripting using T-SQL, ASP Server Pages using VBScript, HTML, CSS, JavaScript and other technologies, dlls and com objects using Visual Basic. Other third party technologies required, included QuickBooks integration, Acrobat PDF’s, Envoy NFS Fixed format files for exporting medical claims, and an Online Medical program complete with Practice Management, Accounts Payable and Human Recourse modules.

Contract – Teligistics, Inc. The Woodlands, Texas 04/2005 – 09/2005

Senior Programmer Analyst

Develop new Online RFP product.

* I was responsible for the design and development of an Online RFP for the Telecom industry. The responsibilities included, the creation of a back-end database and an active server page front-end. The product required three integrated interfaces (Client, Vendor, and Maintenance). I created the back-end using an MS SQL server database. The front-end consisted of Active Server Web pages consisting of VBScript, HTML, CSS, JavaScript and other technologies where required. Security was accomplished by using Login and password identifications qualified through back-end T-SQL stored procedures.

DDS-Data.com Conroe, Texas 08/2003 – 03/2005

Senior Programmer

Maintain existing and develop new active server pages for several online clients.

* Our product provides online reporting tools for evaluating credit card transactions for clients that serve several merchants. Reports consist of active server pages serving as the front end and Microsoft SQL server database as the back-end. It was not unusual for their database to handle millions of records. My main focus for the company is their Fraud product. I upgraded an existing fraud package, by allowing risk investigators to select from unique merchant criteria and then select from several transaction parameters, to query the database and alert them of potential fraud. Most of the front-end work utilizes VBScript, JavaScript and HTML. I currently write many SQL stored procedures, to provide the data for the reports. We are currently using Dot Net and C# to develop front-ends for our newer customers.

Contract Townsend’s Polymer/Services & Information Houston, Texas

Programmer Analyst 04/2003 – 08/2003

Designed and develop active server based applications with SQL Server back-end.

* Client: Townsend’s Polymer/Services & Information - Maintain web-based product using Active Server front-end with SQL 2000 database. Requires SQL Server 2000 T-SQL, ASP, HTML, JavaScript, and VBScript.

Townsend’s Polymer/Services & Information Houston, Texas

Programmer Analyst for Web based Products 01/2001 – 04/2003

Designed and developed active server based applications supporting full B2B functionalities for North America and Latin America.

* Designed and developed a web-based product, to replace an older existing one that used a CD based delivery method. It was built on an MS Access 2000 database with a Visual Basic 6.0 front-end. I converted the back-end from MS Access 2000 to MS SQL Server 7.0/2000 using T-SQL stored Procedures and the front-end from Visual Basic 6.0 to active server pages using VBScript, JavaScript and HTML.

* Developed a client maintenance module for the purpose of maintaining client contract information, login security, and generating usage and billing reports. The program provided a search engine used to setup client access to their purchased portion of the database.

* Provided a comprehensive data entry program for researchers, both internal and external to the company. These researchers interviewed companies and entered data appropriate to their industry.

* Provided a multilevel search engine used by the client to generate company profiles, mailing lists, aggregate summaries, and downloads of pre-selected data.

* All, if not most, of the above programs utilized an intranet environment with Active Server front-end and SQL 2000 back-end. The majority of functionality was written with SQL stored procedures. I designed and built all tables with the appropriate primary keys and indexes, to enhance performance and integrity (Third Normal Form where possible). Views were deployed to access these tables from the front-end.

Digital Consulting and Software Services Houston, Texas

Senior Application Specialist 10/2000 – 01/2001

Participated as part of a team and contributed to the development of several projects and when required, was sent out to work onsite at client locations.

* Database design and implementation using MS SQL Server 7.0 and MS Access 2000. This included table, view and stored procedure development. Front-end programming using Visual Basic 6.0, VBScript, JavaScript, and HTML. This included login script, data entry validation, page redirects, and multiple functions using ADO, CDO, SMTP, and other object oriented code. Command Objects were used for most SQL (T-SQL) stored procedures. ADHOC queries used sparingly for simpler data display and menus. Worked with internal project teams and also was sent out to clients, to work onsite.

TRAINING

* Microsoft 574 System Administration for Microsoft SQL Server 6.0, 1996

* Implementing a Database Design on Microsoft SQL Server 6.0, 1997

* Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition (1)

* Exam 70-306: Developing and Implementing Windows-based Applications with Microsoft Visual Basic® .NET and Microsoft Visual Studio® .NET (1)

* Exam 70-310: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework (1)

(1) MCAD.Net online through SmartCertify.com (main focus Asp.net and Visual Studio.net)

2/7/19 Page of

Contact this candidate