Below are the 2 most recent journal entries recorded in jabhodgson's LiveJournal:

Thursday, January 24th, 2008
3:17 pm	Resume  JOHN HODGSON                                                        jabhodgson@computer.org                                          ENTERPRISE APPLICATION ARCHITECTURE AND DEVELOPMENT                                                                   OVERVIEW                                                                   PROFILE                John  Hodgson is an architect and  developer                in  the field of high performance multi-tier                Web and business computing.  He has provided                technical leadership and designs in areas of                application   architecture,  object-oriented                analysis   and   design,  integration   with                databases   and   other   services,   system                administration    and    management,     and                testing/deployment  on  a  wide  variety  of                enterprise   projects.    His   professional                interests   include   Web-based   e-commerce                solutions for the intranet and the Internet,                Service-Oriented Architecture (SOA)  middle-                tier  business  services,  and  business-to-                business (B2B) Web services. PROFESSIONAL OBJECTIVES                +     Enable leading edge enterprise and  e-                  commerce technologies                +      Provide   technical  leadership   for                  outstanding business software                +     Achieve  client  satisfaction  through                  high quality of services                +       Build   reputation   for   technical                  excellence and reliability CORE EXPERTISE                +     Sun  J2EE APIs, including Web services JAVA 2           and  XML  technologies, Web  technologies, ENTERPRISE       security technologies EDITION        +    Spring Framework, Apache Struts (J2EE)         +     BEA WebLogic Server 9.2, IBM Websphere                  5, Apache Tomcat                +     Data:  advanced ER modeling,  database ORACLE           design,  normalization  and  optimization,                  physical and conceptual models                +    Client: Advanced SQL, SQL optimization,                  client configuration, JDBC drivers, SQLNet                +     Server: End-to-end performance  tuning                  and troubleshooting, Oracle server/session                  parameter   optimization,   unix    server                  optimization,     table    and     storage                  optimization                +     Service  Oriented  Architecture  (SOA) APPLICATION      design   patterns  (recently  with  Spring DESIGN           Framework)                +     Web services: interoperable, document-                  centric, Business-to-Business (B2B)                +     High  usability Web application design                  and  business process analysis,  including                  portal-type applications                +     Custom  framework library  design  and                  development                +     Deep  knowledge of Java and J2EE usage                  and design patterns, including synchronous                  and  asynchronous  access  and  processing                  patterns CHRONOLOGY OF PROFESSIONAL EXPERIENCE                               January  2008    CGGVeritas      Houston, Texas                Consultant                - Troubleshooting and tuning of Aspera file transfer                 services.  Results: throughput bottlenecks resolved,                 and logging improved.               - Mentoring and guidance of chief JEE architect.                 Results: Various gaps in architect's knowledge and                 application of JEE design, development, and deployment                 filled.                - Rearchitecture of file transfer and control and                 monitoring application according to current enterprise                 application design patterns. Results: Application is                 now divided into multiple tiers and is                 service-oriented.  Developers can work on individual                 tiers.  Application behaviour is robust and can more                 effectively be understood, analyzed, and extended.                - Advice given for team development infrastructure, in                 regard to IDE configuration and use. Results: Team                 development infrastructure will be more effective and                 easy to maintain.                April 2007-Dec. 2007 Citigroup Toronto                J2EE Technology Specialist                - Selection and implementation of key technologies:                 clustered transactional caching, dependency injection,                 frameworks, messaging, build and deployment systems,                 Web services and XML technologies, desktop development                 tools; technologies: WebLogic 9.2, Oracle, Spring                 Framework, JBoss Cache, Maven, TIBCO EMS, JAXB 2.1,                 Quartz.  Results: choices and implementations of                 technologies are near optimal for performance, cost,                 and maintenance.                - Mentoring and guidance of line developers.  Results:                 Developers learn and apply important design patterns                 and architectural principles; application quality                 remains high; critical design errors are avoided;                 developers are satisfied.                - Support of line developers, troubleshooting of                 complex problems in use of J2EE frameworks, tools, and                 general programming. Results: road blocks are quickly                 resolved; line developers stay productive and                 motivated, scheduled milestone dates are met.                - Build, deployment, and run time management of                 application in heterogeneous complex enterprise                 environment. Results: application is manageable in a                 complex enterprise environment.                - Selection and setup of developer tool sets.  Results:                 developers stay focused on application, not on tool                 management.                Sept. 2005-Feb. 2007          Workbrain, Inc.     Toronto                J2EE Technical Architect                -    Definition and development of new, top-                 level, service-oriented architecture for  a                 large multi-module application used by major                 corporations worldwide (10,000+ employees);                 technologies: Spring Framework 1.2.7,  2.0.                 Results:  allowed a new, considerably  more                 complex business module to be delivered  in                 less than one year from start to finish, to                 meet new government regulatory requirements                -        Design    and    development     of                 interoperable,    secure    Web    services                 infrastructure and frameworks; technologies:                 Apache  Axis  1.4  and WSS4J  1.5.0,  WS-I.                 Results: business modules are now accessible                 to   external   clients  and   applications                 according to the latest industry standards,                 as requested by customers                -      Development  of  new  frameworks  for                 dependency injection, services, and Web MVC;                 technologies: Spring Framework, J2EE Servlet                 2.4,  Apache Velocity, WebLogic  Server  9,                 Websphere    5    (basic    administration,                 application   deployment  and   extension),                 Oracle  10g, DB2 v8, SqlServer. Results:  a                 new  Web application module was able to  be                 made  verifiably secure for the first time,                 to meet customers' increasing demands                -     Integration  with  legacy  application                 components,      including      transaction                 management; technologies: Spring Framework,                 J2EE   transaction  API.  Results:   legacy                 transactional code operates seamlessly with                 J2EE-based  transactional  code,   enabling                 manageable,  gradual modernization  of  the                 application                -     Definition  of new design  and  coding                 standards; technologies: enterprise  design                 patterns.  Results:  logging,  alerts,  and                 monitoring now meet customers' stated  high                 expectations                               August 2005    Environment Canada     Toronto                Senior Consultant, John Hodgson Software                Inc.                -     Review of application architecture for                 an  in-house thick-client data entry multi-                 tier application; technologies: J2EE, Swing,                 JDBC,   javax  comm.  Results:   functional                 requirements are confirmed as achievable                -    Revised the high-level architecture and                 mentored  on  architectural  methodologies.                 Results:  performance  and  maintainability                 objectives are now achievable                -      Provided  advice  on  composition  of                 development  team and on project  cost  and                 schedule estimation. Results: delivery  can                 be made within promised time                               June 2005-July 2005 Canadian Standards Association Toronto                Senior Technical Architect, John Hodgson                Software Inc.                Designed  and  developed custom  Model-View-                Controller    framework   with    clustering                (failover)  capability for high-availability                enterprise portal environment; technologies:                SAP  Enterprise Portal 6.20,  JDBC,  Oracle.                Results:  custom portal development combines                SAP with other enterprise systems                               Dec. 2004-Jan. 2005        Environment Canada     Toronto                Senior Consultant, John Hodgson Software                Inc.                -     Review  of  application  architecture,                 design  patterns, and practices for an  in-                 house multi-tier application based on Java 2                 Enterprise  Edition;  technologies:  JBoss,                 JMS, EJB, JDBC, JTA, JMX, Hibernate, Erwin,                 Oracle,    Postgres.    Results:    serious                 performance bottlenecks eliminated;  system                 can  meet  performance objectives for  high                 volumes of data                -     Mentoring  and training of application                 developers in J2EE architecture                               Jan. 2000-Sept. 2004 Mackenzie Financial Corp. (Canada) Toronto                Senior Technical Architect, John Hodgson                Software Inc.                -     Architected  a Web browser-based  data                 entry  application,  including  design  and                 development   of   a  Model-View-Controller                 framework.,    for   dealer    and    sales                 representative support; technologies:  J2EE                 Servlet  2.3, WebLogic Server 6.1,  Struts,                 JSP,   JSTL.  Results:  20  clerical  staff                 transitioned from mainframe screens to  new                 system   with   no  loss  of   data   entry                 efficiency;  casual data entry  facilitated                 for the first time                -       Architected   a   highly   scalable,                 extensible  Web browser-based  inquiry  and                 reporting system, with initial deployment to                 customer support; technologies: J2EE Servlet                 2.3, WebLogic Server 6.1, Struts, JSP, JSTL.                 Results: approximately 100 customer service                 representatives  enabled  in  Toronto   and                 Vancouver;   three  separate   applications                 replaced  by  one  Web  application  in   a                 department with high employee turnover  and                 burnout                -      Provided   OOAD   and   architectural                 technical  leadership  and  mentoring   for                 initial   team   of  four   in-house   Java                 developers;  technologies:  J2EE,  WebLogic                 Server 6.1, JBuilder. Results: organization                 became J2EE-capable                -      Designed   and  developed   a   high-                 performance enterprise-wide business domain                 information   service   in   Java,   as   a                 cornerstone architectural component  to  be                 used by all future enterprise applications;                 technologies:  RMI,  CORBA,   JNDI,   JDBC.                 Results:   application   development   time                 reduced;  data  and  business  rules   made                 consistent across applications                -       Designed   and   developed   custom,                 enterprise-duty Java framework and  utility                 packages  to complement and extend standard                 Java    packages.   Results:    application                 development   time   reduced;   application                 quality   increased;   applications   fully                 enterprise-quality, e.g., logging, alerting                -      Initiated   configuration  management                 practices   for  Java,  including   package                 hierarchy,  version management,  and  build                 framework  to  support future  development;                 technologies: PVCS 6, unix scripting, Apache                 Ant. Results: J2EE configuration management                 made   consistent   with   existing,   high                 mainframe standards                -     Liased with data department on  issues                 of    business   domain   data    modeling;                 technologies::       S-Designor        (now                 PowerDesigner),  Oracle,  Erwin.   Results:                 business   and   data   modeling    methods                 established in J2EE area for the first time                -     Provided technical advice on a variety                 of  issues,  e.g.,  integrated  development                 environment  tools, operating systems,  and                 system   testing;  technologies:  Velocity,                 Rational     Rose,    TopLink,    Cocobase,                 Optimizeit,   LoadRunner.  Results:   white                 papers   and  presentations  on   strategic                 choices of technologies                -      Designed   and  developed   a   high-                 performance data service, including a custom-                 designed   object-relational  mapping   and                 persistence  layer,  to  support   uniform,                 enterprise-wide   data   update   services;                 technologies: JDBC. Results: cost-effective,                 performing   J2EE  data  access   for   Web                 development;  modest  learning  curve   for                 developers; no licence fees                -     Provided technical advice and  support                 for configuration and administration of BEA                 Weblogic   server;  technologies:  WebLogic                 Server  6.1.  Results:  cost-effective  and                 performing use of WebLogic Server                               1998-Jan. 2000                       DMC Inc.     Toronto                Senior Consultant                -       Designed    Forte   4GL   three-tier                 architecture and applications for securities                 trading data entry at Merrill Lynch Canada                -      Forte  development,  deployment,  and                 administration (Solaris/Sybase)                -     Performed OOAD, business modeling, and                 forward-reverse engineering                               1996-1998 Descartes Systems Group Inc.Waterloo, Ontario                Senior Software Engineer                -     Forte  4GL  and Forte Express  client-                 server development (NT/Oracle)                -    Integrated Seagate Crystal Reports as a                 middle-tier service for scalability                -     Wrote  auto-documentation  application                 for development environment                               1995-1996 University of WaterlooWaterloo, Ontario                Lecturer                -     Prepared  and delivered C++ and  other                 computer courses, 1st-year Engineering                -      Prepared   and  delivered  algorithms                 course, 4th-year Engineering                               1989-1995 University of WaterlooWaterloo, Ontario                PhD Candidate and Research Assistant EDUCATION AND PROFESSIONAL DEVELOPMENT                1999      Oracle              Mississauga, ON                Oracle8 for Application Developers                1996-1998 Forte     Oakland/San Francisco, CA                -     Forte Forum, presented paper at annual                 convention (1998)                -    Forte Fusion (Conductor) course (1997)                -      Forte  System  Administration  course                 (1996)                1998      Seagate Crystal ReportsWaterloo, ON                -    Report design course                1989-1995 Ph.D.        University of Waterloo                -      Pattern  recognition  and  artificial                 intelligence research                -      Extensive   unix,  programming,   and                 Internet development experience                1984-1987 M.A.Sc.       University of Toronto                -      Plasma  physics  and  fusion  reactor                 materials research at University of Toronto                 Institute for Aerospace Studies                1977-1981 B.A.Sc.       University of Toronto                -    Engineering Science, Aerospace option MISCELLANEOUS                -    Fluent in English, Russian and German                -    Professional Engineer (Ontario), Member                 IEEE Computer Society TECHNICAL EXPERTISE Category              Years GUI/Client front end  5  (JSP, Struts, Javascript),                       4 (Forte) Middle-tier and  back 7 (J2EE), 4 (FORTE) end 3 GL                  13 (C), 11(C++), 13 (Lisp) Java                  11 Operating Systems     16 (unix), 9 (NT/95/2000/XP) HTML                  11 Application Server    6 (BEA WebLogic Server) SQL                   11 Reporting Tools       1    (Crystal   Reports),   1                       (Actuate) CASE Tools            4  (S-Designor), 2  (Select),                       1 (Rational) OOAD                  10 (generic), 5 (UML) Databases             9 (Oracle), 1 (Sybase) Configuration         4 (PVCS) Management Data                  7 Modelling/Analysis Project Management    3 (Comment on this)
Thursday, March 1st, 2007
9:51 am	Resume                            JOHN HODGSON                                                        jabhodgson@computer.org                                          ENTERPRISE APPLICATION ARCHITECTURE AND DEVELOPMENT                                                                   OVERVIEW                                                                   PROFILE                John  Hodgson  is  a  senior  architect  and                developer  in the field of high  performance                multi-tier  Web  and client-server  business                computing.    He   has  provided   technical                leadership   and   designs   in   areas   of                application   architecture,  object-oriented                analysis   and   design,  integration   with                databases   and   other   services,   system                administration    and    management,     and                testing/deployment  on  a  wide  variety  of                enterprise  projects.  His recent experience                is  with Sun Java 2 Enterprise Edition.  His                professional interests include Java-based e-                commerce solutions for the intranet and  the                Internet,  and integrating powerful  middle-                tier  business  services  with  evolving  e-                commerce Internet application architectures. PROFESSIONAL OBJECTIVES                --     Stay on the leading edge of enterprise                  and e-commerce technology                --      Provide   technical  leadership   for                  outstanding business software                --      Achieve  satisfaction  through   high                  quality of services                --      Build   a  reputation  for  technical                  excellence and reliability CORE EXPERTISE                --     Java 5.0, generics, annotations, JDBC, JAVA 2           Servlets,   JSP,  JSTL,  JTA,   JMX,   XML ENTERPRISE       technologies including JAX-WS, JAAS, J2CA, EDITION          JavaBeans, RMI, CORBA, JNDI, ANT, EJB (J2EE)         --    Spring Framework, Struts, Velocity                --     BEA WebLogic Server 9.2, Websphere  5,                  Tomcat, clustering                --     Data:  advanced ER modeling,  database ORACLE           design,  normalization  and  optimization,                  physical and conceptual models                --        Client::    Advanced    SQL,    SQL                  optimization,  client configuration,  JDBC                  drivers, SQLNet                --     Server: End-to-end performance  tuning                  and troubleshooting, Oracle server/session                  parameter   optimization,   unix    server                  optimization,     table    and     storage                  optimization                --     Service  Oriented  Architecture  (SOA) APPLICATION      design patterns DESIGN         --    Web services                --     High  usability Web application design                  and  business process analysis,  including                  portal and portal-type applications                --    Custom framework design and development                --     Deep  knowledge of Java and J2EE usage                  and design patterns, including synchronous                  and  asynchronous  access  and  processing                  patterns CHRONOLOGY OF PROFESSIONAL EXPERIENCE                               Sept. 2005-Feb. 2007          Workbrain, Inc.     Toronto                J2EE Technical Architect                n    Definition and development of new, top-                 level, service-oriented architecture for  a                 large multi-module application used by major                 corporations worldwide; technologies: Spring                 Framework 1.2.7, 2.0                n    Design and development of interoperable                 Web services infrastructure and frameworks;                 technologies:  Apache Axis  1.4  and  WSS4J                 1.5.0, WS-I                n      Development  of  new  frameworks  for                 dependency injection, services, and Web MVC;                 technologies: Spring Framework, J2EE Servlet                 2.4,  Apache Velocity, WebLogic  Server  9,                 Websphere    5    (basic    administration,                 application   deployment  and   extension),                 Oracle 10g, DB2 v8, SqlServer                n     Integration  with  legacy  application                 components, including transaction management                n     Definition  of new design  and  coding                 standards                               August 2005    Environment Canada     Toronto                Senior Consultant, John Hodgson Software                Inc.                n       Audit   and   review   of   proposed                 application  architecture for  an  in-house                 thick    client   data   entry   multi-tier                 application;  technologies:  J2EE,   Swing,                 JDBC, javax comm                n    Revised the high-level architecture and                 mentored on architectural methodologies                n      Provided  advice  on  composition  of                 development  team and on project  cost  and                 schedule estimation                               June 2005-July 2005Canadian Standards Association Toronto                Senior Technical Architect, John Hodgson                Software Inc.                Designed  and  developed custom  Model-View-                Controller    framework   with    clustering                (failover)  capability for high-availability                enterprise portal environment; technologies:                SAP Enterprise Portal 6.20, JDBC, Oracle                               Dec. 2004-Jan. 2005        Environment Canada     Toronto                Senior Consultant, John Hodgson Software                Inc.                n      Audit   and   review  of  application                 architecture, design patterns, and practices                 for an in-house multi-tier application based                 on Java 2 Enterprise Edition; technologies:                 JBoss, JMS, EJB, JDBC, JTA, JMX, Hibernate,                 Erwin, Oracle, Postgres                n      Some   higher-level   mentoring   and                 training of application developers                               Jan. 2000-Sept. 2004Mackenzie Financial Corp. (Canada) Toronto                Senior Technical Architect, John Hodgson                Software Inc.                n      Provided   OOAD   and   architectural                 technical  leadership  and  mentoring   for                 initial   team   of  four   in-house   Java                 developers;  technologies:  J2EE,  WebLogic                 Server 6.1, JBuilder                n      Designed   and  developed   a   high-                 performance enterprise-wide business domain                 information   service   in   Java,   as   a                 cornerstone architectural component  to  be                 used by all future enterprise applications;                 technologies: RMI, CORBA, JNDI, JDBC                n       Designed   and   developed   custom,                 enterprise-duty Java framework and  utility                 packages  to complement and extend standard                 Java packages                n      Initiated   configuration  management                 practices   for  Java,  including   package                 hierarchy,  version management,  and  build                 framework  to  support future  development;                 technologies: PVCS 6, unix scripting, Apache                 Ant                n     Liased with data department on  issues                 of    business   domain   data    modeling;                 technologies::       S-Designor        (now                 PowerDesigner), Oracle, Erwin                n     Provided technical advice on a variety                 of  issues,  e.g.,  integrated  development                 environment  tools, operating systems,  and                 system   testing;  technologies:  Velocity,                 Rational     Rose,    TopLink,    Cocobase,                 Optimizeit, LoadRunner                n      Designed   and  developed   a   high-                 performance data service, including a custom-                 designed   object-relational  mapping   and                 persistence  layer,  to  support   uniform,                 enterprise-wide   data   update   services;                 technologies: JDBC                n     Architected  a Web browser-based  data                 entry  application,  including  design  and                 development   of   a  Model-View-Controller                 framework.,    for   dealer    and    sales                 representative support; technologies:  J2EE                 Servlet  2.3, WebLogic Server 6.1,  Struts,                 JSP, JSTL                n      Architected  a  highly  scalable  and                 extensible  Web browser-based  inquiry  and                 reporting system, with initial deployment to                 customer support; technologies: J2EE Servlet                 2.3, WebLogic Server 6.1, Struts, JSP, JSTL                n     Provided technical advice and  support                 for configuration and administration of BEA                 Weblogic   server;  technologies:  WebLogic                 Server 6.1                               1998-Jan. 2000                       DMC Inc.     Toronto                Senior Consultant                n       Designed    FortE   4GL   three-tier                 architecture and applications for securities                 trading data entry at Merrill Lynch Canada                n      FortE  development,  deployment,  and                 administration (Solaris/Sybase)                n    Performed OOAD, business modelling, and                 forward-reverse engineering                               1996-1998 Descartes Systems Group Inc.Waterloo, Ontario                Senior Software Engineer                n     FortE  4GL  and FortE Express  client-                 server development (NT/Oracle)                n    Integrated Seagate Crystal Reports as a                 middle-tier service for scalability                n    Wrote autodocumentation application for                 development environment                               1995-1996 University of WaterlooWaterloo, Ontario                Lecturer                n     Prepared  and delivered C++ and  other                 computer courses, 1st-year Engineering                n      Prepared   and  delivered  algorithms                 course, 4th-year Engineering                               1989-1995 University of WaterlooWaterloo, Ontario                PhD Candidate and Research Assistant EDUCATION AND PROFESSIONAL DEVELOPMENT                1999      Oracle              Mississauga, ON                Oracle8 for Application Developers                1996-1998 FortE     Oakland/San Francisco, CA                n     FortE Forum, presented paper at annual                 convention (1998)                n    FortE Fusion (Conductor) course (1997)                n      FortE  System  Administration  course                 (1996)                1998      Seagate Crystal ReportsWaterloo, ON                n    Report design course                1989-1995 Ph.D.        University of Waterloo                n      Pattern  recognition  and  artificial                 intelligence research                n      Extensive   unix,  programming,   and                 Internet development experience                1984-1987 M.A.Sc.       University of Toronto                n      Plasma  physics  and  fusion  reactor                 materials research at University of Toronto                 Institute for Aerospace Studies                1977-1981 B.A.Sc.       University of Toronto                n    Engineering Science, Aerospace option MISCELLANEOUS                n    Fluent in English, Russian and German                n    Professional Engineer (Ontario), Member                 IEEE Computer Society TECHNICAL EXPERTISE Category              Years GUI/Client front end  4  (JSP, Struts, Javascript),                       4 (FortE) Middle-tier and  back 5 (J2EE), 4 (FORTE) end 3 GL                  13 (C), 11(C++), 13 (Lisp) Java                  8 Operating Systems     15 (unix), 8 (NT/95/2000/XP) HTML                  10 Application Server    4 (BEA WebLogic Server) SQL                   8 Reporting Tools       1    (Crystal   Reports),   1                       (Actuate) CASE Tools            4  (S-Designor), 2  (Select),                       1 (Rational) OOAD                  9 (generic), 4 (UML) Databases             8 (Oracle), 1 (Sybase) Configuration         4 (PVCS) Management Data                  6 Modelling/Analysis Project Management    3   SUMMARY OF RECENT TECHNICAL QUALIFICATIONS JAVA --     extensive  practical experience with Java and J2EE  packages   and  APIs; knowledge of most recent updates in Java 1.5,  latest   features  of  Java 2 Enterprise Edition including Servlet,  JSP,   JSTL, EJB 2.0, JDBC 2.0, JTA, JNDI, JAAS, J2EE security, JMX; Java   language  syntax  and semantics, effective package  hierarchies;   Javadoc inline documentation; design for multithreading, compile-   time  and run-time features, virtual machine organization;  Java   distributed  computing with RMI; experience with advanced  IDEs,   e.g.,  Borland JBuilder and IBM Visual Age for Java;  experience   with  application  servers,  e.g.,  BEA  Weblogic  Server,  best   practices  of  distributed computing, Web, thin-  versus  thick-   client, Internet, and intranet, and user interfaces. CORBA --     practical experience with ORBs, understanding of  CORBA  2.3   Java-IDL  mapping,  RMI over IIOP, CORBA service  for  two-phase   distributed transaction control, naming service, Java wrapper APIs   for CORBA services CONFIGURATION MANAGEMENT --     practical  experience with setting up a version control  and   management system involving multiple developers in PVCS, promotion   groups, version labeling; automating the build process for  Java   and J2EE applications and libraries using GNU make UNIX --     extensive experience with SunOS and Solaris since 1989,  and   recently with Linux --      shell  scripts,  job  control,  batch  jobs,  basic  system   maintenance,   Xwindows  (OpenWindows,  CDE),  compilation   and   debugging, network utilities OOAD --     practical experience with Rational Rose and Select, OMT  and   OID   diagrams,  forward-  and  reverse-engineering,   developed   effective design patterns for distributed multi-tier client-server   applications, familiarity with various basic design patterns  in   enterprise  computing,  use  case analysis,  storyboarding,  and   interviewing of users DATABASES --     practical  knowledge  and experience of  databases  (Oracle,   Sybase),  normal  forms and good schema  design,  DML  and  DDL,   performance  issues  (multithreaded  libraries,  disk  and   RAM   utilization), performance tuning issues and indexes, partitioning   of  processing  (stored procedures vs. middle-tier  processing),   multi-transaction data concurrency, contention, and integrity (Comment on this)