Summary

SAP BW certified consultant around ** years of techno-functional experience in SAP BW/BI 7.3, SAP BOBJ XI 4.1, BOE, HANA, and SAP BI-IP – Data extraction, Modeling and Reporting.

Having 5+ years of experience in BOBJ 3.1/ 4.1.

Expertise in front-end Business Warehouse components (BEX Analyzer, Query Designer, Web Application Designer, Web Reports, Webi, Universe designer (IDT),Xcelsius and Dash Boards) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, Ad-hoc Queries, crystal reports and Web application designer.

Expert in creating Complex Crystal Reports (Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports)

Excellent in creating Ad-hoc Webi reports and deploying them through Info view with OLAP universe and BICS connection as source and creating dash boards using Xcelsius QaaWS, created Webi reports such as Tabular, Cross tab and Graphical reports with multiple tabs.

Involved in creating Dashboard reports using Design studio, working knowledge on SAP BO Data Services.

Involved in SAP BW BO integration part and implemented best practices.

Upgrade Experience in SAP BW from 7.0 to BI 7.3 and in depth knowledge of migrating data sources from BW 3.5 to BI 7.x.

Extensively worked on content migration from BOBJ 3.1 to 4.X and Webi, Crystal report migrations

Proficient in Data Extraction from SAP ECC (FI/CO, MM, SD, CRM,SCM,IS-Utilities, HR,PP,QM,PM), flat files and BW using extractors such as LO Cockpit, CO-PA, FI and Generic Extractors.

Working on 7.3 functionalities like Semantically partitioned objects (SPOs), Hybrid providers etc..

Proficient in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques, OLAP cache/BWA.

Hands on experience in HANA modeling. Experience in creating Attribute views, analytical view and calculated views.

Experience using APD, Open hub services extracted Data from BI and transferred to other Systems.

Good skills in dealing with production support issues, which involved debugging of data loads, update routines and transfer routines, process chains and monitoring and scheduling data loads.

Education and VISA details

Bachelor’s degree in Engineering (B.E)

Key Skills

SAP (R/3&BW/BI), BW 7.3/7.0/ 3.5, ABAP,R/3, ECC 6.0, HANA, SQL

SAP Modules: Logistics (SD, MM,) CRM, HR, FI,CO-PA,IS-U,PM,QM,PP,CRM,SCM

Language: SQL/PLSQL

Reporting Tools: Bex Reporting, Web Application Designer, Business Objects XI 3.1/4.1, Information designer toll (IDT), Xcelsius, BOE, Webi, Crystal report, Design studio, and Lumira

SAP BODS-Business objects Data services

Database: Oracle 10g, SQL Server 2000

Certification details

SAP Certified Business Intelligence with SAP NetWeaver 7.0

Project Profile:

SAP BW and BOBJ Senior consultant

Project: Syngenta – Greensboro, US

Project Duration: February 2015 – Till date

Project & Role Description

Working on SAP BW BO XI 4.1 Integration, Universe designer (IDT), Webi reports, Crystal reports.

Working on design studio to create summarized reports and dashboards.

Working on Xcelsius dashboards and SAP Business Objects Data Services

Working on BO Job scheduling, Server restarting and resetting the failure job instances.

Working on complex Web intelligence reports

Working on SAP BW data models, Bex query designer to create suitable Queries for BO reporting

Tools used-SAP BW 7.3, BOBJ 4.1-Design studio, Webi, BOE, IDT, Crystal, SAP BODS, ECC6

Project Profile:

SAP BW and BOBJ, HANA Senior consultant

Project: Hubbell – Greenville, US

Project Duration: Sep 2013 – January 2014

Project & Role Description

Worked on BO XI 4.1 Universe designer (IDT), Webi reports, Ad-hoc Webi reports development and portal monitoring

Lead the BI BO team and guiding them for the requirements and deliverables.

Worked on Xcelsius dashboards using QaaWS, BO Job scheduling, Server restarting and resetting the failure job instances.

Worked on Vendor score card project in Webi and Xcelsius

