Abhishek L.

Abhishek L.

SAP BW HANA consultant with 5 years experience in BW, HANA and BW on HANA

Pune , India

Experience: 5 Years

Abhishek

Pune , India

SAP BW HANA consultant with 5 years experience in BW, HANA and BW on HANA

31200 USD / Year

  • Immediate: Available

5 Years

Now you can Instantly Chat with Abhishek!

About Me

  • Senior SAP professional with around 5+ year of experience in SAP BW , SAP Hana and SAP BW On HANA
  • Holds excellent interpersonal, communication and analytical skills with demonstrated abilities in customer relationship management...
  • Expertise in implementing complete Life-Cycle Implementation of SAP BW/BI, BW on HANA  and Native HANA which dealt with Blue Print, Realization, Data Modeling, Data Extraction, Data Loading (Full / Delta Up-loads), Scheduling, Monitoring, support packs implementation, BEx Analyzer, Query Designer, Web Applications Designer, Testing, Go Live & Production support, End user documentation
  • Extensively worked on FI-GL, LO Cockpit, Generic Data Source, DB Connect customization and extraction.
  • Experience on BW 7.4 and its new features like Hybrid Providers, Semantic Partitioning Objects, Advanced DSO, Composite Provider, HANA Views, HANA Optimized Cubes, ABAP for BW.
  • Experience in SAP HANA development, migration, optimization and support for mixed approach with Native and SAP BW on Hana solutions.
  • Create and Maintain Process Chain
  • Hands on experience in working on design studio creating dashboards using various components such as background Filters, cascading filters, Filter Panel, creating score cards using pop up window & apply flexible formatting using components such as images, hyperlinks etc.
  • Wide experience in interacting with end-users to gather and document the reporting requirements and giving training to the end users.
  • Identified and defined problems, evaluated alternatives and implemented effective solutions
  • Excellent analytical, time management, interpersonal skills and a good team player with excellent oral and written communication skills
  • Worked on BW Authorizations
  • Strong problem solving & Technical Skills coupled with confident decision making for enabling effective
  • Solutions leading to high customer satisfaction as well as low operational costs.
  • Expertise in SAP BW (Business Warehousing, BW Administration, BW Extractors, DSO, Info Cubes, Info Sources, Info Objects, SAP Design Studio and BEx Reporting), SAP Applications Integration with non-SAP systems.
  • Well verse with SAP HANA Modeling using Different types of views, SQL, SQL Script topics
  • SAP HANA Data provisioning using SAP Landscape Transformation and SAP Data services, DXC, Flat File Uploader, and SAP HANA Architecture.
  • Expertise in Back end Business Warehouse Components Extractors (LO Cockpit, Generic Extraction with in BW System, LIS and non R/3 extraction), Performance (Aggregates, BW Stats, Partitioning), Front end Business Warehouse Components Queries, Calculated key Figures, restricted key Figures, Structures, Variables.
  • Worked on BW on HANA implementation using LSA++ architecture data modeling principle
  • Worked on HANA models in BW like Composite Provider, Advanced DSO

Show More

Portfolio Projects

BW Implementation

Company

BW Implementation

Description

Involved in requirement Gathering, FS, TS, Designing of Info Cubes & DSO's • Build, Unit Testing, Defect Fixing as part of UAT, Handled Cutover activities, Hyper care Support • Providing KT for the Support Team • End-User Training • Application Areas: SD (Sales Orders, Contracts, Nominations), • MM (Inventory Management, Purchasing), FI (FI-GL, AR, AP, AA) • Loading of master/transactional data from flat file as well as from R/3 system • Installed, modified and managed Business Content DATASOURCES (Extract Structures) using RSA5 and RSA6 transactions • Prepared Technical Specifications from Functional Specifications • Developed LO customization, extracted structures and data sources in Sales Order management to facilitate the data extraction to BI enhanced the extract structures by adding new fields. • Set up periodic jobs for delta data uploads, statistics, aggregate and indices rebuild, and event chains to notify end user of report availability • Involved in managing of Info Cubes, Info Object maintenance, DSO Objects, PSA, Data source, Transformation, and DTP • Worked on development of New queries/Cubes/DSO's and extractors • Developing Local specific Process Chains and Meta Chains (RSRQ, RSPC, Event Collector, SM50, SM37, and RSMO) and Create new Info Packages in addition to Global. • Used BEx Query Designer as a Front End Tool to build Queries and Reports • Generated and analyzed reports using BEx Analyzer, Report Designer, and WAD designed and developed Process chains, Meta chain (RSPC) for master data load and transaction data load rocess chains were scheduled for periodic loads • Extensive usage of administration workbench (RSA1) • Data loading was monitored and failed data packets were analyzed if possible, manually edited in PSA and reloaded to DSO.

