Allen Abraham

• 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 structure, governance, and accessibility to optimize analytics capabilities, including AI.
• 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.

Nature of work:
* Business Data Analysis
* Team Leadership
* Leading Veracross student ERP implmentation & SchooliP Workforce Performance monitoring implementation

Technologies:
Power BI Desktop, Excel and Python, Power BI Dataflows, data models, DAX and paginated reports.

Key Achievements:
• Tools: Power BI Desktop, Excel, Python, Power BI Dataflows, data models, DAX and paginated reports
• Established a data governance framework by defining data strategy and data lifecycle to leverage data assets across the Ajyal project, ensuring alignment with organizational objectives for eight government schools.
• As an Analytics Manager, I led a team of eight data managers as the central data governance officer, mentoring them in data stewardship practices and fostering data quality and compliance accountability.
• Introduced Power BI using existing Office 365 subscription, enabling flexible, cost-free analytics & map visuals.
• Established data governance standards by streamlining reporting, consolidating multi-source data, automating Power BI Semantic model refreshes within Microsoft Fabric, and enforcing data integrity through integrated data models.
• Developed analytical reports on MAP benchmark data using statistics, delivering performance segmentation, quadrant reports, trend and KPI analysis, student performance comparisons, and data-driven interventions.
• Demonstrated self-driven behaviour and communication skills, presenting complex data in easy-to-understand concepts to the non-technical senior leadership team and capturing documentation and processes on Wiki pages.
• Created staff workload and stakeholder survey analyses, enabling data-driven administrative initiatives.
• Designed a student Exact Path platform usage Power BI dashboard that enabled targeted interventions and improved platform usage by over 97% WOW. Collaborated with the vendor to obtain data via SFTP.
• Demonstrated strong work ethic, leading the team in implementing Veracross SIS and SchooliP staff performance monitoring in all schools, negotiating buy-in and support from IT Teams & SLT during implementation.

• Business Data Analysis using SQL, Excel, and AWS QuickSight BI tools.
• Business Intelligence Dashboard and Report creation using AWS QuickSight, Excel, SQL


AWS QuickSight, Excel, Power Query, SQL, Redshift/PostgreSQL


• Tools: SQL, AWS Redshift/PostgreSQL, AWS QuickSight, Excel, Power BI, Power Query, Pivot Tables.
• Automated manual publishing processes using Excel Power Query, accelerating key E-Commerce metric reporting.
• Managed KPIs related to seller performance, selection, pricing, inventory, fulfillment, value-added tax registration, finance, deals, and sales performance. Utilized Salesforce data reporting for lead oversight.
• Championed 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 MENA marketplace on QuickSight.
• Applied relationship building skills while challenging discrepancies in the regional implementation of Brand KPI calculations in collaboration with 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.

Nature of work:
* Data Governance solution implementation,
* Mobile Data Analytics using Amplitude,
* Data Analysis using Big Data Technologies,
* Capturing Data Architecture

Technologies:
SQL, Impala, Hive, Azure DevOps, Azure SQL Server, Data Studio, Power BI, Amplitude, Segment, MarTech.

Key Achievement:
• Tools: SQL, Impala, Hive, Azure DevOps, Azure SQL Server, Data Studio, Power BI, Amplitude, Segment, MarTech.
• Managed Mobile App Data Analytics and user journey analysis using Amplitude, Azure Data platform and Big Data.
• Leveraged entrepreneurial spirit to spearhead the development and pitch of data solution to the CTO that improved mobile data event quality by leveraging the CDP feature and eliminated reliance on a third-party testing suite.
• Designed and enforced a data governance process, mandating collaboration between business and technical data stewards, documenting architecture, data catalog and categorizing PII to support enterprise standards and initiatives.
• Collaborated with multiple teams and Google and Segment vendors to identify the root cause of inconsistent data reporting across mobile analytics platforms.

Nature of work:
• ETL & Dashboard Creation for Sales and Operations of the Engineering firm.
• Designed and captured Data Architecture.

Technologies:
Alteryx, Tableau, Microsoft SQL Server, UNIX, SQL

Key Achievements:
• Designed and captured data architecture for modernizing the Sales and Operation (S&OP) reporting platform using Tableau, enabling comparisons with various forecasts and previous performance.
• Gathered business requirements and engineered a scalable and modular ETL module utilizing Alteryx to seamlessly integrate SAP Concur file outputs with multiple ERP systems globally; this workflow automation enhanced operational efficiency.

