We provide IT Staff Augmentation Services!

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.