Manager Data

Thomas McDonald

******.********.****@*****.*** 773-***-**** 120 N. Green St. #702 Chicago, IL, 60607

DATA ANALYTICS MANAGER

Accomplished project leader and client service manager with over years of consulting experience, who specializes in complex data analyses and business code development. Assists clients by transforming data into information to facilitate better decisions while mitigating risks. Extensive experience developing database and code driven models to analyze transactional and customer data from large corporate databases. Expert at integrating data from multiple client systems and publicly available sources. Skilled in data acquisition and validation, database design and maintenance, complex query construction, custom programming, report generation and application development.

Areas of Expertise

Data Analytics Database Design Process Automation Programming Business & Financial Modeling Project Management Training & Coaching Risk Management Research & Analysis Negotiations Proposal Writing Communication

PROFESSIONAL EXPERIENCE

PRICEWATERHOUSECOOPERS, LLP / TAM – Chicago, IL November 2014 to April 2016

Manager, Forensic technology solutions

Managed complex business dispute and investigative matters combining data analysis techniques, information technology tools, joint business relationships, and information management principles while understanding the unusual environment created by these types of matters for clients;

Merged acquisition data between multiple pharmaceutical companies enhancing drug product information by incorporating Medi-Span and FDA data sources. A Tableau server was then implemented to visually display information on multiple interconnected dashboards showing sales treads and pricing details related to Wholesale Acquisition Cost (WAC) and Average Wholesale Price (AWP) so the client could make informed decisions about a single drug or the entire drug portfolio.

Managed 15 consultants in searching and producing discovery responses for a class action lawsuit involving 3 different legacy email systems while adhering to strict documentation guidelines required to show proper and complete collection.

Developed technical coding programs for Cybersecurity matters that could read and normalize server log data to more quickly determine possible breaches. The program incorporated over 30 different sources of hash signatures and internet protocols (IP) from shared sites, the FBI, and paid watch guards. Additionally, the program incorporated a library of rules which triggered alerts when certain scenarios were found to be out of alignment with typical behavior for a given system.

Detected a fraud scheme while assisting a company migrating legacy data to a newly implemented data storage system. Control totals, missing data elements, and research lead to a multi-million dollar internal investigation and employee prosecution.

Undertook firm wide initiatives to test and implement new technologies to gain a competitive advantage in the market space including: introducing elasticsearch, upgrading collection toolkits, researching and implementing third-party products and product add-ons, and maintaining joint venture initiatives with companies such as Google.

DELOITTE, LLP – Chicago, IL April 2013 to October 2014

Manager, Transactions and Business Analytics

Managed the reconstructing of accounting and business records providing detailed analysis to uncover essential facts and insights while utilizing a range of forensic investigation skills to help clients understand and analyze events or issues most pertinent to the client;

Conducted a thorough review of transaction monitoring rules implemented by a bank excessing the rules full reasonableness and effectiveness. The review results were reported directly back to the Chief Anti-Money Laundering office (CAMLO) and his team detailing issues of concern and the necessary correction steps. A second phase of this project was then initiated by the bank to have our team implement the corrections.

Implemented a customer risk rating (CRR) model to assist a bank with missing Know Your Customer (KYC) informational requirements. The model used a statistical approach to fill in information gaps along with automatically generated surveys to gain the remaining information about customers.

Applied proprietary database searching techniques to identify potentially fraudulent transactions across systems located in multiple countries and coded in different languages. Suspicious transactions were then prioritized for reviewers in order to either clear or escalate the transactions for further review.

Audited a statistical sample of alerts and associated Suspicious Activity Report (SAR) generated at a bank. The audit results indicated possible threshold changes were needed by the bank. The bank contracted with Deloitte to perform the same analysis for another three years.

Created a database structure to reconcile a company’s sales and part lists to Request for Quotations (RFQ) in relation to a price fixing allegation. The database was then used to quantify possible damages related to an ongoing Department of Justice (DOJ) investigation.

