Mark Fraser Email & Phone Number

Newton Mearns, Gb

Glasgow, Scotland, United Kingdom

At Arcus, I play a pivotal role in a major business transformation project, aimed at overhauling our technological infrastructure to align with our corporate strategy. My responsibility as a Data Engineer centers around developing and implementing a comprehensive data strategy, establishing a robust data architecture, and instituting a forward-thinking data governance policy.Key Responsibilities:Strategic Leadership: Spearheading the initiative to devise and execute a new data strategy and architecture, aligning it closely with the company's evolving needs.Data Governance and Compliance: Crafting and enforcing a dynamic data governance framework, ensuring compliance with relevant regulations, and adapting to business changes.ETL and Data Services: Overseeing the implementation of ETL processes and technical services essential for business intelligence and data reporting.Data Compliance and Best Practices: Advocating for data compliance, operational processes, and best practices in MI/BI reporting.Stakeholder Engagement: Establishing and nurturing effective relationships with stakeholders, colleagues, and clients to drive the transformation of data services.

Glasgow, United Kingdom

Responsibilities/achievements:o Manage all aspects of system-based reporting, delivering easy-to-use, tailored reports that will minimise workload and facilitate informed decision makingo Recognise and extract key trends from large and complex data sets and be able to interpret and express those trends to key stakeholderso Recognise relationships between multiple data sources, including Verisae FM system, Vehicle Trackers, HR System and other available data sources and use to identify improvement opportunitieso Development of database or reporting platform to facilitate improved data management, interrogation, automated reporting and dashboard creationo Lead the change from Excel based reporting to a database environment, driving efficiency benefits and improved reporting quality, including the use of Visual Analyticso Proactively engage with functional/departmental managers to drive improvement through system or process changes and value-add reportingo Statistical analysis and data mining techniques to identify correlations, validate hypothesis and apply in-business context to improve operational performance

Hamilton

Providing comprehensive reporting at a senior management level within a busy central finance department. Scoping, developing and testing requested reporting suites before applying for sign off by the business owner. These areas of reporting include but are not limited to, GRNI analysis, accrual reporting, debt reporting and contract health assessments.Responsibilities/achievements:o Implement improvements to the cash forecasting process which assisted with centralisation.o Improving analysis of aged GRN, GRNI and prelposted volumes and working closely with the business to drive change in these areas.o Working continuously towards best practice business improvements, such as the alignment of systems & processes between Babcock Rail Ltd & Babcock Networks Ltd.o Significantly reduced resource to produce period end reporting by an estimated 93%

Glasgow, United Kingdom

Managing high volumes of data from several sources daily through our database and manipulating them to client requirements, applying filters and update scripts. Generating tailored reporting based on return files and providing feedback on any patterns/anomalies that could help generate better performance. Partnering with clients to maximise service provision, through strengthened communication processes underpinned by interdependency on accurate source data. Responsibilities/achievements:o Maintaining mySQL interrogation speed through query optimisation and applying indexes accordingly.o Development of an automated daily report which provides an overview of each client and the margin produced within the current billing cycle.o Cleansing records against client specific criteria.o Review, assess and develop analyses in alignment with business requirements.o Comprehensive knowledge of lead generation from conception.

Glasgow, United Kingdom

Producing meaningful reports in an efficient way within a highly pressurised sales environment outsourced to the biggest insurance company in the UK. Effective communication with the client and data manipulation allowed successful campaigns to be run. Responsibilities/achievements:o Entrusted with managing and administering the sensitive senior management bonus scheme.o Up-skilling of 4 members of faculty in line with business requirements.o Producing daily manual and semi-automated reporting in line with the businesses reporting standards.o Timely and accurate completion of workload, alongside delivery of team goals.o Engaging with all stakeholders during the development of reports to ensure all requirements are achieved.o Excellent planning and organisation skills enabled quick progression from within the company and lead to enlarged additional responsibilities.