We provide IT Staff Augmentation Services!

Sap Bi Bobj Lead Consultant Resume

Irvine, CA

Professional Summary

  • 9 years of professional IT experience including SAP BW/BI, BPS, CRM, ABAP,CO-PA, FI-CO ,HR, SD, MM,SRM, CRM, PP,SEM,BPS, IP Development and Administration.
  • 4 years of Sap BOBJ Experience includes Integrating BusinessObjects BO 4.0 and BOXI 3.1 - BO Universe, Web-Intelligence Report, Crystal Reports, Xcelsius with SAP Integration Kit to SAP BI 7.0 and ECC6.0,
  • Expertise in analyzing, designing, creating and maintaining Info Objects, Info Cubes, ODS objects, Remote Cubes, Multi Providers, Info Sources and Extract Structures.
  • Work experience in different kinds of projects like Upgrade (BI 7.0 to BI 7.3), Implementation and Production Support Projects in SAP BI 7.3, BI 7.0, BW 3.5.
  • Worked with Business Objects BO 4.0 and 5.x / 6.x / XIR2 / XIR3 and in various Technical capacities such as Systems Analyst, SAP BI Developer and SAP BO Developer.
  • SAP BW Data Basis Design to support SEM-BPS Planning, Budgeting and Forecasting Applications
  • SAP BusinessObjects Business Intelligence Mobile Applications IPad and Iphone integration with BO 4.0.
  • Experience in BOBJ integration with SAP BI (Data service, Universe, WEBi, Infoview, Crystal report, Xcelsius Dashboards, Xcelsius 2008, live office, QWS (Query as web service), Dashboards. Voyager)
  • Expertise in Flat file, Generic Data Source, LO Cockpit, FI, CO and COPA extraction.
  • ABAP Knowledge for developing business logic in Transfer and Update routines and enhance the Datasource User Exits.
  • Performance Tuning - Evaluated statistical performance using BW Statistics and suggested recommendations to Basis support for optimization. Improved data load and query performance by doing Compression, creating Aggregates, Rollups,Partitioning, Indexes, and Data packet size.
  • Experience in BW components like Scheduling, Process Chains, Data Mart, Legacy Systems, XML and DB Connect.
  • Involved in Data Loading (Full /Initial/Delta Up-Load/ Master, Transaction data) for, Scheduling, Creating & Monitoring Process Chains, Data Marts and Open Hub Services
  • Experience in automating loads using Meta Chains, Process Chains and use of BW Monitor to supervise data loading.
  • Expertise in front-end Business Warehouse Components like Queries, Calculated Key figures, Restricted Key figures, Structures, Variables, Exceptions, Conditions, and Jump queries.
  • Production Support Extensive experience in support, Data loads, Validation and trouble shooting of transaction data and Master data, Change management, Transport Management, Roles & Security, System Checks, Performance tuning and process chains.
  • Performance tuning and Testing -Evaluated using BW Statistics Cubes and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, partitioning, indexing of infocubes, aggregates and use of BW Statistics for the same. Strong Knowledge in Archiving
  • Worked on ALE, IDOCs, RFC settings to be done in the sender and receiver systems for data transfer and communication
  • Experience in implementation of back end features and new reporting features in SAP BI 7.0.
  • Upgrade experience with SAP Net Weaver2004s BI platform and technology.
  • Excellent communication and interpersonal skills, and the ability to interact and collaborate with other MIT teams including application development, testing, operations, and project management office as well as business customers and external vendors.

Skills

ERP : SAP ECC 6.0, SAP R/3 4.7, 4.6C, 4.6B, 3.1I, 3.1H,QM, SD, MM, PP, FI/CO
Data Warehouse Tools : SAP BI 7.3, BI 7.0, SAP BW 3.5, 3.1, 3.0B, 3.0A, Infomatica 7.1/6.2.
DBMS : Oracle 9i / 8.i / 7.3, SQL Server 7
Reporting Tools : Business Objects 4.0, Business Objects XI R3.1, XCelsius, Universe, Webi, BEx Analyzer,
Broadcaster, WAD, Report designer
Languages : C, C++, PL/SQL, ABAP/4, Visual Basic, JAVA 2.0, JavaScript
Operating Systems : Windows 2000 / XP / NT / 98, Sun Solaris, UNIX
Other Applications : Microsoft Office, Microsoft Outlook, Microsoft Projects, Quality Center 10/9.2/9.0

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA Dec'10 - Present
SAP BI BOBJ Lead Consultant

