Associate Consultant Resume

SUMMARY:

2+ years of progressive experience in the area of SAP BI and HANA.
Excellent communication, Presentation skills and Customer Oriented attitude.
Ability to work in a team environment.
Good communication, interpersonal skills and Self - motivator.
Ability to work in-group as well as independently with minimal supervision.
Ability to learn new languages and tools quickly.
Work with a professional spirit of teamwork and knowledge sharing.
Experience on HANA view creation i.e. Attribute view, Analytic view and Calculation view.
Knowledge in extraction through DXC, SLT and BODS.
Experience on Advance DSO, Composite Provider and Open ODS View.
Worked with input parameter, variable, calculated column, restricted column and hierarchy.
Hands-on Experience in Currency Conversion and Unit Conversion.
Experience on transporting object from SAP BW to SAP HANA Studio.
Worked on BI in Data Modelling, Extraction and Reporting.
Hands-on Experience in Data Loading of Master data and transactional data from SAP and Non SAP systems.
Experience in creation of info objects, DSO, Data sources, transformations, info package, DTP and designing of the info cube using BI Extended star schema.
Performance: Building aggregates, compressing requests on info cubes and free characteristic to improve the query performance.
Experience in process chain management, Monitoring and scheduling the batch jobs.
Experience in Generic Extraction and LO data Sources.
Created and Developed BI Queries Using BEx Analyzer and BEx Query Designer.
Extensively worked with calculated key figures, Conditions, Workbooks, exceptions, Conditions, Restricted Key figures, Filters, Structures, and Variables.
Knowledge in transporting objects within the landscape of the system.

TECHNICAL SKILLS:

ERP Packages: SAP R/3,SAP CRM,SAP SRM
OLAP Tools SAP BI 7.0, BW 7.3, BW 7.4, BW 7.5
Reporting Tools BEx Suite (Designer and Analyzer).
Languages Mysql.

PROFESSIONAL EXPERIENCE:

Confidential

Associate Consultant

Responsibilities:

Involved in installing Business Content and configured custom Infocubes, Info objects, DSOs, Transformations, Infopackages, and DTPs.
Involved in extracting data from Master and Transactional data from standard SAP R/3(FI extractors like General ledger accounting i.e. 0FI GL 10, Funds Management 0PU IS PS 44, 0PU IS PS 42 and 0PU IS PS 32), Flat File and NON-SAP source systems.
Involved in extracting data from SAP CRM, SAP SRM,SAP ECC using Generic data sources using views, infoset queries and function modules.
Data Source Enhancement according to client requirement.
Usage of ABAP Routines in Transformation.
Schedule data loads into BW from R/3,CRM and SRM involving Full, initial delta loads & delta loads
Scheduling and Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages
Involved in creating reports using BEX Query Designer with concepts of Calculated Key figures, Formulas, Restricted Key figures, Variables, Conditions & Exceptions.
Performance tuning of queries using aggregates, table partitioning, indexing and compression of Info Cubes and rollup of aggregates.

Confidential

Associate Consultant

Responsibilities:

Extracted data from SAP ECC R/3 to SAP HANA Studio using DXC.
Involved in the creation of HANA Information view i.e. Calculation view.
Involved in the creation of Composite Provider and Open ODS View in HANA studio.
Involved in flexible queries creation with variables, restricted column, and calculated column.
Created level hierarchy and parent-child hierarchy in SAP HANA studio to satisfy reporting requirement.
Worked on HANA security like Creation of User and Analytic Privileges.
Worked on HANA Transport, issue resolution and ticket handling.
Created report in BEX on top of SAP HANA calculation view using Transient provider.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship