Jan 2022 – Feb 2025 · 3 yrs 1 mo

•  Implementing budgeting, planning scenarios Travel Opex cost with respect to department and profit center, revenue Planning with respect SKU category, Product status, and SKU wise. country and, Employee level cost w.r.t. to department
•  Financial statement planning including P&L, Balance sheet statement.
•  Data acquired from S/4 HANA from ACDOCA, Profitability Analysis, material master, Purchase Info records along with COGS.
•  Live Reporting from S/4 HANA for financial reports
•  Expert Knowledge in Solution designing for various types of planning scenarios across industrial sectors in designing Models, Dimension, properties for standard and Key figure models.
•  Created ABAP Custom CDS view to pull S4 Hana data to SAC.
•  Expert knowledge in achieving complex business requirements using data actions and reporting techniques.
•  Working knowledge in SAC on excel and designing security setup across planning models and data.

Dec 2021 – Feb 2023 · 1 yr 2 mos

• Worked on Production support for Sysco FP&A Planning maintaining the applications, Dimensions, Monitoring the daily loads, resolving daily tickets, etc.
• Closely monitoring Weekly Maintenance Jobs.
• Some of the issues resolved include validation of data between BI and BPC after the nightly loads.
• Created Data Manager Packages, Transformation Files and Conversions Files
• Maintenance different packages like Lite Optimization, Actual loads, Seed data push.
• Loaded different transaction data from multiple sources like BI/Flat file to Current Period, Exchange Rate Load
• Handling user access.
• Worked on Enhancements.

Oct 2018 – Jun 2021 · 2 yrs 8 mos

• Excellent communication, analytical and interpersonal skills as a consultant and play key role in implementations from blueprint to go-live.
• Created one environment shell, dimensions & maintained master data.
• Responsible for configuring Demand, Revenue, Facility, Supply Generation, Production, Cost center, Balance sheet, Profit & Loss, and cash forecast models.
• Created Transformation file and Conversion files to load the Master Data from BW Info Objects
• Created Transformation file and Conversion files to load the Actual Transaction Data from BW Info Providers.
• Input template: Fixed and standardizes the input template related to demand revenue, cost center & finance models.
• Report: Organized data and developed reports on demand revenue planning, production planning, cost center planning and Balance Sheet, Net Income, Cash Flow, and variance report as per the requirement.
• Designed dynamic, static, multiple EPM report within one template and organized data from multiple cube in one template.
• Defect Resolution: Fixed defect during UAT.
• Client Interaction: Actively interacted with BPC application owner from the client side. The objective was to understand the new client need and provide them with solution and evaluate the support status on weekly basis.
• Provided training to end user on submitting data through input schedule and how to generate Ad-hoc reports based on business requirement. Also, trained BPC business administrator to support the application independently.
• Transport: Created and released transport and fixing transport errors.
• Worked on security set up. Creating team, task, member access profiles to allow users to perform task and access assigned data.
• Logic scripts: written script logic for several calculations across all the models.
• Business Rules: Account transformation and carry forward rules in finance model.
• Cut-Over activity: Loaded historical, forecast and budget data as cut over activity.

Feb 2018 – Sep 2018 · 7 mos

• Developed Input Queries and Reports using query designer and developed reports in Analysis for Office (AO 2.6).
• I have configured Embedded Consolidation in BPC admin page using ADSO with Agglevels, configured Business rules, and developed AO reports to run the Business rules using Planning Sequence.
• BW security access and work status configuration.
• We have used AO customization and SAP Get, List and Set Members to do some calculation at report level.
• We created local formulas at AO to do calculations on Fly, before saving data to DB.
• Configured Business rules in embedded version, same we have executed from AO using PF.

Sep 2017 – Feb 2018 · 5 mos · Hyderabad, Telangana, India

• Responsible for configuring Consolidation Model.
• Created Transformation file and Conversion files to load the data from BW Info Providers.
• Create Several Reports Balance Sheet and Profit and Loss Reports
• Created several input forms for consolidation like Trail Balance, Trading Partner, Fixed Asset Input Templates etc.
• Worked closely with business users to design, develop, test and implement input schedules, Reports using EPM Functions like EPM Save Data, EPM Retrieve Data, EPM Context Member, EPM Select Member, EPM Context Member, EPM Member Offset, EPM Copy Range.
• Write a Logic Script moving data one Model to another, Deriving Dimensions from properties, Renaming Dimensions, Skipping Dimensions and also assigning constants for some dimensions.
• Configured the setup of business rules like Account Transformation, Carry Forward and Currency Conversions.
• Created Business Process Flows (BPF) for sequential processing of Month-End Close and Consolidations.
• Involved in configuring the Teams, Member Access Profiles and Task profiles.
• Configure Drill through functionality extensively.
• Given Training to Users and Corporate Finance Team.

Feb 2017 – Aug 2017 · 6 mos

