Profile:

• 7 yrs of strong experience in implementing Enterprise Scale Reporting Solutions using SAP BW / BI /BO.
• Full life cycle experience, Significant contributions to all project lifecycle phases, from blueprint and design to configuration, functional design, requirement analysis/definition/determination, test execution, issue resolution, training, go-live assistance and post implementation support
• Involved in end user training, integration testing, resolving performance issues and production support activities.
• Motivated and focused team player with strong analytical and problem solving skills with excellent interpersonal and communication skills.
• Implemented ASAP methodologies( Project Preparation, Blueprint phase, Realization, Final Preparation, Go-live and Support) and Agile Methodologies( Development iterations, Teamwork, Collaboration, and Process adaptability throughout the life-cycle of the project )

BI / BW / BO Experience Summary:

• Comprehensive functional knowledge in Sales & Distribution (Sales Orders, Deliveries, Billing , Retail & Warranty), MM (Purchasing & Inventory Management), PS , QM, FI/CO ( General Ledger , AR , AP , Funds Management , CCA , PCA and COPA ) and general business process of SAP ECC.
• Good functional knowledge in CRM Modules like Service, Sales, Accounts, Master Data and Marketing.
• Experience in various Business Objects Applications (Universe Designer, Webi, Crystal Reports and Xcelsius).
• Expertise in Integration of SAP BI with Business Objects, Crystal Reports and Xcelsius using SAP integration kit.
• Experience in configuring BW publisher to publish crystal reports to BOE Server.
• Extensively worked on creating captivating interactive Xcelsius Dashboards using Query as Web Service and the New SAP BI Connector.
• Extensively worked on creating highly formatted Crystal Reports using options such as Charts, Grouping, Sorting, Alerts and Field highlighting.
• Expertise in upgrading the BW systems from versions 3.1c and 3.5 to 7.0,
• Expertise in designing and implementing the DSO’s, InfoCubes and MultiProviders as per the SAP Best practices.
• Extensively worked on the features of BI 7.0 like transformations, Data Transfer Process, Remodeling of the Info Cubes, Error DTPs, Data Store Objects, Start Routine, End Routine and the New Data Source.
• Extensively Involved in Managing of Info Cubes and resolving the reporting performance issues by updating the Indexes and Statistics, Compression of Info Cubes, logical and physical partitioning, Aggregates, Maintaining Accelerator Indexes and Rolling up of the data.
• Expertise in LO (SD, MM, PP, QM), FI/CO, COPA, PS, CRM Service, Sales, Master Data and Generic data extraction mechanisms.
• Experienced in activating standard Business Content, extending and enhancing using User Exits according to the end-user requirements
• Extensively worked on the Reporting Agent and Information broadcasting for running the reports in background to improve the performance of the reports by filling OLAP Cache and broadcasting the reports to email accounts both internal and external.
• Involved in Post-Production support that includes monitoring of process chains and data loads, reconstruction of data targets in case of failed loads, rescheduling of process chains, debugging of transfer, update routines and transformations.
• Expertise in creating Bex Queries using structures, variables, calculated key figures, restricted key figures, cell restrictions and RRI Jump Queries.
• Expertise modifying standard templates and creating custom templates Using Web Application Designer.
• Extensively worked on Extracting Data using DB Connect and Flat Files.
• Extensively worked on the BI Accelerator (BIA), which involves creating BIA indexes and rolling up of the data.
• Expertise in writing ABAP code in start / end routine and routines in transformations.
• Experience in publishing Bex Reports to Enterprise Portal by creating Iviews.
• Experience training end users in Bex reports, workbooks, Crystal reports and Xcelsius.

Technical Skills:

Data warehousing tools : SAP BI 3.0B/3.1C/3.5/7.0, BO XI 3.1.
Languages : ABAP.
Databases : Oracle 8i/10g, MS-Access, MSSQL.

Reporting Tools : Bex Query Designer, Web Intelligence, Crystal Reports, and Xcelsius.
CRM : CRM 5.0, CRM 7.0.

Confidential, Santa Barbara, CA Feb 09 Till Date
Role: SAP BW / BI / BO Lead

