Atul Sood

SAP BI-BPC/BOBJ Architect

abmli9@r.postjobfree.com

Address: **** * **** *****, ***** OK 74133

Ph: +1-918-***-**** / 314-***-****

Visa Status: Green Card

Summary of Experience:

. 11 years SAP BW 3.X / BI-7.0 / BPC (Outlook Soft/NW)/ BOBJ and

SAP R/3 experience, 9 years of IT experience and 9 years industry wide

Experience.

. Global experience as SAP BI expert with various IT Industries,

and in multiple countries - United States, India, Singapore, New

Zealand, and Qatar.

. 5 Full Life Cycle Implementations: 5 E2E Implementations in SAP

BW 3.X / BI 7.0/SAP BPC(NW) with SAP Enterprise Portals(5.0/6.0/7.0),

and one E2E Implementation in SAP R/3 in SD Application.

. Post Go Live support and Help Desk Support: 3 years as SAP R/3

Analyst and 8+ years in SAP BW/BI Developer/Architect.

. BOBJ: Planned, developed, deployed BI reports using BO XI 3.1 on

WEBI/InfoView, Crystal Report 2008, Universe Designer, Xcelsius 2008,

query as web service in xcelsius for Summarized and detailed reports

and graphs by creating Database Connections with SAP BI

InfoProviders/Queries. BOBJ(CMS) and SAP BI-BOBJ integration.

. BW/FICO/IP - BPC: Very Strong with FI(AR, AP, GL)/CO(PA, Enterprise

Controlling, CCA, Overhead Projects) integration concepts, Month end

FI processes, Finance Planning and (Legal/Management) Consolidation,

Script Logic, Work Status, Custom Menus, Security, Intercompany

eliminations (AR/AP, REV/EXP), Ownership, Validation, Balance carry

forward, Currency conversion, REV/EXP Planning, Budgeting and

forecasting, Expertise in building Input Schedules/ Reports using

EVDRE, EVHOT, EVSND, EVCVW, EVDES etc. BPC Functions and DM functions.

. ASAP Implementation Methodology Phase wise Experience:

. AS IS/TO BE Study and Analysis: 20%

. Business Blue Print: 20%

. Realization: 30%

. Transports and Testing: 5%

. Documentation and Training: 5%

. Go - Live and PGL Activities (Performance tuning etc.):

20%

. 10+ years of SAP Experience ( 8+ years with SAP BW and 3 years

with SAP R/3)

. Six months as Project Manager (R/3 Applications, APO, BW,

SCM, SD, FI).

. Two and half years as Solution Architect

