RailCost™, a custom software application, was developed in collaboration with railroad industry experts to support evaluation and negotiation of rail freight rates for shipments of commodities. The application processes operating statistics collected from Class I railroads operating across the US and Canada by the Surface Transportation Board an independent federal agency. The package has been used by traffic departments of several Fortune 500 companies to better manage multi-million dollar freight shipment expenses.

The application captures time and material expended by client crews responsible for receiving, warehousing, shipping, and installing office furniture throughout the DMV. Data collected is used to support periodic billings of open jobs. As well, a monthly report is generated to compare revenue generated against calculated direct job cost for jobs closed within the timeframe covered; the information is critical to support manager evaluation and bonuses. An automated weekly interface to a third party payroll service eliminates redundant data entry and ensures accuracy of data in both the Job Cost and Payroll systems.

The system tracks expenditure of time and material necessary to complete road & infrastructure construction projects. An automated interface from a separate Job Estimate system provides initial detailed data load for each job; change orders are tracked throughout life of a job. Comprehensive reports support periodic customer billing in a format consistent with initial project bid.

Tracks participant work history, participant and employer contributions, plan receivables and historical changes to participant data. Calculates pension estimates for active participants using plan data and participant supplied parameters. Creates a monthly pension payroll with an audit trail to the previous month's payroll; retiree payments are made by direct deposit or by check. Vendor payments are generated as required. Cash Receipts and Cash Disbursements Journals are produced. Creates a series of files which provide the basis on which the plan's actuarial firm generates its analysis to support its yearly plan evaluation required by the Pension Benefit Guarantee Corporation (PBGC). Produces series of reports used by plan's accounting firm to support yearly audit.

Installation of packaged software for multiple clients to permit integration with Front Office (Marketing & Operations) systems. Modifications to standard packages made where appropriate. Installations have included Payroll, General Ledger, Accounts Receivable, and Accounts Payable modules as well as vertical market modules providing specialized functionality. Packaged software has included Client-Server based Microsoft DynamicsSL, Microsoft DynamicsGP, Peachtree (Sage 50), and MCBA Quantum.

Used to track over $ 65 million of office furniture moving through warehousing operationon a yearly basis. Furniture is ordered by DMV furniture dealers (client's customers), drop shipped from manufacturer to client’s warehouse, inspected, warehoused, and subsequently shipped to, and installed at, the site of the furniture dealer's end-customer.

Enables clients to assign and schedule personnel on installation or maintenance crews; permits “Mass Crew Assignments” to allow the same crew to be assigned as a team to additional jobs. Permits Employer to track “call outs”, personal days, and vacation days. Creates daily crew timesheet templates.

Database used to track preventative maintenance of construction machinery. Enables client to perform upcoming preventative maintenance when equipment is down for other service requirements. Reduces overall downtime of equipment and crews; permits more efficient use of equipment and maintenance personnel.

Enables clients to enroll students in various training courses. Tracks attendance and performance by class on a historical basis, and generates “Certification Diplomas” for qualified candidates.

Tracks membership history and changes to Membership Status; membership status options are table driven based on a given organization’s business rules. Revenue/Billing options include 1) calculation based on actual Member receipts by affiliate or 2) monthly calculation based total membership counts of affiliate. Cash Receipts application to outstanding balances can be made on an open item or net account balance basis. Provides automated interface from each affiliate to prevent redundant data capture; provides verification of affiliate data against national business rules to permit better management of affiliates and to ensure data accuracy across the broader enterprise.

Field office membership system providing functional requirements unique to national affiliate as well as classical membership functionality. Permits tracking and billing of membership status, purchase of products, and purchase of services including educational seminars and training. Application tailored to union requirements permitting a two way interface with employer payroll systems and with local health and welfare systems.

Enables clients to enter receipts by contributor as well as candidate contribution requests; additionally, distribution checks are created candidates' committees. Prepares monthly report to Federal Election Commission (FEC). Prepares periodic management report to permit review of PAC receipts by request campaign and to permit segregation of contributors by donation level for selected periods.

Tracks grievances with each International Union through various stages from initiation through resolution. Creates correspondence based on case data and table driven system parameters. Produces monthly reports for International Leadership.

Tracks scholarship applications including evaluation results returned from assigned reviewers. Data is used to support determination of applicant qualification and the subsequent issuance of scholarships to qualified candidates.

Tracks General President’s National Maintenance Agreements signed with participating contractors. Each job to which a given agreement is applied is tracked across the multiyear span of the agreement. Quarterly reports are generated to permit evaluation of each agreement.

Enables employers to submit detailed qualification requirements of specialized construction jobs unmet by local and regional pool of applicants. Requests are matched to pool of registered qualified candidates willing to relocate maintained in system database and referrals are forwarded to employers.