Description
MAHLE Holding, Pune, India - Present
BW HANA Consultant
• Involved in requirement Gathering, working directly with client and stakeholders
• Worked on Data Warehouse workbench for standard and customized InfoObjets, DSO’s. DTPs, Transformation, Advanced DSOs and Composite providers
• Working on SAP Design Studio, SAP Net Weaver enterprise portal and uCHARM process
Client: Dmart –
BW on HANA implementation
SAP BW HANA Consultant
• Involved in requirement Gathering, working directly with client and stakeholders, creating TS.
• Worked n SAP HANA Studio- BW modelling to create InfoObjects, ADSOs and Composite Providers
• Worked on Query designer to creating Standard and customize queries.
• Transported objects from Dev to Quality.
• Worked on Data Warehouse workbench for standard and customized InfoObjets, DSO’s. DTPs, Transformation, Advanced DSOs and Composite providers
• As part of ECC extraction involved with LO Cockpit & Generic Extractors based on Table, View, Function Module and also cutomized the standard extractors using enhancement RSAP0001.
• Providing KT for the Support Team
• Creates transformations, routines, formulas, DTPs
• Develops, maintains, monitors and manages data loads and functions
• Documents test plans and completes unit testing of developed objects
Client: American Airlines: –
HANA Implementation and Support
Title: SAP BW HANA Consultant
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.
• Develop SQL scripts and functions for complex reusable scenarios in HANA.
• 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.
Client: EMC
SAP BI/BW Consultant
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.
Client: GM
Role: SAP Consultant
Accomplishments:
• Involved in Developing RICEF (Reports, Interface, Conversion, Enhancements, Forms) in ABAP/4 SAP ECC 6.0
• Creation of Classical and Interactive Reports, Development of Reports using ABAP List Viewer
• Creation & Maintenance of Tables, Structures & Views, and other dictionary objects.
• Bug fixings and Code review.
• Developed a report for sales order which displays corresponding sales details using ALV reporting.
• Developed a report that displays customer-wise sales document details.