SUMMARY:

• SAP Certified BW/BI/BOBJ/HANA/ABAP Consultant with 12+ years of experience in SAP BW/BI/BO/HANA (Native)/BW4HANA/S4HANA/ABAP in various modules that includes application areas, Finance, Controlling, Sales and Distribution, Supply Chain Management (SCM), Customer Relationship Management (CRM), Warranty Management, Logistics Execution (LE), Inventory management, Human Resource and Production planning Industry specific on FMCG, Utilities, Oil & Gas and Retail.
• Integration of non - HANA data into HANA DB models and S4HANA data into BW4HANA for live reporting using smart data access (SDA).
• Design and Build of BOBJ multi source star schema Universe on top of HANA DB Models and Oracle tables in IDT.
• Activation of S4HANA EA Feature for Finance/Controlling reporting, building/activating CDS views, activating tiles for Fiori reporting.
• Experience of design/modeling BW objects Composite providers, Advace DSO’s, OpenODS Views, CDS Views (ABAP/HANA), Data Mart Interface, Multi Providers, Info Cubes, ODS/DSO, Info Objects and Info Sources, DTP, routines (start, end, expert and update), process chains and source system connection using different techniques.
• Involved in performance tuning of HANA models.
• Extensively worked in BO OLAP Universe design, developing reports using BO-Crystal reports, Web Intelligence, Xcelsius and CMC.
• Expertise in Performance tuning using Aggregates, Rollup, Partitioning, Compression, Indexing, Physical partitioning of Info cubes, performance analysis with BW Statistics for analysis and data extraction performance as well.
• Experience in configuration and customization of extraction structures such as LIS, LO Cockpit, FI-SL, CO-PA and Generic Data sources for extracting data from SAP R/3 (FICO, MM, SD, HR and PP).
• Extensively worked in BEx Query Designer, BEx Analyzer, Report designer, Web Application Designer (WAD) and BSP.
• Strong experience in technical design, preparation of test scripts, Unit testing, Source code reviews, cutover activities and performance tuning of objects during system and integration testing.
• Trouble shooting and resolving module-level issues on critical objects that arise in post go-live and interfaces with third party software.
• Extensively worked with SAP on fixing bugs, solution gaps and implemented OSS notes, supported basis team applying patches released by SAP & worked as a SQA for all types of reviews and escalations.
• Excellent client facing skills include end user and experienced in working for multinational companies.
• Well experienced in change management process by using both in SDLC and Agile methodologies.
• Good Knowledge of SAP CRM, SAP SCM, SAP Netweaver MDM, SAP Netweaver XI and Web services like SOAP, WSDL.

• Well versed in modeling using SAP HANA Studio/Web IDE for HANA for building Attribute views, Analytical Views, Calculation views (Cube and Dimension) and NDSO. Worked on HDI for XSA HDB module objects developments.
• Expertise on data provisioning methods ETL (Data Services) into HANA, Data Modeling using star schema/snow flake modelling, Row Based Tables, and Column Based Tables.
• Good exposure to SQL writing queries and procedures in SQL server 2012

TECHNICAL EXPERTISE:

SAP BW 7.X, 3.5, BW/4HANA.

SAP BO A4Office, 4.2, 3.1, QilkView, Cloud Analytics.

SAP S4HANA, ECC (P2P, FICA, O2C, FICO, T&E, PS, CATS, SRM, CRM, HR).

PROJECT EXPERIENCE:

Confidential

SAP BW4HANA/S4HANA EA Consultant

Responsibilities:

• Involved in Analysis, Activate, Build and Testing of reporting requirement in Logistics and FICO modules using BW4HANA, S4 Embedded Analytics, S4 CDS views and Analysis for Office.
• Design and build BW4HANA Modelling for ADSO, Open ODS, and Composite provider using LSA++ architecture, Extraction and loading of data from Logistics and FI/CO modules using ODP enabled extractors.
• Design and build/activate S4HANA Embedded Analytics objects, CDS views and BW queries to be used in A4Office.
• Design and build hybrid composite providers using providers from S4 and BW4HANA.
• Design and build live messages monitoring using HANA Smart data streaming feature.
• Design and build live reporting to build Open ODS in BW4HANA using HANA SDA to access S4HANA tables.
• Build, Enhanced and performance improvement of CDS views used for reporting in Fiori UI.
• Implemented BADI RSROA VARIABLES EXIT BADI for filling BW query variables.

