Post Job Free
Sign in

Sap Sales

Location:
Houston, TX, 77063
Posted:
March 26, 2010

Contact this candidate

Resume:

Surya Shetty

Sr. SAP Certified BW/BI/BO Consultant

SUMMARY

. Over 7 years of extensive work experience in the IT industry as

Consultant.

. Experience and knowledge working on SAP BW 3.0-3.5, SAP BI 7.0 and BO

XI R2 & BO XI R3 environment.

. SAP certified BW consultant with 4 full-life cycle implementations and

BW development experiences in fortune 500 companies.

. Implementation of BW 3.0, 3.1, 3.5, BI7.0 which includes Gap Analysis,

Requirements gathering, Data Extraction, Data Loading (Full /Delta Up-

Load), ETL, Scheduling, and Monitoring.

. Creating Process chains and Infopackages to load data to various

Infoproviders.

. Custom data extraction from Legacy systems using Flat files.

. Experience in Performance Tuning using Aggregates & Roll-Up,

Compression of an InfoCube, Indexes, and BW Statistics.

. Involved in Post production, go-live support.

. Over 3 years of experience in creating interactive & executive

dashboards using Xcelsius Enterprise 2008/4.5/3.x

. Expertise using QAAWS and to create prompts used as an input parameter

for the dashboards.

. Managed the resources, granted permissions to Business Objects product

users, Webi users, managed the connections, the Universes and

repository domain.

. Front-end experience in Query Designer and Web Application Designer,

NW 2004s

. Expertise in designing and implementing BEx queries using Calculated

Key Figures, Restricted Key Figures, Filters, Variables, Structures,

Exceptions, Conditions, RRI (Jump Queries), and Workbooks. Created web

reports using Web Application Designer (WAD) and published in

Enterprise Portal using iViews.

. Excellent cross-functional knowledge of FI, SD, MM and PP modules in

SAP R/3.

. Very fluent with business process documentation and end-users training

/ knowledge transfer.

. Demonstrated ability to complete multiple assignments simultaneously

and maintain high standards of client organizations.

. Good understanding of ASAP methodology.

. Strong Communication skills, problem solving skills and ability to

adapt to new technologies.

OVERVIEW OF SAP BW & ABAP EXPERIENCE

. Data-Modeling - Extensive involvement in gap analysis. Design and

maintenance of InfoCubes, MultiProviders, RemoteCubes, ODS objects

with consistent star schema and efficient multi-dimensional data

modeling techniques. Customization of datasources in CO-PA, LIS,

FI/CO and LO Cockpit to match the business requirement.

. Data Extraction - Creation and customization of InfoSources, Transfer

Structures, Update Rules, Start Routines, and Extract Structures.

Scheduling and monitoring of data upload into InfoProviders such as

InfoObjects, ODS, InfoCube as well as PSA. Automating the data

extraction using Process Chains.

. Reporting - Building custom queries using Restricted and Calculated

Keyfigures, Variables, Structures, Conditions and Exceptions.

Extensive experience with Query Builder, BEx Analyzer, RRI - Jump

queries, Web Application Designer, Report Designer, Visual Composer,

Universe Desinger, Xcelsius and WebI. Worked with InfoSets and InfoSet

queries. Sound knowledge in Enterprise Portals.

. Performance Tuning - Analyzed OLAP and WHM performance using BW

statistics. Improved query and load performance using Aggregates,

Partitions, Indices, Packet Size, Data Selection and Data Compression.

. Upgrade - Hands-on experience on Upgrade from BW 3.5 to BI 7.0

. Authorizations & Security - Developed Roles, User Authorization

Objects, Profiles and User groups.

. ABAP/4: BDC, Open SQL, Function Modules, Variants, Data Dictionary.

TECHNICAL SKILL:

Business Intelligence SAP BW 3.0b, 3.1, 3.5,7.0

Tools

Reporting Tools Query Builder, BEx Analyzer, WAD, Report

Designer, Visual Composer, Business Object

- Web Intelligence, Universe Designer,

Xcelsius

Programming Tools C, ABAP/4, JAVA, SQL, PL/SQL, HTML, and VB

6.0.

Operating Systems WINDOWS 2000 Server, WINDOWS NT 4.0, UNIX,

WINDOWS XP/98/95 and LINUX.

