Sales Data

SATISH K INTI

SAP-BW-HANA Consultant

SAP BW/BOBJ Solution Consultant

SAP Business Intelligence consultant with 11+ years of IT experience with

9+ years of SAP BOBJ experience in providing reporting solutions using SAP

technology. Have experience in 4 Full cycle BW implementations.

SAP BW/BOBJ 9 years of experience in SAP BW 7.x, 3.x

Enterprise Portal experience, Performance tuning

experience, Data Modeling experience, Production

Support experience

Reporting Tools SAP BEx, Web Analyzer, Query Designer, WAD, Report

Designer

SAP BO WEBI, Crystal 4.x, Xcelcius (Dash Boards),

Universe Designer, Data Services

SAP Latest BI Trained in SAP HANA, (Planning to do SAP HANA

Technology Certification) SAP Business Object 4.0,3.x

SAP ERP Knowledge Strong functional knowledge in data related to SAP

SD, CO-PA, MM QM,APO, FI, HR, SRM and CRM

Knowledge in various business processes like

Purchase to Pay, Order to cash, Supplier

Relationship Management and Finance

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

SRM 7.x, 5.x, sybase

Project management Strong experience in interacting with the client,

related blue print experience, reporting requirements

gathering experience, designing experience,

experience in leading BI team and providing end to

end reporting solution from design to production

support

Industries Electronics, Public Sector, Consumer Discretionary

Education

Bachelors Engineering

Software Languages Java, ABAP, SQL, C, C++, SQL

Summary

. Involved in multiple complete life cycle implementation of projects

from project initiation, project planning, designing, developing

functional systems integrating with SAP ECC, CRM, SRM, SCM with SAP BW

and Business Objects.

. 4 years of SAP experience with expertise in SAP HCM and SAP BW.

. Has expertise in SAP HCM- including PA, PD, Time management, Payroll,

Talent Management, FI/CO-HR Integration, ABAP/Ad-hoc Queries, ESS&

MSS, ALE customizing and basic ABAP Programming.

. Active participation in all phases of BW/BO project including

requirements gathering, modeling, design & development, extraction of

data, reporting, performance tuning and deployment.

. Expertise in analyzing, designing, creating and maintaining InfoCubes,

DSO objects, Remote Cubes, Multi Providers, infosets, Infoobjects,

InfoSources, and Extract Structures

. Expertise in Flat file, Generic DataSource, LO Cockpit, and COPA

extraction.

. Strong knowledge of Performance Tuning using Aggregates, Rollups, BW

Statistics, Indexing, Partitioning, and Compression.

. Experience in BW components like DataSources, Full/Delta upload,

Scheduling, Process Chains, Data Mart, Legacy Systems, XML and DB

Connect

. Worked heavily on SAP BI/BW backend enhancements using ABAP.

Experience in using ABAP/4 to create start routines, End Routines,

transfer routines, updates routines.

. BW Transports: Involved in testing the extractors, data loads and

reports before going into production & transporting the BW objects

from Development to Quality and subsequently into production.

. Adept at designing and developing queries in BEx Analyzer, Query

Designer using exceptions, conditions, calculated & restricted key

figures and variables, and publishing them on the web. Developed web

reports using the Web Application Designer (WAD).

. Created Info spokes for exporting data to external systems.

. Proficient with Business Objects (BOBJ) WebI, BO-Web I rich, Universe

Designer, Live Office, Query as a Web Service, and Xcelsius 2008

. Used Xcelsuis for dash board reporting.

. Experience in development of SAP Universes in Designer against SAP BI

Cubes and BEx Queries.

. Experience in BOBJ 4.0 integration with BW. Expertise in Business

Objects tools, such as Scheduler, Designer, Data Integrator, and BO

Universe design.

. Expert in managing System Management Tools like CCM, CMC, Import

Wizard and Publishing Wizard.

. Created Analytics and Dashboards using Performance Manager and

Xcelsius to enable executives track progress and compare current and

historical performance against established targets.

. Designed and Developed 30+ dashboards including Data from SAP BW

