Portrait of Siam Sadman

Siam Sadman

Power BI DeveloperMicrosoft Fabric Analytics Engineer

BI Developer and Reporting Analyst with 10+ years in enterprise reporting, building automated reporting pipelines and Power BI dashboards in production environments for clients including British American Tobacco Bangladesh, Arnott's Australia and TOLL Australia.

02 / Experience

Experience

Apsis Solutions Limited

Dhaka, Bangladesh · Feb 2017 – Aug 2026

Reporting Analyst (BI & Analytics) · Jan 2022 – Aug 2026

Senior Reporting Officer · Jan 2019 – Dec 2021

Reporting Officer · Feb 2017 – Dec 2018

Reporting team lead throughout tenure

Client engagement

British American Tobacco Bangladesh

Workstream

Reporting operations leadership

Jul 2016 – June 2025
  • Led a team of 2–4 analysts delivering approximately 130 scheduled and ad-hoc reports per month to BATB's central analytics function, regional managers and area managers.
  • Owned the full reporting lifecycle for BATB's CRM and sales force automation platform, from requirement gathering through delivery, covering sales, distribution, trade and campaign reporting.
  • Designed reusable Power Query report templates that converted recurring manual Excel production into paste-and-refresh outputs, reducing hands-on effort and enabling team-wide self-service.
  • Developed T-SQL queries against the CRM and transactional databases, handling datasets from hundreds to millions of rows.
  • Acted as the client's primary reporting point of contact, sustaining the engagement across a vendor transfer and eight subsequent years.

Workstream

Business intelligence modernisation

2021 – 2025
  • Introduced Power BI capability to BATB and delivered 10–12 dashboards covering sales, distribution and campaign analytics, moving the account from manual Excel output to interactive reporting.
  • Delivered BI work concurrently with reporting team leadership, contributing to two project teams simultaneously.

Client engagement

Arnott's Australia — Power BI delivery

2021 (3–4 months)
  • Joined the Apsis Power BI delivery team for Arnott's Australia P&L reporting, building 4–5 dashboards and authoring hundreds of time-intelligence DAX measures (LY, LM, LQ) with USERELATIONSHIP logic for heavily filtered multi-date models.

Client engagement

TOLL Australia — Power Platform automation

Sept – Dec 2025

Preceded by a self-directed month learning Power Automate (Aug 2025) before project start.

  • Primary builder on a two-person team re-engineering a failing UiPath user onboarding process into Power Automate, delivering five production automations across DEV, UAT and PROD environments.
  • Built unattended Power Automate Desktop RPA handling batches of up to 200 users per run, executing twice daily — Microsoft Entra ID provisioning via Graph API, Adobe licensing API, Active Directory security group and licence assignment (M365 F3/E5), and browser automation across three internal client portals.
  • Implemented input sanitisation, step-level validation and a dedicated error-handling subflow with automated ServiceNow ticket creation and stakeholder notification; the solution ran in production with no reported failures.
  • Developed the reverse offboarding automation to revoke access and licensing across the same systems.
  • Automated a daily licence cost allocation report reconciling employee data, active Microsoft licence inventory and annual pricing into department-level cost output, reducing production time to under 30 seconds.

Internal delivery support

Internal delivery support

2026
  • Supported internal ERP and CRM teams with SQL development and reporting; designed application UI and UX in Figma for internal products.

Earlier roles

Market Express Limited

Dhaka · Jul 2016 – Feb 2017

Reporting Officer

Established the reporting service for British American Tobacco Bangladesh. BATB subsequently consolidated the engagement under Apsis Solutions, the vendor operating its CRM platform, and the team transferred with the account.

K.S. International

Dhaka · 2014 – Jun 2016

Digital Media Developer

The Hub Ltd.

Dhaka · 2011 – 2014 · Part-time

Information Service Department Manager

03 / Proof points

95% → 91.9%

Independent SQL validation

Caught an on-time rate reading 95% instead of the correct 91.9% through independent SQL validation of every DAX measure.

48% mismatch

Arrival timestamp derivation

Adding elapsed minutes to departure time disagreed with the reported arrival on nearly half of all flights. Diagnosed to gate-to-gate local clock time and resolved without a timezone reference dataset.

41.8M rows · 0 failures

Unattended backfill

Seventy-one monthly periods loaded end to end in seven hours through a Fabric pipeline, with retries configured on every activity and none fired.

10+ min → 41s

SQL Server import

Cut a 98,000-row SQL Server import from 10+ minutes to 41 seconds by correcting column type declarations.

04 / Projects

Projects

Sales & Revenue Performance dashboard — Executive Overview page

Sales & Revenue Performance

Three pages tracking sales performance from an executive-level overview down to category and product detail, plus customer and payment patterns behind the revenue.

Power BIDAXT-SQL

View project→

Logistics & Delivery Performance dashboard — Executive Overview page

Logistics & Delivery Performance

An executive delivery overview backed by dedicated delay analysis and seller-and-freight breakdowns.

Power BIDAXT-SQL

View project→

Customer Experience & Satisfaction dashboard — Overview page

Customer Experience & Satisfaction

Three pages covering a satisfaction overview, the drivers behind it, and seller-level performance across the qualifying seller base.

Power BIDAXT-SQL

View project→

BTS on-time performance report

BTS Airline On-Time Performance — Fabric Lakehouse

A medallion-architecture lakehouse over 41.8 million US flight records — PySpark transformation, watermark-driven incremental loading, and a Direct Lake semantic model, with validation gates at every layer boundary.

Microsoft FabricPySparkData EngineeringDelta Lake

View project→

OpenSky Power BI report page: KPI cards, aircraft per 5 minutes, top origin countries and a table of airborne readings below -20 m/s

Live Aircraft Data — Fabric Real-Time Intelligence

Live OpenSky aircraft positions streamed through a Fabric Eventstream into an Eventhouse, analysed with KQL, shown on a Real-Time Dashboard and in a Power BI report on an imported snapshot, with an Activator rule on top. A streaming counterpart to the BTS batch lakehouse; the write-up states what failed and what was not verified.

Microsoft FabricReal-Time IntelligenceKQLPythonPower BI

View project→

Grid Shift overview for Bangladesh, dark theme — KPI cards and the generation-mix chart

Grid Shift — Fabric App

How Bangladesh's electricity is generated, and how it compares with South Asia and the world. A Fabric App (preview) over a Direct Lake semantic model.

Microsoft FabricDataflow Gen2T-SQLDirect LakeDAXFabric Apps (preview)

View project→

05 / Skills

Skills

BI and Analytics

Power BI DesktopPower BI ServiceDAXPower QueryAdvanced time intelligenceUSERELATIONSHIP and role-playing dimensionsExcelTableau

Microsoft Fabric

Dataflow Gen2Fabric Warehouse (T-SQL CTAS)Lakehouse and medallion architectureDirect Lake semantic modelsDelta LakePySparkData Factory pipelines and incremental loadingReal-Time Intelligence (Eventstream, Eventhouse)KQLActivatorFabric Apps (preview)TMDL and Fabric Git integration

Data and Databases

T-SQLSQL ServerMySQLStar and snowflake schema modellingStored proceduresViewsETL developmentPython and PySpark for data processing

Automation and RPA

Power Automate CloudPower Automate Desktop unattended RPAMicrosoft Graph APIREST API integrationBrowser automationUiPath to Power Automate migrationServiceNow integration

Identity and Cloud

Microsoft Entra ID user provisioningActive Directory group and licence managementMicrosoft 365 licensing (F3, E5)Secure credential vault integration

Design and Delivery

Dashboard UX and visual designFigmaRequirements gatheringStakeholder managementDEV/UAT/PROD deployment

Leadership

Team leadership (2–4 analysts)Client relationship managementMultinational stakeholder communication

07 / Contact

Contact

Currently open to new roles — Dhaka or remote.