Brian L. GRIFFIN

ac0pko@r.postjobfree.com

https://www.linkedin.com/pub/b-griffin/43/381/9a

727-***-**** 829-***-****

Languages: VISUAL BASIC 6.0 VB.NET ADO/ADO.NET VBA MS SQL MySQL ORACLE

Operating Systems: IBM/OS –TSO, JCL, Windows

Use of the Following Software Partial List

Lotus 123/NOTES T.O.A.D MS Access 2.0 - 2007

Visual Basic 3/4/5/6/.NET MS Office MS SQL 2000 – 2008

MySQL 5.1 MS Visual Source Safe Crystal Reports 7.0/8.0/11.0

Mainframe ISPF IRMA PROFS

Organizations

Associate member of Society for Computer Simulation SCS

Associate member of Market Technicians Association (MTA)

Lotus NOTES Certification

Paradox Programming Language (PAL) Certification

Writing SuperCharts 3.0 / TradeStation trading models for my own account.

Education

ASEE - Tampa Technical Institute

Senior in BS Physics program Univ. of South Fla.

Rhema Christian Ministries, Toronto, Canada – (telecommute) March 2014- June 2014

MS Access developer

Designing, building, and testing an Access 2007 database for the food bank run by the church. Bar code scanners are used to accept food donations received from contributors and also to document their receipt by clients coming to the church.

It replaced an all-manual process that had many errors and no member or employee history visibility.

FOREX TRADING CO, London, England (telecommute) Apr 13 – Present

Doing telecommute work in accounting, CRM and HR systems on a project basis for various clients using Excel and Access in both the U.S and Europe.

The use of macros and VBA were required. Many were conversions to Access, SQL or VB.NET

Resort Inns of America 90% telecommute to St.Pete Beach, Florida 2012 – Present

Developing a VB 6.0 / ODBC application using connection strings to a T-SQL 2008 R2 backend as part of a team for the largest resort complex on the U.S. gulf coast, eliminating expensive errors costing $1,000’s per year.

It integrates the workflow for several departments in 2 separate locations, reducing errors and increasing productivity by 20%.

Writing all the queries for the forms and reports. All of the coding and most of the beta testing are my responsibility

Georgia State University (GSU), Atlanta (telecommute) Dec 12 – June 13

Systems Analyst

Designed and developed VB.NET winforms applications using ODBC connection strings and Visual Studio 2012 for primate intelligence / memory studies for the Language Research Center in Atlanta, Georgia.

OOD was used and wrote all the forms, reports and queries, providing entity relation diagrams as part of the documentation.

The programs are used by animal subjects and the test results stored in a text file because the volume is small and the client does not want licensing fees.

All of the coding and most of the beta testing were my responsibility.

Virginia 911 EMS, Norfolk (telecommute) Feb 11 – Present

Systems Analyst

Designed and developed VB.NET Win forms applications using ODBC and ActiveX classes for a 911 state wide emergency supplies inventory database.

Entire UI was redesigned by me and the project manager. Convert a Visual Studio 2005 VB.NET legacy system to Visual Studio 2010 increasing performance 200%.Wrote all the queries and forms, providing entity relation diagrams as part of the documentation, correcting errors in the data, entity and referential integrity.

Convert an Access 2003 back end legacy system to Access 2007 making massive changes to the structure (metadata) reducing record size by20%.

The code uses ADO.NET and bar code scanning and printing for the inventory items. All of the coding and most of the beta testing are my responsibility. Conversion toSQL was evaluated, using stored procedures where possible.

Pain and Wellness Center, Largo, Florida Dec 12 – Feb 13

Systems Analyst

Enhanced / validated An Access DB using a MySql 5.1.41 backend for a private medical practice in central Florida reducing DB size by more than 25%. Increased experience with Xampp and Apache server products because the MySQL DB is using them.

All of the coding and most of the beta testing were my responsibility. VBA macros were not needed or used.

Designing and developing MS Access VBA / SQL / VB.NET (ASP.NET) applications for the telecommute clients of Odesk.com, PeoplePerHour.com and Freelancer.com. All are on an indeterminate term project, per hour basis. Some of the SQL projects used stored procedures.

Resort Inns of America, Saint Pete Beach, Florida (telecommute) Feb 12 – Present

Systems Analyst

Developing a VB 6.0 / ODBC application using connection strings to a T-SQL 2008 R2 backend with stored procedures as part of a team for the largest resort complex on the U.S. gulf coast, eliminating expensive errors costing $1,000’s per year.

It integrates the workflow for several departments in 2 separate locations, reducing errors and increasing productivity by 20%.Writing all the queries for the forms and reports.

I rewrote all the form contents and user interface. All of the coding and most of the beta testing are my responsibility.

Platinum Marketing-Clearwater, Florida Mar 2010 – Feb 2012

Systems Analyst

I Converted an Excel sheet cost accounting / CRM system to an MS Access application.

I used dynamic T-SQL, I wrote all the queries and Crystal reports. This eliminated expensive errors that were costing $1,000’s per year.

I had to use my Excel and Word VBA skills from prior projects. Productivity increased by 100% allowing twice as much work to

Be done with no increase in staff. Excel sheets are imported and exported from the Access application to QuickBooks removing 90% of accounting mistakes. Word documents are created from Access record sets which had not been possible before.

I converted the back end DB to MS T-SQL 2005 to support many users when it became too big for Access. 10 staff were doing twice as much work with far fewer errors than before. All of the coding and most of the beta testing were my responsibility.

Cotton Construction-Houston, Texas (telecommute) Jan 08 – Apr 10

Systems Analyst

I Converted an Excel sheet T & M accounting system and CRM system to an MS Access application for a restoration construction company in Houston. This removed most of the employees time and materials errors in the Excel sheet system.

Approx. 300 users are entering timesheets and material usage with almost no errors, as business rules are enforced now.

I wrote all the queries, using dynamic T-SQL and Crystal reports because of the number and sophistication of the reports, many of which are completely new and weren’t possible before. All of the coding and most of the beta testing were my responsibility.

Data Forensics-Norcross, Georgia Jan 07 – Jan 08

Systems Analyst

The development / upgrade of VB 6.0 / Access / T-SQL application for Data Forensics in Norcross,Georgia using VBA / VB6, VB.NET SDLC and Excel on GIS databases used by both private civil engineers and civil service.

This allows interfaces with other programs not possible before. All of the coding and most of the beta testing were my responsibility.

Contact this candidate