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 with upgrade from BOBJ 3.x to 4.x
• Experience in using Information design tool (IDT), to create universes using multiple DataSources.
• Created rich visualizations using SAP Lumira to analyze the commits and forecasts for finance reporting.
• Understanding of HANA views
• 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
• 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.

TECHNICAL SKILLS

BI Reporting tools: BO 4.1 BO 4.0, BO 3.1, WEBI, Lumira (Visual Intelligence), Information Design Tool, Universe Design Tool, Dashboard Design Tool (Xcelsius), Explorer, Business Objects Analysis for Microsoft, Data Federator Admin Tool, Crystal Reports, Tableau Desktop/Server 7.0/8.1/8.3 versions.

ERP Modules: SAP R/3 (4.7) FICO, SD & MM, PS ECC 6.0

Data warehouse: SAP BW 7.3, SAP BI 7.0, SAPBW3.5

BW Reporting Tools: Bex Tools -Query Designer, Bex Analyzer, Web Analyzer, Web Application Designer, Visual Composer.

Database tools: Oracle 9i, 10g, 11g, Microsoft SQL Server

Tools: Microsoft Office, HPQC, Mercury Quality Center.

Operating System: Unix (HP), Linux, AIX, Win2k Servers/NT, XP, Vista, Windows 7

Languages: SQL, ABAP, C, C++, JAVA

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. SAP BO Consultant

Responsibilities:

• Interacted with the business to gather requirements for profit and loss reporting for Finance division
• Created Webi reports, Document Linking and Dashboards for COPA reporting on Commits, Forecast and Actuals for Products and Product Lines while integrating business Units
• Led the team in upgrade testing of the BOBJ environment from for service pack upgrades and system upgrade from 4.0 to 4.1
• Created HANA views for the material master tables for master data reporting.
• Created multiple publications for Engineering reports to meet user requirements, where the reports were pushed to vendor inbox.
• Architectured the Development of 27 reports and 2 dashboards for Project Systems reporting under aggressive timelines with Unit Testing/ UAT and Production migration
• Developed Dashboards using live connections and BIWS for Operations analysis
• Acted as SME for Installation & Warranty reporting under Project Systems
• Created queries to determine spend by excluding partial months in the system’s life cycle for Operations Reporting
• Created visualizations for finance team for commit and forecast analysis using SAP Lumira.
• Developed audit reports to monitor the usage of over 700 webi reports and 80 dashboards over the NorthAmerica, Europe and APAC.
• Created Bex Reports as per business needs to build Webi Reports using BICS connections
• Developed Restricted and calculated key figures to be used with flexibility for various reports across a single query
• Created Analysis for Office workbooks on Bex Queries for Services Reporting
• Implemented insightful reporting in Webi where the user is able to Identify the selection parameters in the report
• Extensively worked with Business and functional team to implement reporting for Financial Supply Chain Management (FSCM) and Bill to Cash (BTC).
• Extensively used HPQC for Quality Assurance and Control in the development to go-live cycle, while monitering the integration of newly acquired Business Units.
• Implemented Conditional Formatting in Webi reports for Service Delivery team to easily identify the performance and life-cycle of the Opportunities.
• Created Functional and Technical Specification documents for Reporting in COPA, Project Systems, and Operations
• Worked as Production Support Lead for BOBJ and managed BW support team as well
• Well versed with SNOW for managing support tickets
• Developed dashboard and Webi reports to analyze the data in SNOW from a support standpoint
• Implemented Security Personalization and set-up users using Excel for Explorer Information Spaces
• Automated Securities for Information Spaces using Unx universe
• Managed the transaction RSDDTPS for maintaining user access to the Explorer cubes
• Created detailed documentation managing Information Spaces, Indexing and Personalization
• Managed CMC for Promotion Management over D, Q, P systems.
• Used Instance Manager as part of housekeeping activities to clear old scheduled instances
• Developed .unx universes on non SAP systems like workday, MSBI and Oracle Databases.
• POC on Tableau based on Excel and SAP Business Warehouse

Environment: Netweaver 2004S, SAP BW 7.3, ECC 6.0, Oracle 11g, Microsoft SQL Server, Business Areas: MM (Purchasing), SD, BEx, BO 4.0, BO 4.1, WEBI, IDT, Dashboard Design Tool, BO Explorer, AAOE

Confidential, CT

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.
• Part of the upgrade team for BO 3.1 to 4.0 upgrade. Migrated objects to BO 4.0 from BO 3.x using Upgrade Management Tool
• 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 in IDT
• Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).
• Created user Prompts, List of Values (LOVs) and Restrictions for reporting parameter specification as per user requirement
• Established connectivity to SAP BW system through BICS to directly access BEx queries.
• Modified BEx queries in to generate WEBI reports in BO 4.0 to meet user requirements.
• Created Multi-Source universe using relational connection based on SAP BW, MS Access and Flat files.
• Created and configures Information Spaces for time-based data based on Universes using BO Explorer.
• Scheduled indexing for these Information Spaces.
• 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
• 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 in corporate query requirements.
• 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.
• 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

Sr. SAP BO/BW Consultant

Responsibilities:

• Created Universes over BEx queries and MultiProvider of SAP BW using Universe Designer.
• Created Detailed, summarized and Aggregated tables to improve query performance.
• 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.
• Proficient in using Break points, Functions, Slice and Dice, Variables, Filters, Calculations and Alerts for creating complex reports in WEBI
• Created WEBI reports & Crystal reports and deployed them through Info View with Universe as source.
• Extensively worked on creating Prompts at universe level and Webi query level.
• Worked on creating Query filters, quick filters and Input controls in Webi reports.
• 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.
• 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

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 Xcelsius Dashboards.
• Extensively worked on SAP QAAWS used in mapping data directly from Universe to Xcelsius Dashboards.
• Created Three Xcelsius Dynamic Dashboards 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, transactional data and delta uploads.
• Worked on Order-to-Cash business process giving Bookings, Billings, Backlog analysis, Sales Commission.
• Implemented LO 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 independent Sales InfoCubes 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

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 LO Cockpit (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 Process chains to automate and schedule the background performance tuning 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

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 Content sales, PO and Inventory extractors and custom-built extractors depending on requirements.
• Generated regular and customized DataSources from APO DP 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 DSO Objects 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 Cell Definitions 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

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.