Power BI SME

Cedric Amoah

Email: ***************@*****.***

Phone Number: +447********* or +447*********

Location: Greater London Area

PROFESSIONAL SUMMARY

With years of extensive experience in Microsoft SQL Server Business intelligence (MSBI), suites of products (SSIS, SSRS and SSAS) with different phases of SDLC.

Well experienced in working on developing SSIS packages, SSRS Reports and SSAS Cubes on large-scale Data Warehouses.

Well experience in implementing, developing, deploying and maintaining Power BI and reports

Good at Developing SQL Server Integration service (SSIS) packages with all the Data flow, control flow tasks.

Using SQL Server Reporting Services (SSRS) developed Custom Reports, Tabular, Matrix, gauge, indicator, Ad hoc reports, distributed reports in multiple formats, drill down reports, parameterized reports, Matrix report, .net scripts Cascaded reports and creating stylish report layouts.

Expert in identifying KPIs and defining referenced relationships, analyzing data intensively, creating and modifying Cubes, Dimensions, Designing, Building the Dimensions, Cubes with Star Schema / Snow Flake Schemas, writing DAX Query, calculated measures and KPI’s using SQL Server analytical services (SSAS) with knowledge and experience using Kimball Methodology.

Experienced in writing SQL query/Stored Procedure/ user defined functions and involved in query fine tuning for performance improvements.

Expert in designing, migration, maintenance & reporting on SSAS Tabular cube for Power BI.

Strong technical background along with the ability to perform business analysis and -write/maintain effective documentation and specifications.

Experience in Data analysis, Application/Production/end user support.

Excellent problem solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines.

Strong written and verbal communication skills.

Demonstrate innovative strategies that will benefit my employer in any way and proficient with Microsoft Office Projects, JIRA and VS-TFS.

Pressured environments are something I’m used to and enjoy and experienced working in scrum/agile environments.

Education/Certifications

Computer Network Management and Security: Middlesex University London from (2010 -2014) Awarded: 2.1.

ITIL IT Service Management Certification: AXEELOS

Prince2 Foundation: APMG-International

Technical Competencies

Operating Systems

Windows 2000/2003/XP/Vista/7/10, Windows Server 2003/2003 R2/2008/2008 R2/2012 r2

Database Tools

SQL Server Management Studio(SSMS), SQL Profiler, DTS Designer, Index Tuning Wizard, Oracle 8i/9i, SQL Data Tools, Oracle SQL Developer, IBM Cognos FrameWork, QlikView

GUI Tools

SQL Server Business Intelligence Development Studio, ER Studio, Visual Studio 2008/2010/2012/2014, Data Tools, MS Report Builder 3.0,IBM COGNOS Report Builder, Microsoft TFS, Azure SQL

Languages

T-SQL, PL-SQL,DAX,MDX, JSON, R

OLAP Tools

SSIS, SSRS, SSAS,IBM COGNOS ANALYSIS STUDIO

Other BI Tools

DQS, MDM,POWER BI,SHAREPOINT,MDS, IBM COGNOS

PROFFESIONAL EXPERIENCE

Client: BDO UK LLP (Finance Department)

Place: Gatwick

Role: Power BI SME

Duration: March 2018-Present

Currently assisting BDO UK LLP, an elite organisation of accountants and business advisors. My role here is to support the company in the implementation and training of using Power BI as a reporting tool for the organisation to gain insight towards a culture of data driven decisions.

Duties include:

Documentation of current reporting infrastructure AS IS and TO BE

Working in partnership with IT team to install and configure Power BI premium node

Write up specification for servers to be used as data source for powering reports to be generated

Support with knowledge transfer of Power BI and writing How to?

Client: EXPERT-24

Place: Amersham, Buckinghamshire

Role: Power BI SME

Duration: October 2017-March 2018

Leverage expertise in Microsoft BI Stack (SSMS, SSIS, SSAS, Power BI) and work on design, development, and implementation of data warehousing, reporting and analytics solutions

Deliver strategy for transitioning current solutions into well integrated SSAS cubes

Suggest new ideas for data visualization (Power BI)

Advanced relational data modeling and database design (SQL Server)

Multidimensional modeling and experience building and fine tuning OLAP cubes (SSAS)

Data transformation and ETL (SSIS)

Health check on Power BI environment

Infrastructure check

Performance assessment

Best practice recommendations

Assess requirements and feasibility to migrate SSRS reports to Power BI

Documentations on Power BI environment, architecture, operations procedure, back up, disaster recovery

Client: Kingston University

