Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Charles TaylorBusiness Analyst - Data
Sep. 2022 - May. 2024
Cognizant Microsoft Business GroupAgile Business Analyst
Apr. 2021 - Aug. 2022London, England, United Kingdom
Foreign Currency Direct plcBI/Data Analyst
Nov. 2020 - Feb. 2021Work from homeo Data Analysis & SQL updates – updated stored procedures for all Power Bi reports that had old data sources. Used SSMS to amend stored procedures in data warehouse database called CHL Reporting. Ran Select queries as and when needed.
o BI Documentation project – created user and tech documentation and processes for BI/Data team. 100+ Power Bi reports created since BI team created in Jan 2019.
o Safeguarding Power Bi Report. Due to Brexit and Data migrations in Dec 2020. Created Power Bi report based on business requirements focusing on EU data. o Testing – assisted Data Architect with testing by creating test files using XML or CSV.
o Project EPFX Subscription switch off - Accurately identified EPFX reports using data warehouse in SSMS and reconciling against EPFX data in order to switch off remaining reports. EPFX contract to expire in Feb 2021.
o Attended daily sprints and fortnightly planning sessions with other developers, product owners and sponsors.
Dun & BradstreetAssociate Product Manager
Jan. 2020 - Jul. 2020London, England, United Kingdomo A Product Manager responsible for sunsetting legacy products as part of a generation shift in D&B’s portfolio of data products. o Data Analysis and requirement gathering. Accurately identifying customers using Finance, Salesforce, and product back office systems to determine an appropriate migration plan to another D&B solution.
o Prepared and facilitated product migration workshops in order to communicate plans for 2020. Included further meetings with Relationship Managers and Customer Success Managers in order to review client usage and set up meetings with clients to communicate notice of upgrade or sunset of product.
o Internal reporting of product usage metrics.
o Project Management support for the wider UK Product and Strategy Team.
Dun & BradstreetPartner Operations Data Analyst WWN
Sep. 2018 - Jan. 2020United Kingdomo Power BI Reports/Dashboards. Created a suite of Power BI reports for the WWN executive team, to monitor WWN Customer Service performance across different products.
o Senior Reporting Analyst for Partner Sales and Product Usage. This involved: -
o Generating Power BI Revenue Dashboards using WWN finance data.
o Developing a suite of Intercompany (GCTRS) & Cross-border (XBSP) reports using SAP Business Objects.
o Generating Power BI Product Reports based on Partner sales usage figures and WWN finance data.
o Data Quality. Power Bi dashboards and reports identify where there were gaps in the data e.g. WWN Customer Service Power Bi had null values in March 2018 to June 2018 in tier 2 level issues.
o Project Management. Decommissioning of D&B Link, which was a website for D&B partner when selling D&B products. This involved working with D&B internal stakeholders as well as multiple external partners to smoothly transition to a new SharePoint system. I was responsible for developing and managing the end-to-end project plan, based on PRINCE2 best practices. o Data Governance. Completed a privacy impact assessment for project partner hub.
Dentsu Aegis NetworkIT Procurement Support (Contractor)
Apr. 2018 - Jul. 2018London, United Kingdomo Data Analysis and Reporting. Carried out analysis of suppliers to assist with Procurement decision making. This involved aggregating detailed information from the Coupa ‘Procure’ system, data from IT Finance Team and then using advanced Excel skills (including pivot tables) to product consolidated reporting. o Supplier and Contract Due Diligence. Responsible for reviewing all existing suppliers and contracts saved in share point and transferred onto new Coupa ‘Procure’ system.
o Governance – set up Procurement Due Diligence process with the Head of IT Procurement.
Legal & GeneralIT Procurement Analyst/Project Management Support (Contractor)
Apr. 2017 - Apr. 2018London, United Kingdomo Data Analysis and Reporting. Carried out analysis of costs for suppliers using the Oracle Procure-to-Pay system as well as the Coupa Spend 360 system. This also involved using advanced Excel skills to produce consolidate reporting from the source systems.
o Contracts. Negotiated with vendors on establishing service agreements, where there was a mutuality of agreement between L&G and the vendor. Worked with legal team to establish service agreement for compliance with GDPR 2018.
o Statements of Work. Ensured vendors followed the agreed statement of work template in the signed contract such as payment terms and costs.
o Supplier Relationship Management. Maintained contact with suppliers, in order to establish good relationships. o Systems and Procurement/Projects cycle. Assisted project managers/programme managers with iProcurement queries as well as other stakeholders including how the procurement process worked and what assistance they needed.
o Project Hydra. Reviewed all supplier contracts for Mature Savings Division in Legal & General before its sale to Swiss RE.
Scipion Capital LtdMiddle Office
Nov. 2016 - Jan. 2017London, United Kingdomo Trade account reconciliation.
o Disbursements of trade transactions and repayments based on what was stated in the facility agreement.
o Worked with the Fund Administrator Centaur to make sure reconciliation of borrowers and bank statements were accurate.
o Calculated disbursements showing the level of interest.
o Daily bank reconciliation of trading and fund accounts.
o Set up online banking and updated registered address for BACB, Barclays Botswana and Lloyds etc.
o Provided cover for the Group Financial Controller. For example, updated reconciliation of operating accounts; made payments for suppliers and personnel; updated Centaur on payments and sent requested documentation. o Fund Audit. Coordinated with the auditor regarding queries concerning the fund. o Borrower Position. Captured every new trade from the point of delivery and ensured that the loan disbursement calculation was correct.
o Administration Support. Ensured that counterparties insurance was up to date with new trade deals and filed correctly. Ensured that Scipion’s relevant company insurance was up to date.
TOTALGeneral Accounting Analyst
Aug. 2015 - Nov. 2016Canary Wharf, Londono Overhead processing. This included invoices, expenses, credit cards (for example, Amex) and direct debits.
o Accounts payable and credit control. Responded to supplier and departmental queries regarding payments.
o Payment Runs. This involved running weekly BACS payments in all currencies.
o Daily Bank Reconciliation. Reconciled all treasury, trading, and corporate accounts on a daily basis. o Recharges and Salary Advances. Sent recharge invoices to different entities based on costs TGPL had paid on behalf of other entities. o Payroll. Posted payroll data into Sun, based on figures given by HR. o FX rates. Updated FX rates on a daily basis using ECB site.
o Balance Sheet Reconciliation. Reconciled the VAT euro control accounts; Belgian Wallonie Taxes; CTSS; TICGN and Biomethane Taxes; fixed asset and depreciation; aged creditors; salary advances; recharges; intracompany banks. o Month End tasks. This included AP ledger closure, cash settlement, bank reconciliation, fixed asset, depreciation, aged creditors, aged debt, revaluation, FX rates, accrual.
o Tax returns. Calculated and prepared VAT returns for Belgian Wallonie taxes; VAT TFCS quarterly return and CTSS; TICGN and Biomethane. o Systems. These included the expenses module, Sun and Vision Q&A, Sun Purchase Order system, Book and Launcher. o Project work. Implemented the Sun iPOS Procurement system.
o Audit, Internal Control and DOA. Used the DOA and set company guidelines, to make sure employees followed these guidelines. Trained new members of the team regarding the job role.
CMC MarketsAccounts Assistant
Oct. 2013 - Aug. 2015London, United Kingdom
Intch is a Professional Networking App for the Future of WorkSee more people like Sophie on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
172807 people
19
Operations Manager
30
Data Engineer
22
Technical Specialists @ Reuse Technology Group Ltd
25519 people
17
IT Manager/DevOps/Developer @ Redburst
25
Business Analytics Graduate @ Imperial College London
23
Automation Engineer @ Cognizant Technology and Solutions