Responsibilities:

  • Interaction with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting
  • Work as a SAP BI Techno Functional expert to design Reporting and Dashboard solutions.
  • Involved in upgradation from SAP BI 7.0 to SAPBI 7.3.
  • Involved in upgradation of BOE XI 3.1 to BO 4.0
  • Developed SAP Mobile applications for IPad and Iphone integration with Business Objects 4.0.
  • Developed Dashboard for Actual Vs Budget Expenses which includes What-if? Analysis.
  • Extracted data from SD, MM, FI, modules of SAP R/3 into SAP BW system through LO Cockpit and Business Content Data sources.
  • Developed the ABAP code by enhancing the standard CO-PA (1_CO_PA_AC_GP) for Government pricing.
  • Used COPA Extraction and developed COPA cube using multiple characteristics and key figures for Profitability Analysis.
  • Managed and monitored data loads with full update and delta mechanism. Automated data loading using process chains.
  • SEM BPS Cost-center planning, Profitability Planning
  • Created planning sequence in BPS for Cost center forecasting, forecast planning, Time management.
  • Extracted data using CO-PA (KEB0) (cost or account based) for analyzing the data on various criteria partitions like cost centers, companies, controlling area, regions to compare cost of sales or overhead costs, product costs, Profitability Analysis.
  • Extracted data from SAP R/3 using LO and Generic extractors. Apart from that extracted data from flat files using flat file source system.
  • Design/Develop Crystal Report, WebI Document, DeskI Document
  • Created Process Chains, InfoGroups, InfoPackages and event triggers for job scheduling
  • Handled postproduction support and development of new design cycles simultaneously.
  • Extensive use of process chain to automate loading all master and transaction data
  • Transportation of various requirements for source system as well as for BW system from development to QA and production environments
  • Error Debugging and rectification, solving issues, problems faced during data uploads.
  • Involved actively in supporting the various issues addressed by the Users from the client side and providing them with required solutions.
  • Using the Business content cube 0FIAR_C03 (Financials) Extracted data from the R/3 source system using the Info Source 0FI_AR_03 for reporting purpose.
  • Developed Global info cubes, Multi cubes, Transactional Info cubes, DSO objects and extracted Master data and Transaction Based Data in QM, MM, and FI Info areas
  • Designed and activated process chain at various levels with varied processes which involves scheduling data in Info Packages, Reading data from PSA and updating corresponding data targets, Activating DSO data from data load, Deleting / Generating Indexes, Deleting requests.
  • Created Queries with BEX Web Application Designer for analysis and reporting and to display the Report in Web.
  • Designed, developed BEx queries, Universes and Webi Reports, Xcelsius Dashboards.
  • Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
  • Troubleshooting and rectifying Universe, Webi & Live Office errors.

Environment: SAP BI 7.3, SAP BI 7.0, BO 4.0, Business Objects XI R3.1, SEM-BPS, Business Explorer (BEx) Query Designer, BEx Analyzer, BEx Report Designer, BEx Web Application Designer, BI-BPS Environment: SAP CRM 6.0, Netweaver 2004s with Enterprise Portal, ECC 6.0,

Confidential, Arlington VA/Huntington Beach, CA Jan'10 - Nov'10
SAP BI BO consultant
Application Showcased in SAP Utilities Conference 2010, Hyatt Regency, Huntington Beach, CA

