Data Sales

Anil Chiruvolu

Certified Net Weaver BI/BOBJ Consultant

Email: abnanp@r.postjobfree.com

Ph : 732-***-****

PROFILE

SAP certified BI/BOBJ consultant with more than 9 +years of professional

experience which

includes more than 7+yrs in SAP BI 7.0,BW3.5, BW 3.X,and 2.X versions and

around 2 years of SAP ABAP experience. Involved in multiple life cycle

implementations involving design and development of BW objects,

Transformations, Business Content configuration, and Sizing using SAP ASAP

methodologies. Have good functional knowledge of SAP R/3 application areas

like SD, MM,COPA, FI AR, AP,CRM,APO SNP,DP,WM,PLM,COPA,BPS,PCA,CCA,BCS,BPC

and IM.

PROFESSIONAL SUMMARY

. Exposed to all phases of project from Planning, Blueprinting,

Configuration, Development, Integration Testing, Cutover, and Training

to Go Live. Responsible for providing end to end solutions to clients,

transitioning and sustaining production support activities, defining

Project Standards, Development of Architecture, Review of Design, GAP

Analysis, Project Schedules, Team Management, ensuring optimum

utilization of resources and complete delivery within budget.

. Extensively worked on data modeling - Entity Relationship (ER), Multi-

Dimensional/Star Schema and Extended Star Schema models - Designing

custom info objects, info providers, info cubes, DSO/ODS objects,

multi providers, infosets, info sources, source systems and dimension

modeling.

. Installation, activation and enhancement of Standard Business Content

for various industry verticals and horizontals like Financials,

Logistics,APO,and CRM.

. Proficient in different modes of extraction supported by SAP BI - my

SAP Service API, DB Connect, XML,UDC, Flat files and extraction from

3rd party ETL tools. Proficient with generic, FI and LO Cockpit

extraction as well as extraction from legacy systems using Informatica

and Data Stage.

. Experience providing support in Open Hub Services for licensed vendor

RDBMS.

. Expertise in performance tuning using Aggregates, Rollup, collapse,

Partition and Compression. Used the BW Statistics cube to analyze

query performance and aggregates performance.

. Worked with the Planning the implementation of the BI Security using

Analysis authorizations.

. SAP APO/CRM: Experience working with Design for Demand Planning using

APO-DP, APO-SNP Integration of BI with APO involving Load Strategies,

Versioning, SNP Location

Master,PDS,CVC,TLANE,CTMTranctiondata,Peggingdata,CRM

Opportunities,Activities,CRMMW,andCRM Marketing master data like

BusinessPartner,CRM Product etc.

. BW Reporting: Reporting using BEx Analyzer, BEx Web, BEx Query

Designer, BEx Broadcaster, MDX, EP Integration, iViews, Visual

Composer, KM and Collaboration Rooms. Expertise in creating BW

components like Queries, workbooks, Calculated Key Figures, Restricted

Key Figures, Structures, Variables, Exceptions, Sap Authorizations,

Conditions, R/RI, WAD, Web Reports, and CSS style Sheets.

. BPS/BPC5.1/NWBPC: Knowledge of creation of Applications, Appsets,

Dimentions, script logic, validations,BPC Excel, Input

schedule,datamanger Packages, Transformation file etc.

. BO Reporting: Design of Universe, creation of the crystal

reports,Webi(Web intelligence reports)Desktop reports, APD, Query as

Web Service, Creation if dashboard reports using Xcelsius and Voyager.

. Support Activities: Involved in daily production support activities

and maintaining Process Chains. Experience in process chain

management,OSS Note Implementation, Monitoring and scheduling the

batch jobs through 3rd party tools like Autosys, UC4 and Control-M.

. Training: Conducted training sessions for users in BW reporting,

created training manuals for the super users and end-users. Involved

in presentations, end-user training and documentation.

KEY SKILLS

. Data Warehouse: SAP BI 7.0, BW 3.5, Informatica Powermart.