• Designed and implemented the information model for Finance, Shipping, Received product and Inventory tracking.
• Extensively involved in gathering the reporting requirements from the business users by conducting workshops and meetings.
• Extensively involved in creating the detailed reporting requirements documents for each reporting area and for the cross functional reporting.
• Involved in a detailed gap analysis between the SAP Standard Business Content and Reporting Requirements.
• Involved in creating a technical design document for each of the reporting areas.
• Designed and implemented a highly complex information model using multiple DSO’s, Cubes and MultiProviders.
• Extensively involved in training of the end users and creating training documentation.
• Extensively worked on writing test scripts and also on the Unit and Integration testing of the reports.
• Configured the Integration of SAP BI with Business Objects, Crystal Reports and Xcelsius using SAP integration kit.
• Configured the Business Objects BW Publisher to publish Crystal Reports from SAP BI to BOE server.
• Involved in importing SAP roles into Business Objects Enterprise, for allowing role members to log onto Business Objects Enterprise with their usual SAP credentials.
• Developed highly formatted P& L, Balance Sheet and Cash Flow Crystal Reports based on Bex Queries using formatting options like charts, grouping, alerts, parameters, formula fields, special fields and running total fields.
• Developed multiple Crystal reports for each of the functional areas with parameters, formulas, custom functions, alerts, multilevel groupings and drill down reports.
• Developed intuitive and captivating departmental Xcelsius dashboards using Query as web service and the new Sap BI connector.
• Extensively working on setting up the information broadcasting to improve the query performance by filling OLAP cache and to broadcast the reports to internal and external users.
• Extensively worked on reporting authorizations and creating of user id’s.
• Involved in publishing BI reports as Iviews in the Enterprise portal.
• Involved in creating, scheduling, monitoring of the process chains and resolving the production issues.
• Extensively Worked on the Transformations, DTPs, Error Stacks and Error DTPs.
• Extensively worked on Start routine, Transformation routines and End routine.
• Extensively worked on setting up the report to report interface to jump from summary reports to detail level reports.
• Involved in creating RFCs between ECC and BI and creation of the source system for the data extraction.
• Extracted the legacy historical data from MSSQL using DB connect for cross system reporting.
• Transported the objects along the ECC and BI system landscapes.
• Extensively worked on identifying and activating the standard business content extractors, cubes , DSOs and reports in the modules of SD, MM and FICO
• Designed and created custom info cubes using SAP best practices for the Shipment and Supply Analysis.
• Created generic extractors with delta capability using tables, views and function modules.
• Extensively involved in setting up of procedures for extracting data from SAP ECC by using generic extraction, FICO and LO cockpit.
• Copied the standard info cubes like 0IC_C03 and 0FIGL_C10 and customized them as per the design requirements.
• Enhanced the standard extractors like 2LIS_02_PUR, 2LIS_03_BF, 2LIS_11_VAITM, 2LIS_12_VCITM, 0FI_AP_4 and 0FI_GL_4 as per the design requirements.
• Extensively worked on activating the business content objects in the modules of Sales and Marketing of CRM.
• Created custom extractors using function modules to extract data for material characteristics, vendor contacts and batch master.
• Developed Balance Sheet Report with drill down for GL account , fund , grant, fiscal year, fiscal period, cost center document no and internal order.
• Developed P & L Report with drill down for GL account , fund , grant, fiscal year, fiscal period, cost center document no and internal order.
• Developed Cash Flow Report with drill down for GL account , fund , grant, fiscal year, fiscal period, cost center document no and internal order.
• Developed P& L Budget vs. Actual Report with drill down for GL account, fund, grant, fiscal year, fiscal period.
• Developed Shipment Report with drill down for sales order, delivery document, material document,plant,material,batch,storage location, vendor and customer.
• Developed Supply Report with drill down for purchase order, material document, plant, storage location, material, batch calendar month and calendar day.
• Developed Inventory Expiration Summary and Idle Inventory Summary Reports with drilldown for material, batch, Vendor, material type, Material Group.
• Developed Order aging and Delivery Process aging reports with drill down for material, personal no, customer, sold to party, ship to party and sales organization.

