Allen is available for hire
Hire AllenAllen Philip Abraham
Verified Expert in Engineering
Data Architect and Developer
Dubai, United Arab Emirates
Toptal member since July 7, 2026
Bio
Allen is a certified data management and analytics consultant with over 16 years of experience driving measurable business value. From earning a NAJM award for boosting Emirates' warehouse performance by 35% to increasing edtech engagement at Taaleem by 97%, Allen excels at transforming complex data into clear, actionable stories. A TOGAF-certified expert proficient in SQL, Power BI, and Python, he bridges technical depth with strategic vision to solve critical business problems.
Portfolio
North Highland
Azure, SAP, Visio, Microsoft Power BI, Data Analysis, ETL...
Taaleem
ExcelJS, Python, DAX, SharePoint, Visio, Microsoft Power BI, Data Analysis, ETL...
Amazon.com
SQL, PostgreSQL, Power Query, Microsoft Power BI, Data Analysis, ETL...
Experience
- SQL - 14 years
- Oracle Database - 11 years
- PL/SQL - 11 years
- ETL - 8 years
- Data Analysis - 6 years
- Data Warehousing - 4 years
- Unix Shell Scripting - 4 years
- Microsoft Power BI - 4 years
Preferred Environment
Alteryx, Microsoft Power BI, SQL, Unix Shell Scripting, Python Data Analytics, Oracle Database, PostgreSQL, Datalake Platform, Microsoft Fabric
The most amazing...
...success has been building Exact Path platform usage across eight schools, leading to a 97% week-on-week improvement in engagement and data-driven interventions.
Work Experience
Data Consultant
2025 - 2026
North Highland
- Served as a data consultant at a management consultancy for a large-scale data transformation initiative, focusing on data architecture design, governance implementation, and data sourcing optimization at KAUST University.
- Enhanced data governance policy, structure, and accessibility to optimize analytics capabilities, including AI.
- Drove business workshops to create a business glossary and worked with the tech team, confirming alignment.
- Supported the design of enterprise data architecture and governance frameworks on the Azure cloud data platform.
- Designed for improved data sourcing, lineage, and quality across complex data environments, including SAP and many fragmented systems. Collaborated with data and technology teams to enable reliable data access for analytics.
- Worked closely with the data architect to align data design and delivery practices with strategic goals.
- Created Power BI dashboards for systems mapping and conducted groundwork for strategic mission-aligned research and use case creation, including stakeholder interviews, conceptual models, and ER diagrams using Visio.
Technologies: Azure, SAP, Visio, Microsoft Power BI, Data Analysis, ETL, Business Intelligence (BI), Data Architecture, Architecture, Data Taxonomy, Communication, Key Performance Indicators (KPIs), Database Architecture, Databases, Database Design, Reporting
Data Analyst | Analytics Manager
2023 - 2024
Taaleem
- Established a data governance framework and defined a data strategy to leverage data assets in the Ajyal project.
- Spearheaded a team of eight data managers from different schools, mentoring them on data stewardship practices and fostering accountability for data quality and compliance.
- Introduced Power BI using an existing Office 365 subscription, developed ETL pipelines to consolidate and centralize reporting for all schools in the cluster, integrated data from multiple sources, and automated Power BI semantic model refreshes.
- Developed analytical reports on MAP benchmark data using statistical analysis, delivering performance segmentation and classification, clustering and quadrant reports, regression-based trend, and KPI analysis for data-driven interventions.
- Designed a Power BI dashboard for the Exact Path online learning platform usage that enabled targeted interventions and improved platform usage by over 97% WOW. Collaborated with the vendor to obtain data via SFTP.
- Presented complex data in easy-to-understand concepts to the non-technical senior leadership team and captured documentation and processes on Wiki pages.
- Gained in-depth expertise in the medallion architecture for OneLake-based data lakehouse analytics, mastering strategies for optimizing data organization, scalability, and advanced analytics workflows.
- Implemented a standardized attendance data-capturing process across the cluster as a process governance initiative.
- Created staff workload and stakeholder survey analyses, enabling data-driven administrative and HR initiatives.
- Guided the team in implementing the Veracross Student Information System and the SchooliP HR application for school staff performance monitoring, and negotiating buy-in and support from IT and SLT.
Technologies: ExcelJS, Python, DAX, SharePoint, Visio, Microsoft Power BI, Data Analysis, ETL, Data Quality, Data Integration, Dashboards, Data Engineering, Data Visualization, Business Intelligence (BI), Dashboard Development, Data Architecture, Architecture, Role-based Access Control (RBAC), Security, Data Taxonomy, Metadata, Communication, Key Performance Indicators (KPIs), Data Analytics, Database Architecture, Databases, Database Design, Data Migration, Data Reporting, Reporting
Business Analyst
2021 - 2022
Amazon.com
- Automated manual publishing processes using Excel Power Query, accelerating key eCommerce metric reporting.
- Managed seller analytics, including performance, selection, pricing, inventory, fulfillment, value-added tax registration, finance, deals, and sales performance KPIs, utilizing Salesforce data reporting for lead oversight.
- Championed a data governance modernization initiative, adopting QuickSight for real-time tracking of intra-day deals and interactive reporting, and standardizing visualization protocols.
- Enabled the first inter-marketplace demand signal processing for the MENA marketplace on AWS QuickSight.
- Applied relationship-building skills while challenging discrepancies in the regional implementation of brand KPI calculations in collaboration with the brand COE. Provided targeted product listing support for merchandising.
- Led root-cause analysis and financial analysis for P&L reconciliation issues post Egypt Marketplace kickoff, affecting returns data. Achieved buy-in for further investigation by presenting the data utilizing creative thinking.
- Conducted data analysis and reporting initiatives on various feature launches such as Palmyra warehouse, IDQ program management, and inventory utilization reporting, collaborating with multiple stakeholders and teams.
Technologies: SQL, PostgreSQL, Power Query, Microsoft Power BI, Data Analysis, ETL, Microsoft Excel, Data Quality, Data Integration, Dashboards, Data Engineering, Data Visualization, Business Intelligence (BI), Dashboard Development, Data Architecture, Communication, Key Performance Indicators (KPIs), Data Analytics, Data Reporting, Reporting
Data Architect
2019 - 2019
P&G/AYM Commerce
- Managed mobile app data analytics, funnel analytics, and customer user journey analysis using Amplitude, Azure Data platform, Big Data, as well as product data analytics such as events, impressions, conversions, and engagement.
- Designed and pitched a CDP-driven data solution to the CTO that improved mobile data quality, eliminated 3rd-party testing reliance, and established a data governance process to unify business and technical data stewards.
- Guided a data governance activation program using the newly implemented solution and maintained the business glossary.
- Documented architecture, created a data catalog, and categorized PII to support enterprise standards and initiatives.
- Partnered with Google and Segment vendors to resolve inconsistencies in mobile analytics reporting during RCA.
Technologies: SQL, Impala, Apache Hive, Azure DevOps, Amplitude, Segment, Microsoft Power BI, Data Analysis, eCommerce, Data Architecture, Architecture, Communication, Data Reporting, Reporting, Apache Impala
Assistant Manager | Data Analyst
2018 - 2019
Gates/HTC Global Services
- Designed and captured data architecture for modernizing the sales and operations (S&OP) reporting platform using Tableau and ETL using Alteryx, enabling comparisons with various forecasts and previous performance.
- Engineered a scalable, modular data integration ETL module utilizing Alteryx to seamlessly integrate SAP Concur file outputs with multiple ERP systems globally, enhancing operational efficiency.
- Designed a data strategy for early wins, securing funds for continued projects.
Technologies: SQL, Alteryx, Tableau, Microsoft SQL Server, Unix, Data Warehousing, ETL, Data Architecture, Architecture, Metadata, Database Architecture, Databases, Database Design, Data Migration, Data Reporting
Senior Oracle Programmer
2011 - 2017
Emirates Group IT (Airlines)/Coforge
- Developed Oracle database applications in agile SDLC. Managed UAT releases, data integration, cross-functional validation, and QA collaboration for Skywards Loyalty application (CRM), tactical planning for marketing campaigns, and customer analytics.
- Promoted from a technical analyst to a technical specialist, then advanced to a technical architect over 6.5 years.
- Performance-managed 13 Coforge consultants for over two years.
- Improved PROMIS data warehouse batch processing by 35% without additional infrastructure or app rewrites. Identified compute-intensive workloads for Hadoop migration and performed capacity planning and regression analysis based on flight growth.
- Architected an end-to-end integration module using Oracle PL/SQL, including conceptual and logical models via SQL Developer ER feature, table creation, advanced SQL, and error logging for POWER2.
- Engineered a UNIX Crontab-driven automated email framework optimizing Oracle report delivery efficiency.
- Designed and implemented an Oracle procedure-based profit violation solution integrating with Sabre Revenue Integrity to automate fraudulent booking cancellations, saving AED 44,000 in vendor costs.
Technologies: SQL, Subversion (SVN), Big Data, Oracle, Data Warehousing, Data Analysis, ETL, DataOps, Data Integration, Data Architecture, APIs, Security, Metadata, Data Analytics, Database Architecture, Databases, Database Design, Data Migration, Data Reporting, Hadoop
Senior Oracle Programmer
2010 - 2010
AllianceBernstein (Bank)/NuWare
- Managed Oracle database PL and SQL application support and development for an investment bank.
- Automated weekly QA environment refreshes involving DML and DDL operations, reducing manual effort and earning recognition for process improvements.
- Provided L2 production support, troubleshooting failures in nightly batch processing caused by data quality and system issues.
Technologies: SQL, Oracle, ETL, DataOps, Financial Data, Security, Databases, Database Design
Senior Oracle Programmer
2005 - 2010
Wipro
- Built and supported Oracle database applications for multiple enterprise clients, including UBS Investment & Wealth Management, Banks, Dell, and Supervalu; received the Thanks a Million award for contributions to monitoring and reporting initiatives.
- Drove the successful migration of a Dell application from Informix to Oracle using embedded SQL, overcoming technical and resource challenges and supporting UAT and production go-live.
- Implemented ETL pipelines, supported UBS's warehousing and business intelligence platforms aligned with regulatory banking procedures and data management, and provided L1 and L2 support.
Technologies: Oracle, SQL, PL/SQL, Informatica PowerCenter, Subversion (SVN), ITIL, Financial Data, Databases, Database Design, Data Migration
Experience
Power BI Projects Executed in Taaleem
https://www.dropbox.com/scl/fi/bygl5zguticc5jhx1xocm/Allen-s-Power-BI-Reports-Online-Platform-Engagement-Taaleem.pdf?rlkey=0hx5uqdtclhoim0awf655mw7c&st=hg7slig0&dl=0PROBLEM
Engagement data for the Exact Path learning platform was fragmented across 8 separate school portals with no centralized tracking, and default reports lacked insights into disengaged students.
SOLUTION
• Partnered with the vendor's US data science team to set up daily SFTP automated data feeds.
• Integrated raw usage logs with central student registration data in Power BI.
• Defined a custom "Neglect KPI" measuring the percentage of unengaged students per period.
• Built a Power BI dashboard allowing drill-downs from cluster level to individual student levels.
IMPACT AND RESULTS
• Enabled cluster directors, principals, and teachers to pinpoint disengaged classes and students for targeted interventions.
• Achieved a 97% week-on-week reduction in Neglect KPI, i.e., resulting in boosting platform engagement across the cluster, maximizing ROI.
Engagement data for the Exact Path learning platform was fragmented across 8 separate school portals with no centralized tracking, and default reports lacked insights into disengaged students.
SOLUTION
• Partnered with the vendor's US data science team to set up daily SFTP automated data feeds.
• Integrated raw usage logs with central student registration data in Power BI.
• Defined a custom "Neglect KPI" measuring the percentage of unengaged students per period.
• Built a Power BI dashboard allowing drill-downs from cluster level to individual student levels.
IMPACT AND RESULTS
• Enabled cluster directors, principals, and teachers to pinpoint disengaged classes and students for targeted interventions.
• Achieved a 97% week-on-week reduction in Neglect KPI, i.e., resulting in boosting platform engagement across the cluster, maximizing ROI.
Education
2001 - 2005
Bachelor's Degree in Electronics and Instrumentation
Sri Ramakrishna Engineering College - Coimbatore, India
Certifications
AUGUST 2026 - AUGUST 2028
Microsoft Certified: Fabric Data Engineer Associate
Microsoft
JUNE 2025 - JUNE 2027
Microsoft Certified: Fabric Analytics Engineer Associate
Microsoft
SEPTEMBER 2024 - SEPTEMBER 2027
AWS Certified Machine Learning Specialty
AWS
NOVEMBER 2022 - NOVEMBER 2025
AWS Certified Cloud Practitioner
AWS
JULY 2022 - PRESENT
Microsoft Certified: Azure Data Fundamentals
Microsoft
NOVEMBER 2020 - MAY 2027
Microsoft Certified: Power BI Data Analyst Associate
Microsoft
AUGUST 2020 - PRESENT
Microsoft Certified: Azure AI Fundamentals
Microsoft
JANUARY 2020 - PRESENT
Tableau Desktop Specialist
Tableau
JULY 2019 - JULY 2021
Alteryx Core Certified
Alteryx
NOVEMBER 2018 - PRESENT
TOGAF 9 Certified – The Open Group Certification in Enterprise Architecture
The Open Group
JULY 2018 - JULY 2020
IIBA-AAC – IIBA Agile Analysis Certification
IIBA
JULY 2018 - JULY 2023
CAPM – Certified Associate in Project Management
PMI
MAY 2018 - PRESENT
PRINCE2 Agile Foundation certified in Agile Project Management
AXELOS
APRIL 2018 - PRESENT
PSPO 1 – Professional Scrum Product Owner 1 Certified
Scrum.org
DECEMBER 2017 - PRESENT
ITIL Foundation Certificate in IT Service Management Certified
AXELOS
JULY 2016 - PRESENT
Oracle Certified Associate PL/SQL Developer (OCA)
Oracle
MARCH 2015 - PRESENT
Oracle Certified Expert in Oracle Database SQL (OCE)
Oracle
Skills
Libraries/APIs
PySpark, ExcelJS
Tools
Microsoft Power BI, Power Query, Braze, Impala, Tableau, SAP Concur, Visio, Skype, Informatica PowerCenter, Subversion (SVN), Jira, LabVIEW, Microsoft Excel, Apache Impala, Apache Airflow
Languages
Python, SQL, Power Query M
Paradigms
ETL, Business Intelligence (BI), Role-based Access Control (RBAC), Database Design, Azure DevOps, ITIL, Agile Project Management
Storage
Databases, PL/SQL, Data Integration, Data Lakes, Database Architecture, Apache Hive, Azure SQL, IBM Informix, PostgreSQL, Microsoft SQL Server, Data Pipelines
Platforms
Oracle, Azure, Microsoft Fabric, Alteryx, SharePoint, Unix, Oracle Database, Amazon Web Services (AWS)
Frameworks
Hadoop, Apache Spark
Other
Data Architecture, Data Warehousing, Data Analysis, DataOps, Data Engineering, SQL Server, DAX, Unix Shell Scripting, Data Visualization, Data Modeling, Data Quality, Dashboards, Architecture, APIs, Data Taxonomy, Metadata, Communication, Key Performance Indicators (KPIs), Data Analytics, Data Migration, Data Reporting, Reporting, Segment, Amplitude, Azure Data Studio, SAP, Big Data, Office 365, UML Modelling, Big Data Analytics, Python Data Analytics, Datalake Platform, IT Service Management (ITSM), Agile Analysis Certification, Professional Scrum Product Owner I (PSPO I), Instrumentation Engineering, Electronics, IT Project Management, Enterprise Architecture, Artificial Intelligence (AI), Machine Learning, Financial Data, eCommerce, Dashboard Development, Security
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring