Nisanthan Sivarajah-BI Consultant
Check rate
Experience
Business Intelligence Consultant (freelance)
NBIC – Nisanthan BI Consulting
Advising companies on building, migrating and optimising BI and reporting landscapes (Power BI, SQL, Python, ETL)
5 client engagements in real estate and finance since 05/2025: taking over and stabilising existing reporting, automating recurring standard and management reports, building cash-flow models
Proposal and feasibility assessments for BI and reporting projects
Using AI-assisted development (Claude Code) to accelerate automation, tooling and web/app development
Custom ERP system
Problem: A client's core processes ran on scattered, siloed Excel files with no central data storage – error-prone, hard to scale and impossible to analyse end-to-end.
Approach: Captured the business processes and requirements, modelled the data and developed iteratively together with the business team.
Implementation: Built a tailored, web-based ERP system with a central database, role-based modules and automated reporting – delivered using AI-assisted development in Claude Code.
Timesheet app
Starting point: Time tracking based on an overgrown, macro-heavy Excel template – maintenance-intensive, single-user and error-prone.
Implementation: Migrated all functionality and VBA macros into a standalone web app with central data storage, multi-user support and automated reporting.
Cash-flow modelling
Starting point: The existing cash-flow model covered standing investments only; project developments were missing from steering.
Implementation: Built and extended the CF model to include project-development cash flows.
Optimisation: Reviewed and optimised existing CF models and expanded the KPI outputs for reporting and steering.
Director BI / Operations
Hines Immobilien GmbH
- Owned development and operation of company-wide reporting for a real-estate portfolio of
50 properties (€4bn portfolio value) - Automated around 20 recurring reports, cutting manual effort by 70–80%
- Managed onboarding and continuous enhancement of the BiSon.Box real-estate planning software (~30 users, 20 assets)
- Designed comprehensive portfolio dashboards in Excel/VBA and Power BI for executive reporting
- Built ESG dashboards in Power BI integrating Alasco data; co-developed a CapEx planning tool
- Optimised complex cash-flow models for strategic planning and investment analysis
- Developed tools for time tracking, compliance checks and cross-portfolio leasing tracking
- German lead and point of contact for PRODA, Hines' globally rolled-out asset-management dashboard (~150 users, ~50 assets)
- Supported the migration from on-premises Windows servers to a modern cloud infrastructure
Senior Financial Controller
Round Hill Capital
- Developed a liquidation / valuation tool to support analysis of new investment opportunities
- Monitored and analysed cash flows across multiple investment platforms
- Created a lease tracker to improve transparency in portfolio controlling
Senior Asset Management Analyst
JLL Retail Asset Management (formerly Acrest Property Group)
- Led a reporting team of 2, responsible for all asset-management reporting incl. strategic initiatives
- Rolled out the BISon.Box real-estate planning software for
15 assets (€2bn) and ~15 users - Established standardised reporting structures and automation solutions for efficiency and data consistency
Asset Management Analyst
ACREST Property Group GmbH (JLL)
- Established standardised reporting structures and implemented automation solutions
- Data visualisation in Excel
Internship Asset Management
ACREST Property Group GmbH (JLL)
- Developed an FTE calculation model for new projects based on KPI-driven inputs
- Prepared and delivered reporting for Asset Management and Acquisitions teams
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Real Estate and Banking and Finance.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Business Intelligence, Finance, Information Technology, Operations, Sustainability Management, and Project Management.
Summary
Business Intelligence consultant with 10+ years of experience at the intersection of real estate, finance and data analytics. Specialised in Power BI, reporting automation and the design of scalable dashboard and ETL solutions. Combines deep domain and process know-how with modern, AI-assisted development – to turn data into reliable decisions.
Skills
It Skills
- Excel / Vba
- Power Bi / Dax
- Power Query / Etl
- Power Automate
- Sql
- Python
Tools & Platforms
- Microsoft Fabric
- Azure
- Power Apps
- Alasco
- Ai-Assisted Development
Core Skills
- Power Bi / Dax
- Excel / Vba
- Power Query / Etl
- Power Automate
- Sql
- Python
Platforms, Tools & Methods
- Microsoft Azure
- Azure Sql
- Azure Data Lake
- Power Bi
- Power Apps
- Power Automate
- Sharepoint
- Teams
- Microsoft 365
- Pandas
- Dax
- Power Query (M)
- Sql / T-Sql
- Postgresql
- Vba
- Claude Code
- Claude Cowork
- Ai-Assisted Development
- Prompt Engineering
- Git
- Github
- Html / Css
- Markdown
- Node.Js
- Data Modeling
- Star Schema
- Reporting Automation
- Dashboard Design
- Esg Reporting
- Capex Planning
- Cash-Flow Modelling
- Alasco
- Bison.Box
Languages
Education
Aristotle University of Thessaloniki
Civil Engineering · Greece
Bauhaus-University Weimar
M.Sc. · Building and Real Estate Management · Weimar, Germany
Bauhaus-University Weimar
B.Sc. · Building and Real Estate Management · Weimar, Germany
Certifications & licenses
Power BI Desktop Data Modeling and Reporting
Confex Training GmbH
Statistics
Experience
Global Experience
Expertise
Qualifications
Profile
Frequently asked questions
Have questions? Find more information here.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Business Intelligence Consultant (freelance)
Nearby freelancers
Professionals working in or nearby Berlin, Germany