Databases ORACLE 8i, DB2, MS ACCESS, and SQL Server

Presentation/Utility MS-Office, MS-Project

Tools

PROFESSIONAL EXPERIENCE

Oakley, Foothill Ranch, CA

Feb '10 - Mar '10

Sr. SAP BI Consultant

Responsibilities:

. Wrote migration documents for SAP BI frontend from 3.x to 7.0.

. Created PPT presentations showing the new functionalities of SAP BI

7.0 v/s 3x.

. Trained the Super users and the SAP BI team members about the

migration of SAP BI front end to 7.0 from 3x.

. Worked on creating a Universe from the existing query using Universe

Designer.

. Worked on creating Static and Dynamic Dashboards using Xcelsius

Environment: SAP BI 7.0, SAP R/3 4.7, BEx Query Designer/Analyzer 7.0, SAP

BO XI 3.1- Universe Designer & Xcelsius.

Hewlett-Packard, Houston, TX

May '09 - Dec '09

Sr. SAP BI Consultant

Responsibilities:

. Responsible for interacting with Business users for gathering

reporting requirements and analyzing the scope of using Business

Content and preparing technical specifications for several reports in

SD, FI- AP,AR, GL.

. Analyzed & Mapped Business Processes to BI for Sales & Distribution

(SD) reporting needs.

. Worked in Bex Analyzer, Query Designer and Web Application Designer,

NW 2004s to create customized workbooks, web reports.

. Generated Xcelsius dashboards out of SAP BW data where the data is in

the form of BEx Queries and Infocubes.

. Created OLAP Universes on BEx Queries and using them in Query As A Web

Service(QAAWS) for data loading into Xcelsius.

. Worked on Query Design including Restricted Key Figures, Calculated

Key Figures, Conditions, Exceptions, and Variables.

. Created Web-templates and displayed the queries in form of tables,

charts with different navigation options.

. Experience in Backend modeling / production support.

. Created ADD documents for approval of design from the architecture

team.

. Worked with team to ensure deliverables/milestones are being met as

per the project plan.

. Worked on open hub destination.

. Wrote includes for expert routines for open hub transformations.

. Involved in Post Production go-live support.

. Possess good understanding of the change management process.

Environment: SAP BI 7.0, SAP R/3 4.7, BEx Query Designer/Analyzer 7.0, WAD

(Web Application Designer 7.0, BO XI R3- Universe Designer, WebI & Xcelsius

2008)

Chevron Phillips Chemical Company, Spring, TX

Oct '08 - Apr '09

Sr. SAP BI Consultant

Responsibilities:

. Worked on developing a program to migrate existing SAP 3.5 bookmarks

into SAP BI 7.0 Query Views.

. Create New BI 7.0 roles and migrate workbooks and queries to BI 7.0

and assign it to the new roles.

. Working on frontend Migration from 3.5 to 7.0.

. Identify Tabular format Reports and create Report Designer Reports.

. Created reports on SD, MM, SRM and FI.

. Activated standard extractors for the required Application components.

. Installed Business content objects including InfoCubes, DSO,

Multiproviders, InfoObjects, InfoSources, InfoPackages,

Transformations, DTP, Process Chains, etc.

. Uploaded master data and transactional data from Flat File and SAP R/3

to BI system.

. Created Infopackages for uploading the master and transaction data,

Process chains for daily delta loads.

. Experience in Bex Analyzer, Query Designer and Web Application

Designer, NW 2004s

. Worked on Query Design including Restricted Key Figures, Calculated

Key Figures, Conditions, Exceptions, and Variables.

. Created workbooks as per user requirements.

. Created Web-templates and displayed the queries in form of tables,

charts with different navigation options.

. Created URL/BI iViews in Enterprise Portal to publish the Web-

templates.

. Possess good understanding of the change management process.

. Working on enhancement of the existing dashboard using BSP, javascript

and XHMTL.

Environment: SAP BI 7.0, SAP R/3 4.7, Bex Query Designer/Analyzer 7.0,

Report Designer 7.0, WAD (Web Application Designer 7.0), Visual Composer

7.0, BO XI R3, Remedy 6.3

Chevron ITC, Bellaire, TX Oct

'06 - Sep '08

Sr. SAP BI Consultant

Responsibilities:

