Resume

Sign in

Data Sap

Location:
Toronto, Ontario, Canada
Posted:
March 28, 2019

Contact this candidate

Resume:

Sandhya Rani V

SAP HANA/BW/BO

ac8xow@r.postjobfree.com

Phone:647-***-****

Professional Summary

I am SAP Certified Consultant in HANA 2.0 SPS01 with 8 Years of experience in SAP BW, SAP HANA, SAP BW4HANA and SAP ABAP and BOBJ Focused on Implementation, Support, Enhancements, Migration and support package upgrade Projects.

Experience Summary

Involved in custom Enhancements of Standard data sources and Generic data sources.

Extraction of data from SAP-R/3 FI and LO data sources.

Schedule the data loads from and to SAP BW systems as per the business requirement Hands-on Expertise in BW including areas of Data Loading, Scheduling, Monitoring and Reporting.

Involved in importing the SAP BW objects to SAP HANA data base.

Expertise in the development of Info Cubes, Multi Providers, Data Store Objects (DSO), Transformations and DTP’s.

Involved in maintenance and creation of SAP BW objects as per user requirements Expertise in writing Start Routines and Transformation routines using ABAP Code based on client requirements.

Expertise in the development of Info Cubes, Multi Providers, Data Store Objects (DSO), Transformations and DTP’s.

Involved in the migration of BW 7.X to BW 7.5 using Side car Scenarios.

Converted Native BW models to HANA optimized models.

Experience in automating loads using process chains and use of BW Monitor to data loading

Expertise in LO data extraction(SD,FI) mechanisms,FI Extractions and Generic Extractions.

Extensively worked in Datawarehousing Work Bench for defining Info Objects, Info Cubes, Multi providers, Info source, Aggregates, DSO objects, Info sets and Transformations .

Scheduled and monitored periodic data loads from SAP R/3 to BI

Good Exposure on LO extraction and Generic extractions

Woked on Roles and Authorisations for users .

Worked on SAP upgradation Activities on Production system.

worked on SAP BO (Webi) .

Extensive worked on SAP ECC on process and data flow within SAP FI,SD,PP and PM

Involved in replacing standard objects using the Advanced data store object leveraging the SAP HANA capabilities

Expertise with BI reporting using BEx Analyzer, BEx Explorer and implementing BEx

Queries, Calculated and Restricted Key figures, variables and workbooks

Involved in Production support for BEx and WEBI reports

Involved in the modification of Webi reports as per the user requirement

Worked on Debugging issues in BW for data mismatch issues in BEx.

Expertise in working with column views, Database view and Information views in Native

SAP HANA Environment.

Good understanding of all the options of SAP HANA In-Memory computing studio.

Data Provisioning (File to HANA, BW to HANA, ECC to HANA, SQL to HANA)

SLT Configuration from ECC to HANA

Involved on Creating HANA objects: Attribute Views, Analytic Views, Calculation Views, Analytical Privileges

knowledge of SAP HANA Architecture, In Memory Computing

Good understanding of Virtual Data Models and types, SAP HANA Live Browser and Decision Tables.

Involved in extracting the data from BODS,SLT and Smart Data Access.

Involved in working on with the Data base tables both the Column store and Row store Involved in the mixed scenarios consuming BW models in SAP HANA and Leveraging SAP HANA modelling advantages in BW

Created Analytical Privileges and Procedures for modelling

Experienced in Developing Reports and Customizing reports using Alerts, Breaks, and Filters and Sorts etc.

Experienced in Developing various Charts, Graphs and drill down reports.

Experienced in creating reports using Web Intelligence, schedule the reports as per the business needs and supporting.

Experienced in Creating Charts with Value-based alerts and setting up Drill down in charts using Crystal Xcelsius.

Worked on creating conditions, filters, ranking in Webi reports.

Knowledege on S/4 HANA system.

TECHNICAL SKILLS

SAP Certified Application Associate with SAP HANA 2.0 SPS01 (C_HANAIMP_13)

SAP HANA 2.0 SPS 01

SAP BW4HANA

SAP BW 7.5 on HANA

SAP BW 7.3

SAP BW 3.X

SAP BO 4.1

SAP BW ABAP

EDUCATION QUALIFICATION:

Bachelor of Technology in Mechanical Engineering NBKR IST in 2008

PROFESSIONAL SAP EXPERIENCE

BELL(CGI)- IFRS 15

Role : SAP BI /HANA Consultant

Aug 2017 – Nov 2018

Involved in the Field Enhancement at the source system side for standard data sources

In depth technical experience in all areas of SAP BW/BI implementation in Extraction, Modelling and Reporting.

Expertise in data extraction from flat files, and SAP R/3(SD/PP) using extract structures such as LO-Cockpit and Generic Data extraction.

Expertise in modelling & Designing of Cubes, DSO, Info sets, Multi-providers, transient providers, Composite providers, Open ODS views, ADSO and Semantically partitioned objects.