. ERP Packages: SAP R/3 4.6,ECC5.0/6.0,CRM7.0 APO, SAP Netweaver 2004s.

. ERP Integration: SAP R/3 - SD, MM, FI, CO, CRM, SCM modules.

. Reporting Tools: SAP BEx, Visual Composer and Web Reporting,BOBJ

Tools, Hyperion.

. Platforms: UNIX, Windows (XP, NT, 2000), VMS.

. Database: SQL*Plus, PL/SQL, Oracle 10g, 9i,8i.

. Programming Language: ABAP/4,ABAP Objects, Java, and ASP.

. Utilities/Tools: SourceSafe, Tidal, ARS Remedy System, Erwin, Test

Director

. Other : Microsoft Project, Mercury Tools, JavaScript, XML, Citrix

Professional Experience:

Perrigo Pharmaceuticals (www.Perrigo.com) Martin, MI, Sr.BI/CRM Lead

Consultant Jan'10 - Till date

Responsibilities:

. Responsible for Requirements Gathering working with the Functional

teams and developed the Functional & Technical Specification

documents.

. Activated the business content data sources for the CRM master data

like Business partner,CRM product,Markting attributes and

Transactional data sources for CRM opportunities,CRM activities,CRM

quotes.

. Activated the Info cubes, DSO'S, Info objects, Multiproviders for the

CRM Implementation.

. Created opportunities win loss report, quotation tracking,

opportunities pipe line analysis report using QAD, WAD and published

in CRM WEB UI.

. Designed Authorization objects for all the CRM and COPA reports based

on Territory path id using Analysis Authorizations in BI.7.0.

. Created COPA costing based data source on operating concern

. Created DTP's and Transformations and Worked in ABAP objects in Start

Routine and End routines.

. Created Test plans for the UAT and Cutover.

. Extensively worked with BEX Reporting for reports like Order History,

Assortment Analysis with Query Designer, Web Application Designer and

Variables etc.

. Worked with the Defects, Validation and providing Knowledge Transfer

to users on various aspects.

. Worked with the WEBI reports and Query as Web Service on the top of

Universe.

. Involved in the Knowledge transfer, Demo, Problem solving and

preparing the BW Technical documentation.

. Worked with the Transports extensively and Collection of BI objects

for transports.

. Worked with MS Visio and Microsoft Project for the arch diagrams.

Environment: SAP R/3 ECC 6.0,CRM7,SAP BI 7.0, SAP NetWeaver 2004s,

SAP BEx WAD,CRM WebUI, ABAP/4 Objects,APD,Query Designer, JavaScript,

HTML, HP Quality Center.

Global Foundries (www.AMD.com) Austin, TX, Sr.BI/APO Lead Consultant

July '09 - Dec'09

Responsibilities:

. Conducted and Presented best practices, logistics extraction and

performance tuning to co-workers.

. Responsible for Requirements Gathering working with the Functional

teams and developed the Functional & Technical Specification

documents.

. Performed extensive analysis about the Source systems like ECC & Asset

history and Historical data

. Worked with the Data Model design for the FI, SD, MM, APO SNP,APO

demand Planning. Worked extensively with Data Warehouse Workbench for

Modeling, Monitoring, Scheduling DTP/Info package and Process chains.

. Activated the Business Content and Data Sources into 7.x/3/x version

and also performed the Data Source Migrations, Mappings and

Transformations with both the ECC & Historical data needs.

. Worked with the Customization of the Info Cubes, DSO objects,

MultiProviders and Info Sets as per requirements.

. Created the custom code using the HTML and Java Scripting in web the

template for the tabler reporting.

. Created CVC, shipment history, CMIR data in BI and published in APO

system for APO DP planning.

. Extracted the SNP Master Data like Location, Tlane, Product and PDS

Information into BI.

. Pulled planning parameters like Yield, Cycle time, Consumption into

BI from APO SNP .

. Created plan vs. actual planning parameters reports in SAP BI.

. Worked with the Transports extensively and Collection of BI objects

for transports.

