Previous Job
Sales - Sales Operations Analyst
Ref No.: 17-01030
Location: San Jose, California
Start Date / End Date: 04/24/2017 to 07/07/2017
Excel Support
• Advanced to Expert level in Excel, with enough system knowledge to quickly learn how to run reports independently
• Ideal candidate will be very comfortable with large data sets, know how to make comparisons between them (pivots and vlookups), and how to efficiently aggregate multiple source files into one consolidated file, etc.
Tasks they will be supporting:
• Run and modify reports for Weekly forecast report prep (backlog&shipment ). Export from SFDC to Excel.
• Maintenance of a Master Zip code lookup table
• Moving compensation data from one file and format to another
• Ad hoc reporting. 5 quarter history by territory,or VAR, etc.
• Quota baseline scrubbing against exception lists and flags
• Running POS reports and sorting by Region or Rep