Inderjeet Singh profile photo 1 on Tal

Inderjeet Singh

Strategic Finance Leader | Principal Business Analyst | Risk & Governance | Transforming FP&A with Python, Power BI & Automation | Driving Profitability through Data Analytics

Greater Toronto Area

19+ years of work experience

OpenText
Dec 20241 yr 9 mosPresent

Richmond Hill, Ontario, Canada

OpenText
Feb 20204 yrs 11 mosDec 2024

Waterloo, Ontario, Canada

I am playing a key role in enhancing cash flow optimization and compliance at OpenText through strategic forecasting and data governance. • Engineered a dynamic model for Bad Debt Expense forecasting, improving financial accuracy. • Developed advanced analytics tools that provided real-time insights to senior leadership, facilitating informed decision-making. • Improved the Collection Efficiency Index, unlocking significant working capital for the organization.
Royal Bank of Scotland
Oct 20163 yrsSep 2019

Leadership: Managed a high-performing team of 8 finance professionals overseeing ledger close and month-end journal preparation. Successfully reduced reporting timelines while maintaining 100% accuracy. Consolidated financial reports and ensured compliance with IFRS, leveraging organizational skills to maintain clarity in submissions to management and the Chief Accountant Division. Finance Transformation: Spearheaded process improvement initiatives, including Oracle ledger implementation and Robotics Process Automation (RPA), collaborating effectively with IT and operations to streamline workflows. Established rigorous analytical procedures over balance sheet and profit and loss accounts, utilizing MS Excel for detailed analysis and error identification to improve accuracy. Financial Reporting: Developed comprehensive Business Performance Review reports, employing Hyperion Essbase for in-depth analytics and driving data-informed decision-making across the organization.
Royal Bank of Scotland
Jul 20142 yrs 3 mosSep 2016

· Successfully led reverse transition of income BI/ Decision support processes to Poland and appreciated for a seamless handover within defined timelines. · Created monthly Business Performance Review reports that provided analytical support (Margins, Ratios, Volume & Rate analysis, New lending, etc.) on business performance to the Finance Director. · Supported Private Banking DS through weekly product performance reports and providing Key Business Analytics around major product lines of the bank like deposits, lending and investments. · Managed optimization of financial performance by CAL Analysis (top movers, users) and offered insightful analytics on underlying margins and established link between volume movements to external economic environment. · Improved client tier reporting by segregating the information at beneficial owner level, stripped out intra-band and inter-branch movements to help BI provide better comparative analysis and more context around numbers. · Monitored business performance with insightful analytics on trends, drivers (like Net New Business and Asset under Management) and other non-financial information.
Royal Bank of Scotland
Oct 20121 yr 9 mosJun 2014

- Analytics and decision support on operating income results for Coutts Bank (Wealth Division) by preparing monthly dashboards for senior leadership in the business. This requires financial and trend analysis for each category of revenue viz., Net Interest, Fees & Commission, Investment, etc. to identify profitable Products, Net New Business gained and rate/ volume drivers impacting MoM movements. - Business Support and Management Reporting for Private Banking arm by compiling and publishing Performance packs for Private Bankers to enable better management of respective client base and tracking of revenue generated and business added.
HSBC
Dec 20101 yr 10 mosSep 2012

· Decision support to functional cost centres in Group Management Office by performing end-to-end financial and trend analysis to identify cost saving, forecast next year requirements and make relevant budgetary allocations. · Examined & published high quality performance reports to Functional Heads which enabled better management of respective expense base. · Provided volume & rate analytics on the specific drivers of spend in S&B, T&E & other lines and prepared presentations for management’s review. · Successfully analysed and reported financial information to executive management; actively worked with functional teams to ensure accurate and value added analysis. · Ascertaining volume & rate analytics on the drivers of spend and evaluating cause for significant variances. · Regular interaction with various Functional heads and providing ad-hoc management reports to enable decision making.
American Express
Jan 201011 mosNov 2010

Ensuring that the operating expenses incurred by the American Express Technology group are recognized appropriately for over 60 cost centers across various technology organizations prior to such charges being allocated to the business units on a monthly basis. Provided business units a better understanding and management of technology expenses by analyzing and reporting a breakdown of costs incurred each period. Variance analysis with comments on actual costs vis-a-vis forecasted expenses for each month submitted to various Tech FL's. using systems such as Oracle Essbase and Clarity. Ensuring complete and accurate expense booking for out task accruals and reclassifications to enable comparing actual results to budget/ forecasts and explaining any variances and net position analysis for the year to date results. Effectively carried out detailed analysis of vendor payments pertaining to prior year to identify any risks in the appropriateness of current year's accruals. A regular interaction with Tech FL's to ensure that all their queries related to various tech finance issues and on variance analyses are responded to.
American Express
Nov 20081 yr 2 mosDec 2009

