Summary:

• 8 years of IT experience in SAP BO, BW and R/3 implementations, custom development involving all phases of the package development life cycle to meet the business needs.
• Experience in using Information design tool (IDT), to create universes using multiple DataSources.
• Created connections to BEx queries and BW Infoproviders using Business Intelligence Consumer Services (BICS) in IDT.
• Expertise in using Universe Designer over BEx queries and InfoCubes to migrate & model data from BW to BO for reporting. Excellent skills to develop reports using WEBI.
• Expertise in creating Xcelsius Dynamic Dashboards using SAP BI data/ BEx Queries. Valuable Knowledge on Xcelsius Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.
• Proficient in Business Objects Reporting using Web Intelligence, Crystal Reports, WEBI Rich Client, Live Office and Xcelsius for both SAP and Non SAP sources.
• Strong knowledge In creating connections using Data Connection manager like Live Office, Query As A Web Service (QAAWS), Flash Variables, SAP BI connectors, UD connecters, DB connectors.
• Proficient in creating Information spaces based on universes and created Exploration views and View sets in BO Explorer.
• Hands on experience in designing custom Queries, Query Views, Web Templates defining Conditions, Exceptions, Variables (User Entry, Replacement Path, User Exit & SAP Exit) Structures, Cell Editor, Calculated Key Figures (CKF), Restricted Key Figures (RKF), RRI (Jump Target),Filters, Free Characteristics and Selections.
• Expertise in Business Explorer Suite - BEx Query Designer, BEx Analyzer, BEx Web Analyzer and BEx WAD
• Hands on experience in various cross functional modules such as: SD, MM, PP, FI-CO and HR.
• Extensively worked on Modeling, Remodeling and maintenance of InfoCubes, DSOs (Standard, Write-optimized and Direct Input), InfoObjects, Data Flow 3.x (Transfer rules, Update rules),Data Flow 7.0 (Transformations, DTP), Info packages, Extractors, InfoSources, InfoObjects Catalogs, InfoAreas, DataSources, Data Extraction, Business Content, DataMarts, Process Chains, MultiProviders, InfoSets, Open Hub Destination.
• Involved in 3 full life cycle implementations
• Developed Routines (Start, End and Expert) during the creation of Transformations and DTPs using ABAP
• Expertise in SAP R/3/ECC Data Extractions (LO Cockpit, Generic Extractions and Business content) & Flat file extractions. Good knowledge of SCM functionality.
• Hands on experience in enhancement of BC extractors for both master data and transaction data sources via User Exits.
• Experienced in Performance Tuning, Aggregates, Rollups, Partition, Compression & ABAP Tweaks.
• Experienced in improvement of data loading performance by PSA partitioning & parallelization of loads
• Hands on experience in the BW Upgrade from 3.5 to BI 7.0.
• Experience in enhancing DataSource as per user requirements.
• Extensively worked on extracting data from non SAP systems like Teradata using DB connect. Have good Business Knowledge about MDM (Master Data Management) functionality.

TECHNICAL SKILLS:

Data Warehouse : SAP BW 7.3, SAP BI 7.0, SAPBW3.5 (SD, MM, HR, FICO, COPA)
BW Reporting Tools: Bex Tools -Query Designer, Bex Analyzer, Web Analyzer, Web Application Designer, Visual Composer.
BO Reporting tools: BO 4.0, BO 3.1, WEBI, Information Design Tool, Universe Design Tool, Dashboard Design Tool (Xcelsius), Explorer, Crystal Reports.
Languages: ABAP, C, C++, JAVA
Database: Oracle 9i, 10g, 11g, Microsoft SQL Server,
Tools: Microsoft Office, Mercury Quality Center.
Operating System: Windows, Unix/Linux

Professional Summary:

Confidential, CT June 2012-Present
Sr. SAP BO/BW Consultant

Responsibilities:

