Bill Clementson


A Senior Architect, Software Engineer, and Project Lead with extensive ERP, EAI and B2B development experience. Responsible for defining much of the PeopleSoft EnterpriseOne development methodology for complex EAI and B2B integrations. Quality-oriented with strong problem-solving skills and a demonstrated ability to translate complex concepts into effective systems.


WORK EXPERIENCE


Software Architect, Product Strategy

Jan 2003 - present

PeopleSoft

www.peoplesoft.com

Summary:

Responsible for coordinating the definition of the "Desired Future State" tools technology direction for JD Edwards prior to the acquisition by PeopleSoft. Following the acquisition, was instrumental in rationalizing cross-platform (Enterprise/EnterpriseOne) technologies and defining key future technology directions.

Primary architect for the following key cross-platform architectural efforts:

  • Metadata future direction: Developed vision for standards-compliant, extensible application metadata.
  • IDE future direction: Created proposal for migrating from a proprietary IDE to an Eclipse based toolset.
  • SOA future direction: Worked on definition of the next-generation component-based application platform.

Detail:

Prototyped extensible, dynamically-generated metadata using Common Lisp as well as a proposed new PeopleSoft IDE based on Eclipse.

Wrote many "Desired Future State" documents and presentations outlining proposals for the future direction of key technology areas for PeopleSoft.

Part of a core team responsible for evaluating technology options and potential acquisitions.

Computers: Multiple PC's and Servers on Windows/2000, OS/400, Unix, Linux, Mac OS X

Languages: Common Lisp, Java

Utilities: PeopleSoft Enterprise/EnterpriseOne utilities


Integrations Architect

Jul 1998 - Jan 2003

JD Edwards

www.jdedwards.com

Summary:

Integrations Architect responsible for much of the EAI, B2B, and Web Services solution for JDE. Designed key enterprise, B2B and interoperability functionality and headed up project teams responsible for implementing the designs. Author of the JD Edwards "XPI Development Methodology" manual specifying standards for the development of EAI and B2B solutions that integrate with JDE's Enterprise software.

Created conceptual and technical design documents for the Business Process API's (BPAPIs), a project that eventually morphed into the Interoperability/Integration Extended Business Process (XBP) definitions. Consultant on many of the OneWorld/World XBP enhancements and integrations.

Design Architect for the JD Edwards Sales Force Automation module, a major OneWorld Front Office system (designed for both client/server and web deployments) totally integrated with JDE's Back Office products.

Detail:

In addition to creating the methodology for developing EAI and B2B integrations, was involved in much of the prototyping activies for early JDE integrations. Prototyped (in Java) some of the WebMethods tool changes needed to adapt the EAI/B2B products for JDE use.

Wrote Python utility to generate a "data dictionary" from canonical integration interfaces in order to ensure that consistent naming standards were being used.

JDE technical representative to RosettaNet and ebXML.

Computers: Multiple PC's and Servers on Windows/2000, OS/400, Unix

Languages: C, ER, Java, Python

Utilities: JDE OneWorld utilities, WebMethods EAI/B2B, NetFish EAI, Microsoft Project


Independent Consultant

Dec 1997 - Jul 1998

JD Edwards, NZ

www.jdedwards.com.au

Summary:

Technical Lead for the Fisher & Paykel project - at the time, this was the largest OneWorld implementation in Australasia. Also provided technical and C programming support for 3 other OneWorld clients during this period.

Detail:

Trained a core set of developers in the use of the OneWorld toolset and OneWorld-specific C programming techniques in order to build a technical team for the Fisher & Paykel project. In addition to being the technical lead for the project, worked on significant enhancements and ran "brown bag" training sessions for both consultants and customer technical staff.

Was the primary C programming "guru" for JDE-NZ during this time. Ran several in-house training sessions in order to improve internal C programming knowledge.

Wrote C code to generate bar codes on Zebra printers from OneWorld.

Worked with multiple clients throughout New Zealand, providing consulting, training, and programming support.

Computers: IBM AS/400 using OS/400, PC's using MS Windows/NT

Languages: C, ER

Utilities: JDE OneWorld utilities, Microsoft Project


Consultant

Aug 1995 - Nov 1997

JD Edwards

www.jdedwards.com

Summary:

One of only a few outside consultants working on key projects for JD Edwards in both the World Software (AS/400-RPG) and OneWorld (Client/Server-Multi-Platform) development teams.