Show More Show Less

Tools

VPN

Native Implementation

Company

Native Implementation

Description

Accomplishments:

  • HANA Development done across all the business Areas for the BI Projects: Developed all Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules.
  • The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements.
  • Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
  • Setup Table Replication SLT for ECC and 3rd party table's real time into Hana. Data replication enhancements created for custom fields when required during replication.
  • Using data provisioning methods like SAP SLT for real time data and Business Object Data Services BODS non sap data Flat file upload and direct extraction connection DXC to acquire the data into SAP HANA Data Mart.
  • Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool.
  • Consumption of HANA information Models in BW by creating Composite and Transient Providers.
  • Developed multi-data source challenging reports by merging data from multiple Data Sources using Web Intelligence WEBI.

Show More Show Less

Skills

Hana SAP ABAP

Tools

Thimble

EMC

Company

EMC

Description

  • Accomplishments:
  • Involved in requirement Gathering, FS, TS, Designing of Info Cubes & DSO's
  •  Build, Unit Testing, Defect Fixing as part of UAT, Handled Cutover activities, Hyper care Support
  • Providing KT for the Support Team
  • End-User Training
  • Application Areas : SD (Sales Orders, Contracts, Nominations),
  •  MM (Inventory Management, Purchasing), FI (FI-GL, AR,AP,AA)
  • Loading of master/transactional data from flat file as well as from R/3 system
  • Installed, modified and managed Business Content DATASOURCES (Extract Structures) using RSA5 and RSA6 transactions
  • Prepared Technical Specifications from Functional Specifications
  • Developed LO customization, extracted structures and data sources in Sales Order management to facilitate the data extraction to BI enhanced the extract structures by adding new fields.
  • Set up periodic jobs for delta data uploads, statistics, aggregate and indices rebuild, and event chains to notify end user of report availability
  • Involved in managing of Info Cubes, Info Object maintenance, DSO Objects, PSA, Data source, Transformation, and DTP
  • Worked on development of New queries/Cubes/DSO's and extractors
  • Developing Local specific Process Chains and Meta Chains (RSRQ, RSPC, Event Collector, SM50, SM37, and RSMO) and Create new Info Packages in addition to Global.
  • Used BEx Query Designer as a Front End Tool to build Queries and Reports
  • Generated and analyzed reports using BEx Analyzer, Report Designer, and WAD designed and developed Process chains, Meta chain (RSPC) for master data load and transaction data load rocess chains were scheduled for periodic loads
  • Extensive usage of administration workbench (RSA1)
  • Data loading was monitored and failed data packets were analyzed if possible, manually edited in PSA and reloaded to DSO.

Show More Show Less

Tools

Thimble
Share:

Verifications

  • Profile Verified

  • Phone Verified

Preferred Language

  • English - Fluent

Available Timezones

  • Eastern Daylight [UTC -4]

  • Eastern European [UTC +2]

  • Eastern EST [UTC +3]

  • Greenwich Mean [UTC ±0]

  • Further EET [UTC +3]

  • Australian EDT [UTC +11]

  • Dubai [UTC +4]

  • New Delhi [UTC +5]

  • China (West) [UTC +6]

  • Singapore [UTC +7]

  • Hong Kong (East China) [UTC +8]