Allen Abraham

• Tools: Power BI Desktop, Excel, Python, Power BI Dataflows, data models, DAX and paginated reports

• Defined data strategy to leverage data assets in the Taaleem Ajyal project of eight government schools.

• Directed and mentored a team of eight data managers as a central data analytics advisor and data lead.

• Introduced Power BI reporting platform using existing Office 365 subscription, allowing flexible and creative data analytics opportunities within the organization at no extra costs. Data extraction using automated data flows.

• Launched analytical academic reports on benchmark exams utilizing statistics and domain knowledge, enabling data analysis, analysis of trends, comparison of student performance, and data-driven student intervention.

• Demonstrated self-driven behavior and communication skills to present complex data in easy-to-understand concepts to the non-technical senior leadership team and showcased writing skills by creating 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. Managed negotiations that resulted in buy-in from IT Teams & SLT in the absence of school data managers during implementation.

• Tools: SQL, AWS Redshift/PostgreSQL, AWS QuickSight, Excel, Power BI, Power Query, Pivot Tables.

• Utilized Excel Power Query skills to automate WBR processes in the 3P team, allowing key E-Commerce metrics related to seller performance, selection, pricing, fulfillment, value-added tax registration, finance, deals, and sales performance to be published earlier, saving two hours weekly.

• Adopted AWS QuickSight to modernize reporting, allowing data visualization and publishing the first inter-marketplace-based Demand Signal processing for MENA Marketplace, enabling actionable business insights.

• Implemented continuous improvement of reports by including more KPIs and moving static reports to QuickSight, enabling real-time performance tracking, especially intra-day deals reporting.

• 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.

I worked as a Data Architect managing data quality processes for Procter and Gamble's Pampers Reward Mobile app. As a data steward, I manage data governance initiatives for data events. My proposal to use of Segment Protocols as a strategical move to improve the quality of the custom events leveraging on the existing infrastructure and processes was accepted by the client. I implemented the solution despite many challenges and created processes to align with the Sprint processes. I manage the data tracking plan for the new data events generated on both iOS and Android mobile devices. Besides investigating issues in Big data environment using Impala and Hive queries I also identify target customers during campaigns based on their profile and activities. My use of tools such as Segment, Braze and Amplitude. Work is managed on Azure DevOps and reporting is also done on Azure SQL database using Azure Data Studio & Power BI.