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
Performed SQL administrative tasks such as backup and restore of databases.
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
Used project management tool (JIRA) to manage workload and SQL Agent to schedule different jobs to automate loading and processing.
Provided tool training for users and supervised and mentored junior analysts
Deputising for the departmental Director in their absence