Hamzah A F

Data Analyst

Charity Safaris • Full time

Jan 2024 - Present • 2 yrs 7 mos

• Achieved a 25% reduction in reporting time & improved donor satisfaction by leveraging advanced Excel techniques for data analysis & reporting, leading to a significant increase in charitable donations • Managed and preprocessed donor data, including comprehensive data cleaning, transformation, and validation, ensuring accuracy and consistency across datasets. • Implemented MS Excel, employing functions like VLOOKUP, INDEX MATCH, COUNTIF, conditional formatting, and pivot tables to analyze and present data • Created data dictionaries, metadata documentation, and business definitions for organisational datasets. • Developed and maintained detailed donor profiles within the CRM (donorfy) system, streamlining data management processes • Documented data flows and source systems, improving transparency of data lineage. • Supported Microsoft Fabric data warehousing, assisting in structuring data zones & organising analytical datasets. • Administered Office 365, controlling roles, access, and system configuration. • Created Power Automate flows that reduced manual workload by 30%. • Managed Azure administration, including API creation for integrations. • Enhanced data processes using Python and SQL, improving efficiency by 30%. • Developed Power BI dashboards and predictive models (clustering, decision trees) to support fundraising and engagement. • Delivered recurring reports to leadership for strategic decision-making.

Data Management and Analyst

Novartis • Full time

Oct 2021 - Dec 2022 • 1 yr 2 mos

Enhanced online presence, leading to a 20% increase in web traffic by optimizing data integration processes, resulting in over 1,000+ viewers within six months. • Collaborated with cross-functional teams to drive project success and streamline operations. • Leveraged MS Excel for data analysis, using pivot tables, VLOOKUP, and conditional formatting to support decision-making. • Created a dashboard in Power BI for real-time data visualization and performance tracking. • Developed and delivered presentations in PowerPoint to communicate data insights to stakeholders effectively