We provide IT Staff Augmentation Services!

Sap Bi Resume Profile

CT

PROFESSIONAL SUMMARY:

  • Experienced in BI-IP Integrated Planning tool development of Real time Info cubes, Multiproviders, aggregation levels, filters, planning functions, planning sequences Input ready queries and variables.
  • Hands-on BI IP solution expertise, with ability to design in the BI IP Planning objects.
  • Having 9 years of experience in SAP Net weaver BI 7.X / BW 3.5 , SAP Business Objects 4.0, 4.1 IDT, UDT, WEBI, Dashboards for implementation, development, support projects for USA, Europe customers Hands on Experience in SAP HANA 1.0 data modeling.
  • Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training.
  • Worked on SAP HANA 1.0 data modeling areas like Creation of Analytic, attribute, calculation views, packages, schemas, data provisioning, users roles management, SQL Joins, transformation capabilities, filters, SLT replication and Objects migration from BW on RDBMS to BW on HANA.
  • Modeling Excellent working knowledge of data warehouse concepts and extensive experience in BW Architecture, Extended Star-Schema, Data Flow Strategy, Defining Dimensions, Info cube, Multi-Provider, Info-Sets, Data Source, Info-Source, Info-Objects, PSA and DSO.
  • Having experience on BW related ABAP by writing Start routines, End Routines, Field Routines, Customer Exits.
  • Having experience on LO Cockpit extraction and standard data source enhancement, developing the generic extractors using Table, View, and Function Modules.
  • Gathered and analyzed Functional reporting requirements to derive best fit dataflow model.
  • Extraction of data from source systems like SAP Vistex, SAP R/3 FI, CO, HR, SRM,SD, MM, PP, Purchasing, CRM and Non SAP system I2Planning tool , CSV files into SAP BW System.
  • Created custom COPA data sources, BW data flows for extracting actual plan line items data based on segment level tables.
  • Experienced in performance tuning Query Data Load : Aggregation, Compression, Roll Up, BIA Indexes, and Secondary Indexes on DSOs.
  • Created report to report interfaces, broadcasting the BEx reports and work books.
  • Actively and regularly involved in loads of master data and transaction data of Daily, weekly, and Monthly, Data Loads using Process Chains and Control M tool.
  • Involved in importing the transport requests TR from Dev to QA environment as a part of transport management.
  • Extensively worked on BICS connection, OLAP universes, WEBI reports, Dash Boards, scheduling reports using SAP BO IDT, UDT, WEBI, Info View, BI Launch Pad .
  • Expertise in creating Dashboards using Xcelsius 2008 tool using Live Office connections.
  • Created SQL stored procedures against OLTP systems in DB2, and formatted in Crystal reports 2008 and 2011..
  • Expertise in writing and conduct the Unit, Integration, Regression, and UAT of the BI/ BW dataflow and reports, Updated defect status in HPQC.
  • Preparing the end user training documents and ensuring the Quality of the deliverable products.

Experience Profile:

Confidential

Role : Sr. Techno Functional Consultant.

Environment : SAP BW 7.4, SAP BOBJ 4.1 and SAP HANA.

Contribution:

  • Experience with SAP HANA Data Provisioning and using SAP LT and DXC Replication Server.
  • Created HANA Modeling objects Attribute Views, Analytical Views and calculated Views on BW-HANA system using HANA Meddler.
  • More familiar with SPO's and Query Pruning logic.
  • Extensive experience on BW 7.4 Migration from RDBMS to HANA Data Base.
  • Expert in understanding of complete architecture Data loading, Data modeling Reporting .
  • Gathered and analyzed Functional reporting requirements to derive best fit dataflow model.
  • Preparing the Design Documents like FS's, MDD's and reviewing the TDD's written by the developer.
  • Expertise in functional areas like SAP CRM, SD, MM, FI GL, CO-PA.
  • Responsible for leading off-shore team form Infosys in delivering solution to our customer McKesson Client.
  • Experience with SAP HANA Data Provisioning for data extraction from SAP ECC, SAP Visstex, SAP CRM, SAP BW on HANA Data Base and Flat Files accessed through BODS.
  • Application of HANA In-Memory concepts.
  • Leverage knowledge of data warehouse and software development methodologies SAP SCRUM to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines.
  • Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool
  • Hands on experience in HANA modeling. Created multiple schemas and table definitions.
  • Expertise in Creating Web Intelligence Reports using SAP Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
  • Scheduled and published reports using CMC and Info view.
  • Preparing the end user training documents and ensuring the Quality of the deliverable products.

Confidential

Role : Sr.Technical Consultant.

Environment : SAP BW 7.3, SAP BOBJ and SAP HANA.