Confidential

SAP BW Consultant

Responsibilities:

• Involved in Analysis, Design, build and testing of Revenue, Payments and Revenue distribution reporting in FICA module, also build reporting in FI, HR, CRM and SRM modules.
• Creation of customized business objects: Generic extractors, Info providers, Transformations, DTP's, Process chains, Queries for Revenue, Payments and Revenue distributing reporting development.
• Developed different types of variables, RKF, CKF other elements for several Bex queries.
• Part of on-prem BW migration to Azure cloud.
• Involved in resolving live services defects, monitoring live data loads and fixing source system upgrade issues.
• Written ABAP function modules to apply formulas for key figure calculations in start/end routines of BW transformations.
• Involved in UT/SIT and UAT for finding defect route cause and defect resolution.

Confidential

SAP HANA/BOBJ Consultant

SAP HANA native development project

Responsibilities:

• Responsible for design and build of Native HANA models using HANA studio through eclipse and Universe design in IDT for Dassian EVM reporting.
• Design and build Attribute views/Analytical Views and Calculation Views (Dimension, Cube, Graphical and SQL) for Dassian reporting
• Integration of Dassian data (HANA) with non-HANA data using smart data access into HANA calc views.
• Design and build complex SQL calculation views to replicate Dassian WBS/OBS hierarchies to able to build drill down/roll up number aggregation at report.
• Design and build single multi-source star schema universe on top of HANA models and non-HANA tables and snow-flow schema on top of HANA models for Dassian reporting
• Usage of CTS+ for HANA Models/Universe promotion.
• Involved in UT/SIT and UAT for finding defect route cause and defect resolution using HP ALM.
• Involved performance tuning of WeBI reports.

Confidential

SAP BW/BOBJ Developer

Responsibilities:

• Responsible for daily/weekly/monthly data loads monitoring.
• Enhanced extractors for sales and finance flows to support business requirements.
• Designed and developed BO OLAP Universe for WebI finance and sales reporting.
• Designed and developed BO WebI for finance and sales reporting
• Developed several FI-AR/AP reports using analysis for office.
• Designed and developed several cash management and FX exposure reports as part of TMS implementation
• Designed and developed Finance Dashboards using SAP Design studio 1.6 on BW queries
• Involved in all the project activities, throughout the project's life cycle using JIRA tool.

Confidential

SAP BW/HANA Developer

Responsibilities:

• Involved in Analysis, Design, Build and testing for integration other subsidiaries sales, billing data for global reporting and Out of Stock reporting for global strategic supplier identification.
• Creation of customized business objects: Info providers, Transformations, DTP's, Process chains, Queries, Web templates for Out of Stock reporting development.
• Written ABAP programs for integration of other subsidiaries data through file system.
• Used ABAP Objects in transformation for Out of Stock build for several calculations.
• Developed several Bex queries to be used as source in BOBJ.
• Prepare project documentation, train business users and support team.

Confidential

SAP ABAP/BI/BO Developer

Responsibilities:

• Analysis and fixing of performance related issues for Vistex data loads.
• Scheduled and monitored the data loads from SAP R/3 system and Flat files to BW and optimized the load performance by Data selections
• BO OLAP Universe modeling on top of Bex queries for WEBI Adohoc reports and web templates for sales/financial reports.
• Prepare project documentation, train business users and support team.

Confidential

SAP BI Developer

Responsibilities:

• Involved in Analysis, build and testing for TPM demand planning forecast evolution.
• Developed extractors for data extraction from APO, TPM and ECC systems for DPFE engine.
• Involved in building DSO’s for staging, do different calculations using OO ABAP for planning purpose in DPFE engine.
• Designed and developed InfoCubes for planning evaluation reporting.
• Developed several reports for consolidation of forecast evolution with Finance module.
• Developed function modules to use in BI and BPS planning for different calculations.
• Involved in all the project activities, throughout the project's life cycle.

Confidential

SAP ABAP/BI/BO Developer

Responsibilities:

• Analysis and development of Vistex objects as per Vistex reporting requirement.
• Creation of customized business objects: Info providers, Transformations, DTP's, Process chains, Queries, Web templates for Vistex analysis reporting development.
• Development of ABAP transformation routines including start, end and expert routines for performance improvement and development of BO Universe for FI/CO reports using Bex query designer and WEBI.
• Uses APD to update different info providers by using Bex query as a source.
• Was part of unit testing, performance testing, and cut over task preparation and pre go-live preparation.

