Work History

Work History
Apr 2009 - Present

programmer

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

and an MS Word automation project to produce Verizon telesales quotes. I combined excel automation, word automation (updated of word documents from excel data) and email automation (automatic send email messages with attached PDF document). Completed 5 projects that were put into production for Verizon telesales.
Aug 2010 - Jan 2011

programmer

health plan

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).

Apr 2002 - Feb 2009

Senior Programmer - Full-time

Visionary Medical Systems

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.

1997 - 2001

Senior Software Engineer

Verifone/Hewlett-Packard

In charge of designing, coding, testing, POS (point of sale) PC-based systems for theconvenience 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.

1997 - 1997

Senior Software Engineer.

MetraComp/Ajilon,

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.

1997 - 1997

Analyst/Programmer

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.

1997 - 1997

Oracle Database Engineer/Internet Enginee

World Color Press

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.

1997 - 1997

Senior Programmer Analyst, Systems Development

Florida Power-DCI,

(3 month cont temp position) Senior Programmer Analyst, Systems DevelopmentI 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.

1996 - 1996

Oracle Developer 2000 Programmer

GatorBait Software

laid off due to company bankruptcyDeveloped 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.

1993 - 1995

Micro Computer Analyst

Morton Plant Hospital.,

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.

1992 - 1993

Micro Computer Analyst-Owner of Home Business

JMH Software

Programmed Visual Basic 1.0 for a lottery application.

1986 - 1993

Senior Programmer Analyst -

FIRST FLORIDA BANK

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.

1984 - 1986

Senior System Analyst

COLLIER-JACKSON

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.

1978 - 1984

Systems Analyst/Programmer

SOUTHEASTERN COMPUTER CORP.

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.

1975 - 1978

Programmer Analyst

ST. ANTHONY'S HOSPITAL

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.

Education

Education

misc ed

Computer Programming and Operations - ITT Computer InstituteDB2/SQL - Platinum Technology (Computer People), 1993Rexx/CMS - St. Petersburg Junior College, 1987Unix and ?C? Language - St. Petersburg Junior College, 1986Oracle - St. Petersburg Junior College, 1994Novell CNA School - Tampa, Fla., 1994C ++ - DCI (Computerpeople) - Clearwater, Fla - March 1997OCP Intro to Oracle9i Sql--Icubed April 2002

Oracle 9iDB adm 1--Icubed May 2002 Oracle 9iDB adm 2--- Icubed May 2002 Oracle Preformance Tunning ---Icubed June 2002

hs

Bellarmine Prep School
Jan 1973

bs

univ of wash

Skills

Skills

qlikview

Additional Skills

In House Conversions                Multi-Vendor COBOL Programming New Product Development        Data Base Programming (IMS, DMS), Electronic Medical Record(emr) PC-Mainframe Connectivity      Medical, Government, Banking, Securities, POS Apps HIPAA Rules and Regulations  Full Product Life Cycle (3 Projects) SQL Database Recoveries        Systems Integration Physical Data Modeling

Skills

Language Skills: Oracle SQL, Visual Basic 6, C, C++(Visual 4.0), T-SQL, SQL Server 2000/2005, Access, Cobol, Visual Studio, Visual Studio.Net, VSS, Olap, n-tier,Oledb, RDO, ADO, COM, MS Access(97/2000/2003/2005), Paradox(DOS), Schemas, RDBMS,vba Triggers/ Stored Procedures, PLSQL, OLTP, OOD, SQL Server Enterprise Manager Studio, Oracle 9i, Clearcase, Magic, SourceSafe, DTS Imports, SQL Scripting, API, Pervasive Map Designer Office Suites: MS Office for Windows 95 and MS Office 97, 2000,2003 Corel WordPerfect Office, Windows Me, XP, Excel, Powerpoint, Word Internet Skills: HTML, CGI, Perl, Java Script, Java, Netscape, IE 7.0, XML, Frontpage, Micrographx Suite, CD burning, Digital Cameras, scanning, Video reformatting, digital photo animation, DreamWeaver, Outlook Operating System: Mainframe: MVS(IBM-3090),VAX(DEC), MPE (HP), MCP (Unisys) UNIX (SCO),Windows 95, 98, NT, XP, vista,Windows 2000, Windows ME and Workgroups,VMS, TSO, ISPF Hardware: IBM 3090 ESA, HP 3000, Burroughs 2900, Citrix  Data Bases: Oracle 7 and 9i, SQL Server 6.5 / 7, Access, IMS DB/DC, DMSII, FoxBase,physical data modeling,Systems Integration,teradata sql assistant, Clarify, Business Objects, SQL Server Enterprise Manager(2000/2005/2008), T-SQL, MySQL, SQL-Express 2005, Paradox, DBaseIV, Crystal Reports, Foxpro Utilities: Query Analyzer, Clearcase, SQL Plus, SQL Loader, Oracle Browser, Toad, MS Outlook & Express, Robohelp, BlackBox testing, VSS (Visual Source Safe) Wise Install Master 9, Crystal Reports 7/8 , Photoshop, Web-Ex, MS-Project, Visio Mainframe: Easytrieve, Roscoe, Focus, Intertest, Librarian Telecom: CICS, 3270 Emulation, HLLAPI, Netview, PcAnywhere, FTP, WebEx