ARUN PRASAD BHUVANENDRAN
San Jose CA
Phone :
408-306-3967
Email :
be_arun_prasad@yahoo.com
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 ·
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 |
|
|
|
|
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 ·
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 SAP BW/CRM Techno-Functional Consultant |
|
·
Worked
on this New Implementation and Project plan through SAP ·
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 ·
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 o
Reports
on Assets by 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 |