1993-1998

University: Moscow State University of food production
Faculty: Cybernetics and Automation
Specialization: Atomized Control Systems
Diploma: HR Corporate Information System
Certificate: Referent/translator of English

2000-2007

Approx.20-25 Information Technologies Courses in SAP, Microsoft and Oracle: SAP/R3, BW, Integrated Planning (BI 7.0), BPS, SEM, MS SQL Server 2000, MS OLAP, MS .NET, Microsoft and SAP integration, DCOM Connector, Oracle 9i, Business Objects.

Self education and practice in BCS, FI, BSP and some other modules.

03/2008 - now

Company: Megapolis (retail of tobacco, bear et cetera; via SAP Russia)

Basic tasks:

• IP (Integrated planning), BW and ERP extraction usage for realization of the budgeting, planning and consolidation purposes;
• Analytics, development, consulting, architectural tasks;
• Most important task is preparation of the Cash flow reporting by payment date on the base of FM module extended by date of payments via ABAP;
• Evaluation of BPC planning, reporting and consolidation.

Stage:

•  Realization phase.

10/2010 – 05/2011

Company: Aeroflot (Russian biggest Aero Company)

Basic technology components:

• BW;
• BO; 
• Xcelsius

Stage:

•  Realization phase.

07/2010 – 06/2011

Company: Gazprom (state Russian Gas Company)

Basic tasks:

• Team leadership for the conceptual design and later realization of about 150-200 analytical reports in SAP/BI;
• Data is mostly loaded from ERP and other source systems should also be integrated;
• Reports are supposed to be built in BEX;
• For planning purposes IP is going to be used.

Stage:

•  Conceptual design phase.

10/2007 - 04/2008

Company: HCFB (Home Credit and Finance Bank)

Basic tasks:

• Transformation of reporting in RAP (Russian Accounting Principles) to IFRS (International Financial Reporting Standards);
• Allocations of Expenses to Profit Centers and additional Analytics;
• Preparation of a reporting pack of  50 flexible reports;

Technology used:

• SAP/BI-BW 7.0 for the core data warehouse which gathers, clarifies and stores all the data appropriate for the tasks described above;
• SAP/BI-IP (Integrated Planning) and BPS for realization of transformations and allocations on the Pilot stage. BPS is chosen by the client due to stronger reliability;
• SAP/BI-BEX 7.0 and 3.5 for the reporting purposes;

Achievements:

• System architecture is built flexibly and extendable;
• Most of transformations are developed;
• Allocations are formalized and the methodic is adjusted for better flexibility in setup and support. The system setup is done and demonstrated to the Client;
• The package of flexible reports is developed in BEX on the basis of transformed to IFRS and Allocated data;
• Data is uploaded to BW and transformed in an appropriate way from SAP/ERP-FI-CO and 3 bank Systems.

06/2007 - 02/2008

BW 7.0 и 3.5 projects for the following respectable Clients (done simultaneously; help in difficult tasks):

• ZEPPELIN (Caterpillar dealer), Formula holding (alcohol distribution in Krasnoyarsk area), TRAKT (work clothes), Tops BI (IT company).

09/2007-12/2007

Company: Orenburgenergy

• Extension of the previous project dealing with SEM/CPM-MC development and implementation. Development of data model in BW, data staging in ERP and BW, KPI calculation in BEX, presentation level on SEM/CPM-MC, presentation of BCS from the presale aspect.

05/2007-09/2007

Company: Moscow Energy Company 

• Project extension: SAP/BI (BW, SEM-BPS) senior freelance consulting (remote with meetings and short business trips) with Net Weaver 7.0. Uploading data from SAP/ERP-PS into BW, planning investments in BPS, analyzing plan/fact and other KPIs in BEX.
• Prototyping of BCS.

04/2006-06/2007

Company: Formula (wine trading holding) via IDS Sheer (Consulting)
Position: Remote Freelance IT Consultant / Contractor

Projects, roles and responsibilities:

