John J. Shi's Home Page

{home}
General: {resume} {publications & presentations}
Experience: {software & web} {teaching}
Research channels: {knowledge engineering} {product process} {supply chain} {health care & biomedical}

John J. Shi's Software PORTFOLIO

Software development is not merely fun; for me it will also be a philosophy, a science comprising logic, ethics, aesthetics, metaphysics, and epistemology.

Eating a turkey leg is a system engineering; so does developing a software product.

Education & Training

  • Industrial & Manufacturing Engineering
  • Computer Certificates (MCSD)

Software Projects & Applications

Assembly Process Drawing

In 1995, I studied and implemented methodologies of automatic generation of the assembly drawing; developed the deliverable system using AutoCAD’s AutoLisp, C/C++. The system has been testified and well used in Nanjing Machine Tools Factory of Jiangsu Province, China.

[>>> go back to the top >>>]

CAPP/NCP

In 1996/7, I developed a typical rule-based expert system that was able to generate manufacturing process plans and produce NC codes that are used in machine center to fabricate the product. The system has been implemented in the factory for three kinds of NC machine systems of Siemens 880/840 and A950.

[>>> go back to the top >>>]

Software Development in Factories

  • 1995 - Wuxi Machine Tools Factory of Jiangsu Province
  • 1996 - Nanjing Machine Tools Factory of Jiangsu Province

[>>> go back to the top >>>]

AI Applications in Ergonomics Study

  • Survey 217 workers to determine what constitutes a demanding lifting job from a worker standpoint
  • Duplication and consistency analysis to reduce the amount of data without losing useful information.
  • Extract useful intelligent IF-THEN rules
  • Rank seven lifting task parameters according to inconsistency checking

[>>> go back to the top >>>]

Lorain Tubular Yield Prediction

  • Date: 10/2002 ~ 01/2003

I developed a analytic model and a software tool to predict the "yield" from the mill and generate simple rules for better understanding of the process involved: managed a research student to collect data from Lorain Tubular; used statistical analysis such as hypothesis testing of different "plugs" and regression analysis of "yield"; ranked parameters by significance based on the statistic results; and built a neural network model for prediction. http://www.eng.uc.edu/icams/research/lt/

[>>> go back to the top >>>]

Condition-based Maintenance

 

[>>> go back to the top >>>]

Adaptive Knowledge Discovery

This ambitious project of "Adaptive Knowledge Discovery" was proposed by Professor Samuel H. Huang and mainly managed by Mr. J. Shi (11/2002 ~ 01/2003). Three students are involved to design, develop, and test a creative and stable software tool, which could finally enable the knowledge discovery as soon as the industry case data is given. The components in format of DLL are being developed using Visual C++, including normalization, discretization (Chi2), dimensionality reduction (based on statistics), neural network modeling, rule extraction from decision tree and clustering, AMFM rule tuning (Adaptive Mamdani Fuzzy Model), as well as rule base pruning.

Decision tree

  • ID3, C4.5, etc.
  • Chi2 statistic test

Clustering

  • Subtractive Clustering
  • Two linguistic terms that are not statistically different, can be merged.

Neural networks

  • Classify continuous-valued inputs into linguistic term sets
  • Represent sets using a binary scheme
  • Dynamic Depth-first Searching

We applied AKD technologies in 11 engineering applications successfully in the previous two years. The research topics include Quadrilateral Mesh Generation, Knowledge-based Engineering, Adaptive and Rapid Process Modeling and Optimization, Response Surface, Traffic Assignment and Transportation Planning, Probe Array Design and Fuel Measurement Principles, Air Quality Model, and Environment Impact of Bus Rapid Transit. The industry partners and/or collaborators include Parker Hannifin Corporation, Lorain Pipe Mills, Cincinnati Machines, GE Aerospace Engine, Kraft, Marzetti, City Planning of University of Cincinnati, and Cincinnati Bell. All these began to establish my research contacts with major industrial companies/institutes.

[>>> go back to the top >>>]

Manufacturing System Simulation

During the summer of 2002, I managed two students to develop SimPro 1.0, a software tool for productivity simulation and process improvement of complex manufacturing systems. This system identifies the sub-systems like "series", "parallel", "assembly", "expansion" and "complex", and enables the process improvement by locating the productivity bottleneck in the manufacturing system. The results were published in two journal papers. C++ Standard Template Library (STL) and ATL (Active Template Library) were used to build the simulation models.

[>>> go back to the top >>>]

Supply Chain Design

