Microsoft BI & SQL Developer

London

Customer-focused professional with Business Intelligence Solutions experience using Microsoft technologies and highly skilled on data architecture and database development. SQL Server 2005-2014 (8 years), SSRS, SSAS, SSIS (8 years), T-SQL, SP, Function Programming (8 years), Tabular & Multidimensional OLAP Design (8 years), PowerPivot, PowerView, PowerBI, Datazen (5 years), SQL Administration (4 years), HA & DR Strategies and Development (5 years), Database Management (8 years)

Key Skills
  • Microsoft BI
  • SQL Development
  • SSRS
  • SSIS

Work Experience

Senior SQL & BI Developer

London North West Healthcare NHS Trust 2 Years

Microsoft BI & SQL Development Development of SSRS - Reporting, SSIS - ETL and SSAS - OLAP projects SQL 2008 to SQL 2014 Migration including installation and settings of Windows Servers Performance Tuning on SSIS, SSRS and SSAS Programming with T-SQL (Querying, SP, Function, Trigger) on all SQL Server projects. SQL Administration including maintenance, performance tuning, replication and security Acute (ICS) and Community (S1) Datawarehousing Inpatients-Outpatients Reporting, Cube Development Radiology (CRIS) ETL design and SSRS Reporting Working on reporting tools including PowerBI, PowerPivot, PowerMaps and Datazen Greenfield SMS Reminder Project including Database Design, ETL implementation .net Web Application Development for SMS Reminder Project


Business Intelligence Team Leader & Consultant

TCM 4.5 Years

Microsoft BI Suite end to end project development including DWH Design, ETL, OLAP Analysis and Reporting SQL Administration, High Availability and Disaster Recovery environment setups T-SQL Development, Performance Tuning PowerBI & DataZen Dashboard Development Microsoft Azure Migrations, Reporting Managing BI & SQL Team, as well as resource allocations and budgeting for ongoing project/support work Lead T-SQL and BI workshops for client education


Senior Business Intelligence Developer

Frito Lay Pepsico6 Years

Pulling together information from a variety of systems (ERP, Finance, HR and Sales Systems) Correlating the data into datawarehouse design in order to provide meaningful insights Utilizing SSAS to design multi-dimensional data cubes for analytics and data mining Developing dashboards and reports utilizing SSRS, SharePoint 2010 tools (PerformancePoint, PowerPivot, Excel) and Dundas Dashboard


Business Intelligence Developer & Consultant

NETRON TECHNOLOGY 2 Years

Providing consultancy services to clients Leading data governance and architecture design effort for BI Department and maintaining modeling standards across all solutions for the data warehouse environment Analyzing conditions and identifying strategies that minimize implementation risk and/or improve system reliability and performance Utilizing SSIS to construct enterprise level ETL procedures, ensuring data integrity and proper data transformations to load data from source systems into target data structures within the warehouse Developing reports, scorecards and dashboards utilizing SSRS, SSAS, PerformancePoint, PowerPivot and SharePoint


COPYRIGHT © JOBDROP GROUP. 2017