Context:
I was a Project Controller from Andryan IT deployed at Dubai Airports to
take care of the final phases of project delivery of the HR applications project
work. It was a techno-functional role.

Actions
I analysed the current state of the applications that were being developed,
captured current, transient and proposed solution architectures in a solution
design document using Visio. Other diagrams such as swimlane & UML
diagram showing process flow and system components and related
behaviour.

As part of the change of change management, I created user guide, test
case scenarios and also suggested features for product improvement.

I proposed better team collaboration strategies such as use of SharePoint
usage for a central access of team & project documents and Skype for
business for improved and efficient team collaboration.

Results
When I captured and provided the roadmap of the solution architecture, I
was able to let developers and Head of HR IT have a unified and sane
discussion on the current state of work and the planned work ahead.

There was no strategy for testing the application and I was able to provide a
testing strategy.

I proposed user guides with different formats and finally provided them with
the format that was fit for their purpose and liking.

• Support and development of Oracle Database Applications for different lines of business in Emirates, including Loyalty application (CRM), Yield Management, Profit monitoring, and engineering departments.
• Gather stakeholder requirements and validate requirements and solutions.
• People Management for NIIT Consultants
Oracle Database PL/SQL Programming, SQL Reports, SVN, Agile, Study of Big Data Scenarios & Implementations, SQL Query performance tuning, Monitoring database performance using AWR reports
Key Achievements:
• Promoted to Technical Specialist from Technical Analyst and later announced as a Technical Architect over 6 1/2 years. I managed fellow NIITian consultants for over two years at Emirates.
• I received a NAJM Award for my performance tuning initiative that improved data warehousing processing performance, saving any additional infrastructure cost.
• Identified heavy data processing operations for migrating to Hadoop processing.
• Implemented an end-to-end integration module using Oracle PL/SQL and SQL, including data modelling, table creation, advanced SQL, and error logging for POWER2.
• Identified unidentified data issues in the reporting setup and set up a remedial solution in the setup.
• Streamlined the quarterly data purging activity and created a reporting framework to schedule and send automated email reporting using UNIX Crontab for Oracle reporting.
• Managed an end-to-end Profit Violation solution delivery, performing business requirements gathering, designing the system, and the technical implementation of the solution.
• Developed Oracle database program and custom integration with a third-party Revenue Integrity product that identified and cancelled fraud bookings, saving 44K AED in additional vendor development costs.

Context
Senior Software Engineer
My client in Nuware Pvt was AllianceBernstein.
I was working there both as a developer providing enhancements to existing
modules and also an L1 support analyst; resolving issues in the overnight
data processing before business resumes the next day in an Oracle database
solution landscape.

Actions
Debugging overnight failures in the batch processing due to data issues and
other issues.
 I refactored their QA data refresh process.
Sri Ramakrishna Engineering College

2 / 4
QA data refresh was a weekly process that was followed by a lot of process
failures due to various reasons.

Results
Demonstrated my ability to work to self-start and see through task
individually till the end.
I was commended by the AllianceBernstein technical managers for my selfinitiated
work done on QA refresh activity saving a lot of manhours of work
on a weekly basis.

Context
Senior Software Engineer
Working with Wipro Technologies, I have had the opportunity to work with
leading investment bank such as UBS. Working with UBS bank both in the
wealth management and investment banking, I have developed a strong
sense of team spirit working with teams dispersed across the globe and
working in regulated environments.

Actions
One of my first memorable projects in Wipro happened when I was working
in Dell Kitting project. This was a application project which required
embedded ESQL programs in Informix database to be ported to Pro* C code
in Oracle. This project was doomed for failure given the key personnel (DBA)
moved soon after the project started to fall apart.
After i was on-board to the project, I was part of the team to come up with
an approach to port the application ( please note this is one of my initial
projects ) . I researched and found a tool called Oracle Workbench for the
purpose and suggested we could getting application porting completed
using the tool. Soon after the POC when the heavy lifting was done, the tool
didn't work upto the expectation and the DBA left the project.
I took the leadership to teach the front-end developers to work on SQL
tasks.

I worked with UBS investment banking and wealth management soon after
my stellar project in Dell Kitting project. I worked on support projects and few
enhancements tasks for rest of my tenure at Wipro.

Results
My leadership skills