Sap Data

Balachandra Gaddam

Sr. SAP BI BO ANALYST

Email: ***********.******@*****.***

248-***-****

OVERVIEW

. 10 years of thorough experience in SAP that includes 8 years of

experience in SAP BI/BW & BO and around 2 years in SAP SEM-BCS,

SAP-BPS & SAP CRM .

. Hands-on experience in 3 full life cycle implementations, with

demonstrated abilities in development and production support, and

specializing in web reporting, web interface, modeling, extraction,

scheduling, interfacing, and ABAP reporting

. Responsible in designing the Info cubes, ODS(New DSO) objects,

Multiproviders, Infosets, infoSources, ODS Objects, PSA, Update

Rules & Transfer Rules( New Transformations), Info objects

Catalogs, Info objects, Characteristics and Key figures info

objects, Data Sources, Info packages, infopackage groups, DTP's,

Process chains, Meta chains

. Expertise in the complete life cycle implementation of SAP BW that

includes data modeling, data extraction, generic extraction, data

loading, scheduling, monitoring, LO Cockpit, CO-PA, and BEx Query

. Good Experience in using ABAP/4 to create start routines, transfer

routines and update routines, user exits.

. Developed Security authorization objects and profiles to restrict

the access to the data model and queries. Developed Roles, User

Authorization, Profiles and User groups

. Performance tuning and Testing -Evaluated using BW Statistics Cubes

and suggested recommendations to basis support for optimization.

Improved data load and query performance by doing compression,

partitioning, indexing of infocubes, aggregates and use of BW

Statistics for the same. Strong Knowledge in Archiving

. Experience in BOBJ integration with SAP BI (Data service, Universe,

WEBi, Infoview, Crystal report, Xcelsius 2008, live office, QWS

(Query as web service), Dashboards. Voyager)

. Technical and functional expertise well augmented by excellent

analytical, problem solving, communication, and interpersonal

skills, with the ability to deliver innovative and profitable

solutions well within timeframe and budgets .

. Worked with Business Objects 5.x / 6.x / XIR2 / XIR3 in various

Technical capacities such as BI Architect, Systems Analyst, BI

Developer and BO Developer.

. Experience in BOBJ integration with SAP BI (Data service, Universe,

WEBi, Infoview, Crystal report, Xcelsius 2008, live office, QWS

(Query as web service), Dashboards. Voyager)

. Designed Universes using Business Objects Designer 5.2

. Fixing system problems with the help of OSS notes

. Experience in extracting data from Flat File source systems, Legacy

Systems (Non SAP R/3) using UDCONNECT and DBCONNECT.

. SAP BO XI3.1,Web intelligence,Crystal reports,SAP BO Xcelsius etc

SKILL SETS

. OPERATING SYSTEMS: Windows NT 4.x

. ERPs: SAP R/3 3.x/ 4.x/ mySAP ECC 5.0 (SD, MM, PP, PS,WM, HR, INV,

SL, FI, CO, LIS, PSA, ODS, SO, PO, LO, BI, Delivery, CO, PA), SAP BW

3.x, SAP SEM (BPS)

. CRM: SAP CRM

. LANG/ TECH: ABAP/4, Java,SQL

. DATABASES: Oracle 8.x, MS Access,

. SERVERS: ITS

. TOOLS: ABAP Tools (Data Dictionary, Objects, Query, Reports, ALV),

SAP Tools (SmartForms, LSMW, Workflow, SAPScript, Screen Painter),

Medruck, BEx (Query, WAD, Browser, Analyzer, Explorer), Reporting

Agent, MQSeries, Mercury Interactive Tools 7.6/ 8.0 (TestDirector),

MS Excel, AutoSys .

. SAP BO XI3.1,Web intelligence,Crystal reports,SAP BO Xcelsius etc

EXPERIENCE

Bowebell Howell-Durham NC

BI Implementation on BI 7.0

March 2008 - Till Date

