Laurence Clark Email & Phone Number

Ashington, Gb

Ashington, Gb

• Leveraged Python programming language to create efficient scripts for data cleansing, transformation, and aggregation. Built dimensions and facts using Python code to enhance the accuracy and granularity of data analysis. • Conducted regular data audits, systematically identify data discrepancies, and propose necessary corrections to maintain data integrity. • Designed and implemented data visualization techniques using Microsoft Power BI, employing various visual types to… Show more • Leveraged Python programming language to create efficient scripts for data cleansing, transformation, and aggregation. Built dimensions and facts using Python code to enhance the accuracy and granularity of data analysis. • Conducted regular data audits, systematically identify data discrepancies, and propose necessary corrections to maintain data integrity. • Designed and implemented data visualization techniques using Microsoft Power BI, employing various visual types to enhance data comprehension and presentation for stakeholders. • Collaborated closely with stakeholders to understand their data requirements and provided data-driven solutions to address their needs effectively. • Designed, developed, and optimized robust data pipelines for seamless extraction, transformation, and loading (ETL) of data from diverse sources, ensuring a smooth data flow throughout the organization. • Engaged in effective collaboration with other teams and data analysts to validate the accuracy of data associated with their teams, gathering knowledge to assist analytics and reporting processes, and ensuring that the insights derived are sound and reliable. • Conducted in-depth exploration and analysis of data sets, utilizing advanced techniques to uncover hidden patterns, trends, and correlations, extracting actionable insights for informed decision-making. • Developed an automated Power BI report to notify stakeholders about the readiness of reports for viewing on the web version, streamlining the reporting process. • Stayed up-to-date with emerging trends in data analysis, continuously implementing new tools and techniques to enhance data analysis capabilities. Show less

Gosforth, England, United Kingdom

I.T • Utilising excel functions and tools to extract data from an accounting system or Salesforce to Excel, where the data is transformed using Excel functions for automation and lastly pre-made pivot tables for visualisation of the data to monitor Park income transition from Park to Bank, fraud or theft, also incorporating external data from the cash collection company reports to examine if parks are following correct banking procedures. • Extracting data from accounting systems,… Show more I.T • Utilising excel functions and tools to extract data from an accounting system or Salesforce to Excel, where the data is transformed using Excel functions for automation and lastly pre-made pivot tables for visualisation of the data to monitor Park income transition from Park to Bank, fraud or theft, also incorporating external data from the cash collection company reports to examine if parks are following correct banking procedures. • Extracting data from accounting systems, websites, Salesforce and card payments for Journal to transform and load onto accounting system. Finance • Successfully reduced variances on four accounts by 70%, utilising pre-existing tools for analysis and further formulating better ways of analysing the information to reconcile and also to communicate my findings to the appropriate teams if further investigation is required. • Responsible for four cash and card income accounts, ensuring reconciliation and journals are accurate. • Arrange cash collections and ensure parks are adhering to procedures to ensure accounts are accurate. • Generate and present month-end reports, with a thorough breakdown at Park level, providing evidence on individual variances which are included in the report and actions for next month, if any variances are still ongoing. Show less

• A fast paced environment supporting 66 holiday parks around the UK. • Invoice processing 250+ invoices daily • Assisting with queries from park management • Reconciliation of individual credit cards to bank statements, as well as updating current card limits on our records. • Supplier Statements

Edinburgh, Scotland, United Kingdom

I.T • Utilising Quantexa for Graph network entity resolution • Python and Pandas • Excel functions for analysis • Cloudera Terradata, Hive and Hadoop • Database extraction, transformation and load to Excel to find extract data on company house and analyse it against the data and finally inputting back into Jupyter notebooks for further analysis based on our input columns of any finds on the data. • Data from Excel used for reporting findings and… Show more I.T • Utilising Quantexa for Graph network entity resolution • Python and Pandas • Excel functions for analysis • Cloudera Terradata, Hive and Hadoop • Database extraction, transformation and load to Excel to find extract data on company house and analyse it against the data and finally inputting back into Jupyter notebooks for further analysis based on our input columns of any finds on the data. • Data from Excel used for reporting findings and providing data for Quantexa team. Finance • Identify and categorise information to find patterns, which can be utilised to formulate solutions, which improves the usefulness of the information or solves a problem that is preventing accurate information being provided and used. This can affect decision making, which was one of my findings that showed a significant flaw in their systems. Show less

