EXPERIENCE SUMMARY

• 8+ years of Experience in SAP BW/BPC in developing functional and Technical modules like Financial Planning, Reporting and consolidation.
• Involved in System Maintenance, Implementation and production support.
• Migrated SAP BPC from 7.0 to 7.5 to 10.0 to BPC on HANA and to cloud on NW Versions
• Proficient in creation of Environment, Models, Dimensions, Dimension Members. Loading Master data and Transaction Data into BPC Applications using Flat File or from BI Cubes.
• Worked on Transformation files, Conversion files, and Data uploading through Data Manager Packages.
• Worked extensively on Logic Scripts for Multi Currency Translations, Allocation and Business Calculations.
• Created Users, Data Access Profiles, Task Profiles and Teams in Security
• Creating customized Input Schedules EVDRE Grid Reports with EvDRE formulas and Custom Templates, Drill down, Drill through and adding Macros.
• Created EPM Reports and Input forms in admin,client interface and adhoc reports.
• Automating month end process using Business process flows to facilitate users to close teh month end reporting.
• Developed BADI’s for logic calculations and between Intra - App Applications data transfer.
• Developed Process Chains for retraction of data from BPC to BI using APD.
• Gather teh business requirement and design teh planning, forecast, budgeting requirements.
• Created Vale types in BW(Categories in BPC) for data loading on MTD,QTC and YTD data loading.
• Legal Consolidation reports: Income Statement Report, Balance Sheet report, Audit Report and Intercom any matching & elimination, Cash Flow report, Consolidated Summary of Operations and Consolidated Balance sheet by Company code etc.
• Transport activities between teh Environments( DEV,QA and Production)
• Supported on all system, server and Configuration Related issues.
• Worked on extractions from heterogeneous Source System including SAP and non-SAP, Developing SAP BW Objects, applying Extended Star Schema modelling principals in Data Design, and used expert knowledge of data warehousing concepts.
• Worked on BWA index activities on info cubes and multi providers for Query Performance
• Extensively worked on query development and formatting techniques in both BEx and Web Application Designer (WAD) of key BW reports and created Web Templates.

TECHNICAL SKILLS

Environments: SAP BI 7.0,7.3,SAP BPC 7.0,7.5,10.0,BEx 3.5 Netweaver Versions.

Programming Languages: HTML, SQL and MDX

Database: Oracle,SQL Server,(OLTP & OLAP),HANA.

BPC: Environment, Dimensions, Security, Excel Reports, Dynamic Templates, Input Schedules, data manager packages, Work Status, Transformation and Conversion files, BPC Functions, Custom menus, BPF’s, EVDRE and EPM Reports and input forms

Operating Systems: Windows Server 2003,2008.Unix&Linux.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SAP BW/BPC Consultant

Environment: SAP BW 7.3,BPC 10.0 on HANA NW Version

Responsibilities:

• Worked on development of Environment,Models and Dimensions including maintenance of dimension members and dimension properties.
• Loaded master data to dimensions through master data automation and Transaction data to models through BW infocube,flat file and from other non-SAP source systems.
• Created Transformation and Conversion files for data loads
• Developed Logic Scripts and BADI’s for Business calculations
• Created process chains and Data Manager packages and automated teh data load.
• Transported BPC object through interfaces(Dev,Quality,Production) through Transport connection in BW and maintained in sync.
• Created EPM Reports like P&L statements,cashflow,Balance sheet and inputforms
• Created users and assigned to teh users to Teams,Task profiles,Data access profiles.
• Extracted data from Source system(SAP ECC) using process chains and Data manager packages.
• Created Consolidation reports: Income Statement Report, Balance Sheet report, Audit Report and Intercom any matching & elimination, Cash Flow report, Consolidated Summary of Operations and Consolidated Balance sheet by Company code etc.
• Created Web Reports, Adhoc Reports and reconciliation between BPC and BW to check teh data load.
• Worked on Intercompany reconciliation and made enhancements to financial statement.
• Performed reporting in Day-End Closing, Month-End closing Quarter-End Closing and Year-End Closing.

Confidential, Lexington, KY

SAP BW/BPC Consultant(Tech Lead)

Environment: SAP BW 7.3,BPC 10.0 on HANA NW Version

Responsibilities:

• Created EPM reports and Input forms.
• Created Backup and restore, optimization techniques as a part of weekly maintenance activity.
• Transported objects between systems and keeping them in sink
• Migrated 7.5 to 10.0 to BPC on HANA versions.
• Data Modelling between BW and BPC System.
• Created Process chains,APD Routine, info cubes,MultiProviders,DSO,DTP,Transformations and BW Queries.
• Extracted data from Source system(ECC) or from NON SAP system to BPC.
• Created Transformation and Conversion files to import data into BPC from source system.
• Created Vale types in BW(Categories in BPC) for data loading on MTD,QTC and YTD data loading.
• Created Reconciliation reports for data push from BPC to BI and from BI to BPC between Infocube,Bex report and from EPM Reports.
• Designed script logic and worked on business rule for Currency Conversions.
• Scheduling teh BPC jobs and monitoring those from BW and BPC end to complete successfully.
• Created custom specific dynamic and static reports, schedulers and live reports and inputforms.
• Involved in Client interactions and processed teh needs as per teh Business Requirement.

