Naveen Rawat

Microsoft PL-300 certified Power BI Developer with 4.5+ years of specialised Business Intelligence experience and 7.8+ years of overall professional background. Proven track record delivering end-to-end Power BI reporting solutions — including data modelling, DAX development, ETL pipeline design, Row-Level Security implementation, and Power BI Service deployment — for 12+ global enterprise clients across Retail, Real Estate, Banking, and CRM domains. Adept at translating complex business requirements into scalable, insight-driven reporting ecosystems that replace manual processes and empower data-driven decision-making.

Additional experience developing Microsoft Copilot Studio chat and voice (IVR) agents integrated with Dataverse and REST APIs.

Power BI Developer / Software Consultant at Cynoteck Technology Solutions (2021-03 – Present)

• Owned end-to-end Power BI reporting delivery for 12+ global enterprise clients across Retail, Real Estate, Banking, and CRM sectors, managing the full project lifecycle from requirements gathering through to production deployment.
• Developed interactive Power BI dashboards and reports using DAX, star-schema data models, and enterprise data sources including Microsoft Business Central, Dataverse, SQL Server, REST APIs, and Zoho API, enabling stakeholders to monitor KPIs and make data-driven decisions across multiple business functions.
• Authored complex DAX measures including time intelligence calculations, dynamic segmentation, running totals, and calculated columns to support advanced analytical requirements across 5+ business units per client engagement.
• Designed and optimised star-schema and composite data models incorporating Fact and Dimension tables, DirectQuery and Import Mode connections, and relationship management using Tabular Editor to maintain report performance at enterprise scale.
• Implemented dynamic and static Row-Level Security (RLS) across multi-user Power BI environments, enforcing role-based data access governance for sensitive financial, CRM, and operational datasets.
• Configured and managed Power BI Service workspaces including report publishing, workspace permissions, scheduled data refresh, deployment pipelines, and gateway configuration to ensure near-real-time data availability for business stakeholders.
• Built ETL pipelines using Power Query (M Language) to extract, profile, clean, and transform raw data from multiple enterprise sources, replacing manual Excel-based reporting for 8+ client teams.
• Led client requirements workshops, translating ambiguous business needs into technical design documents covering data model specifications, ETL processes, KPI definitions, and visualisation requirements, consistently delivered within Agile sprint timescales.
• Developed three fully custom Power BI visuals using the Power BI Visuals SDK in Visual Studio, including a Time Intelligence visual, NextGent Table Visual and a ChatBot visual for natural-language data queries, eliminating the requirement for third-party visual licences.
• Supported 3 client engagements involving Microsoft Copilot Studio, deploying chat and voice (IVR) agents integrated with Dataverse and REST APIs as additional project scope alongside primary Power BI delivery responsibilities.

Digital Marketing Specialist at Tree Multisoft Solutions / Cynoteck (2018 – 2021-03)

• Managed paid digital advertising campaigns across Google Ads and Meta platforms, overseeing monthly budgets up to INR 5 Lakhs and producing weekly performance reports that informed client marketing strategy.
• Grew client acquisition by 30% year-on-year through data-driven audience segmentation, campaign analysis, and A/B testing across 10+ concurrent client accounts.
• Coordinated cross-functional teams of 4 to 6 members to deliver concurrent multi-client projects on schedule, building stakeholder communication and project management skills directly applicable to current BI delivery engagements.

Master of Business Administration in Marketing Management – Swami Vivekanand Subharti University, Meerut (2024-04)

Bachelor of Arts in Economics – Hemvati Nandan Bahuguna Garhwal University (HNBGU) (2016)

Diploma in Computer Science and Engineering in Computer Science and Engineering – Government Polytechnic, Dehradun (2012)