. Enhanced the Material group data source for extracting the long text

from T023T.

. Remodeled the Purchase Cube for getting Navigationa attribute for

report purpose.

. Developed the Process chains for Master Data and Transactional Data.

. Data Extraction from CRM

. Developemnt DSM Dashboard with Visual Composer for Service

orders,labor costs etc

. Worked on Security roles and authorizations in BI7

. Experience in Universe Design and Report development using Business

Objects tools.

. Worked in SAP Portals for Reports and roles in Portals.

. Developed Update start routines for FIGL and FIAR Line items for update

the classification text with respect to Reference Document number and

GL account

. Developed a 15months Inventory usage report with Cells.

. Extracted the Data for Vendor Evaluation (0PUR_C02) from three

extractors 2LIS_02_SGR ((scheduled Lines), ZVIQME(Quality

Notifications(QMIH,QMEL),and ZRSEG (PO invoices(RBKP,RSEG)).

. Worked on Material Stocks / Movements 0IC_C03 cube and extracted data

from the data sources Stock Initialization for inventory Management

2LIS_03_BX, Material Movements from Inventory Management, 2LIS_03_BF

Revaluations in Inventory Management 2LIS_03_UM.

. Developed Ageing Inventory Report for Material with respect to Plant

and Batch for (0-30) (30-60) and (60-90) Days with Drill down for

Plant, Storage Loc, Material and material Type.

. Enhanced the ZCOPA_C01 Extraction with new fields Item and External Obj

Technical Key from AUFK and IAOM_CRMSRV_EXAT tables and developed COPA

cube using multiple characteristics and key figures for Profitability

Analysis.

. Extracted the MRP Data with Generic extractors ZZMARD and ZZMDMA and

updated the Std Cost and Avg moving cost from Costing ODS in the

transformation.

. Developed the Multiprovider for Sales, Delivery and billing information

from extractors 2LIS_11_VAHDR, 2LIS_12_VCHDR, and 2LIS_13_VDHDR.

. Set up Flat file for Time dependent Hierachies for Service associates

for US and CAD.

. Set up the infoprovider ZMAT5100 to load the data only Total stock and

Amount from MRP ODS with respect to Material in start routine.

. Developed End routines and Start routines for updating the new objects

by reading the

data from ODS tables.

. Developed the Roles and authorizations for the users for using the

Profit centers as per

User authorizations

. Experience in creating adhoc reports using Business Objects and Web

intelligence tools.

. Trained the Business Users and IT Staff on BW Reporting Tools.

. Developed reports for Sales using Crystal and Web intelligence

reporting tools.

. Developed Dashboards using BO Xcelsius

Rinker Materials., West Palm Beach- FL

BI 7.0 Implementation.

Jun 2007 - Feb 2008

. Developed the Statutory reports like Balance Sheet, Notes to Balance

Sheet, Profit and loss and Notes to Profit and loss report

. Analyzed and Mapped Business Processes to BW. Appended structures

and used function enhancements - User Exits (CMOD).

. Implemented LO extraction (LBWE) for the Business Content data

sources.

. Used COPA Extraction and developed COPA cube using multiple

characteristics and key figures for Profitability Analysis.

. Developed custom extractors on the R/3 OLTP systems and defined the

extract structures on the source and target systems.

. Developed Management reports like Cash flow, Funds and Profit and

loss reports.

. Developed consolidated reports and detailed Consolidated Cash flow

reports.

. Developed the Open Hub Service (Extract) for the elimination process

for Business

Consolidation

. Prepared the files with Partner and Without Partner and loaded the

data from Consolidated.

. Moniter through various Hierarchies in test and Update methods

. Maintained the Sync between BCS and BI environment with Sync

Programmers

. Developed the web templates and distributed them to the users with

Broadcaster

. Validated the Data in GRS reports with BCS Consolidated workbench

Conagra foods., Omaha, NE

SAP BW Development Project

Jan 2007 - May 2007

. Developed a new BW and SEM systems for smith fields for their meat

division .

. Worked in control M jobs scheduler for processing the Jobs for BW

and SEM

. Worked in developing a Proto type model for History data loading by

creating a new connection from BI 7 system .

. Worked in process chains for processing loads in JSD(SEM) System

with respect to control M scheduler.

. Supported the Conagra Production system (BWP) for daily activities

. Worked in Butterball extraction reports for Conagra Business People

. Created the Test scripts for Reports and ETL for BW and SEM in Test

Directory .

. Developed the Purchasing cubes in 7.0 for History and Actual Data.

Nalco Inc., Chicago, IL

SAP BW Migration Project i,e 3.1 to 7.0

Nov 2006 - Dec 2006

. Worked in BW Migration Project I,e 3.1 to 7.0

. Developed the reports in 7.0 for the open orders reports.

. Developed the North America Dash Board reports for their Daily upto

date Business.

. Developed The Europe Region Dash Board for Europe Business Users.

. Used BI content for CRM application

Synopsys Inc., San Francisco, CA

SAP BW Design and Development

May 2006 - Oct 2006

. Developing SAP CRM application for financial tracking of AMS

products

. Designing the model for actual data that includes booking, revenue,

expenses, and ODS for planned orders, revenue, and expenses, and

creating MultiProviders for the same

. Designing the ODS for planned data with flat file extraction

. Developing a reports for historical report that provides information

about actual for the past four years and future four years for

planned data relating to orders, revenue, and expenses

. Creating a report for actual and planned orders for the current

quarter

. Developing a cumulative report for actual orders by fiscal week for

current quarter

. Developing a dashboard reports for IBase and case tracking with

security for executive sponsors and their business area

. Developing call tracking CRM cases by weekly, monthly, and average

response time for the current assigned supervisor

. Developing reports for the client's business units and providing

open status for over 30 months

. Working on monthly temporary license keys for various customers with

respect to month

. Writing user exits for Financial Tracking, Dash Board, and Current

Assign Reports

. Developed a CRM star tracking ABAP/4 program that will give the

information about cases, creation data, changed data, corresponding

managers, and tier two products, wherein the data file will be

converted to CSV file and send to the Unix server for business users

. Working on Unicode and ERP upgrade

SAP BW 3.5, SAP CRM, SAP R/3 4.6C (SD, MM, HR, FI, CO, ODS), Oracle 8.x,

Windows NT 4.x, ABAP/4

Sara Lee Corporation, St. Louis, MO

SAP R/3 Upgrade and BW Design

December 2005 - May 2006

. Worked as a Techno-Functional Consultant on the upgrade of SAP R/3

from 3.1H to mySAP ECC 5.0 and on the design stage of BW as the

client is planning for a BW implementation

. Worked on the MM and SD modules to support and write the scripts for

customer interfaces, rote mergers, and modifications of ABAP/4

programs and correction in SAP for vendors requiring forecast

information including scheduling agreements

. Supported and managed both SAP and legacy system for data

synchronization using interface programs in Material Management and

raw material Inventory systems in MM and WM modules

. Supported and provided knowledge in SAP SD, MM, PP, and WM modules

. Worked on the SAP HR configuration, program enhancements, coding,

and modification using SAPScript layout sets and SmartForms

. Managed and supported full project life cycle implementation of

electronic transmission of SAP documents for BI and Sales area in

the SD module

. Configured and updated ABAP programs to meet company's global

business requirements

SAP R/3 3.1H/ mySAP ECC 5.0 (SD, MM, PP, WM, HR, INV, BI, SL), SAP BW,

ABAP/4, SAP Tools (SAPScript, SmartForms)

Delphi Automotives, Troy, MI

SAP BW/ SEM Development and Support

March 2004 - November 2005

. Worked as a SAP BW and SEM Consultant for the development and

support for the client, a leading manufacturer of mobile

electronics, transportation components, and system electronics

. Prepared the functional, technical, and developmental specification

for Production Incident Request (PIR), Change Control Request (CCR),

and Development Report (DR)

. Responsible for requirements gathering, data modeling, and planning/

scheduling data input from source systems

. Interacted with users for standard reports, analysis, and associated

solutions

. Created generic extractors (View) to extract data from R/3 for the

SD and MM modules

. Developed FI/CO KE30 reports that were migrated in BW

. Generated Reports using BEx Analyzer and Web Reporting

. Created InfoObjects, InfoCubes, InfoSources, ODS objects, and

MultiProviders

. Used RRI feature to jump between the Queries to analyze the data

. Used open hub service, InfoSpokes, and process chain

. Prepared test cases in TestDirector 8.0

. Discussed critical issues proactively with other Functional

Consultants to facilitate timely resolution

. Carried out system resumption activities every month-end, after

transporting the objects to production

. Provided 24/7 production support

. Supported for over 600 BW users and over 200 SEM users

. Supported applications such as Supplier Score Card, Plan For Every

Part (PFEP), Absent Management Information System (AMIS), and

retroactive active changes

. Clarified Queue management, allocated issues to team members,

followed-up, and aided in the resolution

. Resolved the DW cases created in Peregrine Digital Workflow

. Coordinated the activities between offshore and onsite team

. Responsible for reporting the weekly status to the client

. Trained new team members

. Loaded and monitored SAP BW jobs

. Resolved and clarified cases reported by users of above applications

. Analyzed functional requirements for enhancement activities

. Developed back-end and front-end objects in SAP BW

. Carried out unit testing and integration testing

. Worked on transports cut over

. Created technical and user documents

SAP BW 3.1C, SAP R/3 4.6C (SD, MM, HR, FI/CO), Oracle 8.0, Windows NT 4.x

Lennox International Inc., USA

SAP BW End-to-End Implementation

October 2002 - March 2004

. Worked as a SAP BW Consultant on the end-to-end implementation

. Understood the user requirements

. Participated in gathering user requirements for creating reports

based on KPIs

. Created business specification and BW implementation design document

. Designed transaction/ basic cubes and ODS for extraction

. Planned transfer/ update of routines into data targets

. Maintained master data from different sources

. Responsible for developing the HR headcount reporting

. Extracted data from flat file and SAP R/3 for HR

. Generated web templates and implemented the process chain

. Generated comparable figures from actual and forecasted data

. Generated annual target turnover for headcount

. Implemented BW roles and authorizations

. Participated in transport request

. Worked on the unit, integration, and system test design

. Monitored the data load and update processes running in the

production environment and initiated the fixes

. Responsible for the user manual design and training

. Delivered the first data source that comprised of most data volume

from Germany, GMDS System (Infineon HR system based on SAP HR) via

SAP BW extractor

. Delivered the second data source that were flat files from six major

sites, namely, Malacca, Singapore, Porto, Villach, Richmond, and San

Jose via MQSeries

. Harmonized some of field contents before sending via MQSeries

. Maintained the data directly into SAP BW via a web-interface, which

is built on SAP SEM component

. Performed reporting and analysis of data via SAP BEx and Web

Application Designer (WAD) when deemed to be more suitable for

business needs

. Built an interface for web data entry based on the SAP SEM

technology for data entry

. Carried out the Lennox implementation methodology

. Worked on requirement analysis based on client requirements

. Worked on the requirement study, project architecture design,

business specifications, technical specifications, InfoObject

design, ETL design, dimension design, ODS and multi-providers, and

the reporting design

. Designed the extraction architecture from 3 different source

systems; BW, SEM, and R/3

. Worked on data modeling, data loading, InfoProvider, InfoSource, and

generic extractions

. Worked on the transport report by transporting Lennox objects DN2 to

QN2 and PN2 testing

. Prepared test cases in TestDirector 7.6

. Performed integration testing, quality test, and UAT

SAP BW 3.0, SAP R/3 4.6 (HR, ODS), SAP SEM, BEx (WAD), MQSeries, Mercury

Interactive Tools 7.6 (TestDirector), Oracle 8.0, Windows NT 4.x

Avaya/ IBM

SAP BW Development

Feb 2002 - October 2002

. Worked as a SAP BW Consultant

. Participated in the design, development, and testing of enhancements

or user requirements for implementation by identifying the customer

requirements, modeling the data, and defining the data sources at

OLTP

. Used extended star schema for data modeling

. Worked with ABAP Programmers

. Worked on activating the standard delivered business content in the

form of InfoObjects, InfoSources, ODS, InfoCubes, and customized it

. Worked on data extraction of SAP R/3 system for the LIS and SD

modules by using various extractors and non-SAP systems via flat

file

. Worked on extending some of the extract structures by adding fields

. Created new data targets such as InfoCubes and ODS by creating

interfaces at BW and SAP R/3 level

. Used delta update mechanisms for uploading the data to SAP BW from

R/3

. Worked with ODS and PSA

. Worked on reporting using the BEx Analyzer and Explorer to summarize

data

. Worked with aggregates, InfoSet queries, templates, and Workbooks

. Demonstrated familiarity with role-based security and authorizations

SAP BW 3.0B, SAP R/3 4.6C (SD, MM, FI, CO, LIS, PSA, ODS), ABAP/4, BEx

(Analyzer, Explorer), Oracle 8.0, Windows NT 4.x

Pratt & Whitney,

SAP R/3 Implementation

Feb 2001 - Jan 2002

. Worked as a SAP Technical Consultant

. Responsible for writing the technical specifications from the

functional specifications

. Worked on the data communication process

. Carried out the optimization and analysis of existing ABAP/4

programs

. Developed classical and interactive programs

. Modified SAP standard program to industry requirement

. Responsible for the data migration

. Used BDC for transferring and converting data into the SAP system

. Used Legacy System Migration Workbench (LSMW) for migrating the

general material data from legacy system to SAP R/3 and for updating

the records in MARA table

. Wrote BDC programs to update and change customer master data by

session method for transactions VD01 to update KNA1 table in SD

. Developed a batch input program for creating material master using

MM01 transaction and to create vendor master (MK01) transaction

. Worked on the ALV reports

. Generated a Report using ALV grid that will show the Purchase Orders

. Generated a Report using ALV grid for list of materials details by

using Material Management, wherein the report would collect data

from Sales Orders, stock transport orders, and Purchase Orders and

output it according to customer number or material number, as

selected in the selection screen

. Wrote reports in material master that outputted valuated stock

grouped by material type and plant in MM, wherein the output showed

material number, storage location, and description, in addition to

group totals

. Developed material master details report, wherein the input of

material and plant were as select-options and material type as

parameter, and the output list would have quantity by material group

and plant

. Migrated SAPScript (Medruck) for Purchase Orders to SmartForms and

modified it to suite the requirement

. Participated in the modification of SAPScripts and used SmartForms

for RVORDER01

. Worked on the SAPScript layout sets in SD and MM modules that would

be used in the Delivery document, BI document, and Purchase Order

layout

. Carried out several enhancements such as field exits and user exits

for handling unit validations, Delivery creation and change,

material master custom fields enhancements, and Sales Order creation

and change processing

. Configured ALE partner profiles for Business partners and maintained

data for existing controls, created and maintained ports and Logical

systems, RFC destinations, and ALE transfer of data in various

systems

. Distributed material master and customer master data using standard

message types MATMAS and DEBMAS respectively

. SAP R/3 4.6C (SD, MM, SO, PO, Delivery, BI, LO), ABAP/4, SAP Tools

(LSMW, SAPScript, SmartForms), ABAP (Reports, ALV), Medruck, Oracle

8.x, Windows NT 4.x

Education: B.E Mechnical engineering

Contact this candidate