Project lead and/or design architect for the following significant enhancements:

  • UCC 128 Compliance project: A strategic JDE EDI enhancement for the Retail Industry.
  • ECS Aviation & Marine and ECS Load Confirm of Actuals & Ambient/Standard enhancements.
  • Cost Management Solution with Sales Flexible Accounting.

Detail:

Initially involved in writing key Distribution module enhancements to the Energy and Chemical World product. Subsequently employed to work on key enhancements to both the World and the OneWorld products.

UCC 128 Compliance project was a strategic JDE EDI enhancement. Implemented support for the ASC X12 856 EDI transaction, a hierarchically structured EDI transaction for reporting shipped product details (commonly recognized as the most difficult EDI transaction to implement successfully).

Computers: IBM AS/400 using OS/400, PC's using MS Windows/NT

Languages: RPG/400, CL, C, ER

Utilities: SDA, SEU, PDM, QUERY/400, SQL/400, JDE World utilities, JDE OneWorld utilities, EDI utilities, Microsoft Project


Consultant

Jan 1995 - Aug 1995

Pharmacy Corporation of America

www.pharmerica.com

Summary:

Project Manager for Health Care Products systems, managing the work of client staff and consultants in a mixed Synon /RPG development environment.

Detail:

Worked as a consultant manager for Whittman-Hart (an IT consulting firm) managing the work of multiple consultants working for PCA. In this role, had both managerial as well as technical deliverables. Successful management of technical staff to achieve project objectives, deadlines & budgets. Good rapport and working relationship with staff.

In addition to managing the Health Care Products project, was involved in several technical consulting roles for this client, participating in the planning for the upgrade of PCA's network of AS/400's and discussions on security and change management issues. The support contract ended early when PCA was acquired and the facility was moved to Florida.

Computers: IBM AS/400 using OS/400

Languages: RPG/400, CL, Synon

Utilities: SDA, SEU, PDM, QUERY/400, SQL/400, Microsoft Project


Manager

Jan 1992 - Dec 1994

Computer Services Limited

www.samoa.ws

Summary:

Managed the system support department for a computer bureau servicing banking, financial and government organizations in Western Samoa.

Reorganized computer bureau operations and system support functions, replacing obsolete IBM S/36's with AS/400's and migrating customers to new software. The efficiencies that I introduced resulted in my exceeding the System Support annual income target within the first six months of my contract. CSL had record profits during my 3 years as System Support Manager with the company.

Detail:

System Support Manager for Computer Services Ltd, the major computer supplier and bureau in Western Samoa. Responsible for overseeing all programming and software support done by the bureau as well as having a hands-on role in some projects.

Prepared a feasibility study for Board presentation on the feasibility of upgrading the bureau S/36's to one or more AS/400's. Recommendation to purchase two AS/400's was approved by the Board. Produced feasibility study for CSL for upgrading all major bureau hardware and software from S/36 computers to AS/400's. Successfully implemented proposal, resulting in a more efficient and competitive bureau operation.

Installed two AS/400's for the bureau. This included setting up each machine, installing licensed software, configuring devices and communications as well as organizing the training programs for the operators and programmers. In addition, wrote routines to collate client usage data for billing purposes.

Wrote a Security manual which covered all aspects of security for the new machines, including physical security, software security standards and change management controls. These security standards were approved by bank auditors.

Created the position of Systems Administrator to look after Security Administration tasks and configuring new devices. Trained the individual in these responsibilities.

Wrote a Standards manual which specified naming and programming standards for the bureau. Previously, no standards controls had been in place at the bureau. Set up internal procedures to ensure that standards were adhered to.

Responsible for training a local Samoan as a Trainee Programmer for the bureau in order to reduce the dependency on expensive expatriate contractors.

Migrated the primary bureau customer, the Bank of Western Samoa, from the bureau S/36 to the bureau AS/400. The General Manager of the bank remarked that he had never known any site to experience such a smooth, well-organized migration.

Was responsible for stream-lining the operation of the Bank of Western Samoa's Retail Banking system as well as providing direct support for the site. Reduced bank dependency on programming support by parameterizing a range of functions which previously had required programmer intervention to change.

Wrote a Loans Management system for the Development Bank of Western Samoa. Subsequently, I installed the same system in the Development Bank of Kiribati.

Set up a payroll system for Yazaki, a manufacturing company employing over 2,000 employees.

Was acting General Manager for several extended periods while the G.M. was on holiday or away on business. Maintained continuity of service to customers in the aftermath of Cyclones Val and Lyn. Difficult work environment included frequent power outages as well as damage caused by the cyclones.

