Soumya Pal

Experience

• 

  GENPACT

  Dec 2009 - Oct 2012

  Financial Analyst

  Dealt with 65 multiple currencies high risk Cash & Bank reconciliation daily and closed any unidentified open items with the respective accounting team in the general ledger. Prepared the daily real bank balance report from TREMA application.Prepared & reconciled the JMF (Revenue & Cost) Reports for the entire Europe business to between the Ledger & sub ledger for the quarter end reporting process.Monitored the edit checks of the bank accounts at end of every month.Created the journal entries for the open items.Vat preparation of different European countries.Drove the quality metrics as Quality Catalyst leading a team of 30 members and achieved 50 Lean ideas as the process development target every year.Promoted within the stipulated time frame for exceeding the expectation. Show less

• 

  Capgemini

  Nov 2012 - Mar 2014

  Senior Financial Analyst - Team Leader

  Created statistical analysis of Revenue (Total & External Revenue), Direct Cost & Indirect Cost (SFC, BDC) between Actual, Forecast & Budget with commentary for the ease of CFO.Reported Actual, Forecast & Budget in Hyperion and handled all queries from the Group Level.Automated the Weekly Debt reports, Current, Cash Target, Bad Debt, Debt Graph for the entire business which helped to correctly report the DOR (Days over receivable) and reduced 50% of the team’s time and reduced 5% of total outstanding receivable.Creating and posting journal entries in Oracle for monthly Cost & Revenue accruals.Instrumental in representing Capgemini UK for the successful implementation of Hyperion Financial Management. Show less

• 

  SunEdison

  Mar 2014 - Mar 2016

  Finance Manager

  Created multiple dashboards presentations, KPI Metrics, detailed variance analysis with insightful commentary and adhoc reports as requested by Director of Financial, Planning and Analysis. Consolidation of the project list for all the regions for corporate reporting and reviewing the Project models for all the projects with the project finance team with that in SAM.Worked on project financial models for expected projections of the projects with complicated VBA and various pivot tables.Drove the forecast and budget cycle working with operations, project finance & controllership team.Tracked 35 Global Supply Chain OPEX Cost center with budgetary control of $9M USD per quarter. Reduced $500k USD of operating expenses by correcting wrong cost center mapping and re-classifying irrelevant cost transfers.Drove and Implemented master reconciliation template for cost classification to determine proper cost of operations.Identified & completed a Green Belt project in implementing inbuilt house software (SAM) for efficiently reporting all the financial aspect of the project for all business units.Trained more than 50 new team members across APAC region for the in-house built SAM software for project related financial reporting. Partnered extensively with the technical team to make the SAM software usable globally.Implemented schedules for vendor reconciliations for key accounts on a monthly basis and investigated & resolved the outstanding invoices.Drove the variance analysis related to processing supplier invoices with stakeholders like vendors or internal team.Led the transformation and standardization of Accounts Payable process to remove irregularity for APAC Business units.Created and standardized the Cash Flow format for all the Business Units related to the weekly cash flow projection report which reduced 20% of the Operation Managers’ time. Show less

• 

  TD

  Sept 2016 - Nov 2017

  Operation Officer

  Process all Estate files settlement requests as per the documented policy of the bank.Review the documents received and action as per the bank policy and government regulation.Experienced in processing special requests from PGT (Public Guardian and Trustee) and from the government bodies like the city at an urgent and accurate reporting of information.Investigated and halted all the types of assets including wealth products and liabilities within the service legal agreement and risk mitigation.Analyzed multiple types of investment products, wealth or securities funds, Line of credit, mortgages and credit card accounts to deliver on time and accurate information for better client services.Directly handling any requests or clarification from the branch partners through email and online chat. Show less

• 

  Resource Innovations

  Dec 2017 - now

  Spearhead the Reporting Center of Excellence (COE) team, overseeing two members and actively expanding the team to meet increasing demands.Develop and produce a wide range of reports utilizing internal systems, enhancing internal decision-making processes and fulfilling external reporting requirements promptly and accurately.Design and implement sophisticated Excel dashboards and Power BI reports, empowering stakeholders with actionable insights and facilitating data-driven decision-making.Collaborate closely with software and business leaders to identify system gaps, propose strategic enhancements, and drive initiatives to fruition, resulting in optimized system performance and streamlined processes.Proven track record of delivering high-quality reporting solutions tailored to specific business needs, consistently exceeding expectations and enhancing organizational effectiveness from finance to HR and operations. Act as a key liaison between technical and business teams, effectively translating requirements and ensuring alignment between technological capabilities and business objectives.Continuously stay abreast of industry trends and best practices in reporting and analytics, proactively integrating new methodologies and technologies to enhance reporting capabilities and drive innovation within the organization. Show less Consolidation of multiple dashboards and management reporting like, cost-recovery analysis, P&L reporting, detailed variance analysis between actual, forecast & annual budget and insightful commentary to stakeholder (BOD) to support an informed business decision making.Created and monitor consistently the weekly dashboard for the sales pipeline and backlog from Salesforce (SFDC) for review with the Senior Vice President and COO/CFO.Preparing the 5-year strategic plans by aligning targets to the non-financial professionals like business unit leaders using a consistent framework and assumptions metrics template.Responsible for managing $130 million of top line and $14 million of EBITDA target for the year.Providing actual reports for the SG&A (selling, general and administrative) reflecting the correct cost and to have proper control on the budget assigned.Implemented the P&L reporting structure for the company coordinating with the controllership team to achieve the common goal of robust reports from Oracle adhering to the internal control measures.Implemented the SG&A chart of account groupings and hierarchy for the proper financial statement reporting controls and impact on the business processes.Reviewing the P&L in details to prepare a meaningful walk of the changes to the top line and the EBITDA compared to the budget and/or forecast for each business unit.Preparing month end closing reports with the controllership team to ensure booking of monthly journal entries in general ledger (G/L) within deadline and taking corrective action within the period.Working directly with the controllers to handle the audit queries, financial investigation and resolving the issues ensuring integrity of the data and financial information.Successfully handling the due diligence process and closure of M&A activities.Responsible for the approval of the weekly wire payments in the bank with close control on the bank balance. Show less

  • Solution Deliver Lead

    Sept 2023 - now

  • Finance Manager

    Sept 2018 - Sept 2023

  • Senior Financial Analyst

    Dec 2017 - Sept 2018