ARUN PRASAD BHUVANENDRAN

San Jose CA

Phone     : 408-306-3967

Email       : be_arun_prasad@yahoo.com

BC           :  SAP SDN Business Card

 

 


Objective
To become a successful SAP BW/Portal Application consultant and provide client specific solutions based on requirement. I have about 6 1/2 years of experience in SAP Project Implementation involving Full Life Cycle Implementation as well as Enhancement and Maintenance Processes.

 

Achievements

·          mySAP BI Certification – Business information warehouse (C_TBW50) based on BW version 30B by SAP America

·          Actively involved with SAP SDN Contribution corner

·          Microsoft Certified Solution Developer (MCSD)

 

Educational Qualification

·          B.E (Electronics & Communication Engineering)

 

 

Technical Skills

 

SAP BW

BW (3.x to 3.5), BI 7.0 Upgrade

 

 

BEX Tool

BEX Analyzer, Web application designer, Visual Composer

 

 

BO Tool

XCelsius Dashboards

 

 

SAP R/3

R/3 (4.x to 4.7)

 

 

SAP CRM

CRM (3.0 & 4.0)

 

 

SAP WAS

WAS (6.20 & 6.40)

 

 

BPM Tool

SAP Workflow

 

 

CTI Tool

AMC with 5.05ASP -> 5.10ASP Plug-in

 

 

Front-End

Crystal Xcelsius Professional 4.5

 

 

MS GUI Tool

Visual Studio 6.0/.NET

 

 

Portal Tool

SAP Enterprise Portal 6.0

 

 

Languages

BSP/HTMLB, ABAP, ASP/HTML, Java/JSP

 

 

RDBMS

SQL Server 7.0/2000, Oracle (Basic), MS Access 2000

 

Experience Summary

 

SAP BW (3.x, 70) Experience Includes –
 
·          Data modeling experience (Multidimensional Data Model using Extended Star Schema) with complete understanding of Data model optimization based on the design.
·          Designed and developed Infocubes, ODS, InfoSource, DataSource and Infospokes.

·          Good experience in implementing Multi-level staging scenarios with Data Marts.

·          BW Data load scheduling, monitoring and troubleshooting data extraction / load problems
·          Good Experience in Developing BW reports with Business Explorer tools.

 

Business Objects XCelsius Experience Includes –

 

·          Developed Complex Dashboard equivalent to existing SAP BI Dashboard for Procure to Pay Summary Data.

·          It involves developing BEx Queries and a Custom program to export the Data as an XML file in a Network Directory accessible by XCelsius as a batch job every night as part of the process chain.

 

SAP CRM 4.0 Experience Includes –

 

·          Developed Custom BW Extractors based on Function Module interface for applications such as Opportunity Management, Activity Management, Service Processing, Survey and CIC with CTI Interface.

·          Experience in maintaining master data for different levels of Business partners, products with good understanding of the CRM table relationship.

 

SAP R/3 (4.5b, 4.6c, 4.7) Experience Includes –
 
·          Developed complex workflow to automate Business processes (BP). BP involves standard workflow with BOR object (BUS2038, BUS2007 and BUS2089). Developed Custom Business Object subtype, attributes, and methods and delegated it to the parent object.
·          Developed BW Analytics for SD, FICO and PM/QM Modules.
·          Developed Interface Programming (File Handling, BDC), Dialog programming, Function Modules, and Interactive Reports. Developing BSP application in HTMLB involving other BSP Extensions to bring the screens in portal.

 

SAP EP60 Experience Includes –

 

·          Developed SAP screens (Maintenance Processing, Notification (Create, Display, Edit), Order scheduling) and Complex Reports in Portal 60 SP2 with Eclipse IDE involving JSP programming.

·          Developed Iviews connecting to SAP system with Java Connector Architecture (JCA) and Java Connector (JCO).

·          Has real good experience in developing BSP application involving HTMLB, Class and related BSP extensions. Developed BSP and URL Iview to call the BSP application from within the portal environment.

 

AMC CTI Experience Includes –

 

·          Understanding of Computer Telephony Interface Header and Item interface from AMC for BW Extraction

·          Configuring the SAP Telephony Server to enable Interaction Statistics Extraction from AMC.

 

 

 

Professional Experience

 

Genentech Inc.                                                                                                                             June 2006 to Present

SAP BW Techno-Functional Consultant

 

BO XCelsius Prototype –

·          Developed Complex Dashboard equivalent to existing SAP BI Dashboard for Procure to Pay Summary Data.

·          Worked on a prototype to export summary data from P2P Area to develop a Dashboard Report based on the Xcelsius front-end.