Responsibilities:

  • Conduct requirements gathering workshops and playback sessions
  • Author Strategy Document, Functional Design Document, Technical Design Document.
  • Developed Multiproviders, Cubes, Aggregates DSO objects , Custom InfoObject Catalogues, Characteristics and Key figures info objects, Transformations, routines(start ,end, expert) to extract data from flat file and R/3 systems Creating Info Packages, DTP's, Process chains.
  • Collaborate with On-Site and Offshore teams of Technical experts and Analyst
  • Strategize/Design/Develop Data Extraction mechanism from SAP and Non-SAP systems
  • (Web Services, UD Connect, DB Connect) for heterogeneous database
  • Design/Develop BW InfoProviders and DTPs in BW
  • Design/Develop ETL Process Chains in BW and Transformations in Informatica and BW
  • Conduct Conference Room Pilots (CRPs) and Status meetings for progress updates to Executives
  • Maintain Roles and Rights management for User Roles
  • Design/Develop Crystal Report, WebI Document, DeskI Document
  • Crystal/WebI report generation with Hierarchical based BW reports
  • Crystal Report development with Hyperlink based On-Demand type report
  • Design/Develop dashboard with Dynamic Data Manipulation in Xcelsius
  • Use InfoView Dashboard Designer for integrating Xcelsius, WebI and Crystal Reports
  • Use LiveOffice and QaaWS for data retrieval from Universes and WebI/Crystal reports

Environment: SAP Business Warehouse 7.01 , Business Objects XI R3.1 on Windows Server 2003, Oracle 9i/10g, MS SQL server 2005, Windows NT, UNIX, IIS, BOE XI 3.1

Confidential, CA Jan'09- Dec'09
Integration of SAP BI 7 with BO tool and BO reporting (BOBJ)
SAP BI BO Consultant

Responsibilities:

  • Involved in complete life cycle implementation of SAP BW in SD, MM, PS and FI modules.
  • Developed Multiproviders, Infosets, Cubes, Aggregates DSO objects , Custom InfoObject Catalogues, Characteristics and Key figures info objects, infosources, Transformations, routines(start ,end expert) to extract data from flat file and R/3 systems Creating Info Packages, DTP's, Process chains.
  • Data extraction from R/3 and Flat files, Creating Info Packages, DTP's, Process chains Scheduled loads.
  • Enhanced Standard BI Content Master data Extractors by RSA6 Transaction.
  • Uploaded Master data From Flat file (source system) to Info Objects (Master data table).
  • Uploaded sales order data from SAP R/3 to BI using generic Datasources.
  • Created Financial Reports like Balance sheet, Income Statement, Income Statement Trend, Actual vs. Budget Report using WEBI.
  • Implemented LO extraction (LBWE) for the Business Content data sources.
  • Worked with Crystal reports for developing several reports.
  • Worked with several users, and interacted with them to gather requirements and transformed them into a data model with the concept of extended star schema.
  • Worked extensively on Business Content and installed the necessary objects.
  • Enhanced the standard Info cubes and created custom cubes by adding custom Info Objects to reflect modified R/3 Business Process. Created several custom InfoSources & InfoObjects in BW and mapped them with R/3 fields using transfer rules and extract structures.
  • Defined update rules, transfer rules using routines and formula builder.
  • Extracted data from SAP R/3 using LO and Generic extractors. Apart from that extracted data from flat files using flat file source system.
  • SAP BI Enterprise Portal and KM for Unified reporting of BW reports, BO folders, BO Documents and Xcelsius dashboard
  • Tuning the queries to improve the performance of the report refresh time.
  • Created customized Web Intelligence reports from various different sources of data.
  • Created and Maintained source system interface configuration for BW and R/3. Responsible for maintaining Logical system, RFC Destination and the communication User ALEREMOTE.
  • Design of Data Entry Screen for Plan, Target, Forecast and Budget values
  • Created Process Chains, InfoGroups, InfoPackages and event triggers for job scheduling.
  • Actively involved in improving the performance by regularly tuning the data model, creating aggregates & indices, collapsing the data targets, implementing archiving procedures and logical partitioning.
  • Designed and developed queries in BEx and scheduled exception reports using reporting agent.
  • Environment: SAP BI 7.0, BOE XI 3.1, Universe Designer, Web Intelligence, Xcelsius 2008, Crystal Reports 2008, live office XI, SAP ECC 6.0.

Confidential, Tampa, FL Mar '08 - Dec '08
SAP BI Consultant

