Tek04631

SAP - 9 yrs


Bachelor of Engineering

Highlights

  • Having 8.5 Years of (Development and Support) experience in SAP BWonHANA,BW4HANA, BW-IP, BO & ABAP, HANA, SAC, Power BI.



BI/BW Experience:




  • Strong data modeling, report design skills and Data extraction skills using BWon HANA 7.5 & BW4HANA, BW IP, BI 7.0 systems.

  • Uploading master data and Transactional data both from Non-SAP and SAP S/4,R/3 System, GTS and TM Systems.

  • Experience in ODP based extraction (Lo-Cockpit, Generic Extraction, FI Extraction, GTS data sources)

  • Worked on Generic Extraction using (function modules, views and tables) and Data Source Enhancements.

  • Involved as a team member in complete life cycle Implementation of BI 7.0 which includes Data Extraction, Data loading(full/delta), Scheduling, Monitoring, Info cubes, DSO, Multiprovider, process chains.

  • Involved as a team member in complete life cycle Implementation of BWon HANA 7.5 which includes ODP-Data Extraction, Data loading(full/delta), Scheduling, Monitoring, ADSO’s, Open ODS’s, Composite providers, calculation views, Streaming process chains.

  • Experience in creation of calculation views in HANA environment and access the views in BWon HANA environment.

  • Experience in SLT replication accessing the tables from different source systems and also experiencing of using SDI and SDA methodologies

  • Knowledge and experience with BW4WEB Cockpit and related objects creation.

  • Experience in creation of Routines and customer exits using AMDP’s and ABAP code.

  • Experience in creation of complex function module based extractors and Data source enhancements, good understanding in creation of ABAP CDS-Annotation based custom extractors in S/4 HANA.

  • Experience in creation of DTO, DAP, NLS in BWonHANA and BI environments.

  • Experience in BWon HANA system optimization project, which includes data flow optimization, data archiving, NLS (Near Line storage)

  • Worked on support projects, having experience in handling the tickets using Remedy/Incidents management tools, process chain monitoring, data recompilation and support related activates

  • Experience in handling the Daily/Weekly/Monthly support activities and generate/schedule the reports using Pre-cal server.

  • Experience in handling the team and lead the team

  • Experience in handling the business and client facing skills.

  • Experience in Integrated Planning (IP), Worked on ADSO, Composite Provider and aggregation Level Creation. Creation of planning key figures for forecast the outer years.

  • Experience in Creation of Planning Sequence and different Planning functions.

  • Taken the ownership of workbook models and make sure that reports are Input ready and available for business.

  • Worked with Analysis Office (AO), adding the reports to the AO and binding the planning functions to reports in the AO.

  • Experience in creation of Filters, variables, CKF, RKFs, Structures in Bex and also in HANA Eclipse.

  • Experience in working with different reporting tools like BO, SAC, PowerBI.



BO Experience:




  • Worked on Creation of Universe, SAP BO Design studio, Webi reports, Analysis reports and Crystal reports development.

  • Worked on Dashboards development, Webi reports and analysis reports using BEx queries.



BW Related ABAP Experience:




  • Worked on Star Routine, End Routine, Expert Routine, Lookups, Data source enhancement and functional modules using ABAP and AMDP’s

  • Having strong code debugging skills. ​



HANA Experience:




  • Good Knowledge in SAP HANA Modeling views (Attribute View, Analytic view, Calculation view) and Data Services (BODS, DXC,SDA,SLT).

  • Experience in creation of ADSO’s, Composite Provider in BW-HANA Environment.

  • Experience in creation of Calculation views, Analytic Views and Attribute Views as per the business requirement.



SAC Experience:




  • Experience in create different data models (Analytics/Planning, Acquired/Live, Embedded/Public)

  • Experience in getting data from different sources Including BW4HANA to SAC.

  • Experience in creating different kind of Stories using different models.

  • Experience in creating Planning scenario’s (What if analysis, Allocations, predictive forecast, Value driver tree, Collaborations)



Power BI Experience:




  • Experience in creating Power BI reports in Power BI desktop.

  • Experience in creating handling the Data in Power query (Transform)

  • Experience in creating Modeling view, Data View, Report view in Power BI Desktop.

  • Experience in Creating DAX (Data Analysis Expression).

  • Experience in working with Power BI services.



 


Skills
Primary Skills
  • BW4HANA
  • CONSULTANT
  • SAP BO
  • SAP BW

Secondary Skills
  • ABAP
  • CONSULTANT
Other Skills

 

  • SAP NetWeaver Business Warehouse (SAP BW)
  • SAP BusinessObjects
  • SAP ERP
Projects