through Bex Queries, Data from Universe using QAAWS, Data from Webi

reports, Crystal Reports using Live Office.

. Created Complex Dashboards using Crystal Solutions Dashboard and

Visualization (XCelsius).

. Used Crystal Dashboard design and Crystal Presentation Design (both in-

built templates and customized templates) to transform complex data in

a more consolidated and powerful interactive dashboards.

. Created interactive Executive Dashboards, Charts, Graphs, and

Templates & Technical Designs using XCelsius (What You See Is What You

Get representation).

. Familiarity with Business View Manager and Crystal Reports 2008 and

Crystal Report Enterprise.

. Knowledgeable in SEM BPS/BPC.

. Trained in SAP HANA and preparing for HANA Certification.

. Experience in SAP HANA data modeling using attribute view, analytical

view and calculation view.

. Experience in SAP HANA Data provisioning using SAP LT replication

server (SLT) and data server.

EDUCATION:

B.E in Electronics & Communications Engineering, CHENNAI, INDIA

TECHNICALSKILLS:

ERP : ECC 6.0/5.0,CRM 5.0, ISU, SAP R/3 - 4.6 B,

4.6C, 4.7

Business Warehouse : Nw2004s (BI 7.0/7.3), IP, BPC, SAP BW

7.3/3.5/3.1C/3.0B.

Languages : ABAP/4, C, C++, JAVA, SQL

Databases : HANA1.0, DB2, IMS-DB, ORACLE 9i/8i

Reporting Tools : BEx, Webi, Crystal Reports10, BO/Xcelsius, BI 4.0

EXPERIENCE:

Juniper Networks, Sunnyvale CA

May'12 - Till Date

SR BI/BOBJ DEVELOPER.

The world's top 100 service providers-the biggest and busiest wire line

and wireless carriers, cable and satellite operators, content and

Internet services providers, and cloud and data center providers-run on

Juniper Networks.

Business Area

. ACX Series Universal Access Routers are environmentally-hardened,

compact access routers that deliver industry-leading performance and

simplified provisioning.

. The CTP Series Circuit to Packet Platforms provide the advanced network

router technology and features required to reliably transport TDM and

circuit-based applications across next-generation IP networks.

. The E Series Broadband Services Routers play a critical role in the

networking control, delivery, and accounting of services at the network

edge.

. The JCS1200 Control System allows you to independently scale control

and forwarding planes to enable rapid service rollouts, lower costs,

and enhance operational efficiencies.

Lead Role:

. Managed the Project team, assigned work and metrics reported to Client.

. Lead and designed legacy system interfaces to SAP.

. Worked with Senior Management on business process re-engineering,

providing advice on business structures and how they best align with

SAP and best business practices, and keeping in mind that this is

public sector State Government and not private sector business.

Implementation:

. Responsible for Business Blueprint, configuration and implementation of

Enterprise structures, Organizational Management, Personnel

Administration, and Payroll. It's a full cycle SAP BI implementation as

a Techno functional team leader.

. Designed data model and led team in developing new reports.

. Generated a new Sybase IQ, SAP HANA from an ESP Schema Model

. Constructed reusable templates to speed ETL development in BODS and

provide auditing functionality. Led training sessions explaining

usage of templates and gathering ideas for improvement.

. Created executive summary and framework (Xcelsius) dashboards,

including hierarchical selectors, flash variables (linking to

dashboards), and dynamic sales and marketing information.

. Built Crystal Reports detail reports connected to BI services pointed

at Web Intelligence blocks containing BEx query details. Reports

launched by and received prompts from Xcelsius dashboard.

. Created WebI, Crystal, and Xcelsius reports with SAP data HCM.

. Implemented BO 4.0 with IDT and BICS.

. Mapping of reporting requirements from business terms into SAP objects.

. Currently leading efforts to rewrite the Agent Compensation reports to

support the rollout of new application. Assist in the review, analysis,

and implementation of new reports or system changes as required by new

authoritative accounting guidance.

. Designed and implemented numerous accounting systems including

