Justin D. Email & Phone Number

London, United Kingdom

• Produce a broad range of compensation analytics such as the banks gender pay gap, equal pay reviews, gender diversity forecasts and remuneration system assessments• Run an annual compensation evaluation including market analysis utilising McLagan as market data providers. Developed guidance on how to use McLagan data and supported HRBPs in identifying appropriate salary ranges• Manage the year-end salary review system including its development and ongoing maintenance (this replaced a spreadsheet based process). Provide guidance and training in relation to year-end processes and produce compensation MI at both the management and executive level• Support the calculation of the banks profit share scheme allocations• Developed the MRT assessment framework, conduct MRT assessments (qualitative & quantitative) and report outcomes to the regulators and the banks Executive and Remuneration Committees. • Produce regulatory reports such as the Remuneration Disclosure (CRR A450), High Earners, Pillar 3 Remuneration, Related Party Disclosures and Director Emoluments. • Produce extensive MI such as headcount demographics, turnover, D&I, absence, recruitment and succession• Support the business on a range of adhoc projects, for example, supporting a major restructure by managing a HR tracker, providing attrition analytics to Exco and redundancy accruals to Finance. I also built a redundancy calculator tool saving payroll hours in reporting individual entitlements• Support the local HR teams by offering training and guidance on my specialist areas and introducing innovation such as a password generator that I created from excel (in response to new internal password requirements)

• Advanced BI and analytics. • Querying from Workday, Business Objects and Access• Creating dynamic Excel models. Construction of advanced lookups using index match indirect, pivots with data tables to create more robust models.• Partnering with HR teams such as Coverage, Recruitment, Diversity, Talent and Benefits to supply them with people analytics. • Delivery of monthly metrics, dashboards and ad-hoc analytics• Partnering with Firm Management and the Culture Committee to define, develop and deliver a suite of Firm Culture metrics• Provided an analytical deep dive into EMEA Infrastructure attrition • Created an Excel tool that allows coverage to deep dive into attrition. • Provided an analysis of hiring strategy used in a regional location• Led the EMEA analysis of the Employee Engagement Survey• Managed project to move UK overtime eligible population to new model to be compliant with ECJ rulings relating to holiday pay and overtime• Provided Gender Pay Gap analysis and worked with key business stakeholders to highlight areas of risk and direction for compensation spending• Created, trained and mentored a HR Excel super user group

London, United Kingdom

• Consolidation reporting for approx. 200 employees (based globally) who had packages over GBP 250k for the Remuneration Committee• Managed the monthly eligibility testing as part of the Pension Auto Enrolment process and provide payroll instructions for pension deductions• Introduced UKBA compliance standards by conducting an audit on the SAP immigration records for all UK employees, resolving compliance issues and introducing new procedures• Resolved data inconsistencies in the benefits system by reconciling against data in the primary HR system (SAP)• Projected costs for pensions auto enrolment based on various take up scenarios• Provided monthly absence accrual reports to Group Finance and distributed absence reports to local HR teams for UK payroll• Distributed monthly immigration reports to local UK HR teams• Trained local HR teams on new systems and processes• Introduced a UK initiative to capture and benchmark reasons behind turnover. • Saved the company circa £20,000 per year by creating P11D reports for payrolled benefits which was circulated to HMRC and approx 1,500 staff

• Coordinate the payroll data for a large number of international assignees across a global network• Provide leadership for client projects particularly in technology, process and controls development• Supervise operational payroll functions including: generation of payroll instructions, reconciliation of multi currency payroll reports, funding for client bank accounts to ensure assignees are paid in line with client SLAs• Manage outsourced vendors and global payroll providers • Winner of 2 internal awards for the development of a client interface tool (excel based) and the development of core software used to process client data

London, United Kingdom

• Facilitate a major systems upgrade involving the move of over 1500 staff to a new HR database• Train and mentor team in regards to new technology and processes• Provide maintenance of the central HR databases • Act as the principle point of contact for HR enquiries