. Closely interacted with the client to gather requirements

. Developed a VC Application, which utilized WAD and Report Designer,

called PACE to provide consolidated invoice related data for users in

the fields. This application received data from a 3rd party invoicing

company which had to be consolidated and stored in a new BW model.

. Involved in Performance tuning of the queries.

. Installed, configured and managed Technical content or BI Statistics.

. Created statistics relevant queries based on different KPI's around

performance optimization and BI system usage.

. Worked with BI Administration Cockpit - Query Runtime statistics, Data

Load Statistics etc.

. Sent CSV and Excel format data to 3rd party company using Open hub.

. Created complex formatted Web reports using Web Intelligence and

dashboards using Xcelsius.

. Worked on a new implementation of PRA and FICO bringing in of all

utility information from external sources for OSI (an upstream base

business organization for Chevron) utilizing all new 7.0

functionality.

. Worked on InfoSources for general ledger (0FI_GL_1), accounts payable

transaction data (0FI_AP_2), Profitability analysis quick start

(0CO_PA_3).

. Worked on several reports on MM-PUR, SD, FI- AP, AR, GL.

. Worked with team to develop a Portal Cockpit to replace the current

OSI Cockpit. It has new and enhanced features and was built using the

new NW04s WAD along with embedded javascript & portal development

tools.

. Worked with team to ensure deliverables/milestones are being met as

per the project plan as it relates to the portal cockpit initiative.

. Possess good understanding of the change management process.

. Interact with the offshore team and allocate tasks to resources

. Used job-scheduling tools (process chains) to load data.

. Report project status to the client and higher management.

. Hands on experience with SAP IP

Environment: SAP BI 7.0, SAP R/3 4.7, Query Designer/Analyzer 7.0, Report

Designer 7.0, WAD (Web Application Designer 7.0) Visual Composer 7.0,

Business Objects XI, Remedy 6.3.

General Motors, Pontiac, IL. Sep

'06 - Oct '06

Sr. SAP BW Consultant

Responsibilities:

. Schedule and monitor periodic data loads from SAP R/3 to BW. Advise

delta loading and ODS Loading process.

. Worked extensively in loading historical data files (> 15 Million

records) in to production, consolidation, development, and integration

environments.

. Resolve hurdles and ensure smooth and efficient execution of the

project

. Verify the contents of the deliverables and assure quality

. Created Multiple Process chains to schedule the loads for master as

well as transaction data for the whole BW project and helped the

scheduling team to integrate the process chain into the maestro

scheduler.

Environment: SAP 3.5, Process Chains and Maestro Scheduler

The Home Depot, GA.

Sep '04 - Sep '06

Sr. Datawarehouse Consultant

Responsibilities:

. Interacted with the management and the end-users to identify the

business requirements and documented them.

. Developed ODS object to load Sales Order Data using the LO structures,

defined the update rules. Loaded transactional data into PSA and

updated data from PSA to ODS and Activated ODS for reporting.

. Extended the LO Structure to include additional fields. Developed

Function Module to populate the extended structure.

. Involved in the implementation of the PP module. Have good knowledge

of entire extraction and design process of PP. Took advantage of the

Business content.

. Extracted LO data (2LIS_11_VAHDR, 2LIS_11_VAITM) and others using V3

update using standard structures

. Extracted GL data (0FI_GL_6, 0FI_GL_7) using the FI delta mechanism.

. Maintained and monitored GL data loads.

. Created Info sources for Master Data & Transactional data, assigned

Data Source to Info source, Created and Activated Transfer Rules,

Maintained Communication structure, set the update rules for Info

cube, Created & Scheduled Info packages for data extract, and uploaded

data.

. Developed ABAP/4 routines for data manipulation in transfer/update

rules.

. Created & Activated Custom Info cube as per the Data model for Sales

area covering Customer/Material/Sales Organization.

. Developed custom Bex queries against the Info cubes and ODS objects

using Bex Analyzer. Created Drill through Queries from Summarized Info

cube report to detail ODS data. Included Restricted Key Figures &

calculated key figures for filtering and formula requirement of query.

. Responded to Ad-hoc requests with solutions that meet user needs in

creative ways, utilizing technology.

. Created views of the Query for WEB Reporting, Defined Exceptions &

Conditions Published different elements of the views to the WEB.

