Colin Sachs Email & Phone Number

United States

Primarily focused on coordinating budget activities within the Public Works Department for both Operations and Capital Projects, interfacing with leaders and staff to solicit information for setting biennium and project budgets as well as preparing related documentation for submission to the finance office for all things budget related from initial budget requests, to supplemental and amended budget requests. Also active in fund management and monitoring, financial transaction adjustments, capital improvement program model management, reporting out specific data from various systems in finance, permitting, and timekeeping to managers, supervisors, and staff, as well as facilitating and assisting with various analytical needs and managing the departments APWA accreditation process.

Seattle, Wa

Analyst Reporting IV within the Single Family Lending group involved documenting existing data extracts and report procedures, designing/executing and distributing reports focused on single family lending portfolio management and customer support needs, converting reports from BKS Passport to Microsoft Reporting Services and upgrading reports to run in upgraded Microsoft SQL and Reporting Services environment as well as involved in process improvements for automated and self-access reporting and on-going documentation of data tables and data dictionaries.

Seattle, Washington

Customer Analyst (Senior Systems Analyst) for the City of Seattle's Summit Re-implementation Project (SIP) working on the team to move the City from PeopleSoft 8.8 to PeopleSoft 9.2. Primary focus of activity is on developing standards for customer contacts and addresses for the system to act as the "master record of customer contacts and addresses." Lead for drafting standards and involved in data standardization effort, deactivating dormant records, cleaning up non-standard record formats, and the removal of duplicates, as well as developing criteria for the determination of within-department duplicates and between-department duplicates. Temporary assignment.

Seattle, Wa

Analyst for Student Fiscal Services'​ within Financial Management at the UW. Responsible for a variety of tasks in a team oriented environment, including:* Developing, maintaining and evaluating dashboard metrics/measures/KPIs for process and quality control, and Lean management* Assisting and training SFS staff in the development and maintenance of individual process measures * Originating quarterly and annual reports for senior management* Providing draft input on annual and biannual budget and performance reports* Crafting queries in tSQL using MSSMS, MSBIDS, Visual Studio and Access* Analyzing data extracted from UW's enterprise data warehouse, financial data cubes, in-house SFSdb, legacy FoxPro database, and other UW internal and external data systems using Excel,Tableau or orther reporting tools* Writing and delivering electronic reporting in MSRS, Excel, Word, and hyperlinked PDFs including analysis reports, data reports, and raw data extracts for SFS, UW and external audiences* Acting as business analyst for various projects which have included an Invoice Receivables system, a Scholarship Database system, a Website, and CRM software* Developing and maintaining unit Balance Scorecard Dashboard report (discontinued in 2013) consisting of KPIs and performance metrics for core operational areas and appendix data table* Designing, delivering, analyzing results, and reporting out annual Student Satisfaction Survey in partnership with the Customer Service team* Supporting the Director, Assistant Director, and Managers as part of the Leadership Team by providing insights into business operations, data, analysis, and feedback during team meetings* Assisting in implementing Lean and visual boards across all units as part of a SFS Lean team* Providing student and international student tax assistance* Shepherding SFS's sustainable business practices aligning with UW's sustainability goals resulting in 5 Silver Green Office certifications

Bellevue, Wa

Consultant with a strategic IT management consulting firm specializing in governmental and educational organizations. Responsible for:* Developing winning RFP responses with project budgets ranging from $50K to $500K* Conducting client-facing management interviews and staff focus groups on client work sites* Developing/refining tools, and conducting analysis, for IT staffing, budget, technical infrastructure, and business application portfolio assessments* Drafting reports and presentations and turning draft-to-final versions incorporating client and team feedback* Conducting market research on products and services which would meet client needs and to stay abreast of changes in the marketplace on products and services that may impact current or future clients* Developing cost-benefit analysis models of varying complexity to meet client needs with clearly specified assumptions using Excel * Acting as technical lead for company SBS 2003 server, office data network, and web site, interfacing with external service providers as required -- including implementing and securing the companies Wi-Fi access points* Reigning pinball champion at time the pinball machine was sold during an office renovation

Seattle, Wa

Implemented a two year Bill and Melinda Gates Foundation “Community Access to Technology” grant project to provide computer literacy and employment readiness training to low-income tenants of Plymouth Housing Group properties. This involved creating a handbook for lab operations and training, seting guidelines for appropriate use of equipment, training tenants of properties, recruiting and managing volunteers, and coordinating activities with case workers and property managers to better assist tenants stay in housing.

Pullman, Washington

Provided technical leadership, planning and oversight of the Intensive American Language Centers' faculty and administrative computing systems, instructional computer labs, web sites and servers, in alignment with internal curricular and pedagogical requirements, and University policies and procedures. Also provided ESL instruction in all skills areas to international students from beginner through advanced for both undergraduate and graduate study preparation, teaching up to 18 contact hours per 8 week session.

Ma, Linguistics

Activities and Societies: Conducted research into lexical and morphological processing; TA in TESL at Sunnyside Elementary School; tutored.

Bs, Interdisciplinary Studies

Activities and Societies: Student newspaper (layout, writer); Medieval Guild; Peer Tutor (Logic, Philosophy, Psychology); Film Club.