Jkm Hoffman

Health Plan Services (Tampa, Florida) - Contractror
Medium term Contract Position - 8/15/2010 - 0Consultant

• Programming Document Fulfillment in a mail merge language called Docuflex (Oracle)
  

for a 30 state rollout of Health, Life and Disability claims for Nationwide Insurance.

• Loaded and Configured Mutiple Carriers Databases based on Input Feeds.
  

• Worked with QA Team to setup test parameters for QA test data and production test data.
  

• Perform heavy Multiple regression analysis to verify that state specific docuflex inclusion rules did not impact generic inclusion rules.
  

• Worked on benchmarks for speed of production reports.
  

• Used Visual Source Safe to track code changes. Performed a large amount of manual testing and worked with QA on best practices and test cases for testing. Experience with developing Functional Specifications, Process Flows.
  

• Demonstrated understanding of SDLC's and use of version control systems (SVN).
  

• Excellent time management, organizational, and prioritization skills and ability to balance multiple priorities.
  

• Performed SIT and UAT Testing
  

• Requirement gathering
  

• Analyze the results from usability tests, and document findings (i.e., end-to-end user experience, user workflows, specific UI screens and components, etc.
  

• Test scenarios, test scripting, test execution, defect entry documentation, logging and metrics
  

• Prepared a custom welcome letter to introduce the client to HPS.
  

• Implement assignments made through the Track-it Work Order system
  

QA Analyst - Manual Test Writer

• Used a Remedy Trouble Ticketing System
  

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.

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

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

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.
jhoffmanwhiz@verizon.net
jhoffman123@live.com
jkmhoffman@yahoo.com
jkmhoffman@gmail.com
727-785-8361

visit me at the following sites:
http://www.jobster.com/people/jandmandkhoffman
http://www.brightfuse.com/
http://www.facebook.com/people/Jim-Hoffman/1046185977
http://www.linkedin.com/pub/12/554/227
http://www.slideshare.net/jhoff
http://www.myspace.com/209212843

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.

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

Micro Computer Analyst-Owner of Home Business
Programmed Visual Basic 1.0 for a lottery application.

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

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

Verizon Wireless Tampa, FL 4/20/2009 - 07/31/2010
Consultant

• Created 20 ad-hoc SQL queries using Access VBA and Teradata SQL Assistant for sales reports.
  

• Created an Access VBA front-end to data mine Teradata for wireless device sales.
  

• Wrote Outlook VBA automation code to email sales quotes (sales quotes) written in Access with excel back-end to Verizon Wireless customers .
  

• Wrote an Excel VBA program to mail merge Spanish/English wireless contracts.
  

• Wrote a Word VBA automation project to create Word sales quotes.
  

• Interfaced Rockwell call center monthly call volume using Access VBA for sales tracking.
  

• Combined Word VBA automation and Outlook VBA email automation into a single process.
  

• Skill in designing windows, dialogues, menus and toolbars
  

• Extensive work with VBA Excel functions (cell movement, updates, add-ins, summaries ).
  

• Used reporting software to make reports.
  

• VBA Automation - inserting Access data into Excel templates
  

• Used Visual Studio 2008 - created simple VB.net, ASP.net apps.
  

• Extensive use of Grid controls for sales screens.
  

• Extensive use of inner and outer nested joins for sql queries
  

• Used IM(Instant Messenger) for development chat with other engineers.
  

• Used Visual Source Safe for check-in/check-out of source code.
  

• End-to-end solution delivery, from analysis, design to implementation, which will include documentation, testing and co-ordination within the rest of the team.
  

• Developing ad-hoc reports as well as developing scripts for automated and standardized reports.
  

Provided functional analysis to assist business users in maximizing SQL reporting capabilities

• . I analyzed the results from usability tests, and document findings (i.e., end-to-end user experience, user workflows, specific UI screens and components).
  

• Experience in running usability tests
  

• Track and report status of deliverables on multiple key initiatives in excel.
  

• Performed automated reports generation.
  

• Performing roll out testing and productions
  

• Experience in business requirements and functional specifications development with business user interface.
  

Responsible for performing unit testing, integration testing, performance testing, functional testing, regression testing, scalability testing, client acceptance testing, user interface testing, batch process testing, and production support testing of these various software products

• Creation of adhoc and canned reports-
  

• Developed efficient SQL calls in applications.
  

• Access applications including screen creation and modifications.
  

• Heavy use of EXCEL 2007 as a work datasheet using VBA. The applications were a customer order calculator, an application to create bilingual orders using mail merge, and an application for human resource tracking. All of these used Excel in combination with VBA to automatically populate cells and rows in multiple datasheets as a department level database.
  

• Approved Process Validation Reports
  

• GUI and Screen design background
  

• Develop data collection strategies, tools and templates.
  

• Extract data from systems,
  

• Capable with complex queries using multi-table joins (inner, outer, and full) and use of scalar and columnar functions.
  

• Deliver reports to end users, receive feedback to finalize reports
  

Auditz Tampa, Florida 6/20/2011 - 7/22/2011 (Contract)
Consultant

• Used MS Access, Excel to create ad-hoc reporting and daily production reports and files
  

for client involved in health care advanced payer search and reimbursement.

Software Engineer/Systems Analyst using my diverse background in systems analysis and innovative software design to develop cost-effective solutions in a client/server computing environment.

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

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
Clarify, Business Objects,terradata sql assistant,
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

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

Language Skills: Oracle SQL, Visual Basic 6, C, C++(Visual 4.0), T-SQL, SQL Server 2000/2005, Access, Cobol 74/85, 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
Clarify, Business Objects,terradata sql assistant,DMSII
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.cnc,forklift,warehouse,machinist
Skills
Edit

Machining Steel, Stainless Steel, Aluminum, Cast Aluminum, Cast Iron,search arrays for strings, Parsing for strings,DBMS tools,Query analyzer ,MS Access client/server application development, Scrape Data,HTML Coding ,report generation, automation projects ,Data Conversion ,source control tools,GIF optimization, GIF animationTrack-it Work Order system, Development Tools,recovery tools,video uploading,video downloading,reindexing,institutional claims , testing criteria, defect reporting , file back-up , PM ,word processing software, spreadsheet software,database software,Test Case Matrix, Custom Entry Form,datagridview , issue log,Excel based VBA macro programming, SQL Programming, HP Digital Scanner , FrontPage/ Image Composer , spreadsheet applications,visual basic project, visual basic program, visual basic windows form, simple visual basic code, Implementation-Conversion Analyst , DB Triggers, Front-end/GUI,ole development,quotes systems for sales order,tags,taging,scaning,excel backend worksheets,access screens,data base recoveries,sql server recoveries,rss feeds,animation, image dimension, image file size, color palateMS Office/Excel/VBA Macros ,ODBC ,Query Analyzer, Data Reporting Analyst/Writer ,GUI Development, UI design, DML statements , aggregate functions ,JSON,PC workstations, Data Transformation Services, quickbooks,Medical Information Management , EBAY AUCTIONEER,Remedy Trouble Ticketing System,SQL query syntax, User Acceptance (UA) testing, VB (legacy) , eBay Lister , animated gig ,animated jpg,video/streaming ,Updating Twitter and Facebook profiles, broken tables,Microsoft SQL Server database engines,Microsoft Office suite,Access Database,Software Testing,Health Services,telephony ,HTML EDITING,Database Definitions,outbound calls,inbound calls,video capture,Cobol/mainframe , software design processes. Software Development ,multimedia files ,Social Networking,optimized queries ,record sets ,Relational Database Design ,cell referencing, Health Care Data Analyst,website design,relational database,social media,manufacturing,manufacting,light industal,video compression,Data Format/Claims,Spool file management,surface finishing.part masking,computer system analysts,oodbms,form fields,subheading,file processing,compresion,forms generation,referential integrity,object calls,vba buttons,Tuning Queries,Multiple platform,query analyzer,bat files,dll files,field to field conversions,VBA subroutines,text parsing,production report generation,table comparisons,exporting data in CSV,distributed applications,Object Oriented Development,Component based development,field definitions,billing system ,report changes, control file changes record identifiers,ActiveX Data Objects,inhouse applications, Test-driven development ,visual foxpro,system documentation,medical database,sql calls,health care payment systems,data Verification,Video editing/creation software,financial formulas,patient healthcare record,Conversion/Implementation,CALL CENTER TECHNOLOGY,REPORTS CREATION,REQUIREMENT GATHERING,events,object hierarchies.Excel collections,SIT and UAT Testing.file dumps,Testing methodologies,Functional testing.,Packages and Procedures,Data Conversion Analyst,report generation,spreadsheet design,APIs/Interfaces/Data conversions,report design,table design,form design,canned reports,Health Information Science ,link table,Project Management software,change ticket process,healthcare technology,checklists,sql optimization,database-driven applications,file transmissions,data transfer mapping, case tools,pos confiquration,backoffice,ms products,pc systems,POS Development,formatted spreadsheets,load scripts,Typography,Data Dictionary views,Schema Objects,oftware suites,ms paint,update software user manuals,maintain calendars, contact lists,rapid time to market,remote support,new technology introduction,large implementations,energy/utilities,issue-logs,database integrity tools,File manager applications,Ad-Hoc queries,time management,serif fonts,true type fonts,san serif fonts,concatenate joins,octal,modular code, IsPostBack,seo,Patient Accounting applications,Patient management ,source code control,scalability,open source,assemble,dataset,GUI prototypes, hot fixes,API,SOURCE CODE,VBA modules,DATA IMPORTS,DATA EXPORTS,text files,information extraction,validation techniques,consolidation ,data transfer, CPT, ICD-9, HCPCS, DRG coding,business object specificans,complex business processes,complex business specifications,healthcare insurance,go live support,automated reports,graphics/presentation software,insert query,adhoc reports,Programmer Analyst,ide,Microsoft Jet Database Engine,complex sql queries,pst,ost,automatic email messages,mail merge,forms and controls,filtering and sorting,relationships and joins,connecting to data sources,designing application,finding and filtering data,object oriented concepts,information technology and services,manual and automatic testing,Altova MapForce,averages,sums,counts,parent records,parameter queries,grouping functions,grouping,systems diagrams,computer technology,citrix server concepts,selects,terminal server,dupdate queries,video editing,MS Exchange,MS Active Directory,Enhancement Delivery,delivery timeframes,customer/vendor relationships,dynamic reports,external benchmarking,balancing system conversion,data conversions,internal benchmarking,cost benefit analyst,inhouse conversions,data aggregation,computerized physicians order entry,healthcare records,link tables,hospital/business conversion,healthcare information systems,normalization,distinct,sistinctrow,csv,compact/repair,imput validation,error trapping,error handling,pvcs,component model, custom controls,it/development,photoeditor,im,instant messaging,web page development tools,scanners,digital cameras,finance,multimedia,financial services,defrag,newspaper,columns,search engine optimization,pointers,scalable,plug and play,converguence,container,decision tree,prompt argument,buttons argument,sqlclr,flat files,tweak,sql assistant,teradata tools,mp4,mp3,multidimensional expression,service level agreement,sql common language,runtime,technology consuluting,database managment,FUNCTIONAL ELEMENTS,MPEG,CONTOL TABLES,INHERITANCE,RAM TABLE,FILE BASED TABLES,split testing,static content,query strings,check boxes,securities,reporting deliverables,windows remote desktop,Teradata SQL assistant,heat maps,sql scripts,system integration testing,sql optimization,data replication,gui design,data base developer,accounting,heat maps,data formats,data content,database programmer,headers,footers,balance sheet,records,files,emr,patients charges,insurance charges,callcenter,assets,debit,credit,liabilities,life insurance,database query methods,client acceptances process,Database Backup and Recovery,Linkage Testing,Combined Test,Conversion Methodologies,Turbo Tax,Healthcare Information Technology,Information Management,healthcare it,Healthcare Technology,Healthcare Compliance,Sr Business Consultant,Healthcare Analyst,billing Problem Resolution,vba excel programmer,vba access programmer,vba excel programmer,windows 7,open source coding,aqccess/automation script developer,work diagrams,vba coding,excel addins,query authoring,verifiable database architecture,database management,data acquistion,benchmarks,data sharing,dbms,datastores,data standards,benchmarks,relational database structures,merge records,ooad.custom codes,user support,transaction workflow documents,autosys automation,architecture review,icd-9,wrap,parameter queries,PIM,popup menu,relative cell references,source programs,status bar,styles,table relationships,referential integrity,primary/related table,parent/child relationship,nested if,text wrap,date/time formats,tracking,error trapping,subscripting,wildcards,handles,numeric formats,wrapping text,count function,summmarizing,grouping,data formats,table relationships,linked objects,autonumeric fields,foreign keys,formating commands,handles,numeric formats,wrappicd-9,unit testing,functional testing,conditional statements,append queries,autosave,dialog boxes,unbound controls,toggle buttons,forms,summarizing,database objects,data sources,drag and drop,dynasets,recordsets,enter button,labels,field names,cell references,option buttons,shopping cart,list boxes,radio buttons,combo boxes,fonts modification,vba excel color modification,line spacing modification,DOS command,DOS SHELL,data massaging,truncate tables,deployment,veritas backup exec,apply filters,data dictionary,images,videos,gui forms,database creation,physicians practice,doc,forms development,object models,object related hierarchy,pivot tables,operating systems,implements,compilers,control modules,clist,algorithm,slideshows,managed care,project,diagrams,system specification,technical design models,generation,matrixes,intranet,tables,development tools,job control language,libraries,computer information systems,source control,report triggers,software fixes,libaries,unpacking shipments,calculations,formulas,stocking,maintains,installs,pulls orders,balancing adjustments,regular expressions,mssql,data conversions,extract,transform,error resolution,data changes,data capture,claims,enrollment,screws,vms tools,table properties,access macro development,word headers,cell properties,dts packages,word footers,costom reports,documentation,code modifications,complex methods,Benefits/Cobra,Compliance,Diagnostic Tools,Regression Testing,mvs/jcl,project costing,travel and expense,mvs cobol,cics,Access Reports,Oracle Reports,Key,Process documentation,data sources,hospital billing,practice management billing,screen layout,visual design,windows services,windows applications,records,collections,sql coding,creation,migration,functionality docs,VSAM,change management,graphics,healthcare claims,olap,btrieve,clearcase,blackbox,one-to-one correspondence,forms collection,inprocess server,docmd shell, class modules,vba forms,command buttons,insurance,sw developer,social networking,software debugging,software design,software documentation,office programmer,delimiters,office automation,toad,office,electronic data processing,decimal,offset,sumifs,navigation buttons,automatic sorting,backend,api,client server,adhoc,oracle ddl,entity-relationship diagrams,language tools,defect resolution software,telecommunications,database definitions,screen creation,structured analysis,batch processing,pc,laptop,strings,bits,bytes,binary,hexadecimal,numeric,alphanumeric,ascending,descending,healthcare databases,ssis,row,advanced query writing,classes,application frameworks,service oriented architecture,index tuning,optimization techniques,sort,merge,mainframe,rolls,columns,cell,range,table structures,RADIO BOXES,DROP DOWN BOXES,Oracle 7i,Oracle 9i,Radio Boxes,Drop Down Boxes,Barcodes,Check boxes,Menus,Database Models,Indexes,Creating Tables,GUI Interfaces, Program Structures, Database Applications, UI Programming Skills,Tracking & Reporting,SQL Data Migrations,Database Repairs,Maintain Databases,Complex Formulas,SQL Enterprise Toolset,Outer Joins, Inner Joins,Cost Constraints,Data Extract,Process Analysis, Internet Explorer,Email,Database Definitions,Procedures,Continuous Improvement methods,Youtube,Electronic Payment Technology,Social Media,Medical Coding,ECommerce,Medical Insurance Coding,Banking,Object Oriented Design,Object Oriented Programming,Expressions,Unions,Parameter Passing,Dimensions,COM,Pallet Jack,Order Picker,Charts,Object Hierarchies,Hierarchies,Database Definitions,Cursor Processing,Medicare,Business Process Improvement,Data Modeling,Problem Solving,Operating Systems,Load Process,Aggregate Functions,Transact SQL,Troubleshoot,CMD shell,Object Oriented Code,hand tools,Data Handling,Database Applications,Billing Problem Resolution,Technical Specifications,Status Reports,Manual Test Scripts,Ruler,Automated Testing Tools,Updates with joins,SQL inserts,Complex SQL selects,Form Fields,Sub Headings,Index Functions,SQL Profiler,SQL Query Analyzer,SQL Utilities,Data Compaction/Expansion,Application Programmer,Interfaces.enhancements,IMS,Visual Basic Development Tools,Computer,Binary,Hexadecimal,Oil & Petroleum,Retail Systems,Test Strategies,Reports Generation,Report Design,Trace Process Requests,Time Reporting,Key Reports,Client Reporting,Billing,API,Interface/Feeds,DB Tables,MS Desktop Configuration,Automation,Batch Jobs,Database Administrator,SQL Query Development,Logic Flowcharts,Block Diagrams,Database Platforms,PNG,TARGA,HIPAA,Relational Data Modeling,Visual FoxPro,RAD,GUI Design,Health Services,PC,Laptop,Data Cleansing,OS Databases,MS ACCESS Development Tools,Crash Dump,Abend,Report Analyst,Code Analysis,Requirements Analysis,Code Revision,Data Extract,Consolidation,Manipulation,MS Office Tools,Standalone,Data Transformation,Intranet,Microsoft Office Software,Medical,Healthcare,gcode,bits,byte,micrometer,remote desktop,pc skills,SFTP,sql database programming,code design,database design,object oriented analysis,dev manager,software development life cycle,class libraries,visual basic 6,desktop operating systems,desktop applications,teradata sql,teradata utilities,relational database,automated test scripts,verification and validation,ppt,subqueries,business object developer,systems analyst/report writer/programmer,grinders,blueprints,sql database software,design software,development software,point of sales,intgration testing,functional testing,ms sql server,ms office suite,data requests,Array,Subroutines,Subset,Drill Press,Loop,XLS,RTF,TXT,MDB,VBP,DOC,WPD,TIFF,BYTE,Loans,Deposits,Access methods,Validation checks,Senior Programmer,VB6,VBA/Excel Specialist,Purchase Orders,Sheet Metal,Receiving,Shipping,CVS,Architecture,SQL Server Reporting Services,IT Software Development,Adobe Photoshop,Constraints,Parameters,Financial Services,In-house Applications,Reuseable Code,Process Flow,Screen Flow,Order Number,Tracking Numbers,Components,IMS,Related Objects,McAfee,Toolset,MS SQL Server Management Studio,AOL,Notepad,WordPad,WinZip,Visual Design,Word Processing Software,Information Services,OO analysis,OO design,OO programming, weblogic,database design,database backup and recovery,business intelligence tools,scripts,database functions,drill down data,process tracking,drill press,load testing,install,access performance,monitor,data storage,file systems,optical media,table layouts,materialized view,dimensional cubes,modeling,gui forms,load data,microsoft office,upgrades,spreadsheet development,data communications,ms office products,fixes,data extraction,vbscript,oledb,COM,data integration,application integration,lists,query writing,legacy,scalable queries,batch application,interactive application,SQL/DB,Sun/Solaris,tool and die,lathe,mill,forklift,cherry picker,entity relationshops,subsetting solutions,vendor tools,PLC/SDLC,json,object code,source code,test plans,test cases,test scripts,user forms,workbooks,object code libraries,configuration management,index consistency,pointer consistency,indexes,conditional statements,statistical formula,busines intelligence developer,application connectivity,data consultant,sql graphing,data aggregation,adjoin tables,sql database developer,integration services,datawarehouse developer,reporting services,sql 2008 programmer analyst,modify databases, wysiwyg,visual basic 6 development,it/software development,sql database developer,sr application programmer,transactional,sql database developer,ooad,dimensional database design,ide tools,technical business analyst,structed query language,object oriented development,data analyst,case diagrams,transact sql,conversion methodologies,implementation/support,sr business consultant,healthcare analyst,home healthcare,logical data modeling,OOP,VS source control,data migration,deposits,twitter,facebook,sdk,data structures,multimedia,rfp,web browsers,web editors,information technology,packages,structured programming,pervasive data integrator tool,pervasive mapping,sheet metal.,hot backups,internet protocols,toad,customization,workflow,user interface,lifecycle,data quality,intranet,debugging tools,regression testing,combined test,linkage testing,compiler,relational database,database management,sheet metal,development tools,test tools,case tools,billing systems,physician billing,insurance billing,healthcare compliance,healthcare it,healthcare technology,healthcare information technology,youtube,cnc,design and creating data models,odbc connectivity,sw,front page,jcl,Visual Basic Developmen,graphic design,web applications,echnical developer,snagit embedded sql,sql plus,sql tuning,aplication development,sql/net programing,database recovery,project planning,software project management,sql databasse design,partitioning,enterprise manager,grid control,msde,PhotoExplosion, PhotoExplorer, Paintshop Pro,ebay,retouch,rending,busines analyst,act web pages,equities,stocks,bonds,splice,project management,javascript,machinist,cnc,restaurant,forklift,retail,Software Design,DAO,IDE,sap crystal reports,functional requirements,regression testing,dialogues,gui interfaces,databasee interfaces,toolbars ,menu,data access,table maintenance codes,database parameters,masterfiles,profile,excel addins,teradata sql,report software,cusor,computer,sdlc,data reporting,equity,sdlc,grouped lists,ide tools,fileaid,technical initatives and strategries,health services,legacy systems,database systems,microsoft, tools,data transformation,quicken,quickbook,store front,medical records,middleware,helpdesk,ecommerce,reorganize,database triggers,data anaysis,intrability,digitizing and conversion of video files,third party objects,third party tools,object oriented analysis,technical,concumer banking,middleware,data processing flow,quicktime,nix shell scripting,migration using data loads,data integrity,resolve data issues,utilty companies,grouping,ordering,sql file backup,data cleaning,reporting tools,powe plants,business strategies, mission critical,report writer,record structures, reports, developer tools, usability tesing, multiple platform,taxation and appraisal systems,POWER TRADING,consumer loan reporting system,FOXBASE,branch automation system,convenience store and gas-station industry,DATA MODELING,storefront,software engineering,workmen's comp,access table,sun solaris,progress sql,shopping cart,small scale projects,appointment scheduler,conversion,data structure,practice management,clinical management systems,conversions,peer to peer,standalone,object hierarchies,if statements,secondary keys,functionl requirements,complex software build solutions,vax,excel applications with ado record set,mouse events,parameters,path,control properties,target,word wrap,cel references,datasheet,reps,calendaring functions,event handlers,tags,frames,flv files,large scale project,datawarehouse,sw,dw,presentations,append,cpu,checks and balances,realtime,bi,corel,create table,timelines,tween,operating,systems,senior,conditional fomating,ms dos,remote work,time tables,software development,access macros,transformation,rockwell,youtube channels,encoding,vb,visual studio 2008,sw,remote work,time tables,software development,concatenate,access macros,conditional formating,ms dos,MAINFRAME,PC,COMPUTER,MAX FUNCTION,MIN FUNCTION,AVERAGE FUNCTION,RIGHT FUNCTION,LEFT FUNCTION,DATE AND TIME FUNCTION,COUNT FUNCTION,MAX FUNCTION,SUM FUNCTION,DATA FUNCTION,STATISTICAL FUNCTION,math function,date function,text function,sum function,data function,statistical function,relative cell,ranges,crash dumps,autofill,excel functions,vlookup,youtube channels,encoding,extract,tract,transformation,rockwell,calculated fields,,jpg,gif,health care delivery,command line execution,crop,calculated items,mid,data validation,video clip editing,purge,code review,modeler,parsers,dynamic vba script,web applications,parsers,scanner,ansi sql,block diagrams,logic flowcharts,confiquration options,timelines,implementing staging,healthcare delivery,filtering,search engine,wordperfect,managed care,icons,developmet design,is,web designer,process improvement,bo,novell,translate business requirement,os,clarion,scripting solutions,best practices,WEB PROGRAMING,CONSULTANT,Architect,patient records,practice mangement,thumbnails,hyperlinks,ms works.,analyst,desktop,homehealth,pixels,data center,quality assurance,mockup,tester,defect database.technologist,database tuning,query tuning,complex data relationship,sq lassistant,revisions, word processing,calendar control,vpn,net programming,prototypes,screen layout,visual design,multiple platforms,end to end user experience,large scale project.,db,visual studio 2010,visual studio,metrics, 2008,visual studio 2005,tab delimited,multi table queries,access db,sql erver db,teradata db,subqueries,rollouts,hl7 format,clearcase,software detailed design,laptop,milestone tracking,defact tracking,sql query writing,web graphics,table outlook,text parsing,linked tables,text parsing,access ui,outlook ui,sql server ui,message queues,excel ui,parsing,text parsing,it project methodologies,macros,information architect,vb6,db design,index design,sdlc,graphics,internet,server,,bookmarks,mail merge,links,bullets,pdf,incremental conversions,rapid delivery,data audits,data reconciliation,conversion mapping,subsystems,distributed appliations,dao,functional unit,protocols,validations,,terradata utilities,fast export,regression testing,unix platforms,vba access,vba word,vba excel,asp.net,sql reporting,reporting services,snagit,processflow,addins,vb.net,vpn,rdp,asp.net ajax.,ole,cnc programing,multiple table joins,data extractions,windows 7,office 2007,oracle,terradata,list merge/purge,libraries,backend developer,visual basic,database,foxpro,ms office,visual studio,cobol,vba,sql.Office Suites: MS Office for Windows 95 and MS Office 97, 2000,2003 Corel WordPerfect Office, Windows Me, XP, Vista,Excel, Powerpoint, Word Internet Skills: HTML, CGI, Perl, Java Script, Java, XML, Frontpage, Micrographx Suite, CD/DVD 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,vista, 98, NT, XP, 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, Clarify, Business Objects, SQL Server Enterprise Manager(2000/2005), T-SQL, MySQL, SQL-Express 2005, Paradox, DBaseIV, Crystal Reports,Visual Foxpro, Physical data modeling 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, MS-Project, Visio, Norton PcAnywhere, Active Directory, Remote Desktop, WinFTP, Cisco Web-Ex (meetings/data transfers),active directory,remote desktop Mainframe: Easytrieve, Roscoe, Focus, Intertest, Librarian,Language Skills: Oracle SQL, Visual Basic 6, C, C++(Visual 4.0), T-SQL, SQL Server 2000/2005/2008, Access, Cobol, Visual Studio, Visual Studio.Net, VSS, Olap,ODBC drivers/connections, vba, n-tier, multi-tiered, Oledb, RDO, ADO, COM, MS Access(97/2000/2003/2005), Paradox(DOS), Schemas, RDBMS,Triggers/ Stored Procedures, PLSQL, OLTP, OOD, SQL Server Enterprise Manager Studio, Oracle 9i, Clearcase, Magic, SourceSafe, DTS Imports, SQL Scripting, API, Pervasive Map Designer,Active directory Municipal bonds, equities, mutual funds,3270 emulations,newspaper circulation software,data transfer;bead blasting,surface finishing,Computer Information Systems, electronic mail, legacy code integration, acceptance, end-to-end, user interface specifications, application programming ,Knowledge of video distribution formats,Desktop Applications Development,Video clips ,Video editing,Quality Assurance,Test Scripts,CPT codes,Database query methods,Scrubs and edits ,HTML coding ,MS SQL EXPRESS,shipping,receiving,file conversion,compression, downloading/ uploads videos,Matrix'sre-indexing, integrity checking, database shrinking,image dimension, image file size,google Maps,DBMS tools , Database Management Systems, time tracking tools ,defect tracking/issue tracking software, rar

I have been programming software for 36 years in the Medical, Govt, Banking sectors using Mainframes and small systems. I have coded using Visual Basic, Access, VBA, SQL Server and have finished many important projects for companies in Tampa Bay.