(BW/BI/BOBJ/BPC(SCM,FICO,LO)

. One year and Six months as Lead Consultant

(BW/BI7.0/BOBJ,CRM/SCM/FICO/IP/BPS)

. Three years as Developer(Sr.) (BW/BI-7.0, R/3 SD,SCM,FICO.

BPS,BCS,IP)

. Three years as SAP Business Analyst (R/3, BW, APO,FICO)

. SAP Environmental experience in:

. Implementation Experience with BI NetWeaver 2004s (BI-

7.0), BI NetWeaver 2004(SAP BW 3.5), SAP BW 3.1C with 3.3 add-

on, 3.0B, 2.1C, 2.0B.

. SAP Front-end tool Business Explorer (MS-Excel & Web), Web

Application Designer and SAP Enterprise Portals(5.0/6.0/7.0)

. Integration Experience - SAP CRM (4.0 & 5.0), SAP - APO

2.0 & 3.1, Supply Chain Management (SCM) with SAP BW.

. SAP Solution Manager 3.1(Testing and Tracking).

. Experience in SAP ECC 6.0/5.0, SAP R/3 Releases 4.7 EE,

4.6C, 4.6B, and 4.0B environments and involved in one SAP R/3

SD implementation.

. Know complete document flow of Order - to - Cash & Procure

- to - Pay. Fairly strong in Revenue Reporting, Forecasting

Reporting, Gross Margin Reporting, Forecast Accuracy

Reporting, Backlog Reporting.

. Well versed with SAP Change Management and Post go-live

support functions (Performance Tuning).

. SAP Hands -on Expertise:

. BI NetWeaver 2004s (BI-7.0) - Backend & Front-end

. SAP BW Data Modeling (Back - End).

. SAP BW ETL Back - End: SD, MM - Inventory, Vender

Evaluation & Procurement, SCM, FI-GL, FI-AR, FI-AP, FI-AA, CO-

PA, CCA, PCA, PS, PC, IP, BPS, HR- Benefits, PA & OM, and

Generic Extractions. Extensively worked on Transfer Rules for

semantic consolidation and Update Rules for applying Business

rules using various transformation functions and logic.

Scheduled Data Loads using Process Chains and DTPs (Date

Transfer Process). Experience working with Open Hub Services.

Experience working with Start routines and End Routines and

Customer Exits using ABAP.

. SAP BI/BPC Application sets, Dimensions, Alternate

Hierarchies, Excel Reports, Script Logic and other Logic

options such as Worksheet Logic, Dimension Logic, and

Advanced Logic, Dynamic Templates, Input Schedules, SSIS

data manager packages, Transformation and Conversion files,

Work Status, Security, Custom menus, BPFs, Macros, eVDRE and

other eVXXX functions.

. SAPBW 3.x/ 7.0 Front-End: Roles, Worksets, Pages, iViews

and their assignments with delta relationships. Published SAP

BW queries and views onto SAP EP Portals (5.0/6.0/7.0) using

BEx Web Application Designer. Sound Knowledge of SAP

NetWeaver 2004s (BI 7.0) new front-end Tools- BEx Analyzer,

BEx Query Designer, BEx Report Designer, BEx Web Application

Designer, Information Broadcasting, SAP NetWeaver Visual

Composer and Analytic Authorizations. BOBJ: BO XI 3.1 on

WEBI/InfoView, Crystal Report 2008, Universe Designer,

Xcelsius 2008.

. mySAP CRM 4.0 & 5.0: Worked on mySAP CRM 4.0 & 5.0 : CIC,

and Sales (Activities, CRM Surveys and Service Order

Management) reporting requirements using SAP BI NetWeaver

2004 and SAP BI NetWeaver 2004s.

. SAP Solution Manager 3.1: Worked with Testing Functions

(issue assignment/ issue tracking/ escalation/ team

performance - Application wise).

. SAP Solution Document Development using SAP Solution

Manager, SnagIt, and RWD InfoPack.

Technical Skills

. SAP Backend: SAP BI NetWeaver 2004s(BI-7.0), and worked on

various reporting requirements for Application- mySAP CRM

4.0, APO, SD, FI-AR, FI-GL, FI-AP, FI-PCA, FI-CCA, BW-BCS, BW-

BPS, FI - AA, FI - PC, CO-PA, IP/BPS, MM, PP and SAP Payroll.

. SAP Front-end Tool: Business Explorer (MS Excel & Web),

Web Application Designer. Web Templates, Work books and

IP/BPS Reporting.

. BOBJ: BO XI 3.1 on WEBI/InfoView, Crystal Report 2008,

Universe Designer, Xcelsius 2008.

. Softwares: MS Office, Adobe Photoshop and Reader, MS

Window's accessory tools.

. O.S.: MS Windows, Windows NT, 2000, XP, UNIX and HP-UX, MS

DOS.

. RDBMS: MS SQL Server, DB2/400, Oracle.

. Domains: Logistics, Marketing, Sales, Purchase, Finance,

Customer Service and Maintenance.

Projects:

The NORDAM Group., Tulsa, OK, USA

SAP BI/BOBJ Support/Enhancement/upgrade/New Implementation Project

Mar'09 - May'10

. Worked as SAP BI/BOBJ Architect.

. SAP BI 3.5/7.0 Support/Enhancement Project for US, UK, Mexico,

Singapore Aerospace operations.

. Worked on SAP BI 7.0/FI & CO(FI and CO), BI 7.0/APO, BI

7.0/MM-IM, BI 7.0/SD, BI 7.0/PP, BI 7.0/HR (PA, Payroll and

Benefits) and BI 7.0/MRO(Labor Hours and TAT).

. Developed and deployed BI reports using BO XI 3.1

-WEBI/InfoView, Crystal Report 2008, Universe Designer, Xcelsius

2008 for Summarized and detailed reports and graphs by creating

Database Connections with SAP BI InfoProviders/Queries. Used CMS

for authorizations and BOBJ administrative tasks and participated

with BASIS team for SAP BI-BOBJ integration.

. Upgraded to SAP BI 7.0 Security using RSECADMIN (New

Authorization Concept).

. Executed Support Pack Upgrade (SP 14 to SP 19) and tested

all existing and new functionalities) functionalities.

. Production support (periodically on call) through Help Desk

Tickets.

. Resolved many issues referring OSS notes and applying it. In

couple of cases we had to escalate to SAP Service Support.

. Created/updated Microsoft Project Plans periodically with

detailed up to hourly tasks with resources for each project.

. Implemented E2E project for SAP Labor Details Reconciliation

reporting End to End solution (Internal/ Production/ Service/

manufacturing Orders) /KABA -SAP Labor exception Reconciliation

(KABA is a legacy System) / ADP -SAP Payroll Data reconciliation

