Data/business analysis, process documentation & automation

DAVID DORIS

Bellevue, WA ***** *******@**.*** 206-***-**** www.linkedin.com/in/david-doris

PROFESSIONAL SUMMARY

Results-driven Business Process professional skilled in creating and implementing process improvements, documentation, and productivity enhancements. Effective reducing flow times, presenting large volumes of data in easily understood formats, and explaining business model. Successful defining and implementing new strategies. Strong interpersonal skills leveraging partnerships with project managers, analysts, and cross-functional teams. Technically proficient in T-SQL, SQL Server, Database Design, ASP.net, C#, Access & Excel VBA, JavaScript, MS Project, Earned Value, SharePoint, and Visio.

CORE PROFICIENCIES

Data & Reporting Process Automation

Database Development

Productivity Improvements

Strategy Definition & Implementation

Requirements Gathering & Analysis

Cross-functional Team Collaboration

Cost & Schedule Reporting

Project Management

Process Documentation

Data Visualization

Web Development

PROFESSIONAL EXPERIENCE

PROJECT MANAGEMENT SPECIALIST Boeing Company 6/2023 to present

Data Analysis identifying cost / schedule variances, preparing & executing facilities plans

Define documentation framework for preventive maintenance project

PROGRAMMER / SYSTEMS & DATA ANALYST Boeing Company 5/2022 to 6/2023

Assembled Resource Plans & forecasts, ad hoc reports for senior managers. Investigate cost & schedule variances.

Developed scripts, negotiate test plans, and provide data analysis supporting system deployments and upgrades.

HEALTHCARE INTELLIGENCE ANALYST Valley Medical Center 10/2021 to 1/2022

Developed & maintained reports for Finance, Supplier Management, and Human Resources with Infor CloudSuite and Birst applications during ERP deployment. Gather requirements, troubleshoot & resolve tickets for users.

BUSINESS SYSTEMS ANALYST DISYS (T-Mobile) 9/2021 to 10/2021

Documented bankruptcy & collection processes to identify process improvements

PROGRAMMER ANALYST Boeing Company 10/2018 to 7/2020

Led process documentation for cross functional team implementing Oracle-based defect reporting system. Documented user and data requirements. Identified and eliminated process breakdowns, developed flow charts supporting test driven development, built SQL queries for unit and integration testing. Built interactive reporting website for subject matter expert organizing work statement for offshore team.

Replaced outdated, error-prone process requiring analysis of dozens of emails to identify errors, developing a website to provide daily status reports on raw materials ordered. Mitigated existing process failures, which in one case left 1000 production employees without work for days. New process has never failed.

Continuously implement innovative and reliable time-saving processes and applications including a server modernization project to securely transfer files in C#, and a secondary project to extract, transfer, and load data into downstream systems utilizing C# and VBScript.

Selected contributions:

Slashed flow times by over two thirds, implementing innovative storage procedures and delivering significant improvements through data gathering and reporting process enhancements.

Cut development times by half and improved application performance 33%, leading a modernization project replacing manual processes with data driven web site featuring customized interface components.

Significantly reduced labor costs by two thirds, documenting business rules and defining test and verification processes to transfer work to offshore programming teams.

BUSINESS PROCESS ANALYST Boeing Company 09/2012 to 10/2018

Increased productivity over 33% training Supply Chain analysts to operate ERP LN and data mart reporting process. Documentation included step action tables, user guides, desk procedures, and process charts.

Drove improvements to standardized inventory data collection and reporting for logistical companies, executing detailed business analysis to identify details of data requirements.

Coded change management, daily and weekly task reporting, and provision policy websites, creating interactive SQL-based webpages with capabilities to add, change, and delete user stories and data.

Collaborated on website development to improve communications, leading interviews with project managers, SMEs, and users to automate and simplify processes and reduce flow times.

Selected contributions:

Slashed 250 labor hours annually, removing manual distribution of a weekly report and replacing same with a scrolling news ticker on website.

Reduced reporting process time by two thirds through creation and implementation of a Change Management website replacing existing paper forms with intuitive interface elements.

Enhanced metrics for cross-functional teams, generating integrated Tableau workbooks in place of physical data gathering and circulation to provide up-to-the-minute interactive cost-benefit reports.

Improved user input process, simplifying daily and weekly task reporting through website.

Developed streamlined data collection and distribution website, saving 200 annual labor hours and improving data access.

STAFF ANALYST Boeing Company 12/2011 to 09/2012

Performed analysis of data related to existing systems, labor, operations, sales, and procedures to develop a global overview of operations and identify gaps and areas in need of attention.

Tracked performance data against established training, equipment, and workforce requirements and budgets.

Selected contribution:

Leveraged subject matter expertise in analysis and development of improvement strategies to identify issues, enhance productivity, and eliminate redundancies to improve company’s bottom line.

FINANCE ANALYST Boeing Company 05/2010 to 12/2011

As MS Office Developer and Enterprise Improvement Portfolio manager, delivered vital support on governance, portfolio management best practices, Earned Value, and tool management, also developing standardized processes.

Held sole ownership for coding and testing deliverables, also executing business analysis to determine and document data requirements and processes.

Selected contributions:

Significantly improved forecast accuracy by 50% facilitating team investigations of spending patterns to identify problem areas, also contributing to mitigation and solution strategy development.

Reduced report flow time by 85% for a portfolio of 60 improvement projects, standardizing monthly budget and actual templates, automating data collection and portfolio reporting processes. Forecast accuracy improved by providing an additional 4 days to monthly cycle to identify projects needing attention.

EDUCATION AND TRAINING

Bachelor of Arts in Business Administration, University of Washington, Seattle, WA

Master’s Degree in Public Accounting (Taxation), University of Washington, Seattle, WA

Contact this candidate