Hi,
Please find the below job description and if comfortable revert back with your updated resume to [email protected]. * Position : MS Access Expert* *Duration : 2 Months (Extendable)* *Location : Morristown NJ* *Job Description: * · 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 data warehouses 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 *Frank* *HMG America LLC * *Direct: *732-645-1607 E: *[email protected] <[email protected]>* W: www.hmgamerica.com -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/groups/opt_out.