(ADP Legacy System( for payroll)). It was 100% custom solution.

Also created WEBI reports and published using Infoview.

. Worked on MRO End to End Turn Around Time Reporting End to

End solution (Maintenance, Repair and Overhauling) for 2 stage

Turn around time ("Dock to dock" and "Operational") which

includes data extraction of Production Orders, Service Orders (5

stages). This was 100% Custom solution

. Worked on Project Systems/WBS Elements (Costs,

Revenues,Quantities) for Pan/Actual Costs reporting End to End

solution, by using filter values from Account Type, Offsetting

Account Type and Functional Area in the Queries. Used Custom

DSs/ABAP Enhancements to pull Master Data/Transaction Data of

these objects from T003T, TFKBT,COVP, COBK, and COEP tables.

. Worked on Standard BI Content Procurement End to End

solution(part of P2P Scenario) with 20% changes to fit to

NORDAM's reporting requirement and delivered Custom reports,

assigned security and published on EP Portal. Enhanced standard

extractors and created Transformations using Start/transformation

routines.

. Worked on Inventory management reporting with snapshot

scenario for non-cumulative key figures. Worked on APO issues

bringing Standard price for Material Valuation and various

reports. Worked on SD(part of OTC) data loads and resolved

support issues.

. Improved query execution performance and load performance

using Indexes on DSO and also created Aggregates to improve Query

performance. Created DTPs in the staging layer.

. Used BOBJ Enterprise to create/schedule/publish Crystal

Reports 2008(formatted/Groupwise), multiple WEBI(by merging

multiple queries into one query) and DESKI(on multiple

Datasources of information - offline) reports on Universe(single

and Multiple) and Created interactive Dashboard reports using

Xcelsius 2008.

SAP NetWeaver 2004s, SAP 4.7 EE, BOBJ, WEBI, DESKI, Universe

Designer, Crystal Reports, Excelsius, Infoview, ABAP Enhancements,

SAP BI 7.1, SAP BW 3.5, SCM, Manufacturing, BEx Analyzer, BEx Query

Designer, BEx Web Application Designer, SAP Enterprise Portal 7.0,

performance improvement, SAP BI Content 7.03, MS Windows, SQL

Database Server, Legacy systems(KABA, Get Paid, ADP).

Dyno Nobel Inc., Salt Lake City, UT, USA

SAP BI/IP/BCS/BPC Support Project

Oct'08 - May'09.

. Worked as Sr. SAP BI Consultant/Solution Architect.

. SAP BI 7.0 Support Project for US, Australia, Mexico and Canada

DN Operations (DNA and DNAP).

. Worked on SAP BI 7.0/FI & CO, BI 7.0/BCS, BI 7.0/MM-IM, BI

7.0/SD, BI 7.0/PP, BI 7.0/PM and BI 7.0/BPC and Safety

applications.

. Worked on Consolidation Group Hierarchy creations, CS

Items, Companies, Consolidation Currency conversions,

Consolidation versions for reporting requirements using Profit

Centers InfoProviders and MultiProviders.

. Resolved Data Load issues, reporting issues and

Authorization issues from BI -IP COPA / FI / CO / MM / SD / BOM /

PM / BPC/Safety applications. Created/Changed Hierarchies based

on Cost Center, and BU based on Profit Centers.

. Changed Safety reports used for MMR (Monthly Management

Reports- IFRS and A-IFRS). Changed COPA Reports and documented

all the changes in Change Management Request Workflows, Created

Input Schedules and Reports using BPC eVXXX functions using BPC

for Excel.

. Implemented BI- Integrated Planning solution for

Revenue(Sales) and HCM Planning. Created Aggregation level,

Filters using variables, Planning Functions, Planning sequences.

Created FOX formula Functions. Created Excel based Planning

cockpits using Report Designer/BEx Analyzer capabilities.

. Managed and Documented Transport Requests in Change

Management document server.

. Designed and Created New MultiProvider using COPA and CCA

InfoCubes to include G/L accounts for Canada Income Statement

reporting and reporting through BPC.

. Designed and Created new reports for Inventory Turns

(Quantity and Values) and Inventory Overview. Worked on MM-IM

reporting with snapshot scenario for non-cumulative key figures.

Enhanced standard extractors and created Transformations using

Start/transformation routines.

. Implemented Fiscal Year Variant relevant Solution because of

change in Fiscal Year Variant configuration in ECC system for SAP-

BW/FI, BW/CO and BW/BCS application reports. Specifically

changed Customer Exit Variables, created new Customer exit

variables for Last Fiscal Year, Posting Period, Fiscal

Year/Period and QTD/YTD calculations. Accordingly implemented

these changes in Web Templates to reflect on SAP Enterprise