• Responsible for configuring Consolidation Model.
• Created Transformation file and Conversion files to load the data from BW Info Providers.
• Create Several Reports Balance Sheet and Profit and Loss Reports
• Created several input forms for consolidation like Trail Balance, Trading Partner, Fixed Asset Input Templates etc.
• Worked closely with business users to design, develop, test and implement input schedules, Reports using EPM Functions like EPM Save Data, EPM Retrieve Data, EPM Context Member, EPM Select Member, EPM Context Member, EPM Member Offset, EPM Copy Range.
• Write a Logic Script moving data one Model to another, Deriving Dimensions from properties, Renaming Dimensions, Skipping Dimensions and also assigning constants for some dimensions.
• Configured the setup of business rules like Account Transformation, Carry Forward and Currency Conversions.
• Created Business Process Flows (BPF) for sequential processing of Month-End Close and Consolidations.
• Involved in configuring the Teams, Member Access Profiles and Task profiles.
• Configure Drill through functionality extensively.
• Given Training to Users and Corporate Finance Team.

Jan 2015 – Jan 2017 · 2 yrs · Hyderabad Area, India

• Implementation:
• Responsible Configuring OPEX and CAPEX Planning.
• Experience designing Environment, Models, dimensions, properties, loading data and configuring business rules, logic script.
• Extensively trained the client on BPC Functionality such as Data manager Packages, Conversion and Transformation Files, Environments, Models, Dimensions, Dimension members, Properties, Hierarchies, Functionality of Data manager, Process chains
• Loading Data from BI to BPC and Loading Currency Exchange Rates into the Rate Application.
• Configured Business Rules for Currency Translation and Created Packages for running these Business Rules
• Worked on logic script and other Allocation Logic for top down allocations
• Setting up Work status and Security for Models across different regions. Extensively worked on BPF to automate the planning process.
• Worked closely with business users to design, develop, test and implement Logic Script in custom tasks in packages.
• Worked closely with business users to design, develop, test and implement input schedules, Reports using EPM Functions like EPMDimensionOverride , EPMInsertCellsBeforeAfterBlock, EPMMemberProperty, EPMRetrieveData, EPMMemberOffset, EPMContextmember, EPMSelectMember, EPMSaveData, etc.
• Built Reports and Input Forms using Options like Local Member Recognition , keep , exclude ,etc and worked on formatting the reports
• Created Transformation file and Conversion files to load the data from BW.
• Support:
• Responsible to support both BPC and BW and managing different models like Cost Center Reporting &PBA, PCE
• Responsible to assign roles to business users as per the business requirements.
• Monitoring the BW Process chains and resolved several Issues.
• Resolved several report issue facing by User.
• Worked closely with business users in solving issue like Data loads, Data mismatch in reports.
• Created user manuals to guide the users.
• Solved issues related to master data loads and transaction load.

Nov 2014 – Dec 2015 · 1 yr 1 mo · Greater Hyderabad Area

• Responsible for configuring HCM Planning.
• Extensively worked in Master data loads and Transaction data loads from BI to BPC
• Worked on Transformation Files, conversion Files and created Custom Data Manager Package
• Good Hands on Experience in building codes using scripting commands.
• Implemented Reports and input forms.
• Configure the Securities and Work Status.

Sep 2013 – Nov 2014 · 1 yr 2 mos · BANGLORE

• Responsible for configuring Sales, Capex and Consolidation SAP EPM 10.0
• Implemented SAP EPM 10 implementation Configuring Applications, Input Schedules, Reports, Script Logic, transformations, Business Rules, BPFs, etc
• Created Complex input schedules like List Price, GSI, Volumes,Replace,Replace Asset, Disposal Asset, Future Depreciation of Existing Assets,
• Build Complex Reports like P&L Net Contribution, Volume,List Prices,Existing Asset, New Assets.
• Having good working experience using EPM Functions like EPM Save Data, EPM Context Member, EPM Context Member, EPM Member Offset, EPM Copy Range, EPM Retrieve Data, EPM Select Member, EPM Dimension Override, EPM Member Property.
• Developed Macro coding based on requirement.
• Worked on setup of business rules like Account Transformation, Carry Forward and Currency Conversions.
• Extensively Worked on BPF and Work status.
• Provided training to Business users and also involved in user manuals.

Nov 2012 – Aug 2013 · 9 mos · Hyderbad

• Unilever Phoenix:
• Responsible for SAP BPC 7.5 version Application Maintenance(Support)
• Worked on Production support for Phoenix maintaining the applications, Dimensions, Monitoring the daily loads, resolving daily tickets, etc
• Extensively Worked monthly initialization process
• Worked on Application maintenance on applications like Planning, Financial reporting, Rate on four regions Latam, Europe, North America, & Asia
• Worked on Sync activity.
• Worked on user creation/modification/deletion as per requirements.
• Worked on daily maintenance activity.
• Uploaded material and geography master data as per business demand.
• Solved different issue’s faced by user.