Classified manufacturing supply chains into three types, namely, lean, agile, and hybrid. Studied on the relationship between an appropriate type of supply chain and the characteristic of product an organization is manufacturing. Based on "Supply Chain Operation Reference (SCOR) Model", an Analytic Hierarchy Process (AHP) model was developed and implemented to assist organizations in supply chain selection.

[>>> go back to the top >>>]

Customer Complaint Analysis

During the Autumn of 2000, I developed CyberComplain, customer complaining web service/application, which helped companies collect feedback and helps customer get resolution from web. It could become an integrative customer feedback center/platform. Java Script, ASP, Microsoft Access and HTML were major tools used.

[>>> go back to the top >>>]

Early Supplier Involvement

[>>> go back to the top >>>]

Web-based ERP Application

As a Sr. Software Developer in an IT company, I was responsible for more than 100 COM components for the products of iERP, iSCM, iHRM, and iKM. These products have become major elements of eMP (Electronic Management Platform), the flagship of netwinner.net. Two customer solutions were involved, using technologies of XML, COM and ASP, in an environment of Windows and SQL Server 7.0.

[>>> go back to the top >>>]

Management Information Systems

When I worked in Nanjing Automation Research Institute, Nanjing, China, 07/1997 ~ 03/1998, as Assistant Manager of MIS Department, I prepared the bidding proposal of MIS (Management Information System) projects for (1) Anqing Electrical Bureau of Anhui province and (2) Local Taxation Bureau of Jiangsu Province; built up prototype systems using Borland Delphi to show the main components and functions; recruited temporary employees; managed/developed sub systems using Power Builder/Visual Basic and Oracle/SQL Server.

[>>> go back to the top >>>]

Collaborative Product Development

I (1) Studied and developed methodologies of using the process of CPD with web technologies, for 3 years. (2) Developed a general DFX framework to generate DFX tools (DFA, DFM, etc.) and fit them in a common DFX worksheet: DFX Handbook offering design assistant guidelines, Lucas DFA evaluating the assembability of a product, FMEA offering failure modes and effect analysis online, and CyberWorkflow brokering collaboration among distributed web applications. (3) Published 11 academic reports for the pioneer research work. (4) Developed more than 10 web applications to implement the methodologies. SQL Server, Access and XML were used for data representation and transferring. DAO, RDO, ADO, RDS, and ODBC were used for data communication between application tiers. COM/DCOM/COM+ were applied in middleware development. ActiveX, Java Applet, Script (Java/VB) and ASP were used in client application development. Tools of Visual Basic, Visual C++, FrontPage and InterDev were used in various systems.

[>>> go back to the top >>>]

University Christian Church (Cincinnati) Web Site

Web Site of Intelligent CAM Systems Laboratory of University of Cincinnati

Web Site Construction in the University of Hong Kong

  • Date: 01/1999 ~08/2001
  • Designed, built and maintained
    • HKU CSSA (Chinese Students & Scholars Associate) web site using Windows 2000 Server, JSP, JDBC, Microsoft Access, Visual J++
    • http://web.hku.hk/~cssa/
    • HKU PGSA (Postgraduate Student Association) web site using UNIX, Perl, Java Script, PHP, and MySQL
    • http://www.hku.hk/pgsa/

China-TopTalent.net

  • Date: 01/2000 ~
  • Assigned as CTO

[>>> go back to the top >>>]

Air Quality Models

Since 09/2003, I work as Collaborative Researcher at planning school of University of Cincinnati, with professor and students in planning school, to develop software application in air quality models such as Cline and BPT.

ArcMap 8.3 is being used as the platform. VBA and ArcObject library are major technologies applied. Further work is to develop some algorithms and programs in 3D visualization of the GIS models.

[>>> go back to the top >>>]

GIS Air/Water Analysis Models

Dissertation committee member

  • Master student at City Planning Department in University of Cincinnati
  • Tutor thesis writing and guide research work

Integration of GIS, 3D visualization and transportation planning

  • Based on OKI traffic data, use traffic model to forecast traffic data in 2010
  • Compare two different scenarios of implementing BRT construction and not implementing
  • Input the traffic data and apply CO model to forecast CO concentrations along routes
  • Use Maya and MEL to animate and render pollution status

Web-based GIS Application Development

  • Use ArcGIS and ArcIMS as the development platform
  • Use Visual Basic and ArcObject to develop DLL/Class Modules
  • Use VBA in ArcGIS, JSP, JDBC and Java in ArcIMS

 

[>>> go back to the top >>>]
 

Copyright Jun Shi, 2005. Any comments could be sent to johnjshi@gmail.com.