Success Metrics After Launch
Since 2020, customer retention rose from 30% to 90%, transaction value grew from $10B to $16B+, and clients increased from 150 to 500. The client continues to maintain an AMC.
Impact Since Launch (Dec 2020): Key Growth Metrics
Customer Retention Rate
80%
+
200%
Increased from 30% → 90%
Transaction Enterprise Value
$16B+
+
60%
Grew from $10B → $16B+
Total Clients Growth
500+
+
233.33%
Expanded from 150 → 500
Ongoing Engagement
🔹 Client continues to maintain Annual Maintenance Contract (AMC)
More information visit : https://www.aecadvisors.com
Pain Points
During the analysis phase, I identified key pain points in AEC's process. By incorporating these issues into the design with the help of the PMO team, I can make the design much more user-friendly.
Inefficiencies in the Financial Survey Process
The offline process for collecting financial data using the excel sheet is not efficient
No validation as lots of the excel sheet does contains macro calulations
Challenges in Offline Financial Survey Procedures
Lots of error may happen becuase of the offline data entry
Bit difficult for the AEC to folloup to make sure the sheet is filled
300+ Questions in One Survey make it Challenging
300+ question make it big time config to get it filled
Due to the data requirements from various departments, filling out the survey without seeking assistance is challenging.
No Realtime progress checking
Monitoring real-time data added by different departments is very difficult, leading to delays.
This difficulty makes it challenging for AEC admins and client admins to process the data efficiently.
All their clients are familiar with entering data into the sheet.
Introducing a new platform requires clients to learn how it works.
If the survey has already been filled out in the sheet and, users find it challenging and repetitive to enter the data again into the online form.
No collaboration between different departmenet
Since the data is added offline, real-time collaboration is not possible.
This can introduce numerous human errors, leading to inaccurate data and incorrect benchmarks.
Wireframes







Colors & Typography
Name
Blue Sapphire
Primary
Secondary
For Text Contents
Erros, charts, Status tag
For sucess indication, charts, Status tag
Warnings, charts, Status tag
HEX
#0E567D
Name
Light Blue
HEX
#33A7E2
Name
Mid night blue
HEX
#1C2D49
Name
Light red
HEX
#FD5064
Name
Dark green
HEX
#199978
Name
Orange
HEX
#FF8702
Manrope is a google font
Aa
Regular 400
Aa
Medium 500
Aa
Semi-bold 600
Aa
Bold 700
To enhance the modern and sleek appearance of the project, which requires displaying numerous mathematical values related to finance, I selected the Manrope font from Google.
In the project, I followed the brand's color style guide closely. I created specific colors for tags and charts to match the brand’s look and make the application easier to use and more consistent.








Design Process
After conducting usability testing, I began creating mockups that address all the user pain points to ensure the design effectively solves the underlying business challenges.
Project Goal
AEC aims to develop a user-friendly cloud-based web application for more efficient collation of all required financial data, enabling real-time monitoring to reduce frequent follow-ups and minimize human error, ensuring clients have access to up-to-date information and insights.
The Problem
AEC uses an offline Excel sheet to collect required financial data, including general business information, financial information, people, digital, offices, internal ownership transition details, and M&A, to create financial benchmarks and key performance indicators for advising their clients.
Each page contains more than 150 questions to be filled this outdated Excel-based surveys are complex, error-prone, and lack validation tools, leading to frequent follow-ups and offline data entry issues. To improve user engagement, AEC aims to transform their financial data collection from an offline Excel system to an efficient online platform.

About AEC
AEC Advisors, founded in 2018, provides financial consulting for Architecture, Engineering, and Construction firms, specializing in mergers, acquisitions, and corporate finance. They have completed over 107 transactions worth more than $10 billion and focus on industry benchmarking and empathetic advice.
Goals
ACE, a seasoned financial advisory firm, faces issues with their complex, error-prone, offline Excel-based surveys. To enhance user engagement, AEC aims to transform their financial data collection from an offline Excel process to an efficient cloud based online Web platform.
ABOUT
AEC
ADVISORS
Web Application
Transforming AEC Advisors with Quick User Research for Digital Efficiency
AEC Finance Survey Portal
AEC Advisors is a financial consulting firm specializing in advising leaders of Architecture, Engineering, and Construction (AEC) firms. They assist with mergers and acquisitions, corporate finance, and other financial issues, enabling firm leaders to focus on their core business. Founded in 2018, AEC Advisors has completed over 107 transactions valued at more than $10 billion. The firm is dedicated to industry benchmarking and providing authentic, empathetic advice to their clients.

Finder
File
Edit
View
Go
Window
Help
Mon Jun 22
9:41 AM








My responsibilities
My Role as
SENIOR
UI/UX DESIGNER
Feb - May 2020
User research, Wireframing, Visual Designing, Usability testing,
Conducted comprehensive User research to understand the specific needs and pain points of end users
Collaborated closely with clients, project managers, development, and QA teams to gather and synthesize feedback.
Converted wireframes into high-fidelity mockups from the PMO team, enhancing usability by adding features that help End users complete surveys as quickly as possible.
Supported the development team in translating mockups into live code, ensuring design integrity and usability throughout the implementation process.
Continuously iterated on designs based on usability testing and feedback to ensure optimal user satisfaction.



