SUMMARY:

• SAP Certified BW IP/EPM BPC Senior Consultant with 13+ years of Techno - functional experience in SAP BW/IP/BPC environments.
• Worked on end-to-end SAP EPM BPC and BW-BPS implementations including Project Preparation, Blue print, Configuration, Testing, Go-live and Support.
• Worked in Production Support involving Break-fix resolution, Enhancements, Allocations, Period-end Close, Forecast Roll-forward, Scheduling Process Chains, and Transports.
• Expertise in SAP BW Integrated Planning (IP), Business Planning and Consolidation (BPC 7.0/7.5/10.0/10.1 ), SEM BW-BPS 6.0.
• Expertise in BPC Embedded system with Aggregation Levels, Planning Functions, Planning Sequences, FOX Formula, HANA Views, Analysis for Office (AO) Workbooks and Custom Planning Functions.
• Expertise in BPC Classic with EPM BPC Environments, Models, Dimensions (Flat/Hierarchical), Dimension Properties, Reports, Input schedules, DM packages, Security setup, Advanced Script Logic, BAdIs, Currency Conversions, Intercompany Eliminations, Allocations using Logic Script and Business Rules.
• Involved in analysis, design, development, configuration, testing and Production deployment of SAP BW/BPC data models following sound data warehousing principles.
• Expertise in Production support and Issue resolution which includes Period End Close, Projects Forecast Roll Forward, Process Chains Maintenance and Master Data loads.
• Excellent knowledge of ECC-BI dataflow and SAP delivered Business Content including ECC Extractors, InfoCubes, Data Store Objects (DSOs).
• Expertise in design and development of BI Realtime InfoCubes, BPS Planning areas - Basis and Multi, Planning levels, Planning packages, Manual Planning layouts, Planning functions, Planning Sequences - Local and Global.
• Knowledge of different forms of BPC logic: Worksheet Logic, Dimension Member Formulae, Script Logic, Business Rules; Reports and Input Schedules, Content Library and Live Reporting; Task Profiles, Member Access Profiles, Users and assignment to Teams; Security, Work Status Codes and Business Process Flows (BPFs).
• Excellent communication skills (verbal and written), analytical and problem solving skills.

TECHNICAL SKILLS:

SAP: NW 2004s, BI 7.0, BPC NW 7.0/7.5/10.0/10.1, SEM BW-BPS 6.0, SAP BW 3.5, 3.1, 3.0A, ECC 6.0/5.0, SAP R/3 4.7, 4.6C, 4.6B, 4.0, ABAP/4, FI /CO, PS, IM, SD, MM, HR, HCM, Business Explorer (BEx) Query Designer, BEx Analyzer, BEx Browser, Web Application Designer (WAD), Web Interface Builder.

Environment: s: Windows XP/2000/NT

Languages: ABAP/4, C++, SQL, PL/SQL, Java, Java Script, Visual Basic, Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Plano/Richardson, TX

SAP BPC 10.1 Sr. Consultant

Environment:: SAP EPM BPC 10.1, SAP BW 7.4

Responsibilities:

• Worked on BPC 10.1 Enhancements in Finance, Cost Detail and Treasury Models.
• Implemented Master Data Load for Region Hierarchy into CostCenter and ProfitCenter BPC dimensions.
• Enhanced BPC CostCenter and ProfitCenter Master Data loads by implementing JavaScript to automate Conversion for CostCenter and ProfitCenter values in Conversion Files, and updating Transformation Files to load the Region Hierarchy.
• Worked on BPC enhancements evaluation for NIC (Non-Inventory Cost) Rate Calculations, TMG (TI Manufacturing Group) Package Group Planning, Allocations, and Improvement of BPC logon performance.
• Developed and tested BPC Input Schedule for Treasury House Bank Consolidated Forecast.
• Developed and tested BPC Treasury Cash Flow Detail Report.

Confidential, Torrance, CA

Sr. Consultant

Environment:: SAP EPM BPC 10.0/10.1 Embedded, SAP BW 7.4

Responsibilities:

