Internship Project at Adobe (summer’22)
Adobe Manifest is a website which automates the process of value realization that the Adobe employees do manually up till now.
Value Realization is the ability to track the quantified value a business or stakeholder receives from a solution implemented within the company. Value realization provides a tangible way to track the actual business impact that solutions have on customers, business operations, and ultimately shareholder value.
Previously, for Adobe Sign, the business consultants used to do the process of value realization manually through a very complex excel sheet structure. This excel sheet consisted of 7–8 sheets that were interconnected and really hard to understand. The consultants had to manually find the correct cell locations and enter the input values and change the desired assumptions. Once they had correctly entered/edited the data, the consultants had to copy and paste the value realization values from the excel one-by-one into the PPT. This entire process took about 40–50 minutes per customer; considering the fact that the consultant entered all the values correctly in the correct location.
The solution that we came up with was very effective and efficient:
Build an interactive website in html using JavaScript to automate the entire process of Value Realization.
Predefined assumptions that are editable.
Requires minimal effort and instant results.
This application has 2 main components: single customer entry and multiple customer entry.
If the consultants wish to generate the VR for multiple customers in one go without the hassle of manually doing the same process again and again, the ‘Multiple Customer Entry’ functionality will help them immensely. They simple have to choose an excel file containing just 2 columns: Customer Name and Number of Annual Transactions. On clicking ‘Submit’, the VR will be downloaded for all the entries in the excel file in PPT format.
If user needs to change the assumptions and wants the calculations to differ according to the entered values, the portal gives the flexibility to do so for single users as well. The consultants can click on ‘Single Customer Entry’ and instantly they will be redirected to the Single customer form in which the consultant will see all the assumptions that can be edited according to the customer. On clicking ‘Submit Form’, the PPT with the VR for the customer will be downloaded. This generated file can even be shared on the SharePoint folder of the customer.
The PPT that will be generated through the entire processes will contain 3 slides. Slide 1 will contain all the assumption values used for the Calculation of the VR, Slide 2 will contain the VR itself and, Slide 3 will have the ‘Environment Savings’ (the calculation is done using predefined formulae) that the customer if getting by using Adobe Sign.
To assist the first-time user to fully understand how our portal works, we have also given an option of ‘Documentation’ on the Navigation bar in the Home page. Anyone can refer to it to understand the flow of the portal. We also have a ‘Logout’ button in the Home page.
Project Value
· Several-hours worth work is completed within minutes
· No hassle of copying and pasting values
· Reduced chances of wrong value insertion
· Easy to use User Interface
· Multiple customer data generation in one go
· Saved time utilized by Business Consultants to cater to other projects and clients
Accomplished so far
· Inputs for all fields in Excel captured in tool
· Business logic(formulae) hosted outside of code — no need for Tech intervention for any changes
· Password Authentication (non-integrated with SSO)
· Output generation (PPT — 3 slides)
· Bulk VR generation for multiple customers
· Documentation for users/developers to take over for future releases
Learnings
· Completed professional services sign enablement training
· Good understanding of Adobe Sign and how it helps
· Different aspects of customer engagement as per Professional Services process
· Entire VR lifecycle
· Work as a team in a corporate environment
· Work with different stakeholders and prioritize implementation requests.
