Reza Nematollahi
Summary
Highly skilled Excel Wiz and results-driven Data Analyst with a proven track record across various industries. Extensive background in transactional finance, excelling in Excel and Salesforce CRM for uncovering valuable insights through data analysis and trend identification. Passionate about problem-solving and driving efficiency through advanced Excel functionalities and automation tools. Dedicated to continuous improvement, delivering actionable insights for informed business decisions.
Overview
4
4
years of professional experience
Work history
Accounts Receivable Officer
Birmingham City Council
Birmingham
05.2023 - Current
- Responsible for cash allocation through Oracle Fusion and effective debt collection via phone, email, and letter communications.
Data Analyst / Billing Specialist
Birmingham
06.2022 - 01.2023
- Led a critical data reconciliation project representing 10% of the business's total revenue
- Conducted root cause analysis to identify data inaccuracies behind monthly data imports into Salesforce
- Performed mass SOQL import/update on various billing objects and built ad-hoc reports via SOQL to extract data from multiple objects.
Career Break
11.2021 - 06.2022
- Renovated a new property for personal reasons.
Franchise Finance Admin
04.2021 - 11.2021
- Managed daily credit card reports, reconciliation, and journals for 235 stores
- Ran weekly Direct Debits process, statements, cash allocation, and various checks for accurate figures
- Assisted management accountants with transactional finance tasks and queries.
Accounts Payable
Poundland
Walsall
10.2020 - 03.2021
- Undertook full responsibility for all EDI suppliers, resolving stock disputes and statements via phone and email
- Improved processes via Excel by formulating tasks with macros and VBA from scratch
- Prepared and reconciled critical accounts for CHAPS payments and cash allocation
- Assisted colleagues with Excel and IT issues.
Finance Assistant
Bromford Housing Association
Wolverhampton
09.2019 - 09.2020
- Managed the main shared mailbox and delegated emails to individuals within the business
- Monitored and analysed all rejections daily, contributing to the invoice automation project.
Education
HND - Accounting & Finance
University of Wolverhampton
2018
Business Practitioner Level - undefined
Dudley College
2011
CompTIA A+ Certificate, Cisco CCNA (CCNA 1, CCNA 2). - ITQ Level 2 (Excel, Publisher, Access, PowerPoint), Web Design Level 2, Numeracy Level 2, and Literacy Level 2. - undefined
Pensnett High School
2008
Skills
- Advanced Microsoft Excel Power Query M Code VBA Data Analysis Data Modeling ETL Accounts Receivable Accounts Payable
- Problem Solving Root Cause Analysis and SOQL (Salesforce Object Query Language)
Accomplishments
- Advanced Formulas and Functions, Power Pivot, Power Query, M-Coding, VBA, and Essential Training
- Proficient in data manipulation, formulas, analytics, automation, and ETL
- Salesforce Certified Associate: Achieved designation as a Salesforce Certified Associate
- SQL for Non-Programmers: Proficient in SQL after completing the course
- Power BI: Dashboards for Beginners: Experienced in creating Power BI dashboards
- Root Cause Analysis: Skilled in identifying and resolving business problems using root cause analysis
- Key Achievements:
- Birmingham City Council:- Automated statement reconciliation using Excel's Power Query, reducing errors, and saving time
- Created real-time reporting dashboard for accounts receivable data, improving decision-making
- Utilized VBA for enhanced automation and increased team productivity
- Demonstrated proficiency in data modelling by consolidating data from multiple sources
- One Advanced:- Developed analytical spreadsheets identifying £3 million un-billed lines and £700K in duplicate billings
- Poundland:- Automated EDI data manipulation, reducing task completion time from 7 to under 1 hour
- Designed efficient AP reconciliation templates with macros, improving overall efficiency
- Bromford:- Configured AP shared mailbox with customized Quick Steps, enhancing monitoring and management.
Timeline
Accounts Receivable Officer
Birmingham City Council
05.2023 - Current
Data Analyst / Billing Specialist
06.2022 - 01.2023
Career Break
11.2021 - 06.2022
Franchise Finance Admin
04.2021 - 11.2021
Accounts Payable
Poundland
10.2020 - 03.2021
Finance Assistant
Bromford Housing Association
09.2019 - 09.2020
HND - Accounting & Finance
University of Wolverhampton
Business Practitioner Level - undefined
Dudley College
CompTIA A+ Certificate, Cisco CCNA (CCNA 1, CCNA 2). - ITQ Level 2 (Excel, Publisher, Access, PowerPoint), Web Design Level 2, Numeracy Level 2, and Literacy Level 2. - undefined
Pensnett High School
Similar Profiles
Oi Yan, Sharon FongOi Yan, Sharon Fong
General Assistant at City Serve Birmingham City CouncilGeneral Assistant at City Serve Birmingham City Council
Thomas McCabeThomas McCabe
Volunteer at Birmingham City CouncilVolunteer at Birmingham City Council
Amandeep BhorjeeAmandeep Bhorjee
Learning Development Manager and DSL at Birmingham City CouncilLearning Development Manager and DSL at Birmingham City Council
Christos IoannouChristos Ioannou
Employment Paralegal at Birmingham City CouncilEmployment Paralegal at Birmingham City Council
Sue HamadySue Hamady
Accounts Receivable Officer/Key Accounts at News CorpAccounts Receivable Officer/Key Accounts at News Corp