Malt welcome

Welcome to Michael's freelance profile!

Malt gives you access to the best freelancers for your projects. Contact Michael to discuss your project or search for other freelancer profiles on Malt.

Michael Amankwa

Database and Business Intelligent Developer
  • Suggested rate
    €350 / day
  • Experience8-15 years
  • Response rate100%
  • Response time1 hour
The project will begin once you accept Michael's quote.
Location and workplace preferences
Location
London, England, United Kingdom
Remote only
Primarily works remotely
Verifications

Freelancer code of conduct signed

Read the Malt code of conduct
Verified email
Languages
Categories
These freelancer profiles also match your search criteria
Agatha FrydrychAF

Agatha Frydrych

Backend Java Software Engineer

Baptiste DuhenBD

Baptiste Duhen

Fullstack developer

Amed HamouAH

Amed Hamou

Senior Lead Developer

Audrey ChampionAC

Audrey Champion

Web developer

Skill set (10)
Michael in a few words
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.
Experience
  • Bourne Leisure
    SQL Developer and Report Analyst
    DIGITAL & IT
    June 2021 - December 2022 (1 year and 7 months)
    Hemel Hempstead, England, United Kingdom
    Effectively 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 requirements
    Involvement in process development to drive best practise and performance of our systems
    SQL Server SSIS SSRS Datawarehouse VB.NET Microsoft Excel SSAS
  • PRGX
    Senior Business Information Analyst
    DIGITAL & IT
    May 2012 - Today (12 years and 9 months)
    Luton, 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
    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

    Talend SSIS SQL Server Transact-SQL VB.NET Microsoft Power BI
Recommendations
Education
  • MSc
    University of Manchester
    2007
    MSc in Mechanical Engineering (Thermal and Fluid)
Certifications
  • Microsoft Certified Solutions Associate SQL Server 2008
    Microsoft
    2013
  • Microsoft Certified Technology Specialist SQL Server 2008 Database Development
    Microsoft
    2013