Deployed reports on the web using Crystal publishing wizard and scheduled reports using e-Portfolio and Crystal management console

Extensive knowledge in pre defined functions like string, date, numeric, conversion and null functions of Crystal like isnull, inrepeatedgroupheader, monthtodate, lastfullmonth, lastfullweek etc.

Expert in writing complex formulae at the summary level and group level to implement the business logic

Create various complex reports using Crystal Reports XI R2

Enhance/modify existing reports by creating new Parameters, Formulas etc,

Schedule the reports using Info View to run at specific times in a day/week as desired by the Business Users.

Worked on BI 7.3 Daily, Weekly and Monthly data load monitoring

Fixing the data load errors and other issues immediately to meet daily SLAs

Worked on BMC remedy ticketing tool for incident and change request tickets

Coordinating with BASIS team if any system or database issues

Involved in up gradation from BI 7.0 to 7.3 version

Worked on HANA studio to create Attribute views, analytical views and calculated views

Worked on Process chain creation, scheduling and event based triggering in the Process chains.

Scheduled extract jobs with Process Chain and monitored transfer/update of data loads into data targets with View Log.

Worked on Data reconciliation with R/3 and rectifying the data mismatches and load issues.

Worked on Transport request creation, releasing and collecting the objects through transport connection.

Worked on change requests, high priority incident and problem/Issue tickets

Worked on Bex Query designer, WAD reports, bug fixes.

Worked on Finace, CO-PA, SD,HCM SAP modules.

Worked on BW to APO data pull and push mechanism for demand planning (DP) and Supply Network Planning (SNP) reporting requirements.

Worked on BWA,BOE indexes, development and monitoring of BOE info spaces

Worked on info cube design issues, dimension fixes and repartitioning process

Worked on creating Planning objects like Aggregation Levels, Planning functions, Planning Filters and Planning Sequences using integrated planning.

Created Universes based on the Info-cubes/ Queries in SAP BW system and NON-SAP Systems.

Worked on Universe to check integrity,

Created Complex reports which includes Breaks, Sections, Ranks and Filters.

Worked on Pre-calculating the Bex queries to improve runtimes

Developed new Info cubes, ODS, Transformations for new implementation projects

Worked with Open Hub service for sending the data from BW to External Systems.

Tools used-SAP BW 7.0,7.3, HANA 1.0,BOBJ 4.1-Design studio,IDT,Crystal,Lumira,ECC6,IP

SAP BW/BOBJ Senior Consultant

Project: Ralph Lauren-Polo – New York, US-Implementation

Project Duration: March 2012 – August 2013

Project & Role Description

Understanding the Functional designs by interacting with the Client. Collecting the requirements and report functionalities

Preparing the technical design documents from understanding the Business process and the Functional Design.

Worked on extracting data from SD,MM,FI,COPA applications

Using LO Customizing Cockpit, performed necessary procedures like maintained Extract Structures, Data sources, activated the update, filling up of cluster tables and setting up of V3

Update in SAP R/3 source system.

Involved in Activating the Business Content Data Sources, Generating the Data Source.

Involved in total BW Application support from converting Business requirement document into Functional specifications document, technical specification document

Developed BI customized objects like Info Objects, DSOs, Cubes, Multi providers, Process chains.

Created Transformation's, DTP's between data targets with Start routines, End routines and field level routines.

Worked BEX Report using CKF, RKF, Formulas, selections, Structures, Variables as per the reporting requirement.

Worked on creating reports using WEBI and Advanced analysis as per the user requirement.

Created Direct process chains and Meta chains for all Master data attribute, Master data Text and Transaction data loads.

Worked extensively with the Transportation activities.

Working in resolving the issues during data loads, Unit testing and SIT of the build objects and in fixing bugs.

Tools used-SAP BW 7.0, BOBJ 4.1, ECC 6

Sr. SAP BW/BOBJ Consultant

Project: Hershey - Pennsylvania, US-Support

Project Duration: January 2011 - February 2012

Project & Role Description