. Designed and updated the process chains for the daily loads and tuned

for optimum load performance.

. As part of performance improvement redesigned most of the cubes in

production and removed unused dimension and reloaded the cubes and

lead the team of 3 and managed the cutover activities.

. Continued to work with the users to improve enterprise wide data

sharing through EDW solutions.

. Continued to monitor BW performance and take actions to meet the SLA.

. Designed auto scheduling of all process chains through event

triggering with limited manual intervention.

. Worked on the authorizations objects and gave users the authorizations

based on the Sold _to party info object.

. Created Test plans for the UAT and Cutover.

. Created custom ABAP programs to calculate queries in the backend and

combined multiple query results to produce single consolidated result.

. Worked with the Defects, Validation and providing Knowledge Transfer

to users on various aspects.

. Involved in the Knowledge transfer, Demo, Problem solving and

preparing the BW Technical documentation.

. Worked with MS Visio and Microsoft Project for the arch diagrams.

Environment: SAP R/3 ECC 6.0,SCM6.0 CRM 5.0 SAP BI 7.0, EHP1,SAP

NetWeaver 2004s, EP 7.0,VC SAP BEx WAD, Solution Manager,

ABAP/4,Query Designer, JavaScript, HTML, Windows NT,HP Quality

Center.

APPLE INC (www.apple.com), Cupertino, CA, Sr.BI/BW Lead Consultant

Jan 2009 - July 2009

Responsibilities:

. Conducted and Presented best practices, logistics extraction and

performance tuning to co-workers.

. Managed the offshore team and coordinated the Development activities

leading to the successful project completion on time.

. Responsible for Requirements Gathering working with the Functional

teams and developed the Functional & Technical Specification

documents.

. Worked with the Data Model design for the APO,IB(Installed Base) and

APO demand Planning, SNP and Install base Implementations. Worked

extensively with Data Warehouse Workbench for Modeling, Monitoring,

Scheduling DTP/Info package and Process chains.

. Worked with the Customization of the Info Cubes, DSO objects,

MultiProviders and Info Sets as per requirements.

. Worked with the Transports extensively and Collection of BI objects

for transports.

. Designed and updated the process chains for the daily loads and tuned

for optimum load performance.

. As part of performance improvement redesigned most of the cubes in

production and removed unused dimension and reloaded the cubes and

lead the team of 3 and managed the cutover activities.

. Continued to monitor BW performance and take actions to meet the SLA.

. Designed auto scheduling of all process chains through event

triggering with limited manual intervention.

. Created custom ABAP programs to calculate queries in the backend and

combined multiple query results to produce single consolidated result.

. Worked with the Defects, Validation and providing Knowledge Transfer

to users on various aspects.

. Involved in the Knowledge transfer, Demo, Problem solving and

preparing the BW Technical documentation.

. Created universe objects like Dimensions, Details and Measures,

Conditional Objects and Prompts Functions to meet the requirements.

. Created charts to display summary of the data.

. Created the dashboard reports using Xcelsius and Query as Web service

using the BW data.

. Worked with formatted reporting using Visual Composer. Created

interactive iviews and published them to portals.

Environment: SAP R/3 ECC 6.0 SAP BI 7.0,SCM5.0 SAP NetWeaver 2004s, EP

7.0,VC SAP BEx WAD, RADAR, BO,Xcelsius, ABAP/4,Query Designer,

JavaScript, HTML, Windows NT

Nike WHQ (www.Nike.com), Beaverton, OR,Sr.BI/BW Lead Consultant

Dec 2007 - Jan 2009

Responsibilities:

. Worked on Production Support Kintannas and fixed those Kintannas as per

requirements.

. Involved in Transportation of all Objects like: Info objects, Query's and

DS objects etc into BI production system after validation and testing the

same in development system.

. Used DSO to stage the data before transferring the DSO contents to the

Info Cube

. Modified start routines, update rules and user exits as per the

production Kintannas.

. Managed & monitored several data loadings and optimized the performance