Contribution:

  • Exclusively Used BICS connection for developing Webi and Dashboard reports.
  • Created HANA Modeling objects Attribute Views, Analytical Views and calculated Views on BW-HANA system using HANA Meddler.
  • Experience of front end tools Web Application Designer, Query Designer, BEx analyser.
  • Created process chains to load the master data and transaction data into the targets.
  • Experience of front end tools Web Application Designer, Query Designer, BEx analyser.
  • Created process chains to load the master data and transaction data into the targets.
  • Developed data flow for plan and actual data for COPA in SAP BW system
  • Created various custom queries like Sales analysis report for YTD, MTD, and QTD, Sales analysis for Actual Vs Plan, Inventory actual Vs plan/Estimate, Balance sheet report, and AR comparison reports.
  • Preparing the Design Documents like HLD's, TDD's, TC's and reviewing the test cases written by the tester.
  • Expert in understanding of complete architecture Data loading, Data modeling Reporting
  • Expertise in functional areas like FI GL, AP, AR, and CO-PA.
  • Extracted data consistently into the BW system for the line items in G/L accounting FI-GL , accounts receivable accounting FI AR and accounts payable accounting FI AP by using 0FI GL 4, 0FI AR 4, 0FI AP 4 and for cost allocation 0CO OM CCA 9, 0CO OM CCA 1 to load actual and plan data based on cost center expenses.
  • Used SSIS sequel server integration system to fetch the transaction data from FIM Fountain information management in to BW system and DHT Data Harmonization Tool for master data.
  • Created generic data sources based on Custom tables and function modules.
  • Worked extensively on Data warehouse workbench RSA1 and customized Info Objects, Info Cubes, DSOs, transformations, DTP's, Info sets and Multi providers.
  • Worked on start routine, end routine and transformation routine by using ABAP.
  • Created custom costing based COPA data sources 1 COPA CHS, ZDS COPA Plan on COPA segment level tables, Line Items.
  • Created COPA reports like Value added COGS, P L reports, COPA Report by profit center, COPA detailed reports, COPA Report for reconciliation etc using BEx Query designer
  • Worked in SAP BW/BI integration with SAP Business Objects and created Universes/Reports on top of BEx Queries.
  • Worked in SAP BW/BI integration with SAP Business Objects and created Universes/Reports on top of BEx Queries info cubes.
  • Experience with SAP HANA Data Provisioning and using SAP LT Replication Server SLT .
  • Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool
  • Hands on experience in HANA modeling. Created multiple schemas and table definitions.
  • Expertise in Creating Web Intelligence Reports using SAP Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
  • Scheduled and Published reports using CMC and Info view.

Confidential

Role : Technical Consultant

Environment : SAP BI 7.2, ABAP/4 and SAP BOBJ

Contribution:

  • Business Area worked FI CFP, FSL, RI , FICO.
  • Worked with SAP R/3/ECC Reinsurance RI , Finance Sub Ledger FSL in loading FI data.
  • Installation of standard BI content Info cube0FI C03, 0IC C03, 3FI GL 04, 3FI GL 06 etc.
  • Worked extensively on modeling objects like Info Objects, Info Cubes, DSOs, Info sets and Multi providers.
  • Worked on different types of Data Store Objects DSO like Standard DSO, Write optimized DSO and Direct Update DSO.
  • Used Standard DSO to stage the data before transferring to the Info Cube.
  • Involved in Building the CO-PA DSO ZCOPA O50 , CO-PA Cube ZCOPA C50 and generating the CO-PA Data Source 1 CO PA 1000.
  • Extensively involved in enhancing Master Data sources as well as Transaction Data sources
  • Involved in performance tuning like Creation of aggregates, compression of Info cubes, Creation BIA indexes to improve the Query response.
  • Extensively involved in creating a BEx Reports Global Position Query where I used Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure, Customer Exit, and Used Variables with User Entry/Default Value.
  • Developed KPI Webi Reports on top of universe and Bex Quries.
  • Developed using Universe Designer, Web Intelligence and Multisource universe in Information Design Tool.
  • Modeling Planning Applications using SAP BI Integrated Planning IP .
  • Created Web Planning Layouts in BI-IP using Input Ready Query and Web Application Designer
  • Analyzed different data connectivity that can be used in connection to BOBJ Enterprise like QAAWS, Live Office, BI Web Services, and BEx Queries/Business Intelligence Connection Services and presented the Mockups explaining the Pros and Cons each data connectivity has.
  • Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values LOVS , local variables, Alerts, Ranking and multiple data providers, sections, breaks, drill down reports and hyperlinked reports.
  • Used multi value components like line charts, bar charts, stacked column charts and combination charts, and single value components like gauge, slider, dial and progress bars in the development of the Dashboards.
  • Developed KPI Webi Reports on top of universe and Bex Queries. Created Dashboards using SAP Design Studio by connecting to BEx queries.
  • Created Crystal reports using parameters for filtering the record output.
  • Applied the Sorting and Sort control to the reports for making more meaningful.
  • Used the basic formulas in Crystal reports with applying Boolean formula, String manipulations, numeric formulas and If-Then- Else formulas.

