Matthew Scheff Email & Phone Number

Portland, Oregon Area

· Performed custom database development to create and/or support custom processes or business logic within the Viewpoint Vista and Keystyle platforms· Designed and implemented custom stored procedures and triggers, SSIS packages, deployment scripts, database objects, and end-user documentation related to database solutions and customization projects.· Built, maintained, and monitored development servers and databases for use by database developer group as both server and database administrator· Managed custom database development projects from initial business requirements, estimating, development, testing, and through implementation

Portland, Oregon Area

· Used and built tools to monitor database activities and performance: custom constraints, alerts, and maintenance tasks.· Facilitated data clean up and historical data migration projects via custom T-SQL scripts and database objects.· Built, monitored, and maintained database infrastructure to support ERP and reporting systems.· Designed, built, monitored, and maintained a self-service reporting environment in collaboration with users and Business Analysts.· Designed, built, and maintained automated mechanisms for extracting, transforming, and loading data from disparate sources.· Implemented and maintained security schemes in collaboration with Data Architect.

Portland, Oregon Area

· Analyzed SQL data using complex T-SQL queries + SQL Profiler and debugged stored procedures and triggers to isolate software issues in Vista enterprise ERP software and related databases.· Identified and documented 20+ SQL/.NET software issues per year via testing and troubleshooting for use by Development in research and resolution of defects.· Corrected customer data using SQL modification statements while handling 500+ support cases per year.· Cooperated with colleagues on implementation and maintenance projects of multiple in-house Support database instances on a regular basis as new software/database versions were released.

Atlanta, Ga

- Provided remote and onsite support of Sage 100 ERP software and related technologies to smallbusiness customers by addressing procedural and technical questions, errors situations, product updates, and troubleshooting scenarios.- Generated revenue while fulfilling customers’ business needs as a consultant for ERP system upgrades, custom scripting and modification, and changes to Crystal forms and reports.- Monitored, tracked, and documented customer support cases, projects, and related activities in CRM system.- Assisted other departments with application issues, development, QA, and network/server issues.- Performed data entry and related accounting tasks in Accounts Receivable, Accounts Payable, Sales and Invoice, and Bank Reconciliation areas while conforming to generally accepted accounting principles.

Aki City, Kochi, Japan

Aki City Board of Education- Planned and taught English classes with native Japanese school teachers at 5 public elementary and 2 junior high schools.- Worked with teachers of the Education Research Institute of Aki City to plan, organize, and implement regular classes and special English language-focused events for students and school teachers.- Prepared video clips of English vocabulary for use in elementary schools.- Worked closely with teachers at a pilot school for the 2011 change in English language curriculum in elementary schools throughout Japan.

- Facilitated the design, coding, implementation, testing, and maintenance of 6 major Program Area database applications.- Advised changes and updates to existing ASP reports as part of the Crystal Reports Implementation project.- Utilized SQL database knowledge to develop and implement queries for application development and testing.- Upgraded and configured existing Oracle suites to 10gR2 on multiple workstations throughout FDEP.- Provided feedback, input, and status updates for various system development projects during weekly meetings.

- Worked closely with Data Processing Manager to provide knowledge and assistance to computer users throughout the Central Office as a contract member of the PC Support Team at the Florida Department of Corrections.- Instructed and advised users in the operation and maintenance of essential technology equipment.- Researched and coordinated technology evaluation reports concerning new equipment acquisitions and installations.- Played key role in documenting and tracking technology inventory for yearly audit of inventory for the Central Office.

Provided computer and network support services to 800+ faculty, staff and student body at FSU's College of Law.Coordinated use and availability of audio-visual equipment in a variety of classroom and meeting room locations.Assisted students, staff, and faculty with day-to-day problems ranging from simple hardware/software issues to demanding network and database projects. Performed Domain Administrative functions in Active Directory, including adding new users, modifying user permissions, and other domain maintenance functions.

B.S, Multinational Business Operations

Bachelor Of Science (B.S.), Management Information Systems, General