Craig Rutter

Freelance Accountant & Database Expert

Location:Portland, Oregon, United States
2 Skills
Multnomah County, Portland, OR, Senior Data Analyst 3/15 Present
? Work directly with stakeholders on custom reports, using SQL and Crystal Reports
? Modify and Create SQL code based on need
? Rewrite Crystal Reports using SQL stored procedures instead of direct database tables/views.

Independent Consultant, Portland, OR 12/14 Present
? Work directly with Viewpoint Software customers on custom reports and data projects, using SQL and Crystal Reports
? Modify and Create SQL code based on need

Business Information Group, York, PA, Development Consultant (Software) 11/14 ­ 12/14
(Software development company, worked remotely)
? Work directly with stakeholders on custom projects, both reports and data projects, using SQL and Crystal Reports
? Modify and Create SQL code based on need

JR Merit, Vancouver, WA, Reports Specialist 1/14 ­ 10/14
(Viewpoint Client)
? Work with stakeholders on reporting requirements
? Design and create reports based on need
? Create SQL stored procedures, views, indexes and triggers as needed
? Maintain IT and Software support

(Planned Sabbatical)

Viewpoint Construction Software, Portland, OR 10/01 ­ 09/13
Conversion Specialist, Report Writer
? Performs data mapping from legacy database to Viewpoint database.
? Codes and manipulates data using Microsoft SQL scripting
? Maintains Microsoft SSIS package(s)
? Communicates with Customer during ongoing conversion activities
? Monitors, tracks, and documents conversion activities in CRM system
? Meets scheduled project timelines
? Perform product design, bug verification, release testing and beta support on application software projects
? Track the status of assigned project tasks to insure timely completion, maintains communication with stakeholders regarding progress of work, and notifies appropriate parties when open issues have been resolved
? Create SQL Stored Procedures, SQL Views and Common Table Expressions
? Train customers on how to create their own reports
? Assist in customer phone support for reporting issues

Various Short ­term Contract positions, Portland, OR: 11/99
Central Bethany Development
Staff Accountant

? Correct improper Job Cost setup and fix cost transactions in Timberline Software
? Reconciled monthly multi­-company general ledger
? Developed customer queries in MS Access.
? Created Accounting procedures for home owners’ association
? Reconciled $15M in project costs in order to break it out into three separate assets

Maxim Group, Report Writer

? Developed 20 ad hoc Crystal reports for Clark County’s(Vancouver, WA) new Permits
and Fees software system.

2 Degrees, Assistant Controller for Benchmade Knife Company.
? Daily cash management, Month­ end Journal Entries, G/L Reconciliations, A/P and A/R
reconciliations, Update Fixed Assets and Depreciation.
? Created an Excel spreadsheet to track royalties paid to patent holders for each knife

Resource Connections, Project Accountant for LNR Affordable Housing

? Performed Cash reconciliations on partnership bank accounts.
? Compiled monthly draw packages and submitted to corporate office for payment.
? Conducted financial reviews on various properties on a need be basis.
? Reconciled a $30M project that had costs intermingled between four buildings.

Assisted Living Concepts, Inc., Portland, OR, Senior Corporate Accountant 12/97­ - 11/99
Senior Corporate Accountant
? Conduct monthly budget reviews on 63 facilities.
? Compiled financial statements for two of five regions (63 facilities).
? Job Cost accounting on the construction of new facilities in eleven states.
? Created a Crystal report that reduced the time to reconcile Job Cost from 10 hrs to 2 hrs.
? Supervised seven employees within the Accounting Department.
? Go-­to-­person in the Accounting department on Crystal Reports, FRX and SQL.
? Active role in two Accounting software conversions. Worked closely with consultants and created verification reports to test database integrity.

DRG and Associates, Inc., Vancouver, WA, Timberline Consultant 4/96­ - 11/97
? Participating in various software conversions.
? On­site training in Timberline software.
? Designing reports and inquiries, using TS Report Writer and Crystal Reports.
? Telephone support for Timberline and other software applications including Crystal Reports
? Installed, taught and created reports for 3rd party purchase order software program that imported purchase orders into Timberline.
? Created an Accounts Receivable Aging report for a customer that used a text file as it’s source. At the time this was a huge deal.

Denis Della Vedova, Inc., Iowa ($27 Million Commercial, GC), Controller/Network Admin 7/93 - ­4/96

? Created monthly Financial Statements
? Job Costing (comparing budgets to actual costs and tracking change orders)
? Created all Billings and submitted to owners.
? Acted as liaison between Accounting and Estimating.
? Instrumental in setting up Purchase Order system which reduced accounts payable coding by 50%.
? Daily cash management, helped increase cash reserves by $1M
? Set up and connected PC’s to the network/monitored the network and performed back­ups.
Bachelor of Science in Accounting
Northwest Missouri State University, Maryville, MO May 1992

Software Knowledge:

Viewpoint Construction Software, Microsoft SQL, Crystal Reports, Microsoft Integration Services, Microsoft Excel, Access and Word, novice on SSRS.
Skills (2) Rating