Back significant consulting projects:  
   

Franklin van Splunteren
Coral Gables, FL
305-774-7601

 

October 2005- December 2006

Johnson & Johnson

Cordis Cardiovascular Division

Access, Oracle, AS400, Siebel, Javascript

Team Lead

  • Rewrite of corporate Complaint & Return system and Statistics MTS.

  • Design & implement corporate Hospital & Consignment inventory system

  • Uses Access VBA front ends to implement business rules on Oracle, Siebel and AS400 back-ends.

  • Prepare technical & user documentation for Access sub systems

 

January 2004- August 2005

University of Miami - Psychiatry

Access, SQL Server 2000, ASP, ASP.NET, Excel, Javascript

Analyst/Consultant

  • Architected and implemented NIH Grant Disbursement Charting system for the Department of Psychiatry.

  • Design, analysis and coding of ASP based internet Charting module and ASP.NET control panel.

  • Design, analysis and coding of NIH Grant Disbursement accounting system.

 

2003-2005

Bascom Palmer Eye Institute - Florida Lions Eye Bank

Access, ASP

Consultant

  • Completely redesigned the existing Tissue Bank system, consisting of donor, recipient and tissue distribution.

  • Designed and added the orders and invoicing system

  • Initiated the specular microscope interface and online account information.

  

2003–2004

Segutronic International

COM, ASP, Access, VBA, Javascript
Consultant

  • Design, analysis and coding of Sales follow up system in distributed offices

  • Design and coding of add-on modules

 2002

Schering-Plough Pharmaceuticals

Access, VBA
Team Lead

  • Design, analysis and coding of the FDA mandated training matrix program.

This system enables the company to track the training level and certification status of all personnel, very important since every worker in a pharmaceutical company must be trained and certified for a number of tasks, as mandated by federal law.

 

2001-2002

Old School Square  museum, theatre and cultural center.

Automation, Access, VBA
Consultant

  • Rewrote an existing membership and subscription system

  • Added a donation and classes subsystem

 

2000-2001

RV Add-Ons 

SQL Server 7, ASP 3.0, Access, Javascript
Software Project Manager

  • Converted a static HTML website into a dynamic eCommerce website.

 

1996-2001

University of Miami - Psychiatry Research   publication details

Access, ASP, SQL Server 6.5, SPSS, SAS, Informix, Javascript
Software Project Manager

  • Investigator/Consultant for a large, NIH funded, multi site research project linking HIV with psycho physiological factors required the tracking of a large numbers of measures (both questionnaires and lab data) for the project population  in order to statistically verify the presence of significant differences between control groups and groups undergoing stress  related treatments.

  • Design, analysis and coding of a multisite networked questionnaire control system               

1993

International Profit Associates ,Chicago (Management Consulting)
Sr. Business Analyst

  • Sr. Business Analyst-Consultant for IPA, a business development group and general management consulting firm focused on small and medium-size privately-held companies in North America.

  • Visited one to two small to medium size businesses a week in cities across the US to analyze  their financial status, give presentations and generally lay the groundwork for further consulting work by IPA.

 

1990

Inacomp Computer Centers , Troy  MI
Software Project Manager
dbII

  • Design, analysis and coding of multisite Computer Rental Purchase Order system between corporate and the rental centers.

 

1982-1983

General Electric Caracas (Business Consulting)

  • My consulting firm in Caracas was contracted to install and maintain MARK III telecommunications and printing equipment for GE nationwide in Venezuela, train technicians in the US, etc.

           

1981-1985

Petroleos de Venezuela (PDVSA) (IT/Finance Consulting)
x86 assembly, Fortran
 Software Project Manager

  • My consulting firm in Caracas installed and maintained hardware for the Maraven Finance department.

  • Design, analysis and coding of Financial control and bank transfer system

  • Design, analysis and coding of voice controlled equipment.

 

1981-1984

National Shipping Line CAVN Caracas (IT/Finance Consulting)
CPM basic
Consultant

  • My consulting firm in Caracas installed and maintained hardware for CAVN.

  • Analysis and coding to digitize the company credit union

  •  Analysis and design of  ship mounted hardware and software solutions.