SUMMARY

• Have around 7 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, Logic Script, and Business Rules in BPC 10.0.
• SAP BPC ADMINISTRATION - Managing Environment, Dimensions, Models, Security, Business Process Flows, Work Status, Business Rules, Logic Scripts, MDX.
• 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 Info Objects, 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.
• Good Knowledge in Business Objects like Designing, implementing and migrating complex Universes and Business Objects Reports, created classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins, External Strategies, Prompts and Aliases for resolving Loops and checked the Integrity of the Universes.
• 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 Info Cubes, 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 Info Cubes 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, Business Objects 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), SSIS, SSAS

Data Replication: ETL SAP BODS 4.x, SLT

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

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

Consultant

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 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, Multi Providers, 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 Info Cubes, DSO, Multi Providers using BEX Analyzer as per reporting requirement.
• Worked on designing Local and Secure Universe, Classes, Objects using IDT and created custom dynamic reports. Experience in creating universe, reports, dashboards, scoreboards using WebI.
• Set up of Universe level conditions to restrict data, customized Universe level Prompts, export the universes to Repository, Queries, Drill Down, Cross Tab, Master Detail and Formulas.
• 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
• Worked on BEx Query options like Variables, Restricted Key Figueres(RKF), Calculated Key Figure(CKF), Filter, Conditions, New Selection, New Formula, Cell Definition, Character and Key Figure Properties, Unit and Currency Conversions, Report to Report Interface(RRI), WAD, BEx Analyzer, Report Designer.

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.
• Worked with Finance Team to set up Ownership Model and related method definitions. Good understanding of Purchase, Proportionate, Equity Methods.
• Worked on maintaining critical securities for user’s based on Data Access Profiles, Task Profiles and maintaining Teams and users.
• 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.
• I alone administered all the BW activities like maintaining object versions, monitoring Data Flows, handling Bex queries both for BW-BO and BPC reporting.

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 Worksheet Logics, Business Logic such as Dimension Formula, Logic Script, MDX, and Business Rules in BPC 10.0.
• Created different reports like Rolling Forecast Reporting, Balance Sheet, P & L, Cash Flow…etc.
• Maintained reports and data collection using Distributor & Collector functionality.
• Maintained Logic Script 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, Logic Script, 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 Logic Script 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.
• I alone administered all the BW activities like maintaining object versions, monitoring Data Flows, handling Bex queries both for BW-BO and BPC reporting

Confidential

SAP Business Intelligence Consultant

Responsibilities:

• Extensively involved in Production support by monitoring Daily/Weekly/Monthly data loads into the BI system from different source systems.
• Handled tickets of different priorities related to various areas like extractions and load failures, report issues & data inconsistency problems.
• Monitoring of Info Packages and analyzing the reasons for frequent failures of Info Packages.
• Performed Reconciliation to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Created Info Packages for populating Info providers by executing Info Packages using both update methods (Full update method and Initialization of Delta method).
• Performed Data load monitoring and failed data packets were analyzed and if possible manually maintaining work history for all the tickets until it is closed.
• Implemented various performance tuning activities to increase the performance of Queries by creating Secondary indexes, Aggregates, Partitioning/ Repartitioning and compression.
• Maintaining and rectifying the errors that occurred in complex process chains to automate the whole process, which includes loading of data from R/3 and flat files into cubes and ODS.
• Troubleshooting errors in load with the help of Dumps and error messages.
• Extensively Involved in Performance Tuning and Data Maintenance by creating and maintaining Aggregates, Compression, Partitioning, Indexing of Info Cubes, and use of Statistics for the same.

Confidential

SAP Business Intelligence Consultant

Responsibilities:

• Created Info Cubes, Data Store Objects, PSA, Info Objects, Info Areas, Multi Providers, 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 Data Sources by adding the required additional fields in ECC using RSAP0001 and mapped the same with corresponding newly created Info Objects on BW side.
• Extensively worked on activating the standard delivered business content Info Objects, Info Sources, Info Cubes, DSO initially to show the Reports to the End users.
• 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.
• Generated reports on Info Cubes, DSO, Multi Providers using BEX Analyzer as per reporting requirement.
• Worked on SAP ABAP for the routines, creating tables/Views. Having knowledge on ABAP concepts like IDOC, BAPI, BDC and DDIC.
• 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 designing WEB Intelligence (WEBI) reports using WEBI Rich Client and Info View for Dashboards. Knowledge in designing universe.
• Implemented various performance tuning activities to increase the performance of Queries by creating Secondary indexes, Aggregates, Roll Ups, Partitioning and Compression.
• Created different BEx Query options like Variables, Restricted Key Figueres(RKF), Calculated Key Figure(CKF), Filter, Conditions, New Selection, New Formula, Cell Definition, Character and Key Figure Properties, Unit and Currency Conversions, Report to Report Interface(RRI), WAD, BEx Analyzer, Report Designer.