Product designer
Alpha ABC - Oil & Gas Optimisation
Alpha ABC is a digital platform designed for the Oil & Gas industry to help users optimize operational data management by integrating information from Excel and SharePoint into a centralized system. The platform provides users with a real-time reporting dashboard, enabling data-driven decision-making and streamlined workflows across departments.
Industry :
Oil & Gas
Client :
Alpha ABC
Project Duration :
5 months
Year :
2024
1
Project Overview
Target Audience
Target Audience
Data analysts, project engineers, and operation managers in the Oil & Gas sector. Users who handle large datasets across multiple sources (Excel, SharePoint) and require visual insights for operational efficiency.
Role
Role
Product designer
My Responsibilities
My Responsibilities
Conducting user research and stakeholder interviews. Designing user journeys, information architecture, and wireframes. Creating high-fidelity UI designs. Collaborating with business analysts and developers. Running usability testing sessions
2
Problem Statement :
Users spent significant time consolidating data manually from Excel and SharePoint.
Lack of a unified platform led to data inconsistencies and version control issues.
Reports were difficult to interpret, with limited visualization and filtering options.
Users found the existing tools non-intuitive and time-consuming for daily operations.
3
Possible Solution :
Develop an automated data synchronization feature between Excel/SharePoint and the Alpha ABC system.
Design an intuitive dashboard that visualizes KPIs, trends, and alerts in real time.
Implement role-based access and custom report filters to improve relevance for each user type.
Simplify navigation with a clean UI structure and clear data hierarchy for better usability.
4
Project Goal :
Enhance Executive Oversight
Provide senior management with a unified, real-time dashboard to instantly assess the RAG (Red, Amber, Green) status and financial health of the entire project portfolio.
Standardize Data Integrity
Establish a single Information Architecture (IA) and input method to ensure data consistency and reliability across the Upstream, Downstream, and Gas divisions.
Improve Operational Efficiency
Reduce the manual effort and time Project Managers spend on status reporting, allowing them to focus more on project execution.
Enable Proactive Risk Mitigation
Design a clear system for tracking and escalating high-priority risks and issues, enabling leaders to intervene before issues lead to significant project delays or budget overruns.
5
Challenge :
Handling variations in Excel formatting across different departments.
Ensuring heavy data loads (thousands of rows) could be processed without affecting performance.
Aligning UI design with strict industry compliance and internal IT constraints.
Managing cross-department expectations and different reporting requirements.
6
Visual Design :
7
Final Result :
Success Metrics:
Reduced manual data processing time by 60%.
Improved report accessibility and readability with interactive visualization tools.
Increased system adoption among teams within the first 3 months of launch.
Positive user feedback on the dashboard usability and clarity of information.
What Was Done:
Delivered a complete end-to-end UX process including research, wireframes, prototypes, UI design, and usability testing.
Collaborated with developers to ensure smooth design implementation and data integration.
Result:
The Alpha ABC platform successfully transformed how users handle operational data, enabling faster insights, fewer errors, and more efficient reporting workflows.
More Projects
Product designer
Alpha ABC - Oil & Gas Optimisation
Alpha ABC is a digital platform designed for the Oil & Gas industry to help users optimize operational data management by integrating information from Excel and SharePoint into a centralized system. The platform provides users with a real-time reporting dashboard, enabling data-driven decision-making and streamlined workflows across departments.
Industry :
Oil & Gas
Client :
Alpha ABC
Project Duration :
5 months
Year :
2024
1
Project Overview
Target Audience
Target Audience
Data analysts, project engineers, and operation managers in the Oil & Gas sector. Users who handle large datasets across multiple sources (Excel, SharePoint) and require visual insights for operational efficiency.
Role
Role
Product designer
My Responsibilities
My Responsibilities
Conducting user research and stakeholder interviews. Designing user journeys, information architecture, and wireframes. Creating high-fidelity UI designs. Collaborating with business analysts and developers. Running usability testing sessions
2
Problem Statement :
Users spent significant time consolidating data manually from Excel and SharePoint.
Lack of a unified platform led to data inconsistencies and version control issues.
Reports were difficult to interpret, with limited visualization and filtering options.
Users found the existing tools non-intuitive and time-consuming for daily operations.
3
Possible Solution :
Develop an automated data synchronization feature between Excel/SharePoint and the Alpha ABC system.
Design an intuitive dashboard that visualizes KPIs, trends, and alerts in real time.
Implement role-based access and custom report filters to improve relevance for each user type.
Simplify navigation with a clean UI structure and clear data hierarchy for better usability.
4
Project Goal :
Enhance Executive Oversight
Provide senior management with a unified, real-time dashboard to instantly assess the RAG (Red, Amber, Green) status and financial health of the entire project portfolio.
Standardize Data Integrity
Establish a single Information Architecture (IA) and input method to ensure data consistency and reliability across the Upstream, Downstream, and Gas divisions.
Improve Operational Efficiency
Reduce the manual effort and time Project Managers spend on status reporting, allowing them to focus more on project execution.
Enable Proactive Risk Mitigation
Design a clear system for tracking and escalating high-priority risks and issues, enabling leaders to intervene before issues lead to significant project delays or budget overruns.
5
Challenge :
Handling variations in Excel formatting across different departments.
Ensuring heavy data loads (thousands of rows) could be processed without affecting performance.
Aligning UI design with strict industry compliance and internal IT constraints.
Managing cross-department expectations and different reporting requirements.
6
Visual Design :
7
Final Result :
Success Metrics:
Reduced manual data processing time by 60%.
Improved report accessibility and readability with interactive visualization tools.
Increased system adoption among teams within the first 3 months of launch.
Positive user feedback on the dashboard usability and clarity of information.
What Was Done:
Delivered a complete end-to-end UX process including research, wireframes, prototypes, UI design, and usability testing.
Collaborated with developers to ensure smooth design implementation and data integration.
Result:
The Alpha ABC platform successfully transformed how users handle operational data, enabling faster insights, fewer errors, and more efficient reporting workflows.