Environment: SAP BW 3.5, SAP R/3 4.7, Windows NT, BEx Analyzer, SAP MM/PP,

SAP FI-GL.

HCL Technologies, Noida, India

Apr'01 - Nov'02

ABAP developer

Environment: SAP BW 3.0B, SAP R/3 4.6C, Oracle 8i, Windows NT, BEx

Analyzer.

Responsibilities:

. Responsible for working in Data Modeling, Extraction using

DataSources, InfoSources, InfoPackages, Transfer Structures, Update

Rules, InfoObjects, PSA, InfoCubes, and Reporting.

. Identify DataSources in OLTP, start ETL process to extract data from

source systems into BW and finally report the InfoCubes using BEx

Analyzer by creating several periodic and annual reports for various

functions/roles. Involved in the star schema design with multiple

dimensions and fact tables.

. Worked extensively on standard and custom defined LIS, LO extractors.

Installed relevant SAP business content. Used LO structures for

extracting sales order, delivery information. Logistics Cockpit

configuration and customization; Tracing problem to R/3 and

resolution.

. Installed the business content to implement standard InfoCubes of

Sales and Distribution namely 0SD_C01(Customer), 0SD_C02 (Deliveries),

0SD_C03(Sales), 0SD_C04(Delivery Service), 0PUR_C01(MM Purchasing),

loaded data using the InfoSources 2LlS_01_S260 (Sales Order),

2LlS_01_S261 (Delivery), and 2LlS_01_S262 (Billing Document)

2LlS_01_S263 (Sales Order/Delivery), 2LIS_01_S001 (SD Customer) and

2LIS_01_S005 (Deliveries). Used ODS to stage the data before

transferring the ODS contents to the InfoCube. Done ODS reporting to

give details of delivery items and schedule line items.

. Set up procedures for extracting R/3 data for SD using LO-cockpit into

standard InfoCubes. Customized wherever necessary as per customer

requirements.

. Created DB connects for loading data from Oracle function modules for

custom extraction wherever system did not support delta update. Read

database tables directly or read the change pointer tables.

. Set up statistics/aggregates rebuild and event-chains to notify end-

user of report availability.

. Generated reports using BEx Analyzer including RRI's.

Environment: SAP BW 3.0B, SAP R/3 4.6C, Oracle 8i, Windows NT, BEx

Analyzer.

Dr.Reddy's Labs, Hyderabad, India

Jun'99-Mar'01

ABAP developer

1 Responsibilities

. As per the client's requirements, was responsible for the ABAP/4

development for SD, MM and FI/CO modules. It includes development of

Reports, SAP Scripts, Dialog Programs, BDCs and Call transactions,

Function Modules, Subroutines, Includes, Data Dictionary Objects,

Customer Enhancements

. Enhanced many standard SAP Reports/Transactions according to the

customer requirements for SD.

. Modified, customized and enhanced standard SAP programs SD, MM, FI and

CO modules. Developed user exits, created reports using BW, provided

interface to SD.

. Developed dialog modules and transactions for specific clients needs

using screen painter, flow logic and ABAP/4 code for implementing

logic.

. Created a report to compare standard price and price unit versus the

purchase price and price unit and calculate variances, when plant and

purchasing document date are given.

. Giving purchase order no., material no or order type could also narrow

down this report.

. Designed and developed interface programs using BAPI technology for

data load.

. Utilized BDC sessions to simulate online input, developed GUI screens

using ALV.

. Designed Dialog Modules using BADI, also developed ABAP/4 classes,

methods and functions.

. Modified standard layout set to get the company header and logo,

supplier address, delivery address, total purchase order value and

general terms and conditions.

. Setting up customized InfoCubes with optimal star schema, InfoCube

partitioning for query performance. General ledger (0FIGL_C01),

accounts payable transaction data (0FIAP_C02), published key figures

(0COPA_C01) and quick start (0COPA_C03) is customized according to the

client requirement. ODS objects are created for data staging before

InfoCube loading.

. Worked on InfoSources for general ledger (0FI_GL_1), accounts payable

transaction data (0FI_AP_2), Profitability analysis quick start

(0CO_PA_3).

EDUCATION

. Masters in Computer Science.

. Certified SAP BW Professional from mysap.com.



Contact this candidate