• Interacted with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Developed WEBI reports on SAP BW Queries using BICS.
• Modified BW queries in to generate WEBI reports in BO to meet user requirements.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects.
• Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).
• Created WEBI reports & Crystal reports and deployed them through Info View with Universe as source.
• Created and configures Information Spaces for time-based data based on Universes using BO Explorer.
• Scheduled indexing for these Information Spaces.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Created Inventory Accuracy Dashboards and for Management Reports for Inventory Management, and Wages and Cost report from Cost Center Accounting data.
• Worked on Dashboard Design Tool development using web service on top of SAP BW Trained Power Users on the new reporting tool Business Objects.
• Created queries to determine No. of PO items for a particular Material Group and Type and quantity of material ordered by a vendor and other custom queries meeting end user requirements.
• Developed flexible queries with variables using filters, Navigational attributes and Reusable structures.
• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas,Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.
• Used Cell-Definitions, Structures, Exceptions, Conditions, and various User Exits in the Reports.
• Designed global structures to incorporate query requirements.
• Created several Workbooks using BEx Analyzer by using the queries created using query designer.
• Created Web templates for queries and Dashboards using Web Application Designer and also worked on the WAD to create specific templates based on the business requirements of the user
• Installed Business contentfor Purchasing in MM module.
• Extracted data from MM modules and uploaded purchasing DSO objects 0PUR_O01, 0PUR_O02, 0PUR_DS03 via 2LIS_02_HDR, 2LIS_02_ITM and 2LIS_02_SCL
• Successfully loaded data into Purchasing item service level cube 0PUR_C08 and Purchasing data cube 0PUR_C01
• Created and maintained multiple InfoCubes for the SD module.
• Extensively worked with the InfoCubes 0SD_C05, 0SD_C03 and 0SD_C02 to fulfill client requirements of developing reports in sales and distribution.
• Updated data into these InfoCubes via DataSources 2LIS_11_VAITM, 2LIS_11_VAHDR, 2LIS_13_VDHDR, 2LIS_13_VDITM.
• Created InfoPackages for Full, Initial, and Delta extraction for both Master data and Transaction data with dynamic selection criteria where needed.
• Created Process Chains to automate the data load and data target administration and monitored the processes.
• Scheduled process chains for performance tuning jobs like creating Aggregates, Rollups, Indices and compression techniques.

Environment: Netweaver 2004S, SAP BW 7.3, ECC 6.0 Business Areas: MM (Purchasing), SD, BEx, BO 4.0, WEBI, IDT, Dashboard Design Tool, BO Explorer

Confidential, NE Sept 2011- May 2012
Sr. SAP BO/BW Consultant

Responsibilities:

• Developed System design specifications and reporting specification documents.
• Extensively worked on BO Migration of HR BEx queries. Worked on reviewing web intelligence reports and updating system integration Testing Documents.
• Loaded the data in to Head count and Personal actions 0PA_C01 Info cube.
• Extracted the ERTS data from SQL views through DB connect and UD connect
• Developed and broadcasted Head count, Turn over and Time to Fill web intelligence reports using SAP BOInfoView.
• Created Universes over BEx queries and MultiProvider of SAP BI using Universe Designer.
• Extensively worked on BO XI 3.1 for reporting purposes on Product Matrix Data providers.
• Created Multi Tab Ad-Hoc report according to user requirements.
• Experienced in working with different templates like horizontal table, vertical tables, Cross tab tables and charts.
• Extensively worked on creating prompts at universe level and Webi query level.
• Worked on creating Query filters, quick filters and Input controls in Webi report.
• Experienced in working with grouping, ranking, report variables and different functions in WEBI.
• Worked on performance tuning of Webi report and BW backend design.
• Developed custom queries and used standard queries for Inventory Management, Procurement, and Order Fulfillments.
• Created reports to monitor Material Movements, Dead Stock, and Stock over Flow slow moving items and stock quantity
• Developed flexible queries using filters, navigational attributes, variables in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Analyzed and Designed queries for open order values to incoming order values and credit memos to billing document.
• Involved in extracting SD and FI data from SAP ECC to SAP BW.
• Performed LO-Cockpit extraction to extract the Header and Line item data from the Sales and Distribution.
• Enhanced InfoProviders, MultiProviders and Transformations.
• Created queries for Top Customer, proportions of credit memos to billing documents, Quotation success rates among others
• Created and maintained multiple InfoCubes for the FI module.
• Loaded data into standard InfoCubes 0FIAP_C03 and 0FIAR_C03 using DSOs 0FIAP_O03 and 0FIAR_O03.
• Enhanced the 0FI_AP_6, 0FI_AR_6 DataSources.
• Worked on transformations to include custom ABAP code to meet the reporting requirements.
• Analyzed Business needs for procure to pay (PTP), Order to cash (OTC) work streams and created business events to meet solutions.
• Created Non-Cumulative key figures, InfoObjects, DSO, InfoCubes and MultiCubes.
• Used DSO to stage the data before transferring the DSO contents to the InfoCube. Done DSO reporting to give details of delivery items and schedule line items.
• Created a start routine to restrict material movement data while loading Inventory Management InfoCube.

