Description

A resourceful and technical Business Intelligence professional with over 5 years’ experience of delivering insight through data with extensive use and experience of the Microsoft BI technology stack, among others.

I communicate clearly and effectively with stakeholders, and have been successful at translating business requirements into functional reporting solutions and data presentation layers. I have extensively applied my skills and experience in areas of Database querying and programming; Data warehousing & data modelling for complex MI & reporting.

Languages

English
Native or bilingual

Workplace preferences

Remote only

Primarily works remotely

Instron
MI Reporting Analyst
September 2019 - Today (6 years and 9 months)
Instron is a global market leader in the sales and services of materials testing equipment Key Responsibilities and Achievements:
●Responsible for the design and build variety of operational and performance reports using SSRS and Power BI
●Work closely with lines of business to gather and understand reports requirements and prioritise them
●Write SQL queries for stored procedures and views to provide/enhance reporting datasets
●Troubleshoot, fix and enhance existing reports and stored procedures
●Work as part of a team to maintain the SSIS ETL pipeline for building the Data warehouse
●Monitor, troubleshoot, and fix faults related to daily ETL process and Data mart build
●Take on ETL maintenance/support tasks to ensure the smooth running of the daily batch process
●Provide support to user on the Data warehouse landscape and data usage
●Provide downstream data extracts for consumption by other reporting applications
●Enhance Power BI datasets by adding data elements as required
●Collect and process performance data from various departments and third parties
●Refresh and distribute weekly/monthly static report views
●Maintain and update data dictionary and data lineage
●Triage with colleagues to prioritise tasks and maintain work item backlogs
Centrical IT Ltd
BI Consultant
September 2018 - June 2019 (9 months)
A Business Intelligence and Data Analytics consultancy and training provider Key Responsibilities and Achievements:
●Provide consultancy on small scale implementation of BI reporting solutions and strategies to clients
●Work alongside clients to understand and gather their BI needs and requirements
●Design and build bespoke MI using Power BI and SSRS
●Refactor data to create single customer view for customer insight analytics and reporting
●Investigate and resolve technical issues raised by users
●Provide training on full MS SQL Server BI stack and Data Analytics tools
●Provide product demo and solution presentation to clients
GlaxoSmithKline (GSK)
Data Analyst
January 2014 - August 2018 (4 years and 7 months)
Global pharmaceutical manufacturing company Key Responsibilities and Achievements:
●Responsible for data import into SAP system
●Configure reports parameters as per user requirements
●Consolidate EUC data for import into reporting system
●Carry out data analyses using Excel
●Design new dashboards for several areas of the business
●Provide guidance on data to stakeholders to enable them make informed decisions
●Refine and distribute existing reports ensuring they remain accurate and timely
●Discover and emphasise trend and patterns within the data