applications such as G/L, A/P, A/R, F/A, and Financial Reporting.

. Uploaded cost center data (CO-PA) into cost center for analyzing actual

and plan data, replicated data sources, and made delta uploads using

time stamp method

. Building SD order ODS (SD), Co-PA ODS (FI-CO), A/R ODS (FICO), order

items ODS (SCOR-Supply Chain), shipment cost ODS update

Transformation, and update routines as an input to the same

consolidated ODS to view the overall Waterfall" structure of financial

figures at a granular level

. Worked on payroll data info cube (0PY_C02), where loaded the data from

payroll data (0HR_PY_1), which contains all payroll result wage types

and organizational assignment for the employee grouping. Implemented a

wage type hierarchy. Compared previous year with respect to current

year

. Installed, Configured and Deployed entire BI 4.0 SP4 system & other

softwares on Windows 2008 Server in a clustered Environment.

. Extensively used Central Management Console (CMC) in setting up

security in BI 4.0 and also manages security configuration for various

reports and universe in development, Test and production environment.

. Performed a Huge Upgrade to Migrate the BI Content from BOXIR 3.1 to

SAP BI 4.0SP4 using the migration Utility Upgrade Management Tool (UMT)

and also involved in deployment plan, Migration and system Upgrades, Co-

Existence Planning, Deployment services and Education delivery.

. Installed and configured Business Objects BI 4.0 to test the

functionality between BO XI 3.1 and BO BI 4.0 and migrated BOBJ

Environments from BO XI 3.1 to BO BI 4.0 using Upgrade Manager as well

as used Life Cycle Manager (LCM) to promote content between

Development, Test and Production environment.

. Responsible to Maintain and Migrate Universe & Reports on Dev, Test,

Pre-Prod and Production.

. Implemented Federation (R3.1) and Multisource Universe feature on

Information Design Tool R4.0.

. Created BICS connections to connect directly to a SAP BEx query or a

SAP BW InfoProvider.

. Successfully Promoted the BI Content on the Production Go Live cut over

timelines and overcome the challenges in supporting the end User

queries.

. Extensively worked on Performance Tuning of Business Objects XI 3.1

Universes and Reports against Teradata & Oracle and changed existing

Universes using Universe Designer, redesigned/improved Reports

requiring custom SQL in Web intelligence.

. Involved in Performance Tuning of Teradata SQL using explains plan and

understanding Joins and Data distribution and Associated with ETL &

Database teams for performance improvement and provide constant updates

about the necessary changes required.

. Developed dashboards using the enhanced Dashboard Designer 4.0 tool

on Business Objects R4.0.

. Developed dashboards which get the complete details of the sales info

for the client to analyze the scenario and a simulation model for the

projected sales for various products.

. Created Xcelsius Dashboards for Accounts Payable Metrics (days payable

outstanding, average payable period), Budget vs. Actual Performance

Metrics.

. Created single or multi line chart for showing tendency over a period

of time particularly used in revenue history and also created graphical

representation of reports such as Bar charts, 3D charts, Pie charts,

Column chart, Line chart, Bubble chart using xCelsius 2008.

. Created Business requirements documents for the modifications required

for the reports and Universe, which included testing strategy, Business

Objects fix and Business requirements etc.

. Cloned all folders, reports and universes, updated connections for new

universes, re-pointed reports to new universes and updated logos.

. Converted complex reports from DESKI to WEBI Using

Report Conversion Tool.

. Resolved different issues in UAT after Converting reports from Deski to

Webi.

. Used import Wizard to migrate reports, folders, users, groups,

universes from different environments.

. Worked on Cut-over activities and data validations and post. Go-live

support.

Environment: HANA, BODS,SAP BI 4.0,MS SQL server 2008/2005, Oracle

11g/10g, Informix 3.70, MySQL, IBM DB2, Teradata, Toad, Teradata SQL

Assistant, LDAP, Live Office, QaaWs, WebFarm/CSS, Crystal reports

2011/08, Dashboard 4.0, Xcelsius 2008, Windows 2008/2005 server, and

