Ben Collins Email & Phone Number

Google Sheets Training Courses: 100% Online and Self-Paced video courses to advance your spreadsheet and data skills.My goal is to help you learn the skills you need to be more productive with Google Sheets at work.Through bite-sized, action-oriented, 5 - 10 minute-long video lessons, you'll learn practical techniques you can apply to your own work today.Working with real-world datasets, including examples from industries like sales, marketing, real-estate and social media, you'll enhance your data and Google Sheets skills, so you can get clear insights quickly in your own work.

Educator helping individuals, small- and medium-size businesses work better with Google Sheets to understand their data. Topics covered include data analysis and creating data visualizations and dashboards.Previous client projects: - Performing data analysis and creating visualizations for a startup during their 3-day digital product sale. This helped focus marketing efforts by identifying best channels and times for promotions, as well as providing all members of the team with a near real-time, high-level view of sales progress.- Creating dashboards showing key financial metrics and sales agent metrics for a real estate firm. Helped client move from viewing rows of data in a spreadsheet to seeing that data in a visual format. The sales agent dashboard consisted of weekly, monthly and yearly leaderboards, on display to the whole team, to show progress and motivate the team.- Analysis of customer order data to calculate estimated lifetime value, retention rates and churn, for a food delivery startup. Tasks included data cleaning, writing custom queries in MySQL to calculate a number of different metrics, including retention, churn and lifetime value, creating data visualizations and report writing.

New York, Ny, Us

I taught three iterations of the 10-week Data Analytics course at General Assembly, teaching SQL, Excel, and Tableau to extract, analyze, and illustrate real‐world data.I also taught multiple Excel (beginner and advanced), Data Viz and SQL classes and workshops.

London, Gb

Core team member in three large multi-million dollar voluntary disclosures to U.S. regulators regarding breach of sanctions regulations. Conducted historical reviews of transaction data, financial data and customer data, to discover the extent and nature of the issues and prepare mitigating arguments and remediation steps. Specific tasks and results included:- Collating raw structured data from numerous sources (text files, pdfs, excel files, csv files) and using Excel and SQL for data analysis. Developed VBA macros to automate processes that previously took many hours to complete- Testing data deliveries to ensure accuracy and completeness of data at a high level (e.g. no data gaps) and micro level (e.g. no corrupt records)- Developing methods in Excel using formulas, pivot tables and VBA to analyze financial payments. - Creating dashboards and presentation tables to show key metrics and trends clearly and concisely to senior executives- Descriptive analytics: use of Excel pivot tables, filters and SQL queries to deliver timely, insightful answers to ad-hoc questions from the legal team and clients- Hypothesis testing: formulated hypotheses about specific characteristics within datasets, then designed and implemented solutions in Excel to test for these characteristics- Rigorous quality control testing of data analysis and results to ensure consistency and accuracy- Preparing results to go before U.S. regulatorsAdditionally, I worked as the lead forensic accountant on a number of Foreign and Corrupt Practices Act (FCPA) cases, investigating companies with high-risk business and performing comprehensive risk assessments and reviews of books and records. I also worked on a number of smaller accounting cases, including serving as the lead forensic accountant on a breach of contract case concerning the valuation of a technology company.

Boston, Ma, Us

Spent 3.5 years as a Forensic Accountant on the Investigations team. Projects included:- Investigations, including: systematic expense claim abuse by employees; the collapse of an international money transfer company; individual accused of money laundering; and fraudulent restructuring practices of a large multinational technology firm- Several large loss of profits claims in the oil and gas sector, including: breach of contract between a gas drilling company and a company leasing the drilling platform; breach of contract between an oil trading company and an oil storage plant; and breach of contract between a contractor and operator of an oil and gas field, involving a billion dollar quantum claim- Arbitration work between a supplier and an aluminium smelting plant after a breakdown of trading relationships and accusations of price fixing- Loss of profits case arising from a breached distribution agreement for travel accessories Work performed included:- Construction of financial models, including foreign exchange losses, bank account modelling and price-demand models for profit scenarios- Data analysis work on accounts, cash books, ledgers and other forms of documentation- Drafting of expert reports and letters- Analysis and critiquing of opposing expert’s reports- Verification of reports and calculations to ensure complete accuracy

Portsmouth, Gb

Back-End Web Development, Ruby And Ruby On Rails

Chartered Accountant (Aca), Accounting

Master Of Mathematics (Mmath), Mathematics