Rohit BhanSAP BI/BO

Phone: 559-***-****

: abpon3@r.postjobfree.com

Resumes ID: 48701

Location:, Illinois

Posted: 11.08.2012

Resume Details:

Professional Summary:

* ***** ** ********** ** SAP BI 7.0/BW 3.5 consulting.

Implemented 2 full life cycles following the ASAP methodologies which included requirement gathering, business blue printing, gap analysis, realization and go-live and post go-live support in SD, MM and FI-CO functional areas.

Good knowledge in SAP BI/BW implementation with in depth technical skills in various SAP R/3 implementations, Rollouts, Upgrades, and Post implementation support in MM and SD, mainly using LO- cockpit extractions.

Implemented SAP BI/BW with in depth skills in FI-CO module and worked on sub modules likes FI-AA (Asset Accounting), FI-AR, FI-AP, FI-GL, and Controlling Project accounting mainly using standard extractors with customized and generic extractors.

Worked in SAP APO (PP/DS) and supply chain management.

Worked with CRM and extracted data from CRM data sources to BI/BW system.

Experienced in designing and maintaining Info Objects, DSO’s, Characteristic’s, Key Figure’s, Info Sets, Multi Providers and Info Cubes.

Built Business Warehouse Components like Extractors, Standard and Custom Info Cubes, DSO (Standard, Direct update and Write optimized), Info Set, Info Objects and Info Sources, Web reporting, Extraction, Transformation, DTP, Transfer Structures, Update Rules, Transfer Rules, Info Packages and Authorizations.

Proficient in enabling, enhancing, delivering and activating standard Business Content, extending and enhancing according to the requirements, performingData load management, Scheduling Process Chains, background scheduling, reporting agent, alert monitor, profile maintenance, event triggers and event chains.

Enhanced standard data sources by adding new fields to the data source with the help of ABAP program called as User Exit.

Skilled in Extracting data from SAP R/3 system using LO-cockpit, CO-PA, CO-CA, FI-GL, FI-AP, FI-AA, FI-AR extractors.

Good knowledge of data models such as Extended Star Schema and Star Schema.

Familiarity with BI concepts like BI accelerators, BEx broad caster, ETL interface, info cube remodeling and information broadcasting.

Performed extractions from SAP R/3 system to BW system using extraction queues and delta queues with the help of V3 serialized and unserialized updates.

Used flat files and other legacy data base systems to load data into BW systems using flat file interface or UD connect.

Used ABAP customer exits to enhance the data sources.

Used transaction codes such as CMOD and SMOD to write the user exits.

Performed performance tuning by creating Aggregates, Indexes, Compression and data partitioning within the Info cubes.

Extensively involved in migrating data from 3.5 to 7.0 environments.

Worked extensively on BEx Analyzer, Query Designer, Web Application Designer, web reports and X-Celsius.

Generated reports on Info Providers and Multi providers using Structures, Restricted Key Figures, Calculated Key Figures, Cell editors, Characteristic Variables, Text Variables, FormulaVariables, Exceptions, and Conditions and Replacement path.

Extensively used Calculations, Variables, Prompts, and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects Reports.

Created Advanced Analytics speedometers and Interactive Metric trends to gauge the performance of key Businesses and Display them as Dash Boards.

Created Hyper linked Web Intelligence using open document functionality.

Effectively used advanced reporting and formatting functions in BO reporting.

Proven record in creating complex reports by linking data from multiple data providers.

Expert in Report Generation, Extensively worked on BEx analyzer, Query Designer, WAD, Ad-Hoc Queries, Conducted training on BEx usage for Business Users and Web training and new features to end users.

Communicated effectively with Team members, developers, clients and end users in a diverse matrix environment.

Skill Set:

Data Warehouse:

SAP NW 2004 BI 7.0, 3.5, 3.1C, 3.0B.

Operating Systems:

Windows XP/Unix.

Languages:

ABAP/4, HTML, SQL, and PL/SQL.

ERP Packages:

SAP R/3 4.7, 4.6C, 4.6B, ECC 6.0.

Web Technologies:

HTML, XML.

Reporting Tools:

BEx Reporting, Web Application Designer, Report Designer, Business, Objects (XI R2.1, 3.1), Web Intelligence (XI R2.1, 3.1), Info View, Crystal, Reports, X-Celsius 2008.

Professional Experience:

ALCATEL LUCENT

Naperville, IL

SAP BI/BO Consultant Nov 2010 - Present

Alcatel Lucent is the leader in mobile, fixed, IP and optics technologies and a pioneer in application and services.Alcatel Lucent achieved revenues of Euro 16 billion in 2010 and is incorporated in France and headquartered in Paris.

Responsibilities:

Involved in full life cycle implementation, right from requirement gathering, blue printing, development, testing, go-live and post go-live support.

Held meetings with business users in order to gather business requirements and prepared business blue print based on those requirements.

Extracted data from data source 0CRM_OPPT_ATTR_I, for reporting on item master data such as partners, item type or status etc.