I.T • Produce supplier cost trend reports, as well as Purchase invoices age reports and payment runs by extracting the data from the accounting system to manipulate the data using Excel functions. Finance • Processing high volumes of supplier invoices for foreign and UK companies in various foreign currencies. • Banking reconciliation (inter-company, foreign currencies and etc.) • Reconciling income and payments balances • Reconciling credit notes and… Show more I.T • Produce supplier cost trend reports, as well as Purchase invoices age reports and payment runs by extracting the data from the accounting system to manipulate the data using Excel functions. Finance • Processing high volumes of supplier invoices for foreign and UK companies in various foreign currencies. • Banking reconciliation (inter-company, foreign currencies and etc.) • Reconciling income and payments balances • Reconciling credit notes and payments. • Petty cash and ensuring contractors or apprentices expenses are paid • Forecasting cash outflow and running weekly payment runs. Also international payments, inter company transfers and emergency payments. • Reduced outstanding invoices and credit notes, through building relationships with suppliers and updating our reports of current suppliers to request monthly statements. Overall, improving cash flow forecasting. • Through training and guidance, raised colleagues’ awareness of the importance of timely receipting and the need for purchase order numbers. These improvements increased timely invoice processing, by 80% and overall reduced unused purchase orders at the end of the year. • Produce month-end bank statement reports for all the companies after final bank reconciliation are completed. • Prepare a monthly statement of account reconciliation. • Validate customer invoices on Electronic Data Interchange (EDI), as final check from accounts receivable before sending electronic customer invoices. Also handling exceptions and inter-company transfers. • Generate unmatched payment reporting for direct debits. • Generate unprocessed invoice reports. Show less

• Processing and analysing weekly takings. • Generating reports related to weekly takings. • Responsible for the petty cash and expenses. • Performing systems management by creating and maintaining documentation for audit purposes.

Decided to take a sabbatical to self-funded my AAT qualifications to support my career transition into the accountancy sector. Overcame challenges of returning to self-managed learning and adopted a purposeful and determined approach to study to ensure examinations results were of a very high standard.

Edinburgh, United Kingdom

I.T • End to end client banking support, for security, fraud. • Backend systems for additional client supportBanking• Working in a high-pressure call centre environment to provide support and advice (within FCA regulations) to a broad range of customers.• Provided a solution-focused customer service answering 200+ calls per day for account facilities, charges while simultaneously inputting accurate customer records. • Explained complex financial concepts and… Show more I.T • End to end client banking support, for security, fraud. • Backend systems for additional client supportBanking• Working in a high-pressure call centre environment to provide support and advice (within FCA regulations) to a broad range of customers.• Provided a solution-focused customer service answering 200+ calls per day for account facilities, charges while simultaneously inputting accurate customer records. • Explained complex financial concepts and information in an accessible way to customers.• Worked efficiently to reduce queue times.• Resolved customer queries or complaints while observing company and regulatory policies and procedures.• Recognised inappropriate account activity that was a proven attempt to launder money and so upheld the reputation of the bank.• Compiled concise and factual accurate incident reports for managers.• Introduced a knowledge-sharing activity so that team members could share solutions to frequently asked customer questions and system shortcuts, resulting in reducing customer queueing time. Show less

Irvine

I.T • Deploying and testing RFID stock tagging, for stock position (Warehouse or floor), stock take and liaison any system issues or improvements like PDA signal strength or RFID tags issues like steam damage for example. • Transmitting data on test stock takes and reporting finding of any issues on device or stock figure variances.

Irvine

IT • PDA deployment and testing, also liaison with engineering team of any issues or improvements to the deployment to other stores. As we were training store all new technologies were first deployed at our store. • Deployment of scanning system for stock location, auditing and prepared warehouse to categorise stock system delivered. • Testing and using online system to order and setup customer data.

Aws Cloud Practitioner (Clf-C02) Certication Preparation, Information Technology

Fundamentals Of Aws, Information Technology

Solving Real World Problems With Regular Expressions In Python, Information Technology

Working With Sql — Beyond The Basics, Information Technology

Introduction To Python, Information Technology

Learn Sql - From Newbie To Ninja, Information Technology

Dp-203 Exam Preparation Data Engineering On Microsoft Azure, Information Technology

Microsoft Azure Fundamentals, Information Technology

Working With Python Visualization Tools, Information Technology

Pythonic Programming, Information Technology

Python For Beginners, Information Technology

Introduction To Data Visualization, Information Technology

Wrestling With Data, Information Technology

Introduction To Databases - Moving From Spreadsheets, Information Technology

The Basics Of Data Management, Data Manipulation And Data Modelling, Information Technology

Beginners Guide To Machine Learning And Artificial Intelligence Certificate, Information Technology

Payroll For Non-Payroll Professionals

Applied Knowledge

- Business and Technology - Management Accounting - Financial Accounting

Aat Level 3

Aat Level 2

Hnd Accounting, Accounting

Hnc Accounting, Accounting