Alexander Bazanov Email & Phone Number

Christchurch, Nz

Moscow, Russian Federation

NORILSK NICKEL, 02.2016 –…, Enterprise Data Warehouse based on SAP BW on HANARole: Project architectResults:• Designed EDW-model for required functionality with HANA-specific objects (CV, aDSO, etc)• Designed cue functionality of the project – mapping machine with SAP DS + HANA• Designed visualization model of corporate layer with HANA specific• Designed and developed integration process IBM Cognos – SAP BW – SAP ERP for plan data• Created most common project documents (blue print, specifications, etc)GAZPROM NEFT, 08.2014 – 01.2016, Calculating of the company financial result based on SAP BWRole: Project architectResults:• Designed EDW-model for required functionality• Managed team work connected with base plan• Developed and controlled cue functionality of the project (extraction, input-ready forms, calculations)• Advised new functionality to make business processes more automatized• Created most common project documents (blue print, specifications, etc)

Moscow, Russian Federation

TATNEFT, 11.2013 - 01.2014, Monitoring and analysis of projects for capital construction based on SAP BW/BIRole: Team LeaderResults:• Formed project team• Designed base plan and controlled it to achieve project metrics• Managed team work connected with base plan• Designed and developed cue functionality of the project (status tracking system, block concepts, complex reporting forms with VBA)• Controlled development quality to achieve Client metricsEFES RUS, 10.2013 - 11.2013, Reporting CRM service orders (refrigerators service)Role: Team LeaderResults:• Collected and formalized reporting requirements.• Wrote and agreed specifications, as well as KPI calculation algorithms with the customer.• Analyze and substantiate the required changes in the current model of QCD.• Delivered and distributed the tasks among consultants.• Implemented a key part of the functional data extraction from SAP CRM, as well as sophisticated algorithms for KPI calculations.• Check the quality of work and compliance with customer requirements.GAZPROM ENERGOHOLDING, 06.2012 - 07.2013, Budgeting system based on SAP BI IPRole: Senior ConsultantResults:• Designed and developed all components for those budgets:• Planning and distribution of scenarios;o Budget for staff costs;o Budget for calculations and payment”;o BCF (Cash flow Budget);o Financial budget;• Collected all company budgets (about 30) in one workbook and optimized it’s performance• Designed and developed a lot of functionality of the project with ABAP, FOX, VBA.

Moscow, Russian Federation

GAZPROM, 10.2011 - 05.2012, Budgeting system based on SAP BI IPRole: Senior ConsultantResults:• Successfully designed and implemented a reporting unit for the implementation of liquid hydrocarbons on the basis of data from the SAP ERP (SD, FI modules) with formatting VBA.• Designed and implemented a universal mechanism for integration with other systems through SAP XI / PI with SAP BI IP capabilities (check received on relationships, data lock data).• Developed mechanism transmission guides to external systems.

Moscow, Russian Federation

M.VIDEO, 04.2011 - 09.2011, Development of the corporate reporting system based on SAP BI productsRole: Senior ConsultantResults:• Ensure full convergence of data between systems SAP HCM and SAP BI in terms of analytical reporting staff.• Finalize the model and the data flow of logistics for implementing the functionality of "trade balance" showing all the goods movement chain from procurement to sales (check).• Optimized data warehouse to speed up the download process and display the data in the reports.• Successfully implemented the pilot project "The opening of a new store" based on SAP BO products.• Ensure a smooth passage of the process of Due Diligence in part of reporting.

Moscow, Russian Federation

RUSAL, 08.2008 - 03.2011, Completion and support of existing solutions based on SAP BIRole: ConsultantResults:• Designed and implemented a comprehensive solution "Uniform exchange rates" based on Thomson Reuters source, providing timely and fully automated supply of currency in SAP BW and SAP ERP system on more than 100 currency pairs• Designed and implemented the ability to view real-time reporting data from SAP ERP with the possibility of adjusting the data "on the fly".• Designed and implemented a comprehensive solution for diversity payments for deliveries of products in the BEx Analyzer using VBA and SAP BI IP capabilities.• Implemented an innovative solution to provide users with offline-input forms to download and view the data in SAP BI without using SAP BEx, provided start-up of the decision and support of users (more than 300).• Developed decision "shipment planning" for sale with the possibility of adjusting the data in SAP BI and reporting with the formation of a fixed prostanovkoy signatories.• Bulk configuration and commissioning of the SAP Enterprise Portal operation, as well as integrating it with SAP BI system in terms of roles and accountability.• Productive involved in the processes of integration with SAP BI system Almer, 1C, OFA, MDM.• Developed a number of useful utilities / functions on VBA, ABAP, Web Dynpro.