Sr. Sap Bi Consultant Resume
Indianapolis, IN
PROFESSIONAL SUMMARY:
- 9+ years of strong of SAP Business Intelligenc, Data Warehousing experience in SAP Business Objects 4.1, X1R3, XIR2/6.x/5.x (Information Design Tool, BI Launchpad, Desktop Intelligence, Business Objects Developer Suite, Web Intelligence XIR2/ 6.x/ 2.x, Broadcast Agent) and Business Warehouse experience.
- Experience in all phases of Full life - cycle implementation including Gap analysis, Functional and Technical implementation, Development, Performance tuning, testing, documentation and support.
- Involved in full-life cycle BW implementations, including upgrade from 3.x to 7.x, Enhancements and full life cycle implementations in Business objects XI 3.1 and BI 4.0, 4.1.
- Design & Creation of HANA Calculation views, Hierarchies. Analytics Privileges. Attribute Mapping, Calculated Attributes. Currency as Unit of Measure, Comparing Object Versions,Export/Import of Models.
- Extensively worked with SAP HANA modeler studio with data provisioning (SLT, Data services) various views and SAP Hana information composer to upload customer flat file data into SAP Hana database, loading data from tables in HANA Database to BW data marts.
- Worked on Importing BW Models into HANA
- Expertise in automating loads using Process chains, scheduling delta loads, monitoring data loads, PSA maintenance and de-bugging data load errors.
- Expertise in BW Performance Tuning: Experience in Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing of info cubes and use of statistics for the same.
- Expertise in planning, designing, developing, distributing and maintaining Universes.
- Expertise delivering Webi reports using various data presentation techniques like Tables (Vertical, Horizontal, Cross Tab and Forms), Charts/Maps, Grouping, Filters, Conditional alerts, Ranking, Sorting, Drill down with Slice and Dice, Sections, Breaks, Formulae and Variables.
- Extensively used Web Intelligence, BI Launchpad for querying, reporting and analysis tasks.
- Created multiple reports using Analysis for Microsoft Excel
- Involved with a team in creating Dashboards using various visual analytics, themes to meet corporate standards using XCelsius.
- Created multiple Crystal and Web Intelligence reports and transformed into a single dashboard using Xcelsius.
- Generated Xcelsius Dashboards using SAP Business Objects Live Office and Query as a Web Service (QaaS) as Data Sources.
- Experience using data visualization tools such as SAP Lumira, Design Studio
- Used the Bex Query Designer and the Bex Analyzer to run and modify the existing Bex queries
- Used Broadcast Agent for scheduling and batch processing of Business Objects and Web intelligence document.
- Very good experience in both developing as well as testing of OLTP Business intelligence applications.
- Excellent Performance tuning technique from Business Objects and Database perspective.
- Implemented row level and object level security using the Business objects tool.
- Strong testing and debugging skills and strategies to extract data from different source systems.
- Experience in Import wizard & publisher for migrating reports & universes.
- Worked with complex scheduling features in CMC including calendars and event based scheduling.
- Strong experience in SAP Business Objects Administration/ CMC to create and manage the Users and Groups, applications, Security and rights to the Users.
- Expertise in resolving fan traps and chasm traps using aliases and contexts in Universes.
- Experience in creating complex filters such as pre-defined conditions, report filters, prompts and drill filters.
- Providing User-based training to all corporate customers about creating their own Adhoc reports.
TECHNICAL SKILLS:
DSS/OLAP Tool: SAP BW 7.4 on HANA, 7.3, SAP BI 7.0 in Nw2004’s, BW 3.5, 4.0,Business Objects 4.0, Business Objects 5.x/6.x/XI.x, CMC / Supervisor, CCM, Designer, Full Client / Desk-I, Web Intelligence, BCA, ZABO, BO Auditor 1.0 & BO SDK. Crystal Reports /XI/2008, Business View Manager, Crystal, Xcelsius, Data Insight, Infoburst, Nvision reports and Analysis for Office.
Databases: Oracle: Oracle 7.x/8.x/9.x/10g/11g,MS SQL, SQL Server 2000/2005, MySQL, MS Access 2003, SAP BW,SAP HANA, PeopleSoft
Operating Systems: Windows 9.x/2000/NT/XP/2003
Programming Languages: SQL, T-SQL, PL/SQL,C
PROFESSIONAL EXPERIENCE:
Confidential, Indianapolis, IN
Sr. SAP BI Consultant
Responsibilities:
- Involved in Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
- Worked closely with SME's, functional specialists and process owners to gather detailed business requirements and translated the requirements into robust reporting solutions
- Translates user requirements into Hana Data Models.
- Directely read the Data from ECC into SAP HANA and build universes and reports
- Migrated HANA content from development, testing environment to Production environment using delivery units
- Developed BI approach and strategy document
- Conducted BI reporting ( BO/WEBI,Crystal and Lumira) features workshop with business users.
- Design Complex Universe using IDT against Multiple data sources and ECC
- Created LCM Jobs to promote Universe/Reports/Users/Roles to UAT
- Developed different WEBI reports against Universe, Crystal Reports 2013 and Crystal Reports for Enterprise 4.X, Universe Designer, and Information Designer Tool.
Environment: SAP BOBJ 4.2 SP2, Analysis Office for OLAP, 2.3, WEBI, Lumira, and Design Studio, Crystal Report,2013, Crystal Reports Enterprise, Information Design Tool, ECC 6.0. HANA LCM and HANA 1.2
Confidential, Indianapolis, IN
Sr. SAP BOBJ Consultant
Responsibilities:
- Interacted with the management and business decision makers to identify business requirements.
- Analyzed existing UNV and UNX universes and created BEx queries
- Used Information Design Tool (IDT) to create connections to SAP HANA database and non SAP database, created data foundations and created Business layer and published these connections and layers to Repository.
- Used Information Design Tool to create Relational Connection, Data Foundation and Business Layer and accessed the data in HANA through, BOBJ Dashboard Design, BOBJ Web Intelligence (Webi),.
- Created reports by connecting to IMCE from SAP Lumira, SAP Business Objects Explorer (BEx)
- Converted existing WebI reports into Analysis for Office, Design Studio, Lumira. WebI
- Piloted a POC utilizing SAP Lumira by showcasing the functionalities and visualizations that can be leveraged.
- Showcased the power and functionality of GeoMapping in Lumira.
- Increased the performance of BOBJ CMC and configured BOBJ servers.
- Created users and groups and have assigned access levels to them.
Environment: SAP BOBJ 4.2 SP4,, BW on HANA 7.4 and 7.5, BEx 3.5, SAP BEX 7.3 Workbooks, Analysis Office, 2.3, WEBI, Lumira, and Design Studio.
Confidential - Jersey City, NJ
Sr. SAP BOBJ Consultant
Responsibilities:
- Interacting with report users and Business Analysts to understand and document the requirements and translate these to Technical Specifications for Business Object Reports
- Involved through all phases of Requirements Gathering, Gap Analysis, Blue printing, Functional/Technical Specs, Development, Go-live, rollout and post implementation support of SAPBI in APO, COPA, FI,Implemented according to SAP
- Experience in FI- Core Finance, GL, AR, AP, Taxation with Taxware across different locations
- Worked on functional areas like treasury, banking files, month end process, cost center, internal order
- Hands on experience in cash and liquidity Management,
- Hands on experience in Banking, customer cash application, outgoing payment processing
- Provide solutions for converting and creating SAP AO reports in production system
- Created 20 Analysis office reports in Dev and moved to quality and production.
- Support activities for current production environment and monitoring scheduled instances
- Created four visualizations using different KPI’s also created dataset SALES ORDER ITEM ANALYSIS and uploaded to SAP Lumira cloud to share with other users.
- Developed confidential proprietary analytical tools and reports with Microsoft Excel, and POWER Pivot, and POWER Point
Environment: SAP BOBJ 4.1 SP6.6 SAP BOE 3.1 SP6.2, BW 7.0, BW on HANA 7.4 and 7.5, BEx 3.5, SAP BEX 7.3 Workbooks, Analysis Office 1.4, 2.3, WEBI, Lumira,Tableau 9 and Power BI
Confidential- New York, NY
SAP BW BOBJ Consultant
Responsibilities:
- Migrated Content from 3.1 SP 6.2 (windows) to 4.1 SP6.1 (UNIX) landscape using upgrade management tool
- Migrated over 80 Crystal Reports built on CR2008 (BW Query Driver) to Crystal Reports for Enterprise (BICS/OLAP connectivity)
- Converted over 40 Crystal Reports built on CR 2008 BW Query Driver to CR 2013 BW MDX driver
- Created publications on Crystal Enterprise and CR 2013, to deliver store based reports, and using windows batch files and shell scripts (Using developed BOBJ SDK)
- Created Webi reports based on Bex Queries as replacements for Analysis for Office workbooks (BEX 3.5 workbooks) and scheduled through CMC
- Performance tuning Of Crystal Reports 2013 (MDX Query Driver) and Crystal Enterprise (BICS connection)
- Applied notes for Crystal Enterprise Issues with BICS DSL configurations
- Change existing Bex Queries to work with Crystal Reports for Enterprise. Change Bex Queries and Crystal Reports based on changes from business inputs
- Migrated over 20 BEx 3.5 based workbooks to Analysis Office 2.1
- Created schedules for multiple AO documents in BOBJ using BICS SSO
- Created Tableau documents as sample with SAP Netweaver platform (MDX) and HANA database (HANA ODBC) as sources
- Create documentation on migration, upgrade applying notes, maintain issue logs for the central team
- Support activities for current production environment and monitoring scheduled instances
- Developed Lumira dataset, acquired data, prepare data, cleanse data, created Story and visualization by using Lumira
- QlikView designing and modeling using multiple data sources relational designs
- Given Qlikview POC to the client.
Environment: SAP BOBI 4.1 SP6.6 SAP BOE 3.1 SP6.2, BW 7.0, BW on HANA 7.4, Crystal Reports 2008, 2013 and Enterprise, BEx 3.5 Workbooks, Analysis Office 2.2, Lumira, Design Studio 1.5,Tableau 9 and Qlikview 12.0
Confidential, San Antonio, TX
BW BOBJ HANA Consultant
Responsibilities:
- Interacted with the management and business decision makers to identify business requirements.
- Customized the Existing and created new Info objects, info cubes, DSO’s as per the business needs.
- Involved in creation of Data Sources, Info Sources and PSA for Data Extraction, Transformation and Loading from SAP R/3 system to SAP BW.
- Created complete new Transfer Structure, Update Rules, Data sources, Info sources, Info packages for all new added Cubes, ODS.
- Responsible for writing look-ups in start end and field routine in transformations in order to populate data.
- Architected, created and published complex WEBI 4.0 Reports to BI Launch pad (Extensively used Sliceand Dice, Sorting, Hierarchies, Drill Down, Filter, Calculation, Prompts, Charts, Formulas, Aggregation and Formatting).
- Integrated HANA with Business Objects using BO Data Services (BODS).
- Extensively worked on HANA studio Modeling and other prospective.
- Created HANA views based on SAP BW DSO and Info cubes in SAP HANA Studio.
- Also created Attribute views, Analytical views and Calculation views using SAP and non-SAP data sourcesand handled End to end reporting for HANA by creating universe, connection, data foundation and business layer.
- Used Restricted and Calculated Key Figures, Formulas, Variables, and Customer Exit Variables in the Query Designer.
- Responsible for SAP Dashboards using SAP Design Studio 1.5.
- Involved in developing Pilots for SAP BO Explorer, Design Studio and Analysis tools and given presentations to explain the abilities and capabilities of these powerful tools.
- Responsible for BEx queries for Xcelsius and WEBI reports using BICS in WEBI Rich client to meet user requirements.
- Used Open Docs to allow users to move from the Dashboard to its related detailed WEBI reports and Analysis for Office documents.
- Worked on Performance improvements for the earlier created Xcelsius Dashboards. Followed Best Principles and made some major changes and successfully reduced Dashboard load time.
- Worked with business users to finalize mockups and guided technical team with best practices for development.
- Designed, developed & tested complex Business Objects Universes by using Hierarchies, Aggregate Awareness, Contexts, Pre-Defined Conditions, Cascading Prompts, Outer Joins & Complex metrics.
- Identified the extractors on the R/3 OLTP systems and defined the Transfer structures on the source and target systems. Created BW components like Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions
- Used SAP BW for DataStage to extract, transform and load (ETL) the data from various data sources FI/CO, SD, MM, and HR including the legacy systems and developed reports.
- Experienced with enterprise-wide data modeling, database design, and building data structures and data mapping routines in SAP BW to support the data and reporting requirements for all areas of the organization
Environment: SAP Business Objects 4.0 -SAP Business Objects Explorer, SAP Dashboard 4.0 (Xcelsius 2008), SAP Design Studio, 1.5, Microsoft Sql-Server 2008, SAP HANA, SAP HANA ONE (HANA on Amazon aws), SAP ECC, SAP BW on HANA, SAP BW7.3, Visio and Microsoft Office, LCM and CMC
Confidential - Atlanta, GA
BI/ Business Objects Developer
Responsibilities:
- Created transports and collected the required objects from transport connection tool in proper transport sequence to move objects to other target BW systems.
- Resolved transports warnings and failures by analyzing errors in the transport logs.
- Designed and created process chains to automate data loads. Scheduled process chains based on Event trigger, Meta chains.
- Compressed Sales Orders and Billing cubes to improve query performance.
- Created centralized Repository with all three domains (security, universe and document) and distributed the BO Main key among the enterprise.
- Defined Joins and Cardinalities on tables manually in the universe and created Classes and Objects as per requirements.
- Worked in creation of multiple universe and document domains for development, test and production Environments.
- Worked on Teradata SQL tool to analyze the Teradata SQL and resolve the complex joins causing errors
- Created users, groups and assigned roles, privileges and also set row level and object level securities to different users and groups using Supervisor module.
- Good experience in creating and maintaining Secured, Shared and Personal connections.
- Involved in designing and developing of Universe for reports generation.
- Checked the integrity function for existence of loops and resolved them by using aliases and contexts.
- Involved in the performance tuning of the SQL queries by restructuring the Joins, creation of indexes etc.
- Manipulated the data by creating user defined objects using advanced database functions.
- Involved in setting up of Aggregate awareness to enhance the performance of SQL transactions.
- Created the Reports using the universes as the main Data providers and writing the complex queries including Sub Queries, Unions.
- Trained users to Use Crystal Reports, Modify and enhance Crystal Reports, Save Crystal Reports.
- Have interacted with SAP to improve on the component features of their Dashboard and Design Studio version by testing the Tools against other Reporting Tools and help them improve on the component functionality and also in improving the performance of the tool.
- Re-Create an existing Non SAP Dashboard in Design Studio v1.3 & SAP BI 4.1 Dashboards.
- Formatting the Reports based on the user requirements using all the functionalities in Business objects like Slice and Dice, Drill Down, Alerter, User response, and Formulas etc.
- Developed complex reports using @Functions like @Prompt (for user defined queries), @Where (for creating conditional filters), @Select and Cross Tab tables.
- Created Master Detail and Cross Tab reports to view the data in an analyzed way and Hierarchies to provide the drill down functionality to end-users.
- Created Full Client reports using different Data providers like Oracle, Excel sheets, SQL server.
- Created report level contexts in Web Intelligence and Desktop Intelligence reports.
- Used Broadcast Agent for scheduling and distributing the documents.
- Gave my thoughts and ideas to the data-modeling team in designing a new data mart for future reporting applications.
- Trained business users in creating web intelligence reports.
Environment: Business Objects 6.5.1,X1R2(Supervisor, Designer, Reporter),Web Intelligence 6x,Design Studio, Broad Cast Agent, ZABO, Crystal 9, Oracle 9i, MS SQL server 2000, Sybase 12.0,TOAD,ERWIN,Windows 2000/NT,UNIX.
Confidential, Northfield, IL
Business Objects Developer
Responsibilities:
- Worked with the Business Objects 4.0 including BI Launchpad, Dashboards 4.0, Information Design Tool, and WEBI Rich Client.
- Installed SAP Business Objects 4.0 client tools (WEBI rich client, Information design tool, upgrade management tool).
- Installed Crystal Reports 9 and Crystal reports 2011.
- Used Crystal Management Console for scheduling the reports which are saved in different format like Excel and PDF Format and then e-mailed to the Users.
- Migrated crystal reports from Crystal Reports 9 to Crystal Reports 2011 and validated them.
- Published the migrated crystal reports to the BI Launchpad.
- Scheduling the migrated crystal reports using BI Launchpad and emailed to the end users.
- Migrated all the reports from BO XIR2 to SAP BO 3.1 and SAP BO 4.0 using Import Wizard tool.
- Developed the universes using the Information Design Tool of BO 4.0 and published them.
- Created universes based on multiple data sources in the Information Design Tool.
- Created and maintained Secured, Shared and Personal connections according to the Security level required.
- Resolved the loops using Aliases and contexts and checked the Integrity of the Universes.
- Created various classes and objects with different object qualifications such as measure, dimension and detail objects.
- Created complex reports using cascading prompts, variables and calculation context.
- Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies, Strategies.
- Converted the universes from BO 3.1 to BO 4.0 and published them.
- Generated SAP Business Objects Reports involving complex Queries, SubQueries, Unions and Intersection.
- Created the Web Intelligence reports using the BI Launchpad and WEBI Rich Client using Universes as the data providers.
- Used various functionalities like Breaks, Sections, Sorts, Alerters, Variables, and Formulas in creation of Web Intelligence reports.
- Involved in creation of Reports, Formatting reports, generation of charts, as per user requirements
- Created Complex Reports such as linking of Two Reports, Drill Down and Drill Up.
- Used the filters such as the Query filters, prompts and the report filters in the WEBI reports.
- Created reports involving complex queries, union, intersections and subqueries.
- Created different types of charts such as pie chart for easier analysis of the data.
- Generated complex Dashboards using Live Office and Query as a web service as Datasources.
- Generated complex Dashboards using the crystal Xcelsius.
- Provided support for the IT team members for using the BI Launchpad and Universe development in the Information Design Tool.
- Implemented the row-level and the object-level security as per the user requirement.
- Created Users and Groups and assigned access levels to BO content as well as applications.
Environment: SAP Business Objects XIR4.0, XIR3.1, CMC, Information Design Tool, Web Intelligence, BI Launchpad, Design Studio, ECC 6.0, Crystal Reports 2011, Crystal Reports 9.0, Oracle 10g,SAS, MS SQL Server 2005, Windows 7.
Confidential - Chicago, IL
Business Objects Consultant
Responsibilities:
- Configured Web Intelligence using Configuration tool.
- Responsible for setting up the Users/Groups, database connections, assigning privileges to the users using Supervisor.
- Assigned Broadcast Agent to various groups using Web I Admin Console.
- Defined categories of documents for different level of groups.
- Involved in gathering functional requirements from the business users.
- Design and Development of Universes, which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
- Generation of Xcelsius Dashboards using SAP Business Objects Live Office and Query as a Web Service as Data Sources.
- Defined Joins and Cardinalities on tables manually in the universe and created Classes and Objects as per requirements.
- Created derived tables to reduce the complexity of the universes and also created prompts to force the users to restrict the data in the process of building the universes.
- Involved in the troubleshooting of universe schema with Loops, Chasm and Fan traps and Cardinality problems by creating Aliases and Contexts as required.
- Exported and Imported Universes to and from CMS.
- Created custom List of Values (LOVs) for better understanding of prompts by the end user.
- Created Adhoc and Canned reports and fine tuning them for faster execution.
- Created custom Hierarchies to support drill down functionality for in depth analysis.
- Extensively used Calculations, Variables, Breaks, Slice and Dice and Alerts for creating Business Objects reports.
- Linked Universes to share the common components using Kernel and Component approach.
- Generated complex reports using the various data Providers like Universes, Personal Data Files and Free Hand SQL.
- Created some of the reports using Crystal reports and created Xcelsius dashboards.
- Used Teradata Specific parameters at data foundation layer to increase the performance Worked on various Data Integrator jobs to change the current mapping of the existing tables or adding new table in the database creating data flow for them
- Used Crystal Reports for sales tracking and billing purposes.
- Involved in day-to-day Business Objects Server maintenance.
- Optimized systems with load balancing with distributing components on different servers.
- Created users/groups and defined privileges using Central Management Console. Migrating Business Objects 6.5 version reports to new version XIR2 and X1R3.
- Converted the existing full client reports to WebI reports using Report Conversion Tool.
- Imported existing users, groups, categories, WebI documents, connections, universes and restrictions to BO XI environment.
- Actively involved in giving demos to the users and prospective users about the functionality available in Business Objects.
Environment: Business Objects 6.5.1, PL/SQL, Crystal Reports XI, Web Intelligence, BI Launchpad, and ECC 6.0
Confidential, San Diego, CA
Business Object Developer
Responsibilities:
- Responsible for Designing the Universe. Created Aliases and Contexts for resolving the loops to increase the performance.
- Extensively used filters, conditions, LOV’s and calculations in DeskI and WebI.
- Linked the Universes to share common objects. Updated and maintained Universes based on changing user rents and data source changes.
- Created different types of reports such as master /detail cross tab and charts.
- Created complex reports using user defined functions, condition objects and use aggregate awareness , short-cut join functions for Query performance enhancement.
- Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis.
- Worked extensively on Dashboards and scoreboards while developing the reports.
- Created reports using Performance Manager .
- Created report development using Crystal Reports and Xcelsius.
- Created cross-tab, conditional, drill-down, Charts and sub reports using Crystal Reports.
- Applied Oracle hints, Aggregate awareness, Object Hierarchies, Query optimization, linking for the Universes.
- Developed & Tested complex reports (combining data from multiple Data Sources) for various groups and published them to the Corporate Documents. Developed complicated reports like Orders by Customer/Product/Region, Billing Booking & Backlog reports, Revenue & Commission reports.
- Configured Broadcast Agent/Scheduler for scheduling the reports and accessing the reports through thin client.
- Experience in writing stored procedures using PL/SQL to validate reports.
- Exported the Business Objects reports to WebI to be viewed by all users on the Internet.
- Part of the team for implementing and testing of reports from Business Objects 6.5 to Business Objects XI R2.
Environment: Business Objects 6.5.1, XIR2 (Supervisor, Designer, DeskI, Reporter, Web Intelligence and Infoview), oracle 10g, Toad, Informatica, PL/SQL, Crystal Reports XI, Oracle 9i.
Confidential, Lakeland, FL
Business Object Developer
Responsibilities:
- Interacting with report users and Business Analysts to understand and document the requirements and translate these to Technical Specifications for Designing Universes and Business Object Reports.
- Developed Business Object Universes using Designer and Business Objects for the reporting solution for Operational reporting system.
- Potential usage of alias, context, and shortcut join concepts to overcome the loops.
- Created reports that limit the reports to display information for particular measures by designing complex Filters.
- Created reports like, Reports by Category, Reports by Plan, and Reports by Time (Year, Quarter, and Month Date).
- Created complex reports like Master Detail and Cross Tab reports to view and analyze the data.
- Developed Adhoc reports using Business Objects.
- Formatted Reports as per the user requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
- Involved in Importing/Exporting the Universes to repository to make available to the end user.
- Used Web Intelligence for web based query and reporting and published reports.
- Extensively used Calculations, Break points, Drill down, Slice and Dice, @Functions and Formulas, Filters & Alerts for creating Complex reports.
- Used the Broadcast Agent for Scheduling and monitoring the reports. Validation of the data by creating different test reports on warehouse tables and on base tables.
- Tested the report data, performance of data retrieval against the Warehouse data with TOAD.
Environment: Business Objects Designer 6.5.1, Business Objects Reporter 6.5.1, Web Intelligence 6.5.1, TOAD, ZABO, Broadcast Agent, Dashboard Manager, Oracle 9i, SQL, PL/SQL, SQL*PLUS, Windows XP.
Confidential
BW Consultant
- Implemented new concepts and technologies that are available in the Data Warehousing Workbench for process design and modeling data.
- Created Data Transfer Process (DTP) to transfer data within BI from one persistent object to another object.
- Enhanced Info cube with Remodeling concept to make changes, without having to reload data.
- Used Direct Update DSO in the process of APD (Analysis Process Designer).
- Executed Adhoc query analysis using Web Analyzer.
- Used Write-Optimized DSO (Data Store Object) to load data into BI system.
- Worked extensively on Repartitioning of info cube.
- Extracted data from SD, MM and FI/CO modules of SAP R/3 and from flat files into SAP BI system using Business Content and LO Extractors.
- Loaded Sales data into Cube(0SD C03) Using the following Extractors
- Used Delta Update process for loading the data to BI from R/3 in specific intervals.
- Used Real time Data Acquisition DTP(RDA) to load data from PSA
Environment: SAP BI 7.0 R/3 ECC 5.0