Developed and coded the initial library of AML monitoring rules for the Deloitte Analytical Platform (DAP) consisting of a comprehensive list of the most common customer, account, transaction, wire, behavior, etc. rules. All the rules were written using a dynamic code structure allowing any user of the DAP system to apply the code/rules to any AML client.

Investigated a fraud scheme where employees were using insurance money to discount products sold or leased to customers. Data analytics was applied to identify a pool of possible employees involved in the scheme reducing the cost of a full electronic discovery investigation while estimating possible monetary damages for settlement.

Drafted and presented proposals for new engagements with prospective clients. The proposals led to over 2 million dollars in new client work.

NAVIGANT CONSULTING, INC – Chicago, IL June 2002 to March 2013

associate director, Disputes & Investigations

Developed, performed and supervised detailed financial, accounting, economic and statistical analyses while directing, reviewing and developing computer models including complex database and spreadsheet analyses;

Developed two third party software products including: FATCA FIND SM, a web-based tool that simplifies the Foreign Account Tax Compliance Act (FATCA) reporting and Decision Point SM, a Third Party Onboarding and Risk Scoring Tool.

Provided analytical programming and technical assistance to a large team of consultants needing to use hard drive forensics to develop a case against alleged trade secret theft employees while processing hundreds of gigabytes of unformatted hard drive unallocated space. A procedure was designed and coded to organize, de-duplicate, and format the information allowing the team to quickly research and cross reference phone records, internet history, and email fragments related to the employees. The research was used to develop additional allegations against the employees and stop all engaged in competitive acts prescribed by the company’s “Non-Compete” agreements.

Created a JAVA application to Login, search, and download documents and page images from a client’s SharePoint site. At the onset of the investigation, there was no software program available to meet the client’s demands and preservation agreement. This program was used extensively by the client to preserve the company’s collaborative content and intellectual property during ongoing investigations.

Developed the core database model used to evaluate the reasonableness of the price paid by a U.S. parent company for transferring Intellectual Property (IP) rights to its foreign subsidiaries. The analysis involved re-pricing over 25 million invoice line items at their published list prices after considering specific pricing attributes associated with each line item. The model also established the product version associated with each line item invoiced, which was not readily available from the client’s data, to ensure royalty rates were consistently applied to the appropriate product version sales.

Constructed a comprehensive investor information database to house all data records related to former fund investors. The database added client value by implementing the following: import controls, login and change tracking capabilities, generation of quick and meaningful reports, password and lockout security features, and data input requirements designed to prevent data entry errors.

Acquired and produced forensic images of employee hard drives for a Fortune 1000 company’s voluntary participation in a SEC IPO investigation. Additionally, developed a program to assist this company with further GSA and DOJ investigations while tracking subpoena performance, collaborating with lead attorneys, and soliciting hold notice responses.

Proved a major telecommunications wholesaler was giving its largest client the lowest price on all product lines across all world markets according to its Most Favorable Nations (MFN) agreement. This was done by reconstructing the wholesaler’s pricing books, making all warranted contract pricing adjustments, and performing a series of predefined contract tests.

Acquired over 100 forensic images directly from employee hard drives or remotely through the internet including indexing and searching hard and electronic documents while maintaining quality controls during attorney privilege review.

Created one of the first e-Discovery processing tools. The tool took the place of 22 analysts while providing a more structured approach, minimalizing human error and incorporating quality control mechanisms.

EDUCATION / PROFESSIONAL ORGANIZATIONS

Bachelor of Business Administration - Finance – Texas Christian University – Fort Worth, Texas

Bachelor of Science - Minor: Computer Science – Texas Christian University – Fort Worth, Texas

Teaching Assistant - Computer Science Instructor – Texas Christian University – Fort Worth, Texas

ACFE: Association of Certified Fraud Examiners - Fraud Examiner

IDFPR: Illinois Department of Professional Regulation – Managing Broker

Contact this candidate