Banner Image

All Services

Programming & Development

Data Analyst

$50/hr Starting at $25

I am a Certified Fraud Examiner with 18 years of experience in Financial and Data Analysis, Forensic Accounting and Analysis and Litigation Support. Recent engagements I was involved in: - A 480 million dollar Ponzi Scheme that spanned over a decade. Work involved analysis of over 50 entities, identification of "Net Winners", "Insiders", and Borrowers for litigation. Created and maintained an Excel database comprised of all transactions for all 50 plus entities. Dataset consisted of over 80,000 rows of transactions. Created tranches by Entity, by year, by category (investor, borrower, vendor, etc.) and performed complex analysis which was used by attorneys to successfully litigate all cases. Billings were reviewed and approved by the SEC, the Court, and the Federal Receiver. - A Partnership Dispute under Receivership involving over 20 million dollars in assets. Investigated allegations of fraud, created an exhaustive funds flow analysis of all money in and out of 7 entities. Created and maintained a credit card database comprising thousands of transactions involving 40+ credit cards over a 13 year period. Created a database in Excel to analyze all transactions in the Entities' QuickBooks files. Identified thousands of transactions that were charged to the wrong accounts in QuickBooks. Reconciled loan accounts to the funds flow analysis in Excel. I am efficient and comfortable with working with large datasets. I have significant experience with cleaning data

About

$50/hr Ongoing

Download Resume

I am a Certified Fraud Examiner with 18 years of experience in Financial and Data Analysis, Forensic Accounting and Analysis and Litigation Support. Recent engagements I was involved in: - A 480 million dollar Ponzi Scheme that spanned over a decade. Work involved analysis of over 50 entities, identification of "Net Winners", "Insiders", and Borrowers for litigation. Created and maintained an Excel database comprised of all transactions for all 50 plus entities. Dataset consisted of over 80,000 rows of transactions. Created tranches by Entity, by year, by category (investor, borrower, vendor, etc.) and performed complex analysis which was used by attorneys to successfully litigate all cases. Billings were reviewed and approved by the SEC, the Court, and the Federal Receiver. - A Partnership Dispute under Receivership involving over 20 million dollars in assets. Investigated allegations of fraud, created an exhaustive funds flow analysis of all money in and out of 7 entities. Created and maintained a credit card database comprising thousands of transactions involving 40+ credit cards over a 13 year period. Created a database in Excel to analyze all transactions in the Entities' QuickBooks files. Identified thousands of transactions that were charged to the wrong accounts in QuickBooks. Reconciled loan accounts to the funds flow analysis in Excel. I am efficient and comfortable with working with large datasets. I have significant experience with cleaning data

Skills & Expertise

Data AnalysisExcelFinancial SupportFraud AnalysisFraud MitigationMicrosoft Excel Powerpivot

0 Reviews

This Freelancer has not received any feedback.

Browse Similar Freelance Experts