Successfully led the remote migration of Non TI - Amex Technologies Finance processes from Phoenix by striving to build a strong relationship with Tech FLs, delegates & other business partners for Tech Finance. Automated the OT accrual template for various Tech Finance organizations which helped in greatly reducing probability of manual errors and the time taken for validating calculations.
American Express
Feb 20062 yrs 9 mosOct 2008

Financial Analysis Performing analytical review of financial operations of the company. Conducting Profit & Loss and Cost Center Analysis for ensuring consistency in expense capturing, identification of abnormal variances, putting up controls & monitoring mechanism for timely resolution / clearance of deviations. Coordinating with various market controllers of associate concerns of American Express across the globe in the review of charges in respect of Special Projects, Business partners and ABM with reference to the activity levels.
GitHub
@Inderjeet-23

Inderjeet’s AI Stack

opencode
opencode
claudecode
claudecode

Education

University of California, Davis

SQL for Data Science, Computer Programming

University of California, Davis

20222022
Corporate Finance Institute® (CFI)

Business Intelligence & Data Analyst (BIDA), Business Intelligence, Data Analysis

Corporate Finance Institute® (CFI)

20222022

Join Inderjeet and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Inderjeet Singh on Tal

Headline

Strategic Finance Leader | Principal Business Analyst | Risk & Governance | Transforming FP&A with Python, Power BI & Automation | Driving Profitability through Data Analytics

About

Analytics and Governance Leader and a "Citizen Developer" with over 19 years of experience, who bridges the gap between the CFO's office and the data engineering team, possessing the accounting rigor to ensure compliance and the technical architecture skills to automate it. I am driven by the belief that the future of finance belongs to those who bridge the gap between accounting rigor and data science. Proven track record of not just reporting numbers, but using them to drive strategy - from leading financial control teams at RBS (NatWest) to driving AR Governance at OpenText. Currently manages the governance of a $5B+ global receivables portfolio, with a focus on replacing manual spreadsheets with automated, predictive insights. Core Value Proposition: Strategic Forecasting: Architect of dynamic forecasting models that integrate billings and delinquency trends rather than relying on static run-rates. A "Citizen Developer" in Finance: Specializes in Power BI (Advanced DAX) to visualize the story behind the data. Leverages Python to architect automation workflows—using Monte Carlo simulations to stress-test numbers and validate risk exposure (CECL/IFRS 9) without heavy reliance on IT intervention.

Location

Greater Toronto Area

AI stack

opencode

claudecode

Work experience

Principal Business Analyst at OpenText, Dec 2024 - Present · 1 yr 9 mos, Richmond Hill, Ontario, Canada

Lead Business Analyst at OpenText, Feb 2020 - Dec 2024 · 4 yrs 11 mos, Waterloo, Ontario, Canada, I am playing a key role in enhancing cash flow optimization and compliance at OpenText through strategic forecasting and data governance. • Engineered a dynamic model for Bad Debt Expense forecasting, improving financial accuracy. • Developed advanced analytics tools that provided real-time insights to senior leadership, facilitating informed decision-making. • Improved the Collection Efficiency Index, unlocking significant working capital for the organization.

Senior Manager at Royal Bank of Scotland, Oct 2016 - Sep 2019 · 3 yrs, Leadership: Managed a high-performing team of 8 finance professionals overseeing ledger close and month-end journal preparation. Successfully reduced reporting timelines while maintaining 100% accuracy. Consolidated financial reports and ensured compliance with IFRS, leveraging organizational skills to maintain clarity in submissions to management and the Chief Accountant Division. Finance Transformation: Spearheaded process improvement initiatives, including Oracle ledger implementation and Robotics Process Automation (RPA), collaborating effectively with IT and operations to streamline workflows. Established rigorous analytical procedures over balance sheet and profit and loss accounts, utilizing MS Excel for detailed analysis and error identification to improve accuracy. Financial Reporting: Developed comprehensive Business Performance Review reports, employing Hyperion Essbase for in-depth analytics and driving data-informed decision-making across the organization.