Environment: BI 7.0, ECC 6.0, CRM 7.0, SD, MM, FI, Bex Query Designer, WAD, Xcelsius, Crystal Reports and DB Connect.

Confidential, Houston, TX Jul 08 Jan 09
Role: SAP BI / BO Architect

• Involved in designing, documenting and configuring the Information Model for the Sales Contract Scorecard.
• Created Crystal reports with formatting options such as Charts, Grouping, Sorting, Alerting, Field highlighting, Drill-down, Parameter prompts
• Developed multiple Xcelsius dashboards using charts, containers, selectors, single values, maps and text components.
• Worked exclusively on Xcelsius Dashboards for analysis of Quarterly and Yearly sales.
• Extensively worked on creating the Web Templates as per the requirements
• Extensively worked on extracting data using DB connect and Flat files.
• Extensively worked on migration of Queries, work books, web templates and Query variants from 3.5 to 7.0
• Created / modified the workbooks using the design elements like text elements, Analysis Grid, Navigation panel, Drop down box and filters.
• Involved in creating the BIA indexes for the cube with performance issues and initial fill/rolling up of the indexes.
• Extensively worked on the start / end routines and the routines in the transformations.
• Extensively worked on transformations, Start routine, End Routine, DTPs, Error DTPs and process chains.
• Designed and developed custom DSO’s and Info cubes as per the requirements.
• Created generic extractors using function modules and tables for reporting on the custom build contract application in ECC.
• Involved in the plug in upgrade activities like clearing the LBWQ/SM13 and RSA7 queues on R/3 and support pack upgrade activities on BI.
• Extensively involved in monitoring the process chains and info package groups and resolving the production issues.
• Developed Contract commitment variance report which compares contract commitment values with actual with drill down for customer, sales representative, sold to party, sales org, DC, division and cal month.
• Developed Contract rebate tier variance report which compares rebates commitments with actual with drill down for customer, sales representative, sold to party, sales org, DC, division and cal month.
• Developed inventory control report which gives the GL balances for all the MM accounts with drill down for vendor, material, GL account no, Plant, Storage location, company code and cal month.

Environment: BI 7.0, ECC 6.0, SD, MM, FI, Bex Query Designer, WAD, Crystal Reports, Xcelsius and BIA.

Confidential, Milpitas, CA April 07 Jun 08
SAP Senior BI Consultant

• Involved in designing, documenting and configuring the Information Model for the CRM Service and Sales modules.
• Extensively involved in all phases of project from Requirements Gathering, Blueprinting, Configuration, Development, Integration Testing, Cutover, Go Live and Post Go Live Support.
• Involved in the creation of Report specs, integration test scripts and UAT Scripts.
• Extracted Data from CRM for the Service Contracts, Service Cases, Confirmations and Billing Using business content extractors and as well as generic extractors.
• Extensively Worked on the Transformations, DTPs, Error Stacks and Error DTPs.
• Extensively worked on Start routine, Transformation routines and End routine.
• Extensively worked on the currency translations in the transformations and reports.
• Worked on the report to report interface to jump from the aging summary report to the aging detail report
• Extensively involved in creation of secondary indexes on the Data store objects to improve the data load performance and indexes on the Master data tables when they are being used in the navigational attributes
• Worked on the report performance tuning techniques like compression of the requests, logical partitioning of the info cubes, Building of the aggregates, using the OLAP cache, Marking the dimensions to High cardinality, running the DB statistics for all info cubes after each data load and creating additional indexes on the master data tables that are being used in the navigational attributes.
• Extensively worked on logical and physical partitioning of the info cubes.
• Created generic extractors for billing and contracts conditions using the functional module for the discount analysis reporting.
• Activated, Enhanced and extracted data from the Profit Center Accounting using Profit Center line item extractor (0EC_PCA_3) and involved in the design and development of Data store objects, Info cubes, Multicubes for the Service Revenue and Service Profitability reporting.
• Developed reports using exceptions, conditions, offsets, calculated key figures, restricted key figures and exceptional aggregation.
• Developed Service Contract Amortization report which will give the month on month forecasting amounts, month on month actual amounts, total contract amount, total billed amount, and total back log amount with drill down for service organizations, service product hierarchy, tool hierarchy and sales hierarchy.
• Developed the Service Contract Penetration which will give the penetration of the contracts with the no of the tools with drill down by marketing category, marketing division, service organization and tool hierarchy.
• Developed the Service profitability report using data from the profit center accounting with drill down for service organizations, service product hierarchy, tool hierarchy and sales hierarchy.
• Developed the Billing Request aging reportwhich will bucket the Billing Request aging backlog amounts in the dates ranges from 0 to 30, 30 to 60, 60 to 90 and 90 and above with drill down for service organizations, service product hierarchy, tool hierarchy and sales hierarchy.

