Tek06777

SAP - 11 yrs


N/A

Highlights

  • 11+ years of experience on SAP BI/BW, SAP BW powered by HANA, Enterprise HANA and SAP BO implementation, support and maintenance Projects. Good knowledge in understanding the R/3 System and considerable experience in BI Development. 

  • Understanding the functional requirement and preparing the technical designs covering technical specifications of objects, pseudo code and code flow.

  • Extensively involved in preparing the Cut over plan and activities, Project progress trackers, GO-LIVE plans.

  • Extensively involved in importing SAP BA and HANA objects to higher landscapes and Hypercare support.

  • Experience in creating unit test cases and preparing test case logs

  • Extensively involved in supporting different testing phases I.e. Unit testing, cross functional testing, UAT testing

  • Experienced and supported in implementation and support project, which includes Modeling, Extraction, scheduling and monitoring the data.

  • Extensively involved in creating BW and BW4HANA objects Master data objects, DSO, Infocube, Multi Providers, Infoset, ADSO’s and Composite providers.

  • Extensively worked on flattening the Balanced and Unbalanced BW hierarchies into level wise flat structure.

  • Extensivley worked on pushing the SAP BW data into Anaplan system to planning purpose using Open Hub tables.

  • Extensively involved in creating a BEx Report where Calculated Key Figure, Restricted Key Figure and Used Variables with various variable processing types.

  • Sound knowledge in ABAP, extensively involved in creating complex and medium complex end routines.

  • Experience in creating AMDP based routines.

  • Experience in creating ABAP CDS view based extractors.

  • Experienced in OLTP extraction from SAP R/3 into BW using different extraction structures such as FICO, LO-Cockpit configuration and customization, HR and Generic Extractors, Project systems.

  • Experience in enhancing the standard and generic datasouces.

  • Worked on Currency translation in transformation and BEx query level.

  • Extensively involved in creating calculation views in HANA and stored procedure to push the data to table.

  • Extensively involved in creating calculated columns, Restricted columns, Input parameter and scalar function to improve the reporting performance.

  • Experience in data pruning technique while sourcing the data from multiple sources to improve the reporting performance.

  • Experience in creating input farms using SAP BW IP module.

  • Experience in creating AO and Web Intelligence reports.


Skills
Primary Skills
  • SAP
  • BW4HANA
  • Embedded Analytics
  • SAP BW

Secondary Skills
  • SAP
  • ABAP
Other Skills
  • Data-Warehousing Tool :   SAP BI 7.0, BW 7.3, BW 7.4 SAP BO 4.0, SAP BW4HANA BW powered by HANA, Enterprise HANA, SAP BW IP
  • ERP : SAP R/3, ECC 6.0, S4HANA
  • Reporting Tools :  BEx Query, AO report, Web intelligence
  • Data Base : SQL, SAP HANA
Projects

Project 1. Johnson and Johnson - IT Industry (34 months)

    Project type : SAP BW4HANA, Ent HANA Implementation



    Role & Responsibilities.




    • Understanding the functional requirement and preparing the technical designs

    • preparing the Cut over plan and activities, Project progress trackers, GO-LIVE plans

    • importing SAP BA and HANA objects to higher landscapes and Hypercare support

    • supporting different testing phases

    • Creating SAP BW4HANA objects such as Master data objects, ADSOs, Composite provider, Bex queries and Open hub destinations

    • Creating excel based BW hierarchy data loads

    • Extensively worked on flattening the Balanced and Unbalanced BW hierarchies into level wise flat structure with complex ABAP end routine.

    • Creating Calculations views, Input parameters, stored procedure and scalar functions

    • Creating ABAP CDS view based extractors

    • Leading off-shore team and provide technical support

    • Environment: S/4 HANA , BW on HANA, Ent HANA.


Project 2. Georgia Pacific - IT Industry (17 months)

    Project type :  Ent HANA Implementation



    Role & Responsibilities.




    • Understanding the functional requirement and preparing the technical designs covering technical specifications of objects, pseudo code and code flow.

    • Worked on data provisioning method of loading data through flat files in HANA.

    • Created information models such as Attribute Views, Analytic Views and Calculation views using active tables.

    • Worked on input parameters, variables, filters, calculated and restricted columns.

    • Worked on currency conversions at HANA level.

    • Worked on Scripted calculation view

    • Transporting the developed objects from Dev to other environments through delivery units.

    • Worked on Auto documentation in HANA.

    • Preparing the unit test cases and preparing test case logs.

    • Environment: S4HANA, Ent HANA, SAP BI 4.0


