Tek06777

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
|
|
|
|
Secondary Skills
|
|
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)
- 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 type : SAP BW4HANA, Ent HANA Implementation
Role & Responsibilities.
Project 2. Georgia Pacific - IT Industry (17 months)
- 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 type : Ent HANA Implementation
Role & Responsibilities.
Project 3. Metsa - IT Industry (26 months)
- 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 type : SAP BW on HANA, SAP BW-IP Implementation
Role & Responsibilities.
Project 4. KONE - IT Industry (13 months)
- 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 type : SAP BW on HANA, SAP BI 4.0 Support
Role & Responsibilities.
Project 5. Huntsman Corp - IT Industry (15 months)
- 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 type : SAP BW on HANA Implementation
Role & Responsibilities.
Project 6. In house project - IT Industry (25 months)
- 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 type : SAP BW Implementation
Role & Responsibilities.
Project 7. BOOTS - IT Industry (12 months)
- 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
Project type : SAP BW Support
Role & Responsibilities.