Financial and Institutional Entities
Investors and Financial Institutions
Government and Regulatory Bodies
Industry Consultants and Advisors
Financial officers and analysts
Financial and Institutional Entities
Investors and Financial Institutions
Government and Regulatory Bodies
Government and Regulatory Bodies
AEC Industry Stakeholders
Leadership and executive teams
Business development professionals
Financial officers and analysts
Project managers
Usability Study
FINDING
By conducting the usability testing by the comparing the pain points I find several areas to improve the usability
1
Since the application is new to all AEC customers, an Onboarding process for the survey will greatly assist in getting started with data entry.
2
An option to Upload existing Excel files into the system would be useful for users who have already filled out the survey and need to make only a few changes to their data.
3
An option to Assign different segments of the survey to various departments would greatly improve overall usability and collaboration.
4
Real-time Error validation will improve usability by preventing errors during Excel uploads or data entry via built-in forms.
5
Providing an option to choose between a Web form and Excel upload would help first-time users gradually adapt to the new web form, which is the core of the application.
6
Making the Web form experience as like as the excel will gratily improve the usability
TARGET
AUDIENCE
Architecture, Engineering, and Construction (AEC) Firms
RESEARCH
To gain insights into the pain points faced by current users.
In the project analysis phase, with the help of the PMO team, I conducted a quick user research via email to understand the pain points that need to be addressed in the final mockup to improve the usability of the application across different users.
Usability
Ensure the app is easy to Get started with, especially since it is new platforms to Users.
Interview Questions

Can you describe what is the current issues you re facing while adding datas in to the excel sheets

What challenges do you face when filling out the Excel sheet?

How do you coordinate with other departments to gather the necessary information?

How often do you update the Excel sheet?


I receive the Excel sheet and manually input data from various departments. It's a long process because the sheet has more than 300 questions, including HR and finance-related data. The macros sometimes cause errors, and it takes a lot of time to ensure all information is accurate.


It's very time-consuming and prone to errors, especially with the macro


Coordinating with different departments is challenging and takes a lot of time, as I need to gather information from each one


We update the Excel sheet every quarter, which means the data can be outdated by the time we finish.

What is your current process for adding data from different departments?


I have to gather data from each department separately, usually through emails or meetings, and then manually enter all the information into the Excel sheet. This process is very time-consuming and prone to errors
DESIGN
PROCESS
User research to Mockups
Wireframes
I used the wireframe as my initial reference for the mockup, addressing the pain points to ensure the design solves the business challenges and user issues.
My design process
After completing the analysis phase, the client has pushed to finish the mockup to start the development process, aiming to get the application live as soon as possible by integrating prioritized user feedback and aligning with project goals within a limited timeframe.
Challenges 1
Tight timeline to get the mockup approved to start the development process
Create and deliver a high-fidelity mockup in 7 days, incorporating prioritized user feedback into a provided wireframe, to ensure quick client approval and prompt commencement of development.
Solution
After analyzing user feedback to identify key pain points, I skipped empathy mapping and user personas. Instead, I directly integrated the feedback into the provided wireframe, prioritized essential features, and quickly created a high-fidelity mockup using design systems and rapid prototyping tools. I ensured the mockup addressed critical issues and prepared an interactive presentation for quick client approval, aiming to start development within in one week.
Challenges 2
No time to update the wireframe created during the initial stages of the analysis.
Because of the short timespan, updating the wireframe to include user pain points would take too much time, as the wireframe was created during the initial stages of analysis.
Solution
With the tight deadline, I skipped updating the PMO wireframe and applied user pain points directly to the mockup, using the original wireframe as a guide. To create initial mockups quickly, I started by designing a mood board for the core survey page.
Navigation
Simplified & Organized Navigation
The user journey was mapped out to identify and eliminate unnecessary steps, resulting in a streamlined navigation path.


Get started
Get Started with Finance Survey Faster
As this application is new, I’ve added a "Get Started" section with animated GIFs to ensure first-time users have a smooth, step-by-step guide for entering their financial data.

Import data
Import Data from an Existing Survey Excel Sheet
Offering a choice between a web form and Excel upload allows first-time users to gradually transition to the new web form, which is central to the application.
22px Bold



Upload data
Realtime upload progress for the fetching data from the excel sheet
Given that the Excel sheet contains over 300 questions, fetching all the data can be time-consuming. Providing a real-time progress indicator will help users understand the upload and data retrieval duration more clearly.

Feedbacks
Post-Upload Feedback
Once data is added through the web form or Excel upload, providing feedback is crucial to confirm that the survey is completed successfully and inform the user of the next steps.
22px Bold



Validation
Real-Time Error Notifications
It is crucial to notify users if any incorrect values are entered or mandatory fields are left blank. This ensures that all submitted data is accurate, allowing AEC to provide precise financial advice essential for their business.

Web form
Familiar Excel-Like Web Form Design
This design mimics Excel to help users comfortably transition and gradually adapt to the new web form.
22px Bold

Validation
Design System for Seamless Scalability and Consistency
Despite the tight project timeline, I developed and maintained a design system to support feature consistency and facilitate future scaling.

Web form
Component Library for Design Consistency
I’ve designed a Component Library to ensure design consistency and simplify maintenance with reusable elements.
22px Bold

All Mockups
The AEC web survey portal includes additional modules such as User Management, Campaigns, Reports, and M&A Transaction Data.
Iconography
Material Icon Set
Google Material Icons is a comprehensive set of modern, consistent, and easily customizable icons designed to work seamlessly with the Material Design guidelines. These icons enhance user interfaces by providing clear, intuitive visual cues across various platforms and applications.


22px Bold