Windows XP.

PRATT AND WHITNEY, Dallas, TX

Dec'11 - April'12

SR BI-BO REPORT DESIGNER

Pratt & Whitney Canada is currently seeking qualified applicants to ensure

a strong pipeline of future talent in support of development programs

across our market segments.

Business Area

. Parts for Sale: Pratt & Whitney Canada maintains a comprehensive, fully

computerized spare parts distribution system and provides the highest

level of support to the operators of P&WC engines worldwide.

. Component Repairs: P&WC performs repairs on components related to the

P&WC family of engines including the PT6, JT15D, PW100, PW200, PW300,

PW500, PW600 and PW900 series engines.

. Accessory Repair & Overhaul: Accessories Services business unit is

devoted to accessory management and offers a one-stop shop for all your

accessory maintenance requirements.

Lead Role:

. Responsible for overall sap data migration analytical reports project

management.

. Review, Analyze project plans, project status, and communicate to sap

project teams and senior management.

. Responsible for sap technical leadership, designed, developed,

maintained, tested, and documented enhancements, and reports.

Implementation:

. Actively participated in the blueprint phase of SAP HANA project

regarding the architecture phase.

. Created and ran ETL jobs to load and manipulate Material Master and

Vendor SAP information.

. Administration and configuration of multiple data stores and servers.

. Upgrade of First Logic / Data Quality to Data Services, with data and

multiple country address cleansing.

. Developed, published, and scheduled batch and real-time jobs.

. Responsible for the development of strategic documents including the

technical specs.

. Acted as key developer, leading a team of four (mostly remote)

developers in the creation of Webi reports, universes, and Xcelsius

dashboards consisting of Plant Maintenance information.

. Performed the data analysis and data modeling for the SAP PM reporting

project

. Developed Proposal list Report for different vendor for SAP-HR.

. Installation and configuration of Business Objects Enterprise and Data

Services, including Data Quality.

. Creation, improvement, and documentation of HCM reports and related

universe, including standardization and applying best practices.

. Involved in Information Design Tool - Creation of Data Foundation,

Universe for HANA reporting.

. Participated in requirement meetings with clients and stakeholders

. Generated reports using BEx Query Designer with SAP CRM as a source

system.

. Designed the mapping templates for data extraction and loading and

supported ETL developers

. Designed and implemented Plant maintenance Cubes (0PM_C03

Maintenance Orders), DSO, Data Sources (2LIS_17_ORDER) in SAP BI data

flow.

. Designed and developed "Dashboard-like" Web Intelligence reports by

linking across various charts and components through interactive use of

input controls.

. Created Live data connected Dashboards for the Executive Dashboard

portal using Crystal, Xcelsius to provide the business analysts a

summarized glance of the reporting environment in an interactive

manner.

. Extracted data source for cube from SAP transactional system and flat

files.

. Various other forms of dashboard development also performed including

Data from SAP BW through Bex Queries, Data from Universe using QAAWS,

Data from Webi reports, Crystal Reports using Live Office.

. Dashboards Using Advanced Multiple Drills Down, Dynamic Visibility, and

Alert Features were designed to support Complex Requirement Scenario.

. Design, develop, and implement Xcelsius dashboard against SAP BW data

sources. Established the design pattern for all future Xcelsius

development using Live Office and QaaWS as connectors.

. Created Xcelsius Dashboards for Overall Sales Volume (sales per

product, Group, customer segment), Billing and Collections (AR) Metrics

(days sales outstanding, average collection period).

. Developed Cross Tab Reports, Sub Reports by using Crystal Reports 2008

and embedded Xcelsius onto Crystal Reports for better results and also

provide users with clear understanding.

. Developed different types of reports with features like Ranking,

Filtering using Crystal Reports.

. Extensively worked with Crystal reports using parameters and record

selection formulas to allow the users to filter the data, and also

solved any issues/errors encountered.

. Scheduling daily, weekly and monthly reports using BO XI Scheduler

using Events, creating Calendars. Upgraded BO XI R2 to BO XI R 3.0

