Summary

• 20 years of experience with a broad background in software, hardware, and operating systems.
• Appreciated as an integration expert, able to gather, analyze and translate project technical requirements into solutions.
• More than 15 years of experience writing applications utilizing Delphi versions 2.0 through XE2.
• Strengths in systems design, including hardware, data and program design, and implementation, database access and data movement. Knowledge of a diverse set of technologies gained from years of integrating disparate components into cohesive systems.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Computer consulting and software programming firm serving business and government offices providing a wide range of expertise and support for office automation challenges involving management of personnel, changing of processes to support automation, system determination, system configuration, training, and support. As a separate focus, develop specialized software operations for medium size database processes, and develop unique applications for specialized government operations.

Selected Projects: Confidential

Update of accounting applications to current standards from large backlog of changes and requests. Extraction and loading of data from external sources to SQL database for client initializations. Update of code from Delphi 2009 to XE2. Development of SQL changes process to server farm. Delphi 2009, XE2 and MS SQL 2005, 2008, 2012.

Confidential

Perform updates and additions to the corporate clinic software distributed to 2500 clinics. Supported daily data operations and corrections. Delphi 2009 and MS SQL 2008.

Confidential

Perform updates and additions to the corporate web and back-office operations by adding features to the user capabilities and creating applications and SQL processes to support these new capabilities. In addition, the work encompassed a number of change requests, a queue manager project to accept and process data from multiple sources for the immediate transmission of data to the end users, and an upgrade to the in-house deployment builder application. Delphi 7, DLL for Web services, with templates, XML data flow, multi-threaded queuing system and FTP transport.

Confidential

Provide support for existing Delphi applications, these are applications that provide in house support and corporate specific operations to the Dell Xcelys Medicare-Medicaid Member Processing system. This work moved into converting all of the 30 applications into C /.Net web applications. The environment included Oracle 9 and 11, Delphi 4, TOAD, Visual Studio 2005, Crystal 10.5, dBase IV, MYSQL, IIS 7/7.5 on 32 and 64bit servers.

Confidential

Upgrade code set from Delphi 2006 to Delphi 2010. A team of 4 staff employees with three consultants were tasked to perform the upgrade, with the target umbrella platform to be the Microsoft Internet Explorer versions 6, 7, and 8. The code set was approximately 800K lines of code, interfacing to a mid-tier COM/DCOM set of objects part of the code set , supported by an IBM mainframe DB2 database. The source for third-party components was available, and was in addition to the base code set two of the several component builders were no longer in business . Quick Reports and IBM 3270 terminal emulation were part of the final product build. Of the team, only three, myself, one contractor, and one staff member, were the Delphi code producers, while the others performed other tasks such as installation builds, ASP interfaces, and database enhancements. The primary effort was completed in four months, with testing consuming the balance of the eight month project. The target distribution was approximately 35,000 users into several of the major banks of the United States. Delphi 2010 DB2, COM, Middleware,

Confidential

• Developed software to administer the office back-room operations for DataMax Marketing Systems.
• Identified and developed processes to handle varied operations necessary to support the continuous flow of sales initiatives, support operations, and daily management of the business. Integration included data movement between multiple MSSQL and MySQL databases, email functionality, course scheduling, and web-base store operations.
• Developed pseudo-automatic generation of agent web sites with agent access to base level site management, and a corporate sales site web-based store .

Confidential

Developed a software prospect generation system, with associated processes for internet access, data movement, multi-office data management, and sales force oversight, the system used MSDE SQL for local data storage, with transmission to corporate SQL database for overall management of outside offices and total agent support and productivity.

Confidential

• Converted comparative results from medical laboratory equipment from a previous format to a new format for ongoing storage and statistical analysis.
• Project responsibilities consisted of a project management, acting as a client liaison, a laboratory test expert and a programmer.
• Converted approximately 700K records into the new format based upon an Oracle database.

Confidential

• Created a specialized multi-site Medical Point of Sale program, connecting back to a centralized data storage site via extranet interconnection.
• The central site processed and separated data as either private/medical data or transactional/accounting data, and performed both fulfillment and administration operations and interfaced to the web-host functions of FedEx, UPS, and AuthorizeNet/IPayment for transactional processing and shipping.
• The connection protocols were done via COM/DCOM and XML, over TCP/IP, with Microsoft SQL database.
• Total development was in excess of 100K lines Delphi v6/7 and 50K lines SQL, on MS SQL 2000.

