- InstronMI Reporting AnalystSeptember 2019 - Today (5 years and 7 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 LtdBI ConsultantSeptember 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 AnalystJanuary 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