VisualCV

This project involved extensive database conversion coding using Visual Basic 6.0 of a Btrieve medical billing system to a SQL Server 2000 Data center database in Orlando. This involved extensive use of Btrieve call and ADO connections to a SQL server 2000 database. I was heavily involved in on-line retrieval and testing and end-user testing. Also extensive use of SQL Server Enterprise Manager 2000/2005 for database creation, backups, restores, stored procedures, T-SQL, DTS imports/exports. Over 300 clients with 1800 databases were converted from 60 different Medical Billing systems to 1 common system. Our data center model was the ASP model using Microsoft Remote Desktop and also involved transmitting SQL Server backups to the AT&T data center over a VPN (Virtual Private Network). Performed 100 SQL Database Recoveries for SQL 2000 and SQL Server 2005 databases. Extensive use of SQL Scripting for maintenance imports. Also used Pervasive Map Designer to map ODBC, SQL, Binary, Btrieve databases to Visionary SQL databases. Used Web-ex for customer dialins.

Heavy new development coding and design for a national workmen's comp and managed-care provider company. This project written in Visual Basic 6 (with OLE documents, ADO data controls and grids and heavy use of server (network) based Access tables) is a complete front-end customer view of manager care providers with all demographics and repricing data. Approximately 40 different modules and approximately 20,000 lines of VB 6 code. Also extensive use of SQL Server 7 linked tables and extensive use of VB SQL commands. Also heavy installation coding using Wise Install Master 9.0.

In charge of designing, coding, testing, POS (point of sale) PC-based systems for the
convenience store and gas-station industry. I also developed communications software for both serial and modem communications between a PC and the POS terminal.
I used Visual Basic 6, Visual Basic 4 (Sheridan, Videosoft Controls) and Crystal Reports 7 extensively with some light VC++. I also developed installation programs using Wise Install Master to test/install the software on all variants of Microsoft Windows from Windows 95, 98, NT 4, 2000. Also I developed an Engineering Tracking system in Visual Basic 6.0 that interfaced with a server-based Clarify database. Extensive use of Visual Source_Safe (VSS) for source check-in and Visio for Flowcharts, diagrams.

Responsible for coding, testing, and documentation of a new security processing system. This system would allow account executives to review security positions, trades, production and customer account balances for securities such as Municipal bonds, equities, mutual funds, etc.
Written in MS Visual Basic 4.0 using RDO controls tied into SQL Server 6.5 databases.

This job entailed creating dynamic HTML web sites using Platinum SQL Station embedded inside of HTML,CGI and JavaScript. Our clients included Lucent Technologies, Paradyne and Spiegel catalogues. We used extensive data modeling (S-Designer) using physical data models and Oracle packages. These web sites allowed customers to place orders for telephone, routers, etc.using an extensive search of online database with graphics images and catalogues. The web site ran on Sun Solaris servers.

(3 month cont temp position)
Senior Programmer Analyst, Systems Development
I programmed in MS Access 2.0 tied in with Oracle databases on Windows NT 3.51 servers. I also programmed many graphs of Florida Power loads and temperatures, and performed many maintenance changes on existing systems. I worked for the Power Marketing Dept. in their trading room and their energy control center.

laid off due to company bankruptcy
Developed conversion/load procedures for Oracle Accounting Software for the Nursery/Greenhouse Industry. Extensive use of Oracle 7.1 Developer 2000 in Windows 95 environment. Interaction with Novell Netware 4.1 and SCO Unix Servers. Extensive SQL Conversion coding using SQL * Plus and PL* SQL scripts, SQL Loader, Procedure Builder (Triggers), and Oracle Browser. Some Oracle forms (4.5) development and also Delphi 2 development.

Designed, developed, and implemented three complete financial applications for the Home Health subsidiary of Morton Plant. The applications were Payroll, Purchase Orders, and Human Resources.
* All applications were written in Borland Paradox for DOS, and were installed on both Novell 3.1 networks and stand-alone . Symantec?s PcAnywhere was used extensively to communicate data from office to office.
* Developed employee wellness database using Microsoft Visual 3.0 and VB. 4.0 (Prof. Edition) and Microsoft Access 2.0. We used Crystal Reports for reporting.

Programmed Visual Basic 1.0 for a lottery application.

Maintenance of Marshall & Isley banking code and conversion of correspondence banks to this vendor’s system.
* Converted seventeen banks from different vendors? C & S, NCR, FIS, Burroughs,
NAFS to M & I deposit systems.
* Converted 110,000 accounts and $600 million in balances for DDA, Savings, CD?S,
and IRA accounts.

Senior Programmer Analyst, Systems Development 1986-1990
* Designed, developed, and installed a complete PC-BASED deposit and consumer loan branch automation system for First Florida branches. Saved millions of dollars in duplicate data entry, printing, and transmission costs to host and increased accuracy and efficiency. Co-Lead on project and timeline was developed in MS Project.
* Designed, programmed, and implemented the real-time transmission of customer information from PC’s to an IBM 3090 host using 3270 emulations.
* Developed complete deposit and consumer loan reporting system in FoxBASE. The reporting system contained daily and monthly consolidated reports.

Programming and installation of newspaper circulation software throughout the United States. This software was installed on HP 3000 and DEC. VAX mini computers.
* Installed three newspaper circulation systems throughout the Midwest.

Programming, design, and installation of taxation and appraisal systems for county governments throughout the United States. All systems were on Burroughs small and medium systems.
* Programmed and installed five taxation and appraisal systems in the United States.
* Programmed complete taxpayer billing for ten county government clients.

Conversion of service bureau patient accounting system to in-house system. Development of on-line real time patient accounting system for patient charges, admitting, and insurance billing. Developed G/L system.
* Converted service bureau to in-house in fifteen months for all charges and accounts receivable.
* Developed real-time system in Burroughs DMS II for admitting, patient charges, and insurance charges, and insurance billing in thirty-six months.

Contractor SQL VBA – Verizon Wireless - 4/20/2009 – 7/30/2010

Contract work using VBA, VB, Access and Teradata SQL Assistant.  Heavy use of SQL queries and data mining against a very large Teradata database to gather Telesales statistics on wireless devices and top salesmen.  I also wrote some MS Outlook automation code to invoke an email program for contacting customers about possible sale

Health Plan Services (Tampa, Florida) - Contractror

Medium term Contract Position – 8/15/2010 –  01/31/2011

Programming Document Fullfillment in a mail merge language called

Docuflex (Oracle).