We provide IT Staff Augmentation Services!

Sr. Sap Bpc Consultant Resume

0/5 (Submit Your Rating)

NJ

SUMMARY

  • Ten years’ experience in SAP BPC Net Weaver and Microsoft versions in Planning and Consolidation and 7 months experience in SAP BFC and SAP ICS.
  • One year experience in EPM 10 for Schedules and Reports design.
  • Completed a 90 hour Certificate program in IFRS Standards from KPMG.
  • Involved in gathering the requirements and analyzed the process to be modeled for the same.
  • Demonstrated ability to work as part of a team to analyze complex business requirements and translate them into Business Intelligence solutions
  • Good experience in designing, implementing and testing the BPC system for various Business Scenarios.
  • Good understanding of overall dataflow from ECC to SAP BPC system.
  • Ability to propose solutions for various Business Scenarios using the SAP BPC Toolkit/components.
  • Exposure to installation, configuration of SAP BPC in Windows environment.
  • Have setup Consolidation, Ownership (Dynamic Hierarchy Editor) and Rate Applications and the corresponding settings in App set and Application Parameters.
  • Have setup Balance Carry Forward, Account Transformations, Intercompany Eliminations business rules and Adjustment Header and Details rules for Consolidation of Investments.
  • Good experience in creation of Application Sets, Applications, Dimensions, Dimension Properties, updating Dimensions, defining multiple hierarchies and maintain Dimension Member formulas.
  • Good experience in creating Transformation files, Conversion files and packages for Master Data and Transaction Data Load in multiple business scenarios
  • Ability to propose the right source of logic among Worksheet Logic, Script Logic, Allocation Logic, Dimension Member formula and BADI’s (knowledge of various constructs used in BADI).
  • In BPC for Excel, created both Static and dynamic reports and Input Schedules. Extensively worked with EVDRE and EV functions like EVCVW, EVPRO, EVMBR, EVTIM, EVGTS, and EVSND.
  • Expertise in designing complex Reports and Input Schedules using SAP BPC EVDRE and other Reporting features (Expansion, Filtering and Suppression) as well as native Excel functions.
  • Expertise in SAP BPC BPF’s (Business Process Flows) including creating and modifying BPF Templates, maintaining and resetting BPF instances and configuring BPC for Web to execute BPF’s
  • Good experience in defining Security to define multiple SAP BPC components, and Work Status features for using the SAP BPC system based on the business needs.
  • SAP BPC TRAINING ON DATA MANAGEMENT, SAP BI/BW TRAINING ON BASIC BI, Conducted internal trainings to Junior Associates in BPC.
  • Knowledge of various UJ related T - codes like UJKT, UJFS, UJ VALIDATION, Master Data Validations, Audits, Concurrency Locking, Transports and BPC Process Chains.

TECHNICAL SKILLS

Technology: Basics of Databases (Oracle 9i & MS SQL SERVER 2005) .NET, Java, HTML

SAP: BPC 10 NW/ 7.5 NW/ 7.0 NW/ 5.1 MS, SAP BFC 7.5, SAP Intercompany Server(ICS), SAP Financial Information Management(FIM), SAP BI/BW 3.5/7.0, SAP ECC 6.0, SAP BO (Crystal, DESKI)

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. SAP BPC CONSULTANT

Responsibilities:

  • Have been involved in Consolidation Month-End close preparation activities to support the business.
  • Have updated/added Master data in critical dimensions (Entity, Groups and Interco) after seeking approvals from Master Data Council.
  • Also, updated the Transaction data on monthly basis in Ownership and Rate applications.
  • Have resolved many installation, security and work status issues with very little/minimal impact.
  • Have supported business in loading Actual, Budget and Forecast data and resolved issues during this process.
  • Modified/added Transformation and Conversion files, Input Schedules to facilitate error-free loading of Transaction data.
  • Recreated/modified various Consolidation reports in line with the External Reporting.
  • Have scheduled and resolved many discrepancies during the execution of Data Manager Packages.

Environment: SAP BPC, Java, J2EE, Oracle, Master data, Transaction data, Data Manager Packages.

Confidential

BPC Support

Responsibilities:

  • Have developed 15 medium to complex reports and input schedules in EPM/BPC 10 without assistance.
  • Have redesigned the reports or input schedules in EPM 10 which were earlier built in BPC 7.5 and hence gained the ability to migrate from BPC 7.5 to 10.
  • Have comprehensively understood, without any assistance, the existing business logic in reports/schedules in 7.5 and have redesigned them in EPM 10 in a very short span.
  • Have written complex script logic.
  • Fully understood the new BPC 10 and EPM 10 interface for performing various tasks like Master Data management, Transaction Data load, Data Manager Package’s execution, Script Logic and Complex Report/Input Schedule development.