Enterprise Environment.

. Implemented all phases of the project life in Business Objects

Enterprise XI 3.1 cycle including analysis, design, development,

testing, deployment and post-production support/maintenance.

. Involved in the Tuning the SQL and Query Performance issues.

. Conducted presentations and seminars with business owners and financial

supporters to deploy.

Environment: BI 7.0/7.3 Flat Files, BEx, BODS,BI 4.0.HANA, Business

Objects XIR 3.1, Designer, Crystal Reports 2008, CMC, Web Intelligence,

Dashboard Manager, Desktop Intelligence, Import Wizard, Xcelsius 2008,

QAAWS, Live Office, Data Services XI 3.1, Oracle 10g, Teradata SQL

Assistant, TOAD, DB2, SQL Server, UNIX, Windows server 2008 and Windows

XP.

HOSHANCO, Madison, WI

April'09-Nov'2011

SAP BW/BO DEVELOPER

BI 7.0 Implementation -Retail

Responsibilities:

. Prepared the Road map of SAP BI and IP.

. Created Aggregation levels, Data slices, Planning Functions, Planning

Sequences, Filters and variables.

. Created POSDM DSOs and Inventory Stock and Movements Cubes for Retail

Implementation.

. Designed and developed Business Objects Universes to support the new

sales reporting requirements of business users.

. Automated document Scheduling, Publishing and Distribution for WebI and

Desktop Intelligence clients, using the Central management Console

(CMC).

. Designing and implementation of Universes using Business Objects

Designer.

. Analyzed the existing database and designed the Universes using

Business Objects Designer Module for generating reports.

. Created Cardinalities, Contexts, Joins and Aliases for resolving Loops

and checked the Integrity of the Universes.

. Exported the universes to the Repository to making resources available

to the users.

. Generated reports using business Objects Report Designer.

. Created parameterized crystal reports and customized existing reports

for presentations using Summary reports, Detail reports, Cross-Tab

reports and Sub-reports.

. Assigned the privileges to users using Central Management Console

(CMC).

. Created and customized application dashboards using Performance

management to meet the requirements of higher level analysis.

. Developed dashboards and scoreboards for detailed analysis using

Xcelsius 2008.

. Developed an implementation strategy of new features in BI 7.0 which

includes new data flow, re-modeling, integrated Planning, Real-time

Data Acquisition, and enhanced features of Process Chains etc.

. Tested the ETL process with new data flow using emulated data sources.

Also tested the old dataflow for the data sources which are not

emulated and cannot be uploaded using new data flow process i.e.

Transformations and DTP (Data Transfer Process).

. Performed Data Extraction and Data Staging using CO-PA and extended the

structures using user exits to support the business needs.

. Created DSO and loaded data from different staging DSO's by executing

Start Routines & End Routines at transformation level in BI.

. Created Real-time Infocubes and Multiproviders which supports real time

data to access updated data records every minute and every hour

according to the business requirements.

. Scheduled and Monitored InfoPackages and Job load Process with

automation of standard loads after initial runs using Process chains.

. Created BEx reports with Exceptions, Variables, Restricted and

Calculated Key figures for detailed level reporting.

. Involved in creating and moving Transports from Development to

Production using specific transportation tool GSKC (Global SAP

Knowledge Center).

. Successfully resolved various issues during BW migration from BW 3.5 to

Net Weaver.

Environment: SAP BI 7.0, BW 3.5, ECC 5.0, BEx Analyzer, Query Designer,

Report Designer, Web Application Designer, Crystal Reports 2008/ XIR2,

Web Intelligence, Oracle 10g, SQL Server, DB2, Windows XP.

ALLEGHENY ENERGY, Pittsburgh PA

Feb'08 to Mar'09

LEAD Consultant

Responsibilities:

. Monitoring Chains on Daily Weekly, Monthly.

. Loading Master data, Transaction data into the SAP BW on daily basis.

. Handling the tickets raised by the market.

. Worked in BW 3.5 to 7.0 upgrade project

