loading

  • Ranto Rakotonirainy

    SAP BW Consultant

Get started

Ranto
Rakotonirainy

SAP BW Consultant

My Profile

  • Name: Ranto Rakotonirainy
  • Date of birth: 21 June 1983
  • Nationality: French/Malagasy
  • Address: 28 Rue Bois Perron,
    FRANCE
  • Email: rrakoton@gmail.com
  • Phone: +33 650063578

Who am I?

I'm SAP BI consultant with 5 years of professional experience. I'm interested in all kinds of BI tools, but my major focus is on SAP BW Developpement.

I also have skills in other fields like, BPC, BO, QulickView, SSIS.

I am able to work individually as well as in a team with good communication skills.

Experience

×

My rewarding experience since my beginning in AtoS group

JULY 2015 -
Actual

AtoS / SAP BW - BPC Consultant

Customer :
  • ADP (Aéropot de Paris)
Context : ABAP, SAP BW 7.0 / 7.4 , Bex Analyzer, BPC

Modeling, extracting, transforming, and loading (ETL) data into data warehouse environment.
  • Using BADI to build an Input template as per user requirement to handle complex requirement
  • Reconfiguring the design by removing unnecessary dimension and accordingly to comply the changes in Reporting and logics
  • Debugging BADI and script logic
  • Maintain transformation, conversion file
  • Maintain custom APD to create files used to handle BPC hierarchy
  • Designed and developed OpenHub
  • Designed and developed custom BW extractor for BODI/BODS (Business Object Data Integrator / Services)
  • Designed and developed process chains (RSPC) for master data loads and transaction data loads with the help of DTP and these Process chains are scheduled for periodic loads.
  • Loaded Master and Transactional data from R/3 system and flat files into BW system.
  • Enhanced SAP Business Content to meet business requirements.
  • Developed Transfer Rule, Update Rule and User Exit with ABAP language.
  • Execute and control Pre-Post action in SAP BW migration (7.0 to 7.4)
JULY 2011 -
JUNE 2015

AtoS / SAP BW Consultant

Customers :
  • Renault - (10 months)
  • Third Party Application Maintenance (DGAC, BIOGARAN, La Poste, Renault) - (8 months)
  • GDF Suez - (2 Years and 6 months)
Context : ABAP, SAP-BW, BEX Analyzer, WAD (Web application designer), Integrated planning, Workbook, SAP Netweaver Portal

Modeling, extracting, transforming, and loading (ETL) data into data warehouse environment.
  • Daily Data load Monitoring of the BW jobs. Ensured successful daily data load from R/3 to BW.
  • Designed and developed process chains (RSPC) for master data loads and transaction data loads with the help of DTP and these Process chains are scheduled for periodic loads.
  • Loaded Master and Transactional data from R/3 system and flat files into BW system.
  • Found the gap between SAP Business Content and business requirement.
  • Developed Transfer Rule, Update Rule and User Exit with ABAP language.
  • Designed, developed and tested queries based on infoProvider with Bex.
  • Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Variables, custom User Exit. For customized reporting using BEx Analyzer, BEx Query Designer. Designed and developed several web reports using web templates in Web Application Designer.
  • Designed and developed OpenHub, APD for data extraction from BW infoproviders
  • Maintain SAP Netweaver Portal using System Administration, User Administration, Content Administration
  • Enhanced SAP Business Content to meet business
JANUARY 2011 -
JUNE 2011

AtoS / SSIS BI Consultant

Customer :
  • CNSA (Caisse Nationale de Solidarité pour l'Autonomie) - (6 months)
Context : SQL Server 2008 Enterprise Edition, SSIS, T-SQL, Windows Server 2003, Visual Studio 2008,Power AMC

Modeling, extracting, transforming, and loading (ETL) data into data warehouse environment.
  • Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
  • Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
  • Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Developed the SQL Server Integration Services (SSIS) packages to transform data from MS SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
  • Designed ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Handling SSIS Package Production deployment to export various package properties to make package environment independent, using the package configuration tool.
  • Acuiring extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.
  • Knowledge in Applications using SAP BI Integrated Planning (IP).

Education

×

6 years of study at Bordeaux 1 Sciences & Technologies University

Relevant Formations

  • SAP BW310 Enterprise Data Warehousing
  • SAP Bw330 Modeling & Implementation
  • SAP BW360 Operations and Performance
  • SAP BW370 Integrated Planning
  • SAP BO100 Business Object
  • SAP BPC420 Business planning and consolidation
JUNE 2010

Bordeaux 1 Sciences & Technologies University

Master’s degree in Business Applications  (MIAGE in French)

3 years Course

Bachelor Degree of Computing sciences

3 years Course

My Skills

×

I am absolutely passionate about BI tools

  • 0%

    ABAP

  • 0%

    SAP BW

  • 0%

    BPC

  • 0%

    BO

  • 0%

    SSIS

  • 0%

    SAP BW/IP

Contact Me

×

Get in touch via contact form or email me directly. I will get back to you as soon as possible.

Where to meet

28 Rue Bois Perron
LUGOS, 33830
France

Contact

Email:
Phone: +33 650063578

Google Maps