Terrence Johnson Email & Phone Number

Seattle, Washington, United States

Seattle, Washington, United States

Seattle, Washington

• Worked closely with operational groups to create insightful, actionable dashboards for Business Units, focusing on content for Marketing, Community Engagement and Bloodworks Bio.
• Partnered with Community Engagement, creating dashboards allowing them to effectively manage various donor engagement programs, and measure the success of each program.
• Created robust dashboards for Bloodworks Bio’s Cord Blood program, visualizing cord blood collections, successful uploads to the national cord blood registry, and visualizing discards, enabling the collection.
• Developed flexible Tableau dashboards for Community Engagement to dynamically create donor lists based on blood type, location, and availability, greatly increasing the effectiveness of their donor outreach efforts.
• Created outward-facing Tableau dashboards for the CEO for the impact specific local business have when hosting mobile blood drives, allowing him to effectively engage companies for their continued support.

Seattle

• Assumed all payroll reporting allowing for a smooth transition due to a sudden vacancy. Streamlined the overall process, while improving accuracy and reducing turnaround time.

• Created the Line of Business Profitability reports for each specialty within the clinic.
• Streamlined and implemented numerous improvements to the reporting templates, reducing the number of files from forty files to seven.
• Streamlined the Physician Compensation Model.
• Created numerous Excel Macros to automate time-consuming tasks.
• Worked with Practice Managers to create all five-year projections for new physicians.
• Created production files for the annual budget, as well as the physician compensation components of the budget, working with Practice Managers to develop the budgets for new projects and new physicians.

• Prepared all contracts for customers’ review and approval. Followed through with sales leads, serving as the initial point-of-contact for new clients. Completed all Financial Controller responsibilities for the.
• Streamlined the weekly accounts payable process, using Excel and QuickBooks to reduce data entry.
• Created new sales reports and analyses for the owners of the company.

• Created Excel-based models to set wholesale and retail rates for Electronic Data Systems’ telecommunications service offerings.
• Developed and deployed of an Activity Based Management System.
• Developed and implemented a new, Excel-based outlook-forecasting tool to increase efficiencies in the monthly financial outlook process.
• Designed, created, and implemented an Activity Based Management system using PowerBuilder and an Informix database.
• Created all graphical user interfaces for application menus and online reporting.
• Prepared Capital Appropriation Requests for mainframe computer hardware requiring EDS’ Finance Committee approval.