Portals.

. Created Reports BOBJ -Crystal Reports 2008,WEBI, DESKI on

Universes and Created couple of management Dashboard resports

using Xcelsius 2008.

. Created New Queries and Views for various Business Units

used in various Web Templates, for Income Statement, P&L

Statement, Detailed Balance Sheet, and detailed Finance Summary

with new RKFs/CKFs/Structures (KF and Non-KF) using new

hierarchy.

. Created new Web Template using various Web Items and published

those reports on SAP EP Portals. Created Iviews, Pages, Roles,

Folders. Extensively worked in PCD, User administration, and

System Administration Functions. Broadcasted all these reports

through InfoView WEBI and Scheduler-Broadcaster configuration.

SAP NetWeaver 2004s, SAP ECC 6.0, SAP BI 7.1, DataSource Enhancement,

used Custom (

Custom Exit) SAP ABAP, BPC 7.0, BOBJ, WEBI, DESKI, Universe Designer,

Crystal Reports, Excelsius, Infoview, SAP BW 3.5, SCM, Manufacturing, BEx

Analyzer, BEx Query Designer, BEx Web Application Designer, SAP Enterprise

Portal 7.0. SAP BI Content 7.03, MS Windows.

SAP America, Global Solution Center, Newtown Square, PA, USA

MySAP CRM - SAP BI Integration Project

July' 08 - Sept'08

. Worked as SAP BI/CRM Consultant

. SAP NetWeaver 2004s Implementation Project.

. Worked on Activity, Opportunities, CRM Survey,

Utilization, and Pipeline Visibility for SAP's analytical

requirements.

. Created Business Blue Print Document for Activity reporting

- CRM Survey Reporting Enhancements for US SAP Sales.

. Created custom data flow model with Data Staging Layer for

CRM Survey Data flow model: InfoProvider DSO: PCRMSU23 (QGUID-

Answer IO Mappings & PCRMSU17-CRM Survey Data: Opportunities),

about 22 Answer InfoObjects, DataSource & Transformations:

PCRMSU_QUID_ANSWIO and 0SVY_DATA_1, DTP and InfoPackages to

acquire data from CRM System and Flat File Systems and

transported them through the landscape. Enhanced standard

extractors and created Transformations using Start/transformation

routines.

. Enhanced the Activity Reporting InfoCube: PCRMSUC01 and

MultiProvider for Activity: PCRMSUM02 with 21 additional IOs with

changes in Start Routine and corresponding update routines.

. Enhanced necessary Queries (Investment, Activity and

Utilization) using SAP front end Reporting tools.

. Created new Web Template using various Web Items and

published those reports on SAP EP Portals. Created Iviews, Pages,

Roles, Folders. Broadcasted all these reports through Broadcaster

Scheduler and scheduled Process Chains also.

. Created/Used BI Accelerators(BIA) in each process chain

after loading load to improve performance of queries using BIA

index concept using preconfigured hardware setup.

. Worked on SQL and SAP BI Data reconciliation.

. Worked on Analytics Authorizations (New Approach) using T.

Code: RSECADMIN.

SAP NetWeaver 2004s, SAP CRM 5.0, SAP BI 7.0. SAP ABAP, DataSource

Enhancements, BIA, BI Accelerators, BEx Analyzer, BEx Query Designer, BEx

Web Application Designer, SAP Enterprise Portal 7.0, SUN/UNIX.

Forest Pharmaceuticals, Earthcity, MO, USA

SAP BI Upgrade/Support Project

Feb 2008 - April 2008

. Worked as SAP BI Lead Consultant

. SAP NetWeaver 2004s upgrade Project

. Migrated SAP NetWeaver 2004 BI DSs with into upgraded NetWeaver

2004s system with new Data Staging strategy and Created DTPs, IPs

for data loads, Changed and Rescheduled PCs. Created new Variants

for Query/Workbook Executions.

. Changed and Rescheduled Process Chains with new created Process

variants (DTP & IPs).

. Worked on FI (GL, AP, CCA, PCA, PS, WBS) report reconciliation

of Budget, Transaction, and Actual Line items Reports after SAP

NetWeaver 2004s upgrade, and also documented all the results

taking timestamp of extractors into consideration in production

environment. There were approx. 64 reports. In case of deviations

did detailed analysis by finding header/Item level document

changes.

. Validated FDA compliance reports for current stock position

with batch numbers (with Expiration date information) within

company's Ware Houses and Distributors for their 6 drugs in the

market.

. Worked on APO Planning Book (Inventory, Forecast, Days of

supply) reporting requirements and reconciliation, considering

various quantity types (on hand, In Transit, open order, total

etc. restricted with Time horizon). There were 4 SNP workbooks