• Worked on Confidential implementation of BPC Planning, Budgeting and Forecasting at AHMC ( Confidential ) and HAM ( Confidential ) including several other Companies of Honda using BPC Embedded and Classic Models.
• Designed and developed Aggregation Levels, Planning Filters, Planning Functions, Planning Sequences, Input Ready queries, Analysis for Office (AO) Workbooks, EPM Templates and BEx Workbooks as required.
• Worked extensively on developing Aggregation Levels, Planning Functions, and Planning Templates using BPC Embedded System.
• Designed and developed ABAP Exits required for BEx Variables and Custom Planning Functions.
• Developed complex AO Templates for P&L using BEx Structures, VBA and Excel Functionality.
• Developed data interfaces for BW HANA using SLT, BODS and ODP technologies.
• Developed various HANA Information Models, Attribute Views, Analytical Views, Calculation Views, SQL Scripts.
• Extensively worked on Pre Upgrade steps required for BW HANA migration.
• Extensively worked on re-implementing BPC layouts in BPC 10.1 Embedded.
• Designed and configured BPC Environment for North America, Models for BUDGET, PROJECT SYSTEMS, COST PER UNIT, WORKFORCE, IN-HOUSE COST, SUPPLIER BUYER TOOLING, RATES, Dimensions for ACCOUNT, ASSET CLASS, ASSOCIATETYPE, AUDITTRAIL, COMPANY (Entity), COSTCENTER, EVENT (Category), INTERCO, INTERNALORDER, JOBCATEGORY, LABORTYPE, PRODUCT, PROFITCENTER, PROJECT, RPTCURRENCY, SLDTODESTINATION, TIME, VARIANCEDETAIL (Flow), Input Forms and Reports for Budget and Forecast.
• Used Program UJA REFRESH DIM CACHE to refresh Dimension Members and avoid DB errors when saving and processing dimensions.
• Worked on complex logic for PRODUCT Master Data with Sales/Manufacturing Key Codes and Multiple Hierarchies and Levels for PRODUCT - Model Based (Levels - Segment, Brand, ProfitCenter, Model, Door, Engine for Automotive Line of Business with different combinations of Levels for other Lines of Businesses like Motorcycle/ATV, Power Equipment, Parts, Others), Model Year Based, Variance Detail, Sales Link, Lifecycle Link Hierarchies
• Created and maintained Multiple Account Dimensions and associated Properties by Model - ACCOUNT BUDGET, ACCOUNT PS, ACCOUNT CPU, ACCOUNT WF, ACCOUNT IHC, ACCOUNT SBT.
• Worked on Data Manager Packages and Package Links for loading Master Data and Transaction Data into BPC from BW InfoProviders, external files from BW Application Server (AL11), Conversions from legacy systems, for Copying/Clearing data between Events/Time Periods using Standard Packages, for pushing data from one Model to another, and for triggering BAdIs (for performing various calculations such as Allocations, Gross Profit Calculations, YTD Adjustments, Variance Calculations, Income Tax, P&L/Balance Sheet Calculations) by running Logic Script with Advanced Script in Data Manager Packages.
• Created Data Manager Package Advanced Script to perform Light Optimize along with Compression and Zero Elimination of All Requests to optimize BPC Cubes (Models).
• Developed Transformation Files with logic and Conversion files to load Master Data to BPC Dimensions and Transaction Data to Models (Cubes).
• Developed Logic Script for various functionalities like Account-Functional Area Mapping, Pushing data between Models. Performing calculations based on Dimension Properties and User selections, Variance Analysis between Events and Time Periods, and calling BAdIs in Logic Scripts for complex requirements. Debugged Script using Transaction Code UJKT by simulating data intersections.
• Worked on Allocation of Inventory Units planned at higher levels (Segment, Brand or ProfitCenter) of Product Hierarchy down to the Base Level Products (Sales Key Codes for Sales Companies & Factory Key Codes for Manufacturing Companies) based on User Input Sales Mix Percentages, Gross Profit - Revenue and Cost of Sales calculations for Sales and Manufacturing Companies based on Production Units and Transfer Price, Income Tax calculation based on Net Income Before Taxes, and Balancing of Balance Sheet.
• Worked on integration of data from all Models into Budget Model for calculation of Net Income before Taxes, Income Tax and on Input Forms for User Input Adjustments to flow into P&L (Income Statement). Also worked on Balance Sheet and related calculations for Retained Earnings, Other Current Assets and Other Current Liabilities.
• Worked on Interfaces for sending data from BPC to ECC for P&L to CCA/COPA for Allocation/Top-Down Distribution to ProfitCenter and Product, and Balance Sheet to GL for Allocation to ProfitCenter/Segment, and for getting ALLOCATED data back from ECC to BPC.
• Created EPM Input Forms and Reports for Capital WBS Element Planning, Labor, Salary and Benefits Budget, Workforce Adjustments, Travel Rates and Benefit Rates, Standard Work Day Schedule, SG&A Department Budget Input and Adjustments, SG&A Detail by Month, SG&A Variance Analysis by Event, SG&A Pre vs Post Allocation, Royalty Rates, Sales Incentives, Target Setting, Exchange Rates, Sales Quote, Inventory Units Planning, Sales Mix Percentages, Utility Rates, Income Tax, Income Statement Input and Adjustments, Balance Sheet Input and Adjustments, Income Statement Comparison by Month and Segment, Income Statement Pre vs. Post Allocation, Balance Sheet by Month, Balance Sheet with Variance, Balance Sheet Pre vs. Post Allocation.
• Designed and configured Task Profiles, Data Access Profiles, and Teams and assigned Users to Teams.
• Configured Work Status at Environment and Model levels to enable tracking of the Work Status during Planning phases and prevent unwanted data changes (locking) once the Plan is finalized based on the Work Status for various interfaces. Configured Owner, Performer and Reviewer Properties on CostCenter Dimension for Work Status.
• Worked on Transporting BPC Objects from Development to QA, Pre-Production and Production Environments - Collecting Objects in BW (RSA1) Transport Connection, Choosing Environment, Transferring Selections, Choosing BPC Objects to Transport, Collecting Objects in a Transport Request using “Transport Objects”, and Releasing Transports using Transaction Code SE09, Setting the Target Environments Offline, Refreshing and Importing Transports in Target Environments using Transaction Code STMS, Verifying the Transport Logs In Target Systems using Transaction Code SLG1, Troubleshooting failed Transports, Performing quick clean-up in Target Systems before Re-Transporting.
• Documented the functional and technical configuration of Planning and Reporting solutions.
• Worked on System Integration Testing and involved in Business User Acceptance Testing of BPC Input Forms and Reports and resolving issues in backend (BPC Admin / BW) and front-end (EPM Excel Add-In).