Confidential, NJ

SAP BW/BPC Consultant

Environment: SAP BW 7.3,BPC 7.5,10.0 NW Version

Roles and Responsibilities:

• Worked on development of Application Sets, Applications and Dimensions including maintenance of dimension members and dimension properties.
• Designed Sales application and, Capex applications.
• Worked on Conversion and Transformation files and Data manager for loading data into BPC.
• Created various Reporting (Finance, Sales) & Non-Reporting Applications (Rate) for planning purposes.
• Migrated 7.5 to 10.0 NW version
• Legal Consolidation reports: Income Statement Report, Balance Sheet report, Audit Report and Intercom any matching & elimination, Cash Flow report, Consolidated Summary of Operations and Consolidated Balance sheet by Company code etc.
• Worked extensively with Script logics especially around allocation.
• Worked extensively on EVDRE functions.
• Granted access to specific applications using security setup.
• Customizing business rules and automates teh consolidation of investment process.
• Working knowledge on Transports to move data from Development environment to Production environment.
• Worked extensively with Script logics especially around allocation.
• Worked on work status,secuity,and Datamanager Packages.
• Migrated BPC 7.0 to 7.5 Version and teh transports related to migration between teh systems.

Confidential

SAP BW/BPC Consultant

Environment: SAP BW 7.3,BPC 7.5 NW Version

Responsibilities:

• Application management such as creation, maintenance, addition of members.
• User Security such as team, task, member access profile creation, maintenance. Also restricting user access by activity, for reports only and specific to region.
• Script Logic to arrive at net profit and other calculations.
• Data management and loading of transaction data to BPC using teh data transformation, conversion logic, Master Data loaded to a BPC Dimensions. Validation of data loaded.
• Work status management to monitor teh job completion.
• Implementation of Business Process Flows, Custom Menus
• Exchange rate maintenance in rate application, Creation of input template for sales planning data, material planning, and stock holding inputs etc.
• Customizing business rules and automates teh consolidation of investment process.
• Consolidated Summary of Operations and Consolidated Balance
• Creation of journal template and journal entries.

Confidential

SAP BW/BPC Consultant

Environment: SAP BW 7.3,BPC 7.0 NW Version

Roles and Responsibilities:

• Created Applications,Dimensions.Members and Dimension properties
• Involved in reviewing and redefining teh existing budget process, validating and mapping new data requirements to support teh budget process.
• Created users,Teams,Task profiles and Member access profiles in Security
• Worked extensively on EVDRE functions in creations of Reports and Input Schedules.
• Granted access to specific applications using security setup and understood BPC audit.
• Developed Process Chains for retraction of data from BPC to BI using APD.
• Developed Script Logics for allocations, Currency conversions and for Business Calculations.
• Developed intercompany Eliminations, matching and Balance carry forward rules.
• Created Conversations and Transformations for Data Loads.
• Created Backup and Restore of complete application set.
• Worked on Troubleshoot and on performance issues.
• Created Adhoc reports to check teh Reconciliation between BW and BPC for Data load.
• Created Queries(BEx) on BW/BPC Cubes to check teh data load for MTD,QTD and YTD.
• Gather teh business requirement and design teh planning, forecast, budgeting requirements
• Has good knowledge in work status and optimization techineques.
• Support for all change requests / data issue / system issue.

Confidential

SAP BW Consultant

Environment: SAP BI/BW 7.0/BEx 3.5 NW Version

Roles and Responsibilities:

• Extensively involved in Production Support by loading Daily loads/Weekly loads into teh BW system from different source systems.
• Created info Cubes,DSO,Transformations and DTP for Data Loading through Process chain from Source System.
• Involved in BWA index activities on Data loading and Query performance.
• Setup teh Statistical Setup for teh LO-Cockpit and used teh V3 Update for Delta Management.
• Created and worked on daily basis with LO-Cockpit, Generic DataSource, InfoSource, Transfer Rules, Update Rules & InfoPackage.
• Designed Info Sources, activated Pre/Post transformation rules, scripted extraction routines for master data, texts and hierarchies.
• Setup procedure for extracting R/3 data for Customers, Sales Order, Delivery in Sales and Distribution (SD) using LO-Cockpit.
• Generated teh DataSource from SAP R/3 using LO-Cockpit.
• Installed Business Content InfoCubes, InfoSources from BW Side.
• Activated DataSources in SAP R/3 using T-code RSA5.
• Maintained InfoCube, Update Rules and Creation of InfoPackage and scheduling teh data into teh Data Targets.
• Involved in Info Cube maintenance i.e. Compression, Aggregates, Roll-up.
• Handled teh tickets of priority 1,2 and 3.
• Maintain list of all teh activities for all teh tickets until it is closed down.
• Actively and regularly involved in Load Monitoring of Daily, weekly and Monthly, Data Loads using Process Chains.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Maintaining teh queue - related to teh system generated tickets and customer generated tickets.