Confidential

Used Delphi as a TCP/IP receiver to capture traffic packets on the radio controller LAN and store them onto an SQL server for analysis. The project consisted of two parts: the packet receiver and storage module, and the reporting module. The packets were UDP data broadcast on the radio controller LAN and were trapped in real-time mode. From this data the reporting module would generate several types of graphical and text output in real-time that would depict traffic patterns, device usage data department, user , traffic bottlenecks, device failure occurrences, and other management information to help proactively manage the radio system. The system is still growing, but currently has over 5000 devices on the radio network, covering the entire county, including three cities and over 12 separate agencies. The data is expanding 4M records per month, and currently holds 90M transmissions 350M records online 2009 spanning eight years. Development was initially in Delphi 4, and upgraded to 7. The database is MS SQL 6.5 converting up to 2000 and then to 2005.

Confidential

• Designed and developed a data transport system to provide data movement between several hundred outside agencies and the mainframe-processing component of the organization. The system included movement of data via FTP, SMTP/e-mail, CompuServe Dial-up, and several internal intranet sites, moving it to a DB2 database. The data was user protected and optionally encrypted during the movement. An administration system coordinated users, authorized movement, authorized processing and encryption operations and tracked the movement of data from each agency. The transport system typically handled several hundred operations daily, both incoming and outgoing, each of which was typically several hundred megabytes in size. Due to the type of data, the system was built to handle transactions in the multi-gigabyte capacity, which happened several times per month. Development was in Delphi 5 and the dataset is DB2.
• Confidential Supervisor of IT Special Projects and Computer Aided Mass Appraisal Programmer/Analyst
• Property appraisal office with 100-120 employees producing annual appraisals covering 450,000 properties and 130,000 businesses for tax revenue generation.
• Recruited to oversee the conversion of a major set of programs and data from a mainframe to a PC environment and to manage continual development, support and operations.
• Managed daily operations, network configuration and server systems build/maintenance/operations.
• Developed SQL databases and deployed software.
• Managed coding for approximately 1/3 of the code set for the move.
• Member of a team of four that moved the entire appraisal operation from IBM mainframe to PC-based servers and rewrote the entire code set for operating a state mass-appraisal system.
• Rewrote major changes into the code set accommodating major additional exemptions, levees, and additional local and state changes to the tax code.
• Responsible for about 85 of the code set after major revisions on the state and local tax codes.
• Performed Y2K conversions
• Developed a data and asset tracking as well as processing system which was designed for the communications division to cover the change over and servicing of the new 800MHz radio system. It took about 1.5 years to develop and was completely written in Delphi. The back-end is on MS-SQL and has 30K lines of support SQL for data operations. This was a high-standard inventory control system, but included event-based maintenance, damage control reporting, multi-level components, integrated bar-coding, property-control responsibility settings, user-defined attributes, and manager operations. Some special aspects of this system include internal interfaces into Crystal low-level calls, NT Services to handle special data upload/download, and multi-level secured access. The application was developed in Delphi 7. The database is MS SQL 6.5 converting up to 2000 and then to 2005.

Confidential

Communications Engineer Network Services Manager

• Division of Lee County, Florida with 1200-2100 employees who were handling county radio operations, data voice, county-wide cellular/cable franchise contracts E911 operations, and EOC dispatching for all emergency medical and 20 fire agencies.
• Served in a combination hands-on/management position, hired to coordinate all computerized operations for the Emergency Operations Center and E911 dispatching and later for the County Data and Voice networks.
• Provided for daily operational maintenance, new construction installation, associated data systems, server systems coordination, for all telephone and data operations for the County crossing boundaries of all of the County department and 5 State operations, and connecting networking systems to these agencies across the County.
• Upgraded the county network with over 2500 devices from a sporadic operation into a dependable one, with little or no funding employing up to 7 direct reports
• Served as county liaison for the first ever graphically-based Computer Aided Dispatching Intergraph Corporation while the system was developed and implemented, with direct work on the RFP, development, installation, maintenance, and daily operations.
• Upgraded a marginally functional county-wide network experiencing a major failure per week and a minor failure per day to one of a minor failure per month and a major failure per four months.