Computer Systems Consulting

Sample Projects

Developed for Analog Devices, Inc

• Worldwide Manufacturing Forecast and History Analysis.  Collect data via online form input and import from other systems at multiple planning sites worldwide.  Consolidate data via import process.  Sophisticated reporting and graphing through user defined reports.  Users define and save named reports specifying: type of data in each column; report format including grouping and totaling; filters; report title.  Supports “Save As” function to duplicate and modify existing reports.  This database is tracking 36,000 entries per year.
• Worldwide Incoming Quality Control Testing Analysis.  Collect data via online form input at multiple inspection sites worldwide.  Site data uploaded to central database with one button click.  Reports and graphs include: Summary and detail inspection data with parts per million (PPM) failed and number of problems encountered; Outstanding Corrective Action Requests; Failure reasons.
• Manufacturing Process Status and Internal Price Quoting.  Entry and maintenance of manufacturing process status information.  Automatic update of order processing system process status.  Entry and storage of subcontractor pricing for wafers.  Company-wide price quoting for subcontractor manufacturing of wafers.
• Employee Bonus Planning.  Entry of department bonus plans through distributed databases.  Consolidation of company-wide bonus plans.  Import of employee data from HR system.  Adjustment of bonus plans.  Print management reports.  Create payment text file for payroll processing company.
  
• Salary Survey Reporting.  Import salary survey data.  Report on comparisons of Analog salaries vs. market.
• Employee Stock Option Planning.  Entry and maintenance of employee grant data.  Import of employee data from HR system.  Entry of division grant recommendations through distributed databases.  Consolidation of division grant recommendation data.  Reporting on grant data and recommendations.  Export of stock option grant data to Stock Option system.

Developed for Raytheon Company, Corporate Treasury

• Companywide Bank Accounts.  All pertinent information on all bank accounts.  Reporting on bank account status.  Automatically print letters to banks when changes are made on accounts.
• Letters of Credit.  All pertinent information on letters of credit.  Reporting on status of all outstanding letters of credit.  Automatic generation of check requests for payments due.  Automatic update of central accounting system for payments made by direct debit.  Report of combined data from Letter of Credit and Surety Bond databases.
• Surety Bonds.  Entry and maintenance of surety bond data.  Reporting on surety bond status and history.
• Commercial Paper.  Daily import of commercial paper data from bank.  Reporting on all aspects of outstanding commercial paper.
• Receipts / Disbursements Forecasting.  Distributed databases at all reporting locations for entry of cash reports.  Weekly consolidation of all cash reports into central corporate treasury database.  Reporting and charting of quarterly forecasts and comparisons of forecast to actual.
• Funds Transfer.  Entry of funds transfer requests through either Access or Web front-ends (Web front-end developed by Raytheon).  Treasury approval process for transfers.  Export of transfer data to bank.  Import of transfer status data from bank.  Extensive reporting on transfer history.
• Foreign Exchange / FAS 133.  Entry and maintenance of trade data.  Trade settlement with printing of settlement instructions and automatic creation of funds transfer requests (integrates with E-wire database).  Extensive reporting on trade status and history.  FAS 133 reporting with end-of-quarter accounting entries automatically calculated.  Data exchange with FXall online trading system.
  

Developed for Raytheon Aircraft Company

• Aircraft Resale.  Maintain and report on specifications of all aircraft in inventory.  Report on cost of aircraft in inventory.  Search for aircraft in inventory based on multiple characteristics.  Deal processing for single and multi-aircraft deals.
  
• Loan Amortization.  Import loan balances and conditions from loan management system.  Report on cash flow for the life of the loans, filtering on multiple loan characteristics.

Developed for Taramark Title Company, Inc

• “Request for Title Work” Management System.  Entry of requests for title work (similar to order entry).  Automatic faxing and emailing of requests and outstanding work reports to examiners.  Mapping of properties from requests.  Reporting on all aspects of outstanding requests.  Import of client and vendor information from accounting system.

Developed for G. T. Reilly and Company

• Contact Management and Mailings.  Entry of all client and referral information.  Printing of mailings labels for multiple mailings per contact.  Contact query and mail merge to MS Word.

Developed for Be Our Guest Inc.

• Order Processing, Billing, Shipping, and Inventory Control.  Entry of orders for party equipment and linen rental.  Printing of orders, shipping documents, and invoices.  Reservation and overbooked item reporting.  Entry of non-A/R payments (prepayments & COD).  Physical inventory counting.  Customer contact tracking.  Lost item tracking.  Daily export of customer and sales data to accounting system.  Receive delivery status data form drivers’ cell phones via CometTracker database and display delivery status.  Email order documents to customers as PDF files.

Developed for WebDialogs

• Web Service Billing.  Entry and maintenance of customer, product, and fee data.  Import of Web usage transaction data.  Automatic creation and printing of customer invoices.  Export of sales data to accounting system.  Customer, product, and billing reports.
  

Developed for Century Color Company

• Batch Order and Billing System.  Entry and storage of formulas for manufacturing of printers’ ink.  Entry of orders and printing of batch tickets for manufacturing.  Automatic creation of invoices based on purchase order number.  Printing of invoices.  Export of sales and cost data to accounting system.
  

Developed for Sentry Electronic Products, Inc

• Inventory Data Export.  Import inventory data from Peachtree Accounting database and create text and DBase files for sharing inventory availability information with other electronics parts distributors.
• Consolidated Inventory Query.  Import inventory availability data from other electronics parts distributors and consolidate with internal inventory data.  Used by sales staff for online inquires.  Includes: lookup on partial part number; drill down to detail data; automatic lookup of substitute parts; customers’ account status and sales history.  This database includes 500,000 items and is growing.