. Involved in report migration from BW 3.5 reports to BI 7.0

. Analyze the errors in the data loads.

. Using Lo cockpit configured and maintained MM data sources.

. Uploading Master and Transactional data from Flat files and SAP as the

OLTP sources, worked extensively on Administration workbench.

. Installed Business content as and when required.

. Involved in Creation of reports using BEx Analyzer such that the

execution time is evenly distributed through the report by using Free

Characteristics, Restricted Key figures, calculated key figures,

Variables and Exceptions.

Environment: BW 7.0, CRM 5.0, ECC 6.0, WAD

PANASONIC, SECAUCUS, NJ

Feb'07 - Jan'08

LEAD Consultant

Responsibilities

. Involved in the upgrade from BW 3.5 to BI 7.0 and tested the

configuration of all objects in BI system.

. Created Transformations and Data Transfer Process(DTP) in BI 7.0 for

PCA and HR cubes

. Created Info Cubes, Info Sources, Transfer structures, Transfer rules,

and Communication structures, Update Rules and Process Chains and

Aggregates.

. Data Load Monitoring and fixing the load problems in Master Data and

Transaction Data for PCA, HR, Shipments, Inventory Management, Asset

Accounting, Material Ledger, AR, AP, COPA, BPS, and APO Demand

Planning(DP) and Supply Planning Network(SNP) and Product Costing and

Service Orders and Notifications cubes.

. Extensively Used Process chains and all jobs are controlled by a UC4

scheduler.

. Data load problem resolution using Remedy trouble ticketing system.

. Performance tuning using Aggregates, Compression, Query tuning using

RSRT, RSDDSTAT.

. Created Data Transfer Processes (DTP) and used in process chains.

. Enhancements to the existing Product Costing Cube.

. Crystal Enterprise folder maintenance using Management Console

Environment : SAP BW 3.5, /7.0 R/3 ECC5.0 (MM, SD, FI-CO), SEM 4.0, BEx

Analyzer, WAD

KBC CINCINNATI, OH

Nov'05 - Feb'07

LEAD Consultant

Responsibilities:

. Managed the Project team, assigned work and metrics reported to

Client.

. Communicated Weekly status updates to client with the tasks analysis,

scope and risks if any.

. Discussions with VP on SOW and scope of the project.

. Completed the feasibility study of the current business process

functional specifications and identified the relevant areas for

customizations.

. Involved in upgradation of BI from BW 3.1C to BW 3.5.

. Tested the System Configuration Settings for all Objects in BW 3.5

System

. Implementation of BW PCA for UPI (Universal Pictures International,

UK) with 0EC_PCA_1 DataSource.

. Regression Testing of Project Juice (PeopleSoft to SAP Migration) BW.

. Created InfoCubes, InfoSources, Multi-Providers, Transfer structures,

Transfer rules, Communication structures, Update Rules.

. Implemented Deltas for PCA and FI-SL by applying OSS Notes to R/3 4.6c

which does not support Deltas.

. Scheduled and monitoring of data loads from R/3 during Quarter close

activities for CCA, FI-GL and PCA and SPL cubes.

. Extensively worked on Process Chains, created Daily Monitoring chains

using RSPCM of Financial Data Loads for PCA, CCA, FI-SL and FI-GL.

. Worked on Master Data Attributes and Hierarchies for Profit Center,

Account, and Company Code data.

. Transported BW objects from Development to QA for testing using Lotus

Notes MDM process and created Kintana CCP ticketing to move transports

to BW Production (Change Management Process).

. Performed various tuning techniques (aggregates, statistics and Query

Cache) to optimize the query performance.

. Developed flexible queries on MultiProviders using filters,

navigational attributes, variables, calculated key figures, restricted

key figures in BEx analyzer to facilitate data analysis in a drill

down or summarized way to give detailed level of information.

. Created Views and Web Templates for PCA Work Books by using WAD.

Environment : SAP BW 3.5/3.1C, BI 7.0, R/3 4.6C (FI-CO, SD, MM), SEM 4.0

