Position:MS Access Expert
Location:Morristown NJ
Duration:6+ Weeks
Data extracts
· Data extract is at invoice level from Jan 2010 to YTD for US-CAN and EMEA and comprises of multiple fields including invoice fields, customer database, product database
· Mapping of invoice level data to master table in Access DB
· Entire process can be automated with a live ODBC link from Access DB to the datawarehouses in US-CAN and EMEA
· The other data extract is current pricing (customer/product level) with surcharges which are combined with the invoice data
Reporting functionality
· There are several queries and filters in Access DB which helps me pick the filters dynamically and slice the data. Some of the reporting functionality include
o Snapshot analysis based on time period
o Price index plots
o Plotting capability(trending)
o YOY analysis, etc
Advanced analytics/ simulations
· Pricing simulations (ability to change price and see impact)
· Margin bridge analysis
· Pricing index
--
Thanks & Regards
Gary
HMG America LLC
PH: 732-645-2086
E:Gary@hmgamerica.com
http://www.hmgamerica.com/
--
The Most Active and Happening ERP/SAP Jobs Listserve for SAP Jobs in the US.
https://groups.google.com/group/itjobs-usa
Follow us on Twitter: https://twitter.com/SAPbuddy
Post your Jobs at SAP JOBS USA Linkedin Group by clicking this link
https://www.linkedin.com/groups/SAP-JobsUSA-4081187/about
Join our Professionals Networks in Linkedin
https://www.linkedin.com/groups/SAP-JobsUSA-4081187/about
https://www.linkedin.com/groups/Global-Network-SAP-Professionals-4081179/about
https://www.linkedin.com/groups/Network-SAP-Professionals-3874920/about
http://finance.groups.yahoo.com/group/SAPJobs-USA/
---
You received this message because you are subscribed to the Google Groups "SAP JOBS USA" group.
Visit this group at http://groups.google.com/group/SAPjobs-USA?hl=en.
No comments:
Post a Comment