Confidential

Role : Technical Lead

Environment : SAP BI 7.0 and BO 3.x, SD, MM, FI, FICO.

Contribution:

  • Involved in performance tuning like Creation of aggregates, compression of Info cubes, Creation BIA indexes to improve the Query response.
  • Created RRI from high level report to detailed level reports.
  • Ability to build process chains for any IP Planning functions / Sequences / Data loads.
  • Good at writing FOX functions and ABAP user-exits - Good ABAP knowledge desired.
  • Extensively involved in activating the Business Content for Info cubes, DSOs Data Sources, Multi Providers as well as Created Custom Info cubes, DSOs, Multi providers Transformation from Data sources to DSO and DSO to Info cubes.
  • Replicated the standard data sources 2LIS 03 BX, 2LIS 03 BF, 2LIS 03 UM, 2LIS 02 HDR, 2LIS 02 ITEM etc in BI and enhancing standard Objects by writing Routines Start routine, End routine, Expert Routine and Object level routine
  • Experienced in BI-IP Integrated Planning tool development of Real time Info cubes, Multiproviders, aggregation levels, filters, planning functions, planning sequences Input ready queries and variables.
  • Created Info packages DTP's and scheduled them in order to load Master and Transactional data from SAP R/3 source system into BI.
  • Worked with PSA in monitoring the data transfer from source system into BI and used DSO to stage the data before transferring the DSO contents to the Info cube.
  • Extensively involved in creating a BEx Reports Global Position Query where I used Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure, Customer Exit, and Used Variables with User Entry/Default Value.

Accomplishments of Business Objects Skills:

  • Developed KPI Webi Reports by accessing universe and Bex Queries.
  • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
  • Designing Universes for various business needs and resolved Chasm trap, Fan traps using contexts Aliases.
  • Created objects like Dimensions, Details and Measures, which are logically grouped into Classes as per business requirements.
  • Created Hierarchies, complex objects using various functions such as select, prompt, where, aggregate aware in Universe.
  • Created pre defined filters and cascading prompts in Universe level.
  • Checked the integrity of the universe and exported the universe to repository.
  • Responsible for Migrating the Business Objects Universes/Reports across the Servers/Repositories Development to Testing, Testing to Production Servers using Import Wizard.
  • Created reports using multiple data providers such as Universes, Personal data Free Hand SQL, Excel files for Monthly and Quarterly basis using Desktop Intelligence and Web I XI R2.
  • Created various kinds of graphs, Charts and analyzed the data in charts using slice/dice, drill up/drill down.
  • Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice to develop the reports.

Confidential

Role : BW consultant

Environment : SAP BW 7.0, ECC 6.0, SCM, SD, MM

Contribution:

  • Business Areas worked SD MM.
  • Created a process chains in RSPC.
  • Handled the tickets of priority 1, 2 and 3 by following SOP Standard Operating Procedures and
  • Involved in load monitoring using RSPC, RSPCM, RSMO, SM37, and SM50, SM66, SM36.
  • Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
  • Understand the reason for the failures and find out quick solutions in real time and execute those to avoid the future failures for such cases, design and develop the solutions and never missed the SLA Service Level Agreement.
  • Involving in solving Customer Issues within SLA Service Level Agreement .
  • Created Meta process chains to load the master data and transaction data into the targets.
  • Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis.
  • Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
  • Maintaining Reconciliation's to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
  • Responsible for the Rev Track system in maintaining, creating Rev Tracks for the PGS area used in transports.
  • Involved in complete life-cycle implementation of SAP BW 7.0, which includes data modeling, data extraction, data loading, and Reporting and support activities.
  • Data Warehousing Workbench Experience in designing and maintaining Info Cubes,
  • DSO Data Store Objects , Transformation, DTP Data Transfer Process , Info
  • Objects, Multi providers an d Data Sources.
  • Worked with SAP R/3 Logistics LO and Hands On functional area like Sales distribution SAP SD MM .
  • Enhanced Data sources in R/3 by using LO Cockpit LBWE initialized the setup tables using Info sources 2LIS 13 VDKON for Billing Info cubes etc..,
  • Reporting created Custom Queries using Conditions, Exceptions, Variables Structures and created aggregates for frequently used queries and Proficient in designed BEX Query Designer, Structures, Exceptions, free characteristics, restricted key figures, calculated key figures, and different types of Variables with different processing types.

Hire Now