by adjusting Packet Size and data selections.

. Redesigned the info cubes by using that ABAP program

SAP_ALL_INFOCUBE_ANALYSE.Spilt the dimensions into smaller where ever dim

data exists more than 10% of fact table. / proposed line item dimension.

. Created Info spoke based on DSO and pulled into the flat table and DB

tables.

. Worked with end users to gather requirements to design and build the

BW application.

. Prepared the technical specification from functional specification.

. Created 13 TODS objects to load closed Sales orders schedule line

level data from 43 standard ODS partitions holding sales order

data at grain level.

. Wrote ABAP report program with native SQLs to load 13 TODS partitions.

. Created 8 InfoCubes in Analytical layer to load sales Schedule line

data from 13 TODS objects in Integration layer for US, AMER, EMEA,

Asia Pacific regions.

. Wrote transfer routines, start routines and User Exit to lookup

master/transaction data and populate key figures and Characteristics.

. Created Multiprovider upon 8 sales info cube partitions to enable

reporting across all regions.

. Extended the extract structures by adding new fields and populating

them with the User Exits.

. Worked on filing set up table for PO data and then loading into

staging server and from there into Integration layer throughout the

landscape.

. Worked on Oracle TOAD to prepare the native SQL and test the

performance.

. Created DTP and Transformations using Bi 7.0 for the different

modules.

. Created Business add ins (BADI) for populating the key figures in the

Coverage queries.

. Extensively used the new process types in the process chains used

Class builder.

. Created the dashboards reports using the WAD and published in the

portal using the information broadcasting.

. Involved unit test, regression testing, SIT (system integration

testing) and UAT phases of implementation.

Foundation Coal Holding INC (www.Foundationcoal.com), Baltimore,MD,Sr.Lead

BI/BW Consultant Apr 2007 - Nov'07

Responsibilities:

. Interacted with business end users to gather requirements and

transformed them into a data model with the concept of Extended Star

schema.

. Ability to develop strategic imperatives and execute on resulting

initiatives (such as BI business case formulation, Reporting,

acceptance and adoption, governance and control, operations

management).

. Ability to translate key business expectations into requirements;

ability to translate requirements to a robust design.

. Ability to lead the project to successful completion, while laying the

plans/roadmap for future deployment.

. Analysed business reporting requirements that could be satisfied with

SAP business content and installed the necessary objects.

. Extensively worked on conversion of routines,Transfermations, Data

