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

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.
• 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.
• 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.

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 in the.

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