Consultant Profile - SAP BW / BOBJ Consultant

Candidate: 472010

Location: Indiana, USA

Title: SAP BW Consultant

Profile

• Over 8+ years of experience delivering SAP solutions for global clients
• Three Full life cycles in SAP BI / BW data warehouse and report development
• Three years experience in Business Objects Report Development
• Experienced interfacing with the customer to develop requirements, business process modeling and solutions.
• Provided training to end users on BI 7.0 BEx Analyzer
• Cross-functional module experience in SD, MM and FI-CO
• Experienced with Design, Coding, Testing, End User Acceptance lifecycle
• Experienced with Data Extraction, ETL, Data Sources, Data Load Management, Process Chains, Monitoring, Problem resolution, BW System Wide Performance Tuning, SAP WEBI report performance tuning expert.
• Experienced with Design, Coding and Testing of BW Reports using BEx Analyzer, BEx Browser, SAP Web Application Designer, BEx workbooks and BEx Broadcaster.
• Complete understanding of Software Development Life Cycle (SDLC) from Project Preparation and Go live and support.
• Used Universe Development Life Cycle (UDLC) to plan, design, build, distribute, and maintain universes.

Industries:

Retail, Financial, Pharmaceutical, Government, Technology

Functional Areas:

SD, MM, FI-CO, SCM, CRM, BW, CO-PA, LO

Methodologies:

SAP BW, SAP BO, CCNA, MCSE

Technical

Application

Development Tools:

BEx Analyzer, Web Application Designer, Net weaver, Crystal Reports (BO),SAP BOXI R3

Application

Packages:

SAP BO

SAP BI 7.0, SAP BW 3.5, SAP 3.1C, SAP 3.0B, SAP 3.0A, SAP 2.1C, SAP 2.0B.

Environments:

SAP ECC 6.0, SAP ECC 5.0, SAP 4.7, SAP 4.6C, SAP R/3

Modules:

MM, SD, FI, CO-PA, LO

Databases / DB

Tools:

Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 6.5/7.0/2000, MS Access 7.0/2000

Methodologies  /

Techniques

Data Modeling, Data Extraction, Reports, Cubes, DSO’s, Transforms, DTP’s, InfoSources, Business Content, InfoObjects

Programming

Languages:

ABAP/4, C/C++, Java, Visual Basic 6.0, SQL, SQL*Plus, PL/SQL

Industry: Retail Products

Duration:

21 months

Project Description/Scope: SAP R/3, BW 3.5, 7.0, MM, SD, FI, ABAP, BEx Analyzer

Role: SAP BI Consultant

Responsibilities / Deliverables:

• Responsible for requirement gathering and analysis of the business requirement that could be satisfied with SAP business content and created the necessary objects required.
• Worked on building the technical specifications for the requirements from the client.
• Worked on the MM module for extracting the data by using the custom data sources for the details analysis of the reports like PO line item report and Summary reports.
• Developed the custom DSO's like Goods receipt line items, Purchase document line items and PO line item details and used the standard and custom info objects.
• Worked on the enhancement of the GR/IR line item extractor and EDW purchase document item extractor for including the necessary fields from the standard tables like EKPO and EKKO and populated the fields by modifying the ABAP code for satisfying the requirement.
• Worked on the code in the functional module of the extractor to solve the issue related to the vales populating in the field used in the SA Summary report.
• Created and modified the necessary transfer rules, update rules and transformations between the DSO's and worked on the start routines and end routines in order to modify the data as per the requirement.
• Loaded the data into BI, using info packages by initializing the Full and Delta process. Loaded the data from flat files into BI system. Created DTPs and Error DTPs in BI to load and monitor the data into info providers.
• Worked on the reconciliation to check the data accuracy by comparing the data in ECC and BW.
• Analyzed the errors that occurred during the data loading and solved the issues for that occurred during the activation process of the objects.
• Performed the unit testing after the data has been loaded into the development and released the transports into the Quality after the success of the unit testing.
• Involved in transport collection and release of transports from Quality to production and worked with the basis team for successful release of the transports.
• Involved in solving the tickets in the production depending upon the priority level.
• Worked on monitoring of the process chains, analyzed and solved the frequently occurred errors.
• Worked on the Query designer for building the queries and generated thePO/ SA detail line report and PO/SA summary reports and embedded them into the workbooks.
• Worked on the performance tuning the queries by maintaining aggregates, indexes and compression on Info cubes.