Responsibilities:

  • Involved in all phases of ASAP methodologies, project planning, Business Blue printing, Realization, Final Preparations, Go-Live and Support.
  • Created Technical and Functional specifications and was Responsible for building customizing Info Cubes for SD Customer, Deliveries and Sales after the Gap analysis.
  • Activated relevant Business Content objects for PP, MM and FI modules.
  • Installed and configured BOE premium XI3.0( BOXI 3.1) and its components namely Designer, voyager. Also Installed and Configured Xcelsius, Crystal Reports 2008.
  • Configured Integration of SAP BI 7 tools with Business object reporting tools using SAP integration kit. BO tools are installed in Virtual Machine.
  • Worked on Material Stocks / Movements 0IC_C03 cube and extracted data from the datasources Stock Initialization for inventory Mangement 2LIS_03_BX, Material Movements from Inventory Management, 2LIS_03_BF Revaluations in Inventory Mangement 2LIS_03_UM.
  • Developed Aged Inventory Report for calculating age of the Finished product with Drill down for Plant, Storage Loc, Material and material Type
  • Worked with Open Hub and infospokes in pulling the data from global Datastore.
  • Building and activating Info Sources for master data and transaction data for SD applications.
  • Responsible for creating Info Set combining ODS and Info Objects for Sales Item level Information..
  • Transporting the objects from Dev Server to QA Server.
  • Designed/Optimized the queries (top customers, monthly incoming orders and revenues, product analysis, returns) and analyzed the data using BEx analyzer/browser.
  • Created query variables and enhanced the query functionality with the use of Customer-Exits.
  • Designed SAP Web Application-based Dashboards.
  • Customer Interaction, ticket resolution and Involved in preparing end user training documentation.

Environment: SAP BI 7 (SAP NetWeaver BI 7.0), BOE Premium XI 3.0, Universe Designer, Web Intelligence, Xcelsius 2008, Crystal Reports 2008, Live office XI, Voyager

Confidential, San Jose , CA Jan 07 - Feb 08
Senior BW BOBJ consultant

Responsibilities:

  • Worked extensively on the design, development and maintenance of the BW solution.
  • Analyzed the requirements, worked on gap analysis and identified existing business content as well as areas for enhancements.
  • Extracted Master data and Transaction data from CRM into BW.
  • Activated the Business Content data sources in CRM system.
  • Designed & Created CRM related data models in BW.
  • Conducted several workshop sessions with users during the requirement gathering.
  • Created New Universes on top of BEx queries and modified the existing Universes and used @functions like @select, @where and @prompt in the process of building the universes
  • Extensively used Webi Infoview for querying, reporting and analysis tasks.
  • Broadcasted reports (Crystal and WEbi) to field representatives using Info View scheduling functionality. Involved in creating web-based reports using Business Objects Webi.
  • Involved in discussions on BOBJ deployment scenarios and data modeling
  • Created Universes with standard and custom hierarchies and Filters.
  • Created Objects and classes in Universe which in turn used in Webi and Crystal reports.
  • Created parameterized Crystal Reports, Business Objects Reports Desktop Intelligence, webi Reports and customized existing reports and used conditional formatting for color-flagging data that met client requirements and also performed multiple grouping for different hierarchy levels.
  • Designed backend and report for Project and Territory Management system.
  • Extracted CO data to incorporate overhead Cost controlling and Cost Center Accounting data in BW reports.
  • Worked extensively with Logistics data sources 2LIS_12_VCHDR, 2LIS_12_VCITM, 2LIS_08TRTLP.

Confidential, Santa Clara, CA Mar '06- Dec' 06
SAP BW consultant

Responsibilities-

  • Worked with BEx Analyzer to generate Queries and embedding them into Workbooks.
  • Monitoring the Process chains for daily and monthly loads for different applications.
  • Monitor daily load, rectify the problems for data load and provide solutions for repetitive problem.
  • Involved in Delta issues, process chain failures and table space issues.
  • Provide solutions for Production Trouble Reports.
  • Configured BEx Queries for Free Characteristics, Calculated and Restricted Key figures, Filters, Variables and Exceptions.
  • Extensive use of Process Chains (RSPC) to automate loading of all master and transaction data.
  • Excellent working knowledge in debugging ABAP Code in Start routine, Update routine & User exits.
  • Involved in Production support and resolved the errors during the transition period.
  • Environment: SAP BW/BI, FI- CO, Logistics.

Confidential, Greensboro, NC Jul'05- Feb'06
SAP BW Consultant

