Resourceful Data Developer with an in-depth understanding of data warehousing and cloud technologies . Highly knowledgeable about database structures and tools with additional industry qualifications . Expert optimization skills and project management experience.
Overview
4
4
years of professional experience
Work History
Data Developer
Protirus
03.2022 - Current
Managed company SQL databases.
Developed 100+ SQL scripts, utilizing stored procedures, views and functions to optimise critical business processes.
Developed and monitored ETL pipelines within Azure Data factory.
Performed data modelling and data cleansing techniques on weekly imports of 5 million+ records.
Provided helpdesk support to local and international colleagues.
Delivered key reporting duties at stakeholder meetings.
Powershell scripting duties, automating system administrator tasks across 30+ application servers.
Data Warehouse Developer
Mackenzie Electrical London LTD
09.2019 - 03.2022
Developed a data warehouse from inception to implementation following Kimball methodologies.
Technical & programming assistance, developing complex scripts for analysis and reporting.
Analysed and developed complex logical database designs, data models, and relational data in support of corporate and client area info systems requirements
Provide daily reports built with Power BI, reports covering sales figures, price changes and forecasting future growth opportunities
SQL script development utilising stored procedures, views, and functions
Applied knowledge of data modelling and statistical analysis to note trends and draw conclusions.
Education
Bachelor of Science - Mathematics
Open University United Kingdom
MCSA Data Analytics And Management -
Microsoft
Skills
Strong experience in MS SQL Server as developer and administrator
Applied experience and skills with API Development: WS, RESTful, or SOAP/WSDL, etc
Applied experience and skills with cloud-based infrastructure as a service platforms: AWS or Azure
Excellent IT, communication, leadership and management skills
Solid experience linux administration
Solid understanding and experience working with Azure components (Data Factory, Azure SQL, Synapse etc)
Strong experience building complex ETL pipelines with dependency management
Solid Python experience
Accomplishments
Delivered data gathering procedures with SQL, developing views, procedures and indexes to improve query performance by 20-25%.
Automated the company reporting process
Implemented new processes and procedures leading to a 25% reduction in data redundancy and 15% decrease in bottlenecks.