Environment: SAP BI 7.0, BO XI R 3.1, ECC 6.0, ABAP/4, Oracle and Windows XP, Business areas : FI, SD, MM

Confidential, MO October 2010- August 2011
SAP BO/BW Consultant

Responsibilities:

• Created Universes over BEx queries and Info cubes of SAP BI using Universe Designer.
• Extensively Worked in SAP Live Office to create connections b/w WEBI and XcelsiusDashboards.
• Extensively worked on SAP QAAWS used in mapping data directly from Universe to XcelsiusDashboards.
• Created Three XcelsiusDynamicDashboards over SAP BI data.
• Created WEBI reports with Complex Calculations to get Alerts for Xcelsius Dashboards.
• Developed Local and Global Structures for reusability and using Filter values in the reports for further breakdown of the report.
• Worked towards optimal development of Universes by removing loops through the use of aliases and contexts, Creating Universe with number of Classes, many objects, Derived Tables using inner/outer and equi joins as per requirement
• Developed various RRI / Jump Targets using WAD, RSBBS (web template to web template, URL, R3 etc ).
• Worked on Creating Aggregates, Compressions, Indexes, MultiProvider and parallel setups for data loading to improve performance and utilize data effectively.
• Created Web reports using Web Application Designer to access the reports through portal using Information broadcasting in BEx broadcasting of workbooks.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Identified the Gaps in Business content and designed the best possible solution to bridge the gap by creating custom DSO, Cubes and extractors.
• Activated Business Content for SD and personnel administration and Payroll InfoCubes.
• Developed data loading strategies for master data, transactionaldata and delta uploads.
• Worked on Order-to-Cash business process giving Bookings, Billings, Backlog analysis, Sales Commission.
• ImplementedLO structures for Purchasing, Inventory, filled setup tables for Init loads and scheduled V3 updates using cockpit after initialization of delta processes
• Analyzed the sales data and figured out the fields needed to be added in the sales data.
• Built independentSalesInfoCubes and extracted data from sales modules.
• Involved in extraction of master data from interface files and SAP R/3 DataSources.
• Worked on MultiCube to compare the Sales data and Plan data.
• Extracted Data from SAP SD, MM, HR of R/3 into SAP BW.
• Involved in Initializing the LO Datasources - 2LIS_11_VAITM and 2LIS_11_VASCL by activating the Business Content DataSources, Maintaining the Extract Structure, Generating the DataSource, Activating the DataSource, Enhancing the DataSource and Used the Enhancement RSAP0001 to fill the data into the Fields Enhanced.
• Installed Business Content Sales Overview Cube and designed and activated Customer service to meet user needs. Created several DSO objects which acts as data staging
• Worked on DataStore Objects (DSO) to stage the data before transferring it to the InfoCubes.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.

Environment: SAP BI 7.0, BW 3.5, ECC 6.0, BO XI R 3.1, Business Areas: HR, SD, MM (Purchasing and Inventory Management)

Confidential, WA Jan 2010- Sept 2010
SAP BW Consultant

