Experience

Karhoo

• United Kingdom
• IT Services and IT Consulting
• 1 - 100 Employee

• Senior Business Intelligence Developer

  • Apr 2019 - Present

  London, United Kingdom



The MDU

• United Kingdom
• Financial Services
• 200 - 300 Employee

• Senior ETL Developer

  • Feb 2015 - Apr 2019

  London, United Kingdom • Led in the design and implementation of facts and dimensions in the data warehouse using Kimball methodology to establish one source of truth. • Built the ETL using SSIS and used complex stored procedures to transform the data for staging. • Liaised with stakeholders to understand their business requirements & create sun diagrams. • Sun diagrams used to develop the data warehouse to achieve the business requirements. • TFS repository used to upload and maintain T-SQL Scripts… Show more • Led in the design and implementation of facts and dimensions in the data warehouse using Kimball methodology to establish one source of truth. • Built the ETL using SSIS and used complex stored procedures to transform the data for staging. • Liaised with stakeholders to understand their business requirements & create sun diagrams. • Sun diagrams used to develop the data warehouse to achieve the business requirements. • TFS repository used to upload and maintain T-SQL Scripts, SSRS reports and SSIS Packages. Used branches in TFS to develop in Dev and promote to Test/Prod as required. • Create and maintain data mapping for source and destination of the ETL. • Used DataEDO and Alation to map data and definitions in the data warehouse. • Helped to establish data owners in various business departments. • Worked within an Scrum/Agile framework to deliver outputs to the product owners in each sprint. • Managed several staff members including contractors. Show less



The DST Global Insight Group

• SQL Developer

  • Aug 2013 - Feb 2015

  London, United Kingdom • Solutions developed for various clients including the NHS, Arriva and Tiffany. • Packages developed for campaigns which sent out emails to certain customers throughout the week, including confirmation, password reminder and completion emails. • On-going reports designed using SSRS and uploaded to Report Manager for easy user access and scheduling. • Developed SSIS packages to download and upload files to SFTP/FTP sites, extract data to external files, load data in to the database… Show more • Solutions developed for various clients including the NHS, Arriva and Tiffany. • Packages developed for campaigns which sent out emails to certain customers throughout the week, including confirmation, password reminder and completion emails. • On-going reports designed using SSRS and uploaded to Report Manager for easy user access and scheduling. • Developed SSIS packages to download and upload files to SFTP/FTP sites, extract data to external files, load data in to the database, update the database, send emails, move files etc. • Utilised T-SQL features such as Stored Procedures, Functions, CTE and Triggers in the development of reports and packages. • TFS repository used to upload and maintain T-SQL Scripts, SSRS reports and SSIS Packages • Worked on projects in an Scrum/Agile environment. • Documented the process behind Stored Procedures, SSIS packages and Database Loads. • Trained and supported colleagues in the use of SSIS, SSRS and SQL. Show less



British Red Cross

• United Kingdom
• Civic and Social Organizations
• 700 & Above Employee

• Business Intelligence Developer

  • Feb 2012 - Jul 2013

  London, United Kingdom • Developed BI solutions using a number of technologies and tools including the MS BI Stack (SSIS, SSAS, and SSRS), Excel, Tableau and SharePoint as appropriate. • Developed dashboards and integrated solutions in Tableau for regular and ad-hoc requests. • Supported the development of a new data warehouse based upon the Kimball Methodology to allow faster and more efficient reporting. • Developed, amended and updated the ETL behind the dataset using SSIS as required. • Work alongside… Show more • Developed BI solutions using a number of technologies and tools including the MS BI Stack (SSIS, SSAS, and SSRS), Excel, Tableau and SharePoint as appropriate. • Developed dashboards and integrated solutions in Tableau for regular and ad-hoc requests. • Supported the development of a new data warehouse based upon the Kimball Methodology to allow faster and more efficient reporting. • Developed, amended and updated the ETL behind the dataset using SSIS as required. • Work alongside other developers to test the ETL for accuracy and completion. • Trained and supported colleagues in the use of SSIS. • Developed test plans and carried out process and system testing on new external agency reporting process driven from the data warehouse. • Worked on projects in an Agile Scrum environment. • Documented various business processes to identify weaknesses and allow audibility