SAP BW 7.3 / EPM BPC 10 Lead Consultant

Environment:: SAP BW 7.3, SAP EPM BPC 10.0

Responsibilities:

• Worked on the design, implementation, testing and deployment of BPC financial planning models.
• Designed and configured BPC Environments, Models, Dimensions, Input Forms and Reports.
• Created and modified Applications by adding new Members and updating Dimension properties.
• Designed and developed the BPC Account Based model from the BW Key Figure model for FI Accounting General Ledger.
• Developed BAdI for Master data enhancement using the standard BAdI implementation UJD ROUTINE.
• Created the Input Forms using EPM functions EPMDIMENSIONOVERRIDE, EPMMEMBERID, EPMCONTEXTMEMBER, EPMMODELCUBEID, EPMSAVE, EPMMEMBEROFFSET, etc.
• Created Input Forms for Employee Additional Pay, Salary, Overtime, Benefits and Compensations, FTE, Labor Summary etc.
• Developed Transformation & Conversion files and Data Manager Packages to load BPC Dimensions and Applications.
• Designed and configured Task Profiles, Data Access Profiles, and Teams and assigned Users to them.
• Configured Work Status at Environment and Model levels to enable tracking of the work status during Planning phase and prevent unwanted data changes (locking) once the Plan is finalized based on the Work Status for various interfaces.
• Documented the functional and technical configuration rationale of Planning and Reporting solutions.
• Involved in Business User Acceptance Testing of BPC Reports with users and resolving issues in backend (BW) and front-end.

Sr. SAP BW-BPC Consultant

Environment:: SAP BW 7.3, EPM BPC 10.0

Responsibilities:

• Worked on BW and BPC performance enhancements for Financial Planning Models - Budget, Revenue and HR.
• Refined BW-BPC Staging Architecture to ensure better performance of Actuals data loads from ECC to BW and then to BPC.
• Improved performance of BPC planning models which had more than necessary dimensions by logically splitting into models with fewer dimensions that cater to specific functional area and reporting need.
• Improved the functionality of BPC Input Forms and Reports by utilizing the strengths of EPM 10 Reporting capabilities.
• Worked on the requirements and estimates for DealerTrack Financial (Legal) Consolidation project.