·          It involves developing BEx Queries and a Custom program to export the Data as an XML file in a Network Directory accessible by Xcelsius as a batch job every night as part of the process chain.

·          Developed an Excel Model for the Xcelsius source mapping for every item in the page.

 

SCM PROP Analytics –

·          Worked on Class A Manufacturing standards related metrics such as Forecast Stability / Accuracy, Production Plan Performance / Stability, Master Production Schedule Performance, Inventory Accuracy, Supplier Delivery Performance, Purchase Order within Lead Time, Maintenance Schedule Performance, Quality Release Performance.

·          Worked on Analytics related to APO SNP/DP Planning, Material Movements, Inventory Coverage, Process / Planned Order, Quality and Inspection Lot to provide Class A Manufacturing Standard compliance with GMP.

 

BI 70 Upgrade –

·          Worked on several testing scenarios related to ETL, Performance & Reporting to have a complete regression testing with the upgrade

·          Worked on BI BEx Pattern to have a standardized web template that should be re-used for any new development.

·          Worked on enabling web services based on SOA concept to have BI Data Widget or any external application to make use of the web service

·          Developed Web Dynpro for ABAP (WD4A) for Custom Table Maintenance and Automation ABAP screen conversions.

 

Projects –

·          Worked on Commercial Expense Tracking Project involving Actual data from SAP R3 (Finance and Purchase Requisition), SAP EBP (Shopping Cart) and Forecast/Budget data from Cognos (Forecast/Budget model).

·          Developed complex ABAP Program screens, transaction & Infospoke extract to Cognos with BADI involving several levels of massaging and conversions.

·          Developed BSP Applications for multiple custom Table Maintenance, process Automation and manual user adhoc Data load execution for Forecast / Budget data to Pre-Prod and Prod environments.

·          Worked on BEx Reporting development & enhancements and developed couple of dashboards.

·          Developed an APD process to extract & Transform data from a Complex Multi-cube and load it into ODS object with transformation.

 

BW Security Reconciliation –

·          Worked on Re-designing the BW Security Roles with the Security Team to adhere the Audit Standards for Back-end / Front-end Developer, Super / Power / Reporting Users.

 

Complex E-mailing Program –

·          Multiple BEx Queries & Web Templates, Multiple User selection based on BW Roles, Custom Info object security as part of the program

·          Process Chain to handle breakdown of 3000 users and sending E-mails as blocks of users to handle the Large Volume of data & Memory restriction.

·          LOG table to store the details of the Executor, User Selected, Date / Time, Email run status with the BSP Application

 

LENNOX Inc                                                                                                                                      Jan 2006 to May 2006

SAP BW/CRM Techno-Functional Consultant

 

·          Worked on the Full Life Cycle Implementation of CRM-BW Analytics for Customer Interaction Center (CIC) Module with Activity & Sales Order Analysis with CTI Interface from AMC.

·          Project involved complying with the existing BW Landscape and in process CRM system landscapes.

·          Conducted BW Functionality Workshop & Actual Reporting Demo Workshop for the Client at different phase of the project timeline.

·          Work involves developing complete Software development Life Cycle with prior Functional and Technical document.

·          Project Go-live Timeline document for the Development, Testing and Go-live process with the available resource.

·          Modules involve CRM Activity Management, Interaction Center Analytics and CRM Sales Order Extraction.

·          Worked on the interface with the external Computer Telephony Interface (CTI) to CRM for Data extraction from AMC 3rd Party tool.

·          Developed Document for BW-CRM Object developed based on the above modules.

·          Developed the Complete interface with Web Templates and made the User Point of entry from the Clients local website.

·          Categorized the Roles based on the module such as CIC: Activity Analysis Manager, CIC: Sales Analysis Manager and CIC: Interaction Center Manager.

·          Enabled all settings required to publish those web template into Portal as Iviews.

·          Successfully made the BW Reports to Production on time as per the Project Plan and Timeline.

 

Intervoice Inc (SAP America)                                                                                                          Aug 2005 to Dec 2005

SAP BW/CRM Techno-Functional Consultant

 

·          Worked on this New Implementation and Project plan through SAP America team.

·          Developed BW analytics for CRM Opportunity Management involving a BPS planning application to update data directly from the Portal PCUI Opportunity screen.

·          Consolidated data from both Booking and Revenue planning area for Opportunities into one Cube to create several reports as required by the client.

·          Developed Process chain involving standard Booking data extractor which runs every hour to be almost real time and process chain for Revenue extractor which involves program to convert the Revenue transactional cube to non-planning cube to extract data which runs every four hours so the reports are updated.