Environment: BI 7.0, ECC 5.0, FI-CO, my SAP CRM 5.0, Bex Analyzer and Query Designer, MS Sql server, WAD.

Confidential,OH May 06 Mar 07
Role: SAP Senior BI Consultant.
Phase: 1

• Involved in BI 2004s & BI Accelerator Sizing
• Involved in the Pre Upgrade Activities & post-Upgrade activities (3.1C to BI 2004s).
• Involved in the Pre Upgrade & Post Upgrade Activities for BI Plug-In Upgrade on the R/3 from 2003.1 SP 10 to 2004.1 SP 12
• Involved in the migration of the Bex Queries ,Query Variants, Workbooks and Web Templates from Version 3.1C to 7.0

Phase: 2

• Interacted with management and identified Business requirements, analyzed legacy reports in Sales & Distribution, Purchasing and inventory application areas.
• Created Dashboards and modified standard web Template Using Web Application Designer.
• Actively involved in Transports, Troubleshooting and Data Validation.
• Involved in the POC on the usage of the Visual Composer.
• Performance tuning of Queries by maintaining Aggregates, Compression of Info Cubes, Partition (Both Logical and physical) of info cubes.
• Involved in Business Content Activation, Enhancement of data sources and writing user exits (Master data and transaction data) on R/3 and BW.
• Activated and enhanced the BC line items extractors for Accounts receivable and Accounts payable extractors with the business area.
• Extensively involved in setting up of procedures for extracting data from SAP R3 by using generic extraction and customizing LO cockpit by using enhancements and writing User-Exit programs as per requirements.
• Activated Standard Business Content cubes for Sales & Distribution (Customer-0SD_C01, Deliveries-0SD_C02, and Sales Overview-0SD_C03) and Subsequent Data Flows.
• Developed reports in SD to display Quotation lists, Orders within time period, Billing due lists, delivery due lists, Sales Summary, Inquiries lists etc.
• Developed Days of Supply Report for measuring of the number of days of shipping can last with the current level of inventory with drill down for Plant, Material, Cal day and Material Type.
• Developed Safety Stock Days of Supply Report for measuring the number of days of shipping we can last with the standard level of safety stock. With drill down for Plant, Material Type, Cal Day, Cal Month & Material
• Developed Days Sales Outstanding report for measuring of the average delay to get paid, from the invoicing date with drill down for Plant, Company, Customer and Cal day
• Developed Days Payable Outstanding report for measuring the average delay to pay our suppliers, from the date of the payable. With drill down for Plant, Company, Vendor and Cal Day.

Environment: BI 7.0, ECC 5.0, SD, MM, FI, Oracle 9i, Bex Query Designer and WAD.

Confidential,Toronto, Canada Jan 06 April 06
Role: SAP BW Consultant