with various levels of details.

. Rescheduled Data loads for APO Process Chains as post upgrade

activity, and recreated variants for selection screens in some

cases for SNP & DP reports.

. Analyzed and resolved broadcasting issues of workbooks using

T.Codes- SOST, RSPRECADMIN, SLG1 in production environment.

SAP ECC 6.0 (FI-GL, FIAP, PS, WBS, CCA, PCA), SAP ABAP, Manufacturing, SAP

APO 4.0, SCM, SAP NetWeaver 2004s, SAP BI7.0, SAP BW 3.5, BEx Analyzer,

Broadcaster, Precalculation Server, MS Windows.

Northwest Natural Gas, Portland, OR, USA

SAP BI/BPS Implementation Project

October 2007 - January 2008

. Worked as SAP BI Lead Testing/Training Consultant

. Worked on BI integration testing documentation for master and

transaction data (quantities and $values) at various levels of

Data staging for margin forecast, budget with history data, COGP

actual costs data(CCA), FI-GL line items data, and number of

customers and shares data

. Created FI master and transactional data in ECC 6.0 for delta

extraction for master and transactional data by scheduling data

transfer processes and InfoPackages and usage of PCs

. Responsible for the development of complete technical design

document of SAP BI solution delivered

. Participated in training delivery and follow-up as part of

SAP Change management initiative.

. Developed the operational manual for Post Go-Live support

SAP ECC 6.0 (FI-GL), Manufacturing, Power and Energy, SAP NetWeaver

2004s, SAP BI 7.0, SUN/UNIX.

The Solae Company, St. Louis, MO, USA

SAP BW - COGP Implementation Project

August 2007 - October 2007

. Worked as SAP BI Architect

. Analyzed processes, did problem/solution assessment, required

changes/Enhancements, solution design and planned PGL support as

part of Change Management.

. Worked on requirements gathering for FI-CCA for fixed costs

and FI-PC for variable costs reporting requirements.

. Worked on As-Is and To-Be analysis (gap analysis) and business

blueprint documentation for global business requirements with

Data Staging strategy.

. Used 0COPC_C11 for fixed costs and 0PC_C01, 0COPC_C07 and

0COPC_C08 for variable costs for COGP actual costs

. Customized cost center and company code for required attributes

for navigations

. Created sample reports for actual, budget, forecast, and

previous year RKFs for absolute and % Variances for quantity and

cost KFs for Soya products for various origin groups (beans,

flakes, chemicals, and ingredients)

. Acquired development sign offs and transported them through

standard landscape

SAP R/3 ECC 6.0 (FI-CCA, FI-PC), Manufacturing, SAP NetWeaver 2004, SAP

BI 7.0/3.5, MS Windows..

Wyeth Pharmaceuticals, PA, USA

SAP BW - MM, PP, and FI Support Project

May 2007 - July 2007

. Worked as Sr. SAP BI Developer

. Created user report help documents and attached all those to

corresponding queries in the development environment

. Created InfoProvider help documents for IM and PP InfoProviders

