Larry Wilson Summary

• Over 15 years of experience in the IT industry including business analysis, GUI design, technical documentation, customer support, training, troubleshooting, administration, networking, management of remote servers and programming
• 15 years of experience in Access and Excel development
• Proven ability to rapidly learn emerging technologies
• Excellent analytical skills Exceptional communication skills
• TARDIS Systems overlaps all of my jobs because it has been my company for many years and I do continuing support for a couple of clients in Denver and some governmental agencies sporadically.

TECHNICAL SKILLS

Applications: PowerBuilder 11.5 w/PFC, SQL Server 7.0/2000/2005, Microsoft Office 97-2013, MS Outlook, Crystal Reports Business Objects v6.0/7.0/11.0, Excalibur Oil and Gas, Macola MRP Accounting System v7.5.103, Peachtree Quantum 2012

Programming: Microsoft VBA for Access/Excel, MS Access 97-2013, MS Excel 97-2013, MS Visual Basic 6.0, MS Visual Basic .NET 2005/2010, MS C .Net 2005/2010, MS SQL Queries in SQL 7.0/2000/2005, SQL Query, Macola VBA-behind-the-screen, MS C 5.2, Unidata including UniObjects DLL , Universe, PICK Basic, Ultimate, Advanced Revelation, Prime Infobasic, SQL Stored Procedures and triggers

Platforms: Microsoft NT/2000/2003/Virtual 2005 Server, Microsoft Servers 2000/2003/205, various UNIX flavors, Pervasive SQL Networks: TCP/IP, DSL, Ethernet, DNS, DHCP, TCP, IP, PPP, VPNs, Novell 4.11

Hardware: Various access points, routers, PCMCIA wireless cards, motherboards, processors, hard drives, video cards, modems and monitors

Desktop: MS-DOS, Windows 9x, NT, 2000, XP, XP Pro, Vista Ultimate, Windows 7 Ultimate

Enterprise: Microsoft IIS 5/6/7, Microsoft SQL Server 2000/2005/2008, Crystal Reports XI, Microsoft Server 2008, ybase 15.5, Oracle 10g, Teradata

PROFESSIONAL EXPERIENCE

Confidential

• Access, Excel, VBA Developer and Integration, VB6, C .net
• Develop new Access On The Web 2013 applications
• Modify existing Access 2013 applications
• Modify existing VB6 and C .net code.
• Assist users in converting prior version Excel to 2013.

.NET Developer

Confidential

• Develop new Access 2013 applications from specs design tables in Access and create Teradata tables to replace local tables.
• Modify existing Exce many prior version l spreadsheets to upload data to Acess 2013 and/or Teradata.
• Convert prior versiions of Excel and Access to 2013 versions or assist users in the conversions.
• Working with Petroleum Experts IPM 8.0 and Prosper software
• Working with Petroleum Experts IVM software
• Working with WellView software
• Wrote the Oil Pickup Scheduling system that automatically creates the truck schedules for daily pickup of oil from every well in the Eagle Ford Shale Project and sends to orders out to the carriers. The system also parses the confirmations from the carriers and puts the information into a database so that metrics can be created reports/graphs/charts.
• Created auto-validation and installation routines for Excel and Access to insure that the correct versions were installed and that all appropriate drivers were installed using registry entries to validate. If drivers and/or software was missing, the routines fire the appropriate installation disks from the network and re-validate.
• Converted MS Access programs to C .NET 2010 utilizing Team Foundation Server
• Wrote a Teradata interface DLL and a generic string handling DLL in C .NET utilizing Team Foundation Server

Independent Consultant

Confidential

Access Developer Remote/Part Time

• Ongoing support on a monthly basis since 2001
• Assist in installing SQL Server 2000 and porting Macola to SQL Server 2000
• Port their Macola from Btrieve to SQL Server 7.0
• As of 09/1/2011, currently re-writing their EDI system using the latest 4010 forms: 810, 850, 855, 856 and writing an export of some reports from Macola to Excel using VBA
• Supporting their Macola Accounting system in manufacturing and distribution environment as well as their Windows Server WAN that incorporates offices in three cities
• Modify existing reports, Macola custom code and Microsoft Access code to use ANSI-standard SQL queries
• Took over their EDI Systems, which is written in Access, VBA and SQL as well as upgrade it to be able to split single orders out to multiple warehouses The upgrade to their EDI system involve a time-intensive analysis of their needs, helping them to understand the conditions under which a split would, or would not, occur
• Aid their interfacing to Gentran EDI system
• Wrote a system in Access to allow uploading of expenses that their salesmen send to them in Excel format, thus bypassing manual entry, utilizing Access and SQL Query functionality
• Wrote a system in Access to allow uploading of an Excel spreadsheet into the GL, so that they could develop their budgets in Excel and bypass manual entry VBA access, via Office Automation to Excel, the SQL Query and VBA functionality to upload to SQL Server 2000
• Wrote a new and comprehensive expense and commission reports, utilizing in VB 6.0 and ANSI-standard SQL queries that displayed both budget as well as actual figures for the periods in question

Confidential

Trading Analys

