Ben D

Proven track record supporting 2000+ users, building scalable performance dashboards, and managing system validation in complex customer-focused environments. Strong technical expertise in Aderant Expert Classic (Generic Importer/Scheduler, Alerts, DocuDraft, Reports), Aderant Framework, Design Studio, Expert Time, Expert Rates, Security Manager and Expert Administration. Proficient in Microsoft SQL Server, T-SQL, SSRS, SSIS, SSAS, PowerShell, and REST APIs.

Proven track record providing 2nd/3rd line support to 2500+ users, resolving complex billing, WIP, disbursements, GL issues, and delivering system enhancements. High level of discretion and confidentiality when handling sensitive financial information.

Finance Systems Analyst - Smart Managed Solutions - London

(2026-01)

Provide comprehensive finance system and 2nd/3rd line application support for 500+ users, bridging the gap between Finance and IT.

• Deliver 2nd and 3rd line application support to ensure swift issue resolution and high-quality system performance.
• Lead end-to-end ERP implementations and configuration updates for Dynamics 365 Business Central to support business changes.
• Engineer automated data flows for the central database warehouse, accelerating technical processing speed and boosting reporting reliability.
• Conduct targeted technical training for diverse systems users, ensuring proper alignment with support standards.

Financial Systems Analyst - Fieldfisher LLP - London

(2020-01 - 2026-01)

Managed complex data integration pipelines and designed business intelligence dashboards.

• Built performance dashboards and robust reporting systems using Power BI to serve 2,000+ active system users with actionable insights.
• Optimized system warehousing architecture using SQL Server to dramatically improve troubleshooting speed and data governance workflows.
• Act as administrator for eBilling Hub and BillFiler, ensuring systems availability meets business needs across Finance, Fee Earners, Secretaries, HR and BD staff.
• Provide senior technical & functional 2nd/3rd line support, troubleshooting and managing escalated calls, reducing escalations through documentation and knowledge handover.
• Develop and optimize T-SQL queries, stored procedures and data endpoints to enhance financial data processing, BI and integration with web applications.
• Create ad-hoc reports and custom SSRS reports in response to business requests; source data via standard PMS reports or custom SQL queries unsupervised.
• Support monthly system maintenance and financial month-end closures, running regular system routines and ensuring data integrity controls.
• Identify opportunities for system enhancements and lead finance systems improvement projects from requirements gathering, configuration, testing, implementation, training to handover.
• Perform SQL analysis for troubleshooting, data validation and project requirements; diagnose and resolve software defects, escalating when required.
• Assess vendor roadmaps, new functionality and AI capabilities for potential adoption; assist with evaluation of upgrades, patches and fixes.
• Deliver business requirements, level of effort estimates, system specifications, data mapping and support documentation; create knowledge-based articles documenting resolutions.
• Collaborate with business partners to translate business needs into functional/system requirements; support UAT definition, coordination and execution.
• BI reporting on the financial health and performance of the firm, developing, publishing, and scheduling Power BI dashboards to align with business requirements, while efficiently managing resources and optimising UI and UX for timely information dissemination across all Legal Entities. Analysis Services reporting models, visual reports, dashboards, and KPI scorecards.
• Designed and integrated data flows based on business logic for loading into the data warehouse. Facilitated data integration from multiple sources, including Cascade, Intapp, Interaction, and Evergreen (Dynamics 365 F&O).
• Conducted Power BI development and executed data preparation, data gateway, and data warehousing projects. Utilised SQL for connecting to data sources, importing, and transforming data for Business Intelligence.
• Led project design, documentation, prototyping, requirement analysis, process automation and integrated Power BI with Dynamics (F&O) for management reporting. Challenged and enhanced existing controls and processes to boost the efficiency of the Financial Reporting Team.
• Expertise in advanced calculations on datasets, such as DAX, and employed analytical thinking to translate data into informative visuals and reports, utilising Agile methodologies.
• Intapp time reporting across the firm by Legal entity, Department, Fee Earner, Client Partner and Matter Partner.
• Migrated legacy data from Elite, Aderant systems onto Dynamics 365 (F&O).

Technical MA - Power BI Lead - Furness Insurance Services Group - London

(2021-01 - 2021-12)

Designed database models for reporting and validation.

• Designed high-performing SQL database models and Analysis Services architectures to support reporting and validation.

Financial Reporting Manager - Estuary Housing Association Ltd - Southend

(2020-01 - 2020-12)

Technical lead for financial application process optimization and validation procedures.

• Established strict data validation and testing procedures, ensuring high reporting accuracy and complete system compliance in a housing association context.

Finance Manager - Fujitsu General Air Conditioning (UK) Ltd - London

(2014-01 - 2020-12)

Directed complex ERP integration projects across diverse operating modules.

• Directed a team of 5 in integrating MS Dynamics Navision 2016 ERP modules, successfully uniting CRM, Stock, and Finance operations.

Graduate - Fabric Analyst

Part-Qualified - CIMA