• Achievements: Enhanced the Purchasing 12 month carryover operational analysis report and Customer directed supplier SA Detail line report by adding the info objects as per the requirement.
• Modified the Purchasing MPV finance Analysis and MPV operational and purchasing MPV management reports by adding the variables, restricted key figures and calculated key figures for the queries.
• Worked on the Total payment term analysis report and Sales summary report for populating the missing data in the fields.
• Reviewed all the reports and carried out the necessary modifications as per the requirement and also as per the convenience of the end user.
• Interacted with the end user and solved the issues that occurred during the end user testing and supported the team for releasing into the production successfully.

Industry: Financial

Duration:

24 months

Project Description/Scope: SAP ECC 6.0, SAP BI 7.0.1, Business Objects BOXI, Business Explorer, Web Application Designer (WAD)

Role: SAP BI Technical Consultant

Responsibilities / Deliverables:

• Activated business content in both 3.5 and 7.0 data flow for Master data and Transaction data. Used EHP 3 content in the areas like Check Register to enable reporting on PAYR tables. Used EHP3 content for AP, AR and GL areas.
• Activated data sources in ECC, CRM, SRM and LO cockpit scenarios. Created full, Init and Delta loads from Source systems.
• Created Generic data sources from views, function modules on Custom tables and Data domains.
• Used efficient methods like Function modules instead of user exits for Custom enhancements to data sources.
• Extracted and built hierarchies like Financial Statement items, cost centers, Material and Product and enabled reporting on them in the latest front end tools like Crystal reports using text and hierarchy variables.
• Developed custom Infocubes for material movement (quantity and value) like Goods receipts, returns and consignment stocks (vendor managed inventories and customer managed inventories) based on plant, storage location, material, material group, vendor and customer.
• Created complex data modeling structures using Start routines from multiple DSOs into single DSO. Used efficient methods like sort and binary search and updated into each individual characteristics using routines without accessing internal tables redundantly.
• Created crosswalk between AR and GL DSOs and enabled revenue source reporting.
• Created custom ODS to enable Grant CMIA reporting by enhancements from AP, AR and GL modules.
• Created budget report having Fund, Grant dimensions with aggregated and detail levels.
• Build Custom cubes for Department of Transportation and Development (DOTD), on Road, Bridge, Projects, LETS/STIP Data in PS module.
• Created  reports out of Custom PS Cubes like Project vs Fed Funding, DOTD Contingent liability Report, HPP Projects Let by districts, DOTD Accrued Unbilled Report, FHWA Reporting on Z-Tables, Highway Priority Program  in Crystal Reports.
• Designed and implemented a reporting solution for web reporting, information broadcasting, pre-calculated web templates and background scheduling.

Designed process chains for scheduled loads and enabled batch processing for various administration activities in the data ware housing system

Achievements:

• Full life cycle Implementation of Business objects was carried out successfully and integrated with SAP BI, by installing and configuring the SAP Integration Kit.
• Involved in the installation of Business Objects repository, creation of user Ids, implementation of security features and management of the repository.
• Involved in Scheduling and publishing reports in Crystal Enterprise Environment/ Business Objects Enterprise XI R3 Environment.
• Created formulas and store procedure and different Alerts based on the conditions.
• Developed advanced Xcelsius objects on concepts like What If Analysis, Dynamic Visibility, narratives, interactive charts, hierarchies.
• Created folders and User groups and applied security access restrictions as per the user roles through CMC. Integrated Crystal Xcelsius 2008 with Business Objects Enterprise XI 3.1.
• Involved in testing and fixing issues in Universes, Reports, Objects, Conditions and LOVs List of Values.
• Developed Ad hoc reports using Business Objects.
• Installed Business Objects in VMWARE and My SQL Database systems.
• Used SAP BI Integration Kit to connect Business Objects and SAP BI.
• Prepared Master queries by identifying common report requirements in each cube to enable Adhoc reporting on Universes and Webi reporting in Business Objects XI 3.1
• Involved in OLAP Universe life cycle management using SAP BI data sources.
• Worked on MDX query driver to build reports off of SAP BI cubes, ODS & published it to BO Enterprise.
• Developed complex queries and reports using different data providers in the same report.
• Created reports using Crystal Reports and also using Business Objects functionalities like Queries, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc
• Full training was given to the end users development team for the maintenance of the dashboard reports.
• Participated in business objects administration roles in central management console (CMC). Maintained severs of DEV, QA and PROD systems.

Industry: Technology

Duration:

12 months

Project Description/Scope: SAP BI 7.0, SAP ECC 6.0

Role: SAP Functional Consultant

Responsibilities / Deliverables:

• Attended all functional business workshops to gather the requirements and to analyses the gaps.
• Prepared the Business content and BI Strategy documents (Including Customer object standards, Extraction Strategy, Legacy Historical data Strategy, Reporting Strategy e.t.c).
• Designed and developed documents and reviews conducted time to time.
• Created the Functional and  technical design documents for OTC(Order to Cash), MTS(Make to Ship), PTP(Procure to Pay), ATR(Account to Report), HTR(Hire to Retire), DTB(Demand to Build).
• Data Logical flow documents created for the developers.

Achievements:

• Coordinated the entire developing process with the Offshore team (India).
• Conducted design reviews with the client for clarifications while developing.
• Installed SAP BW Technical content.
• Extracted data from the ECC system to BI. Created process chains on daily and as needed Loads.

Industry: Retail

Duration:

8 Months

Project Description / Scope: SAP BI 7.0, SAP ECC 6.0

Role: SAP BI Consultant

Responsibilities / Deliverables:

• Involved in extensive Onsite Support for the Client by coordinating with offshore team.
• Performed Daily Monitoring and Maintenance of Performance of Process chains.
• Performed Data load Monitoring and ongoing Maintenance.
• Identified Production problems, Issues. Suggested Fixes.
• Besides Production support Uploaded master and transactional data from flat file and SAP R/3 as the OLTP source.
• Created Info packages for initial, full and delta uploads for both master data and transactional data.

Achievements:

• Developed basic cubes for Customer and Quotations, Created aggregates and indexes for Info Cubes to improve the query performance.
• Extensively used BEx Analyzer, created queries MM data targets.
• Loaded business content, and performed activation of SAP supplied Info Objects.
• Extensively used Process Chains to automate data loading process.
• Transported the objects from Development to QA and then to Production.

Industry: Technology

Duration:

8 months

Project Description/Scope: SAP BI 7.0, BW 3.5, SAP ECC 6.0/5.0

Role: SAP BW Consultant

Responsibilities / Deliverables:

• Identified and activated SAP business content required for the Info Cubes.
• Replicated the data sources into BW, thereby making Metadata related to the data sources available to the BW.
• Enhanced the Info Cubes by adding custom Info Objects to reflect modified R/3 Business Process.
• Created Application Component for the Info Sources and Assigned the Replicated data sources to the Info Sources and Activated the Transfer rules and Communication Structure.
• Created Transfer/Communication Structures, Transfer rules and Update rules for ODS and InfoCubes.
• Created Update Rules for data load into Info Cube from the Communication Structure.
• Loaded Master data (attributes, texts, hierarchies) from flat files to the Info object.
• Extracted data from SD modules and uploaded the data into the procurement cubes via 2LIS_11_VAHDR, 2LIS_11_VAITM, and 2LIS_02_VASCL.
• Created Sales and Delivery, Billing InfoCubes OSD_C01 and OSD_C03 for sales overview.
• Developed ODS object to load SD Sales Order, Delivery note, Billing document Data from Business Content delivered Infosources, defined the update rules.
• The Data was extracted from various SD Tables like VBAK, VBAP, LIKP, LIPS, VBRK, VBRP, etc.

