- Develop and implement databases, data collection systems, schemas and dictionary- Acquire data from primary and secondary data sources and maintain data systems/databases- Identify, analyse, and interpret trends or patterns in complex data set.- Define and manage information exchange with 3rd parties- Filter and clean data and identify / correct code problems- Work with management to priortize business and information needs- Locate and define new process improvement opportunities.SKILL & EXPERIENCE: SQL SERVER AND MICROSOFT BI STAK, SSIS/ETL, MS POWER BI, TABLEAUEXPERIENCE COMMUNICATING WITH ALL LEVEL STAKEHOLDERABILITY TO ARTICULATE COMPLEX PROBLEMS TO A NON-TECHIE AUDIENCEABILITY TO UNDERSTAND WIDER SYSTEM REQIREMENTS AND THE IMPACT OF CHANGEABILITY TO PROVIDE ACCURATE ESTIMATES & WORK TO TIGHT DEADLINES

• Work in a team focussing on data migration• Extraction of data from source systems and the data warehouse• Applying business and data rules to extracted datasets• Checking for gaps in datasets and working with the various business functions to remediate• Mapping source data to new target datasets• Produce reports / dashboards to monitor data migration quality and progress• Construction of combined datasets in preparation for data loading• Transformation of data types to support data load files• Creation of migration documentation to support the data migration framework• Provides support for Data & Analytics Developers as and when required with operational activity• Deals with service logs generated by the Service Desk (including troubleshooting, dealing with requests/problems or assigning to a colleague in ITS as appropriate) if required• Carry out project work as required• Advises and supports other teams with project work• Complies with Group policies and GDPR requirements at all times

Currently, I am involved with the review of current NHS Digital commercial system architecture and relationships between systems. I am involved with retrieving and manipulating data from different sources (MS Excel, Text Files, Flat Files, csv, Databases, etc.) interacting with both internal and external customers for the purpose of gathering requirements in order to create various data models in Power BI which will enable self-serve report building capability for the entire organization.As part of my task, I develop commercial dashboards, reports, KPIs and datasets from agreed specification (TBC) in MS Power BI and deploy them to the cloud service as well as to Bravo Website and Microsoft SharePoint and also schedule refresh;- Operational Management Dashboards, KPIs and reports with several visuals- Commercial Leads Dashboard, KPIs and reports with several visuals- Senior Leadership Team Dashboard, KPIs and reports with several visuals- Procurement Dashboard, KPIs and reports with several visuals- Contract Management Dashboard, KPIs and reports with several visualsI equally make use of Reporting services such as SSRS, Tableau, QlikView, Advanced Excel to produce and deploy reports, dashboards and datasets to the reporting services and schedule refresh across them.I use SSAS to build Multidimensional cubes which enable self-serve report building among colleagues and other non-IT customers.I migrate and transfer data from different data sources to their final destinations using SSIS(ETL), perform different types of SSIS transformations and updating of databases and Datawarehouse in order to automate reports in reporting services.I use SQL Server 2017 editions and Visual Studio to create database objects based on business policy and business model and in line with the organization daily business processes.These database objects include; creating Databases, Schemas, Tables, Stored Procedures, Views, Subqueries, CTEs, Temp Tables, Triggers, Functions, etc.

Responsible for designing and implementing reporting solutions for the purpose of data analysis, standard reporting and management information for the specialist Car Benefit Solutions Ltd helping UK and international company and brand. As part of a financial company that provide loans, credits and other financial services for All Employee Ownership Car Scheme and the automobile companies across the UK and Ireland, my role includes using SQL Server to extract and analyse data from the databases/data warehouses, to develop interactive data visualisation solutions that meet the need of both internal and external customers. I write reports underpinned by clean, logical and efficient T-SQL in order to provide market analysis and business insights using various datasets, dashboards and KPIs.I create new reports in SSRS, Power BI, Tableau and Excel based on customer’s requirement obtained through a tracking system and project management software known as YouTrack as well as keeping track of tasks and bugs, create workflow, etc. for the purpose of business enhancement.I work on Test/Dev/Live environments and also deploy reports to reporting services such as SSRS and Power BI services, Storm website and Microsoft SharePoint for easy accessibility by customers.I equally engage in the conversion/migration of reports from SAP Crystal Reporting platform to SSRS and Power BI reporting services. Perform ETL processess using SSIS to clean, transform and Load data from various sources such as Text files, Excel files, Flat files, XML files, databases, etc to their final destinations.

I produce high quality innovative Business Intelligence solutions for the specialist Digital Insights Inc. helping UK and International companies and brands. Using Microsoft SQL Server 2008 /2012 /2014/ 2016, Visual studio 2013 / 2014 / 2015 / 2016, SSIS, SSRS, SSAS, Microsoft EXCEL functions and POWER BI to create and automate spreadsheets, pivot tables, power pivot, power views, packages and solutions etc., to enhance a suite of ad-hoc and standard reporting outputs, to customise reports, publish reports, create and share KPIs and dashboards from raw data into visual format which meet internal and external customer needs across the UK & Ireland. Using the above tools to combine various financial and business data to create an exceptional insight, business evaluation and risk stratification, migrate data from several sources to their final destinations and to maintain and develop databases, to create star schema data models, ETLs (Extract, Transform and Load data) and validating results with business representatives. Supporting BI solutions by monitoring and tuning queries and data loads, addressing users’ questions concerning data integrity, monitoring performance and communicating functional and technical issues.Work with wider BI team and internal IT Teams to drive technical innovation and add genuine value and insight to all aspects of the business.

Performed daily data queries and prepared report on daily, weekly, monthly and quarterly basis using Microsoft SQL Server (T-SQL, Store Proc, Views, Temp Table, CTE, etc.), SSIS, SSRS, SSAS and Excel functions (pivot tables vlookup, hookup, index, if function, charts, graphs, formatting, etc. ) to generate spreadsheets, dashboards and Key Performance Indicators (KPIs) to enhance robust business decisions for the organisation. Acquiring data from primary and secondary data sources and maintaining databases as well as filtering and cleaning data by reviewing reports, printouts, and performance indicators to locate and correct code problems.

Monitoring And Inspectorate Dept.