Is Coe Business Serv Analyst

**Votre rôle**: **Mission / role purpose**: Contribute to business growth in the Americas IS business by developing, compelling and insightful business oriented analytics and reports. Through proven data visualization techniques identify gaps and opportunities to enhance the quality of business decisions made by management. Provide leadership and governance in managing and driving key Sales programs and initiatives in the Americas. - Establish and maintain interlock between Sales, Finance and International Business & Sales Operation - Drive adoption and utilization of digital tools and process to enhance the business - Partner with Sales to drive and advance the AME Strategy through sales tools and process (TML, Pipeline Management, CRM, Digital Selling, etc.) **RESPONSIBILITIES** **Activities** **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 BA