Computers: IBM AS/400, S/36 & PC's using OS/400, SSP, Microsoft Windows, & PC/DOS

Languages: RPGII, RPG/400, OCL, CL, REXX, FoxPro

Utilities: IDDU, SDA, SEU, DFU, POP, PDM, PCS/400, QUERY/400, SQL/400, S/36 to AS/400 Migration Aid


Independent Consultant

Dec 1983 - Jan 1992

New Zealand Dairy Board

www.fonterra.com

Summary:

Primary developer of PACS, a custom manufacturing/distribution system integrated with real-time manufacturing data collection and monitoring.

Also contracted directly to other clients during this period for a number of custom code development projects.

Detail:

Involved in the design, coding and implementation of "PACS", a manufacturing system specific to N.Z. Dairy Packers' requirements. It included all normal manufacturing modules but placed special emphasis on historical material tracking, tracking individual cartons of milk powder from production through distribution.

Set up necessary DDM/DSPT links to allow the NZDB to access and run programs on NZDP's S/36. Also developed utilities to facilitate transfer of software from S/36 to S/36. Was probably the first person in NZ outside IBM to install DDM on two S/36's. I also wrote a series of routines to enable me to provide remote support via DDM for the second S/36.

Wrote program generater in RPG in order to facilitate the generation of basic maintenance and report programs.

Assisted in the setting-up of a Novell Netware/386 network on a Compaq Systempro. In particular, I set up the security standards for the network.

Modified an American accounting package to suit requirements of Dairy Containers Ltd. The package was written in Advanced Revelation, a Pick-like environment.

Developed "Market Intelligence System" for NZDB for analyzing markets for dairy products. This was the only facility of its kind at the Dairy Board until it was replaced by a similar system two years later running on the NZDB's Amdahl mainframe.

Designed an IBM PC to S/36 data transfer routine which facilitated real-time transfer of line monitoring equipment data from a PC to the S/36 for analysis. At the time (1985), this was generally considered to be quite a feat as few sites in the world (and none in NZ to my knowledge) had succeeded in using the S/36 in a real-time manufacturing line monitoring role.

Assisted with the modifications, implementation and training for several modules of packaged accounting software including BPCS General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets and Billing.

Assisted with the modifications, implementation and training for the Payroll/Personnel system PAYMAS/PERMAS. Also developed a bar code clock card system which streamlined the previously very time-consuming task of entering employee hours resulting in both improved and much faster payroll processing.

Migrated all PACS and IMAS software from S/34 to S/36 and did necessary modifications and conversions. Also did a trial conversion of a portion of the manufacturing programs on the S/36 to native-mode on an AS/400.

Performed a performance evaluation on the Waikato Hospital Board's S/36 using the S/36 System Monitoring Facility and software I had developed. The evaluation consisted of a series of interviews with users and operations staff as well as software monitoring. My report highlighted procedural and application program contributors to poor performance as well as indicating where tuning or equipment purchases could improve performance.

Developed a system for use by a chimney sweeping cooperative for the scheduling of work for its members.

Assisted with set-up of terminals/printers, integration of PC's with 5250 emulation and PC/36, training with word processing and S/36 graphics utilities.

Computers: IBM S/36 & S/34, IBM PC using SSP, PC/DOS

Languages: RPGII/III, BASICA, RBASIC

Utilities: APPC, IDDU, SDA, SEU, DFU, POP, DBT, PCFSU, PC/36, 5250 emulation, SMF, TMS, BGU/36, QUERY/36, DW/36, DDM, DSPT, S/34 to S/36 Migration Aid Fusion/36(Report generation & file maint), Fusion/3(Spreadsheet utility) IDF(Interactive debugging utility)


Analyst/Programmer

Jan 1981 - Nov 1983

Technology Resources Ltd

n/a

Summary:

Employed as an Analyst/Programmer by Technology Resources Ltd (a software house) developing custom solutions. Also did some contract programming work during the first 6 months of this period while I was completing my studies.

Detail:

Wrote a Temporary Debtors Program in BASIC for Thomson & Ward (an office supplies company) to provide them with a quick facility for maintaining temporary debtors accounts off the main accounting system.

Assisted with the installation of an IBM S/32 computer and with the modification of an IBM MMAS debtors package for Jewel Quilting Ltd (a bedding/curtain manufacturer). It provided them with custom stock control programs.

