Applied Software Technologies





















As of  2011/04/12

Competitive Retail Leader

(20 Months)

Data conversion analyst on conversion from multiple legacy systems to Microsoft Dynamics 2009.  Tools used include:  SSIS as an ETL, VB.NET, and migration tools in general.

Higher Education -  University

(38 months)

Project steward of selected Financial and HCM modules in Peoplesoft 8.0 to 8.9 environments.

Surface Mining Leader

(14 months)

Wrote SQRs and INCludes for conversion from legacy systems to AIX DB2.  JDE report writer also used.
JDE financial and production systems

Data Warehouse Leader

(8 months)

Wrote SQRs and INCludes for profit and cost centre accounting.  Published reports to the web for world wide use.
SAP financial systems to Brio Portal (complete web enabled)

Telecommunications Leader

(2 months)

Subsequent to attendance at the Brio user convention and completing the Brio.Portal tutorial, for this competitive local exchange, added OMR (optical mark recognition) bar codes to their Daleen Billplex invoicing software using SQR and postscript. Also made modifications to SQR based business logic using remote SQR development factory.

International Airline

(7 months)

Wrote general designs, detail designs, SQRs and PeopleCode for a legacy pension and payroll system to PeopleSoft V7 and Penfax conversion.

Telecommunications Leader

( 10 months)

Provided evolutions and maintenance support for a Human Resources/Payroll V5.11 system including:

  • job retroactive processing for union contracts;
  • V5.11 to V5.12 Cobol change identification;
  • PeopleSoft to SAP conversion SQRs; and,
  • Year-end processing.

Automotive Assembly Plant

( 2 months)

Wrote technical specifications to convert legacy system AP, PO, and Inventory system data to PeopleSoft financials.

Large Regional Hospital

( 7 months)

Converted legacy system data and provided technical leadership on implementing Human Resources/ Payroll and Benefits. This also included:

  • union time input information from a Matrix system;
  • customization of multiple panels, process scheduler, and related run controls; and;
  • IT staffs training.

Consulting Development Shop

( 5 months)

Wrote over 30 custom SQRs and quality accepted and tested off-shore developed SQRs for financial systems including: GL, AR, and AP. Maintained SQRs from home based software factory in Nashville, Denver, Chicago, San Francisco, Singapore and Boston. Using internet, Buddy, CoSession, Lap Link, and MSNet.

Conversion to PeopleSoft

Assisted 7 firms to convert to PeopleSoft from many different legacy systems.

About DSS | Products & Services | Clients Only |USA Computer Consulting

White Papers | SQR | Home

John Willson 2011/04/12