Responsibilities:

  • Analyzing the exiting BW objects for the requirements of the affiliate and
    issue new change request for customization and creation for the same.
  • Extracted data from SD modules and uploaded the data into the procurement cubes via 2LIS_11_VAHDR, 2LIS_11_VAITM, and 2LIS_11_VASCL.
  • Developed ODS object to load SD Sales Order, Delivery note, Billing document Data from Business Content delivered Infosources, defined the update rules and worked on 0IC_CO3, 0IC_MC01 cubes.
  • Responsible for the activation of SAP pre-delivered content and Info Cubes in the area of Vendor Evaluation
  • Developed custom extractors on the R/3 OLTP systems and defined the extract structures on the source and target systems.
  • Coded ABAP Routines for transfer rules, update rules, conversion routines in BW system.
  • Improved data load and query performance by doing compression, aggregates, partitioning.
  • Worked on system tools for tuninglike RSRV, ST05.
  • Created transfer structures, transfer rules, update rules including necessary routines wherever required for ODS and Info Cube level.
  • Involved in creating reports for Plant Maintenance area, Sales and distribution area, Inventory Management and ware house management.
  • Created Generic Data sources according to business requirements with views and infoset query.
  • Developed Aggregates for Query optimization. And monitor data loading into the Info Cubes.
  • Automated Data Loads through Process Chains.
  • Scheduled monthly loads according to the business needs.
  • Resolved data issues and Query issues of the end users of the BW system.
  • Developed ABAP reports, queries and interactive reports
  • Created Queries with BEX Web Application Designer for analysis and reporting and to display the Report in Web.
  • Created and Maintained source system interface configuration for BW and R/3. Responsible for maintaining Logical system, RFC Destination and the communication User ALEREMOTE.
  • Create and Maintain BW Authorizations on hierarchies (RSSM).
  • Customized and maintained interface with Flat file and successfully extracted data into the SAP BW system

Environment: SAP BW 3.5, R/3 4.6C, SD, MM, FI/CO, BEx Analyzer, BEx Browser, WAD Web Template, ABAP Query, Windows NT.

Confidential, India Jan '03- June'05
SAP ABAP BW developer

Responsibilities:

  • Created a Classical Report to display a list of Purchase Requisitions with details like MRP Controller, Release Date, Unit Of Measure along with the Standard details.
  • Developed an Interactive Report for Displaying Vendor Information. The Selection made in the Corresponding Vendor details, the line selected from basic list was visible and with Secondary List.
  • Created different layout sets using Transaction Code SE71.Created Windows, Paragraphs, Page Windows and Company LOGOS are copied from tiff file while using the program RSTXLDMC.
  • Using SAP SCRIPT Created and Modified Layout sets and the ABAP/4 Program for Sales Order Confirmation RVORDER01, Packing list RVDELNOTE AND Purchase Order MEDRUCK.
  • Developed BAPI Program that Converts between Internal and External Data Format such as Currency and Amount by generating a Function Module.
  • Analyzed Parameters and their names in the Function Module.
  • Conducted User requirement sessions and actively involved in requirement analysis.
  • Followed ASAP Methodology throughout the development of the project.
  • Involved in discussions with the top management as well as end users for Business Requirement Analysis in order to freeze the functional design specifications for data capturing from the existing business scenarios.
  • Transfer of Business Content to active version with all its dependent objects like Queries, workbooks, updated rules, Info Sources, Transfer Rules etc.
  • Creating new Data models using the New and 3.x Datasources, PSA, Transformation and DTP (Data Load Process) Working with new Data Store Objects standard and write optimized, and Virtual Infocubes with Direct Access and Infocube with RDA (Real time Data Acquisition). Worked with the Remodeling Toolbox to change the existing data models.
  • Analyzing source data, and helping to establish ETL guidelines, to the design, development, and testing of Data Stage ETL programs/processes to move and transform data from several businesses into corporate Oracle data warehouse.
  • Extensively worked in improvement of the Query performance by creating Aggregates and Compressions on Info cubes.
  • Configured & Scheduled the BEx Download Scheduler to Download the Reports to local file (htm or xls) so that the reports can be distributed offline.

Environment: SAP BW 3.0B, R/3 4.6C, SD, MM, FI/CO, BEx Analyzer, BEx Browser, ABAP Query, Windows NT.

Hire Now