Wrote programs to interface to an Allen Bradley Programmable Logic Controller to provide a process control facility for a Dairy Company manufacturing plant. This involved writing a communications protocol in Z80 assembler based on the DF1 protocol (derived from sub categories D1 and F1 in ANSI publication X3.28-1976) to communicate with the PLC. Additionally, I created a set of graphics commands in assembler which could be called from a BASIC program to display sections of the plant where errors had (or were) occurring. I managed the work of a second programmer who utilized these graphics routines in programs displaying portions of the plant. I also wrote routines to handle error/status messages from the PLC.

Designed and wrote a Printers Job Costing package using dBASEII DBMS to allow a small printing company to accurately cost their work. Designed and wrote a "surplus plant reference" system for a broker who wanted to act as an agent for buying/selling surplus items using Control DBMS. Wrote a Herd and Membership record package for the N.Z. Dairy Goat Breeders .

Modified/enhanced standard General Ledger, Accounts Receivable, Accounts Payable, Inventory and Sales Order Entry programs to suit customer requirements.

Taught BASIC programming part-time for one year at a technical institute during this period.

Was responsible for installation of software, troubleshooting, liaison with customers, training and support.

Computers: IBM S/32, Onyx, North Star, Panasonic, MDL MX using SSP, Oasis & CPM

Languages: RPGII, Oasis Basic, Microsoft Basic, Z80 Assembler, dBASEII, Control

Utilities: SEU, DFU and Various utilities associated with the Oasis and CPM operating systems


NON-WORK EXPERIENCE


  • Produce a Lisp-related weblog .
  • Contributed to the following Common Lisp open-source projects: CL-Cookbook , CLISP , ILISP , and SLIME .
  • Gave a presentation Using Emacs as a Lisp IDE at the ILC2003 conference.
  • Wrote a Presentation Slide Generator in Common Lisp.
  • Contributed the articles Using Emacs as a Lisp IDE and Setting up an IDE with Emacs on Windows or Mac OS X to the Common Lisp Cookbook project.
  • Wrote an IE-specific XSLT tester to test XSL transformations.
  • Wrote a set of internet search tools to facilitate different types of common searches.
  • In February, 1995, my article "Hackers, Viruses, and Your AS/400" was published in News/400 Magazine . It showed how security can be compromised on the IBM AS/400 and what can be done to prevent this. When the article was first published by News/400 magazine, it was one of the most controversial articles in the magazine's history.
  • In June, 1994, News/400 Magazine published my article "Format a CL Program " which contained code for a utility to automatically format CL programs.
  • In 1990, wrote a program generator in C on an Amiga 500 computer - in part to learn the language and in part to fill a gap in the software available for that machine.
  • In 1989, developed a multi-media educational program for schools titled "Dolphins of New Zealand" that received a number of good reviews in New Zealand computer and educational magazines.
  • In March 1988, spent a week with Wade Doak (an oceanic researcher) recording and exchanging sounds with wild dolphins for computer spectrographic analysis. I am acknowledged in a couple of his books.
  • In 1987, after some contact with handicapped individuals, developed a "floating keyboard" (simulated in software) that could be controlled by a head-mounted joystick. Subsequently donated the software to a non-profit organization that worked with quadriplegics.

SKILLS/EDUCATION/AFFILIATIONS


  • Current skills: PeopleSoft EnterpriseOne/Enterprise, EAI, B2B, Web Services, SOA, Metadata
  • Current languages: Lisp, C, XSLT, Java
  • Speaker at the 2003 International Lisp Conference and multiple JD Edwards user group conferences
  • Former president of the Front Range IBM User's Group
  • Several articles published in News/400 magazine
  • MNZCS - Full Member (former branch committee member/meetings coordinator) of the NZ Computer Society
  • Post-secondary Education:
    • New Zealand Certificate in Data Processing (with honours) from Waikato Technical Institute
    • Completed one year at Temple University (Dean's List for academic achievement)
  • Academic Awards:
    • 1984-N.Z. Computer Society award for student gaining highest marks in 3 year NZCDP course.
    • 1982-Waikato Manufacturers Association award for top student in Computer Course.
    • 1982-Received top student awards for two consecutive years.
    • 1981-Received "A" bursary for results in first year of study at Waikato Technical Institute. This paid for subsequent years study for NZCDP.
    • 1972-Made "Dean's List" upon completion of first year at university.
    • 1971-During last year of High School, received academic awards including "Letter of Commendation" for achievements in scholastic tests, Rotary award and a scholarship to pay most of my university fees.


3882 Wonderland Hill Avenue, Boulder, CO 80304
Phone: 303-473-1941
Email: bill_clementson@yahoo.com
WWW: home.comcast.net/~bc19191/