• SAP/BI (BW, SEM-BPS) senior freelance consulting (remote with meetings and short business trips) with SAP All in One Solution (SAP/BW 3.5) for a wine distribution Company. Involved into all major aspects of Development and Implementation process: Analyses of requirements and activation of appropriate R3 (SD, MM, FI, FM) extractors, BW and BPS business content; development of the necessary user-exits in ABAP, formulas in FOX et cetera.

12/2006-04/2007

Company: for Moscow Energy Company via MRCB (Consulting)
Position: Remote Freelance IT Consultant / Contractor

Projects, roles and responsibilities:

• SAP/BI (BW, SEM-BPS, CPM) senior freelance consulting (remote with meetings and short business trips) with Net Weaver 7.0. Uploading data from SAP/ERP-PS into BW, planning investments in BPS, analyzing plan/fact and other KPIs in BEX.
• Delivering a course of BW and BPS for 7-10 SAP consultants.

07/2006-11/2007

Company: MAY Company
Position: Freelance IT Consultant / Contractor

Projects, roles and responsibilities:

• Management of a Budgeting model development with Microsoft technology. Overheads allocation to SKUs, KPI calculations et cetera. SAP presale. 

09/2005-03/2006

Company: Abbott Labs
Position: Freelance IT Consultant / Contractor

Projects, roles and responsibilities:

• Manager and Analytic of a Project dealing with Development of a Client-Server IS for Patient cards registration and analysis, Medicine hand over, Medical treatment et cetera. The Information System is developed with SQL Server 2000 as back end and MS Access XP as front end. The basic part of the Project is finished by now.
• Manager of the Project dealing with network installation in a Medical Center.
• Developer of a Medical Information System in MS Access XP.

01/2004-08/2005

Company: OVO Twinings UK
Position: Freelance IT Consultant / Contractor

Projects, roles and responsibilities:

• Business Unit Planning Model (BUMP) development & implementation. The system is based upon MS Access XP/2000 and SQL Server 2000. The system consists of several 'first level' modules (Volume, Cost of Sales, Pricing, Deductions, Distribution costs, Consumer A&P, Trade Investment, Operation Expenses) and the recalculated analytical modules of Profit & Loss and Ratio analysis. There are about 70 reports, 30 input forms, 100 transactional and classification tables. Forecasting and Planning is done on the 13 period a year basis. The system is tightly integrated with MS Excel. You can find more info about the system and my work on the web sight. Integration with external Systems.

08/2001-12/2003

Company: Coca-Cola Vienna Group
Position: Freelance IT Consultant / Contractor

Projects, roles and responsibilities:

• Continues Planning Model (CPM) development for the Company Group office in Vienna. The System is now used in production on a single Server in Vienna. It gathers information from 30 countries reporting to Vienna office and has more than 100 users in 20 countries. The functionality greatly reminds BUMP described earlier in this document. Integration with external Systems including SAP ERP, BW and SEM/BPS.

08/2000-08/2001

Company: Coca-Cola Bahrain Division
Position: Freelance IT Consultant / Contractor

Projects, roles and responsibilities:

• Continues Planning Model (CPM) development for the Company Division office in Bahrain. The System is now used in production. It gathers information from 10 countries reporting to Bahrain office and has more than 30 users in 5 countries (Bahrain, Egypt, Lebanon, Pakistan, UAE). The functionality reminds BUMP described earlier in this document. For more information please apply to my web sight.

09/1999-07/2000

Company: Coca-Cola Russia (bottling business)
Position: Freelance IT Consultant / Contractor

Projects, roles and responsibilities:

• Installation of the System on approx.15 plants in Russia, consolidating module in Moscow, organization of the approval process.
• Addition of the Profit and Loss (calculated from bottom to top), Balance Sheet and Cash Flow modules to the integrated System.
• Integration of the modules described below. Development of an integrated data module with unique classificatory, referential integrity et cetera. Development of a common Interface for all modules and cross functional reports. Development of data import from other Systems (SCALA and some others).

09/1998-08/1999

Company: Coca-Cola Russia (concentrate business)
Position: Freelance IT Consultant / Contractor

Projects, roles and responsibilities:

• Developer of several Information Systems (IS) on MS Access: Marketing; Operating Expenses; Pricing; Deductions; Sales; Inventory Information System in MS Access.

