Position: .NET, SQL, ERP
Category: Other
English level: intermediate
Years of experience: 10

I have had number successful ERP projects. I have 1 successful project using Oracle 7.3 to develop billing system. 
Last 2 years I made ETL (Extract, Transform and Load) project for transportation prepared data from ERP to Microsoft Power BI.
Have some experience in .NET, MVC, Rest API.
Fragment FRD. (Solved)

General Information

Financial department has report Profit and Loss statements. It consists of:
 Revenues (Gross sales) - our sales
 Cost of Goods sold – cost of our sold goods
 Gross profit – subtotal of Revenues minus Cost of Goods sold
 ...
This report is not detailed by SKU. It based on report of sales that is detailed by:
Period (date), Project, Customer, SKU, Order number, Quantity, Sales summa, Summa cost of goods.
Financial department has report of overhead costs. Each cost is detailed by:
Period (date), Project, Cost name, Summa

Functional Requirements

We need to allocate overhead costs to SKU level. The cost allocation process should take into 
account the matching of project values in sales and overhead costs. Finally, we need to have report 
margin SKU. This report needs to have Period (date), Project, Customer, SKU, Order number, 
Quantity, Sales summa from sales report. Additionally, we need have columns:
1. Gross profit = Sales summa - Summa cost of goods.
2. Overhead Costs as result of allocation Overhead Costs to SKU level.
3. Profit = Gross profit - Overhead Costs.
Please, do not use any formal technical traps during the interview.