Solutions Automated Company-Wide Gmail Signature Blocks BUSINESS PROBLEM Our client valued consistency in branding within email. Concerned that employees creating their own signature blocks in email would result in branding conflicts, KilPen was consulted to develop a company-wide signature standard in Gmail. OUR MISSION Using Gmail and Google Cloud Console, KilPen needed to develop a technical
Solutions Google Sheets Data Aggregation BUSINESS PROBLEM Our client identified significant waste related to employees manually updating Google Sheets that fed business critical decision making information. The client operated in a projectized environment with one Google Sheet per project. With a portfolio size of 150+ simultaneously executing projects, executive leadership needed a way to aggregate
Solutions Image Conversion Using API BUSINESS PROBLEM Our client needed to produce 1,000+ images using an image creation tool. The images exported from the tool in PNG format, but a TIFF format was needed. Doing this conversion by hand would take considerable resources. OUR MISSION Develop an automation tool that would integrate into the
Solutions Gate Review Risk Management System BUSINESS PROBLEM Our client expressed concerns about poor product quality exiting their product development workflows. Due to the nature of their business model, many contributors play a role in development and the quality of their contributions vary. OUR MISSION Using Google Workspace, develop a process and supporting tool to enable
Solutions Motor Pool Vehicle Maintenance System BUSINESS PROBLEM Our client operates in a tight margin industry where budget wasn't available to purchase a commercial vehicle maintenance tracking tool. With growth in their business, tracking vehicle maintenance and licensing requirements became more and more difficult. A centralized tool was needed to help retrieve service and
Solutions Project And Vendor Management Tracking BUSINESS PROBLEM Our client, a small business start-up company, utilized a business model where independent contractors provided services on a project basis. The contractors work on short term projects that build the company's product. The current commercial software products available on the market exceeded cost allowances. This business