BW HANA Maintenance and Support (20 months)

    Responsibilities:




    • As a BW module lead, I am handling the FCTL & AVENTICS business units for BW.

    •  I am responsible for run the business smoothly w.r.t BW Data loads and report execution daily.

    • I will take the ownership for handle the Team and divide the workload, handle the various P1/P2/P3 tickets on priority using Incident management.

    • Interact with clients/Business users and gather the business requirements for change requests and also for solving the Incidents and Tasks.

    • Handle the complex month end activities on every Fiscal period end.

    •  Monitored data loads which are running daily, weekly & monthly basis and solving errors when occurred.

    •  Add and Remove process chains during month end activities.

    • Daily take the planning area dump and compare with reports.

    • Error handling during daily data loads and sends the status mail to users daily.

    • Ensure that reports will be available to the end user in time.

    • Attend Daily, Weekly and Monthly Project meetings and explained the client about the Issues and other BW related activities.



     


BWoH Optimization/Migration (18 months)

    Responsibilities:




    • This Project all about dataflow optimization, data archiving process(DAP’s), handle the NLS (Near line storage) which all are useful to improve the system performance and reduce the cost to the business and also perform the migration from 3.x flow to 7.0 flow.

    • Get the memory size of all system objects using standard programs or run the SQL scripts to analyze the system.

    • Taking ownership for Pre-checks in production before doing data flow optimization, DAP’s, NLS.

    • Involved in determining the data flows optimization where we can remove the redundant flows and delete the obsolete objects. 

    • Taking the ownership of identifying time char’s to create the DAP’s where we can move the data from HANA system to Sy-base system to improve system performance and reduce the HANA IN memory.

    • Extensively worked on Query Builder objects viz. filters, Free Characteristics, Restricted Key Figures, calculated key figures, Variables, Customer exit.

    • Assign the NLS variable to each query and make sure that it is picking online (Warm data) or offline (Historical data) based on inputs which we provide.

    • Implemented on BADI’s, customer exits to make sure that NLS options works dynamically at runtime.

    • Actively involved in Debugging the BADI’s, Customer Exits and fix the issues as part of query execution.

    • Actively involved testing of NLS, DAP”S before Go-Live.

    • As part of Go-Live activity’s taking Pre, Post snapshots and time count.

    • Actively involved in data flow conversion from 3.x to 7.0 using RSMIGRATE T.code.

    • Create the Migration project for the data flows and perform the migration.

    • Actively involved in perform comparison activities like: Data source fields, Target object table fields, Routines, customer exits in Dev,Q and production system and make sure that all systems are in sync before migration.

    • Actively involved in Fixing the issues while migrating the data flows and objects.

    • Perform the consistency check of data flows, target objects and Process chains after migration in Q and Production systems and test the migrated flows with test data.

    • Taking the ownership to maintain the documentations project activities.

    • Attend the daily, weekly and monthly meetings to ensure that project should be in track as per delivery lines.


BWoH Optimization (20 months)

    Responsibilities:




    • This Project all about dataflow optimization, data archiving process(DAP’s), handle the NLS (Near line storage) which all are useful to improve the system performance and reduce the cost to the business.

    • Get the memory size of all system objects using standard programs or run the SQL scripts to analyze the system.

    • Taking ownership for Pre-checks in production before doing data flow optimization, DAP’s, NLS.

    • Involved in determining the data flows optimization where we can remove the redundant flows and delete the obsolete objects. 

    • Taking the ownership of identifying time char’s to create the DAP’s where we can move the data from HANA system to Sy-base system to improve system performance and reduce the HANA IN memory.

    • Extensively worked on Query Builder objects viz. filters, Free Characteristics, Restricted Key Figures, calculated key figures, Variables, Customer exit.

    • Assign the NLS variable to each query and make sure that it is picking online (Warm data) or offline (Historical data) based on inputs which we provide.

    • Implemented on BADI’s, customer exits to make sure that NLS options works dynamically at runtime.

    • Actively involved in Debugging the BADI’s, Customer Exits and fix the issues as part of query execution.

    • Actively involved testing of NLS, DAP”S before Go-Live

    • As part of Go-Live activity’s taking Pre, Post snapshots and time count.

    • Taking the ownership to maintain the documentations project activities.

    • Attend the daily, weekly and monthly meetings to ensure that project should be in track as per delivery lines.


