Bryan Wright's Resume (Last updated December 5th 2007)

Over eleven years experience in SQL server, DTS, software development life cycle, Web enabled application development, ColdFusion and Windows experience. Four years developing specifications, test plans, and implementation plans as a Database Engineer. Provided comprehensive knowledge transfer including training manuals, user guides, documentation and as needed requests for the support of these applications. Accomplished database application developer and programmer using VB.NET, ASP.NET, SQL Server, T-SQL, MS Access including: database design, normalization, backend development of stored procedures, triggers, and VBA.

Responsible for all reporting needs within the company. Provided key metrics the Marketing, Sales, Engineering, and Finance departments needed for their projects. Write ad-hoc queries for one time requests as well as renewable reports. Maintain the SQL server. Keep the SQL agent jobs and DTS jobs running. Perform all DBA tasks, from user set up to server optimization.

Short term contract, upgraded an Access database to SQL Server 2000, and continuing to utilize the Access front end. Wrote a reusable DTS package to migrate all data from Access to SQL tables. Provided new development in Access front end to use barcode scanners and print barcodes on reports and labels.

Contract position at a steel manufacturing company responsible for designing, and testing DTS packages to pull, massage and load data into a SQL Server data warehouse from several sources, including IBM mainframe and Toshiba Systems.

