SUMMARY

• Senior SAP BI/BW4HANA Consultant wif 10+ years’ experience in several full cycle SAP implementations.
• Highly motivated professional consultant in the area of SAP Business Intelligence like SAP BW on HANA, SAP BW/4 Hana and SAP BW UPGRADE from 7.4 to 7.5. Data Warehousing Experience includes Requirements gathering, analysis, design and development. Leading team and Delivering Projects.
• Knowledge in Implementing SD, FI, MM (Purchasing and Inventory Management), Production support & Maintenance Projects, Enhancement Projects.
• Good Exposure to the Functional noledge of the implemented Modules.
• 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.
• Experienced in designing solutions and developing technical specifications based on functional requirements
• Excellent noledge on: SAP BW/4 HANA, Advanced DSO(ADSO), Open DSO Views, Transient Providers, Composite Providers, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA, LSA and LSA++, ODP API like SLT and SAPI.
• Good experience in BW4HANA and BW on HANA ODP data source Extraction and build LSA++ data flow wif all Hana objects.
• Experienced in creating the composite provider, created ADSO wif all options like standard DSO, write optimized DSO, data mart like cube and planning options.
• Extensively worked on Transformations, Start routines, Expert Routines and End routines.
• Experience working wif Open Hub Services to push data out of SAP BI.
• Experienced in activating standard Business Content, extending and enhancing using User Exits according to the end - user requirements
• Extensive experience in front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Variables, Exceptions, Conditions, BEX analyzer.
• Worked on BEx Query designer in designing reports using calculated key figures, restricted key figures wif all the properties of the characteristics and key figures.
• 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
• Involved in Post-Production support that includes monitoring of process chains and data loads, Reconstruction of data targets in case of failed loads, Rescheduling of process chains.
• Extracting Master & Transaction Data using Generic Data Sources from OLTP and from External systems.
• Uploaded master and transactional data from files and SAP as the OLTP source.
• Created Transformations, Routines and DTP to extract the data from the source system
• Worked on creating process chains wif many of the process types and involved scheduling the loads daily loads
• Involved in solving the data load failure issues of the process chains.
• Designed Reports as, to Analyze Open Tickets corresponding to managers, directors.
• Analyze open and close ticket, Number of open tickets in a Queue and Severity of the Tickets. Executive touch reports to analyze Monthly & Weekly Data…. etc.
• Created Trend Analysis reports using WEBI Reports like bar charts, Column Charts and customizing the charts as client required.
• Created process chains for full/delta - ATTR, TEXT and transaction loads by using the processes like DTP, Info Package, Save Hierarchies, Main/Local process chains, Delete overlapping request, AND, Delete PSA, Attribute change run etc.
• Efficiently handle the team and also an effective team player.
• Meet wif SAP Functional Analysts and business users to discuss user requirements, developed and documented technical specifications, technical approach and time frame.
• Involved in Training the junior resources and utilize them effectively in the project.
• Understanding of business environment, good communication skills, and ability to work proactively in a fast-paced environment.

• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Developed complex SQL scripts in Calculation views.
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application
• Created reports and visualization across Calculation, Attribute and Analytical views .
• Native HANA modelling
• SAP LT Replication Server (SLT)
• SAP Data Services (DS)
• SAP Direct Extractor Connection (DXC)
• SAP Smart Data Access (SDA)
• ODP Extractions in BW on HANA

TECHNICAL SKILLS

ERP: SAP R/3, ECC6.0,S4 HANA

DW Tools: SAP BW 3.5, BI 7.0,7.3,7.4, BO-4.2.BODS, Crystal Reports, Lumira

Database: Oracle, DB2, MSSQL,HANA 2.0.

Operating System: Windows NT/2003/XP, UNIX.

Others: HPQC,MS Office (Word, Access, EXCEL, Power Point)

PROFESSIONAL EXPERIENCE

Confidential

Environment: SAP BW4/Hana

Responsibilities:

• Performed BW Pre-Conversion activities for In-place conversion.
• Performed BW4HANA Post conversion and follow activities.
• Analyze the existing Design of BW Reports in classic BW systems and prepare design documents for BW/4HANA development.
• Designing calculation views (private views, reusable view, Query View), counters. Restricted and calculated Measures, input parameters, filters debugging views.
• Created the HANA objects like ADSO, Open ODS, and Composite provider.
• Working in HANA Replication techniques SLT.
• Handling currency conversions in HANA views.
• Imported and exported HANA Views in different Landscape and Migration of HANA views from Development till Production.
• Test HANA Views and all developed objects and resolve defects.

Confidential

Environment: SAP BW4/Hana

Responsibilities:

• Performed BW Specific Pre-Upgraded Activities
• Performed ASUG preparation activities during upgrade.
• Performed SPDD adjustments during Upgrade
• Performed SPAU adjustments after Upgrade.
• Performed Post upgrade activities.
• Worked Closely wif SAP through Expert Chat.
• Provided End User Training on BW 7.5.

Confidential

Environment: SAP BW4/Hana

Responsibilities:

• Conducted Business workshops and prepared a Detail Design document for business use case.
• Defining the SAP HANA components (SAP and Non SAP sources to replicate) replication process and define HANA views.
• Understanding the SAP ECC Data tables which are identified for dashboard reporting and getting clarification from Business analysts.
• Worked on BW Modeler prospective for building Data Targets ADSO’s.
• Designed and Created Process Chains Using different process types Example: ABAP Program Process type, PSA Request Deletion Process Type and OS command process type, deleting Data target data, deleting overlapping request.
• Captured implementation or changes in Change Id’s for transporting the object from dev to quality and production.
• Resolved issue occurred during transportation of BW HANA Objects.

Confidential

Environment: SAP Solman 7.2

Responsibilities:

• Studied the existing business rules and understood the client's new reporting requirements by interacting wif the Business managers and users.
• Identified the Business content Cubes for Alerts and System availability metrics.
• Activated all the required Business content objects
• Created a BEX Reports on ITSM for SAC.
• Created an Open hub to extract data from Bex Reports to third party tool.
• Created and scheduled a process chain for the Entire flow
• Recommended solutions and resolved issues.

Confidential

Environment: SAP BI 7.4

Responsibilities:

• Gathered requirements from the client.
• Participated in brainstorm sessions in understanding the business requirements.
• Handled Complete Upgradation of BW 7.0 to 7.4
• Analyzed the Existing System (3.x & 7.0) and re-created all the objects by Consolidating the Design of SD & MM Applications.
• Working on Re-implementing MM & SD (11,12,13) Application Components.
• Worked Extensively on Integrated Planning, In Creating Planning Sequences, Function, Filters and Aggregation Levels.
• Extensively Worked on Creating WAD reports using Container Layout, Analysis Item, Button Groups, Navigation pane, Filter pane etc...
• Handled P1 Tickets and resolved P1 Issues as well as change Requests.

Confidential

Environment: SAP BI 7.4, SAP B.O 4.1, ECC 6.0 EHP7

Responsibilities:

• Involved in gathering of information from the Functional Spokes as per the business requirement and developed the Technical specs.
• Worked wif various standard as well as custom BI/BW objects for FI, SD of ECC.
• Designed and developed various Datatargets and Infoproviders like DSO, Info cubes, Infoobjects, Multiproviders using Administrative workbench (EDW, RSA1.)
• Populated various data targets like Infoobjects, ODS and Infocubes, wif Master data and Transactional data from ECC 6.0, legacy systems using flat file interface via Data Staging area (PSA)
• Developed BW reports for SD/FI/MM.
• Loaded data Using Initialization, Delta Loads and Full Update
• Developed, conducted and presented various training to the users as well as the project members
• Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Text Variables, etc. For customized reporting using BEx Analyzer, Designed and developed several workbooks and global views

Confidential

Environment: SAP BI 7.4, SAP B.O 4.O,R/3 ECC 6.0

Responsibilities:

• Involved in gathering of information from the Functional Spokes as per the business requirement and developed the Technical specks.
• Extensively worked on Migration of objects from 3.5 to 7.O
• Extensively worked on Upgradation from 3.5 to 7.4
• Involved in Creation of new reports in BI and Integrated in BO WEBI.
• Created universe using Information Design Tool (IDT).
• Enabled dynamic report linking by passing Variables (prompts) between reports
• Designing, developing and deploying using Universe Designer, Web Intelligence.
• Worked on Transportation of the objects from Development system to till Production system across the landscape.
• Interacting wif the clients for various issue resolutions.
• Involved in Unit Testing and Business Acceptance Testing using HP Quality Center
• Interacted wif Business users and collected requirements and provided solution accordingly.
• Migrated Inmemory Cubes and DSOs to Hana studio and modified as per requirement to create Calculated and Analytic views.
• Created SAP HANA Information Models using Attribute, Analytic and Calculated Views.
• Preparing the reports and sending it to the clients and involved in client interaction, understanding the requirements and working on the same.
• Support to day to day activities by trouble shooting various issues related to data loads, Performance tuning and cleaning up the system.

Confidential

Environment: SAP BI 7.0, R/3 ECC 6.0

SAP BI Consultant

Responsibilities:

• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Data Loads.
• Created G/L account hierarchies in ECC system
• Actively Involved in Daily loads and doing data comparisons to ECC and BI By using Reconciliation in Production Systems.
• Actively Involved in Creating DTP’s Info package’s
• Prepared Functional Specs
• Handled tickets wif different priority and never missed the SLA
• Involved in maintaining lot of documentation for all the Activities.
• Involved in Validated data consistency in reporting wif Data Target against PSA after loading them to data targets.
• Involved in handling the tickets posted by the user.
• Extensively worked on BI testing after upgrading from 7.1
• Involved in testing the reports and performing necessary changes as per the new business logic.
• Loaded data Using Initialization, Delta Loads and Full Update.
• Created process chains for all the master and transaction data loads and scheduled them as per the requirement
• Triggered setup tables for Orders, Delivery, Billing and loaded data in BI side.
• Worked on different kinds of attributes like Display, Navigational, Compounding, Time dependent attributes.
• Created & modified queries based on the user requirement using Calculated Key Figures, Restricted Key Figures, Formulas, Exceptions, Conditions, Variables, etc
• Extensively worked on BI Testing(MQC)
• Worked on data mismatch errors at Query level and suggested suitable solutions.
• Worked Extensively on Open Hub integrated wif data stage.
• Worked on the customization of the cubes as per the new business. Worked on the functional testing of the new development as per the requirements of the customer