BAE LOUISVILLE, KY

Aug'05

- Oct'05

SAP BI Consultant

Project: BW 3.5 Implementation

Responsibilities:

. Involved in Project Development and Go-Live.

. Worked extensively on LO extraction for Sales Billing Documents,

Purchasing Data, and Inventory Management.

. Created ODS and loaded flat file for Rebate Calculation according to

Purchase organization, distribution channels, ship-to-party customers,

material and vendor line items.

. Process Chains development (Master Data Attributes, Texts, Hierarchies

and Transactional Data) for Sales, Rebate, Purchasing, and Inventory

data.

. Scheduled the Process Chains for master and transactional data loads.

. Used V3 update for delta for uploading data from R/3 to BW in specific

intervals.

. Transported BW objects from Development to Q&A and production.

. InfoCube compression on Inventory Cube to optimize the query

performance.

. Extensively worked on BEx Analyzer and Web Application Designer.

. Created various BEx reports for Sales Billing Documents, Purchasing,

FI-GL, and Inventory Management.

. Training to end users in query development-using BEx.

Environment : BW 3.5, SAP R/3 4.7 FI-CO/MM, SD,HR

WORLD BANK WASHINGTON, DC

Mar'05- Aug'05

Sr. SAP BW Consultant

Responsibilities:

. Completed the feasibility study of the current business process

functional specifications and identified the relevant areas for

Customizations.

. Created and activated InfoCubes, InfoSources, Multi-Providers,

Transfer structures, Transfer rules, Communication structures, Update

Rules (both ODS and InfoCube level) and conversion techniques.

. Worked extensively on standard and custom defined CO-PA and LO

extractors.

. Extensively used LO extract structures and data sources in material

management to facilitate the data extraction to BW.

. Made enhancements according to the requirements and wrote ABAP

routines in Transfer rules, Update rules and Start routines.

. Involved in design, development and extraction from R/3 systems and

flat file for FI/CO, MM and SD.

. Created ODS for incoming sales orders according to sales organization,

distribution channels, ship-to-party customers, material and vendor

line items.

. Uploaded master data and transactional data from SAP R/3 via data

staging to PSA, ODS and InfoCubes. Worked with data flows from R/3 to

BW.

. Used V3 update for delta for uploading data from R/3 to BW in specific

intervals.

. Transported the objects from Development to QA for testing.

. Extensively used process chains to automate the process of loading

data into data targets.

. Performed various tuning techniques (aggregates, statistics and

partitioning) to optimize the query performance.

. Developed flexible queries using filters, navigational attributes,

variables, calculated key figures, restricted key figures in

. BEx analyzer to facilitate data analysis in a drill down or summarized

way to give detailed level of information.

. Worked on RRI jump queries, web publishing and ODS queries.

. Configured alert monitor, Job schedule monitor, Exceptions handling

and user role maintenance.

. Involved in creation of role based security and authorization for

certain InfoCubes and Info Objects.

. Training end users in query development-using BEx.

Environment: SAP BW 3.1C, SAP R/3 4.6C, FI/CO, SD, MM, BEx, Web

Application Designer

GE NEW YORK, NY

Feb'04 - Feb'05

SR SAP BW CONSULTANT

Responsibilities:

. Created and Activated Communication Structure, Transfer Structure,

Transfer rules and Update Rules.

. Data extraction from SAP R/3 using LO Cockpit and Generic extractors with

generation and maintenance of Extract structures, data sources and

transfer & update rules.

. Design and development of Infocubes, Multi providers, ODS.

. Data and reporting analysis and modeling for BW Extended Star Schema.

. The Cubes and ODS developed are Sales, Customer, Deliveries InfoCubes,

Sales Order ODS, Revenue ODS, Shipment ODS and Backlog ODS.

. Created custom and modified standard Info Objects based on Master and

Transactional data from SAP and flat files into BW.

. Created Aggregates to improve the Query performance.

. ODS creation and maintenance for data manipulation and for drill down

reporting

. Developed several queries and the workbooks using BEx

Contact this candidate