Achievements:

• Enhanced the Business Content Extractors with the user requirements
• Involved in Scheduling data loads and delta data loads into BW from R/3.
• Created Aggregates on info cubes in order to generate reports and improve query performance. RSRT for Query monitoring.
• Designed and developed several BW queries using BEx (Business Explorer).
• Worked on Web Application Designer (WAD) and published reports on web.
• Implemented a framework of templates, restricted key figures, calculated key figures and variables to implement common reporting structure.

• Extensively trained the client on BI 7.0 Data Modeling which includes installing Business Content; creating Info Objects, InfoCubes, DSO – Data Store Objects, Transformations, DTP – Data Transfer Process, Info Packages, Data Sources, Process Chains, and Source Systems

Industry: Manufacturing

Duration:

15 months

Project Description/Scope: SAP BW 3.0, SAP R/3 4.6C

Role: SAP BW Consultant

Responsibilities / Deliverables:

• Gathered Functional requirements, prepared Functional & Technical specifications, and developed blue prints by interacting with the functional experts, business analysts, management and end users.
• Involved in customizing the business content to suit the Company’s specifications.
• Made extensive use of the ODS capabilities, delta management functionality and optimal use of update rules keeping query performance in view.
• Created a forecast ODS and a billing history cube and extracted data into these data targets from R/3 and other legacy systems.
• Worked extensively on transfer rules, update rules and user-exits for transaction data.
• Developed and enhanced LO cockpit data sources.
• Automated data load processes, maintained BW statistics, did rollup of BW aggregates using SAP BW Process Chain Monitoring tool.
• Executed queries in the BEx with variables, structures, calculated key figures, restricted key figures, exceptions, conditions and RRI features.

Achievements:

• Analyzed and Mapped Business Processes to BW and wrote Business Blue Prints using ASAP methodology. Analyzed and activated Relevant Business Content and setup R/3, Flat File and BW as source systems. Reconciliation of data from various sources including legacy systems as Present Data ware houses.
• Created Web templates using Web Application Designer (WAD).

• Transported BW objects from development to QA and Production

Industry: Chemical

Duration:

11 months

Project Description / Scope: Business Objects 5.0 (Designer, Business Objects), Oracle8, PL/SQL, SQL*Plus, MSOffice, Windows2000

Role: BO DEVELOPER

Responsibilities / Deliverables:

• Installed and configured environments for Test, Development and Production and created multiple Business Objects Repository and Domains with the help of the team.
• Created multiple groups and users with appropriate row and object level security.
• Interacted with Business Users and End Users to know their Business views in developing and modifying Universes and Reports.
• Implemented technical requirements and data specifications for creating Business Objects Universes and Reports.
• Worked closely with the ETL and EPM team to understand the flow of the data and create universes with optimal schemas, design and flow.
• Built multiple universes with appropriate joins, aliases and aggregate awareness tables and built customized Classes and objects.
• Generated Full Client and WebI reports with an extensive use of Sections and Breaks.
• Customized the Full Client and WebI reports as per the user requirements by using the Formulas, Drill Downs, Master/Detail and Cross Tabs.

Achievements:

• Built individual reports with multiple universes and multiple data providers from different data sources.
• Identifying errors and understanding the report by conducting stress tests and improving the performance of reports and universes.
• Successfully installed BCA and scheduled and deployed reports through BCA.
• Lead a team and involved in installing Auditor and exporting and modifying reports as per the client requirements and tracked reports, universes and users.
• Involved in migration of WebI reports and universes from one environment to another.
• Part of the trouble-shooting and support team for the production environment.