Working for Gap I quickly identified opportunities for growth in efficiency's of the Digital Artist workflow. Our legacy process included manually converting PSD files to other file types. Every 25 PSd's took roughly 15 minutes to convert. In addition the user would have to drop these files to an external server manually.
Partnering with my team and brand including Users, Management, and Sr Management we secured hardware resources to create an automated server that would convert files and deliver them. I conceptualized, learned applescript, developed, engineered, delivered, and provided maintenance for this tool.
The workflow is written in applescript and based on modification date triggered scripts. Each script runs independently of one another. If the modification date of a folder has changed the associated script will run. See the chart above for efficiency gains.
With Digital artists processing hundreds of assets per day per person we saw actual time savings of an hour a day per user of the server (avg of 20 hours of daily downtime saved). This workflow is used across multiple brands.
Leading marketing retouching is half project management and half retouching.
In order to minimize staffing requirements and workflow "crunches" we needed a tool that would help us track and deliver projects. However this tool also needed to help us forecast workflow by testing throughput & timeline solutions against budget limits. Retrieving the data necessary to create this tool meant regular interfacing with production, creative, and photography teams.
I created a google spreadsheet to track deliverable dates as well as metric data for fiscal seasons. Further incorporated into this spreadsheet is a formula providing the number of retouchers required to deliver a project. This formula takes into account how much needed to be done vs what was completed, the number of business days (excluding holidays) between the current day and the due date, and lastly the ratio of how many images could be done per day.
In the graph above the red line "R" shows how many retouchers would be needed to complete the work for the season. The best part about this data is that it live updates based on the current day and the current workload.