Built ODS 0CHM_ATTR for channel partner attribute and data was retrieved from 0CRM_CHM_ATTR for channel management.

Developed query 0CSAL_C01_Q0100 mainly display the activities that have been created in last 12 months either by brand owner company or by related channel partner companies.

Developed a query ZORQSC_ZSCNNM04_NN_05 to mainly help the business review the annual budget.

Developed query 0CRM_C04_Q0101, mainly to display expected sales volume by product.

Developed query 0CSALMC02_Q0102 to enable channel managers and channel partners to analyze sales documents that originate directly or indirectly from a quotation.

Built an Info Cube ZSCNNC05 to capture the Trade Promotion Actuals.

Developed an Info Cube ZSCNNC10 to capture the fund postings occurring in the TPM system.

Loaded data into data source 0CRM_SERVICE_PROCESS_I from service order items.

Worked on the info cube 0CRM_PRI in order to analyze service orders and confirmations at item level.Worked on multi cube 0CRM_MC03, which defined the way in which the key figures in CO-PA in customer’s R/3 system are viewed from CRM marketing. The data is transferred from CO-PA to the multi cube.

Developed info cube 0CRM_QTIC which contains item information for service order quotations.

Extracted data from data sources such as 0CO_OM_OPA_1 and 0CO_OM_OPA_2.

Created process chains and meta chains for periodic uploading of text data, master data and transaction data.

Created reports in the BEx analyzer using concepts like Inception- to- date, year- to- date and month- to- date.

Developed info cube ZSCNNC09 to manage the claims.

Created jump reports, where a query jumped from a one report to other specific report, using a Concept called RRI.

Developed single and multiple dash boards and score cards using Business Objects.

Was involved in unit testing, Integration testing and regression testing of the reports.

Wrote test scripts to test different business scenarios and executed various test scripts.

Created Master/detail reports, cross tabs, charts and applied slice and dice, implemented different levels of hierarchies for drill techniques.

Used Open document function for linking different reports and dashboards.

Experienced in generating Webi reports over various BEx queries and other BI objects such as info cubes etc.

Used SAP integration kit to connect various business objects tools to SAP BI/BW environment.

Involved in designing Universe and created Ad Hoc and Canned Crystal Reports.

Developed the OLAP Universes using BEx Queries as data provider.

Developed Webi and crystal reports on top of OLAP Universes.

Defined BO Classes, Objects, prompts, filters, Hierarchies in OLAP.

Extensively used BEx analyzer to validate the Universes and reports data against the BEx queries.

Enabled dynamic report linking by passing Variables (prompts) between reports.

Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC.

Responsible for developing Analytical Reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using the Business Objects Enterprise XI.

Environment: SAP Net weaver 04 (BI 7.0), ECC 6.0, CRM 5.0, MM, SD, Business Objects Xi 3.1, BEx Analyzer/ Browser/BO Xi 3, SD, MM, FI /CO modules, Windows XP, SOL MAN 7.0, SCM 5.0, Universe designer, Webi, Crystal reports 2008, Xcelsius 2008.

Tenneco Inc

Lake Forest, IL

SAP BI/BO Lead Consultant Jan 2010 - Oct 2010

Tenneco Inc is a worldwide corporation organized into various geographic divisions such as North America, South America, Africa, Europe, Asia and Australia.Since becoming a standalone company in 1999, Tenneco has grown to become one of the world’s leading designers, manufacturers and distribution of emission control and ride control products and systems.

Responsibilities:

Successfully implemented full life cycle implementation including Gap Analysis, Blue-Printing, Report Design, and Development.

Coordinated with offshore to develop Analytics and reporting queries and help understand the business requirements. Successfully made the transformation for the Process Automation division to move from the legacy system (MACPAC) to BI reports.

Worked extensively with FI reports like, Pulling ECC Sets Hierarchies (GS03) into BI (using T code BW07) for the Income statement reports and Balance sheet reports.

Created many test cases and test scenarios for Unit testing, Integration testing of many BI reports. Conducted many training and Brown Bag sessions to help the end client understand the SAP BI system and also to gather the requirements.

Created views in the portals and published reports for super users.

Created many complex and customized SD (Order to Cash OTC) reports which specific business requirements in various modules like Sales Shipment report, Sales overview report, Billing document report, Top 10 Customers etc... Using BEx Query Designer etc.

As a part of Production support involved in debugging and monitoring load failures, solving the high priority tickets from HP Quality centre, Delta loads, planning ECC Outage for filling up of setup tables for Logistics (LO) extractors, Minimizing the Init load and setting v3 jobs, loading XML data into BI, etc.

Involved in monitoring the performance of the system and reporting which includes performing OLAP Cache, Aggregates, Indexes, Archiving the non cumulative info cubes, Partitioning, etc.

Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSOs, Multi Providers, Info Sources, Info Set, time dependent master data and also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc. Also involved new features of SAP BI security like Analysis authorization.

