DLA PiperData Analyst
Apr. 2021 - Feb. 2023Data Analyst working on Vector, a global programme to replace the legacy DLA Practice Management System. This is core to the operations of the firm, handling the creation and distribution of bills, revenue management, core accountancy functions and controls. • Legacy source system: Thomson Reuters Elite • Target system: Fulcrum SNAP (a version of SAP S4 HANA customised for use by law firms) • Conduct data analysis in order to identify the target population for migration using the appropriate business rules • Map data from the legacy system to the SAP templates provided by the supplier (Fulcrum Global Technologies) • Conduct an impact analysis of migrating some data objects (master and transactional data) and leaving others based on the relationship with other data objects in the data model • Design, develop and execute end to end data migration scripts and automated ETL processes • Execute multiple end to end mock load data migration cycles prior to cutover • Produce documentation on data profiling and data transformation and create reconciliation reports • Support the technical/ business users with data testing and fixing of any data defects raised • Successful data migration of:
o 8,000 legal professionals across 50 offices in 29 countries
o 80,000 clients
o 95,000 client contacts
o 370,000 legal matters
o 2,500,000 Time and Cost entries
o 4,000,000 Client, Matter, Timekeeper and Band Level charge rates