Place: Norbiton, Surrey

Role: Senior Business Intelligence Applications Technical Analyst

Duration: May 2017-October

Responsible for Enterprise BI Applications, Power BI Development & Implementation of Data Gateways

Other Duties:

Take responsibility for the design, data modelling, build and further development of the Kingston University DWH and BI

Define, build and implement effective information processes to ensure data integrity, performance, and security of reporting solutions using Microsoft SQL Server 2012 BI Suite SSIS, SSAS (analysis services), and SSRS (reporting services)

Define and build KPI metric dashboards using (SSRS) and/or Power BI tools

Working with the BI and Information Management Team Leader to define and take ownership of BI and DWH service capability roadmaps

Working with the BI and Information Management Team Leader to develop architectural blue prints for BI and DWH information management services going forward

Responsible for setting up and running of requirement gathering workshops, meetings, and reporting demo’s to elicit and document stakeholder reporting requirements across the University in a consistent manner

Ensure BI and DWH technologies are fit for purpose including the consolidation and standardisation of technologies and the rationalisation and decommissioning of duplicate technologies across the University

Undertake unit, system and performance testing of BI solutions, and contribute towards user acceptance testing to ensure quality deliverables

Take a technical lead role in the configuration, development, implementation, and administration of Microsoft SQL Server 2012 BI Suite (SSIS), (SSAS), (SSRS)

Develop and maintain a broad application and technical knowledge, being fully aware of technology developments in HE Sector

Deputise for BI & Information Delivery Team Leader as required, representing IT Services at meetings, and events

Backup and recovery of SQL-Server

Maintaining Power BI reports in Azure

Client: Hitachi Consulting(IMGROUP)

Place: Blackfriars, London

Role: Senior Business Intelligence Consultant

Duration: September 2016-May 2017

Provided business intelligence expertise, delivery and consulting to a variety of large corporate clients. Working with a team and reporting to the BI Practice Group Manager, as Consultant I must understand a client’s business problem, contribute to the creation of a viable solution and guide the implementation of that solution within the client’s environment. The scope of projects varies from 20 to 2,000 man days.

Other Duties Included:

Working with client companies to establish the business need.

Working with technical architects to scope the solution by providing a clear, accurate and workable brief and then ensuring this works in practice.

Devising and delivering appropriate BI technical solutions to meet client and IMGROUP requirements.

Acting in a consultant role with the client, providing liaison, ongoing communication, managing client expectations and dealing with client issues.

Implementing MDS (Master Data Services) solutions.

SSAS Tabular implementation.

Power BI reports creation

POC with clients to illustrate end product and establish client expectations.

ETL Development

Delivering KPIs, reports, executive summaries, at the portfolio level, Programme and Project level

Using JIRA to manage projects and creating projects reports and dashboard for client to manage expectations/insight on project span such as sprint burndowns, voted issues, work load pie charts and more

Creating project plan in MS VSTS for developers and client for clarification on current and future works

Client: The Foundry

Place: Soho, London

Role: SQL Business Intelligence Manager

Duration: April 2016-September 2016

Currently heading the Business Intelligence department at the Foundry, this is a market leading visual effects company with prestigious clients such as Pixar and Walt Disney animations. In this role, I have created a meticulous and result focused development that aids all core functions of the business. In conjunction with configuring development, test and production/live server environments to provide a test driven development, which facilitates handling errors more efficiently. Constructed and implemented the BI architecture which consists of the most recent Microsoft technologies:

SQL server 2014 as the on premise database.

Microsoft SSIS as the integration tool with custom built API's to allow communication with Sales Force and other sources of cooperate data such as Microsoft Dynamics CRM.

Microsoft SSAS Tabular Instance as the OLAP technology for data analysis.

Microsoft Power BI 365 Service as the reporting and presentation layer.

JIRA for project management and project reporting via dashboards and visual reports.

This architecture is backed by data quality strategies, data governance rules and a BI framework devised and enforced by myself to maintain a robust and efficient end to end BI Solution, whilst adhering to all stages of the SDLC, as well as following Kimball methodology in regard to data warehouse implantation best practices.

Other Duties Include:

Drive the strategic business intelligence roadmap, working with stakeholders from the other business functions to identify, initiate, and deliver projects which will leverage the data and information to generate increased business value

Accountable for leading BI transformation programmes

Accountable for establishing and managing a data governance programme across the Organisation

Responsible for the overall IT systems landscape covering business intelligence solutions plus the development and building new data function

