Requests
8
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
RLDatixTechnical Delivery Consultant
Mar. 2023 - Oct. 2024London Area, United KingdomTechnical Delivery Consultant working with the RLDatix Services team on various projects for Maritime and Defence customers such as NATO, the Royal Fleet Auxiliary and Norwegian Cruise Lines. • Development and configuration of data mappings and change tracking to facilitate selective two way real time data synchronisation via the Migration Bridge • Development of ETL processes to bulk transfer data from the legacy database • Interpretation of complex reporting requirements into web enabled client dashboards, including standardisation of common database objects for reuse across multiple related reporting scenarios where possible • Development of a scalable dynamic database synchronisation tool to:
o Identify deltas between two versions of the system
o Validate data and identify any issues that applying those changes may cause o Automated fix of the above where applicable
o Apply the changes to the target
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
FTI ConsultingData Analyst
Feb. 2020 - Mar. 2020London, England, United Kingdom
CapitaData Analyst
Aug. 2019 - Dec. 2019London, United KingdomData Analyst working on a major SAP migration project as part of the wider SFF (Smarter Faster Finance) programme • Work closely with Data Preparation Manager to review existing transformation processes relating to 150million+ transaction records ingested into the migration database. o Identify and advise on performance issues with existing transformation processes and scripts
o Normalise data, use alternative field data types and sizes and add keys, indexes and constraints as appropriate
o Further enrich data for migration and produce extracts as appropriate • Development of ETL processes in order to ingest and transform forecasting data for migration o Ingest of initial feed of existing forecast and supporting reference data for mapping from a combination of flat text files and Excel spreadsheets
o Identification of potential duplicate records, records with key missing attributes such as profit and cost centres, and exclude records not requiring migration
o Enrich, transform and export data to the required format for migration and load into the new system
o Perform an end-to-end reconciliation at every stage of the above • Design and build a set of dynamic ETL processes to ingest a series of complex Excel templates manually completed by the Business o Single code base for importing multiple individual ranges for variously Sales Contracts, Projects and Products & Services
o Validation of ingested data o Generation of exception reports for feeding back to the business • Design and build a “Self Service Reporting Tool” to dynamically generate reports and allow end users to extract their own data from the system, drastically reducing the need for ad hoc reports to be created • Exhaustive documentation of all the above following an announcement in late 2019 that the entire project was to be put on hold
EYSenior Solutions Designer
Mar. 2017 - Jun. 2019London, United KingdomSenior Solution Design Engineer working on a regulatory mortgage remediation project for Lloyds Bank Group. • Requirements gathering and definition of specifications for key data points and source data files • Design and build of dynamic data ingestion process • Data analysis, identification of population for remediation • Standardise data formats from diverse source systems in order to process remediation • Identification of subset of population requiring case review • Calculation of customer redress and batching of data for processing by our banking client • Management reporting throughout the project lifecycle.
Barclays Wealth ManagementData Analyst
Sep. 2014 - Dec. 2016London, Greater London, United KingdomData analyst and developer on a regulatory remediation programme for Barclays Wealth.
• Rigorous analysis of Barclays data warehouse systems in order to identify, cleanse and de-duplicate target population for remediation (Teradata / Oracle / SQL Server) • Design, development, support and enhancement of MS Access / SQL Server case review tool, including o The underlying back end SQL Server database tables, views, functions and stored procedures
o The various ETL processes for importing / exporting / transforming data (SSIS / VBA)
o The MS Access / VBA front end tool allowing the case handlers to manually review the cases
o The table-driven workflow logic driving the case handlers through the review process o The progression of cases through the various statuses in the review process
o The remediation calculation itself where appropriate
o Levels of user access to the system depending on their respective membership of user groups and their specific update permissions to specific cases • Reporting / MI on a case-by-case and overall project summary level
AXA UKDatabase Developer
Jan. 2008 - Jun. 2014• Design, development and support of key invested asset reporting database for the Group Investment and Treasury team • Manage and troubleshoot key monthly data feeds, involving design, development and troubleshooting of various ETL processes in SSIS, Informatica and MS Access / VBA • Developing and structuring robust database architecture and supporting reporting functions to facilitate client requirements, involving development of sometimes complex T-SQL, Views, Functions and Stored Procedures • Managing and maintaining all databases and report processing functions, ensuring that a complete and accurate database is available • Ensuring efficient and effective processes and controls are in place to meet key SOX compliance • Managing investment database and systems change to support new investment initiatives – both in house and with our outsourced partners at AXA Business Services based in India • Bringing new members of staff up to speed with business as usual processes, arranging necessary training and ensuring documentation is complete • Mentoring, training and providing ad hoc support and advice.
BSkyBDatabase Developer
Dec. 2006 - Dec. 2007Development, maintenance and support of key bespoke project management database, tracking key project finance and life cycle information.
FusionRemedy Developer
Sep. 2006 - Nov. 2006On site support and remedial development services to Fusion's client Sit-up TV on their mission critical back end Remedy / SQL Server based systems that drive their key TV Auction business (Remedy versions 5, 6 and 7). Remedy
Remedy Administrator
SQL Server 2003
SQL Enterprise Manager
Query Analyser
MS DTS
Euroclear SA / CrestCo LtdAnalyst Developer
Jan. 2001 - Aug. 2006Design and development of Internal Applications and the administration of live database environments.
Insignia Richard Ellis (now CBRE)Database Manager
Jan. 1999 - Jan. 2001Database manager for Corporate Real Estate Services team
W P Thompson & CoAdministrator
Jan. 1996 - Jan. 1999IT Administrator for 20 users in London office / Patents Secretary
Intch is a Professional Networking App for the Future of WorkSee more people like Tim on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
607696 people
16
SHEQ & Training Coordinator @ M Group Telecom
16
Project Manager @ Vodafone
15
Wellness and Health Specialist
168833 people
15
Wellness and Health Specialist
22
HR Specialist
22
Data Engineer @ EasyJet