Андрій

Andriy Karpeshko
Power BI Data Analyst | Dynamics 365 F&O / Business Central Specialist | Business Analyst
Expected compensation: USD 2,000+ / month

PROFILE SUMMARY
Power BI Data Analyst and Dynamics 365 specialist with 6 years of hands-on experience in Microsoft Dynamics 365 Finance &
Operations and 3 years developing Business Intelligence solutions. Strong background in ERP processes, financial analytics,
and end-to-end BI delivery - from requirements and data preparation to semantic modeling, dashboard development,
deployment, refresh, and support.
Experienced with Power BI, DAX, Power Query, SQL, Power BI Service, star-schema models, Row-Level Security,
scheduled/incremental refresh, Dataverse, Dynamics 365 integrations, and financial reporting across AP/AR, budget vs actual,
margin, P&L, and cash flow.

CORE SKILLS
Power BI & Modeling: Power BI Desktop / Service; DAX; Power Data & Integration: SQL / MS SQL Server; D365 F&O Data
Query (M); semantic models; star schema; relationships; Entities; Business Central REST API pages/queries; Dynamics
measures; calculated columns; KPI dashboards; drill-through; 365 CRM / Dataverse; Fabric / Synapse Link; OData / REST
slicers; conditional formatting. API.
Security & Deployment: Dynamic RLS; ERP & Business Processes: Finance; Sales; Procurement;
USERPRINCIPALNAME(); workspace roles; Power BI Service Inventory; Warehouse; CRM; requirements analysis; stakeholder
deployment; scheduled refresh; incremental refresh; dataflows; communication; testing and support.
Import / DirectQuery. Power Platform & Excel: Power Apps; Power Automate; SSRS;
Financial Analytics: AP/AR; aging; budget vs actual; P&L; cash Excel Power Query; PivotTables; data quality checks and
flow; margin / profitability; vendor and invoice analytics. reconciliation.

PROFESSIONAL EXPERIENCE
Microsoft Dynamics 365 F&O Developer / Power BI Developer
6 years of experience developing, extending, and supporting Microsoft Dynamics 365 Finance & Operations solutions and ERP
business processes.
3 years of experience creating Power BI dashboards, semantic models, KPI reporting, and analytical solutions using DAX, Power
Query, and SQL.
Delivered full-cycle BI work: requirements gathering, data preparation, modeling, report development, deployment, refresh
configuration, testing, and ongoing support.
Worked with D365 F&O, Business Central, CRM / Dataverse, Data Entities, REST/OData APIs, and data-lake/Fabric/Synapse
integration approaches.
Built finance and management reporting for AP/AR, invoices, budgets, profitability, margin, P&L, cash flow, sales, procurement, and
operations.
Worked independently in small teams, combining development, stakeholder communication, troubleshooting, validation, and
business-focused improvements.

EDUCATION
Ternopil Ivan Puluj National Technical University - Master's Degree in Cybersecurity (Higher Education)
Target positions: Power BI Data Analyst • BI Analyst • Power BI Developer • Dynamics 365 BI Consultant • ERP Data Analyst •
Dynamics 365 Business Analyst

1

SELECTED POWER BI PROJECTS
Project 1 - Sales & Margin Analytics Dashboard
Dynamics 365 F&O / Dynamics 365 CRM Integration
Developed a Power BI analytics solution for monitoring sales performance, profitability, customer activity, and operational KPIs.
The report combines ERP and CRM data to give management a unified view of revenue, cost, margin, customer profitability, and
sales performance.
Key features
Revenue and cost analysis with margin tracking.
Customer profitability and product / item-group performance.
Sales group and sales representative analysis.
Monthly performance trends and KPI monitoring.
Detailed transactional analysis for invoices and sales orders.
Technologies: Power BI, DAX, Power Query, SQL, Dynamics 365 F&O, Dynamics 365 CRM, Data Modeling

Project 2 - Vendor Invoice & Purchase Order Analytics Dashboard
Dynamics 365 F&O / Dynamics 365 CRM Reporting Solution
Created a BI solution for Finance and Operations teams to analyze vendor invoices, purchase orders, sales orders, costs, and
profitability indicators. The model consolidates purchasing and sales data into a practical management view.
Key features
Open vendor invoice monitoring and total invoice amount.
Purchase-order analysis with item-level details.
Sales-order reporting with cost and contribution margin.
Financial KPI monitoring and vendor performance analysis.
Integration of Dynamics 365 F&O and CRM reporting data.
Technologies: Power BI, DAX, Power Query, SQL, Dynamics 365 F&O, Dynamics 365 CRM, ERP Data

Project 3 - AP Aging & Budget Control Dashboard
Finance / Accounts Payable Analytics
Built a Power BI solution for Accounts Payable analysis, overdue-risk monitoring, and budget control. Source data was cleaned
in Power Query and modeled in a star schema with reusable DAX measures and interactive report pages.
Key features
AP KPIs: Total AP, Total Open, Total Paid, and 90+ overdue exposure.
Department-level aging across Current, 1-30, 31-60, 61-90, and 90+ buckets.
Actual vs Budget reporting with variance, variance %, and conditional formatting.
Filterable invoice-level detail by Department, Vendor, Payment Status, and Intercompany flag.
Star schema with FactAP, Budget, DimDepartment, and DimAging; refreshable Power Query pipeline.
Data-quality controls for duplicates, mixed date/amount formats, blank departments, and inconsistent status values.
Technologies: Power BI, DAX, Power Query, Excel, Star Schema, Financial Analytics, Dynamics 365 F&O

2

POWER BI PORTFOLIO EXAMPLES

TARGET POSITIONS
Power BI Data Analyst • BI Analyst • Power BI Developer • Dynamics 365 BI Consultant • ERP Data Analyst • Dynamics 365
Business Analyst

3