·          Consolidated Time conversion at different levels involving custom fiscal quarter aggregation based on custom company calendar. Bookings data is stored at day level and the revenue data is stored at month level.

·          Developed Weekly Snapshot scenario based on companies requirement which involves process chain to run every week at specified time, custom snapshot calendar functionality to make the standard calendar to work Friday to Friday week, and Opportunity change document history from source system as control data for the reports.

·          Developed Portal interfaces with SAP BW Report Iview to bring all the BW Reports into Portal environment. Developed and maintained the worksets to categorize the reports based on users.

 

 

Synopsys Inc                                                                                                                                     Jan 2005 to July 2005

SAP BW/CRM Analytics Consultant

 

·          Worked on different CRM application involving Opportunity Management, Activity Management, Service Processing and Survey.

·          Good understanding of the CRMD tables for Header, Items, Business Partners and the products involved.

·          Worked on new features in BW 3.5 involving the Enhanced web reporting involving the BEX Web items such as information broadcaster, Data provider information, and XML web item.

·          Developed BW specific Function module extractor for different application in CRM to implement complex application logic at the source system level and keep the data flow in the BW environment smooth.

·          Re-modeled the data model and the data flow to optimize the performance of the Infocube dimensions by studying the Dimension to Dimension count ratio to balance the granularity homogeneously.

·          Implemented complex Data Mart interface scenario with ODS updating several data targets.

·          Developed and maintained complex process chain involving the complete data loading and activation scenario for several application.

·          Developed Complex BEX templates and queries involving Customer exit, Web Design API interface with MODIFY_CLASS, Client side programming with JavaScript and customized dashboards.

·          BW has the limitation of 60 chars for an infoobject.One of the major development was to bring up the long text to the BW report involving Class, RFC to source and concatenating the columns to show up the long text in paragraph format.

·          Also enabled Exception reporting based on characteristics value with MODIFY_CLASS functionality in the web template.

·          Developed BSP application to get the CRM Order details such as Long Text, and more related information in the CRM system. Used the BSP application as a Report to Report interface from BW Reports.

 

PG & E                                                                                                                                               June 2004 to Dec 2004

SAP Portal/Workflow Consultant

 

·          The client is in need of a complex collaborative environment where the data could come from varied data sources like Workflow Inbox, BW reports, SAP R3 transaction, Customized portal Iviews in a common place.

·          Extended BUS2038 and BUS2007, which is the standard Business Object for Plant maintenance Notification processing and Order Processing respectively. Developed additional attributes and methods and delegated it to the custom object. Involved in developing Workflow for unscheduled corrective maintenance, which handles emergency and non-emergency cases and for Order completion workflow to automate the order closure & status change process.

·          Developed Complex Workflow Methods and attributes for Custom Business Object to perform multiple functions within single screen.

·          Developed Notification (Create, Edit, Display), Maintenance Order Processing screen with nice intuitive look in BSP application, which in turn was called inside Enterprise portal.

·          Developed Application Classes and methods to handle the application / Business logic for the BSP application.

·          Developed set of maintenance forms in BSP application; these forms are tied with Notification and Order. This forms overcome the limitations set by the standard SAP screen with lots of new functionalities as required by the customer.

·          Developed Complex Notification and Order Reports which has the capabilities of Dynamic filtering, sorting and selection of fields based on BSP application

·          Developed Portal application with Collaborative environment, which access the workflow workitems with Universal worklist in one Iview and Complex SAP screens and JCO and JCA connectivity.

·          Involved in developing Complex PBO/PAI Dialog programming screen, which communicates with workflow to set the workflow container flags during the approval process.

·          Developed a prototype BW data model and reporting to show the power of Multi-dimensional OLAP analysis for the PM/QM Module. Prototype replaced the equivalent BW reports for the existing reports in R3 PM/QM Module and the data retrieval process.

·          Analyzed the possible use of BW Business content Cubes such as Notification, Inspection Results, lots and usage and developed these available standard reports in QM Business content to speed up the implementation

·          Developed Standard reports such as Notification Analysis and Maintenance Order Analysis..

 

Samsung                                                                                                                                           Mar 2004 to May 2004

SAP BW/ABAP Consultant

 

·          Developed the complete data model involving QM Notification (Activities, tasks, items and cause) and Inspection results (General and Quantitative data).

·          Developed the standard reports for Quality Management  such as :

o         Defect Analysis

o         Vendor Analysis / Evaluation

o         Material Analysis

o         Notification Analysis

o         Inspection Results

o         Usage Decision

·          Provided support for the existing SAP BW data model based on SD and FICO by tuning the Transfer/Update rule and aggregates to improve performance.