Extracted inventory management data using the update marker in the info cubes.

Designed and created many process chains to automate the data load and data target administration.

Responsible for developing Analytical Reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using the Business Objects Enterprise XI.

Implemented analytics across the organization and used tabs on company performance via flexible management navigational dashboards and scorecards.

Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups. Also Created Ad Hoc Reports by accessing the Universe.

Created Web I reports with Complex Calculations, Variables, What-If analysis, Alert.

Worked In creating custom variables, prompts for canned and ad hoc webi reports as per the business requirements in webi and created navigational dashboards based on various KPI’s and metrics having what-if analysis for users ease.

Developed custom queries using navigational attributes and filters in BEx query designer and created cross tabs SQL selection criteria and grouped in reports. Performed report bursting scheduling through CMC and Info View.

Extensively Worked in Live Office and QWAAS for developing dynamic and navigational Dashboards.

Sound Knowledge over SAP QAAWS used in mapping data directly from Universe to Xcelsius Dashboards.

Created Xcelsius Dynamic Dashboards for 7 different KPI’s over SAP BI data.

Environment: SAP BI 7.0, SAP ECC 6.0, FI/CO, SD, SCM 5.0, Business Objects Xi 3.1, BEx Analyzer, Query Designer, SOL MAN 7.0

Global Packaging Solutions, Inc

San Jose, CA

SAP BI-IP Consultant Jan 2009 - Dec 2009

GPS is an integrated logistics solution provider with a seamless extension to the companies by providing shipping options and handling methods to meet all the import and export requirements.

Responsibilities:

Set up source systems to load both SAP ECC and Non-SAP Transaction data to BI.

Worked on Standard Line item data source like 0FI_GL_4 (General Ledger line item), 0FI_AR_4 (Accounts receivable Line Item), 0FI_AP_4 (Accounts Payable Line Item).

Used ABAP Routines (Start Routines, End Routines) in transformation rules to update characteristics and Key Figures in the Info Cubes.

Managed and monitored several data loadings, debugged the errors to identify the bugs and suggested several OSS notes for the errors encountered while loading the data.

Extensively worked on ETL activities, activated transformation rules, and scripted extraction routines for master data, texts and hierarchies. Extensively involved in transportation, developed queries using filters.

Created process chains to automate the data load and data target administration.

Published the Queries in Portal as views on their respective Folders.

Extensively involved in analyzing the BI statistic cubes and involved in performance tuning of all the slow running reports in the production environment.

Extensively worked on query development and formatting techniques in both BEx and Web ApplicationDesigner (WAD) of key BW reports and created Web Templates.

Migrated existing BW 3.5 functionality to BI 7.0.

Migrated existing BW 3.5 queries to BI 7.0 queries.

Migrated existing Data model from BW 3.5 to 7.0.

Involved with performance tuning of queries by maintaining BI index, Rollup, aggregates and Change run of BI accelerator, partitioning of info cubes and actively involved in maintenance of OLAP CACHE for specific queries using the reporting agent and the transaction code RSRT.

Environment: SAP BI 7.0/BW 3.5, SAP ECC 6.0, FI/CO, SD, SCM 5.0, Business Objects Xi 3.1, BEx Analyzer, Query Designer, SOL MAN 7.0

Verizon Business

Dallas, TX

SAP BW/BI Analyst Jan 2008 - Dec 2008

Verizon is America’s largest and most reliable network with voice and data and a leader in fiber optics offering phone, Internet, TV, wireless and service bundles to residential, business, government and wholesale clients.

Responsibilities:

Involved in full life cycle implementation, right from requirement gathering, blue printing, development, testing, go-live and post go-live support.

Held meetings with business users in order to gather business requirements and prepared business blue print based on those requirements.

Extracted and uploaded data into Info Cubes from Data Sources like Actual Cost through delta extraction (0C0_OM_CCA_9), Internal Order through delta extraction (0C0_OM_OPA_6), Account Receivable (0FI_AR_4) and Account Payable (0FI_AP_4) forthe FI & CO modules from the Business content.

Extracted data from R/3 in HR. Used Info source 0HR_PY_PP_2 for HR. Activated business content Staffing Assignment (0PAOS_C01) Info Cube and dependencies for transactional data, uploaded from R/3.

For HR, activated business content Headcount and Personnel Action Info Cube (0PA_C01) and dependencies for all transactional data which extracted from R/3 data sources.

Responsible for design, development and extraction from ECC Source system and flat files to BW for FI & CO.

Worked with functional consultant for mapping the source data (ECC) to target data source in BW.

Created Queries by defining rows, columns and free characteristics providing drill down functionality in reporting using BEx. Worked with users to understand their reporting needs.

Generated Export Data Sources to transform data from one Info Cube to other Info Cube.

Scheduled Daily/Weekly/Monthly data loads. Managed and monitored data loads with full upload and delta mechanism.

Created Info set for master data to enabling querying on data.

Contact this candidate