SAP BW-BPC Lead Consultant

Environment:: SAP BI 7.0, SAP BPC NW 7.5, ECC 6.0

Responsibilities:

• Worked on the design, implementation, testing and deployment of financial planning models for PepsiCo Global Business Solutions, primarily on BPC applications for Field Sales Planning and Capital Project Planning.
• Designed and configured BPC Dimensions, Applications, Input Schedules and Reports.
• Created and modified Applications by adding new Members and updating Dimension properties.
• Designed and developed Input Schedules for Business Users to load Field Sales Plan (Annual Operating Plan AOP and Periodic Forecast) by Segment, Sales Team and Planning Channel, and Capital Projects Plan (AOP and Forecast) at WBS Element level and at Program Position level.
• Designed and implemented Actuals data loads for Field Sales and Capital Projects using BW Process Chains and BPC Data Manager Packages.
• Developed Transformation & Conversion files and Data Manager Packages to load BPC Dimensions and Applications.
• Implemented Script logic to perform Conversion of Field Sales data (Amounts) into Cases (Volumes) based on Price data (Price per Case).
• Implemented the Projects roll-up from Field (WBS) to Function (Program Position) level and calculation of total Project Plan after Business Users key in adjustments at Function (Program Position) level.
• Designed and configured Task Profiles, Member Access Profiles, and Teams and assigned Users to them.
• Configured Work Status at AppSet and Application levels to enable tracking of the work status during Planning phase and prevent unwanted data changes (locking) once the Plan is finalized based on the Work Status for various interfaces.
• Documented the functional and technical configuration rationale of the solutions implemented.
• Involved in Unit testing, System testing and User Acceptance testing, Go-live and Post Go-live Production Support of the BPC models, and in end-user training of Business Users.

Sr. SAP BI-BPC Consultant

Environment:: SAP BI 7.0, SAP BPC NW 7.5, ECC 6.0, Hyperion-Essbase

Responsibilities:

• Involved in the full life cycle implementation including requirements gathering, development, testing and go-live of BPC models.
• Implemented the Budgeting and Forecasting applications for Financial Planning team.
• Created Transformation and Conversion files to load the Applications and Dimensions.
• Implemented Script Logic to support the Business requirements of planning models.
• Involved in evaluation of integration options for data transfer from BW/BPC to external system Hyperion-Essbase.
• Developed BPC Data Manager Packages to run Script Logic that calls BAdI to load data from BPC cubes to DSOs.
• Designed the data transfer from BW using Open Hub Destination to database tables to be pulled into Hyperion-Essbase.
• Worked on migrating Budget from planning applications - E&P CAP, E&P LOE, E&P Prod, GA, MM, Proj. Cap, and Actuals from Consolidations applications - LEGAL, Ownership to external systems like SQL Server and Oracle (Essbase).
• Worked on migrating Master data for BPC dimensions - Concatenated Functional Area/Account, Data Source, Entity (Company) to external systems.
• Built OpenHub Destinations to export BPC data from DSOs to 3rd party systems.
• Built BW Process Chains to trigger ETL and run OpenHub Destination to migrate BPC data to 3rd party systems.
• Worked on enhancing BW Extractor 0FI GL 14 to add additional fields required for New GL Actuals from ECC.
• Migrated GL Actuals loaded from ECC to BW into external systems using OpenHub Destination/ETL run with Process Chains.

SAP BI-BPC Consultant

Environment:: SAP NetWeaver BI 7.0, SAP BPC NW 7.0

Responsibilities:

• Worked in Financial Planning and Analysis (FP&A) team on BPC Applications for Cash Flow, Long Term (Bonds) / Short Term (Revolvers) Debt Planning, Cash Balance, Tax Rates Adjustments and Calculations.
• Worked on gathering requirements for FP&A enhancements and updating functional requirements.
• Worked on fit-gap analysis and updated the technical design documents for the enhancements in BPC applications.
• Worked on enhancing the Input Schedules to update the Planning layouts for Interest and Cash Position, Interest Details, Debt Repayment Schedule.
• Worked on BPC Dimensions, Applications, Transformation and Conversion files, Data Manager Packages, Script logic, Task Profiles, Member Access Profiles, Teams and Work Status.
• Documented the functional and technical specifications for the enhancements implemented.
• Developed enhancements in Development system, performed system testing in QA system, prepared test scripts and involved in User Acceptance Test and migration to Production system.