Extracted the Data on Daily/weekly/Monthly basis from various R/3 and Non R/3 System to BW system.

Involved in Load monitoring using RSPC, RSMO, SM37, and SM50.

Involved in Low-prioritized tickets regarding extractions, Performance Issues and also load failures and never missed the SLA.

Involved in Submitting the SLA reports at end of every month.

Involved in submitting the Ticket Status (Open/Close) report.

Involved in both the Activities monitoring and Production Support.

Maintain Work History for all the tickets until it is closed down.

Involved in taking necessary actions to correct the info packages by doing Manual update, Reconstruction and Running the process Chains manually depending on the case.

Scheduled the data loads from SAP R/3 to BW, Monitoring the data loads which are running hourly, daily, weekly & monthly basis and solving the errors when errors occurred.

Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report, Time sheet maintenance of the support team.

Maintained Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.

Tools used-SAP BW 7.0, BOBJ 3.1,ECC

Sr. SAP BW/BOBJ Consultant

Project: Johnson & Johnson - New Jersey, US-Implementation

Project Duration: April 2010 - December 2010

Project & Role Description

I Joined Johnson & Johnson as BI BO Developer. My Responsibilities are working on BI Backend and front end FD and Webi TD's.

Involved in Activating Business Content for Standard Info Cubes, ODS Objects, Info Sources &

Info Objects of SD, FI, and MM Modules as per client Requirements and worked on Extraction (Master and Transactional data) from SAP R/3.

Replicated and Maintained Data Sources from Source System Application hierarchy into the SAP

BW Modeling environment.

Done Prototyping on BI 7.0 and Webi 3.1 Functionality on test systems to check the feasibility of reports and backed design

Collected Report requirements from Onsite and worked on Front end Functional Designs from BEX and Webi point of view.

Created some complex Webi reports in BO 3.1 Version to check on how to apply measure values, MTD and YTD as input control.

Created Webi report with Grid and Graph layout, applied element linking and content linking in input controls, based on the user selection from input control Graph and grid values will change.

Involved in Creation of Xcelsius Dashboards using QAAWS and Business Objects Live Office and published them to the Business Objects Enterprise.

Created variables, formulae and used Alerts in BO Webi.

Worked on Front end Technical Designs, the reporting tool used for the Front end is Business Objects-Web Intelligence.

Worked on Back end technical designs, which includes Business Partner, Customer Master, Territory master data from CRM and Sales

Actively Participated with Onsite team in Backend data model Design for BI 7.0

Lead the team from offshore and provided timely updates to onsite and made proper follow-ups of the deliverables.

Tools used-SAP BW 7.0, BOBJ 3.1,ECC

SAP BW/BOBJ Consultant

Project: Florida Crystal Corp - West Palm Beach, Florida, US-Support

Project Duration: July 2009 - March 2010

Worked as a SAP BI/BO Senior Technical Consultant

Monitored the daily, weekly and month end data loads

Maintained the statics of DTP's, Info packages, Process chains and APD Jobs

Stabilized the data loads which were newly added to the systems in project landscape environment.

Optimized the existing extractor enhancement codes and improved the data load completion timings those are overrunning in Production system

Rectified the Errors at various levels during the Production BW batch execution times.

Monitoring the Process chains through RSPC, RSPCM and ST13 TXN codes.

Analyzed the Short dumps related to BI errors and taken the necessary actions.

