Pragya Pugalia

• Designed and developed a Power BI month end dashboard from scratch, enabling trend analysis, anomaly detection, top/bottom mover analysis and executive-ready reporting.
• Managed month-end reporting and variance analysis (CM/PM, YTD, Actual vs Budget) for SG&A and other support functions, ensuring timely insights for decision-making.
• Own Franchise commission operations by managing manual payment processing, validations, and reconciliations, ensuring timely and accurate payments in line with financial controls.
• Implemented strategies to enhance process efficiency.

1. Optimizing manual payment cycles (288 hours saved annually)

2. Standardizing Claims processes

3. Developed a tracker in Power BI to identify the duplicate payment (Gives around GBP 2.4mn of annual cash saving)

• Served as primary finance contact across commercial, consumer FPA, and franchise teams, recognized for high levels of responsiveness and accuracy.

• Work closely with FBP onshore (Finance Business Partner) which includes following key responsibilities:
• Reviewed Income Statement and Balance Sheet to identify variances against forecast and budget, conducting trend analysis to inform financial insights.
• Forecasting and its revisions (Income Statement, Balance Sheet & Free Cash Flow) in BPC based on assumptions, projections and trend analysis.
• Developed and improved budgeting, financial projections, and operating forecasts to enhance financial accuracy and decision-making.
• Preparation and Authorization of Balance Sheet Reconciliations in Cadency.
• Cost and payroll reviews and postings adjustments for accruals and deferrals.
• Monitored KPIs to identify causes of unexpected variances, providing actionable insights for financial adjustments.

• Creating monthly rolling forecasts and detailed analysis of variance to budgets and forecasts.
• Generated monthly variance reports to identify significant variances across scenarios including CF vs PF, YOY, and QOQ for cost analysis.
• Prepared close and forecast reports with qualitative data on one-time and permanent impacts, and presented findings to senior management.
• Participated in developing the annual budget by collaborating with cross-functional teams.
• Identify and implement process changes to improve quality and productivity of certain process & reports.
• Developed standard operating procedures (SOPs) to streamline processes and improve operational efficiency.
• Build and maintain strong professional relationships with key stakeholders.
• Coordinate with AP team and make sure all the transitions hit correctly to the cost centres.
• Posting JVs in SAP at month end for revenue and cost allocation among projects.
• Creating journal entries for accruals, prepaid expenses, and amortization to ensure accurate financial records.
• Working with controllership team to do the NRV assessment of internally developed software for external use.

• Gathering the requirement from the client (CIT,CCIT, etc).
• Developed validation rules and schema to ensure accuracy and compliance in tax data processing.
• Updated Income Tax Return preparation utilities and related forms to align with new tax regulations.
• Created approach note for functionalities related to Income Tax India e-filing portal, including pre-validation of bank accounts and representative assessee features.
• Preparation of Management Information System reports (MIS) for the client.
• Managed e-filing maintenance project to ensure compliance with tax regulations.
• Analyzing the changes in Direct Tax Law (Income Tax Act,1961).