We provide IT Staff Augmentation Services!

Sap Bi Consultant Resume

SUMMARY

  • Senior SAP BI/BW4HANA Consultantwith 10+ years’ experience in several full cycle SAP implementations.
  • Highly motivated professional consultant in teh 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 teh Functional knowledge of teh implemented Modules.
  • Involved in designing teh Graphical star Schema View by following teh necessary standards to deploy optimized Info cube Data Model both at teh Database level and Reporting Level.
  • Experienced in designing solutions and developing technical specifications based on functional requirements
  • Excellent knowledge 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 with all Hana objects.
  • Experienced in creating teh composite provider, created ADSO with 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 with Open Hub Services to push data out of SAP BI.
  • Experienced in activating standard Business Content, extending and enhancing using User Exits according to teh 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 with all teh properties of teh characteristics and key figures.
  • Extensively Involved in Setting up teh procedures for LO Cockpit, Involving Activating teh Business Content Data Sources, Maintaining teh Extract Structure, Generating teh Data Source, Activating teh Data Source, Enhancing teh Data Source and Using teh Enhancement RSAP0001 to fill teh data into teh 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 teh OLTP source.
  • Created Transformations, Routines and DTP to extract teh data from teh source system
  • Worked on creating process chains with many of teh process types and involved scheduling teh loads daily loads
  • Involved in solving teh data load failure issues of teh 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 teh Tickets. Executive touch reports to analyze Monthly & Weekly Data…. etc.
  • Created Trend Analysis reports using WEBI Reports like bar charts, Column Charts and customizing teh charts as client required.
  • Created process chains for full/delta - ATTR, TEXT and transaction loads by using teh processes like DTP, Info Package, Save Hierarchies, Main/Local process chains, Delete overlapping request, AND, Delete PSA, Attribute change run etc.
  • Efficiently handle teh team and also an effective team player.
  • Meet with SAP Functional Analysts and business users to discuss user requirements, developed and documented technical specifications, technical approach and time frame.
  • Involved in Training teh junior resources and utilize them effectively in teh project.
  • Understanding of business environment, good communication skills, and ability to work proactively in a fast-paced environment.
Core Competencies
  • 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

SAP BI Consultant

Responsibilities:

  • Performed BW Pre-Conversion activities for In-place conversion.
  • Performed BW4HANA Post conversion and follow activities.
  • Analyze teh 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 teh 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

SAP BI Consultant

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 with SAP through Expert Chat.
  • Provided End User Training on BW 7.5.

Confidential

Environment: SAP BW4/Hana

SAP BI Consultant

Responsibilities:

  • Conducted Business workshops and prepared a Detail Design document for business use case.
  • Defining teh SAP HANA components (SAP and Non SAP sources to replicate) replication process and define HANA views.
  • Understanding teh 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 teh object from dev to quality and production.
  • Resolved issue occurred during transportation of BW HANA Objects.

Confidential

Environment: SAP Solman 7.2

SAP BI Consultant

Responsibilities:

  • Studied teh existing business rules and understood teh client's new reporting requirements by interacting with teh Business managers and users.
  • Identified teh Business content Cubes for Alerts and System availability metrics.
  • Activated all teh 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 teh Entire flow
  • Recommended solutions and resolved issues.

Confidential

Environment: SAP BI 7.4

SAP BI Consultant

Responsibilities:

  • Gathered requirements from teh client.
  • Participated in brainstorm sessions in understanding teh business requirements.
  • Handled Complete Upgradation of BW 7.0 to 7.4
  • Analyzed teh Existing System (3.x & 7.0) and re-created all teh objects by Consolidating teh 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

SAP BI Consultant

Responsibilities:

  • Involved in gathering of information from teh Functional Spokes as per teh business requirement and developed teh Technical specs.
  • Worked with 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, with 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 teh users as well as teh 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

SAP BI Consultant

Responsibilities:

  • Involved in gathering of information from teh Functional Spokes as per teh business requirement and developed teh 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 teh objects from Development system to till Production system across teh landscape.
  • Interacting with teh clients for various issue resolutions.
  • Involved in Unit Testing and Business Acceptance Testing using HP Quality Center
  • Interacted with 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 teh reports and sending it to teh clients and involved in client interaction, understanding teh requirements and working on teh same.
  • Support to day to day activities by trouble shooting various issues related to data loads, Performance tuning and cleaning up teh 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 with different priority and never missed teh SLA
  • Involved in maintaining lot of documentation for all teh Activities.
  • Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
  • Involved in handling teh tickets posted by teh user.
  • Extensively worked on BI testing after upgrading from 7.1
  • Involved in testing teh reports and performing necessary changes as per teh new business logic.
  • Loaded data Using Initialization, Delta Loads and Full Update.
  • Created process chains for all teh master and transaction data loads and scheduled them as per teh 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 teh 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 with data stage.
  • Worked on teh customization of teh cubes as per teh new business. Worked on teh functional testing of teh new development as per teh requirements of teh 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 teh data in PSA before loading them into data targets.
  • Facilitate integration and user acceptance testing of teh 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

SAP BI Consultant

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 with data stage.
  • Enhanced teh 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 teh 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 with excellent interpersonal skills. Exceptional ability to quickly master in new concepts and technologies.
  • Extensively worked on BI Testing(MQC)
  • Handling teh team and involving in teh issues countered by teh users.
  • Involving in teh Resolving teh issues in teh reports. Designed teh Multi provider to pull teh Data from different cubes
  • Monitoring teh daily loads.
  • Worked on teh customization of teh cubes as per teh new business. Worked on teh functional testing of teh new development as per teh requirements of teh customer
  • Suggested teh process improvements to stabilize teh system by way of monitoring teh loads by being Pro-Active rather then 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 teh 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 with 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 teh 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 teh master data attribute value to reflect into teh cube.
  • Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
  • Handled tickets with different priority and never missed teh 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 teh error records in teh error stack and uploaded these records by using error dtp.

Confidential

Environment: SAP BW 3.1C

BW Consultant

Responsibilities:

  • Involved in Load Monitoring Using RSPC, RSMO, SM37, and SM50.
  • Handled teh tickets of priority S1, S2 and S3 by following (SOP) Standard Operating Procedures and never missed teh (SLA) Service Level Agreement.
  • Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report, Time sheet maintenance of teh support team.
  • Supported teh client by providing long-term solutions to teh tickets by doing Root cause Analysis.
  • Maintain list of all teh activities for all teh tickets until it is closed down.
  • Involved in Validated data consistency in reporting with 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 teh reasons for frequent failures of info packages.
  • Maintaining Reconciliation’s to verify teh data in SAP R/3 and SAP BW are same or not after teh data loads. Maintaining teh queue - related to teh 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

Hire Now