Mark Liddle Email & Phone Number

London, England, United Kingdom

• Design and development of new audit tools to maximise company and client revenue using minimal resource (SQL Server Views / Stored Procedures / Access / VBA)
• Advanced SQL data analysis and querying of complex datasets, identifying and providing insights into the data to pinpoint areas of interest and potential revenue generation
• Efficient UI design and development with a focus on usability and productivity
• Performance tuning and optimisation of new and existing processes within SQL Server via analysis of indexing, structures and execution plans
• Data warehouse architecture design with a focus on scalability where appropriate
• Rearchitecting existing databases and systems

• Design, delivery, documentation and support of applications and solutions to support audit teams (SQL Server / Access / VBA)
• Project Management responsibilities
• Leading a team of analysts, including recruitment of new staff
• SQL Server development including complex stored procedures and exploiting new features
• Design and development of efficient data warehouse systems
• Management of large datasets

• Feasibility studies, scoping and shaping work to produce a project brief
• Analysis and documentation of business and systems processes
• Facilitating stakeholder workshops to extract, understand and refine requirements
• Challenging the validity of requirements where appropriate
• Producing accurate functional, non-functional and technical requirements
• Proposing solutions that satisfy the user and business requirements, ensuring that they are workable from a technical perspective, while keeping within project scope

• Working with all levels of users and management to identify and extract business requirements, developing reporting systems and analysis to satisfy the requirements
• Meeting deadlines and service levels against challenging timescales
• Designing and developing automated applications and enterprise level reporting systems using Access, Excel and VBA
• Building report data using SQL Server, using scripts and stored procedures
• Data management, owning and administering very large datasets
• Producing accurate and professional reports

• Developing financial reporting systems using Access, Excel & VBA
• Accurate and thorough testing of developed solutions
• Extensive Management Information reporting, producing weekly reporting for the Executive Board
• Working with all levels of users and management to identify and extract business requirements, developing reporting systems and analysis to satisfy the requirements
• Providing system and process training to the end users
• Master data management and database administration

• Managing the distribution of stock to stores via computerised systems
• Automation of report production, performance reporting and data analysis