VisualCV

Programming & Project Management

Developed Rich Internet Application tools to mine data from PSQL and MSSQL databases via ODBC using PHP5, XHTML, HTML5, CSS, Ajax, unobtrusive JavaScript (jQuery / Ext JS), and web standards, which allow users to mine two ERP systems, GoldMine CRM and CAPA (corrective actions) data systems via the company Intranet and secure Internet. Users realized increased productivity and company saved money that would have been required to purchase more ERP licenses.

Lead project that created a company training records system and a medical equipment service tracking program. Lead project to upgrade company to a new CRM system and integrate it with existing ERP system. Currently spearheading an effort to expanded e-commerce and data sharing applications for external customers (researchers, doctors and hospitals) in accordance with web standards and industry security directives (HIPAA). 

ERP and CRM software systems analysis

As internal consultant for the company, I  administered the mission-critical ERP and CRM software systems (implementation, updates, optimization, and training) for the IT department.

Quality Systems (ISO 9000, FDA, ETL SEMKO) process development and review committee

As a member of the quality systems review committee, I provided guidance on all corrective action review notifications where the subject matter touched on processes in the Manufacturing, Materials, and IT departments.

Creating data mining software and data driven web sites. These projects range from small eCommerce sites done pro bono, to local commercial web sites, to an open-source data mining application for EvoERP built with PHP5, standard SQL, HTML5 and jQuery. I also serve as a BPR coach for small manufacturing businesses.

eCommerce Development with Java Servlets / XML / XSQL / XSLT
Consultant for development of an online sign-up and bill paying system for student residential services, such as telephone, cable TV, pagers and cellular phone and airtime. Using Oracle 8i and WebSphere Application Server, provided a dynamic web application for over 10,000 authenticated users. Used XSQL to retrieve student and service data into XML files to dynamically deliver secure web pages via XSLT processing.

The project was intended to serve between thirty and fifty percent of the incoming class. Actual results were that eighty percent of the resident students signed up for services online and the application performed very well and scaled as needed with no down time during the crunch leading up to student arrival.

Application Analysis and Documentation
Performed design and modeling of applications based on rudimentary user specifications. Developed Use Case, Data Flow and Sequence diagrams with modeling tools using the UML and Object Oriented Design methods. Wrote the required developer documentation and testing guidelines and provided a simplistic bug tracking system in an MS Access app.

Java / XML Product Internationalization (I18n)
Consultant for Level 2 and Level 3 I18n of SiteLoad product. Modified Java Servlet-based website load testing software to accept non-ascii character encodings, including double-byte (Unicode) character sets, such as Japanese (Shift-JIS). Developed Use Cases into specifications for full i18n of product and provided guidance to development team on creating and maintaining an international product.

Development of an XML Viewer in Java 2 Swing
Planning and development of a cross-browser, cross-platform Java applet to be a replacement for their ActiveX viewer. I was the first Java developer in a VB development environment. The viewer was the first step as the company began its move away from 100% MS environment into Java, Linux, Oracle and XML technologies to broaden the market for their portal product, Report2Web. Development highlights include JavaServer Pages interaction option vice ASP, dynamic XML creation via ASP or JSP calls, and extensive use of the Java text package for viewing and manipulating XML data reports.

Developed Downport.com web site (1200+ pages, 8000+ user sessions monthly)
Went from 0 to over 1200 pages of RPG support content. Site developed using HTML 4.0, JavaScript, Java, Apache SSI, and CGI components. The site received 54,430 page views in 11,158 user sessions from 4211 unique users in April 2000. Layout and testing was done in three different browsers, on two platforms and with three monitor resolutions to ensure usability for visitors. All development was done in TextPad and EditPlus text editors. In 2003 I consulted with them on a move to XHTML and CSS. 

To help make the Downport.com site self-supporting, I developed a book and  game e-commerce area with PayPal credit card processing using PHP4 and MySQL. Proceeds paid hosting costs and consulting fees for Downport.com and affiliated sites. The single site grew to a family of related sites, about a dozen of which still operate as of 2011.