Confidential

Environment: SAP BI 7.0, R/3 ECC 6.0

SAP BI Consultant

Responsibilities:

• Review, Analyze and evaluate end-user requirements
• Installed Business Content Data sources and Business Content Objects
• Created Customization Objects as per user requirement
• Created Generic Data source and extensively worked on Generic Deltas.
• Loaded data Using Initialization, Delta Loads and Full Update.
• Checked for data consistency and modified the data in PSA before loading them into data targets.
• Facilitate integration and user acceptance testing of the newly developed reports.
• Involved in performance tuning by creating Indexes, Aggregates, and Line Item Dimension.
• Documentation of development activities.
• Performance Tuning

Confidential

Environment: SAP BI 7.0, R/3 ECC 6.0

Responsibilities:

• Triggered setup tables for Orders, Delivery, Billing and loaded data in BI side.
• Worked on user Exits
• Created process chains.
• Worked Extensively on Open Hub integrated wif data stage.
• Enhanced the datasource 2LIS 11 VASTH by adding new field CMGST.
• Worked on Information Broadcasting(Email Bursting)
• Involved in Datastage Errors.
• Worked on Code optimization.
• Worked on data mismatch errors at Query level and suggested suitable solutions.
• Involved in performance tuning by creating Indexes, Aggregates, and Line Item Dimension.
• Worked on different kinds of attributes like Display, Navigational, Compounding, Time dependent attributes.
• Created & modified queries based on the user requirement using Calculated Key Figures, Restricted Key Figures, Formulas, Exceptions, Conditions, Variables, etc
• Having very good communicational skills, being a smooth offshore Team Lead wif excellent interpersonal skills. Exceptional ability to quickly master in new concepts and technologies.
• Extensively worked on BI Testing(MQC)
• Handling the team and involving in the issues countered by the users.
• Involving in the Resolving the issues in the reports. Designed the Multi provider to pull the Data from different cubes
• Monitoring the daily loads.
• Worked on the customization of the cubes as per the new business. Worked on the functional testing of the new development as per the requirements of the customer
• Suggested the process improvements to stabilize the system by way of monitoring the loads by being Pro-Active rather tan Re-active.

Confidential

Environment: SAP BI 7.0, R/3 ECC 6.0

Team Lead

Responsibilities:

• Created Technical Specs for Data source, Info providers, BEx Reports.
• Created of Generic Data source for Customer Portal by using View, Function Module, Infoset.
• Actively involved in Rectification of Load Failure Errors like Master Data Loads, Transaction Loads.
• Involved in Creation of Info cube and DSO for Customer Portal and created Reports for the customers.
• Involved in Creating Expert & Start Routines for Transformations.
• Extensively Worked on Generic Deltas.
• Involved in Quick Sizing of Production Data.
• Enhancement of Data source by adding required field by appending structure and written code in functional enhancement.
• Worked wif HR data sources 0HR PA 0(Employee) 0HR PA 1(Personal Actions).
• Created process chains & Metachains by using advanced process types like Decision between alternatives, Using interruption to stop the process chain in particular time.
• Created a Multiprovider on Single Cube, by executing property sequentially not parallel.
• Used APD to improve my Query Performance and to reflect the master data attribute value to reflect into the cube.
• Involved in Validated data consistency in reporting wif Data Target against PSA after loading them to data targets.
• Handled tickets wif different priority and never missed the SLA.
• Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Text Variables, etc. For customized reporting using BEx Analyzer, Designed and developed several workbooks and global views
• Involved in editing the error records in the error stack and uploaded these records by using error dtp.

Confidential

Environment: SAP BW 3.1C

Responsibilities:

• Involved in Load Monitoring Using RSPC, RSMO, SM37, and SM50.
• Handled the tickets of priority S1, S2 and S3 by following (SOP) Standard Operating Procedures and never missed the (SLA) Service Level Agreement.
• Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report, Time sheet maintenance of the support team.
• Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis.
• Maintain list of all the activities for all the tickets until it is closed down.
• Involved in Validated data consistency in reporting wif Data Target against PSA after loading them to data targets.
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Data Loads.
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages.
• Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads. Maintaining the queue - related to the system generated tickets and customer generated tickets.
• Involved in creating data source for FI, MM and SD modules and also from flat files.
• Created open hub to transfer data from Info Provider to Flat Files for further analysis.
• Schedule Daily/Weekly/Monthly data loads schedule new jobs.
• Worked on aggregates, export data source, transfer rule, update rule, info source.
• Created process chains for data loads for transaction data, master data, and data from finance and Goods movement.
• Created reports, web reports.
• Extensively worked on pre-upgrade and Post-upgrade activities from 3.1c to 3.5