Experience in report generation. Worked extensively on BEX Analyzer in building Queries using Filters, Variables, Structures, Restricted Key Figures, Calculated Key Figures, Conditions and Exceptions.

Scheduled and monitored periodic data loads from SAP R/3 to BI

Good Exposure on LO extraction and Generic extractions

Woked on Roles and Authorisations for users .

Worked on SAP BW 7.5 data modelling like composite providers, Transient providers, Open ODS Views.

Worked on SAP upgradation Activities on Production system.

Designed SAP BW on HANA Composite Provider as semantic layer using BW on HANA Modelling tools in HANA Studio.

Expertise in Creating database Procedures and Script based Calculation views using SAP HANA Programming languages like SQL Script.

Knowledge on BW/4HANA Modelling for ADSO and Open ODS, Extraction and loading of data S/4 HANA.

Generated SAP HANA Analytic Views for standard DSO’s in HANA and used them in calculations Views

Good knowledge on SAP HANA Architecture, In Memory Computing

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

Loading Data into the SAP HANA Database using Data Provisioning( SLT, BODS and Bringing Data from ECC, Oracle and Flat files)

Involved in creating decision tables using return values and update values and performed calculation using function provided by HANA.

Generate time data in SAP HANA and Transport management.

Involved in Unit testing, Integration Testing, User acceptance testing etc.

Overview, Row store and column store, Persistence layer in IMCE, Backup & recovery and database connectivity options

Design SAP HANA data model information Views for report consumption with time dimensions.

Develop SQL scripts and functions for complex reusable scenarios in HANA.

Created HANA database users, role, analytical privileges for data and data model security.

Native HANA MODELLING - Designing Views (Attribute View, Analytic View, Calculation View), Stacked Calculation Views, Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters.

Good understanding of all the options of SAP HANA In-Memory computing studio.

Good Knowledge on Data Acquisition into SAP HANA using Business Objects - Data Services, System Landscape Transformation.

Prokarma Softech Pvt Ltd

Role : SAP BI/HANA Consultant

Nov 2014 – July 2016.

Worked on SAP upgradation Activities on Production system.

Loading Data into the SAP HANA Database using Data Provisioning( SLT, BODS and DXC. Bringing Data from ECC, Oracle and Flat files)

Involved in creating decision tables using return values and update values and performed calculation using function provided by HANA.

Good Knowledge on Data Acquisition into SAP HANA using Business Objects - Data Services, System Landscape Transformation, DXC Extraction and Smart Data Access.

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

Creating Analytic privileges and assign to user

Generate time data in SAP HANA and Transport management.

Creating Data store between Source and target system, Data base creation, repository creation, Job server, Project, Workflow, Data flow, Jobs.

Overview, Row store and column store, Persistence layer in IMCE, Backup & recovery and database connectivity options

Good understanding of all the options of SAP HANA In-Memory computing studio.

Involved in enhancement of Standard Master and Transaction Data sources. Worked on developing report for QM, PM, PS and Purchasing.

Involved in developing Info Objects, DSOs, Info cubes and Multi Providers as in the process of delivering the reports

Involved in creation of Generic Data sources using Function modules and Views

Involved in writing Start, End and Field level routines

Created Processes Chains to automate the process of loading data into data targets Involved in the migration of BW 7.X to BW 7.4.

Involved in remodeling of persistence Info providers and virtual Info providers

Involved in writing the codes at Start routine, Field Level Routine and End Routine.

Fujitsu Consulting India Pvt Ltd

Role : SAP BI/BW Consultant

Mar-2011 – Sep 2014.

Involved in Installing Business content cubes and DSO from BI content for all SD and

FI Modules based on requirements.

Migration of data source from 3.x data flow to 7.0 flows using with export and without export.

Extracted data from SAP ECC and Non-SAP systems (Via Flat file)

Designed and developed DSO’s and Cubes for standard sources from ECC. Created

Transformations.

Formatted the reports as per the client’s needs with inclusion of new columns.

Improved performance by implementing indexes, Aggregates and Repartitioning of

Cubes.

Worked with Bex Analyzer in building queries and defining rows, columns and free characteristics, providing drill-downs, worked with Restricted Key Figures, Calculated Key Figures, Formulas, Conditions, Exceptions, Variables and Structures.

Interacted with Business Users and Business Analysts to gather the requirements and

Business Logic.

Worked on Start Routine, End Routine. Involved in debugging of Routines.

Good knowledge on internal table operations.

Involved in creation of custom queries and defined calculated key figures, restricted key figures, variables with different processing types, filters, selections and structures Involved in enhancing the Data sources

Involved in installing Technical Content and customized queries as per users requirement Involved in extensive testing of newly created objects by doing unit testing, Integration testing

Involved in writing Variable Exits for BEx reports Involved in Testing in Sandbox and QA systems Involved in Transport mechanism.

Involved in writing Start, End and Field level routine.



Contact this candidate