Pricing Data Analyst in Vietnam for 3 months

Project status
Project start date
15 Oct 2018
Project posted
1 Oct 2018 23:33
Project duration (approx.)
3 Months
Budget (approx.)
US$200 / day
Level of Experience
Area of expertise
Data Analytics
Consultant location
Vietnamese (Essential) , English (Nice to have)

Objectives and Key Deliverables

A) To develop a Business Intelligence repository to capture price, all cost types & sales volume movements
B) To develop Interim pricing solution for pricing data modelling, pricing process automation supported through central pricing repository

Pricing department of our Company wants to analyze the trend of price, cost (Current, F, FF) & sales volume across continuous period of the past years and going forward, broken down in months at a SKU/BoM level comprising all the relevant details pertaining this specific sector, Loading scale etc.

For this purpose, it is proposed to maintain above information in Business Intelligence database (OLAP), wherein complete breakdown of Sector wise / Product / BOM wise details of Price, Volume, Cost (Current, F, FF) is maintained.

Below is the high-level scope of work
1) To understand the report & dashboard requirements of Pricing Department
2) Document the requirement & get the same approved from Pricing Department
3) Develop system design document & get it signed off from Pricing Department
4) Develop scripts to extract the required data from JD Edwards
5) Develop data marts to store the data in Oracle Business Intelligence repository
6) Develop reports and dashboards as per user requirements
7) Perform unit testing to confirm new developments are as per business requirements
8) Organize User Acceptance Testing to get sign off on the new developments
9) Deploy the new developments to Business Intelligence Production
10) Create repository of historical data of price, cost & sales volume

Currently all of the Ad-Hoc pricing and regular price requisitions are performed outside of the system as a manual activity. The Methodology incorporated is refined and can be easily automated through simple technology solutions. This immensely supports in reduced Turnaround Time, focus on accuracy and Revenue optimization.

Available actions

You must have an account to be able to apply for projects.

Register as a consultant

Already have an account? Log in

Looking for a consultant?

Post a project and have consultants apply

Post a project

About Talmix

Talmix is an online market place for consultants to connect with clients for projects such as market research, due diligence, competitive analysis, strategic business planning, and organisational reviews.

  • 35,000+ consultants
  • 150+ countries
  • 100+ sectors
Why Talmix >