SAP BW-BPC Consultant

Environment:: SAP NetWeaver BI 7.0, SAP BPC NW 7.0, ECC 6.0- PS, IM, FI/CO

Responsibilities:

• Worked on SAP BPC applications for Project Systems areas - A&M (Advertising and Marketing), Capital, and D&A (Discounts and Allowances), and supporting other areas including Sales General and Administration (SG&A), Supply Chain Finance, PBSG (Horizontals), Topline, and BU Finance (Integrated P&L).
• Worked on the following in BPC Development System, tracking the status and updating the resolution details in Peregrine/SM7, Starteam Project Servers, transporting the fixes to QA System, testing and Business approval in QA, and migrating to Production System:
• Script Logic to aggregate SG&A data for Allocated, Direct and Selling Expense and Copy to Integrated AOP.
• Project Systems Period Roll for Period End Close to improve the performance and runtime.
• Capital IM (Program Position level) Planning layout to point to the Copied Project Actuals at IM Level rather than to Actuals at Projects Level directly that was causing a locking issue with Capital Projects Manual Planning layout for accessing the same data sets in the two planning layouts simultaneously.
• A&M/D&A Allocations Planning layouts to include the Account for Royalty Income, Functional area for Cost of Sales and Sales Curve adjustments by including the necessary FS Item levels.
• Script Logic to derive the Previous Forecast Version from Current Forecast Version for IM Forecast Period Roll.
• Creating a new Logical Trade Scenario for IZZE that was moved from PCNA to QTG with the changed Profit Centers in Tax Planning BPC model.
• Script Logic in Supply Chain Finance – Transportation – Inbound Freight model to calculate Total Spend calculation from Average Linehaul, Miles and Max. Quantity.
• Worked on the following to automate BPC functional process in the respective areas.
• Automating the Periodic Actuals load for PBSG Horizontals Projects by creating Data Manager Packages, Process Chains and Control-M jobs scheduled.
• Automating the process to Copy A&M/D&A Allocations Grid Data from Prior Forecast Version by creating the Data Manager Packages, Process Chains and Ad-hoc Control-M jobs executed periodically by the EAM BPC team.
• Automating the determination of Fiscal year/periods for AOP and Forecast based on the Version (AOP or FXX) that the user selects and the Fiscal years for AOP and Forecast.
• Worked on BPC Period End Close for A&M, Capital, and D&A areas, and IM Period Roll for A&M and D&A to maintain the Annual Plan Total.
• Worked on Year End BPC activities including Roll Forward of Multi Year Projects data into the New Approval year and Closing Projects those ended with the Previous Year.

SAP BW-BPC Consultant

Environment:: SAP NetWeaver BI 7.0, SAP BPC NW 7.0, ECC 6.0-PS, IM, FI/CO

Responsibilities:

• Worked on the design, development, testing, go-live and production support of Planning models for Annual Operating Plan (AOP) and Forecast (FCST) processes in Advertising and Marketing (A&M), Capital Expenditure (Capital), and Discounts and Allowances (D&A).
• Designed and configured BPC Dimensions, Applications, Application Sets, Input Schedules and Reports.
• Developed Planning solutions for Projects (PS) and Programs (IM) by Segment, Planning Interfaces at Project WBS Element level by period and at IM Program Position level yearly.
• Worked on the functional design and development of RICEF(W) objects as part of the planning solutions for A&M, Capital, D&A.
• Extensively used Borland CaliberRM to document the functional designs and technical design specifications of RICEF(W) objects.
• Worked on the validation of Projects Systems (PS) Transactional Data (Actuals) loads from ECC into BW (InfoCube 0WBS C11), and Master Data loads for 0PROG POS (Program Position), 0PROG DEF S (Program Definition), 0WBS ELEMT (WBS Element), 0PROJECT (Project Definition) from ECC (Tables IMPR, IMTP, PRPS, PROJ respectively) into BW.
• Worked on the Conversion process for loading Plan data from flat files into Realtime InfoProviders for Projects (PS) and Programs (IM).
• Involved in Functional design and development of BEx Reports for A&M, Capital, D&A – A&M/Capital Forecast by Projects and WBS, A&M Targets by IM Position, A&M Targets vs Project Systems, A&M Forecast by IM Position, Capital AOP Targets vs. Submitted, D&A Targets by IM Position, D&A Targets vs Project Systems, D&A Forecast by Projects and WBS.
• Developed BPC Planning layouts for Project planning (PS) by WBS Elements and Cost Elements, and for Program Planning (IM) by Program positions hierarchy and Cost Element Groups to allow planners to manually enter plan data in web interfaces.
• Extensively used Script Logic in Planning functions for Copying AOP/FCST data from PS level to IM level, adding PS data copied to IM and IM adjustments to calculate Total AOP/FCST at IM level, calculating Better/(Worse) calculations for comparison with AOP/Prior FCST Version/Last Year Actuals.
• Developed Period Roll functionality for IM Forecast using Script Logic to keep the IM Total FCST constant with the previous forecast version by automatically calculating IM adjustments when the IM planner copies FCST from PS level. Developed similar functionality for IM AOP to keep the IM Total AOP constant by automatically calculating IM adjustments when the IM planner copies AOP from PS level.
• Involved in the Assembly Test of Variable User Exit Function Modules – A&M Split Outs of IM Hierarchy based on Person Responsible, A&M Set WBS Hierarchy based on Project, D&A Cost Elements Derivation off of Cost Element Groups, D&A Set WBS Hierarchy based on Project.
• Created and executed Unit Test Scripts and Assembly Test Scripts in Development System, System Tests in Quality Assurance System, User Acceptance Test with Business Users in Pre-Production System for AOP and FCST planning solutions – A&M PS, A&M IM, D&A PS by executing the Web Interfaces in Enterprise Portals and validating data in SAP BW.
• Documented test results in Mercury Quality Center and handled defect/ticket resolution in Mercury Quality Center and Borland StarTeam.
• Involved in Post Go-live Hypercare and Production Support of A&M, D&A, Capital Project Planning solutions.

SAP BI/BPS Consultant

Environment:: SAP BI 7.0 (NW 2004s), SEM BW-BPS 6.0, ECC 6.0 / HCM, BEx Analyzer/Report Designer, WAD (Web Application Designer), ABAP Development Workbench

Responsibilities:

• Involved in the blueprinting, design and development of data models for P&L planning/forecasting.
• Involved in design and configuration of BPS planning models including planning areas, planning levels, aggregation levels, filters, Fox functions. Also involved in development of planning layouts for entry of plan data.
• Involved in development of InfoCubes for Plan and Actual data.
• Developed Logistics, Financial and HR, HCM reports – Days Sales Outstanding (DSO), Customers payment History, Consignment stock, Fulfillment rate, Open orders, Travel Management, E-Recruiting, Planned Time and Labor.
• Developed Portfolio and Corplan reports for Phase Analysis, Funding Allocations, Resource Analysis and Collections
• Developed InfoSpokes to deliver data to external systems in the form of flat files. Also developed transformations for OpenHub interface.
• Extracted data from databases using DB Connect, UD Connect, and also from XML files via Administrator Workbench in SAP BW using ‘Create BW DataSource with SOAP Connection’.
• Extensively worked with new BI features such as Write optimized DSOs, Transformations, Data Transfer Process (DTP), Start Routines, End Routines, BEx Broadcaster, Report Designer, Web Application Designer (WAD), Portals, Visual Composer, and also migrated BW 3.X Data Flow to BI 7.0 Data Flow.
• Scheduled BEx Broadcaster using predefined time points created in BI, and also reports using Pre Calculated Value sets, Email (Bursting), Publishing to Portal, broadcasting in multiple formats through different channels for performance optimization.
• Used BEx Report Designer to create highly formatted reports including inserting images, hierarchies, static and dynamic sections.
• Migrated BW 3.X Transfer Rules and Update Rules to SAP NW 2004s BI Transformation, and also coded Start Routine and End Routine of Transformation to load data into InfoProviders via Data Transfer Process (DTP).
• Worked on BI security issues like Analysis Authorizations and also involved in creating roles and maintaining authorizations for workbooks and reports to specific roles and users.
• Involved in extracting data from InfoCubes to external systems using Open hub destination
• Created MultiProviders combining data from logically related InfoProviders to enhance reporting flexibility.
• Extensively created BEx Queries with Filters, Free Characteristics, Calculated and Restricted Key Figures, Variables, Conditions and also generated Reports with Exceptions.