Responsibilities:

• Involved in Full life cycle implementation Of BI 7.0/NetWeaver 2004s as well as an up-gradation of SAP BW 3.5 to BI 7.0/NetWeaver 2004s and Performanceanalysis.
• Designed functional/technical specs for complete end to end Implementation/Development of SAP BI.
• Interacted with the Management and Business End-Users to identify business requirements and actively involved in implementing ASAP methodology.
• Involved in Requirements analysis, Data Modeling and technical implementation.
• Customized/designed Data Flow right From ECC to BI and further. Activated Business content and designed data flow from BW 3.5 to BI 7.0
• Trained business users on the updated BI 7.0 features.
• Interacted with end-users to gather business requirements and transformed them into technical work plan.
• Extensively worked on Travel Expenses (T&E) /Planning (0FITV_C02, 0FITV_C01) InfoCubes of HR-TM.
• Worked on HR-Time and Payroll data MultiCube 0PY_MC02 in order to build complex BEx reports.
• Extracted data from SAP ECC using LOCockpit (2LIS_11_VAHDR, 2LIS_11_VAITM) and worked on enhancing the extract structures based on the Client Specs.
• Activated the DataSource 2LIS_04_P_MATNR in the LO cockpit. Extracting the data from MM (Material Management - “2LIS_03_BF” DataSource), and PP (Production Planning and controlling) modules.
• Extracted and loaded data into InfoCube 0PP_C10 to analyze status of manufacturing orders.
• Leveraged on the business content InfoCubes (0SD_C03, 0SD_S13) to extract sales and shipping data and did enhancements to fill the user reporting requirement.
• Created ABAP routines to develop Transformation rules to populate fields or to modify the existing data according to business requirements.
• Created MultiProvider on Sales Order/Delivery and Vendor Analysis Account Payable Line Item cube (0FIAP_C03).
• Created MultiProviders and InfoSets on which BEx reports were developed and published queries on web.
• Extensively involved in production support by loading Daily loads/Weekly loads into the BI system from different source systems.
• Maintained Processchains to automate and schedule the background performancetuning jobs of BW query using Indices, Aggregates, Compression, Archiving and Partition.

Environment: NW 2004s, BI 7.0, BW 3.5, ECC 6.0, BEx, BO XI R 3.1, Business Areas: MM, SD, FI, HR

Confidential, TX Jan 2008-Dec 2009
SAP BW developer
Responsibilities:

• Involved in full life cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Interacted with the end users to understand their reporting requirements and creating document of understanding.
• Extracted data from standard Business Contentsales, PO and Inventoryextractors and custom-built extractors depending on requirements.
• Generated regular and customized DataSources from APODP planning areas Used MultiProviders and InfoSets to extract data from tables and table joins.
• Worked on standard HR- Payroll and benefits extractors and reports.
• Created Process Chains and Meta-Chains for periodic upload of Text data, Master data and Transactional data, and Monitored data loads with full update and delta mechanisms.
• Performed analysis, design, development and implementation of standard/customized InfoCubes and DSOObjects for MM, SD, FI, HR and SCM modules.
• Created intermediate write optimized DSO Structures and APD’s in BI 7.0 to improve performance while loading AP data.
• Worked on customized and standard InfoCubes.
• Defined transformations, created DTPs and InfoPackages for scheduling loads to data targets.
• Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC-BI CMOD, Generic Extractions and also in BI data modelling like Start Routines and End Routines.
• Actualized various types of BEx query variables including User exit, Replacement Path, Text and formula variables.
• Created calculated and Restricted Key Figures, Structures, Conditions, Filters and CellDefinitions within queries, maintained Query settings and tuning.
• Performed performance tuning of queries using indices, aggregates, compression and partition.
• Built Aggregates, Indexes, enabled BIA, phased out and re-enabled few aggregates.
• Involved in designing and implementing user security at query level and cube level.

Environment: SAP BW 7.0, ECC 6.0, ABAP, SAP Portals, HR, SD, APO, Bex Analyzer,

