Millersoft is a software development consultancy focused on providing cloud based data solutions for its clients. It has developed an SaaS product, Sheetloom (Sheetloom.com), to automate the update of business spreadsheet models and reports. My main role on the Sheetloom project, which I have worked on since summer 2022, has been to build up multi-dimensional data models in Excel with Power Query and Power Pivot to process source data and build Pivot reports, KPIs and dashboards. These are built both as proof of concept models and to fulfill client specifications. Other projects I have worked on include:-Business analysis for the creation of an online lottery platform for state level lottery in South America. The role expanded into unit, end to end, and load testing of lottery apis using Jmeter, and the specification of a business intelligence platform.-Migration of client reporting platform from Business Objects to Yellowfin BI, replicating reports and giving business users the means to build ad-hoc reports and analysis through an intuitive click and drag interface. My contribution was to elucidate business requirements, and ensuring the functionality was built into the new platform through reviewing and testing.-Business and data analyst on team that saved client 50 hours per month through the automation of reporting using an OLAP cube containing customer activity data. Previously this was meshed together in Excel from separate reports. I elucidated business requirements and facilitated communication between business and developers. Responsibility to identify data sources and quality, and to test and reconcile data with source.

Overall responsibiity for all aspects of the buildout, running and development of the business. I researched and wrote the business plan during early 2016. Funding was obtained and the project began in summer of 2016. Specific responsibility for understanding, documenting and implementing working processes, creation and measurement of marketing campaigns, financial reporting, business reporting, establishment and monitoring of KPIs.

Credit and liquidity risk analysis, financial analysis, market analysis, legal review, preparation, and presentation of private equity finance proposals for high net worth clients seeking equity release funding from private banks; brokering of deals with private banking partners. Liason and relationship development/mangement with key partners in the legal, financial and realty sectors.

In addition to the principal positions listed, I undertook a variety of freelance roles:Marketing/Business Analyst, CyberCroupier AB online Casinos, 2000-2008:-Collection of reporting /KPI and analysis requirements from business for online marketing campaigns. -Selection of appropriate platforms and tools to conduct the analysis.-implementation and running of marketing campaigns-measurement and refinement of campaigns for future marketing.-Online Affiliate Manager, establishment and maintenance of relations through effective CRM and incentivisation programs.Research and writing for the UK Consumers´Association´s Which? magazine and online shopping service, Value Direct 1999-2000.Financial articles written for Hutchison´s Almanac 1999-2000.Freelance work with www.konsus.com, primarily data analysis for clients 2016-2017.

To identify and resolve threats to the integrity, confidentialiy and availabiity of sensitive company and customer data deriving from potential security breaches.

Responsible for the collection, input, analysis and presentation of data for Which? magazine retail financial reports. During this time I enhanced the quality and robustness of research output through the introduction of quantative techniques and new software platforms. Recruited, trained and managed analyst team to operate at and beyond required standards.

To research and write reports on retail financial products for Which? magazine, published by the UK Consumer´s Association. I specialised in savings, loans and mortgage products, producing unbiased comparative information for the organisation´s 800,000 subscribers.