Prasang Sachdev

Energetic SAP BPC Consultant with strong skills who thrives in a fast-paced, dynamic environment with good experience in SAP BPC Tool. Ambitious Financial Analyst well-versed in balancing priorities and meeting deadlines under pressure. Expertise in risk management, corporate finance and performance optimization. Detail-oriented professional with 6 years of hands-on experience in statistical and quantitative analysis and forecasting. Proficient in SAP BPC Module paired with strong analytical skills to promote organizational success.

Administration

• Extensive hands-on experience configuring BPC objects of Models, Dimensions, Reports, Input Forms, Data Manager Packages, Dimension Formula, Security Profiles, Work Status, etc.
• Preparing the detailed system-designing document.
• Setting up the application/Model parameters and work status.
• Setting up the Planning, Legal, Ownership and Rate application Model.
• Experienced in Designing and configuring the BPC solution structure i.e. model, dimensions, and dimension member properties based on the requirement gathering.

Reporting

• Experience with Financial Planning & Annual Business Planning that includes planning, budgeting & forecasting.
• Reports and Input Form for checking the data submission, BS, P&L and Cash Flow statements using EPM Add- in and AFO Add-in
• Input schedules for entering the Plan and Actual Data.
• Generation of various analysis and Rolling Forecasting reports with drill down capabilities, pick and choose options.
• Reports for Variance Analysis for MTD, QTD & YTD
• Reports and Input Form based on Property and using EPM Function like EPMRetriveData, EPMDimensionOverride, Axisoverride, ContextMember, DimensionList, MemberOffset, SaveComment, DimensionPropertyValue and AO Function like SAPGetDimensionDynamicFilter, SAPGetDimensionEffectiveFilter and more.
• Input Form and Report using Dynamic Filter and Formatting, VBA and excel functionality.
• Experienced in creating waterfall analysis as per business structure.
• Setting up Work Status functionality.

Consolidation

• Experienced in using Analyzer, Bex Query, report designer. Setting up the Model for Consolidation.
• Setting up the currency translation rules for standard and historical rates.
• Setting elimination and other business rules.
• Building the business process flow.
• Creation of Ownership structure.
• Balance Carry forward process.
• Creating Controls

· Carrying out Currency Translations

· Intercompany Elimination