Master Service Projection Report

• Use IS Reports to pull NAM Service Projection report. 
• Add new orders to unbilled orders tab and moved existing orders to billed tab if they have billed. 
• Pull Safir report ERS invoices closed and update closed orders with Invoice information, start/end dates, monthly revenue and cost treatment (defer or no deferral). 

VBS Oracle PO report & Gold Order Summary report

•    Use IS Reports to pull VBS Oracle PO report. 
•    Do a summary pivot with Gold order, FPC, PO entity, Bill currency, By currency, cost and revenue. 
•    Use IS reports to pull the Gold Order Summary report, which shows all NAM IS orders and their current status. 

Safir invoices closed and NAM credits

•   Use Safir invoice reporting module/dashboards/ERS Inv closed and Safir Ad hoc credit notes reports to analyze closed invoices & credits.   

Service Backlog Report

•   Update Service Backlog report with new orders >=$1K from previous week. 
•   Update comments on all orders based on information in Gold.

IS Revenue Deferrals, IS Credit Deferrals reports

•   Using the Service Projection report, determine any material (>$10K) VBS or Cobrand invoices that billed as one time charges but should have billed with a term. 
•   Add these invoices to the IS Revenue to defer report with correct start/end dates and update the associated amortizations schedule. 
•   Use the BIC report at month-end closing to capture any undeferred invoices not found during the month and ones that billed in the bill run.
•   Use the Safir Ad Hoc credits report and at month end, the BIC report, to find material credits that billed as one time charges and need to be deferred over a term.   
•   Add any   credits that need to be deferred to the NAM IS credit deferral file with correct start/end dates. Update amortization schedule for each credit. 
•   If a credit/rebill with for the same amount, fpc, term, then open an IT ticket to have the original invoices deferred revenue brought into the current month.

NAM FS Revenue Accruals, NAM IS Specific Credit note provision & BIC report (Software only & IS sub-reports)

•   After bill close, determine any material IS orders that did not bill, and calculate the revenue to accrue through the current month. Currently only making an accrual entry for Mastercard R24, H24 and H06 revenue that bills in arrears.
•   After bill close, determine any material IS credits that did not bill and add them to the Specific credit note provision file with the amount of credit to be taken through the current month.  Send file to Rich Lauterbach to make journal entry.
•   After bill close, pull NAM Sales and Marketing R283 report(xls file) from BIC.   

Oracle Cost of Sales Report

•   Check each Gold order on this report, against the Service Projection report to ensure that the costs and billing come through in same month. 
•   Deal with issues as needed where there are costs coming through with no invoicing or if an order has been invoiced, but the costs are not showing on this report.

VBS cost additions schedule, legacy amortization schedules and new IB Template amortization schedule

•   Based on current month VBS costs from Service Projection report and Oracle cost of Sales report. 
•   VBS additions schedule is used for the VBS cost additions journal entries. 

Software revenue &  cost deferrals Master file and Software revenue and cost final file 

•   Orders are added to this report from the BIC report. 
•   Any software orders >=$25K with software billing that was billed deferred or is needing to be deferred manually, are added to both of these software schedules with details of the order (gold number, customer name, IC01, FPC, BAN, vendor PO, cost and revenue mgt codes, start and end dates for the software service, revenue and cost information .   
•   The Master file has the amortization of the revenue converted to USD. 
•   The Final file has a tab for the invoices whose revenue needs to be deferred and another tab for the cost amortizations that are being done from costs coming through Oracle (legacy cost system).

IC01/BAN lists and Monthly FX rates (Equant Corporate rates)

•   Pull report from OBS MSBI Portal.  Use to look up information on BAN's/IC01's (customer name, management code, product/svc type, billing entity, billing periodicity.
•   Pull report from Plaza site (https://plazza.orange.com/groups/digitreasury-dft). Save to Teams folder.

ERS Backlog / Dashboard

•   Update ERS backlog report with previous weeks new orders and obtain updates on the current status and expected revenue recognition month. 
•   Take these updates and upate the "Weekly" report with the current backlog.  The "Weekly" report also has the pipeline and previous month's closed orders.

knowledge and abilities

• A proactive attitude toward accelerating transformation initiatives and driving new and existing processes

• Utilize statistical analysis techniques to help the sales leadership to project future business outcomes from the pipeline. 

• Ability to manage the orchestration of multiple key reporting deliverables in a cross functional environment.

• Understanding of business processes and ability to liase with stakeholders at all levels.

• Enthusiasm toward continued personal / professional development

• Strong communication skills

• Attention to details and quality driven

education, qualifications, and certifications

Desirable:

• Bachelors Degree 

Experience

• 5+ years Direct Business to Business Sales Experience in Global Markets

• 3 to 5 years Sales Operations or Sales Support Experience

behavioral skills

skill target proficiency level expected

Active Listening

Proficient

Relationship Building

Proficient

Influence & Persuasion

Advanced

Logical and Analytical Thinking

Advanced

Communication

Proficient

Time Management

Proficient

professional skills

skill target proficiency level expected

Global Effectiveness

Proficient

Customer Service Orientation

Proficient

Operational and Financial Excellence

Proficient

Knowledge and Development

Advanced

Teamworking and Networking

Advanced

Leadership and Matrix Management

Advanced

 Product Knowledge

Proficient

 Tools Aptitude 

Expert