● 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● Data management including data cleansing, ETL, ELT, merging data from disparate systems and sources● Working closely with the audit teams for both the design of new tools and enhancements to existing tools● Fully understanding the business drivers behind the requirements in order to provide the best solutions● All disciplines within the different Project Management roles● Management of multiple simultaneous projects and rapidly changing priorities● Working across many different accounts, supporting and developing tools developed by many different people● Testing, release and regression plans● Workflow analysis, identifying areas that would benefit from automation● Application support and troubleshooting● Efficiently researching and exploring alternative solutions when required● Knowledge sharing within my team and also to colleagues in other divisions● Implementing documentation and coding standards within my team to aid optimal cross account support and development ● Deputising for the departmental Director in their absence

● 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● Database performance tuning● Data mapping , loading, cleansing and quality assurance● Creating test plans and testing programmes● Liaising with internal and external clients regarding data acquisition● Training end users on existing tools and new developments● Application of both Waterfall and Agile approaches to development projects● Mentoring and developing less experienced members of the team● Analysis of business requirements and drivers● Analysis of existing systems to identify areas of improvement in terms of performance, efficiency and data accuracy● Process analysis, re-engineering and improvement● Analytics and trend analysis using the vast datasets captured● Direct client liaison and stakeholder management● Identification of processes which could be automated, to increase accuracy and efficiency

● 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 and managing members of the project team to ensure smooth and efficient delivery● Construct a thorough testing strategy for new developments, overseeing user acceptance testing● Implementation planning and delivery of new developments

● 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● Extensive Management Information reporting, producing weekly reports for the Executive Board● Working with external auditors to validate data models developed and used for the financialshareholder updates● Line managing a member of the team● Re-wrote and optimised the front end of one of the main company reporting systems to resolve network traffic issues, improving availability, performance and stability

● 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