Accountable for the day to day support and maintenance of solutions and delivery on SLAs, including delivery of ongoing functional releases required to support new business requirements and technical improvements. Works closely with business change function and regional head of IT to capture and prioritize new requests on Reporting.

Promote BI benefits across the organisation. Promote BI usage to the relevant departments.

Evaluate and select database/data warehouse components, including relational database management systems and database design solutions.

Conduct research and make recommendations on BI products, services, and standards in support of procurement and development efforts.

Keep up to date in all aspects of Business Intelligence developments and attend training courses as appropriate.

Any other duties as agreed.

Ensure that the documentation of all developed products is accurate and complete.

Implement and document change control procedures.

Adhere and contribute to all development standards and procedures.

Concentrate on quality and excellence with an aim to improve processes and systems.

Troubleshoot BI tools, systems, and software as and when appropriate.

Monitor and evaluate system and software performance and make system/software recommendations as appropriate.

Design and deliver end-user training and training materials.

Provide technical support as necessary.

Design, develop and deliver reports, graphs, dash boards and portal interfaces where appropriate to meet customer requirements. This would be according to the agreed priorities.

Design, code and test all new or modified BI systems and reports.

Undertake thorough testing at development stage. Manage customer testing, user acceptance and sign off.

Undertake data analysis in order to provide the customer with a clear understanding of their data and the information contained therein.

Client: Hamley’s of London

Place: Oxford Circus, London

Role: SQL Business Intelligence Developer/Analyst

Duration: January 2016-April 2016

Hamley's London is a prestigious retail company specialising in high end children's entertainment toys. My role as a SQL Business Intelligence Developer in the support center at Hamley's is to provide and end-to-end BI solution to give insight on the large amounts sales data. The architecture consist of combining the most recent versions of components of the combined Microsoft & IBM Cognos stack.

Microsoft is used as back-end environment: Microsoft SQL Server 2008 is used as database

Microsoft SQL Server Integration Services 2008 is used as ETL containing a staging area and a data warehouse target area, Microsoft SQL Server Analysis server 2008 is used as Cube technology. The IBM Cognos 8.4 Business Intelligence solution is used as BI front-end environment: IBM Cognos 8.4 Framework Manager is used as business layer, IBM Cognos 8.4 Report Studio and Qlikview is used as report builder, and IBM Cognos 8.4 Analysis Studio is used as OLAP layer and using MS VSTS as a project management tool.

My duties include:

Construct or modify program modules from specifications using programming languages and techniques to achieve a well-engineered product.

Construct, execute and interpret results of test plans.

Use the required standards, methods and tools for analysis and program development and be able to use common features to a basic level in supervised environment.

Document all work to the required standard.

Support with the presentation of technical problems, processes and solutions.

Plan and schedule specific tasks competently.

Build SQL SSIS packages and Dashboards to support THE COMPANY MI environment.

Implemented automated jobs for manual work arounds using SSIS, SSRS and Qlikview for various departments.

Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).

Played a major role in production support of SSAS cube and SSIS jobs.

Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).

Design various E-R diagrams for different modules by using Erwin and Visio.

Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.

Migration is also done using Bulk Insert and dynamically created queries in the job steps.

Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.

Designed and implemented Dimensions and Measures according to business requirement.

Used ADO.NET objects to access data from SQL Server 2012 database by using stored procedures and queries in T-SQL.

Created reports and dashboards using QlikView for Finance depart.

Created Linked Server using the dedicated LAN for load balancing and increased the performance of the Data Warehouse.

Utilised documentation prepared by Business Analyst to complete projects.

Used business Analytics to prioritize reports.

Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.

Scheduled and maintained routine jobs, tasks, and alerts. For instance an alert would be sent to the manager of customer service representative if fields were not entered by the data entry person regarding screening using SQL Server Agent.

Created ad hoc T-SQL Queries.

Performed some DBA Tasks like checking the jobs that fail and troubleshooting the issues.

Worked in Development, Testing and Production environment.

Client: Kings College London

Place: Covent Garden, London

Role: Business Intelligence Developer/Analyst

Duration: November 2014-January 2016

At King's College London in my role as Junior Business Intelligence Developer I was part of a team of 6 which implemented a BI Solution called Insight. Insight is a collection of tools and techniques for transforming raw data into meaningful information through analysis. Examples of outputs include KPIs and other performance measures, reports, transcripts, letters, alerts, automated decisions, algorithms, forecasts, graphs, maps, dashboards and other visualisations. Using Power BI as our reporting tool, I created and implemented all dashboards, reports and dataset using excel power query, power pivot and power map in order to make use of the Q &A feature In Power BI. Coupled with Using SSAS Tabular and Multidimensional, I created all the cubes and wrote all DAX calculations for cubes which we used as datasets in Power BI. I was also tasked to do the below:

Involved in complete life cycle of SDLC and also responsible for designing of logical as well as physical database.

Using Microsoft BI Package(SSIS,SSAS,SSRS and SSMS)

Creating indexes for better performance.

Creating packages to migrate data from different data sources to data warehouse.

Creating and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.

Extracting required mapping fields from different sources (schema, CDW) to data Warehouse for Staging Table.

Testing the data with complex queries, joins, sub queries and temp tables.

Creating SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).

Rendering reports in different formats like PDF, excel etc to be executed automatically on weekly or monthly basis and managed subscriptions.

Generating Sub-Reports, Drill down reports, Drill through reports, Ad-hoc reports and Parameterized reports using SSRS.

Meeting with end-users and gathering requirements for business intelligence applications

Participating in the design of business intelligence solutions

Developing test scripts and executes quality assurance test plans for both data results and business intelligence application functionality

Providing necessary support and facilitation of user acceptance testing activities for business intelligence applications

Documenting data standards, data flows and data management processes in support of enterprise data governance initiatives

Configuring the report viewing security for various users at various levels using Report Manager.

Scheduling the monthly/weekly/daily reports to run automatically onto the Dashboard.

Scheduling report and exporting in PDF format.

Documenting all database objects, procedures, views, functions & packages for future references.

Performing all QA testing and match results for different environments.

Documenting all old and migrated Store Procedures and scripts for future references. Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.

Creating calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.

Creating MDX queries to extract data from the Data Warehouse.

Profiling data sources using SQL and other data discovery tools in support of data quality analysis and business intelligence design efforts.

Analysing and recommending solutions to data quality issues.

Client: NHS-Royal Hampshire County Hospital

Place: Winchester, Hampshire

Role: SQL/SSRS Developer/Data Quality Officer

Duration: August 2014-October 2014

Using SQL Server and Business Intelligence skills to deliver statistics based on SUS patient records at junior level. These statistics include delivery in the form of metrics, measure groups, standard deviations, charts and tolerance levels using mainly T-SQL to prepare the Fact tables and Dimension tables then using MDX to perform further analysis within the cubes.

These statistics are presented in reports and charts using SSRS which can be rendered in various formats such as Excel, PDF or CSV.

Further reports are being delivered using SSIS, SSAS & presented on SharePoint and SSRS.

Approximately 100 data quality ad hoc reports have been developed on the SUS data warehouse, this number is increasing all the time.

Shadowing other members of staff in the areas of business analysis, BI, SQL and project management including creating requirements definition templates.

The main data source for this project is the national NHS data warehouse called SUS (Secondary User Service). The main data mart used within this data warehouse was Payment by Results (PbR).

Validating patient’s pathway.

Using T-SQL to write select statements and joins to report on.

Client: NHS Bart’s Health

Place: Newham University Hospital Docklands, London

Role: Data Quality Officer/Performance Analyst

Duration: February 2014-August 2014

Performance Analysis

Analysed, Monitored and ensured that performance issues within the trust are accurate and effective.

Produced comprehensive report based on the operational performance of all specialty within the hospital.

Participating in annual, weekly and monthly performance review process where objectives are agreed, performance monitored and divisional developmental needs are discussed.

Working as an 18 Week Wait Analyst with the Cerner Millennium IT system which is an electronic patient record system used in large hospitals. My daily tasks were:

Validating patient data/pathways

Updating patients records

Searching for records

Creating SSIS package to move data from SQL Server to Excel for data validation purposes

Using Citrix software

Using CRS software

Advanced use of Microsoft Excel to create pivot tables and charts

Tracking patients health records using HIM Tracking

Using explorer menu to view pathway activities

Creating SQL SELECT statements and views

Client: NHS-Royal London Hospital

Place: Whitechapel, London

Role: Cerner Trainer

Duration: June 2014-August 2014

Specialised data quality support officer and training personnel at Bart’s Health. Trained staff in Oral Surgery APL and NAPL/ Orthodontics NAPL department. Other tasks included:

Training staff to use CRS software.

Lecturing staff on RTT status codes.

Floor walking- assist booking clerks on RIO.

Using PAS to demonstrate how to find clinical notes.

Using EPR to gather information about patients and presenting this to members of staff.

Using SCHAPPTBOOK to retrieve patient appointment information.

Contact this candidate