SUMMARY:

• Overall 10 year experience as a senior SAP BW consultant which includes data modelling, extraction and report creation and Technical Lead with Client facing roles and responsible for Technical Architecture, Implementation & Go live support including end - to-end SAP implementation experience and also integrated on ECC,HANA, BOBJ, SCM, SRM,CRM, ISU,EC,SEM-IP, NetWeaver, Implementation, Upgrade and Enhancement.
• Certified SAP HANA (C HANAIMP141) App. Associate
• Involved in SAP BI 7.4 Implementation and Support and Maintenance projects.
• Worked on various versions of SAP BW starting from 3.1C, 3.5, Net weaver BI 7.0, 7.3 and BW 7.4 powered by HANA, HANA Studio 1.0,SAP BO4.0/4.1,ECC 6.0
• Good Knowledge in Hana Database Architecture and strong understanding of different types of engines; SQL Engine, Calculation Engine, OLAP Engine, Join Engine and XS Engine.
• Experience in HANA Modelling and worked with Attribute, Analytic and Calculation views and strong understanding of when and where to use join types like Text, Left Outer, Right Outer, Referential and Inner.
• Worked with different Data Provisioning Techniques like SAP DS/BODS, SLT, SDA (Smart Data Access) and good knowledge on DXC.
• Worked on NLS and archiving the historical data for large volumes of the data set.
• Fetched data from various Source systems viz. ECC6.0 (SD, MM, FI, PP, Inventory, HR, PM, CO, COPA, FI-CA, ISU-Utilities...Etc.). SAP EC, BODS, Hyperion, Flat-file, SRM, CRM, SCM and SEM-IP modules.
• Knowledge in Implementing SD, MM (Purchasing, Inventory Management), Production support & Maintenance Projects, Enhancement Projects.
• Involved in designing the Graphical star Schema View by following the necessary standards to deploy optimized Info cube Data Model both at the Database level and Reporting Level.
• As part of Information Consumer Layer designed BEX Reports providing insight of Business Intelligence for Business Analyst for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables with User Entry/Default Value and Replacement Path.
• Involved in changing the Existing data model of an Info Cube by adding new Characteristics and Key figures, involving the Re-initialization of Data Sources from SAP R/3.
• Involved in creating Generic Extractors using Table and view.
• As part of Data Provider Layer, migrated data from SAP R/3 using LO, Business Content Extractors.
• Extensively Involved in Setting up the procedures for LO Cockpit, Involving Activating the Business Content Data Sources, Maintaining the Extract Structure, Generating the Data Source, Activating the Data Source, Enhancing the Data Source and Using the Enhancement RSAP0001 to fill the data into the enhanced Fields.
• Extensively worked in Business Information Warehouse Info Cubes, ODS Objects, Info sources, Info objects, Transfer rules, update rules, Extractors, Info sources, Info packages, Info objects Catalogs, Data sources, Data Extraction, Business Content, Data Marts, Process Chains.
• As part of Quality management standards to deliver the objects in quality performed Unit testing and recorded the test results in unit test cases documents.
• Designed and developed process chains (RSPC) for master data loads and transaction data loads with the help of Info-Packages. And these Process chains are scheduled for periodic loads.
• Uploaded Master and Transactional data from Flat Files, SAP BW and SAP R/3.
• EXTRACTION: LO and Flat file data Extraction for Master and Transactional data. Generic Extraction, Activating Data Sources, deleting Setup tables, filling up of Cluster tables, setting up of V3 update, Customizing and Enhancement of Extract structure / Enhancements for Data Sources.
• MODELING: Process Chains, Info Cubes, MultiProviders, DSO Objects, Info Sets, Info Objects, Info Sources, Data Sources, Update Rules, Transfer Rules, Communication Structure, Transfer Structure, Info Packages, Transformation, Expert Routines, Virtual Cubes, Real-time Cubes etc.,
• REPORTING: BEx-Analyzer, Query Designer, Report Designer, Condition Reporting, Exception highlighting, Restricted key figures, Calculated key figures, Variables, Filter, Free Characteristics, Variants, Structures and Report to Report Interface.
• DASHBOARDS: Visual Composer 7.0 and WAD.
• PERFORMANCE TUNING: Aggregates, Indexes, Compression, Partitioning and Statistics.

TECHNICAL SKILLS:

• BW powered by HANA.
• BI-IP.
• Open-hub-destination.
• BEx-Web, WAD, Visual Composer 7.1 and BO Dashboards.
• Real Time Data Acquisition (RDA).
• BI 7.4 and functionalities.
• ABAP and EP.
• Participated in the kick-off and onsite Participated in the kick-off and onsite

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Involved in Extracting Complex Extractions.
• Involved in Modelling, Reporting, Extraction.
• Involved in submitting the Ticket Status (Open/Close) report.
• Involved in both the Activities monitoring and Production Support.
• Handled tickets with different priority and never missed the SLA.
• Executing of BI Reports in KM Portal.

Confidential

Responsibilities:

• SAP-ECC 4.7, 6.0,BO 4.1
• SAP-Visual Composer and Front End-BEx Web Analyzer
• SAP-Environmental Compliance and SAP- BW-Upgrade
• SAP-CRM,SCM,SEM-IP

Confidential

Responsibilities:

• Proficient in data modelling using BW extended star schema model
• Proficient in evaluating requirements and implementing BI solution for Clients
• Extensive experience in implementation, Development as well as Production Support projects
• Performed extensive Logistic extractions, Finance and generic extractions
• Worked on queries using BEX Analyzer, BEX workbooks and WAD.
• Extensively used structures, variables, exceptions, conditions, restricted and calculated Key Figures and customer exits in reporting
• Experience in Performance Tuning.
• Proficient in handling support projects. Analysed and corrected production problems as they occur in the SAP BW system.
• Experience on implementing BW 7.4 new concepts.
• Worked on writing ABAP routines, customer exit Programs and Function Modules based on the customization.

Confidential

Responsibilities:

• Worked on Attribute views
• Worked on Analytical views
• Worked on Calculation Views using Graphical.
• Worked on SLT Tables from ECC and Non-SAP databases.
• Worked on the aDSO
• Worked on the SDA to fetch the data from Non SAP sources.
• Worked on Composite Providers

Confidential

Responsibilities:

• Experience on Webi
• Experience on SAP Business Objects 4.0
• Experience on SAP Business Objects 4.0 Web Intelligence, OLAP Analysis Explorer
• Experience on Design Studio
• Experience on Lumira