Power BI Developer Portfolio

About Me

Professional Summary

Power BI Developer with 4.5+ years of specialized BI experience and 8+ years of overall IT background, delivering end-to-end reporting solutions for global clients across Retail, Real Estate, and CRM domains. Expert in DAX, Power Query (M), star-schema data modelling, and Row-Level Security (RLS). PL-300 certified, with hands-on experience building custom Power BI visuals using the Power BI Visuals SDK in VS Code. Distinctive UI/UX design background producing dashboards praised for clarity, usability, and executive-level impact. Proven track record integrating complex datasets from Microsoft Business Central, Dataverse, and SQL Server into actionable business intelligence that drives measurable decisions.

📍Dehradun, India

✉️pbi.naveenrawat@gmail.com

7+

Years of IT Experience

4+

Years BI Expertise

12+

Global Clients Served

4+

Domains Covered

Expertise

Core Competencies

📊

Visualisation

Power BI DesktopPower BI ServicePower BI Report BuilderPaginated Reports

💻

Custom Visual Development

Power BI Visuals SDKVisual StudioAI-assisted development toolsTime Intelligence Bar/Column VisualChatBot Visual

📐

DAX & M Language

Complex DAX measuresTime IntelligenceKPI DesignPower Query / MTabular Editor

🗄️

Data Modelling

Star SchemaSnowflake SchemaFact/Dimension TablesRelationshipsRow-Level Security (RLS)

🔗

Databases & Sources

Microsoft Business CentralDataverse (CRM)SQL ServerAzure SQLZoho API

🛠️

Supporting Tools

Excel (Power PivotPower Query)SharePointHTML/CSSFigmaCanvaAI-assisted DAX authoring

⚡

Other Technology

Power AutomateMicrosoft Copilot StudioPython (Basic)SQL Server

Career Journey

Professional Experience

Power BI Developer / Software Consultant

Cynoteck Technology Solutions

📍 Dehradun, India (On-Site)

Mar 2022 — Present

Delivering end-to-end Power BI solutions for global clients across multiple domains.

▸Delivered end-to-end Power BI solutions for 12+ global clients across Retail, Real Estate, CRM, and Finance domains, integrating data from Business Central, Dataverse, SQL Server, REST APIs, Zoho CRM, and flat files.
▸Designed scalable star-schema data models and developed advanced DAX measures to support complex business reporting requirements.
▸Designed pixel-perfect, UI/UX-informed report visuals and executive dashboards adopted across multi-user enterprise environments, consistently receiving client praise for clarity, interactivity, and usability.
▸Implemented dynamic and static Row-Level Security (RLS), ensuring secure, role-based access to sensitive business data.
▸Managed Power BI Service deployments, including scheduled refreshes, workspace administration, and deployment pipelines.
▸Collaborated directly with clients to gather requirements, define KPIs, and deliver analytics solutions using Agile methodologies.
▸Developed automation and AI-powered business solutions using Microsoft Power Automate and Microsoft Copilot Studio.
▸Built custom Power BI visuals using the Power BI Visuals SDK, including Time Intelligence and AI-powered chatbot visuals.

Digital Marketing Specialist

Tree Multisoft Solutions, Cynoteck Technology Solutions

📍 Dehradun, India (On-Site)

2018 — Mar 2022

Led paid media and digital marketing campaigns with data-driven optimisation.

▸Led paid media and digital marketing campaigns (Google Ads, Meta) with data-driven optimisation, managing budgets and client reporting.
▸Developed strong UI/UX sensibility and stakeholder communication skills through 5+ years of client-facing project management.
▸Built and managed cross-functional teams, balancing delivery timelines with quality output.

Portfolio