• Provided support to traders for pricing, volatility, forecasting, reporting and interfacing to Entegrate, Nucleus, Energy Trader ET and nERGIZE
• Business and needs analysis, design and wrote an inventory storage valuation system for North American Natural Gas in Microsoft Access 2003 The numbers produced went directly onto BPs P L statement and Balance Sheet.
• Wrote part the system documentation and training manual for the ET Administration application
• Co-wrote the standards documents for both ET documentation and training materials when done in PowerPoint
• Provided Level 3 support for BP's Energy Trader system, utilizing Powerbuilder 11.5, Sybase SQL stored procedures, iSQL, RapidSQL and Visual Studio 2008 .NET
• Analyzed problems with pricing and invoicing and providing real-time solutions to users and traders
• Modifications and new coding in PowerBuilder 11.5, Sybase and Oracle SQL
• TSI offered a wide range of sales and service to the computing community - 125/hr

Confidential

• Provided customer needs analysis and custom programming for companies, primarily used PICK, 'C', Advanced Revelation, UniData, Universe, Prime Infobasic, Microsoft Access, Microsoft Excel, VB 6.0, VB.NET, C .NET, VBA and SQL Queries
• Advanced level training to customers in NOVELL networking, Revelation, WordPerfect, Microsoft Word, Microsoft Excel, Confidential
• Access Develope
• Business and needs analysis, design and wrote safety device inspection database in Microsoft Access 2007
• Completed responsibility for all aspects of the database, from analysis through documentation and training
• Worked directly with the engineers, not with IT

Confidential

.NET Developer

• Business and needs analysis, design and wrote new programs and program modification using UniData
• Created supporting SQL Server 2005 databases
• Created VB.NET interface, utilizing Visual Studio 2005, through Internet Explorer for input and retrieval of information
• Created web pages, via Visual Studio 2005, to support data queries using SQL query syntax and BO XI
• Created Business Objects XI reports, selected against SQL databases and integrated into the Visual Studio project and web pages
• Modified VB6 program for daily data migration from UniData to SQL Server databases
• Created addition VB6 programs to support data conversion
• Modified meter reading program to facilitate accurate billing of clients, utilizing proprietary scripting

Confidential

• Developed custom application in Access 2003 and subsystems in VB6 and SQL, to run foundation repair companies after consulting with AFR on their needs and drawing up a system design This application manages all aspects of business with one of the major focus points being interface of database to external word processors for auto-generation of all of documents needed in day-to-day business of company AFR is selling this system to other foundation repair companies, starting with those companies that license its patented 'Millennium' piling
• Wrote all Access queries in ANSI-standard SQL syntax
• Converted system to both UniData and to Visual Studio 2003, C , on the PC
• Maintained their computer network installed OS upgrades, removed viruses, malware and spyware and transitioned them to Office XP from Microsoft Works

Confidential

• Single-source support for the Macola MRP Accounting System, V 7.5.103
• Converted their system from Novell Btrieve v4.11 to Microsoft SQL Server 2000
• Sold and installed new modules for Advanced Distribution, Standard Costing and Currency Management
• Modified exiting forms and wrote 'VBA behind the forms' to both create custom interfaces with existing data and to facilitate entry and retrieval of data associated with their UK owner's manufacturing operation and to automate some processes within order entry and purchase order entry The new interfaces required extensive needs analysis and screen modifications to interface with a new, separate SQL database and interfacing the new tables with existing and new Crystal reports
• Wrote custom reports utilizing the Crystal 7 Business Objects reporting system and ANSI-standard SQL queries and troubleshot reports they created that had problems
• Wrote many data interfaces, reports and updated/modified/deleted queries for their Macola database in Access and SQL, utilizing ANSI-standard SQL queries
• Wrote two programs in VB 6.0 to support their IT dept. One checked all machines to make sure they had Macola VBA loaded, and the other was to automate the reprinting of custom Crystal Reports that printed Receiving Inspection and Material Review Move Tickets tickets were custom modified in Macola The VB 6.0 programs also incorporated new subroutines that allowed them to dynamically pick new SQL server/database to attach to
• Assisted in the implementation of LEAN in their Macola system by writing custom modifications into the Macola system and writing new reports fixed the Macola MRP explosion report that did not work as shipped with 7.5.103 The major reporting system was a new implementation of the MRP explosion that would allow them to show just on major project or include several major projects Additionally, the multi-project system written in Access would allow them to show each project or show combined quantities for all projects for each assembly/part
• Confidential
• Moved their accounting system from Btrieve to Pervasive SQL and upgraded it from 6.5 to 7.5.103
• Wrote custom reports in Microsoft Access 2000, utilizing ANSI-standard SQL queries and custom modified Macola screens
• Confidential
• For DCS's client, a hotel financial services company, created Excel reports utilizing office automation via VBA in Microsoft Access 97/2000 and querying SQL Server 6.5/7.0, utilizing ANSI-standard syntax
• Created satellite communications program to gather data from wellhead and transmit it to passing satellite, programmed in MS C 5.1 and 8086 assembly language

Confidential

Programmed in UniData fixed End-of-Month reports to shorten run time accomplished a 50 percent reduction in five days of work time and to allow data entry of current charges before all payments for past month were entered, which allowed them three more data entry days per month

• VB 6.0 project utilizing ObjectCall UniData to do dial-up RAS and FTP documents to and from medical insurance sites and do EDI with documents, utilizing standard EDI formats
• Developed DLL in VB6.0 that encapsulated all of major file and string operations of UniData in reusable class