Implementation of actual data management reporting (performance and P&L) and planning system on the basis of IBM Cognos Express (TM1+BI). Developed planning and management reporting system consist of:

• Subsystem to report and store recorded consultants work hours, accounting company revenue and expenses data by persons, departments and business units, customers, projects, labour types. Functionality to support calculation of standard hour cost. Functionality to support allocation of labour costs related to internal projects, sales and presales and studying between business units based on personal hours. Functionality for absorption cost variance calculation with allocation capabilities.
• Subsystem to plan on-going projects and opportunities in terms of revenue, expenses and labour cost based on employees and subcontractors hours spent. Resources planning analysis and review by roles and names, projects, customers, departments and business units.

Different types of plan-fact reporting including P&L by business units, projects and customers. Rolling forecast reports.
Integration with existing DW by means of Turbo Integrator processes to synchronized dimensions and actual data uploading.

IBM Cognos Express (TM1+BI) project.
Implemented TM1 functionality includes planning / budgeting subsystems and actual business data collection on a daily and monthly basis for seven different companies by means of Turbo Integrator chores from Corporate Data Warehouse. Planning and budgeting subsystems for each company provide the ability to create unlimited number of plans and budgets.
Planning system supports such features as rolling type planning with twelve months horizon and new versions of plan entry, multiple business lines PFO, production and procurements plans verification and synchronization between companies for intercompany products, intercompany eliminations, direct and absorption cost methods with and without intercompany eliminations. Data Warehouse has been designed and implemented to collect actual data with different levels of details from numerous heterogeneous business systems by means of ETL chores.
TI chores have been designed and implemented for further actual data transfer from DW into TM1 cubes which are storing pre-aggregated actual data for management and P&L reporting at TM1.
Different user interfaces have been designed by means of TM1 Web, Cognos Insight, Cognos Query and Report Studios to meet different user role’s requirements in consolidation reporting, "plan-fact" analysis and "what-if" simulations from TM1 cubes and DW tables.

IBM Cognos Express (TM1+BI) project.
Cash flow planning and budgeting on yearly and monthly basis by departments. Support of amendments requests for departmental expenditures to transfer budget amounts between expense accounts and departments with on-line interactive control of quarter budgeted limits. Actual expenses data uploads from accounting system by means of Turbo Integrator processes. "Plan-fact" analysis and control by means of different reports and views.

Daily sales and expenses collection and consolidation from numerous heterogeneous business systems by means of automatic regular batch processes. Different user interfaces (web, Excel) provide users with the capability to create their own reports and analysis, including "plan-fact" variance reports and analysis, without IT requests.
Planning and budgeting parts of the system give the ability to have unlimited number of plans and budgets, operational and strategic planning within one system.
What-if scenarios within manufacturing planning subsystem provides the ability to consider different sales forecasts, BOM’s and optimize yearly and monthly raw materials procurement plans.
What-if scenarios planning within meat import business allow to optimize the ratio between quotable and non-quotable items.
Business lines profitability planning and budgeting functionality allows to estimate product margins and their contribution in business line profit while "plan-fact" analysis allow to see how and why actual operations are not meeting the planned ones.

System supports two cycles of sales forecasts for the future fashion season based on statistical data from similar previous seasons. First cycle allows to plan on patterns level while the second one details the sales forecasts for the approved patterns to the levels of size, color, customer / channel and region.
System supports two types of sales forecasts - yearly with month’s scale and quarterly with week’s scale.
Interfaces to synchronize data directories with legacy system and data upload have been provided.

Data interfaces to transfer daily sales and expenses data from each company ERP system Dynamics NAV into TM1 database on a daily basis or/and under request.
Consolidated and cost variance reporting. Consolidated and companies P&L’s and Balance Sheets.
Brands profitability reporting. Expenses analysis by departments and types. Planning and budgeting with "what-if" scenarios.

Rolling forecasts, planning and budgeting with "what-if" scenarios. Data warehousing and CIS consolidation reporting with "plan-fact" variance analysis.

Implemented functionality within GMCS implementation project of IBM Cognos TM1 planning and budgeting system for energetic company OGK-4.
Development of the functionality for dynamic assignment of user’s rights allowing and denying data access as an addition to the standard workflow budgeting process. Development of the subsystem for the expenses gathering by the sources of their incurrence.

Planning and budgeting by brands, companies and departments. Actual business data uploads from SAP R/3, 4th Shift and SCALA by means of TM1 processing worksheets.
System provided functionality included FSU data consolidation in different currencies and GAAP adjustments to convert statutory reports to Gillette intercompany reporting standards to be submitted to HQ in London.
Functionality to support conversion of item’s statutory production cost into item’s intercompany production cost.

Sales, AR, Purchasing, AP, Inventory , Accounting and Controlling accounting, Manufacturing including multi-level BOM’s and Machine Centers, MRP and MPS.

Sales, AR, Purchasing, AP, Inventory , Russian Accounting, Controlling accounting.
Customization and new functionality developed to meet veterinary legislation and to implement logistics management with payment scheduling following logistic events.

Hotel sales & AR, Bars & restaurants sales & AR, Inventory, Purchasing & AP, Production accounting, Russian accounting, Controlling accounting, Multicurrency, Fixed Assets.

Sales, AR, Purchasing, AP, Inventory , Russian Accounting, Controlling accounting, Fixed Assets, Cable-to-Promise manufacturing, Customer Relationship Management (CRM).

Sales, AR, Purchasing, AP, Inventory , Russian Accounting, Controlling accounting, Companies consolidation and reporting, Fixed Assets, Payroll. Integration with MS Access.