·          Written Complex Data Transformation Rules with ABAP to combine the data from different source system to remain same and to get the date range automatically based on the fiscal period.

·          Developed and maintained queries with Restricted Key figures, Calculated Key figures, Selection, Formulas, Variables, Conditions and Exceptions.

·          Created and maintained InfoSpokes through Open Hub Services (OHS) to export data from the data targets to external logical source.

·          Created Web Templates with BEX Web Application Designer for analysis and reporting and to display the Report in Web.

 

National Semiconductor                                                                                                                  Jan 2004 to Feb 2004

SAP BW Consultant

 

·          Worked extensively on BW 3.1c.

·          NSC Required 2 Cubes one with the Current 36 period Special Ledger data and the other with History data, 1 ODS for Detail data, 1 Multicube to make Actual / Plan analysis based on the 2 cubes.

·          During the ETL process I developed several Filtering Criteria in Start routine and Transformation based on requirement in Transfer and update rules which involves complex ABAP Routine.

·          During the Loading process wrote ABAP Routines to automatically retrieve the current 1-month period selection with the current date.

·          Loaded the Data from SAP R/3 as well as Flat file and made the required configuration to successfully load the data.

·          Developed the Process Chain for transaction and master data with prior notification with email if the Data Load fails. The process chain Steps involves Deletion of Requests from PSA, Deletion of Data from the Data target, Deleting/Generating Index, Loading the data with prior Transfer Routines and Filling the Aggregates for loading Transaction data into the Cube.

·          Developed Several Queries based on the Special Ledger Cubes and developed Web Templates Based on the query with NSC specific Template Design.

·          Enabled the Report to support Report-to-Report Drilldown to the detail Level.

·          Configured & Scheduled the BEX Download Scheduler to Download the Reports to local file (htm or xls) so that the reports can be distributed offline.

·          Developed InfoSpokes using Open Hub Services to extract the BW analytic data with high volume to flat file.

 

Samsung                                                                                                                                          June 2003 to Dec 2003

SAP BW Consultant

 

·          Developed Info cubes, Multi cubes, ODS objects and extracted Master data and Transaction Based Data in SD and FI/CO Modules.

·          Developed and maintained queries with Restricted Key figures, Calculated Key figures, Selection, Formulas, Variables, Conditions and Exceptions.

·          Optimized the performance of the Data targets (InfoCube, ODS, MultiCube…) by Loading the Data through proper selection criteria and maintained the request for each each data load to compress it in the future.

·          Created Web templates with BEX Web Application Designer for analysis and reporting and to display the Report in Web.

 

Hyperroll                                                                                                                                            Jan 2003 to May 2003

SAP BW Consultant

 

·          Developed Info cubes, Multi cubes, ODS objects and extracted Master data and Transaction Data from FI/CO Modules.

·          Involved in troubleshooting data load in the information supply chain to enable successful Go live implementation

·          Developed several Reports based on FICO application area.

o         Actual/Plan Analysis by Cost Center

o         Reports on Assets by Cost Center

o         Cumulative comparable analysis of G/L Balance by selected Periods

o         Comparative analysis current year with prior year of GL Breakdown Periods

·          Evaluated an external tool to improve performance of BW query and aggregation.

·          Developed a prototype for Sales analysis with and without middleware to demonstrate the performance improvements in reporting

·          Scheduling periodic data loads from SAP R/3 to BW. Advised delta enabled data load and prior use of ODS Layer.

·          Developed Complex reports with BEX analyzer and BEX Web application designer.

 

Samsung                                                                                                                                           Mar 2002 to Dec 2002

SAP BW Consultant

 

·          Created, activated and worked on a daily basis with Extractors, Generic Extractors, Generic Data Sources, Info sources, Transfer Rules, Update Rules, Info packages, Info package Groups, Info objects, ODS, Info cubes, ODS Structures, Queries, Variables, Calculated & Restricted Key Figures.

·          Created & maintained Start routine to filter out prior unwanted data while loading for functional enhancement during data update in update rules & transfer rules.

·          Created and maintained Transfer rules and Updates rules to map the fields of DataSource to InfoSource and InfoSource to InfoCube Respectively.

·          Worked extensively on BEX Query Designer. Developed flexible queries using filters, navigational attributes in BEX Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information. Developed SD Reports,

o         Top Customers

o         Weekly/Monthly Deliveries

o         Returns per customer

o         Billing Documents

o         Quotation success rate

·          Create and Maintain BW Authorizations on hierarchies (RSSM).

·          Customized and maintained interface with Flat file and successfully extracted data into the SAP BW system