Prasad Kore

Independently built an end-to-end finance analytics pipeline in Microsoft Fabric, ingesting customer and transaction data from SQL Server into a Lakehouse via Dataflow Gen2. Modeled relationships and created a semantic model for finance KPIs, then configured a daily refresh pipeline and built reports for finance leadership.

Independently built a Microsoft Fabric pipeline for Meta ad performance analytics, ingesting MSSQL Server data into a Lakehouse via Dataflow Gen2. Published Power BI reports and created a reusable semantic model for consistent business measures.

Designed and shipped Power BI dashboards for email marketing analytics, including measures that reduced decision-making time by 25%. Reworked ETL in Power Query and built DAX time-intelligence measures (MTD, QTD, YTD), and implemented row-level security with business users.

Turned business requirements into Power BI reports on ISP performance and revenue, including forecasting models for financial planning. Built reusable reporting logic using DirectQuery and Import modes across SQL, Excel, and other sources.

Built server cost and performance dashboards with DAX-driven profit and loss tracking to support cost decisions and resource planning.

Handled documentation, vendor checklists, server cost records, and order/return processes, and built HTML/CSS email campaigns for clients. Ran email campaigns, A/B testing, and deliverability audits using segmented data to improve conversion rates.

Set up and administered Linux systems and email infrastructure to support reliable email delivery, including domains, DNS, and IP warmup.

Completed the Microsoft Learn self-paced Microsoft Fabric Analytics Engineer learning path covering Lakehouse architecture, Medallion architecture, Dataflow Gen2, Pipelines, and Power BI semantic modeling.

Earned a B.E. in Information Technology from Pune University in Pune.