As a Power BI consultant, data architect, developer, SQL data solution analyst, I have been responsible for setting up data architecture to integrate disparate sources of legacy data into a unified business data model, conducting feasibility study of advanced data tech, providing a single source of business data, and end-to-end delivery of business data. I have achieved success in data modelling and developing SSAS tabular model, creating complex SQL procedures, developing SSRS reports, and designing and implementing Power BI reports. I have also administered the Power BI portal, SSRS portal, and SQL Server Infrastructure requirements.

As a Data Analyst Developer, my responsibilities included facilitating progress of a data source system, organising data mapping sessions, streamlining business rules, and introducing SCD. My achievements include importing data within two months, identifying data lineage and flow, improving cube performance time by 70%, and conceptualising an ETL framework. I have also created a bespoke ETL framework using SSIS+SQL to perform extractions from multiple data sources to the end user legacy application Everest.

As a Lead SQL Developer BI Architect, I was responsible for analysing KPI requirements and introducing a new reporting process to Investment Managers and Financial Planners. I also architected, designed and developed a bespoke dynamic SSIS ETL solution, allowing near real-time ETL scheduling and transformation of source data without modifying any ETL packages. In addition, I developed complex T-SQL procedures for logic driven reporting and REST APIs in C# to retrieve JSON data from the CRM source web servers. My achievements include developing a Power BI dashboard to identify report usage across 250+ employees and implementing Tableau reports.

I have 5 years of experience as an Interim Scrum Master. My responsibilities included delivering under Agile using SCRUM and Kanban approaches, creating User Stories in JIRA, overseeing Sprint delivery, leading the team on various design and architectural changes, and liaising with Business stakeholders using interactive sessions. I achieved SSRS 2012 to SSRS 2016, branding the portal on lines of the organisation theme, and defining and scoping out user story requirements.

As a BI Architect Developer, I was responsible for strategising the long-term view of the BI estate, gathering and analysing requirements for upcoming BI projects, integrating multiple development work streams into the current BI estate, and liaising with application and DBA support. My achievements included developing a Greenfield DWH for a CRM system, re-designing and developing a legacy CMS DW, migrating legacy WFM data and system, developing advanced SQL objects, and developing SSAS Tabular model for Power BI reporting.

A a Senior BI Developer Analyst, I have designed and developed BI systems using T-SQL and SSIS, automated SSRS reports hosted via SharePoint, developed SQL code to present scheduling data, and performance tuned SQL routines. My solutions have optimised lead generation for Clinics, reduced manual effort by 30-man weeks annually, and improved query times by 80% on average.

I am a BI specialist with 2 years of experience in Requirements Gathering, Estimation and Delivery of projects amounting to £1M. I have led, assisted and co-ordinated with teams (offshore and onsite) for every release cycle, provided consultancy to data warehouse projects, delivered Monthly Project release cycles, designed, developed and delivered the Organisation dimensional structure, developed Dimensional BI model for hierarchies, developed SQL stored procedures, re-designed the ETL to reduce the avg. nightly load durations, facilitated effective incident resolution within SLAs, and conducted workshop-based trainings for onsite and offshore teams. I have received Employee of the Month for outstanding service and customer engagement.

Responsible for Requirements Gathering, Estimation and Delivery of projects amounting to £1M. I led, assisted and co-ordinated with teams (offshore and onsite) for every release cycle, and provided consultancy to data warehouse projects. I delivered Monthly Project release cycles, designed and developed the Organisation dimensional structure across 6 countries using Slowly Changing dimensions (SCD), developed Dimensional BI model for hierarchies to report Facts at multiple (8) reporting levels, developed SQL stored procedures for facts to report at both historical and current organisation dimensional structures and further extended this into Cognos Transformer cubes using the Kimball Data warehouse design methodology. I re-designed the ETL to reduce the avg. nightly load durations by 40%, facilitated effective incident resolution within SLAs and resolved Problem records with minimal delay. I also conducted workshop-based trainings (both functional and technical) for onsite and offshore teams.

Responsible for Requirements Gathering, Estimation and Delivery of projects amounting to £1M. I led, assisted and co-ordinated with teams (offshore and onsite) for every release cycle, and provided consultancy to data warehouse projects. I delivered Monthly Project release cycles, designed and developed the Organisation dimensional structure across 6 countries using Slowly Changing dimensions (SCD), developed Dimensional BI model for hierarchies to report Facts at multiple (8) reporting levels, developed SQL stored procedures for facts to report at both historical and current organisation dimensional structures and further extended this into Cognos Transformer cubes using the Kimball Data warehouse design methodology. I re-designed the ETL to reduce the avg. nightly load durations by 40%, facilitated effective incident resolution within SLAs and resolved Problem records with minimal delay. I also conducted workshop-based trainings (both functional and technical) for both teams.

I am a Software Engineer, my responsibilities include Requirements Gathering, Estimation and Delivery of projects, leading and coordinating teams, and providing consultancy to data warehouse projects. My achievements include delivering Monthly Project release cycles, designing and developing Organisation dimensional structure, developing Dimensional BI model, and developing SQL stored procedures. I have also conducted workshop-based trainings and received Employee of the Month for outstanding service and customer engagement.