Power BI Developer, Power BI Report Analyst, Snr. MI Analyst

* Develop and maintain deployment pipeline rules across the different workspace environments and
deploy artefacts such as dataflow, semantic models, reports etc.
* Manage Power BI Security, Workspaces, Apps, incremental/scheduled refresh, implementation of Row
Level Security (RLS), Bookmarks.
* Design, develop, and maintain semantic models, dataflows used in creating Complaints, Exception
Management, Energy Supplier, Non-Half Hourly, and Half Hourly Dashboards to provide the business
with actionable insights.
* Worked cross-functionally with the Integration Management Office following the acquisition of
Power DA to develop new dashboards and migrate existing SSRS reports/Power BI Reports from PBI
Report Server to Power BI Service
* Created Pipelines in ADF using Linked Services, Datasets and Pipeline to extract, transform and
load data from different sources including Flat Files in Azure Storage account, into Azure Synapse
Analytics tables
* Implemented Power BI paginated report solution best practise and trained the team on the most
effective way to develop reports which helped to reduce development time by over 50%
* Developed complex SQL queries using stored procedures, common table expressions (CTE), temporary
table to support Power BI paginated report
* Carry out performance tuning using Performance analyser and DAX Studio to review queries that are
impacting on the visualisation rendering time
* Merge data from disparate data sources using Data blending for Sales Metrics Dashboard using
Tableau
* Create calculated fields, crosstabs, combine field, bins, sets, hierarchies and dual-axis
charts/maps using Tableau
* Create user filters to restrict access at the Data Row Level to ensure only Sales team can access
the dashboard using Tableau.
* Created filter actions, parameters and calculated sets for preparing dashboards and worksheets in
Tableau
* Mentored 3 Junior Data Analysts on the organizations evolving approach to requirements management
and best practice and dashboarding
* Led on the project on performance improvement of customer service reporting suite and enforced
query folding thru out the steps in power query, this reduced the data load time drastically by over
60%
* Collaborate with cross-functional teams to gather and understand data requirements and
subsequently create BRD document.
* Conduct Power BI training to upskill members of the team and other end users within the business
* Performed gap analysis and documented current and future state process workflows
* Develop exception management reports to monitor and improve data quality / integrity
* Contribute to the development of the company's data strategy such as data governance, data
dictionary etc.
* Manage stakeholder needs and expectations and communicate effectively for ongoing project progress
visibility
* Perform data transformation in Power Query by utilizing MERGE, APPEND, LEFT OUTER, RIGHT OUTER,
INNER, LEFT ANTI & RIGHT ANTI JOINS.
* Migrated over 20 existing self-service crystal reports and adhoc reports to Power BI as part of
project Energise

* Redesign/convert excel based IAR Forecasting Model to PowerBI which involved creating Appt Slots,
Appt Slots Utilisation, Expected Delivery Target etc by cluster
* Working cross-functionally with key business partners to help establish strategic goals and
objectives, project objectives, and set expectations on functional scope.
* Performed gap analysis and documented current and future state process workflows
* Map data across different codes to successfully partition data when presented as a Matrix
* Utilized variables to create complex measures in DAX for forecasting for the different weeks, MTD,
YOY, Last3Months by Cluster etc.

* Manage PowerBI Security, Workspaces, Apps, incremental/scheduled refresh, implementation of Row
Level Security (RLS), Dynamic reporting, Bookmarks, support and training for both internal and
external clients

* Develop interactive dashboards in Power BI from Data warehouse e.g., creating calculated measures,
columns, variables, creating complex data model, and using DAX functions.

* Worked with stakeholders to elicit requirements, and documenting these in the form of business and
functional requirement artefacts.

* Respond to ad-hoc request by extracting data from Database & DWH utilising SQL such as CTE,
Subqueries, Temp tables etc.

* Gathered, validated and documented the "As Is" and "To Be" process states and identified gaps.

* Elicitation of business and user requirements needed to conduct current state analysis

* Migrate SSRS reports/Power BI reports from Power BI Report Server to Power BI Service

* Managing stakeholder needs and expectations and communicate effectively for ongoing project
progress visibility

* Design, develop, and maintain, Sales Dashboard, HR Dashboard, Finance Dashboard, Customer Success
Dashboard, Leadership DB for external clients delivered as an embedded report using Power BI
* Merge data from disparate sources using Data blending for R&D Metrics project using Tableau
* Create calculated fields, crosstabs, combine field, bins, sets, hierarchies and dual-axis
charts/maps using Tableau
* Create user filters to restrict access at the Data Row Level to ensure only R&D team can access
the dashboard using Tableau.
* Develop complex dashboards in Tableau using table calculations and Level of Detail Expression
(LOD)

* Produce data dictionary and data mapping to assist the Data Architect with data warehouse design

* Provide technical support and guidance through prototyping, testing, build, and launch of Power BI
dashboards.
* Provide subject matter expertise to internal and external stakeholders on BI solutions
* Support the full BI lifecycle from requirements analysis through to design & development, release
and maintenance phases.
* Develop exception reports to monitor and improve data quality/integrity
* Implement both standard and scheduled data-driven subscriptions in SSRS and reports rendered in
different formats such as PDF, PowerPoint, CSV, Excel etc. from disparate data sources