Confidential, CA July 2006-Dec 2007
SAP BW developer

Responsibilities:

• Interacting with management and the end-users to identify the business requirements and documented them.
• Worked on Inventory handling and material movement (Article) to Distribution center and Customer.
• Involved in the design and development of InfoCubes. Responsibilities include development of new InfoCubes & Enhancements to the existing functionality as per the user requirements.
• Involved in the design and development of InfoCubes and ODS objects in SD, MM & FI applications.
• Defined Complex reports by defining complex ABAP Routines to get the fiscal period automatically based on the calendar day entered.
• Developed most of ABAP to code the logic in start routine so as to optimize loading times.
• ABAP code for functional enhancements for Transactional Data.
• Worked extensively with 2LIS_11_VAITM, 2LIS_11_V_SSL & 2LIS_02_SCL extractors.
• Extracted data form FI-GL DataSources 0FI_GL_4 and 0FI_GL_6 to load data into custom InfoCubes.
• Developed custom GL InfoCubes using the standard InfoCubes 0FIGL_C01 and 0FIGL_C02.
• Created InfoSets, assigned user groups to the InfoSets and also defined InfoSet queries. Created exception evaluations for queries. Designed multiple drill-through reports from BEx Queries, ODS Objects.
• Extracted the Purchasing details for Pre- packs from R/3 to BW.
• Provided support for data load, validation, performance monitoring and tuning. BW Data load scheduling, monitoring and troubleshooting data extraction / load problems using LO Cockpit and COPA.
• Report delivery is via the web using queries, web templates, and security-based roles.
• Scheduling InfoPackages for loading Master Data and Transaction Data & Monitoring.
• Configuration work has included InfoObjects, InfoCube, Transfer Rules, Update Rules, Roles, Queries, Web Templates, ABAP, etc
• Extracted purchasing documents and inventory data from R/3 using LO cockpit, implemented Report-to-Report Interface and R/3 thrill-through for drill down analysis, and developed SAP BW reports for performing the analysis of purchasing documents and inventory management
• Uploaded master data and transactional data from SAP R/3 via data staging to PSA, ODS and Info Cubes. Worked with data flows from R/3 to BW.

Environment: SAP R/3 4.6 C, BW 3.5, SAP Portals, MM, FICO, BEx Analyzer, BEx Browser, WAD Web Template, ABAP Query, Oracle 8.0, Windows NT.

Confidential, India May 2004- March 2006
SAP BW Developer

Responsibilities:

• Conducted User requirement sessions and actively involved in requirement analysis.
• Followed ASAP Methodology throughout the development of the project.
• Involved in discussions with the top management as well as end users for Business Requirement Analysis in order to freeze the functional design specifications for data capturing from the existing business scenarios.
• Used BW transactions like RSA1, RSD1, LISTCUBE to maintain BW objects and data.
• Creating new data models using 3.x Datasources, PSA, Transfer rules and update rules, working with new Operational DataSources, and Virtual InfoCubes with Direct Access and InfoCube with RDA (Real time Data Acquisition). Worked with the Remodeling Toolbox to change the existing data models.
• Analyzing source data, and helping to establish ETL guidelines, to the design, development, and testing of Data Stage ETL programs/processes to move and transform data from several businesses into corporate Oracle data warehouse.
• Extensively worked in improvement of the Query performance by creating Aggregates and Compressions on Info cubes.
• Created different Reports in MM, SD, FI module such as product stock value available based on the product type, Best selling products, Billed selling orders based on territory etc.
• Good understanding on Performance Improvements in areas like Change Run, Aggregate analysis, Compression techniques, Query Parallel processing.
• Created reports using BEx Reports, Workbook, and Queries for the required sales order queries with exceptions, conditional formatting, restricted key figures and calculated key figures.

Environment: SAP BW 3.0B, R/3 4.6C, SD, MM, FI/CO, BEx Analyzer, BEx Browser, WAD Web Template, ABAP Query, Windows NT.
References available upon request