TECHNICAL TRAINING NONE

SPECIAL QUALIFICATIONS

• Over 25 years experience in logical design, system analysis, training, design, and maintenance of financial and healthcare processing systems. Extensive experience in the design, development, implementation, maintenance and configuration of database software on PC based systems directly supporting the management of various private companies in the financial, health care and general services fields.
• Over 20 years experience in Microsoft database products beginning with Access 2.0. 18 years experience with MS-SQL products beginning with MS-SQL 6.5 in 1995.
• 20 years experience in the use of various database design tools for entity relationship design ERD , structured query language SQL and stored procedure development including CA ERWin, Sybase DataArchitect, Datanamic Dezign and SilverRun ER modeling. Developed small to large scale projects ranging in size to millions of records and hundreds of tables, queries and stored procedures.
• 20 years experience in database reporting using a variety of reporting tool such as Crystal Reports, Fast Reports and MS-Access report writer. Developed hundreds of custom internal management reports.
• 18 years experience with custom computerized accounting system development including order entry, customer tracking. accounts receivable / payable, general ledger and inventory control.
• 14 years experience in Microsoft VB/VBA development.
• 10 years experience in Borland Delphi development used in a global reach application with hundreds of full time remote users utilizing TCP/IP.
• 2 years experience with proprietary voice-over-IP VOIP systems using Linux with internet protocol IP private branch exchange PBXs , VoIP gateways, call center automatic call distribution ACDs and interactive voice response IVR systems and an embedded MYSQL database backend.

HARDWARE

• PC Based servers
• Operating Systems Network Tools Spreadsheet Presentation
• CPM 2.2 HP OpenView Excel 5.0 PowerPoint
• DR-DOS Excel 2003 Visio
• DOS 3.1/4.0 Excel 2007
• WIN NT 4.0
• WIN2K/ WINXP
• Vista
• Win 7
• MS Server NT4.0/2000/2003
• Linux

Applications Languages

• Exchange 2003 Pascal / Delphi 3.0, 4.0, 5.0, 6.0
• MS Office 2000/2003/2005/2007/2010 Visual Basic
• Alpha Four Five
• dBase
• Transact SQL
• VBScript

Databases Design Tools

• MS-SQL 6.5, 7, 2000, 2005 and 2008 CA ERWin
• MS-Access Sybase DataArchitect
• Borland Interbase Firebird Datanamic Dezign
• ANSI SQL SilverRun ER modeling
• dBase
• FoxPro
• ASTA N-tier
• MYSQL

SPECIFIC WORK / TASK EXPERIENCE

SUMMARY

I am a flexible and committed architect and senior developer. I am eager to learn new skills and competencies. I am passionate about what I do, the applications I develop, and the solutions I architect. I am an enthusiastic team player and strive to contribute best practice standards and compliant approaches always. I enjoy the challenge of setting and achieving high goals through a hands-off, leadership approach, trust in one's colleagues, open communication, quality control and division of work by interests and ability. I enjoy the challenge of explaining solutions to non-technical users, wholly and in an accessible way. I am technically proficient with an eye on the larger picture.

SQL/Access Developer

Confidential

Lead SQL developer on short term assignment to create/build a data base for internal statistical analysis of corporate wide marketing data using Access 2010, Excel 2010. System consisted of 60 tables and data migration/acquisition processes.

SQL Developer Secret Clearance

Confidential

• Lead SQL developer on short term contract for theater logistical management system which tracked thousands of distinct data points on Google Earth using SQL Server, Visual Studio, MS-Access, SharePoint 2010, and Google Maps. Light SSIS development for data acquisition.
• Responsible for development of SQL databases, stored procedures, data migration and acquisition. Developed internal management reports using SSRS.

Outside Consultant

Confidential

Researched, designed and built mid scale remote SQL server application supporting hundreds of remote TCP based clients utilizing the Delphi / ASTA transaction gateway. System supports 100,000 in transactions daily. Extensive development in Delphi, MS-Access and SQL server conversions. Specified, procured, and lead the installation of upgraded hardware including server. Developed daily integration with 3rd party payment processors. Wrote end-user documentation manual and on-line help. Provided daily and weekly management level briefings to senior management / owners. Managed 3 offshore developers.

Owner/President

Confidential

Researched, designed and procured all server and workstation hardware,T1 interfaces, CSU/DSU and Asterisk LINUX server. Responsible for initiating TI voice service for 48 workstations. Enhanced order entry program to work for call center application. Responsible for day-to-day operations of business hiring, scheduling, management and payroll for approximately 15 employees.

Outside Consultant

Confidential

Designed and Developed Delphi 6 / ADO / MS SQL statistical analysis data collection and reporting system with over 2000 discrete data fields. Liaised with customer from initial requirement specification, through full functional specification, pre and post delivery testing, and post release support. Wrote end-user documentation. Developed all internal SQL queries, stored procedures and functions.

IT Director

Confidential

• Developed PC to Mainframe to PC interface for ACH payment processing.
• E-commerce financial processing
• Principal architect of 50 Million annual SQL E-commerce financial processing system for check and credit card charges. Increased throughput from 3 Million annual to 50 Million annual, while reducing labor overhead by a factor of 10. Management of IT critical path engineering and development. Responsible for local area network LAN , wide area network WAN and storage area network SAN management. Brought in the company's first MSSQL server to replace aging DBASE/ FoxPro environment. Responsible for SQL integration with in-house built call center application. Managed a team of 5 developers and network engineering staff. Responsible for day to day running of the department scheduling, progress tracking, problem solving. Provided daily and weekly management level briefings to senior management / owners.

Outside Consultant

Confidential

Developed internal property/project tracking system in Access requiring a dashboard like status report showing over 100 data fields. Designed and developed forms for use in property administration. I was involved from inception through installation and provided customer support during rollout. System used internally for 12 years to manage 900 million in property acquisitions as well as monthly property management support.

Outside Consultant

Confidential

Long term consulting contract with 300 patient per day emergency medical facility. Designed and implemented a multi-user drug screen reporting and occupational health billing system using Access and Delphi, allowing non-computer savvy users to input billing information and create reports simply and quickly. Wrote user-friendly documentation and manuals. Managed mid-size Novell network. Recovered over 300,000.00 in unbilled charges and all system data from failed previous medical billing system.

Outside Consultant

• Projects during this period included:
• Designed and developed a large-scale multilevel commissioning system for IDT, a local long distance re-seller using MS-Access The quality and system enhancements of the data base made the commissioning process more transparent, easier to manage, and introduced a greater level of control.
• Designed and developed a truck brokering system in Access for a local truck broker. Requirements included tracking hundreds of vehicles acquired and resold requiring maintaining data bases on multiple servers. When development was finished, I wrote and delivered user-friendly system documentation and stayed on to support the customer during rollout
• Designed, developed and lead installation of over 10 Novell and Windows networks.
• Liaised with customers from initial requirement specification, through full functional specification, pre and post delivery testing, and post release support. Prepared and presented various proposals and recommendations.