to place them into eRoom (client's SharePoint)

. Created global and regional queries for MM-IM, PP, FI-GL, FI-

PCA, FI-CCA, FI-AA, IP and FI-PC with standard naming conventions

. Validated the data using customized variables, conditions, RKFs,

CKFs, and structures

. Tested all these queries for the data accuracy.

. Created reports for reported hazards/Reason codes (through drill downs)

to improve safety to follow FDA governance and Audits regulations within

Wyeth and their distributors.

. I had to pass mandatory examination of Internal FDA governance

certification exam for IT systems to get entitlement to work in IT team

of Wyeth to acquire required knowledge of FDA regulations. One of the

important regulation was FDA Bar Code Label Requirements for Human Drug

Products and Biological Products -- The FDA requires bar codes on most

prescription drugs and certain over-the-counter drugs.

. Created new Web Template using various Web Items for (BI-IP)Planning

Queries as data providers and published those reports on SAP EP Portals.

Created Iviews, Pages, Roles, Folders.

. Resolved productions issues of Inventory Management such as

ZBW_INV_CYCLECOUNT updated from LINV - inventory cycle count

table for missing pricing information against the batches with

change control procedure, resolved issues related to every day

data refresh uploads for every month, and modified routine used

in the DTP/ InfoPackage for calendar month within new Data

Staging Strategy. Worked on non-cumulative key figures.

. Consolidated the client's global master data and KPIs in As-Is

document for the enhancement of the requirements of standard data

sources (2LIS_03_BX, 2LIS_03_BF and 2LIS_03_UM) to utilize most

widely used capabilities of 0INV_C03.

. Resolved a few issues related to days of full coverage for

client's Inventory Management aging status and Sales Overview

InfoCube for OTC reporting reports like Sales by customers, Top n

customers and Sales Revenues by Product etc.

. Resolved issues related to validation and update for global

vendor master data from flat files through changes in the start

routine.

. Created a few global and local reports for Goods Receipt and

scrap analysis reporting requirements on 0PP_C02 InfoCube and

resolved issues such as few process orders were not uploaded

during initial loads and those were missing for certain plants

SAP R/3 ECC 6.0 (MM-IM, SCM, Manufacturing, PP, SD, FI-GL, FI-PCA, FI-CCA,

FI-AA, IP, FI-PC, GR, LO), SAP ABAP, DataSource Enhancements, SAP

NetWeaver 2004s, SAP BI 7.0, SAP Enterprise Portal 7.0, SUN/UNIX.

Qatar Petroleum Ltd., Doha, Qatar

SAP BW Training to Technical Resources and End-User

Sept 2006 - Dec' 2006

. Worked as SAP BI Training Lead Consultant

. Worked in SAP NetWeaver 2004 environment to design and change

global/ ad-hoc queries using BEx Analyzer (MS Excel) and Web

Application Designer

. Prepared BW training material for end-user training delivery in

BW - HR, BW - BPS, BW - FI Applications for Web and BEx users

. Trained 200 end-users in SAP BW HR, FI, and BW (BPS) as part of

change management initiative.

. Worked on Trainee Allocation System (TA Data entry, Re-

Designation) for accessing information and generating Ad-Hoc and

Static reports using SAP BW as new tool

. Participated in designing, reviewing, updating, and managed

training curriculum and training plan

. Participated in coordinating and conducting training delivery in

groups of six to 15 end-users with training material such a

Presentation and Step by Step End User Training Manual at local

and corporate locations

. Rated 5/5 or 4/5 by 90% of the participants in the Evaluation

Feedback.

SAP NetWeaver 2004, SAP BW 3.5, Oil and Natural Gas, Energy, SAP R/3 ECC

5.0 (HR, HR-TA, FI), SAP

SEM (BPS), BEx (Analyzer, WAD), MS Excel, SUN/UNIX.

Hewlett-Packard, CA, USA

mySAP CRM 4.0 (CIC)-BI End-to-End Implementation Project

Jan' 2006 - Sept' 2006

. Worked on ASTRO2 solution set 1: mySAP CRM -BI Integration end-

to-end implementation project

. Worked as Business Re-engineering Lead, area of focus was Business

process management and improvement, organizational assessment, change,

design and support, performance measurement and optimization, Training

needs analyses and content development, Training delivery and follow-up,

Communications planning and execution as part of Change management

strategy.

. Prepared business blueprint ("What" and "How") for global/

regional requirement of HP customer service support function

. Participated in face-to-face/ virtual business/ technical

meetings and training sessions

. Defined dimensions and KPIs for Customer Interaction Center

Analysis for mySAP CRM 4.0 Win client (Call, email, and Chat

data)

. Participated in analytical and reporting requirement gathering

across HP's CRM business processes such as agent login, account

ID, account review, quick close, problem ID/ solution, service

order management, interaction wrap-up, escalation, service

tickets, and interactions

. Participated in the preparation of Business Requirement Document

(BRD) and 'Reference Design Document (RDD)" and updated both the

Documents as per Reviews.

. Activated and delivered complete data flow models for HP's

business scenarios - CRM activities, SOM, Problem ID, and

Solution.

. Worked extensively with dimensions interactions, service ticket

and interactions, email analytics, quick close, document content,

complaints, service order, product registration for reports using

count, display, filter, and sort functions for Master data

requirements

. Mapped all reporting requirements of legacy systems from EMEA,

APAC, and SEA Geographical Regions to BI with complete business

understanding (130 reports) and delivered 40 standard dynamic

Queries and Workbooks. And web reports using Web Application

Designer as frontend tool using variables, conditions,

exceptions, and filters.

. Created a few RKFs and CKFs

. Developed all the reports in WAD and published on SAP EP Portals

through roles. Created Iviews, Pages, Roles, Folders. Broadcasted

all and scheduled them into Process Chains also.

. Scheduled and automated all data loads using Process Chains

. Imparted training to business users and technical team in

Practice Sessions

. Provided global solution for time zone issue while accessing

reports using BADI

. Analyzed and documented SAP BI-7.0 capabilities/ extensions for

enhancement requirements in ASTRO 2 Solution Set 2 and 3

SAP ECC 5.0, SAP NetWeaver 2004/2004s, SAP ABAP, Enhacements, SAP BW

3.5/BI 7.0, mySAP CRM 4.0, BEx (WAD), SAP Enterprise Portal 6.0, HP-UX

Mindspeed Technologies Inc., CA, USA

SAP BW End-to-End Implementation Project

August 2005 - December 2005

. Worked as SAP BI Application Consultant

. Worked on analytical and reporting requirements that were

mainly in MM & SD applications Data acquisition from SAP R/3,

flat files, Lotus Notes and Oracle DB (DB Connect) source systems

. Mindspeed migrated from Cognos to SAP NetWeaver 2004 for their

Reporting requirements.

. Worked on the project wherein there were 90% customization that

included a few enhancements and the rest 10% of developments were

from standard business content for the requirements for sales

dash board, Supply Chain Management Matrix (OTD and RMA matrix)

that included Inventory Management (Material Stocks and Material

Movements), Booking, Billing and Backlog (BBB Reports/OTC),

Forecast, Projected revenues, and Design Tracking System Reports

(source: Oracle DB)

. Participated in solution design, realization, testing, and

validation of all master data and transactional data, and query

creations on InfoCubes, ODSs, and MultiCubes used in Data

Staging. Actively involved into Change management meetings and

contributed for the best practices.

. Designed and changed queries using BEx Analyzer (MS Excel) and

Web Application Designer

. Published all reports on Enterprise Portals and delivered end-

user training and prepared End-User Report documentation

SAP NetWeaver 2004, SAP BW 3.5, Manufacturing, SAP R/3 4.7EE (MM, SD), SAP

EP, BEx (Analyzer),

DB Connect, Lotus Notes, Oracle SUN/UNIX.

Megachem Limited, Singapore

SAP BW End-to-End Implementation Project

December 2004 - May 2005

. Worked as SAP BI Architect

. Participated in business blueprint preparation, gap analysis

for Financial Accounting (FI-AR, FI-GL, CO-CCA, CO-CCA), Sales

and Distribution, Material Management (Vendor Evaluation,

Purchasing data), and Inventory Management (Material Movements:

Plant and Periodic Plant Stocks).

. Derived MIS financial ratios from P&L Statement and Balance

sheet using Report Painter in SAP R/3.

. Coordinated with the Chief Finance Officer, Chief Operating

Officer and various level of Users for Requirements,

clarifications, and Sign Offs for the BW solution.

. Ensured timely resolution of technical and functional issues for

all the three applications

. Designed two MultiCubes for cross application reporting for FI-

CO, SD(including OTC), and MM Basic InfoCubes.

. Designed and implemented custom InfoCubes, ODSs, and InfoObjects

(Chars and KFs) for the specific requirements with Data Staging.

. Delivered 30 Multi Dimensional KPI Reports.

. Coordinated with users and other SAP Functional Consultants for

the issue resolution related to data harmonization.

. Participated in Extraction, Testing, and Loading (ETL) for

performance and finally transporting the developments to quality

and production.

. Automated various data loads using process chains.

. Worked in SAP NetWeaver 2004 environment to design and change

global/ ad-hoc queries using BEx Analyzer (MS Excel), and Web

Application Designer.

. Published reports on Intranet using SAP EP by creating folders,

roles, Worksets, pages, and iViews. Published on those reports on

SAP Enterprise Portal.

. Acquired user acceptance of reports and carried out end-user

training on report execution using BEx and web usage.

SAP NetWeaver 2004, SAP R/3 4.7 EE (FI-AR, FI-GL, SD, SCM, MM, IM),

Manufacturing, SAP EP, SAP

Tools (Report Painter), BEx (Analyzer, WAD), SAP Enterprise Portal 5.0, MS

Excel, SIS.

Fonterra, Auckland, NZ

SAP Regression and Integration Testing

July 2004 - November 2004

. Worked as Project Manager

. Worked for the client who is New Zealand's multinational dairy

company

. Managed team of 13 Consultants and coordinated activities of

Regression and Integration testing

. Interfaced and coordinated with client's Business Analysts and

Functional Consultants for issue resolution

. Coordinated and tracked testing activities for on schedule

delivery and performed defect analysis

. Created test scripts for SD process using Solution Manager 3.1.

. Carried out effective testing of SD, PP, IM, FI, APO and BIW

referring Integration/Regression test scripts for testing.

. Managed the test activities using SAP Solution Manager 3.1 for

defect tracking and record keeping

. Defined the process for raising Test Problem reports

. Ensuring timely resolution of these TPRs from the team of

Consultants

. Coordinated with the business users on all clarification related

to business blueprint

SAP R/3 4.7 EE (SD), SAP APO 3.1, SCM, OTC, P2P, Manufacturing, SAP

BW3.1C/3.5, SAP Tool (Solution Manager 3.1). Change Management.

Hero Honda Ltd., Delhi, India

SAP R/3 Enterprise Upgrade and SAP BW 3.1C Implementation

May 2004 - July 2004

. Worked as SAP BI Architect

. Worked on the project that involved SAP R/3 Enterprise

upgrade(4.0B/ EE 4.7) and new implementation of SAP BW 3.1C with

3.3 add-ons

. Did on project preparation work

. Prepared business blueprint (As-Is/ To-Be)

. Created Technical and Functional documentation for new

developments and upgrades

SAP BW 3.1C (3.3 BI- Content), SAP R/3 4.0B/ 4.7 EE, SCM, Manufacturing.

Rohm and Hass, PA, USA

SAP BW Implementation Project

October 2003 - April 2004

. Worked as Sr. SAP BW Developer

. Activated the standard business content Info-Cubes-

Delivery, Sales Overview, Purchasing Data, and Vendor Evaluation

. Worked on profitability Analysis Info-Cubes

. Executed various data extractions for master data (full and

delta) and transactional data (full and delta) using LO Cockpit,

CO-PA, and generic extractors using Process Chains

. Scheduled and automated data loads and optimized the load

performance by range partitioning, buffering number range

objects, and adjusting the packet size and data selections

. Participated in performance tuning, using aggregates,

compression, and indexing, and setting up parallel processing

. Worked extensively on BEx Analyzer (RRMX) and created queries

using variables, free characteristics, filters, exceptions,

conditions, calculated, and restricted key figures.

. Worked extensively on SIS reporting. Prepared Configuration

and Business Process documentation

SAP BW 3.1C, SAP R/3 4.6C (LO, CO-PA), SCM, OTC, P2P, Manufacturing,

ABAP/4, BEx (Analyzer)

Kimball Electronics, Jasper, IN

SAP BW Implementation Project and PGL Support

January 2003 - September 2003

. Worked as SAP BW Developer

. Worked extensively in Administration Workbench and created/

changed various InfoProviders

. Activated standard business content and loaded Sales data into

the InfoCubes and ODS objects

. Created queries according to requirements of SD and FI using LO,

CO-PA, and Generic Extractions

. Scheduled, managed, and monitored several data-loads and

optimized the performance by adjusting packet size and parallel

data loads with proper data selections

. Reviewed the existing system and provided more Solutions by

changing variants and contributed for client's future

enhancements plans

. Worked extensively on SIS reporting

SAP BW 3.0B, SAP R/3 4.6C (SD, FI, LO, CO-PA, ODS), SCM, Manufacturing,

ABAP/4, ABAP Tools

(AWB)

Gujarat Ambuja Cement Ltd., India

SAP SD End-to-End Implementation Project

April 2002 - December 2002

. Worked as SAP SD Consultant

. Customized SD application to suit the unique requirements of

cement industry

. Customized partner functions and pricing procedures for

respective Sales-Areas

. Worked on customer-Pricing procedure and document- Pricing-

procedure

. Worked on text determination

. Worked on various Sales Documents such as Sales Orders,

Deliveries, Goods Issue Notes and Billings for Standard Customer

(customer and vendor), Inter-Company, One Time Customer, Third

Party Order, and an Individual Purchase Order

. Created condition types, access sequences, condition tables to

address pricing requirements for different divisions, and

Shipping conditions considering transportation zones.

. Worked extensively on SIS reporting

SAP R/3 4.6C (SD, SO, SIS, PO, GI, Shipping, Pricing), OTC, ABAP/4, Dell

220S

Marico Industries Ltd., Mumbai, India

Business Analysis

September 1999 - March 2002

. Worked as a SAP Business Analyst

. Carried out responsibilities that included defining roadmaps,

business requirements gathering, interfacing with SAP Technical/

Functional Developers and Business Users, creating test scripts

for client's business scenarios in BW, SD, IM, MM, and APO

Applications for most of the developments and documenting them,

system training and monitoring activities, and handling

integration, performance, authorization, and transport issues

. Worked on SAP APO 2.0B implementation and the client was the

first company for APO implementation in India, and BW and R/3.

SAP R/3 3.1H/ 4.0B (SD, IM, MM), SCM, Manufacturing, SAP BW 2.0B, SAP APO

2.0B, ABAP/4, SIS

Computer Consultancy, India

Business Development and Operations

January 1991 - March 1999

Various Clients, India

Maintenance

April 1981 - December 1990

EDUCATION

Engineering Degree - Associate Membership in Institution of

Engineers (AMIE) - Electronics and Telecommunication Engineering

(Equivalent to 4 year Bachelor Degree of Engineering in Electronics

and Telecommunication

Contact this candidate