Project 3. Metsa - IT Industry (26 months)

    Project type : SAP BW on HANA, SAP BW-IP  Implementation



    Role & Responsibilities.




    • Extensively involved in requirement gathering.

    • Extensively worked on Planning enabled BEx reports.

    • Extensively worked on SAP BW-IP planning functionalities.

    • Extensively worked on cut-over activities.

    • Worked on SAP BW on HANA data flow development.

    • Environment: ECC 6.0 / NetWeaver 7.4, SAP BW on HANA


Project 4. KONE - IT Industry (13 months)

    Project type : SAP BW on HANA, SAP BI 4.0 Support 



    Role & Responsibilities.




    • Extensively involved in all the BO related deliverables.

    • Extensively involved in Universes and Webi reports development 

    • Providing BO report access, Publications, Report and universe developments

    • Involved in HANA migration activities.

    • Regular BO activities monitoring activities.

    • Involved in BW developments.

    • Involved in the BW on HANA migration project.

    • Created HANA models similar to existing BW flows to replace existing BW flows.

    • Environment: ECC, BW on HANA


Project 5. Huntsman Corp - IT Industry (15 months)

    Project type : SAP BW on HANA Implementation



    Role & Responsibilities.




    • Extensively worked on Creating and maintaining info area, Info Object Catalog, InfoObjects, Info Sets and MultiProviders.

    • Experience in creation of Attribute Views, Analytic Views and Calculation Views using HANA Studio.

    • Imported the Flat file data into HANA tables and created the Information models using HANA studio.

    • Extensively worked on Creation of HANA Optimized Info Cubes and HANA Optimized Data Store Objects.

    • Created and activated Data Sources, Info Packages.

    • Created the Transformations and DTP’s on different Data Sources and DSO’s. 

    • Worked on different types of Info Cubes.

    • Created the BEx Queries using free characteristics, Filters, Restricted key figures, calculated key figures, Variables and Navigational attributes and Hierarchies.

    • Created Process Chains for Master data and Transaction data loads.

    • Transported the Objects from Development to Quality, Pre Quality and then to the Production.

    • Involved in the Info Cube Performance activities like Indexation, Compression and Rollup to improve Reporting Performance.

    • Worked on different CR’s which came during UAT (User Acceptance Test).

    • Involved in Data model designing.

    • Worked on Start routine, End Routine and Field Level routine.

    • Involved in Business content Installation, Modifying and Activating InfoCubes and DSO Objects.

    • Environment: ECC 6.0, NetWeaver 7.3,SAP BW on HANA  


Project 6. In house project - IT Industry (25 months)

    Project type : SAP BW Implementation



    Role & Responsibilities.




    • Requirement gathering and Documentation.

    • Worked extensively on Data warehousing workbench (RSA1). Customized Info-objects, Data Sources and InfoCubes.

    • Involved in Data model designing.

    • Created and Maintained Process Chains by scheduling daily/weekly/monthly jobs for periodic loads.

    • Involved in Business content Installation, Modifying and Activating InfoCubes and DSO Objects.

    • Developed Geometric MIS reports which includes Balance sheet, Parables and receivables, Day Sales Outstanding, Manpower Utilization, Training ,Attrition, Revenue tracker(Actual and Projected) reports .

    • Extensively worked on currency translation at transformation and query level.

    • Extensively involved in creating a BEx Report where Calculated Key Figure, Restricted Key Figure and Used Variables with various variable processing types.

    • Enhancement Datasource and User EXIT variables.

    • Publishing BEx reports into Enterprise Portal.

    • Environment: ECC 6.0 / NetWeaver 7.3, SAP BW 7.5


Project 7. BOOTS - IT Industry (12 months)

    Project type : SAP BW Support



    Role & Responsibilities.




    • Involved in production support, data loads and troubleshooting of transaction data.

    • Worked with PSA options and maintained data at PSA level for effective loading.

    • Monitored data loads with full update and delta mechanisms for both master data, transaction data.

    • Performed housekeeping activities I,e deleting data for better performance of BI reports.

    • Created Process chains to automate the process of loading data into data targets

    • Involved in analyzing the tickets and providing a relevant solution to the end users and maintaining the history of the ticket until it is closed down.

    • Maintaining the documentation for each solution for the further reference.

    • Environment: ECC , SAP 7.0


Awards
N/A

Similar Talent

Key Skills - Self Rating

View

Key Skills - Self Rating

View

Key Skills - Self Rating

View

Key Skills - Self Rating

View

Key Skills - Self Rating

View