Rob Archibald Email & Phone Number

London, Gb

Irvine, California, United States

Working across all the firm’s legal and operational departments to improve the technical side of things, with a focus on automating/streamlining processes, data management, reporting and analysis.• Consult with managing attorneys, accounting and marketing, then deliver elaborate automated reports to fit their requirements• Responsible for all firm data, managing my own team, and teaching employees across the firm about best practices • Write complex SQL queries to extract and manipulate data from live SQL database for use in reports and automations• Create beautiful automated interactive Excel dashboards pulling from various external data sources • My dashboards show financial reporting, employee utilization, client value, marketing analytics, loan analytics, and more• Utilize task scheduler, macros, and VBA to schedule automatic refreshing and emailing of Excel reports• Write Stored SQL Procedures, run on schedules, performing DB audits and sending email alerts when issues are found• Customize reports in case management & accounting software (ProLaw) using SSRS (SQL Server Reporting Services)• Create popular reports in Power BI and publish to app to reduce strain on server from multiple instances of each report• Customize billing process, redesigning prebills and invoices to depend on custom billing codes to fit firm’s requirements• Manage team in various projects, designing workflows & delegating tasks, taking ultimate responsibility for quality• Coordinate integration of hundreds of legal documents into ProLaw, writing SQL to link document fields to DB fields• Firm contact/buffer (fix many of these issues myself without the need to reach out) for Ads managers, SEO provider, web designer, and web hosting and security provider

Irvine, California

• Automated processes:- Wrote SQL code to automatically extract ProLaw billing data into an Excel spreadsheet that I made (using advanced excel formulas & VBA code) communicate w/ Outlook to email reminder notices 2 & 4 weeks after invoice date- Developed similar system to above for securities team, automating Form-D reminder notices- Configured Outlook rules & permissions to automatically save invoice emails to shared folder & backup as PDFs• Integral member of emergency accounting team when both CFO and accountant left firm during major accounting software transition (BillQuick to ProLaw):- Taught ProLaw to less technical team members- Reconciled trust account from 3 conflicting sources- Audited client’s ACH & CC pulled payments & reconciled mistakes- Generated monthly invoices in ProLaw & emailed to clients- Categorized and correctly formatted all transition-period AP expenses, in Excel for upload to ProLaw- Solved other mismatched balance issues• Marketing Dashboard:- Designed data processing plan, for long-term use in predictive analytics- Wrote Java Scripts in WordPress to send analytics data to Google Analytics (GA), generate unique client IDs, link to Google Tag Manager container, and define & listen for events- Configured Tag Manager variables, triggers and tags to track users’ interactions & send event hits to GA as conversions to goals- Built objective model for assigning $ amounts to goal conversions- Extensively researched & tested to devise optimum combination of GA dimensions & metrics for extraction groups- Used Stitch (an ETL tool) to extract GA data tables to Google BigQuery- Wrote Cloud DataPrep recipe to clean and join the data tables- Scheduled Stitch & DataPrep to refresh daily and send clean output back to BigQuery- Built automated interactive Tableau dashboard to measure performance of marketing campaigns & content against KPIs, whilst visualizing trends in converting users’ pathways to provide actionable insights

London, United Kingdom

Part of new team to expand this London-centric online restaurant guide and booking platform, to the rest of the UK.• Sold guide membership to restaurants, ensuring my pitch was clear, concise, and always tailored to the individual• Sourced and used website traffic/link/rank/booking statistics & user statistics (demographic/geographic) as selling points• Sourced new leads, evaluated likelihood of converting to clients, coordinated interactions accordingly• Logged all communications in CRM to improve collaboration between colleagues, personal workflow and client relations• Worked on backend of website to create and update restaurant pages and increased knowledge of SEO in the process

Newport Beach, California, United States

Assistant to Allison Foster, Realtor®, to develop business strategy and provide administrative support.• Diligent use of CRM to implement comprehensive follow-up strategy for lead retention• Conducted research on emerging markets to pinpoint prospecting locations • Created market updates for leads and clients

Worcester, United Kingdom

Provided in-class support to undergraduate students with learning disabilities.• Attended all classes of 4 students, studying English Language, Computer Science, Journalism & Economics, respectively• Provided each student with detailed, clear and concise, handwritten lecture notes at the end of every class• Fully understood content of each class to ensure accuracy of notes and help student with any questions

South Africa, Swaziland, Mozambique, Malawi, Tanzania, Kenya

Documented my 10,000-mile, 9-month, solo African motorcycle trip, on a blog, in magazines and at public speaking engagements.• Problem-solved to navigate bureaucratic, cultural, linguistic, mechanical, physical and medical hurdles• Conducted careful saving, financial planning, risk assessment, and organisation to ensure the success of the trip• Published multi-page articles in international magazines, such as Getting-into-Adventure, Overland Magazine and RiDE• Presented about the trip to large audiences at events such as The Overland Event (UK) and MCN London Bike Show

Windsor, United Kingdom

Full time duty manager of The Horse & Groom (8 months) then Bar 51 (15 months).• Managed stock and accounts with weekly stock takes & orders, and daily cash-ups• Motivated team, led by example, strategically delegated tasks for effective teamwork and employee/customer happiness• Implemented initiatives to hit targets/increase profit; menu changes, offers, themed nights, staff incentives for upselling

Certificate Program, Applied Accounting

Part-time online course: Financial Accounting Management Accounting Accounting in Business Intermediate Accounting Theory & Practice.

Accelerated Certificate, International Finance

Accounting Financial Mathematics Financial Modeling Financial Analysis International Financial Markets & Strategies Risk Management.

Accelerated Certificate, Data Science And Predicitive Analytics

Business Applications of Data Science Applications of Predictive Analytics Data Preparation for Data Mining Modeling Methods, Deploying.

Bachelor Of Science, 2-1 Honours, Music Composition And Technology