SUMMARY

• Have around 4 years of end to end Implementation and Support Experience in SAP BPC NW 10.1, 10.0, 7.5, Business Warehouse NW 3.5, 7.0, 7.3, 7.4, 7.5 and HANA 1.X, 2.0.
• Have experience in both SAP BPC Planning and Consolidation process.
• Created and Maintained Application Sets(Environment), Dimensions and Applications(Models) in BPC 10.0.
• Created and Maintained Input Template and Reports and developed Business Logic such as Dimension Formula, Script Logic, and Business Rules in BPC 10.0.
• SAP BPC ADMINISTRATION - Managing Environment, Dimensions, Models, Security, Business Process Flows, Work Status, Business Rules, Script Logics.
• SAP BPC DATA MANAGER - Maintaining Data Manager Packages, Conversion and Transformation files.
• SAP BPC for OFFICE - BPC for Excel, BPC functions and formulas, Custom Menus, Reporting and Input schedules.
• Worked on Consolidation Business Rules & logic, such as Balance Carry Forward, Currency Conversion, Intercompany Matching/Elimination, Account Based Calculation.
• Extensively worked in Data Warehousing/Administrative Workbench, Data Modeling, Extraction, Data Loading (Full/Delta upload).
• Extensively worked on designing and creating InfoObjects, Standard and Custom Info Cubes, DSO /Operational Data Store, DTP, Transformations /Transfer structures, Communication structures.
• Monitoring of Data Loads and analyzing the reasons for frequent failures of Info packages.
• Defining of Process chains for interdependent processes with tasks like Data loading, aggregate rollups, Cube Compression, Master data & DSO activation in achieving the best possible performance.
• Worked on SAP HANA and SAP BW on HANA Landscapes based on HANA ASAP 8 Methodology.
• Experience working on HANA Modelling - Attribute Views, Analytical Views, Calculation Views, SQL Scripting, CE functions, Procedures, Analytical Privileges.
• Excellent knowledge on: HANA Optimized InfoCubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA.
• Experience in migrating the Standard Info Cube and DSO to HANA Optimized InfoCubes and DSO.
• Experience in Data Provisioning/Replication techniques like SLT, DXC, SDA, SRS, SDI, Data Services(BODS) to perform real-time data replication and near time data loading into HANA.
• Worked on Data Modeling, Data Provisioning, Reporting, good understanding and experience in providing security restrictions on models using Analytic Privileges and assigning Authorization roles for different types of users in SAP HANA.
• Experience in Importing BW models Info Cube, DSO in HANA as Analytical view.
• Experience in Configuring and Consuming SAP HANA models in BI clients such as Analysis for Office, Lumira, Predictive Analysis, BusinessObjects Explorer MS Excel.
• Extensively worked on Logistics Data extraction from ECC and worked on building reports related to SD like Open Order Pipeline, Delivery, Sales, Open Order Pipeline Not Yet Processed using Bex Query Designer and Bex Analyser.

TECHNICAL SKILLS

Data Warehousing: SAP NetWeaver BW 7.5,7.4,7.3, BI 7.0, BW 3.5

ERP: SAP R/3 ECC 6.0/5.0, SAP R/3 4.7

Business Modeling: HANA Design Studio, Data Services Workbench, Data Warehousing Workbench (RSA1)

Data Replication: ETL SAP BODS 4.x, SLT

Reporting Tools: BEx Query Designer, BEx Analyzer, MS Excel, BO tools (IDT, Analysis for Office)

Programming: ABAP, SQL, SQLScript, HTML, CSS, Java, C/C++, OOPDatabases SAP HANA 1.X, 2.0, Oracle 10g/9i/8i, MS SQL server 2008, MS Access, MySQL 5.xOperating Systems Windows NT/2000/XP/7, Windows Server 2008, Unix, Linux

Functional Modules: SD, MM, PP, HR, FI-CO, CRM

Others: SAP Fiori, SAP Hybris, Analysis Process Designer(APD), BWA, MS Office 2010

PROFESSIONAL EXPERIENCE

Confidential

Software Developer Intern

Responsibilities:

• Worked on Native Hana Development: Creating HANA information models or Views (Attribute, Analytics and Calculation views) with Graphical, SQL Scripting, CE Functions, Procedures and also created Hierarchies, including Restricted and Calculated Measures, Filters, Input Parameters, Counters, etc.
• Worked with different node types in Calculation View - Projection, Aggregation, Join, Union, Rank.
• Created required ADSO for BPC, Hana views, Composite providers, Bex and Dash Boards reports etc.
• Worked on HANA SQL views and procedures.
• Worked on BW on HANA, was involved in BW on HANA Life cycle implementation.
• Worked on Data Provisioning/Replication techniques like SLT, DXC, SDA, Data Services(BODS) for SAP and non-SAP data sources to acquire the data into SAP HANA Data Mart.
• Implementation of Security model in HANA to restrict Data level security using Analytical Privilege and population of restriction values dynamically using Stored Procedure.
• Created Info Cubes, Data Store Objects, PSA, Info Objects, Info Areas, Multiproviders, Data Sources, and Info Packages to load Master and Transactional data from SAP R/3 and flat files into BI system.
• Configured and extracted data from the LO Cockpit extractors into BI System.
• Designed process chains for loading Transaction and Master Data and involved in performance tuning for enhancing Query Efficiency.
• Developed various data extraction procedures for Master Data (full and delta load) for Attributes, Texts and Hierarchies and Transactional Data (full and delta) LO Cockpit and Generic Extractors for Customer-Defined Tables.
• Generated reports on Infocubes, DSO, Multiproviders using BEX Analyzer as per reporting requirement.
• Extensively Worked with Query designing and defined Variables, conditions, Filters, Exceptions, Structures, Navigational & display attributes, calculated key figure, restricted key figures, Report to report interface etc.
• Worked on Inventory Management reports like Percentage Compliance and Non-Compliance, Contract Validity reports by extracting data from ECC using Data sources: 2LIS 03 BX, 2LIS 03 BF, 2LIS 03 UM

Confidential

BPC-BW Consultant

Responsibilities:

• Maintenance of Application Set, Dimension Members and Dimension Properties.
• Involved in data extraction from ECC to BW to BPC systems using Process chain and Data Manager Packages. Developed Process Chain to load Data from ECC to BW.
• Created HR Custom Input templates and Reports apart from making enhancements to the existing templates.
• Worked on Dynamic Formatting Template and applied Hierarchy Level, Dimension Member/Property, Row, Column Banding and Page axis formatting to Reports and Input Forms.
• Created Custom Reports with EPM functions to match with the user requirement.
• Created and maintained Distribution and Collection Wizard for different Planning reports for different locations to different users.
• Worked on Drill Through for Website, ECC/BW Query to view the information on source systems.
• Extensively worked on Transporting Objects from Dev to QA to PRD.
• Worked on Transformation, Conversion files and Data manager for loading data between BPC and ERP systems with extractors and ETL tools.
• Developed Business Process Flows to guide end-users through pre-defined sequential tasks that span across the different departments within the organization and maintained related work status.
• Worked on setting up Security settings to ensure user entitlements and access rights.

Confidential

BPC-BW Consultant

Responsibilities:

• Created and maintained Environment, Dimensions and Models in BPC 10.0.
• Worked on Master Data and Transaction Data Loading.
• Created and Maintained Input Template and Reports and developed Business Logic such as Dimension Formula, Script Logic, and Business Rules in BPC 10.0.
• Maintained reports and data collection using Distributor & Collector functionality.
• Maintained Script logic in planning process i.e. sending data from one application to other, calculation etc.
• Evaluated & customized USGAAP RDS as per client requirement by modifying dimensions, script Logic, business rules - Currency Conversion, IC Matching, IC elimination and Cash flow.
• Worked on Consolidation Business Rules & logic, such as Balance Carry Forward, Currency Conversion, Intercompany Matching/Elimination, Account Based Calculation
• Developed Custom Chain to load Data from ECC to BW to BPC using single Data Manager Package.
• Created Package links to bundle BW Process Chains and Data Manager Packages and to run them sequentially in BPC.
• Worked on Comments with Input Forms to enable users to record planning assumptions and variances.
• Created Spread, Trend and Weight Planning Functions on Input Reports to perform Planning according to the business requirement
• Maintained Custom Measure on YTD Model to meet the Business Requirement.
• Developed Business Rules and Script logic for various Business Needs.
• Maintaining and rectifying the errors that occurred in complex process chains to automate the Data Loading Process, which includes loading of data from R/3 and flat files into cubes and DSO.

Confidential

BW Consultant

Responsibilities:

• Created Info Cubes, Data Store Objects, PSA, Info Objects, Info Areas, Multiproviders, Data Sources, and Info Packages to load Master and Transactional data from SAP R/3 and flat files into BI system.
• Configured and extracted data from the LO Cockpit extractors into BI System. Enhanced the Datasources by adding the required additional fields in ECC using RSAP0001.
• Extensively involved in handling Initialization of Delta for the Logistics Applications.
• Designed process chains for loading Transaction and Master Data and involved in performance tuning for enhancing Query Efficiency.
• Developed various data extraction procedures for Master Data (full and delta load) for Attributes, Texts and Hierarchies and Transactional Data (full and delta) LO Cockpit and Generic Extractors for Customer-Defined Tables.
• Worked with Query designing and defined Variables, conditions, Filters, Exceptions, Structures, Navigational & display attributes, calculated key figure, restricted key figures, Report to report interface etc.
• Implemented various performance tuning activities to increase the performance of Queries by creating Secondary indexes, Aggregates, Roll Ups, Partitioning and Compression.