The Doe Run Company needed help automating many of the Project Management Organization (PMO) functions that were being performed manually and with spreadsheets. These functions included the project initiation and funding approval process, portfolio reporting and management, and capturing data at project closing. Innovative-e assessed the situation and helped the customer implement a Business-Critical SharePoint (BCSP) solution that will result in greater productivity and improved financial rate of return for the customer.
Innovative-e helped The Doe Run Company create a Business-Critical SharePoint solution by helping the customer implement the AFE business process an d forms in SharePoint
The Doe Run Company is a privately held natural resources company in St. Louis and is one of the largest integrated lead producers in the Western Hemisphere. Dedicated to environmentally responsible mineral and metal production, Doe Run operates one of the world’s largest, single-site lead recycling facilities, located in Boss, Mo. The Doe Run Company and its subsidiary deliver products and services necessary to provide power, protection and convenience.
The Doe Run Company was already using SharePoint 2010 for project team collaboration but wanted to streamline the AFE process using SharePoint and wanted to ensure that all team members were aware of the most recent status of the AFE. When Innovative-e, a Microsoft partner, made its assessment of The Doe Run Company’s needs with regard to their AFE process, it was determined that the manual processing of the AFE spreadsheet was cumbersome and inefficient. The customer’s pre-solution AFE process required that data be entered on an AFE spreadsheet. Multiple copies of the spreadsheet were stored in several locations, so it was difficult to know which was the latest version. Also when information on the AFE was updated, the original requester often didn’t know about the change. The AFE was printed and manually passed around from one desk to another for approvals. Whenever one of the approvers had a comment, the approver wrote the comment on an adhesive note and attached it to the AFE form. It was often difficult to determine who had the printed copy of the AFE for review.
There was also no way to view the entire portfolio of requests for project funding and approved projects. According to Sharon Gietl, VP of IT and CIO at The Doe Run Company, “Our manual process to obtain funding approvals was cumbersome and lacked the transparency we needed to make the best decisions. Our PMO needed a better way to see the entire project portfolio, share lessons learned, and capture data to perform analytics on project outcomes over a period of time.”
Innovative-e helped The Doe Run Company create a Business Critical SharePoint solution by helping the customer implement the AFE business process and forms in SharePoint. However, the complex economic analysis was left in a spreadsheet. A custom process was put in place to push data from the economic analysis spreadsheet to the AFE data in SharePoint.
Workflows were built using Nintex to automate the AFE approval process so paper was no longer passed from one desk to another. Leveraging Nintex in building the workflows accelerated the implementation time. It also provided the following capabilities out of the box that enhance ease of use:
The BCSP solution Innovative-e helped implement included the following features:
“One of the key requirements for this system was that it would take advantage of our prior investment in SharePoint. We wanted a system that contained all project-related data. Since we were already using SharePoint libraries to manage project documents and SharePoint lists to manage project details, it just made sense to integrate functionality for project-related funding. Innovative-e helped us design a solution to manage all project-related data, from the portfolio level down to individual project details”, says Callahan.
The Doe Run Company’s implementation of Innovative-e’s recommended BCSP solution resulted in several marked benefits for the company. The AFE process was streamlined to provide greater visibility into each step of the AFE process for all team members. The use of InfoPath forms, rather than spreadsheets, makes data entry more user-friendly and improves the quality of data captured. Better visibility into the company project portfolio, combined with increased productivity, translates to real financial benefits to the customer, including a better-than-30% internal rate of return.
Having a common repository for project-related data allows queries to support better decision-making (e.g. an increase in the percentage of regulatory projects over budget may lead the PMO to focus training on cost management).
Increased productivity and decreased turnaround time via automation
Internal Rate of Return: 34%
Net Present Value: $45,740
Payback Period: 2.3 years
Leveraging InfoPath forms and Nintex Workflow provides the ability for Doe Run admins and power users to more easily and more rapidly make changes to the solution as their business processes evolve.
Innovative-e and Nintex are both Microsoft BCSP partners, enabling both companies to come together to assist The Doe Run Company in implementing solutions that have a real, practical, and measurable impact and improve some of their business critical operations. The collaboration between Microsoft partners to help a customer realize greater efficiency and a ROI in business critical operations is a win for the customer, the partners, and Microsoft.