transfer process (DTP's) in BI 7.0.

. Migrated the 3.0 X Data Sources to the B.I 7.0 Data Sources with

Transfermations and DTP'S

. Worked on Writing routines for PP module to calculate confirm

quantity and other KPI's using conversion factors.

. Installed and activated standard Inventory cube 0IC_C03 .

. Worked on Daily plan data (Z_PP_C01)and Monthly plan data(Z_PP_C02)

custom cubes and Z_PP_C04 cube for PP module.

. Pulled the BOM data into BW cubes and DSO's .

. Developed Function Modules to create the custom data sources for PP

module.

. Installed the business content data sources for the PM orders,PM

Operations and PM order costs

. Created the Transfermations,DTP'S to the DSO 's and to the PM cubes.

. Created the Custom data sources for the PP confirmations

. Enhanced the standared the PM data sources With the custom fields for

the reporting requirements

. Created the multiproviders for PM and PP specific for the reporting

. Created PM compliance,Work Order Activity,Scheduled Costs and

Scheduled Man Hours reports for the PM reporting

. Created the Surface KPI reports which inclueds Coal

Production,Overburden Production,Coal Truck Productiviy,Overburden

Truck Productivity,Equipment Availability,Equipment Utilisation

Reports for PP.

. Created the Drill Procution,Truck Production,Escavator Production

reports for the Resources specific in PP module .

. Effectively worked in designing the dimensions by using ER model,

analyzing the size of dimension and fact tables, and maintained the

line item dimension for material and sold-to to improve the

performance

. Created the Process chains for the Master Data,Transactional Data

for different Modules .

. Used Transport connection to move objects from development to quality

environments. Worked with Transport organizer to migrate the newly

developed queries, process chains to Test client for testing and then

migrated to production.

. Extensively involved in publishing the Reports to Portal for the end

users to access them .

. Published BEx Queries to Web / created the Web Templates, linked

them to Portals.

. Enhanced the Data sources AR / GL as per reporting requirement for

Customer Credit level reports / balance.

. Activated the business content Info cubes and ods objects and

created the complex transformations and routines COPA content.

. Created costing based data source for the COPA and pulled data from

ECC to BW.

. Created events in R/3 and BW and communicated the scheduling triggers

via RFC connections.

. Involved in Daily process flow consistency, Load monitoring and

recovering failed data loads/deltas.

. Daily process chain monitoring, missing master data loads, PSA edits

and BW scheduling of Jobs.

. Installed BI statistics component and validate the expense queries .

Environment: SAP R/3 ECC 6.0 SAP BI 7.0, SAP NetWeaver 2004s, EP 7.0,VC

SAP BEx WAD, ABAP/4,Query Designer, JavaScript, HTML, Windows NT

Bristol-Myers Squibb (www.BMS.com), Princeston,NJ,Sr.BI/BW/SCM Consultant

Feb 2007 - Apr'07

Responsibilities:

. Worked on standard and custom defined LO extractors. Installed

relevant SAP business content. Used LO structures for extracting sales

order, delivery and billing information.

. Configured and customized Logistic Cockpit extract structures and data

sources in sales and distribution and material management to

facilitate the data extraction to BW and to reporting using

classification of various data elements. Extended the extract

structures by adding new fields and populating them with the user

exits.

. LO-Cockpit extraction: 2LIS_11_VAITM, 2LIS_02_HDR, 2LIS_03_BF,

2LIS_03_UM using V3 update.

. Setup the Statistical Setup for the LO-Cockpit and used the V3 Update

for Delta Management.

. Enhanced existing master data and transactional data extractors.

Modified and Created User Exit programs to accommodate additional

fields in the extract structure of the Data source.

. Responsible for transporting the objects Using STMS Transaction.

. Developed front-end reports using Business Explorer (BEx) and

published in the workbook.

. Responsible for designing ODS, Info cubes to run Profitability Reports

and year end balances

. Worked extensively on configuration using Administrator Workbench

(RSA1). Customized data Sources, Info Objects, Info Sources and Info

Cubes. Designed by making extensive use of the ODS capabilities, delta

management functionality and optimal use of update rules keeping query

performance in view.

. Used RRI interfaces, Filters, Conditions, Variables, Currency

conversions and navigational attributes. Exception handling through

SAP Mail, batch printing and alert monitor.

. Monitoring of Master Data and Transaction Data uploads. Added New

Transfer Rule, Update Rules.

. A modified and configured custom Info source, Data sources, Transfer

structures, Transfer rules & Update rules for Info cube and ODS.

. Worked extensively on BEx Analyzer. Used Navigational attributes,

Filters, Exceptions, Conditions, Jump targets (RRI), Variables,

Hierarchies, etc. Created Templates for WEB Reports.

Environment: SAP R/3 4.7/CRM 4.0/BW 3.5, BEX, WAD, Test Director, ABAP/4,

Windows NT.

Computer Associates (www.CA.com), Long Island,NY,Sr.BI/BW /CRM Consultant

July 2006 - Feb'07

Responsibilities:

. Analyzed the requirements, identified the gaps, mapped the legacy

fields to BW info objects, and identified the suitable business

content for SD, OTC,P2P,LTQ,PS(Professional Services)and FI modules

and had the standard info cubes, ODS and multi cubes and various other

relevant objects installed and activated.

. Configured and customized Logistic Cockpit extract structures and data

sources in sales and distribution and material management to

facilitate the data extraction to BW and to reporting using

classification of various data elements. Extended the extract

structures by adding new fields and populating them with the user

exits.

. Worked with the AP350 & CTP documents for approval and testing.

. Gathered Sales force analysis (Sales commissions) requirements,

Prepared as-is documentation, functional and technical specifications

and developed custom info cubes, ODS and sales commission and

incentives calculation reports.

. Built the master and transactional data process chains and scheduled

accordingly to upload data into info providers.

LTQ/OTC Implementation

. Developed a data model for CRM sales (Sales orders and complaints),

CRM Marketing elements (Campaign and Marketing Plan, Campain, Market

analytics) from different source systems.

. Worked on CRM Opportunities Header (0CRM_OPPT_H, OCRM_OPPT_I) and Item

extractors and enhanced the item and header extractors with partner

functions and pulled it to BW.

. Worked on LTQ and P2P modules and created custom date sources to pull

the date from ECC.

. Optimized the performance of data targets (Info cube, ODS, Multi

cubes) by loading the data through proper selection criteria and

maintained the request for each data load to compress it in the

future.

. Developed standard document templates and standard practices for every

object that is developed. Mentored the users and support groups on the

design, data model and maintenance of the objects.

. Involved in creating components of BW-BPS like planning area, planning

levels, planning applications and creating web entry layouts etc.

. Responsible for the development of various Test cases/scenarios and

validation of BW reports with SRM and R/3 data at various stages of

testing such as Unit Test, Functional Unit Test and detailed

Integration Testing.

. Created Info Objects, Data sources, Info sources, Data targets, Info

Packages and Info Providers to load Master and Transactional data from

SRM and R/3 system into BW system.

. Worked in Dash board reports in BW for FI/CO, SEM and COPA service

line using WAD HTML and Java Script.

. Developed Function Module exit for in active Pricing Conditions to

pull in to BW. Which are not pulling with the standard extraction.

. Extensively used the tool of BPS for creating the planning levels,

planning packages and planning layout.

. Created the user exits/BADI and pulled the data CRM into BW

environment.

. Extended the standard BI content info cubes/DSO objects for Sales

Planning, Sales orders/quotations, Opportunity analysis and Activity

analysis for custom info objects.

. Created standard reports for Sales Planning and forecasting, Pipeline

and Funnel Analysis, Win Loss Analysis, Opportunity Analysis and ABC

analysis.

. Managed the BW and SEM Security by creating Roles and Authorizations

for different users.

. Conducted Training for End-users and Project Team members. Developed

different BW and SEM training documentations for different users based

on their roles.

. Extensively involved in publishing the Reports to Portal, email,

Collaboration rooms and KM using BEX broadcaster for the end users to

access them.

. Created the data sources using DB Connect and pulled the data from the

Oracle and other 3rd party tools

Up Grade responsibilities:

. Lead the Query part of Upgrade Project to 2004s. Responsible for

migrating around 400 Reports involving publishing reports through Query

Designer & developing Web Templates in Web Application Designer

. Designed a base Web Template with customized layout & menu options that

was used as the default template for all Queries

. Closely worked with Portal, Security & Basis Team in the Upgrade

Process

. Involved in creating/migrating Reports, Web Templates & Workbooks

. As part of the Upgrade worked on different documentation required to

keep track of the development & maintain best standard for a well

planned Upgrade

. Production Support activities to trouble shooting & supporting the

Upgraded system

. Created Technical Specifications & involved in distributing the work

among developers.

. Converted the Hyperion reports into BI reports.

. Trained off-shore team both in back end & front end development

Environment: SAP R/3 ECC 5.0/CRM 4.0/SRM5.0/Solution Manger, BW 3.5, BEX,

WAD, Test Director, Java Scripting, Hyperion, HTML, ABAP/4, DB2, Windows

NT.

SAP AG (www.SAP.com), Germany/SAP Canada, Toronto, Sr.BI/BW/CRM/MW Lead

Consultant Feb 2005 - June'06

Responsibilities:

. Interacted with business end users to gather requirements and

transformed them into a data model with the concept of Extended Star

schema.

. Analyzed business reporting requirements that could be satisfied with

SAP business content and installed the necessary objects.

. Identified data sources based on end-user reporting requirements, and

created Info Cubes, extracted data from different modules like FI/CO

PCA.CCA,COPA,CATS,OM/PA Modules.

. Responsible for the specification, design and development of multiple

currencies for the NEBS project of Deluxe. Designed Currency

translation queries which perform translations based on different time

periods by using the monthly average exchange rate

. Extracted data from SAP R/3 using BC, Generic extractors and also from

flat files.

. Extended standard Business Contents based on client requirements using

USER Exit and Function Module. Modified/Wrote user Exits to fill the

appended extract structure with the data.

. Extensively used BEx analyzer, created queries with variables,

filters, calculated key figures, restricted key figures, exceptions,

conditions etc. Developed Report - Report Interface for all the Profit

Center Accounting (PCA), Cost Center Accounting (CCA), and FI-GL

queries to drilldown from CUBE level to ODS level and then to R/3

level

. Used Transport connection to move objects from development to quality

environments. Worked with Transport organizer to migrate the newly

developed queries, process chains to Test client for testing and then

migrated to production.

. Monitored the daily load process chains and worked with BASIS and DBA

teams to resolve the issues that arise in daily data extractions

. Improved performance of existing SAP BW Queries and reports by

creating Aggregates, Compression and Partition etc. Monitored BW

Statistics and tuned BW Info Cubes, aggregates, OLAP cache and query

performance. Created indexes, database statistics, aggregates,

efficient queries, modified the data transfer parameters, etc.

. Involved in Research, request, test and validate application of BW,

SEM, etc. support packages and notes.

. Extensively involved in publishing the Reports to Portal for the end

users to access them

. Involved in pre note implementation in BW.

. Involved in UC4 implementation for triggering the process chains form

the third party tool and monitor the process chains, initialization

and doing consistency of aggregates.

. Activated the master data objects and infocucbes for the T&E module.

. Created overview of travel expenses and expense receipts reports for

users.

Environment: SAP BW 3.1, SAP R/3 4.6C, BEx Analyzer, ABAP/4 Workbench,

FI/CO, CSN, UC4, Windows XP.

Delphi (www.Delphi.com), Troy, MI, BW Technical Consultant

Nov '03 - Jan'05

Responsibilities:

. Understanding the specifications provided by the functional

consultants, interacting with SME'S to get to know the exact

requirements, suggest them the changes where required and then develop

the objects as per the evolved specifications

. Created Info Objects, Data Sources, Info Sources, Data targets, Info

Packages and Info Cubes to load Master and Transactional data from SAP

R/3 system and flat files into BW system. Customized Info Objects,

Info Sources and Info Cubes.

. Conducted user acceptance, unit and system testing, for SD and MM

modules. Hands-on implementation experience as technical contribution

for project.

. Designed Process Chains: local chains, Remote chains for all daily

loads and Monthly loads.

. Performed extraction using generic from tables and views, Master data

extraction.

. Responsibilities included developing the extract structures, designing

the info-source and activation of business content.

. Designed and Maintained an Info cube, which held market and

competitor's information. The available data was uploaded from a flat

file for competitors and in house data was extracted from SAP.

. Monitoring of Master Data and Transaction Data uploads. Added New

Transfer Rule, Update Rules.

. Extensively worked with Administrative Work Bench (AWB).

. Extracted data using R/3 and flat files source systems.

. Scheduling and monitoring the data loads in production.

. Pulled data from the APO cubes into BW space .

Environment: SAP BW 3.1, SAP R/3 4.6C, BEx Analyzer, ABAP/4 Workbench,

FI/CO, Test Director, Windows XP.

USA Semiconductor, Santa Clara, CA, BW/ABAP Technical Consultant

Jan '03 - Oct'03

Responsibilities:

. Designed and developed Bex Reports and Web Enabled Reports based on

the business requirements

. Worked extensively on configuration using Administrator Workbench

(RSA1). Customized data Sources, Info Objects, Info Sources and Info

Cubes. Designed by making extensive use of the ODS capabilities, delta

management functionality and optimal use of update rules keeping query

performance in view

. Identified Roles and Profiles to meet Authorization (SU01)

requirements in order to restrict confidential data to end-users.

. Performed extraction using generic from tables and views.

. Used the Business Content and Developed Queries, Structures, Formulas

in Sales, Purchasing areas according to the Power User needs using BEx

Analyzer, Bex Browser. Enhancing extract structures by appending new

data elements using enhancement component and used user exits.

. Analyzing the SAP BIW Business Content required, activating the

business content components.

. Assigned Data Sources to the Info Source, Defining Transfer

Structures, and Metadata maintenance for the Info Source and source

system. Configuring Metadata in the Administration Workbench for

replication and Updating of Data Source from the source system.

Environment: SAP BW SAP R/3 4.6C, BEx Analyzer, ABAP/4 Workbench, SD/MM/

FI/CO, WAD, Windows XP.

UK, Utilities BW /ABAP Technical Consultant

Jan '02 - Dec'02

Responsibilities:

. Participated in day-to-day responsibilities that included analysis

of reporting requirements and translation of these requirements into

dimensional data models, with an emphasis on actual implementation

in BW

. Activated and utilized the business content according to the

functional requirements

. Responsible for FI/CO, SD, Purchasing, and Inventory Management

InfoCubes

. Customized the InfoCubes for MM module to suit client's business

needs

. Extracted data from SAP R/3 using LO Cockpit, CO-PA, generic, and

business content extractors

. Used delta update process for loading the data to SAP BW from R/3 in

specific intervals

. Used BEx to create reports with exceptions, conditional formatting,

restricted key figures, and calculated key figures

. Worked on currency conversion as per the user requirements

. Created drill through queries from summarized InfoCube to detail ODS

data

. Developed specific reports required in the areas of FI/CO, MM, and

SD modules, and actively participated with power users in helping

them to generated reports

. Defined and modeled queries to satisfy business analysis, and used

MS Excel to format and slice and dice the data

. Provided quality assurance and technical support during Go-Live

. Used the other reporting functionalities such as reporting agent

extensively for performing automatic background scheduling of

various reports

. Created web templates using Web Application Designer

. Created conditions, exceptions, structures, and variables that were

used in BEx Reporting modifying the reports based on user

requirements

Environment: SAP BW 2.1C/ 3.0B, SAP R/3 4.5B/ 4.6B (FI, CO, SD, MM, LO,

IM), BEx (WAD, Report), ABAP/4, Windows 2000/ NT, MS Excel

Manufacturing Company, Bangalore, ABAP Technical

Consultant May'00 - Dec'01

Responsibilities:

. Analyzed and studied Required Specifications.

. As a member of the ABAP Development Team, involved in Developing

Reports, BDC, Layout Set and Module Pool Programming as per client's

requirement.

. Involved in the Support and Maintenance.

. Developing an Interactive report clubbed with BDC for calculating the

Sales commissions for Internal and external agents.

Reports:

. Created a Classical Report to find out Stock availability for a

particular storage location using select options Plant, Company Code,

Material Number, and Storage Location.

. Created a Interactive Report that List details Vendor No ands address

in the Basic list and Bank details Like Account Number, Bank Name and

Bank details in the Secondary List.

. Created a Report to find out total of net Purchase Order Values for a

particular Vendor.

BDC:

. Customer Master records (using XD01 transaction) and Vendor Master

Records (using MK01 transaction) from legacy system were brought into

SAP using BDC programs.

Environment: SAP R/3, SAP R/3 4.0B (SD, MM, PO, SO), ABAP/4, ABAP Tool

(Workbench), Oracle 8.0, Windows NT

Education and Certifications:

. B.S in Mechanical Engineering

. SAP BO XI 3.0- SAP Certified Application Consultant.

Consultant's Profile

Consultant's Profile

Contact this candidate