Created the process chains for Maintenance activities of BW objects( PSA master data and DSO change log data deletion

Created the Indexes and Aggregates for Improvements of the Query run time performance

Compressed the data in info cubes for Improvement of query execution times.

Responsible for Monitoring Failed BO report Instances on a daily basis and Managing Universes and Connections.

Tools used-SAP BW 3.5, BOBJ 3.1, ECC

SAP BW Consultant

Project: Epson America, Inc – Long Beach, California, US-Implementation

Project Duration: December 2008 - June 2009

Project & Role Description

Involved in Activating the Business Content Data Sources, Generating the Data Source.

Enhanced the standard data sources to meet the requirement.

Performed Data Extraction and Data Staging using LO Cockpit (LBWE) and extended the

Structures using user exits to support the Business needs for SD and MM modules

Created Generic Data source using Table, View and Function Module.

Worked on extracting data from ECC system and in modeling BI objects to publish the data at Feed store side by using Open hubs.

Worked on extracting data from R/3 systems and in modeling BI objects to provide the data for reporting through Bex and WAD.

Developed BI customized data targets like DSOs, Cubes, Multi providers, Process chains.

Implemented Routines to meet the Requirement

Created Direct process chains and Meta chains for all Master data attribute, Master data Text and transaction data loads.

Scheduled the Process chains as per the client requested timings and also resolved the upcoming issues during the Monitoring of Process chains.

Worked extensively with the Transportation activities.

Working in resolving the issues during data loads, Unit testing and SIT of the build objects and in fixing bugs.

Tools used-SAP BW 7.0, ECC

SAP BW Consultant

Project: Essent Green fields – Hertogenbosch, the Netherlands-Implementation

Project Duration: January 2008 - November 2008

Project & Role Description

Worked on IS-Utilities module implementation.

Installed relevant SAP business content objects and enhanced them as per requirement.

Created Info objects, Info cubes, DSO's, Data Source and Multi Cubes.

Created Transformations, DTP's between the Objects.

Created Multi providers for reconciliation.

Created Queries on Multi providers and Info cubes. Worked on Web Application Designer.

Data Modeling, extraction and reporting areas with respect to Sales and Contracting of IS-U.

Enhanced the Sales Statistics Data Source 0UC_SALES_STATS_02.

Did the data modeling for Sales and Contracting Area.

Generated Reports with BI 7.0 functionality

Developed flexible queries using Filters, Variables, Exceptions, Conditions, restricted key

figures and calculated key figures in Bex query designer and WAD to facilitate data analysis in a drill down or summarized way to give detailed levels of information.

Tools used-SAP BW 7.0, ECC

SAP BW executive

Project: Reliance Industries Ltd- IS - Implementation

Project Duration: July 2006 - December 2007

Project & Role Description

Involved in the design, development of Multi dimensional Data Models, Info Cubes, Data Store Objects (DSO), Aggregates, Hierarchies, Info Objects, Data Sources, Info Sources, Info Providers, Data Transfer Processes (DTPs), Transformations Using BI 7.0.

Activation of Standard Business Content cubes for IS-Oil and Gas project implementation

Involved in Installed Info Objects, Data Sources, Info Sources, Data targets, Info Packages and Info Providers to load master and Transaction data from SAP R/3 system into BW system.

Worked extensively on extractions loaded the data from R/3 to BW and used Initialization with delta update and full update methods.

Extensive Worked in building Queries by using Calculated and Restricted key figures, Structures, Variables, Exceptions, Conditions, Cell restrictions, Formulas, RRI (Report to Report interface) by creating Multi providers.

Involved in creating Dashboard reports for top management using Web application designer

Validated data consistency in reporting with Data Target against PSA after loading them to data targets.

Tools used-SAP BW 7.0, ECC

SAP BW Associate consultant

Project: BW Enhancements and Support –Reliance Infocomm- Support

Project Duration: November 2005 - May 2006

Project & Role Description

Developed new Info cubes, communication Structure, transfer rules, Update rules.

Worked on creating single roles, composite roles and providing authorizations to respective end users as per the business requirements.

Worked on creation, maintenance of aggregates and hierarchies for the Info cubes to access data in an efficient and ordered level.

Worked with Open Hub service for sending the data from BW to External Systems.

Handled performance issues like – Info cube Compressions, partitioning, query performance, Selective deletion of cube data on monthly basis etc.

In case of data load failures, took corrective actions using appropriate extraction programs after making corrective actions.

Scheduled extract jobs with Process Chain and monitored transfer/update of data loads into data targets with View Log.

Extensively worked in many Performance issue improvements in both loading and Execution activities.

Worked in roles and authorizations

Created web dashboards using WAD tool.

Tools used-SAP BW 3.1

Contact this candidate