Андрій

Andriy Karpeshko
Power BI Developer / Data Analyst | Dynamics 365 F&O Developer

[open contact info](look above in the "contact info" section) | Mobile / Telegram: [open contact info](look above in the "contact info" section)
[open contact info](look above in the "contact info" section) | t.me/andrewww_txt
Expected compensation: USD 2,000+ / month

PROFILE
Power BI Developer and Dynamics 365 F&O Developer with 6 years of ERP development experience and 3
years building business intelligence solutions. Delivers BI solutions from requirements gathering and data
preparation to modeling, reporting, deployment, and support. Strong focus on financial analytics and
translating business needs into practical reports.

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

PROFESSIONAL EXPERIENCE

Dyneria | 2020 - 2026
D365 F&O Developer / Power BI Developer

• Developed, extended, and supported Dynamics 365 Finance & Operations solutions across ERP business
processes.
• Built Power BI dashboards, semantic models, and KPI reports using DAX, Power Query, and SQL.
• Managed the BI delivery cycle: requirements, data preparation, modeling, report development, deployment,
refresh configuration, testing, and support.
• Worked with D365 F&O, Business Central, CRM / Dataverse, Data Entities, REST/OData APIs, and data-lake /
Fabric / Synapse integration approaches.
• Created finance and management reports covering AP/AR, budgets, invoices, sales, procurement,
profitability, and cash flow.
• Combined development with stakeholder communication, troubleshooting, data validation, and ongoing
improvements in small teams.

EDUCATION
Ternopil Ivan Puluj National Technical University
Master's Degree in Cybersecurity

Andriy Karpeshko 1

SELECTED POWER BI PROJECTS

Sales & Margin Analytics Dashboard
Dynamics 365 F&O / Dynamics 365 CRM Integration

Developed a unified reporting solution for sales performance, customer activity, profitability, and operational
KPIs, combining ERP and CRM data.

• Revenue, cost, and margin analysis; customer profitability and product / item-group performance.
• Sales group and representative reporting; monthly trends and KPI tracking.
• Transaction-level detail for invoices and sales orders.
Technologies: Power BI, DAX, Power Query, SQL, Dynamics 365 F&O, Dynamics 365 CRM, Data Modeling

Vendor Invoice & Purchase Order Analytics Dashboard
Dynamics 365 F&O / Dynamics 365 CRM Reporting

Created a reporting solution for Finance and Operations teams, consolidating purchasing and sales data into a
management view.

• Open vendor invoice monitoring, total invoice amounts, and vendor performance.
• Purchase-order analysis with item-level detail.
• Sales-order reporting with costs, contribution margin, and financial KPIs.
Technologies: Power BI, DAX, Power Query, SQL, Dynamics 365 F&O, Dynamics 365 CRM, ERP Data

AP Aging & Budget Control Dashboard
Finance / Accounts Payable Analytics

Built an Accounts Payable reporting solution for overdue-risk monitoring and budget control, with Power
Query transformations, a star schema, and reusable DAX measures.

• AP KPIs: Total AP, Total Open, Total Paid, and 90+ overdue exposure.
• Department-level aging: Current, 1-30, 31-60, 61-90, and 90+ days.
• Actual vs Budget analysis with variance, variance %, and conditional formatting.
• Invoice-level filtering by department, vendor, payment status, and intercompany flag.
• Model: FactAP, Budget, DimDepartment, and DimAging; refreshable Power Query pipeline.
• Data-quality checks for duplicates, date and amount formats, blank departments, and inconsistent statuses.
Technologies: Power BI, DAX, Power Query, Excel, Star Schema, Financial Analytics, Dynamics 365 F&O

Andriy Karpeshko 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

Andriy Karpeshko 3