Environment: EPM/BPC, Java, J2EE, Oracle, Master Data Management, Transaction Data load, Data Manager Packages, Script Logic, Complex Report.

Confidential

BPC Support

Responsibilities:

  • Have understood the system in the dataflow terms from BW to BPC Reporting.
  • Have understood the Planning process and budgeting cycle without the KT support from onshore.
  • Have resolved master data issues by reconciling with BW.
  • Have loaded work status data into Entity dimension.
  • Have understood the business logic in Financial Planning and the respective calculations and checked them for proper data output.

Environment: SAP, BW BPC data flow Reporting, Java, J2EE, Oracle, Master data, Entity dimension.

Confidential

BFC Support

Responsibilities:

  • Setup Reporting ID, Reporting Units, and Consolidation and Intercompany reconciliation definitions.
  • Have loaded master data into dimensions, setup category builder and configured various options in the same.
  • Have setup Rates and loaded the master data into the same.
  • In ICS, have setup periods, initialized and closed them after the completion of month-end activities.
  • In ICS, loaded FX master data.
  • In ICS, imported transaction data and later exported the final ICS data to BFC.
  • Have defined controls, formulae and dimensional analysis in the Category Builder.
  • Have regenerated the packages and reported and resolved any reporting units failing to regenerate.
  • Have published and integrated 4000 packages in multiple server sessions so as to minimize the time for execution. Reported and resolved the errors in the process.
  • Have setup hourly run of various consolidations and intercompany reconciliations by creating task definitions and task groups.
  • Have run manual consolidations and intercompany reconciliations on demand.
  • Have analyzed the necessity for performing various tasks as part of operational activities. Uploaded the statistics of various tasks onto share point portal.
  • To be efficient and effectively streamline, have proposed the order of task executions as well as helped the business in understanding the tool-business mapping.

Environment: ICS, BFC, FX master data, manual consolidations, Oracle, Java, J2EE

Confidential

BPC DEVELOPER

Responsibilities:

  • Defined new Properties including Parent Hierarchies for the existing Dimensions and maintained the data in those Properties manually using VLOOKUP function.
  • Loaded Master Data including Properties, manually as well as through Data Manager Packages using Transformation and Conversion files.
  • Loaded Transaction Data into Sales Billing Application through Data Manager Package by using MVAL keyword for joining various Key Figures in BW to single account in BPC.
  • Also, loaded Transaction Data into Sales Billing Application through Data Manager Package using various combinations of Dimension values.
  • Designed complex BPC Excel based EVDRE Input Schedules and Reports for the Sales Billing module, HR Planning, Production Planning using multiple EVDRE’s, EVDRE Options, EVDRE Formatting, BPC Excel Macros, EVCVW, EVPRO, EVMBR, EVTIM, EVGTS, and EVSND.
  • Designed an Input Schedule-cum-Report by using the Get Only Range option of EVDRE.
  • Defined complex Member Sets dynamically (in Expansion Range) using BPC Excel and native Excel based functions. Also, defined member sets using Formatted Member Sets.
  • Designed a Monthly Variance report based on the ACTUAL vs. PLAN data for a particular year.
  • Used Excel based features to include in Reporting.
  • Executed, validated the Script Logic execution manually by checking data in BI/BW system.
  • Created BPC Excel based EVDRE reports for Unit Testing of various Script Logic files.
  • Created the End User Training Document for HR Planning, R&D Planning based on BPC BPF’s.

Environment: VLOOKUP function, Master Data, Data Manager Packages, Transaction Data, BW, and BPC Excel based EVDRE, Macros.

Confidential

SAP BPC DEVELOPER

