About Michael
Business intelligence and Database Developer with 10 years’ experience in data and analytics industry; experienced in working in a variety of sectors including hospitality, retail, and recovery audit. Understand and work with retail data sources, datasets and stakeholders.
I have deep understating of working within a variety of business users and datasets to analyse, design, and develop systems and processes to ensure delivery of high quality, compliant data by using T SQL, SSIS, SSRS, SSAS, Power BI and other tools.
Possess excellent skills in communication and able to outline and implement SDLC. Have the ability to work effectively as a member of a team as well as the capacity to work autonomously. Flexible and able to build and provide positive relationships with clients and stakeholders. Well organised and always ensure stakeholders have the right information available for resolution of business issues. Adopted best practice standards and guidelines when using databases and associated systems to produce outputs and reports. My keen interest is using IT systems and technologies to develop and deliver high quality information.
English
Native or bilingual
Remote only
Primarily works remotely
Experience
- Bourne LeisureSQL Developer and Report AnalystDIGITAL AND ITJune 2021 - December 2022 (1 year and 7 months)Hemel Hempstead, United KingdomEffectively developed and modified database objects like tables, views, indexes, rules, stored procedures, triggers, functions to facilitate efficient data manipulation and data consistency.Migrated data from heterogeneous data sources to centralised SQL Server databases using SSIS by building packages to validate, extract, transform and load data.Support of existing datasets and reports and development of new reports and datasets.Ad-hoc queries requested by the Business Unit and maintain security and GDPR principals.Work with other members of the IT Team when requirements gathering and specifying new reporting requirementsInvolvement in process development to drive best practise and performance of our systems
- PRGXSenior Business Information AnalystDIGITAL AND ITMay 2012 - Today (14 years and 1 month)Luton, United KingdomDesign 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 generationEfficient UI design and development with a focus on usability and productivityPerformance tuning and optimisation of new and existing processes within SQLServer via analysis of indexing, structures and execution plansPerformed SQL administrative tasks such as backup and restore of databases.Data warehouse architecture design with a focus on scalability where appropriateRearchitecting existing databases and systemsData management including data cleansing, ETL, ELT, merging data from disparate systems and sourcesWorking closely with the audit teams for both the design of new tools and enhancements to existing toolsFully understanding the business drivers behind the requirements in order to provide the best solutionsAll disciplines within the different Project Management rolesManagement of multiple simultaneous projects and rapidly changing prioritiesWorking across many different accounts, supporting and developing tools developed by many different peopleTesting, release and regression plansWorkflow analysis, identifying areas that would benefit from automationApplication support and troubleshootingEfficiently researching and exploring alternative solutions when requiredKnowledge sharing within my team and also to colleagues in other divisionsImplementing documentation and coding standards within my team to aid optimal cross account support and developmentUsed 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 analystsDeputising for the departmental Director in their absence
Recommendations
Be the first to recommend Michael
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- MScUniversity of Manchester2007MSc in Mechanical Engineering (Thermal and Fluid)
Certifications
- Microsoft Certified Solutions Associate SQL Server 2008Microsoft2013
- Microsoft Certified Technology Specialist SQL Server 2008 Database DevelopmentMicrosoft2013