Implementation (Integrated Planning) (15 months)

    Responsibilities:




    • Involved in determining the data flow for the business requirements extraction and reporting, and translated these requirements into BW-HANA Environment.

    • Worked on creation of ADSO, Composite Providers and Aggregation levels, Planning sequence and planning function.

    • Worked on creation of Calculation view, Analytic view and Attribute view.

    • Worked on BO Design studio to design the dashboards to see the output of HANA Views.

    • Extensively worked on input ready Query’s creation using HANA Eclipse and Bex.

    • Worked on adding the reports to the Analysis office and binding the planning function to the reports and make sure that the reports display the forecast data for outer years.

    • Taking the ownership and maintain the workbooks in the server.

    • Actively involved in business meetings and as per the business requirement change the reports for demo.

    • Involved in changes the development as per the changed request.

    • Worked on resolving data load issues, reporting issues and perform the unit testing.

    • Extensively worked on BEx Query Builder objects viz. filters, Free Characteristics, Restricted Key Figures, calculated key figures, Variables, Customer exit.

    • Attend the daily, weekly and monthly meetings to ensure that project should be in track as per delivery lines.


SAP BW Implementation (30 months)

    Responsibilities:




    • Involved in determining the data flow for the business requirements extraction and reporting, and translated these requirements into Dimensional Data Models in BW for Warehouse Implementation

    • Worked extensively on ECC and GTS environment to get the data from source system to BI using different delta mechanisms.

    • Extensively worked on GTS System to develop the Generic data sources based on FM, tables and views, handle the ABAP related issue and extractors issues independently.

    • Extensively worked on design of BI target objects like Info cubes, Multiprovider, Transformations, Data transfer process and Info packages according into business requirement.

    • Worked on routines development (Start routine, End routine, Export routine, Field level routine and lookup’s) to meet the business requirement.

    • Worked on Process chain development according into business requirement and trigger the jobs in development and quality system to test the data loads before the production move.

    • Worked on resolving data load issues, reporting issues and perform the unit testing

    • Extensively worked on BEx Query Builder objects viz. filters, Free Characteristics, Restricted Key Figures, calculated key figures, Variables, Customer exit.

    • Worked on BO (Universes, Webi and Analysis Reports) reports and Design studio dashboard development.

    • Worked transport management to collect and move the objects to the quality, production environment as per the sequence and compare the objects with development system.

    • Attend the daily, weekly and monthly meetings to ensure that project should be in track as per delivery lines.


SAP BW Viscor Product Development

    Responsibilities:




    • Involved in Client Demo’s major development activates as per their business requirements.   

    • Extensively worked on ECC data sources, Generic data sources based on table, View and Function Modules for uploading the data from ECC to SAP BW System using different delta mechanism.

    • Worked on Logistics Cockpit extractors setup table filling for transaction data sources and upload the data to BW side using V1, V2, V3 delta methods.

    • Worked on GTS Standard data sources, Generic data source development for upload the Import/Export, Compliance, SPL Embargo related info to BW side as per business requirements.

    • Merged both ECC and GTS data for the Demo as per the client requirements.

    • Extensively worked in the creation of BI objects like Info cubes, Multiprovider, Transformations, Data transfer process, Info packages, Open hubs,

    • Worked on ABAP code debugging and development of Start routine, End routine, Filed level routine, Lookup’s as per requirements.

    • Worked on several reports development as per the client requirement for the Demo and changed the Viscor existing reports and resolved several data loading and reporting issues.

    • Extensively worked on BEx Query Builder objects viz. filters, Free Characteristics, Restricted Key Figures, calculated key figures, Variables.

    •  Worked on BO (Webi and Analysis) reports and Design Studio Dashboard development using BW info providers and BEx querys.


SAP BW Support and Maintenance (6 months)

    Responsibilities:




    • Scheduled data loads to BW from SAP R/3(PRE, RRV, CRV) source systems.

    •  Monitored data loads which are running daily, weekly & monthly basis and solving errors when occurred.

    • Actively participate in offshore for the issues in production and close the incidents with appropriate Resolution in Remedy Tool

    •  Add and Remove process chains to meta chain every weekend and resolve the data load issues.

    • Solve usual problems with Process chain. Lock and Unlock the process chains during outage using Z-Tcodes

    • Resolved application issues with severity 1, 2 and 3 raised by user using Remedy Tool.

    • Answer first level of Tickets related with this Data loading activity.

    • Coordination and communication with the Source team, TWS team, Informatica team and onsite team.

    • Daily take the planning area dump and compare with reports.

    • Error handling during daily data loads and sends the status mail to users daily.

    • Ensure Week end and Monthly activities – Scheduling and rescheduling of process chains, filling of aggregates, compression of I.C, Housekeeping activities, Perform Reconciliation Reports, post manual actions after transports are imported.

    • Ensure that reports will be available to the end user in time.

    • Attend Daily, Weekly and Monthly Project meetings and explained the client about the Issues and other BW related activities.


Awards
N/A

Similar Talent

Key Skills - Self Rating

View

Key Skills - Self Rating
  • Ariba
  • SAP MM

View

Key Skills - Self Rating

View

Key Skills - Self Rating

View

Key Skills - Self Rating

View