SAP BW-BPS Consultant

Environment:: SAP BI 7.0, BW 3.5, SEM 3.0, SAP R/3 4.7, BEx Analyzer/Browser, Web Application Designer (WAD), ABAP Development Workbench

Responsibilities:

• Involved in a full life cycle implementation including requirements gathering, analysis, design and development of BW/BI data models for LO – SD & MM, HR and FI/CO – G/L, AP, AR modules as well as for BW SEM-BPS.
• Developed a planning system to forecast material consumption and inventory turnover, including master data synchronization, plan/actual comparisons and rolling forecasts.
• Involved in SEM-BPS configuration of planning areas, planning levels, aggregation levels, planning packages, filters, characteristic relationships, Fox functions etc. Also involved in design and development of Transactional and Basic InfoCubes for Plan and Actual data respectively. Designed and developed BPS layouts for manual entry of plan data.
• Involved in extraction of data from Logistics applications included initialization of setup tables and maintaining the update mode for scheduling initial and delta loads.
• Involved in data extraction from Financial and HR Extractors and development of financial reports for P&L statements, Balance Sheets, Accounts Payable (AP), and Accounts Receivable (AR), and also HR reports for Employees’ Payroll, Time Management, Education and training, Compensation Management, Recruitment, etc.
• Coordinated development with a team of off-shore developers based in Germany.
• Designed and developed base level ODS Objects layer for LO and FI extractors to update further to higher level ODS Objects and then to InfoCubes.
• Extensively used BEx Analyzer and Web Application Designer (WAD) to generate reports specific for various business requirements like Top 10 customers, Sales and Order Values etc.
• Extensively used Open Hub Service – InfoSpokes to distribute data to external systems in flat files. Also developed InfoSpokes with Transformation using BAdIs (Business Add-Ins) to perform master data look-ups and other calculations.
• Developed MultiProviders and created queries on them to enhance reporting flexibility and performance.
• Involved in evaluation and upgrade from BW 3.5 to BI 7.0 including migration of the existing objects and also implementing the new features of data staging like Transformation and Data Transfer Process (DTP). Also used Open Hub Destination with Transformation and DTP to distribute data from BI to external systems.
• Worked extensively on new BI features like Write optimized DSOs, Transformation, Start Routine, End Routine.
• Involved in creating indexes, DB statistics, aggregates, and compressing cubes.
• Involved in post production support including monitoring process chains and troubleshooting data loads.

SAP BW Developer

Environment:: SAP BW 3.0B, SAP R/3 4.6C, Business Explorer (BEx) Analyzer/Browser, ABAP Development Workbench

Responsibilities:

• Gathered requirements from users and developed BW data model using extended star schema concept.
• Involved in preparing Functional Design Specifications based on the business requirements.
• Worked on extraction of data from legacy systems, flat files, and also SAP R/3 using Business Content Extractors (LO Cockpit), CO-PA, and Generic Extractors.
• Used data staging via Persistent Staging Area (PSA) to update InfoProviders with Master Data and Transactional Data from SAP R/3.
• Used ODS Objects as intermediate storage for data extracted from external systems to further update from ODS Objects into InfoCubes using update rules.
• Used Formula Builder and Routines to create Transfer rules and Update rules for loading data into ODS Objects and InfoCubes.
• Created InfoSet queries involving ODS Objects and Master Data InfoObjects, and MultiProvider queries involving ODS Objects and InfoCubes to improve reporting flexibility.
• Created Aggregates and Indices on InfoCubes to improve reporting performance.
• Involved in BW security, created Roles and Authorizations for InfoCubes and other Metadata objects.
• Assigned Workbooks and reports to specific roles and users in BEx Browser.
• Designed BEx Queries with Filters, Free Characteristics, Calculated and Restricted Key Figures, Variables, Conditions and also generated Reports with Exceptions.
• Created process chains to automate data load processes and monitored the scheduled process chains.