Обязанности и достижения:
Optimizing financial business processes and financial business systems:
• Optimizing processes between OLAP and OLTP data systems in order to increase efficiency;
• Researching on innovations that can add value to the current FP&A processes;
• Establishing data warehouse in order to provide with smooth and efficient data flow between originating databases and Excel application;
• Managing various integrations between different originating sources (accounting source; forecast and consolidation source; revenue forecasting source; revenue pipeline opportunities source; project reporting source, etc.);
• Creating and managing proper reconciliations between systems by various dimensions: legal entity, department, natural account, project, subcontract, org structure level etc.;
• Reaching the various divisions in order to identify the currently established data flow processes, conducting business analytical tasks, establishing new processes in compliance with business needs;
• Creating functional requirements for the preparing of the automatic financial analyses systems on ERP;
• Creating manuals for the “revenue analyst” and “financial analyst” positions;
• Creating flowcharts for the various financial business processes in order to have one convenient source with the logic of business processes that is visually reflected and easy to understand (i.e. avoiding reading functional specifications/requirements in order to simplify and make the logic process easier for comprehending).
Performing and managing FP&A activities for the monthly, quarterly and year-end financial closing:
• Analysis of the direct labor calculation and allocation by function, by type of resource;
• Managing the gross margin reporting on ERP; calculation and analysis of the facilities overhead rates on the quarterly basis; analysis of the gross margin costs in different dimensions; on the quarterly basis creating in Power Point the bridge between gross margin at the GAAP level and gross margin at the managerial reporting level;
• Analyzing of the headcount month-to month changes, identifying the root cause of the major changes;
• Conducting the month end financial/managerial reporting meetings (act vs fcst): discussing and analyzing root causes of the variances between analyzed data based on accounting team inputs, providing the final reports to function owners and top-management;
• Analysis of the intercompany transactions (P&L and CF statements)
• Creating of the financial models for analysis and reporting of the financial positions from the managerial reporting stand point (SDN/NFV analysis (P&L and cash basis), etc.).
Business planning and analysis and presentations to Board of Directors and Executive Committee:
• Managing the process of the current period forecast preparation (revenue, expenses, cash flow); creating various techniques in order to make the process maximum efficient;
• Preparing planning reports and conducting the pre-executive committee meetings in order to identify the current forecast (for quarter, half, full year) and high-low case scenarios;
• Preparing (from the beginning to the end) on the monthly basis financial part of the ppt presentations for the executive committee and board of directors meetings. As parts of preparation: analyzing revenue, orders, operating profit risk ranking by type of revenue (Committed, Pipeline, Funnel), analysis of the cash flow, preparing various financial tables, charts according to the different financial structure dimensions (GAAP vs managerial reporting) people costs to revenue analysis, etc. Reviewing the slides with top-management, adjusting the slides in accordance with requirements, and preparing ad-hoc reports related to any questions raised during the review meeting.
Financial analyses of FX impacts, taxes, labor costs, etc.:
• Preparing FX impact analysis budget vs actual FX (average); creating the bridge between US GAAP and managerial reporting level results;
• Conducting HRIS Audit (i.e. internal controls of the Human Resource Information System) to ensure accuracy and consistency of the compensation plans data, providing the results to payroll and HR teams on the monthly basis;
• Preparing global facilities schedule and updating on the quarterly basis;
• Providing to tax accountants various analyses by projects for tax reporting procedures.
Budgeting, monitoring and analysis of business unit’s sales/costs:
• Updating cost reports for each department (over 85 departments), conducting the meetings with budget owners to keep track of the current forecast vs budget targets, providing ad hoc reports to budget owners;
• Deep dive analysis of the cost structure of the different departments and providing the results to the budget owners;
• Analysis of the Marketing, Marketing Strategy, Legal Departments costs and based on the analysis providing the results to the accounting team for the proper accruals;
• Revenue and orders reporting: preparing consolidated revenue booking report, act vs fcst reporting, participating in meeting with sales team in order to identify pipeline opportunities; preparing monthly committed + pipeline revenue forecasts.
Ad hoc reporting and market research:
• Preparing various ad hoc reports for the different departments (e.g. closely working with business profitability team in calculation labor cost rates; forecasting of the gross margin by customer based on the LOE from the resource plan and actual costs recognized by project);
• Managed Services implementation and deferred labor analyses;
• Market Telecom Industry researching.