SUMMARY

• Ten years’ experience in SAP BPC Net Weaver and Microsoft versions in Planning and Consolidation.
• Completed a 90 hour Certificate program in IFRS Standards from Confidential .
• Involved in gathering teh requirements and analyzed teh process to be modeled for teh 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 teh BPC system for various Business Scenarios.
• Good understanding of overall dataflow from ECC to SAP BPC system and knowledge on SAP ECC Tables for FI/CO, SD and MM.
• Ability to propose solutions for various Business Scenarios using teh SAP BPC Toolkit/components.
• Exposure to installation, configuration of SAP BPC in Windows environment.
• Has setup various Planning, Consolidation, Ownership and Rate Models and teh corresponding settings in Global Parameters in SPRO.
• Has setup Currency/FX Translation, BCF, Account Transformations, Intercompany Eliminations business rules and Adjustment Header and Details rules for Consolidation of Investments.
• Extensive experience in creation of Environments, Models, 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. Experience in DM Script
• Ability to propose teh 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 EPM AddIn, created both Static and dynamic Reports and Input Schedules. Created Multi - Report sheets, Multi-Schedule Report and Multi-Report sheets from different Models.
• Expertise in designing complex Reports and Input Schedules using EPM Functions and other Reporting features (Local Members, Formatting, Comments) 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.
• Good experience in defining Security to define multiple SAP BPC components, and Work Status features for using teh SAP BPC system based on teh business needs.
• Knowledge of BADI Implementation (Start and End Routines, Custom BADI’s, Retraction), Drill Through (BEX Query, ECC) and Drill-down Reporting, BPC Process chains.
• 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, EPM 10, SAP BI/BW 3.5/7.0, SAP ECC 6.0 (FI/CO, SD, MM)

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. SAP BPC CONSULTANT

Responsibilities:

• Gathered client requirements and created Environment, Models, Dimensions, DM Packages, Reports & Schedules. Has setup Work Status and Security components.
• Handled script logic and MDX as part of teh solution implementation.
• Has been involved in Consolidation Month-End close preparation activities to support teh business.
• Has updated/added Master data in critical dimensions (Entity, Groups and Interco) after seeking approvals from Master Data Council. Also, updated teh Transaction data on monthly basis in Ownership and Rate applications.
• Has resolved many installation, security and work status issues with very little/minimal impact.
• Has supported business in loading Actual, Budget and Forecast data and resolved issues during dis 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 teh External Reporting.
• Has scheduled and resolved many discrepancies during teh execution of Data Manager Packages.

Environment: SAP BPC 10 NW, EPM 10, BW 7.3, ECC 6.0, Oracle, Master and Transaction data, DM Packages, Script Logic, ABAP, Complex Reports

Confidential, New York City

Sr. SAP BPC CONSULTANT

Responsibilities:

• Has developed 15 medium to complex Multi-reports sheet and input schedules in EPM/BPC 10
• Has redesigned teh reports or input schedules in EPM 10 which were earlier built in BPC 7.5 and hence gained teh ability to migrate from BPC 7.5 to 10.
• Has comprehensively understood teh existing business logic in reports/schedules in 7.5 and has redesigned them in EPM 10 in a very short span.
• Has written complex script logic.
• Fully understood teh 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: SAP BPC 10 NW, EPM 10, BW 7.3, ECC 6.0, Oracle, Master and Transaction data, DM Packages, Script Logic, ABAP, Complex Reports

Confidential

Sr. SAP BPC CONSULTANT

Responsibilities:

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

Environment: SAP BPC 10 NW, EPM 10, BW 7.3, ECC 6.0, Oracle, Master and Transaction data, DM Packages, Script Logic, ABAP, Complex Reports

Confidential

Sr. SAP BPC CONSULTANT

Responsibilities:

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

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

Confidential

Sr. SAP BPC CONSULTANT

Responsibilities:

• Defined new Properties including Parent Hierarchies for teh existing Dimensions and maintained teh 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 teh 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 teh 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 teh ACTUAL vs. PLAN data for a particular year.
• Used Excel based features to include in Reporting.
• Executed, validated teh 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 teh 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 teh 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 teh Currency Translation logic, maintained Rate Application, Input Currency and Account dimensions.
• Provided leadership within teh SAP BPC project development team and participate in Project and Programmer meetings.
• Administered teh SAP BPC by creating user logins with appropriate roles and monitored teh user accounts, creation of groups.
• Created various Work Statuses within teh scope of planning execution.
• Has 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 teh 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 teh Dimension member values in teh Page Key Range, set teh password and saved them as Dynamic Templates in teh required folder.
• Designed an Input Schedule-cum-Report by using teh 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 teh ACTUAL vs. PLAN data for a particular year as well as based on teh Currency Data of SALES vs. FINANCE.
• Used Excel based features to include in Reporting.
• Executed, validated teh 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 teh business requirements.
• Created teh BPF Instances and prepared teh 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 teh 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).
• Has written Script Logic for Allocation and passed dynamic parameters from Data Manager.
• Has setup teh business rules for Balance Carry Forward and Account Transformations.
• Customizing teh Reports, Input Schedules, Logic to meet teh specific needs of teh 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 teh 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 teh 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 teh gap between development and teh customer.
• Always up to date with teh 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 teh business requirement and design teh planning, forecast, budgeting requirements.
• Proactively explored and understood BPC Design, Architecture, Logic and Reporting features
• Has techno-functional expertise in BPC, including functional requirements analysis, blueprinting and translating functional into technical requirements.
• Had experience in teh 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.
• Has written Script Logic based on requirements and also written Allocation Logic.
• Has set teh Security features to teh various users involved in teh BPC system.
• Developed Input Schedules, Reports using various EV functions and custom interfaces, menus. Has incorporated Advanced Formatting features of teh 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.