Responsibilities:

  • Created Technical Design document with appropriate details including the flow and master data.
  • Created Application Set, Applications, Dimensions, Dimension members and Dimension Properties.
  • Loaded Master Data including Properties, manually as well as through Data Manager Packages using Transformation and Conversion files.
  • Loaded Transaction Data into various Applications through Data Manager Package by using MVAL keyword for joining various Key Figures in BW to single account in BPC.
  • Configured the Currency Translation logic, maintained Rate Application, Input Currency and Account dimensions.
  • Provided leadership within the SAP BPC project development team and participate in Project and Programmer meetings.
  • Administered the SAP BPC by creating user logins with appropriate roles and monitored the user accounts, creation of groups.
  • Created various Work Statuses within the scope of planning execution.
  • Have written Script Logic using various constructs like Planning Allocation and also written custom code for Currency Translation and movement of Transaction data between Applications in the same Application Set.
  • Designed complex BPC Excel based EVDRE Input Schedules and Reports for various Applications using multiple EVDRE’s, EVDRE Options, EVDRE Formatting, Drill Down, BPC Excel Macros, EVCVW, EVPRO, EVMBR, EVTIM, EVGTS, EVSND etc,.
  • Also, locked down the Dimension member values in the Page Key Range, set the password and saved them as Dynamic Templates in the required folder.
  • Designed an Input Schedule-cum-Report by using the Get Only Range option of EVDRE.
  • Defined complex Member Sets dynamically (in Expansion Range) using BPC Excel and native Excel based functions. Also, defined member sets using Formatted Member Sets.
  • Designed a Monthly Variance report based on the ACTUAL vs. PLAN data for a particular year as well as based on the Currency Data of SALES vs. FINANCE.
  • Used Excel based features to include in Reporting.
  • Executed, validated the Script Logic execution manually by checking data in BI/BW system.
  • Created BPC Excel based EVDRE reports for Unit Testing of various Script Logic files.
  • Provided technical support to internal developers and external clients.
  • Created and maintained BPF Templates for various Applications based on the business requirements.
  • Created the BPF Instances and prepared the End User Training documents.
  • Created BPC Excel based EVDRE reports for Unit Testing of various Script Logic files.

Environment: MVAL keyword, BI/BW system, SAP BPC Excel based EVDRE reports, Unit Testing, BPF Templates, Script Logic files, FINANCE.

Confidential

SAP BPC CONSULTANT

Responsibilities:

  • Worked closely with both type of users (business & technical) to find out the best solution for their problems. And also made recommendations about designing, developing, testing & implementing Report, Input Schedules, Logic, Security, Data Packages, Applications, Dimensions & other components.
  • Loaded Master Data including Properties, manually as well as through Data Manager Packages (from BI/BW and Flat Files) using Transformation and Conversion files.
  • Loaded Transaction Data into various Applications through Data Manager Packages (from BI/BW and Flat Files).
  • Have written Script Logic for Allocation and passed dynamic parameters from Data Manager.
  • Have setup the business rules for Balance Carry Forward and Account Transformations.
  • Customizing the Reports, Input Schedules, Logic to meet the specific needs of the client using supported functions within BPC Excel. Used Excel based features to include in Reporting.
  • Made recommendations about complex financial reporting requirements and interface BPC and BI applications to design end-to-end reporting solutions for optimal performance.
  • Troubleshooting all aspects of the product from Reports, Input Schedules, Logic, Security, Data Packages, BPF (Business Process Flows), Applications, and Dimensions.
  • Hosted training sessions and mentored End Users.
  • Written best practice document within the project scope, updated KB (knowledgebase) and worked with escalated Customer incidents.
  • Hosting remote sessions with customer on daily basis to understand & solve incidents.
  • Responsible for all aspects of customer support including escalation and customer management, and bridging the gap between development and the customer.
  • Always up to date with the new releases of BPC to take advantage of new/revised enhancements.

Environment: BI/BW, Flat Files, Transaction Data, Data Manager Packages, Script Logic, BPC Excel, BPF

Confidential

BPC DEVELOPER

Responsibilities:

  • Gather the business requirement and design the planning, forecast, budgeting requirements.
  • Proactively explored and understood BPC Design, Architecture, Logic and Reporting features
  • Have techno-functional expertise in BPC, including functional requirements analysis, blueprinting and translating functional into technical requirements.
  • Had experience in the area of SAP BPC Application Design, Development, Administration and Maintenance.
  • Maintained Master Data in various Dimensions and loaded Transaction Data into Applications.
  • Loaded Transaction Data into Applications using Data Manager Tools.
  • Have written Script Logic based on requirements and also written Allocation Logic.
  • Have set the Security features to the various users involved in the BPC system.
  • Developed Input Schedules, Reports using various EV functions and custom interfaces, menus.
  • Have incorporated Advanced Formatting features of the Reporting component.
  • Assisted End Users with test scripts for User Acceptance Testing.
  • Managed and participated in User Acceptance Testing for multiple releases.
  • Assisted with development and delivery of End User training.
  • Provided basic Outlook soft training to team members and Subject Matter Expertise to other project teams.

Environment: SAP BPC Application Design, Master Data, Data Manager Tools, BPC system, User Acceptance Testing, EV functions.

We'd love your feedback!