SUMMARY:

• Over 30 years of experience in the IT industry including business analysis UX/UI design, technical documentation, customer support, training, troubleshooting, enterprise and network administration, networking, management of remote servers and programming
• 15 years of experience in Word, Access and Excel development; very strong on VBA and macros.
• Proven ability to rapidly learn emerging technologies
• Excellent analytical skills. Exceptional communication skills
• Confidential overlaps all of my jobs because it has been my company for many years and I still do continuing support for a couple of clients in Denver and some governmental agencies,sporadically.

TECHNICAL SKILLS:

Primary Applications/Languages: UniData/Universe/Ultimate/Prime Information/AREV (Advanced Revelation), VB6, MS Access/Excel/VBA/Formulas, PowerBuilder 11.5 (PFC)

Applications: PowerBuilder 11.5 w/PFC, SQL Server 7.0/2000/2005/2012 , Microsoft Office 97 - 2013, Crystal Reports (Business Objects) v 6.0/7.0/11.0 , Excalibur Oil and Gas, Macola MRP Accounting System - v7.5.103

Programming: Microsoft VBA for Access/Excel, MS Access 97-2013, MS Excel 97-2013, MS Visual Basic 6.0, MS SQL Queries in SQL 7.0/2000/2005/2012 R2, SQL Query, Macola VBA-behind-the-screen, MS C 5.2, UniData (including UniObjects DLL), Universe, PICK Basic, Ultimate, Prime InfoBasic, Advanced Revelation (AREV), SQL Stored Procedures and triggers

Qualified Programming: MS VB .NET 2005/2010/2012 , MS C# .Net 2005/2010/2012 - I am great with the languages; weak on .NET Framework

Platforms: Microsoft NT/2000/2003/Virtual 2005 Server, Windows Server 2012 R2, Pervasive SQL, NetWare

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, Windows 10 Pro

Enterprise: Microsoft IIS 5/6/7/8, Sybase 15.5, Oracle 10g/i, Teradata

Documentation: BS Elem Ed, newspaper columnist/reporter and decades of doing documentation for accounting, inventory distribution and medical patient management systems has given me extensive experience

PROFESSIONAL EXPERIENCE

Confidential, Dallas and Houston, TX

IPM Engineering Technician

• TSI offers a wide range of sales and service to the computing community
• Software contractor 6/1980-Present
• Rocky Mountain Area Hardware/Software distributor 6/80-12/95
• Specializing in Pick/AREV/Unidata/Universe/Access/Excel/VBA/VB6/VB.NET/SQL/MS C 5.1
• Sybase 15.3/Oracle 10i/Powerbuilder 11.5/MS SQL Server (all versions), Pervasive SQL
• Medical Insurance/Accounting/EDI/Inventory/Wholesale Distribution/Manufacturing experience
• Management consulting provided to various IT clients.
• SPECIALIZED SKILLS: MS VB 6.0, PICK/UniData/Universe/Revelation(AREV)/Prime Information, MS Access/Excel/VBA/Formulas, data migration, database design (datatyping, indexing) on any database system, including Oracle 10i, SQL Server (up to 2012R2), Sybase and Teradata. I can do triggers and stored procedures, but I'm only about a 4/10 on those. Documentation is also a specialty; my years as an elementary teacher and newspaper reporter and columnist, as well as decades of software documentation have allowed me to excel at this.

Confidential, Houston, TX

IPM Engineering Technician

• Access, Excel, VBA Developer and Integration, Teradata Database DBA
• Developed new Access applications from specs (I was the sole BA); designed tables in Access and then created Teradata tables to replace local tables, acting as DBA, and was the Project Manager.
• Modifed existing Excel spreadsheets to upload data to Access and/or Teradata.and/or SQL Server
• Converted Access 2000 programs/code to Access 2012
• 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 pickup 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. All BA, DBA, documentation and training work. This project eliminated the need to replace 3 people that had quit Conoco who were working solely on manually processing this information.
• 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 handler DLL in C#.NET utilizing Team Foundation Server

Confidential, Dallas, TX 

Trading Analyst

• Ongoing support on a monthly basis since 2001
• Supported their Macola Accounting system in manufacturing and distribution environment as well as their Windows Server WAN that incorporates offices in three cities
• Ported their Macola from Btrieve to SQL Server 7.0
• Assisted in installing SQL Server 2000 and porting Macola to SQL Server 2000
• Modified 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
• Re-wrote 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, acting as PM, BA, DBA, developer, documenter and trainer.
• Improved their interfacing to Gentran EDI system from Macola using Access as an aggregator
• 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, Houston, TX

Trading Analyst

• Initially hired in as a RAD BA/Developer for trading support in Access/Excel/VBA
• 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. All BA, DBA, developer, documentation, training and some PM work
• 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 (w/PFC) and backended with SQL Server, Sybase and Oracle SQL

Confidential, Houston, TX

Access Developer 

• 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
• Performed all BA, DBA, documentation, training work and some PM

Confidential, Houston, TX

.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
• Performed all BA, DBA, documentation and training work

Confidential, Dallas, TX

Access Developer

• 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
• Performed all PM, BA, DBA, documentation and training work

Confidential, Systems, Dallas, TX

Access Developer

• 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 existing 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
• Performed all PM, BA, DBA, documentation and training work

Confidential, Dallas, TX

Access Developer 

• Supported their Macola Accounting system in manufacturing and distribution environment, and their network
• 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
• Performed all PM, BA, DBA, documentation and training work

Confidential, Dallas, TX

Access/Excel Developer

• 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
• Performed all PM, BA, DBA, documentation and training work

Confidential, Stratford, CT

VB6 Developer

Responsibilities:

• Programmed in UniData; fixed End-of-Month reports to shorten run time (accomplished a 50 percent reduction of reports run time in five days of work time) and modified system to allow concurrent data entry of current charges while bills and reports were running for the previous month. This allowed Dianon 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, including Medicare/Medicaid and do EDI utilizing standard EDI formats
• Developed DLL in VB6.0 that encapsulated all of major file and string operations of UniData in reusable class
• Performed BA, DBA, documentation and training work. Limited PM
• Performed all PM, BA, DBA, documentation and training work
• Wrote and maintained large medical billing system in AREV 3.12. This software managed patient and insurance information and billing for 50 therapists and handled multiple modalities and insurance companies. APT was one of several clients, but the longest-using.
• The software was 1 of 10 packages that the American Physical Therapy Association recommended.