Learn Data Skills
Beta
Ric Clark

Ric Clark

Data Modeller

Miller Homes Ltd

Technologies

My Portfolio Highlights

My New Course

Database Design

My New Course

Intermediate Importing Data in Python

My New Workspace

Introduction to SQL

Data Engineer and passionate technologist

My Work

Take a look at my latest work.

course

Introduction to Relational Databases in SQL

course

Intermediate Importing Data in Python

course

Introduction to Importing Data in Python

course

Database Design

course

Cleaning Data in Python

course

Understanding Data Engineering

course

Understanding Cloud Computing

course

Introduction to SQL

course

Intermediate SQL

course

Joining Data in SQL

workspace

Introduction to SQL

1Upvotes
course

Introduction to Python

course

Intermediate Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Miller Homes Ltd | Dec 2021 - Present

Senior Anaplan Analyst / Data Modeller

- Project manager and lead for Anaplan within Analytics and Business Applications function; - Building a centre of excellence; - Transformation of all models from classic dashboards to Anaplan UX; - Development, maintenance and security administration of all multi- dimensional data models; - Gathering requirements, agreeing, designing, building, testing, documenting and implementing all changes within models; - Trouble shooting for users with specific queries, for full utilisation of models functionality; - End to end data integration of business specific data ETL import, processing and export - Building dashboards for end users ranging from Finance, Land and Production in Anaplan system; - Optimising data retention levels and eliminating redundant data;
Show More

Miller Homes Ltd | Nov 2020 - Dec 2021

Data Modeller / Anaplan Analyst

- Development, maintenance and security administration of all multi-dimensional data models; - Gathering requirements, agreeing, designing, building, testing, documenting and implementing all changes within models; - Designed & built new Strategic Model forecasting the next 6 years in collaboration with Finance; - Trouble shooting for users with specific queries, for full utilisation of models functionality; - Creating new export flat files for Qlik reports; - Building dashboards for end users ranging from Finance, Land and Production in Anaplan system; - Oversight of "Anaplan Connect" batch jobs for all regular ETL data integration, and use of Remote Desktop for SQL queries, including review of schedules, failures, mapping and adjustments; - Took over as Acting Anaplan Lead role in March 2021, whilst manager on maternity leave; - Completed Level 1 Model Builder training November 2020;

Snappy Shopper | Jul 2020 - Oct 2020

Data Science Intern

- Extracted tables from MySQL into RStudio using a keychain - Joined various SQL tables together to create "super tables" with optimum variable selection - Completed cohort analysis by month to compare customer retention in percentages - Visualised key variables through GGplot for trend comparison - Used geompoint in GGplot to chart the incidence of orders from the most prolific orderers - Created and Identified user personas and built profiles based on buying habits from SQL tables - Created a data dictionary on all MySQL tables identifying class/type, primary keys, important variables for future joins and further analysis - Performed Data Modelling and specifically regression analysis on most successful outlets, customers and products

Scottish Tech Army | Apr 2020 - Present

Volunteer

- Worked on a volunteer database, migrating data, updating volunteer information and skillsets on airtable for future reporting and resourcing initiatives. - Collaborated in a remote project team to produce an R-Shiny dashboard for data from the Scottish Government's COVID-19 datasets https://rhi-batstone.shinyapps.io/covid19_scot_map/ - Created a proposal with two colleagues for a full digital MOT that encompasses front and back end, data analysis and cyber security - Produced and edited videos of volunteer stories for LinkedIn and twitter https://twitter.com/ScotTechArmy/status/1280093663838842880 - Produced and edited videos of "How to make..." various recipes for Edinburgh Community Food Charity https://www.wevideo.com/ view/1768068138 https://www.youtube.com/playlist? list=PLD0I3p2rQkzvoPM9o9P7aLSjPliaKevPL

CodeClan | Feb 2020 - Jun 2020

Trainee Data Analyst

A full-time data analysis course, teaching the fundamentals of data analysis, statistics and visualisation, predictive analysis, with hands on learning and application of industry tools and best practices including daily stand-up in an agile environment: - Daily R programming in R Studio using many different libraries to manipulate data; - Visualisation with GGplot, making RShiny dashboards and Tableau, story telling; - SQL, Python Jupyter Notebooks, Visualisation, Machine Learning and Spark; - Statistical analysis, A/B Testing, hypothesis testing; - Google Analytics API, Key Performance Indicators; - The terminal & command line and version control using Github; - Machine learning, regression analysis, decision trees, k-means clustering; Projects completed to date: Games Data Sales Project: Insights into what types of video games sell the most? https://github.com/riccymiccy/games_data_sales_project R Shiny Dashboard Project: working in a team of 4, creating a reactive dashboard whilst working remotely https://github.com/riccymiccy/google_analytics_shiny_app Dirty Data Project: week long project data wrangling increasingly harder datasets https://github.com/riccymiccy/dirty_data_project Data Ethics Project: Automated Decision Making, how do we govern AI and Machine Learning? https://github.com/riccymiccy/ethics_automated_decisions https://github.com/riccymiccy

Walter Scott & Partners Limited | Jan 2016 - Jan 2020

Finance Analyst, Balance Sheet and Controls

- Designed and developed a increasingly accurate model for the Annualised Revenue impact of our Alpha performance against various MSCI benchmarks on Excel; - Designed & developed automated Excel models for P&L forecast to the board, business MI and balance sheet & liquidity monitoring for corporate governance; - Revamped production of the quarterly board pack and the monthly CFO’s pack that includes AUM & AR reporting, P&L forecasts, variance & commentary; - Balance sheet management, FSA Returns (various); - Enhanced our Key Risk Indicators report for our Risk & Compliance committee; - Monitor all team workbooks/models, procedure notes and checklists;

Walter Scott & Partners Limited | Sep 2009 - Dec 2015

Finance Assistant, Statutory and Regulatory Reporting

- Monthly and Quarterly VAT Reconciliation & Reporting to BNYM Tax; - GL reconciliation of balance sheet & control accounts and creating schedules; - Month end Journals and reporting to internal stakeholders; - Client take-on, IMA fee & contract review, change and termination; - Accounts Payable; - Accounts Receivable;

AH&Co | Nov 2007 - Aug 2009

Accounts Assistant

- Prepared statutory accounts; - Balance sheet reconciliations; - Prepared and analysed quarterly VAT returns; - Monthly Bookkeeping to Trial Balance; - Company Secretarial work;

Scottish & Newcastle (now Heineken) | Nov 2004 - Oct 2007

Account Manager

- Financial deal and price modelling for units using: - Advances of discount; - Business Loans; - Return on Investment calculations; - Margin Management; - SAP R3 and SAP Business Warehouse;

My Education

Take a look at my formal education

Certificate in Business Valuations ACCA | 2018
Bachelor's degree ACCA | 2017
Advanced Diploma in Accounting and Business ACCA | 2017
Advanced Certificate in AccountingAAT | 2010

About Me

Ric Clark

I currently work in data for a construction business. I do a bit of engineering, analysis, visualisation and project management, as well as end user training. I am trying to improve my technical capabilities because I want to become a Data Engineer.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free