Results-driven Data Analyst with expertise in Power BI, DAX, Power Query (M-Query), Python, Machine Learning (ML), Azure Data Factory (ADF), SQL, and ETL. Skilled in transforming complex datasets into actionable insights, enabling data-driven decision-making and process optimisation. Develops interactive dashboards in Power BI, using DAX and M-Query to create dynamic calculations and automate data transformations. Conducts daily data queries and reporting, ensuring accuracy and efficiency in tracking key performance metrics. Proficient in advanced Excel functions, including pivot tables and VBA, to support detailed data analysis. Experience in ETL processes and data pipeline automation using Azure Data Factory (ADF), improving data ingestion, transformation, and integration from multiple sources. Works with SQL to develop tables, views, and materialised views, enhancing data accessibility and reporting. Applies Python and ML techniques to analyse large datasets, identify patterns, and develop predictive models for business forecasting. Collaborates with stakeholders across finance, operations, and senior management, presenting insights that influence business strategy and process improvements. Engages with external teams to define requirements, write test scripts, and conduct functional testing. Uses GitHub for issue tracking, development, and collaboration to streamline workflows. Optimises business processes by automating repetitive tasks with Power Automate, reducing manual effort and improving efficiency. Works closely with internal teams to define analytical requirements for customer, product, and project needs. Applies statistical and algebraic techniques to extract key insights and improve data integrity. Led initiatives that achieved £5,000 in cost savings, resolving long-standing operational inefficiencies through data analysis and automation.

D-Link Europe | Nov 2017 - Jan 2019

Business Analyst

Analysed user needs and concerns to determine optimal system solutions, ensuring alignment with business requirements. Provided support across Finance, AR, AP, G/L, Sales, Distribution, Procurement, CRM, Inventory, and Advanced Pricing, delivering go-live support for a multi-site, multi-national organisation. Designed and conducted end-user training, both classroom-based and one- on-one, to improve system adoption. Led functional design documentation, business process flow mapping, system configuration, and CRM, Sales Orders, and Procurement implementation. Collaborated with developers using SQL databases to perform data inquiries and validate system functionality. Worked with OMW (Object Management Workbench) to create versions, design menus, and configure UBE/UDCs for various JD Edwards (JDE) functional areas. Facilitated Conference Room Pilot (CRP) sessions and documented business process models (BPMN) to support system design and validation. Developed user manuals, functional specifications, and technical documentation to standardise processes. Managed JDE environments (Development, Prototype, Production) with Redfaire, overseeing project deployments and system enhancements. Provided post-go-live support, resolving issues, documenting reporting needs, and working with developers on system enhancements. Ensured batch version and interactive application security, restricting access based on user roles. Handled daily support tickets via ManageEngine, prioritising and resolving system issues. Led UAT (User Acceptance Testing) for new developments, creating test scripts and facilitating end-user testing. Analysed business processes, evaluating impact and identifying efficiency improvements. Presented business intelligence insights to support data-driven decisions and conducted training on new processes and system developments.

D-Link Europe | Sep 2016 - Nov 2017

Data Analyst

Dynamic and results-driven Data Analyst with a proven track record of enhancing departmental performance and delivering actionable insights. Expertise in collaborating with cross-functional teams to address diverse analytical needs, achieving an impressive departmental performance increase to 99.6%. Proficient in developing comprehensive performance and forecasting reports for senior management, utilizing raw data from the JDE ERP system. Skilled in data management, streamlining processes by refining essential information in Salesforce and employing SQL to optimize data quality. Proficiency in QlikView ensures accurate daily sales reporting by individual products, enhancing visibility for stakeholders. Thrives under pressure, consistently meeting strict deadlines and delivering high-quality work ahead of schedule. A proactive team player who embraces new responsibilities and organizes training sessions to share knowledge and best practices within the department. Commitment to excellence reflected in the ability to ensure timely deliveries with minimal errors while adhering to standardized procedures. Contributed to system testing initiatives, analyzed complex datasets using Excel, and received commendations for analytical contributions. Focused on continuous improvement, training colleagues on software for enhanced data management and resolving data integrity issues to ensure reliable reporting.

Great Ormond Street Hospital for Children NHS Foundation Trust | Aug 2016 - Sep 2016

IT Auditor

IT asset and mobile device audits, with a strong focus on accuracy, compliance, and operational efficiency. Adept at conducting comprehensive asset assessments, ensuring proper tagging, documentation, and lifecycle management to enhance data integrity and resource allocation. Expertise in identifying obsolete IT assets, assessing risks related to performance and data security, and providing strategic recommendations to mitigate potential issues. Strong analytical skills enable the development of efficient asset tracking processes, minimising discrepancies and improving decision-making. Collaboration with project managers and stakeholders ensures seamless audit execution. Daily progress meetings facilitate issue resolution, process optimisation, and workflow improvements. Through proactive problem-solving and refined methodologies, asset tracking processes have been optimised, reducing project timelines by 10%. A strong advocate for continuous improvement and technology-driven efficiency, committed to enhancing IT asset management frameworks that align with business objectives and regulatory compliance. Passionate about driving innovation, accuracy, and security in IT asset auditing while ensuring high standards of governance and accountability.

Hyper Direct | Jun 2008 - Jul 2016

Operations Analyst

Responsibilities encompassed the comprehensive analysis of operational data to identify inefficiencies and streamline workflows, ultimately enhancing overall business performance. Developed and maintained a suite of reports, dashboards, and key performance indicators (KPIs) using advanced tools such as Excel and SQL, allowing for real-time monitoring and informed decision- making. Collaborated closely with cross-functional teams, including operations, finance, and IT, to implement targeted process improvements and automation strategies that significantly increased operational efficiency and reduced costs. This collaboration involved conducting thorough needs assessments, facilitating workshops, and ensuring alignment with organisational goals. Assisted in budget planning and financial forecasting by analysing historical data and market trends, providing insights that supported strategic decision- making and resource allocation. Conducted in-depth market research and benchmarking to identify industry best practices and inform business growth initiatives, ensuring the organisation remained competitive in a rapidly evolving market. Regularly presented findings, insights, and actionable recommendations to senior management, effectively influencing key operational decisions and driving strategic initiatives. Utilised data visualisation techniques to communicate complex information clearly and persuasively. Ensured compliance with company policies, industry regulations, and best practices by implementing robust data governance frameworks and conducting regular audits. This proactive approach safeguarded the integrity of data and supported the organisation's commitment to ethical standards and operational excellence.

My Education

Take a look at my formal education

Bachelor of Science (BSc), Computer ScienceBrunel University | 2008

Information and Communication Technology Southgate Collage | 2003

About Me

Mohamed hasn't filled in a bio text

Create Your Data Portfolio for Free