Syed Rahman
London
Summary
Seasoned data-driven analyst with over a decade of experience in finance, healthcare, and technology industries. Specialising in data analysis, automation, and reporting using SQL, Power BI, and Excel to extract insights from complex datasets, streamline processes, and provide actionable recommendations. Actively improving skills with Python and Data Analytics to advance proficiency in modern data techniques. Proven track record of boosting decision-making, efficiency, and profitability with innovative data-driven solutions.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Payments Operations Analytics Manager
Zepz
02.2025 - 06.2025
- Lead a cross-functional team of data analysts, accountants, and operations managers focused on end-to-end payments reconciliation, data integrity, and loss prevention.
- Used Databricks and Python alongside SQL to perform complex data analysis, automate reconciliation processes, and build scalable dashboards that track and surface financial discrepancies.
- Investigated and resolved mismatched transactions internally and with external partners to ensure accurate and timely financial reporting.
- Collaborated with product and engineering teams to implement early loss detection systems and improve payment workflows across the organisation.
Payments Analyst
Lightspeedhq
04.2022 - 01.2025
- Creating and optimising SQL queries in BigQuery using advanced techniques such as window functions, Common Table Expressions (CTEs), aggregation, joins, and CASE statements for key financial reports (sales, revenue, costings, variance checks, money movement issues, promotions, and credits).
- Automated reconciliation processes using Power Query and Power Pivot, reducing manual intervention by 40% and enabling the analysis of large datasets.
- Developed data models to track sales volumes and revenue across regions and payment methods, enhancing visibility for decision-makers.
- Conducted variance checks and root cause analysis for discrepancies, collaborating with payment system support to resolve external issues.
- Produced daily/weekly/monthly account-level reconciliation reports, streamlining reporting and improving data accuracy by 20%.
- Systems: Google Sheets, SQL (BigQuery), Excel (Power Query, Power Pivot), Power BI
Finance Business Partner
Network Homes Ltd
05.2020 - 04.2022
- Streamlined the journal import process for large data sets using Power Query, reducing processing time by 50%.
- Created and automated utility bill cancellation reports, leading to a 15% reduction in debt by identifying billing discrepancies early.
- Developed Power Pivot models to analyse financial trends and support budgeting decisions, providing actionable insights for senior management.
- Implemented Power Apps for expenditure tracking, improving financial control and reducing processing errors by 25%.
- Systems: Infor SunSystems, Power Pivot, Power Query
Accounts Payable & Treasury Analyst
City of London Corporation
07.2018 - 04.2020
- Reconciled AP ledgers and bank payments, ensuring accurate financial records and reducing discrepancies by 30%.
- Created dashboards in Excel using Pivot Tables, providing management with KPIs and supplier performance insights.
- Managed the purchase order process, improving supplier payment timelines and ensuring compliance with corporate policies.
- Systems: Oracle R12, MS Excel
Data Analyst
University College London Hospitals NHS Foundation Trust (UCLH)
12.2016 - 07.2018
- Analysed complex datasets to validate patient pathways, using SQL queries and Excel to generate detailed reports.
- Automated waiting list reports for diagnostics and outpatients, improving efficiency and reducing manual workload by 35%.
- Participated in audit meetings, providing actionable data insights to improve patient care and optimise operational processes.
- Systems: MS Access (SQL Queries), MS Excel
Education
BSc (Hons) - Information Systems
Greenwich University
Skills
- Power BI
- MS Excel Advanced
- Google Sheets
- Python programming
- Data Automation
- Communication Tools
- Business intelligence
- SQL programming (Databricks and BigQuery)
Certification
- Data Analyst with Python, DataCamp, In Progress
- Data Analyst in SQL, DataCamp, In Progress
- MySQL Specialist, Maven Analytics, 02/01/23
- Thinking Like an Analyst, Maven Analytics, 01/01/23
- AAT Level 2 Certificate in Accounting & Finance
- Communicating Numbers: Effective Visualisation of Data, Udemy
Languages
English
Bilingual or Proficient (C2)
Arabic
Intermediate (B1)
Timeline
Payments Operations Analytics Manager
Zepz
02.2025 - 06.2025
Payments Analyst
Lightspeedhq
04.2022 - 01.2025
Finance Business Partner
Network Homes Ltd
05.2020 - 04.2022
Accounts Payable & Treasury Analyst
City of London Corporation
07.2018 - 04.2020
Data Analyst
University College London Hospitals NHS Foundation Trust (UCLH)
12.2016 - 07.2018
BSc (Hons) - Information Systems
Greenwich University
Similar Profiles
Carol WarugongoCarol Warugongo
Global Talent Acquisition Lead at ZepzGlobal Talent Acquisition Lead at Zepz
Amal AlGhrayebAmal AlGhrayeb
AML/ COMPLIANCE LEAD at ZepzAML/ COMPLIANCE LEAD at Zepz
Cesar ColomaCesar Coloma
Program Manager at ZepzProgram Manager at Zepz
Daiyaan RahmanDaiyaan Rahman
Data Inputter at Bounds Green Group PracticeData Inputter at Bounds Green Group Practice
Rebecca DominatoRebecca Dominato
Mid Market Expansion – Client Development Manager at Smartsheet IncMid Market Expansion – Client Development Manager at Smartsheet Inc