• Responsible for installing and customizing Business content as well as created generic objects as per the business requirements in the modules of FICO, MM and SD.
• Extensively involved in using the LO Cockpit extraction.
• Worked on the Reporting agent to run the queries in the background for the precalculation of the query results.
• Created Reports as per the Business requirement using Bex Query Designerand Dashboards using WAD.
• Worked extensively on the Business Content and Modified/Designed MM, Sales and Financial Info Cubes to meet the End-User Requirements.
• Created extractors to extract CO-PA data for the relevant Operating Concerns from SAP-R/3 into SAP BW and created corresponding Info Sources, ODS Objects and Info Cubes in BW and Enhanced the existing Extract Structure for CO-PA on the SAP R/3 side, to account for certain additional Characteristics
• Improved performance of existing SAP BW Queries and reports by 50% by creating Aggregates, Compression and Partition etc.
• Worked extensively on Bex Analyzer. Used Navigational attributes, Filters, Exceptions, Conditions, Jump targets (RRI), Variables and hierarchies.
• Created, Scheduled and monitored info packages and process chains to load data from R/3 and flat files, perform aggregate rollups, index maintenance, master data and ODS data activation

Environment: BW 3.5, SAP R/3 4.7, CO-PA, MM, SD, PCA, PS, ABAP, Bex Analyzer and WAD.

Confidential, Pune, India Oct 04 Nov 05
Role: SAP BW Consultant

• Involved in the requirements gathering phase to understand the business requirements and converting them to technical requirements
• Was part of BW implementation in the areas of CO-PA, Involved in creation of generic extractor for operating concern and modified the Standard Info Cube. The Cube design involves identifying the business reporting requirements, identifying characteristics and key figures
• Created Accounts Payable and Accounts receivable Cubes based on the reporting requirements. Modified standard Info sources like 0FI_AP_3 and 0FI_AR_3
• Worked extensively on Web reporting tools, designed and developed Web Templates and Dashboards Using WAD.
• Worked extensively with Business Content for modified existing Salesand Financial Info Cubes to meet the End-User Requirements
• Installed the technical content cubes to update the BW Statistics data.
• Created Aggregates on InfoCubes to improve Query performance.
• Modified several existing Bex. Reports to improve Query performance.
• Created generic function module extractors to extract the data from the Custom Warranty and extended warranty applications in R/3.
• Worked on the DB connect to extract data from legacy systems.
• Improved the Query Response time by reorganizing the Dimensions & providing Line Item dimensions.
• Extensively involved in setting up of procedures for extracting data from SAP R3 by using generic extraction and customizing LO cockpit by using enhancements and writing User-Exit programs as per requirements.
• Creating, Scheduling and Monitoring Info packages and load processes and Job/Process error Resolution.
• Designed and developed process chains (RSPC) for master data loads and transaction data loads with the help of Info Packages. And these Process chains are scheduled for periodic loads.
• Involved in creating and maintaining Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas, MultiProviders, Info Sources, Data Sources, and Info Packages.
• Involving in designing and implementing of Multi cubes.
• Involved in Transporting the BW objects from development server to Quality server for Integration testing and Unit testing.

Environment: BW 3.1C, SAP R/3 4.6C, FI-CO, LO, ABAP, AWB, Bex Analyzer and WAD.

Confidential,Ahmadabad, India Jan 03 Aug 04
Role: SAP BW Consultant

• Gathered Business Requirements and Conducted Gap Analysis to install Business Content.
• Designed & Developed custom DataSource, InfoSource, Extractor, InfoCube and ODS as per user requirements.
• Developed Transfer rules, Update rules and Start routines using ABAP to incorporate Business logic and perform data manipulation.
• Enhanced master data sources 0Customer, 0Material and 0Vendor to meet custom reporting requirements.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Developed data loading strategies for master data, transactional data and delta uploads.
• Created process chains for data loading, delta uploading and periodical PSA deletion.
• Extracted and loaded data from SAP R/3 into Sales Order InfoCube using DataSources.
• Created Multiprovider on sales and delivery cubes to assist reporting on sales and delivery together.
• Worked on Creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for data loading to improve performance and utilize data effectively.
• Extensively worked on Query Designer and Web application designer to create Queries to forecast sales, budget and delivery analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.
• Used reporting agent to create batch jobs for Report printing and Exception reporting.
• Involved in documentation and end-user training.

Environment: BW 3.0B, SAP R/3 4.6C, FI-CO, LO, ABAP, AWB, Bex Analyzer and WAD.

• Bachelor of Engineering