John Dlugosz Email & Phone Number

Denver, Colorado, United States

• Created and implemented a new Digital and Innovation forecast file using Google Sheets.
• Built Digital forecast file with additional functionality to view project spend and capital send.
• Collaborated with accounting to find $1.6M in accruals that were reversed in Digital.
• Inherited Data & Analytics, CTPO, and CIO forecasts when an employee transitioned to accounting.
• Worked with project managers and accounting to identify and resolve labor allocation issues
• Process bi-weekly CHI payroll headcount file so FTE’s can be included in Finance forecasts.

Denver, Colorado, United States

• Redesigned heritage Dignity Health IT maintenance report to include heritage CHI.
• Worked with the business and Deloitte to clear $1.5 million in again Deloitte invoices, 46 days or older.
• Joined IT contracting and procurement’s triage call to assist with RITM’s for legacy CHI.
• Created a new process to reduce the number of tickets a requestor needs to submit to get signature/PO.
• Reviewed quotes and compared with last year to determine if the increase was acceptable.
• Assisted business with PO creation and maintenance of Pyxis ES monthly support from CE to pharmacy.

Englewood, CO

• Would reconcile Monument consulting invoices weekly to ensure that consultants were not over billing for their expenses.o Report was sent to management and AP to pay the invoice.
• Use passed Monument invoices, to predict the first weekly invoice amount of the month, so that AP can accrue for the expense.
• Use SAS to consolidate PO files and developed a report that shows PO commit, PO spend, invoices charged to PO and amount left on PO.o The PO file was used to help management forecast future spend based on historical.
• Use PO data to create Ad Hoc reports to present in management meetings on short notice.
• Coordinate meetings with Managers, Directors and VPs to discuss their outstanding PO’s.
• Work with AP to insure vendors are paid on time when a PO is attached to their invoice.

Englewood, CO

• Sorted through 1,000’s of records to identify maintenance invoices.o Developed a template using excel and VBA to load maintenance information into Service Now.
• Worked with internal sourcing and negotiation team to get new contracts and cancel existing contracts.
• $6.1 million in found savings due to cancellation of unused maintenance contracts.
• Provided guidance to Business Owners on PO process to ensure the vendor gets paid and the maintenance is uninterrupted.
• Created documentation, swim lanes and RACI charts to explain the importance of how this role effects the whole organizations profit and loss.
• Supervised contractor to review contracts between CHI and vendor.

Greater San Diego Area

• Forecasted and allocated projected global inventory for test equipment required for engineering testing.
• Collaborated with Project Managers to collect and submit forecast for budget approval for new projects.
• Extracted department data from corporate tools to provide weekly test equipment allocations to Project Management.
• Used advanced data mining functions to pull data from separate data bases into a single spreadsheet and generate Ad Hoc reports to present to upper management.
• Extracted data sets with ~40,000 lines to conduct high level analysis to present to upper management.
• Oversaw million-dollar lab recycling efforts to reuse phone screens in manufacturing of new hardware.

Greater San Diego Area

• Distributed internal hardware from stockroom with 600+ devices valued at $2.5 to $5M.
• Managed shipping logistics for test hardware to domestic and international internal teams.
• Implemented change in storage of internal hardware improving space efficiency in the stock room by 50%.
• Used corporate tools to procure $1M worth of accessories for engineer testing needs.
• Identified and developed organizational performance metrics used to improve department processes.
• Created reports and presented to leadership and Project Management on quantities of test equipment to ensure program needs are meet.

• Managed client database, including client information and prioritizing client needs.
• Collaborated with the IT team to improve database functionality and organization.
• Reported to the Sr. Customer Service Manager providing financial information including daily margins and data entry status.
• Identified innovative solutions for improving database functionality, reducing data entry time by ~5 hours per week.
• Formulated new email templates in response to emergent client issues.
• Process and input 100s of new orders into corporate system, handling check and credit card numbers.

Greater San Diego Area

• Processed and input 100s of new orders into corporate system, handling check and credit card numbers.
• Operated with a Service Level Agreement that work is to be completed within 24 hours of receipt.