PROFESSIONAL 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

Confidential

Senior consultant

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

Confidential

• Performed 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 a 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.