Confidential

SAP BI/ABAP Developer

Responsibilities:

• Analysis of the specifications provided by business owner.
• Enhanced standard data extractors for ECC and CRM data sources.
• Developed several interfaces in logistics by ALE/IDoc
• Involved in creation of data sources, ETL process, and written all transformation routines (start, end and expert) by using ABAP Objects for Logistics and HR modules.
• Responsible for FI/CO reports by using report writer and report painter.

Confidential

SAP BI/ABAP Developer

Responsibilities:

• Part of BI development project in developing Extract structures, ETL process to extract data in Logistics and HR module, developing DSO’s, writing all transformation routines, and report development by using Bex query designer in SD module to support sales team to make better price deal for quotations.
• Part of design and development of Campaign and Voucher projects to help the business to know success rate of Campaigns/Vouchers used by customers which has been sent by Homebase.
• Part of E-commerce project to Integrate SAP with web-based java system to synchronization SAP system with online shopping web system to support all online shopping activities. Involved in development, unit testing and system testing.
• This project is to achieve B2B functionality.
• Part of SAP Recycling Administration implementation in developing reports as a part of world legislation on package wasting, batteries, and WEEE.

Confidential

SAP ABAP Developer/Sr ABAP Developer/Consultant

Responsibilities:

• Worked on developing new data source, written transformation rules, and data loads through ETL from ECC (HR and FI/CO modules), SRM and CRM source systems.
• Expertise in using SPDD and SPAU for upgradation and patching the system.
• Developed extraction programs for HR employee data extraction for migration into Web based system.
• Developed Shopping cart creation through XML upload file in SRM system for course creation, auto GR and Invoice generation.
• Involved in the full project life cycle, from the initial phases of blue print till post go-live activities.
• Liaised with SAP in defining SAP standard naming conventions to use across the global implementation.
• Created functional and technical specifications with respect to European requirements and get the FS sign-off from the business.
• Developed ABAP based classes for custom planning functions by ABAP Objects.
• Developed several reports in FI includes A/R aging, A/R Statement, etc by ABAP Objects.
• Single point contact for all issues in rebate, price query, booking and sales out systems.
• Designed and developed several reports in SD, MM and PM modules
• Responsible for all issues related to the ALE/EDI and Workflow in LE includes SD and MM modules.
• Implemented reports on IDoc tables integrated with Document flow to ease EDI operations
• Developed reports to split SO according to load capacity of truck or pallets for logistics purpose
• Responsible for rebate accruals and claims to customers on time includes agreement creation and posting of AP accounting documents.
• Responsible issues related fiscal period closing, fiscal year closing issues in SD, MM and FI modules.
• Extended standard data extractors for ECC-ISU data sources.
• Responsible for migrating objects from 4.6B to ECC 6.0.
• Involved in interface development for meter reading to calculate the online billing as a part of E-bill.
• Involved in issues resolution in work force management.
• Responsible for preparing quality and test documentation as per the NSTAR standards.
• Member of On-Site Support team and Off-shore team, responsible for handling issues from key-users for SD, CS, MM, PS, PP, FI/CO and PM Module.
• Validated time sheet entries enter by user through CAT2 by using user exit.
• Involved in analysis of existing system, review and updating development specifications, developing objects, debugging and unit testing.
• Developed many classical, Interactive reports related to production orders, invoices, purchasing, inventory, G/L accounts, APs, ARs and developed enhancements in customer master and sales order as per client requirement.
• Developed BDC to create Internal Orders by using KO01 and BDC to upload for ME12 and MR21.

Confidential

SAP Developer

Responsibilities:

• PPP consist of a set of many interrelated custom tables of which there are 5 tables used to drive updates within the Tcodes of PPP. The primary purpose of PPP is to dictate the manufacturing sites and distribution centers that provide specific products to each forecasting entity.
• The Project was undertaken as a part of PDM-IT to Development of new objects in 4.7 boxes and Migration the PPP Objects from 3.1i to 4.7, which mainly consists of MM and PP module.
• Involved in coding, development and testing of Programs and also involved objects Migration from 3.1i to 4.7 and performance tuning of existing reports.
• Developed ALV Report for Device details and document management system, Current WIP (Work in Progress).