• Database Marketing Report Writer

  • Jan 2011 - Jan 2012

  London, United Kingdom • Lead report projects, acting as the primary point of contact for client liaison throughout the project lifecycle. • When leading projects agreed and understood the stakeholders needs which included specifications, timescales, commercial needs and translated these into data and reporting requirements. • Worked with BIDS to develop packages using SSRS, SSAS and SISS. • Used SSIS to extract data from flat files/SQL Servers, transform it and update/insert in to the CRM… Show more • Lead report projects, acting as the primary point of contact for client liaison throughout the project lifecycle. • When leading projects agreed and understood the stakeholders needs which included specifications, timescales, commercial needs and translated these into data and reporting requirements. • Worked with BIDS to develop packages using SSRS, SSAS and SISS. • Used SSIS to extract data from flat files/SQL Servers, transform it and update/insert in to the CRM Database. • Worked with T-SQL to produce data for SSRS reports using CTE, Rank, User defined functions and stored procedures. • Managing SSAS by starting, pausing, or stopping the Analysis Services. • Built tabular, matrix, chart or free-form reports using SSRS, which included: o Connecting to data from a range of data source e.g. OBDC, OLE DB etc. o Using query parameters to allow end users to filter data. o Using controls and expressions to aggregate and summarise data. • Used Microsoft Reports Manager to manage shared data sources, report access and setting up data-driven subscriptions as required by end users.



Homes for Islington

• United Kingdom
• Real Estate
• 1 - 100 Employee

• Performance Data Analyst

  • Sep 2008 - Dec 2010

  London, United Kingdom • Produce certain reports on periodical basis from the OHMS Housing database. • Monitor and report on the key performance indicators for the repair’s contractor. • The development of a performance framework model for Responsive Repairs. • Use of Northgate/Anite OHMS and iWorld to check the status of repair orders. • Establish reports and procedures that will help improve efficiency of the housing service. • By using Data Query tools such as SQL, Infomaker, Business Objects and… Show more • Produce certain reports on periodical basis from the OHMS Housing database. • Monitor and report on the key performance indicators for the repair’s contractor. • The development of a performance framework model for Responsive Repairs. • Use of Northgate/Anite OHMS and iWorld to check the status of repair orders. • Establish reports and procedures that will help improve efficiency of the housing service. • By using Data Query tools such as SQL, Infomaker, Business Objects and Crystal, lead on creating and distributing bespoke reports for a variety of stakeholders and audiences as required by the service. • Provision of data both externally and internally in relation to the procurement of a new contractor. • Regular monitoring of the Housing Database and reporting on the integrity and quality of data within it. • Identify, analyse and report on outstanding orders on the system which may be present due to human error, system errors or disputes. Show less



Ofsted

• Government Administration
• 700 & Above Employee

• Data Analyst

  • Apr 2007 - Apr 2008

  London, United Kingdom • Produce various quarterly Children services reports for internet publication using SQL. • Using VBA to design macros and functions for use in Excel. • Regular and ad-hoc reporting on children service provider’s related data, and providing this data to clients, other departments and management. • Quality assured the accuracy and presentation of data prior to submission. • Use of SQL and Business Objects to extract and manipulate data from the database • Ensure monthly… Show more • Produce various quarterly Children services reports for internet publication using SQL. • Using VBA to design macros and functions for use in Excel. • Regular and ad-hoc reporting on children service provider’s related data, and providing this data to clients, other departments and management. • Quality assured the accuracy and presentation of data prior to submission. • Use of SQL and Business Objects to extract and manipulate data from the database • Ensure monthly snapshots of the database are taken from the server and saved for use by the team. • Reporting on statistical changes between quarters and examining the possible reason for its occurrence. • Producing reports in MS Excel, using functions, macros, pivot tables, etc. • Advanced use of MS Access to produce relational databases and write queries. • Supporting the team, by offering advice and assistance where possible. Show less



M Yunus & Associates

• Information Analyst

  • Aug 2003 - Mar 2007

  London, United Kingdom • Regular and adhoc reporting on various business performance data. • Extensive and advanced use of Access and Excel in the production of reports. • In-depth analysis of activity and financial data. • Maintenance of database, including data quality testing. • Developed certain software modules, using VBA, to transfer financial data from a client’s data system in to VT transaction. • Dealing with any technical questions regarding a particular report or the… Show more • Regular and adhoc reporting on various business performance data. • Extensive and advanced use of Access and Excel in the production of reports. • In-depth analysis of activity and financial data. • Maintenance of database, including data quality testing. • Developed certain software modules, using VBA, to transfer financial data from a client’s data system in to VT transaction. • Dealing with any technical questions regarding a particular report or the database. • Planning, prioritising and the organising of work in adherence to deadlines. • Gained a general accounting knowledge through aiding the accounts team in busy periods. Show less