Manager at Royal Bank of Scotland, Jul 2014 - Sep 2016 · 2 yrs 3 mos, · Successfully led reverse transition of income BI/ Decision support processes to Poland and appreciated for a seamless handover within defined timelines. · Created monthly Business Performance Review reports that provided analytical support (Margins, Ratios, Volume & Rate analysis, New lending, etc.) on business performance to the Finance Director. · Supported Private Banking DS through weekly product performance reports and providing Key Business Analytics around major product lines of the bank like deposits, lending and investments. · Managed optimization of financial performance by CAL Analysis (top movers, users) and offered insightful analytics on underlying margins and established link between volume movements to external economic environment. · Improved client tier reporting by segregating the information at beneficial owner level, stripped out intra-band and inter-branch movements to help BI provide better comparative analysis and more context around numbers. · Monitored business performance with insightful analytics on trends, drivers (like Net New Business and Asset under Management) and other non-financial information.

Assistant Manager at Royal Bank of Scotland, Oct 2012 - Jun 2014 · 1 yr 9 mos, - Analytics and decision support on operating income results for Coutts Bank (Wealth Division) by preparing monthly dashboards for senior leadership in the business. This requires financial and trend analysis for each category of revenue viz., Net Interest, Fees & Commission, Investment, etc. to identify profitable Products, Net New Business gained and rate/ volume drivers impacting MoM movements. - Business Support and Management Reporting for Private Banking arm by compiling and publishing Performance packs for Private Bankers to enable better management of respective client base and tracking of revenue generated and business added.

Assistant Manager - Group Cost & Investment Reporting at HSBC, Dec 2010 - Sep 2012 · 1 yr 10 mos, · Decision support to functional cost centres in Group Management Office by performing end-to-end financial and trend analysis to identify cost saving, forecast next year requirements and make relevant budgetary allocations. · Examined & published high quality performance reports to Functional Heads which enabled better management of respective expense base. · Provided volume & rate analytics on the specific drivers of spend in S&B, T&E & other lines and prepared presentations for management’s review. · Successfully analysed and reported financial information to executive management; actively worked with functional teams to ensure accurate and value added analysis. · Ascertaining volume & rate analytics on the drivers of spend and evaluating cause for significant variances. · Regular interaction with various Functional heads and providing ad-hoc management reports to enable decision making.

Assistant Manager - Corporate Planning & Analysis at American Express, Jan 2010 - Nov 2010 · 11 mos, Ensuring that the operating expenses incurred by the American Express Technology group are recognized appropriately for over 60 cost centers across various technology organizations prior to such charges being allocated to the business units on a monthly basis. Provided business units a better understanding and management of technology expenses by analyzing and reporting a breakdown of costs incurred each period. Variance analysis with comments on actual costs vis-a-vis forecasted expenses for each month submitted to various Tech FL's. using systems such as Oracle Essbase and Clarity. Ensuring complete and accurate expense booking for out task accruals and reclassifications to enable comparing actual results to budget/ forecasts and explaining any variances and net position analysis for the year to date results. Effectively carried out detailed analysis of vendor payments pertaining to prior year to identify any risks in the appropriateness of current year's accruals. A regular interaction with Tech FL's to ensure that all their queries related to various tech finance issues and on variance analyses are responded to.

Sr. Financial Analyst - Corporate Planning & Analysis at American Express, Nov 2008 - Dec 2009 · 1 yr 2 mos, Successfully led the remote migration of Non TI - Amex Technologies Finance processes from Phoenix by striving to build a strong relationship with Tech FLs, delegates & other business partners for Tech Finance. Automated the OT accrual template for various Tech Finance organizations which helped in greatly reducing probability of manual errors and the time taken for validating calculations.

Financial Analyst - Global Accounting at American Express, Feb 2006 - Oct 2008 · 2 yrs 9 mos, Financial Analysis Performing analytical review of financial operations of the company. Conducting Profit & Loss and Cost Center Analysis for ensuring consistency in expense capturing, identification of abnormal variances, putting up controls & monitoring mechanism for timely resolution / clearance of deviations. Coordinating with various market controllers of associate concerns of American Express across the globe in the review of charges in respect of Special Projects, Business partners and ABM with reference to the activity levels.

Education

SQL for Data Science, Computer Programming, University of California, Davis

Business Intelligence & Data Analyst (BIDA), Business Intelligence, Data Analysis, Corporate Finance Institute® (CFI)

Public links

github: https://github.com/Inderjeet-23