PRAGADEESH J

• Played a key role in transitioning the planning and budgeting process from Hyperion to SAP Analytical Cloud.
• Collaborated on data integration and validation, ensuring the accurate flow of actual data from BPC to SAP Analytical Cloud via DataIKU, across various models.
• Designed and updated the security matrix for Workforce Planning (WFP) and Balance Sheet Simulator models according to the specified design.
• Led the transition from creating sub-models to directly planning on the main model, utilizing the new mass upload functionality.
• Managed the SAC Workforce monthly process, where WFP costs account for 55% of total costs. Maintained comprehensive knowledge of the end-to-end process and cost movement, based on driver-based calculations.

- Updated versions, loaded and reconciled actual data, ensuring accuracy.

- Pre populate FTE and drivers for planning periods using admin steps, and performed cost calculations.

-Addressed user queries and resolved issues promptly.

-Performed daily business-as-usual (BAU) activities, including pushing data to Outlook/CP models via cross-model copy functionality for reporting.

-Locked the WFP tool after month-end closure, archived data, and prepared for the next month’s planning cycle.

• Assisted users in understanding the logic behind cost calculations, providing functional guidance for correct data updates to achieve desired results.
• Managed the Balance Sheet Simulator model, a top-down planning tool that uses "what-if" functionality for simulated private version balance sheet scenarios and on-the-fly metric calculations.
• Pre populate data from Outlook and CP/BR into the Balance Sheet Simulator model, preparing it for user simulation.
• Engaged in testing new builds, offering suggestions to improve existing processes.
• Assisted with monthly administrative tasks such as currency exposure mix loading, checking AIEA and AIBL data quality, and resolving user queries.
• Facilitated the transfer of outbound data from SAC to BW, supporting downstream systems (CFX/Service Change/FGCR) through data mapping.
• Collaborated with the project team to review and address backlog items, ensuring process improvements and enhancements were implemented.
• Gained strong expertise in data modeling using Data Sphere through training and hands-on experience.
• Supported structural changes at the start of each cycle for all SAC models and BW tables, ensuring alignment between BW tables and SAC structure and updating necessary mappings accordingly.
• Evaluated new QRC releases, assessing their impact on existing processes and providing feedback for improvements.
• Continuously sought process improvement opportunities, enhancing user experience by developing validation reports using Stories and automating the data reconciliation process.
• Ensured timely resolution of queries within agreed service level agreements (SLAs).
• Provided ongoing support for HP Planning and HPCM applications as part of BAU activities and assisted with SAC-related tasks.
• Held full responsibility for the transfer of inbound and outbound data from FDMEE during HP and DataIKU/BW to SAC.
• Coordinated with the service charges team to implement changes to services and rules for HPCM.
• Managed and maintained HPCM Point of View (POV) and rules governing the cost allocation process.
• Led the deployment of Phase 2 Change Requests (CR) for the HP Outlook application, conducting User Acceptance Testing (UAT) to ensure successful production deployment.
• Executed monthly data loads for HP/HPCM and the Outlook application, adhering to the BAU process.

• Company Overview: AstraZeneca is a global, science-led bio pharmaceutical business and their innovative medicines are used by millions of patients worldwide.
• Supporting Planning application with BAU activity for all budgeting cycle and month end related activities.
• Worked in Operations planning (FTE, Manpower cost, Inventory, Other Manpower Cost, Operation Profit and Loss, Science RND Cost, Capex) application to support 800+ users business users.
• Managing the process strictly for successful Forecast submission along with Business.
• Work along with Data team (AWS) to bring data from Source.
• Helping Business to reduce FTE spent in Planning system Through mass upload and actualization.
• Involving in Metadata changes along with DRM Team and deploying the changes in application without any loss of data.
• Handling Month End data load activity for MRH reporting.
• Work on new enhancement CR’s and testing them along with business for smooth Go Live.
• Doing necessary control checks before and after planning submission.
• Have good understanding about security matrix to enable user according to system open and close date.
• Managing on cutover activities for all planning cycles based on business requirement.
• Having regular catch up with business to ensure smooth BAU.
• Have basic knowledge in ODI. Check for issues in data loads and fix them in ODI.
• Have understanding about ASO application and maxl scripts.
• Worked on archival process and keeping all environment is sync.
• Timely response to users with queries and issues.
• Address issues within the agreed SLA and give proper RCA.
• Supporting on Capex application, Alliance Planning BAU related activities.
• AstraZeneca is a global, science-led bio pharmaceutical business and their innovative medicines are used by millions of patients worldwide.

• Company Overview: MetLife is among the largest global providers of insurance, annuities, and employee benefit programs, with 90 million customers in over 60 countries.
• Analyzing the Summary requirement document.
• Creating the mockup forms and FR reports based on the requirement document for the TDD.
• Understanding the separate modules for insurance like revenue, cost, Underwriting, EBS, Revenue Attribution.
• Creating dimension and members in hierarchy for the mockup purpose so that it can be used during build phase.
• Creating Forms, Rules for the application.
• Creating security matrix, task list for application.
• Working with DRM team to finalize the application dimensions.
• Unit testing every model with sample data provided before handing over to QA.
• Completion of unit testing with testing team.
• Creating FR reports in PBCS.
• MetLife is among the largest global providers of insurance, annuities, and employee benefit programs, with 90 million customers in over 60 countries.

Mazrui International L.L.C:

• Company Overview: The Mazrui international is one of the largest and most diversified business houses in the United Arab Emirates. Its main interests straddle Energy services, Retail, Construction & Logistics, Education and Healthcare having 40 entities.
• Creating EPMA application for synchronizing dimensions from HFM.
• Added Loan, manpower and asset budget planning based on the requirement.
• Implemented cash flow, Flash report, balance sheet and income statement report for user analysis.
• Created driver-based calculation for revenue, manpower, capex, OPEX, inventories, WIP, Trade receivables, Loans etc.
• Entity wise recharges from Group Company were incorporated based on their allocation method for different recharges.
• Integrating Actual data from Hyperion Finance management to Hyperion planning and posting the budgeted data to HFM after budget cycle. Data movement was handled in FDMEE.
• Detailed Financial reports from HFRS were developed and automated for the user standard.
• Created company specific task list and approvals for Budget promotion.
• Handled and assisted stakeholders during the course of UAT.
• Giving support to the clients after Go live.

• Creating metadata, data forms and entire planning application from scratch.
• Immediate support to key reports like Per Car Cost report.
• Department wise cost report, direct/semi direct report.
• Maintaining zero level for escalations from business.
• Working on the scope for Plant 2 implementation.
• Understanding the detail requirement for Plant 2 Rollout and implementing the changes required as per design document.
• Writing scripts for new calculation and enhancing the existing script as per business requirement.
• Designing profit and loss statement, cash flow and balance sheet.
• Integrated the Actual data from ERP using flat file and loading it in PBCS.
• Created financial reports in HFR for all BU’S according to the requirement.