Senior Consultant Forensic Technology & Discovery Services - Fraud Investigation & Dispute Services
London, Gb
E-discovery: acquiring, processing and analyzing Unstructured and Structured data from computers, mobile devices and databases, using tools such as Encase, FTK, TD1, Linux scripts, Intella, Relativity, LexisNexis Law, Xry, Oxygen, among others. Evidence handling and preservation. Chain of custody.Due diligence on companies and persons.Data Analytics (Forensic and Classic) and Journal Entries tests for companies (including Fortune 500) from several industries such as Gas&Oil, Banks, Retail, Healthcare, Tourism, among others. The data analysis included: searching for anomalies, patterns, trends, internal control failures in order to identify risks and fraud opportunities. Examples of data analyzed are: financial transactions (journal entries, general ledger), procure-to-pay (purchase orders, invoices, accounts payable, payments), payroll, vendor schema, expenses.ETL: Receiving/extracting the data from different sources, data cleansing, data loading into SQL Server. Performing verification tests to confirm the integrity and consistency of the loaded data. Query development for each task.Data visualizations based on the client needs. Reports to show findings and significant information found during the analysis.Technologies: SQL, complex T-SQL, Ms SQL Server, SSMS, ACL, SAP, Oracle, Spotfire, Tableau.