Sap Bw/bpc Consultant Resume
Chicago, IL
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.