10.1997-11.2001

Company: Nicholson International  (UK HR agency)
Position: Freelance IT Consultant / Contractor
Projects, roles and responsibilities:

• Analyst and Developer of HR Grading Information and HR Candidate Information Systems in MS Access.

01/2004-12/2007

Company: LUKOIL-INFORM (IT Outsourcing Company of Oil Company JSC LUKOIL).

Transition explanation: JSC LUKOIL decided to organize a Global IT Outsourcing Company on the base of LUKOIL-INFORM and moved the Information Technology department there.
Position: Chief specialist.

Projects, roles and responsibilities:

• Functional and technical team leadership in the Corporate Information Warehouse Project for JSC LUKOIL. The System is based upon SAP/BW & SEM and is gathering data from more than 300 Company affiliates and subsidiaries. Depending on the project stage there are from 5 to 10 employees reporting to me directly and about 15 indirect helpers from other projects connected to this one (Corporate classification system or Transactional systems delivering data). There are about 300 info-objects, 150 info-cubes, 50 transactional info-sources, 100 master data info-sources, 150 reports developed according to decomposed to info-objects reports.

• Manager and Analytic in the Project dealing with an IS development for the Oil Product Delivery Companies. The IS deals with data collection from 10 Companies, integration with Transactional Information Systems and a Corporate Codification System. Besides Project Management I’m responsible for complex calculation algorithms and flexible reporting formalization. The IS is programmed by an internal LUKOIL-INFORM team with Oracle 9i and Business Objects. There are about 5-7 programmers reporting to me in this Project.
• Controller in the Project dealing with BCS implementation in LUKOIL-Overseas. Interviewed the subcontractors, the Client, checked project decisions and setups in the system from the IT Company Head office standpoint.

02/2001-01/2004

Company: JSC LUKOIL (Global Russian Oil Company)

Position: Chief specialist

Projects, roles and responsibilities:

• Head of the development group and a developer in the Project dealing with Analytical System for the Company top management. The System was developed on SAP/BW, SEM/BPS, BCS and SEM/CPM. The System was supposed to gather data from more than 100 Company affiliates and subsidiaries and present in to the users in the Corporate Center. There were from 2 to 5 employees reporting to me. We developed about 100 info-objects, 50 info-cubes, 2 management cockpits (4 walls, 20 views, and 40 frames), 70 internal and external reports. We successfully finished test usage during two months on 4 plans by 15 info-areas (Upstream, Sales, Production, Finance et cetera).
• Senior Analytic in the Project dialing with restructuring of the existing operational reporting data. Revision of more than 250 reports from different business areas. Definition of info-objects in reports in terms of SAP/BW. Development of a Base Key Figure catalog defining information which should be gathered from the Company affiliates and subsidiaries. Definition of a Key Performance Indicators on the base of the Base Key Figure catalog.
• Developer of an Info-Objects Catalog and Data models (responsible for Architecture of the Solution).

10/1998-02/2001

Company: JSC LUKOIL (Global Russian Oil Company)

Position: Leading specialist

Projects, roles and responsibilities:

• ABAP developer in SAP/R3 for different modules (MM, SD, FI). Development of new and correcting of standard data extractors from R3 to BW. There were about 50 reports, 5 transactions, 30 extractors for BW developed by me. I also broadened the accounts corresponding complex for the RAP (Russian Accounting Principles).
• Developer of an analytical Investment module on MS Access.

Name

Organization

Position

e-mail

Anna Shavikina

+79175337223

TOPS BI

Finance manager

ashavykina@topsbi.ru

David Oakley

+447976606220

Twinings UK

Finance controller UK (not SAP but functionally and English)

David.Oakley@twinings.com

Danila Pravotorov

+7(495)7618196

Bearing Point

Manager (BW, SEM projects)

danila_pro@yahoo.com

Alexander Lopatin

+7(916)6051817

LUKOIL

Head of an organizational unit

alopatin@lukoil.com

Alexei Nevzorov

+7(916)6039816

LUKOIL-Inform

SAP/BI senior consultant

anevzorov@lukoil.com