Contract position working in the COMPUTATIONS directorate at the lab, responsible for taking a SQL 2000 database and ColdFusion MX web application developed at Sandia National Laboratory (a sister laboratory of LLNL's) and making it work for needs at LLNL. This system was to act as a self defending network, preventing unauthorized users, machines, or identities to gain access to the open lab net (unclassified network). This position ended as the budget for this project was cut, and the lab took a different direction and use Oracle to create the self defending network.

Received source code from Sandia National Laboratory and restored it to a development SQL and ColdFusion Server.
Brought up a ColdFusion application on LLNL's intranet.
Sorted through 250 CFML pages to determine the business processes used.
Used Visio to map several of the major business processes from thousands of lines of code coming from multiple sources including SQL Stored Procedures, Triggers, various file formats (i.e. .SQL, WSF and BAT), and ColdFusion pages.
Built and maintained a development SQL and an Oracle 10g Server on Windows Server 2003.

Consulted with IS/IT staff to create a solution to the company's growing need to automate senior management's reports and tools. Designed and built a SQL server back end with an Access front end. Wrote DTS packages to automatically sync the SQL database with their processing system, Mas 200; a Provide X database. Re-wrote reports in Access to pull real time data from SQL. Wrote tools intended for users and management.

Shipping tool - used for organizing and tracking shipments, capturing and organizing freight bills and giving visibility to customer service data (cases ordered VS shipped, order revisions, general sales order data).
Sales tool - used to generate complex sales reports including analysis functions.
Production scheduling - used to organize and drive efficiencies in the production facility. Forecasts demand and shows requirements allowing for 'Just in time' manufacturing model. Provides reports and analysis on production planning for management.
All of these tools help to achieve the following goals.
-reduce or eliminate labor costs associated with the manual processes they replace
-improve accuracy of planning and reporting
-reduce overall operating expenses
-drive more intelligence into critical business decision making

Contract position developed and supported financial systems (AP) including the benefits database used for tracking and reporting information downloaded from their payroll vendor. Converted Accounts Payable systems from Excel to Access for tracking, reporting and archiving of AP information. Wrote routines in Access VBA using the Cute FTP library to automate downloads of files from UNIX.

Automated processes performed in Excel and Lotus 123 into database application solutions utilizing Access and VBA.
Gathered requirements for all aspects of the development life cycle.
Automated manual tasks saving time and increasing reporting efficiency by allowing data to be updated daily instead of bi-monthly and reports to be run at any time.
Supported existing databases in Access and spread sheets in Excel.

CaseCentral is one of Inc. Magazines top fastest growing companies specializing in litigation documentary support. The Electronic Conversion (eConversion) team is responsible for the restoration, discovery, and distribution of data delivered by clients in support of their litigation efforts. The team processes Terabytes of data through secure and efficient means.

Supported development efforts for the first of many automation projects.
Developed tools and procedures to reduce human error and perform automated QC checks.
Greatly reduced the need for manual monitoring during the restoration processes.
Developed numerous adjunct scripts and tools to assist with the daily eConversion.
Managed the creation of data exports in a timely manner.
Provided technical expertise in the establishment and maintenance of complex data transformations.

So-Systems develops software for credit unions across the country. As Project Manager and Document specialist was responsible for data integration, installation, creation, and editing of FormDesigner, and JetForm customized documents. The credit union's loan officers used these specialized documents as hard copies for signatures on loan applications.

Brought in initially to build department and to create processes and procedures and for making document services transparent to users during conversion on a new system install. Oversaw testing on all document products and services on the IBM and Windows servers before shipment. Supervised staff of 6 QA engineers and trained and mentored new replacement.
Provided telephone support to credit union CEO's and their IT staff concerning new loan documents.
Created and regulated proper billing processes for the document services and support, increasing revenue from a negative to a positive in the realm of 100K+ in the first 6 months.

The Computer System Support group was responsible for writing custom software and maintaining all installed desktop and server software for Global Treasury Risk Management. As Assistant Vice President; Sr. MIS Programmer Analysts was responsible for writing custom applications and reports. Architecture design, modeling, development and deployment of SQL databases based on business requirements. Complete whole life cycle development of software programs, web design, deployment and maintenance. Heavy technical support for 65 Senior Executive business users acting as a liaison to the level 4 corporate help desk.

Designed and wrote RCredit application to move a Lotus Notes application to SQL, the intranet and Visual Basic to reduce the processing time for commercial credit requests from 3 - 5 days to near real time.
Designed and supported databases in SQL and Access, using Visual Basic and WEB front ends.
Used DTS to manipulate data from text files, Access tables, Excel spreadsheets, etc. to the SQL server.
Taught co-workers how to develop in T-SQL using SQL Enterprise Manager and Query Analyzer to write stored procedures, views, and how to develop web application using ColdFusion, JavaScript, and HTML.
Lead a project to convert our users from a Token Ring network to an Ethernet network, provided support during the conversion that saved the team hours.
Designed and wrote training manuals and taught classes on the features of Outlook 2000 addressing the issues of migration from Lotus Notes and CCmail.
Provided technical support for desktop hardware, software, operating systems, printer hardware, print servers, and network support for 65 users; saving our users an average of 5 days of down time per incident.
Wrote policy definitions, provided database support, and ad-hoc business intelligence report writing using web interfaces, SQL reports, Crystal Reports, Access Reports, Brio.

LANGUAGES: .NET, ASP, ASP.NET 1.0/2.0, ColdFusion 4.5/MX 7, T-SQL, Visual Basic 6.0/.NET, VB Script, VBA, HTML/DHTML, JavaScript.

SOFTWARE: SQL Server 7/2000/2005, DTS, T-SQL, TSQL (UNIX util.), Embarcadero ER/Studio, Visual Studios 6.0/.NET, Office 97/2000/2003/XP, Access 97/2000/2003, Outlook 2000/2003, Project, Power Point, CuteFTP, PcAnywhere, Adobe FormDesigner, FormFlow 99, JetForm, PhotoShop, Illustrator, Visual InterDev, VI, IBM Reflections, Windows Task Scheduler, Crystal Reports, ActiveX Controls, Norton Anti-Virus, Internet Explorer, Mozilla Firefox, Netscape Group Wise, Adobe Acrobat/Distiller/Reader, WebEx.

OPERATING SYSTEMS: Windows XP/2000/2003/NT/9X/3.XX Server and Workstation, Linux, UNIX, DOS.

HARDWARE: Compaq Desktops/Servers, HP Printers, Cannon Printers, Dell Workstations/Laptops/Servers, IBM Servers/Laptops, Ethernet Adapters.

NETWORKS: Switched 10/100 Ethernet, Token Ring.