INDERJEET SINGH
Richmond Hill,ON
Summary
Principal Business Analyst with over 19 years of expertise in accounting, finance, and business intelligence. Specializes in converting complex data into actionable insights that enhance decision-making and operational efficiency. Demonstrated success in increasing forecasting accuracy, optimizing reporting processes, and aligning business intelligence initiatives with organizational objectives. Proficient in Power BI, SQL, and various financial analytics tools.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Principal Business Analyst – AR Governance
OpenText Corp
Richmond Hill, ON
11.2024 - Current
- Lead Business Analyst – AR Governance / OpenText Corp
- Responsible for the group's annual collection forecasts of approx. $5 billion evaluating the impact of billings, trend of delinquency on collection efficiency, and identifying opportunities for growth.
- Developed the bad debt expense forecast model based on IFRS 9 requirements (expected credit loss provisioning), computing BDE requirements for the group based on AR credit exposure and delinquency changes.
- Established analytical procedures, KPIs like Collection Efficiency Index, Rate-Vol analysis on AR spend drivers, AR Turnover, etc. to continuously monitor actual performance versus plan, right-size the outlook, and manage management expectations, providing better governance of Accounts Receivables.
- Developed Python-based notebooks to evaluate BDE, AR aging, cash forecast, etc. and introduced control tools like PERT, Monte Carlo simulations, etc. to statistically validate respective outlook.
- Applied project management expertise to lead assessment of using a proprietary case management tool for the customer refund process. Utilized tools such as Lucidspark to quickly develop BPMN-compliant process flows, UML context diagrams, and RASCI matrices, enabling clear stakeholder alignment and process clarity.
- Set up rate and volume analytics, identifying and explaining specific drivers of AR-owned spend (allowance for doubtful accounts, etc.) and prepared presentations for management's review.
- Applied advanced BI skills to build Power BI dashboards, providing actionable insights to internal management and collectors. This includes leveraging DAX to calculate, analyze, adjust, and report on business results.
Associate Vice President – Financial Control
The Royal Bank of Scotland
10.2016 - 09.2019
- Led a team of eight people responsible for core ledger close, MI, and IFRS-based supplementary disclosure reporting of costs for RBS's Commercial and Private Banking division (RBS and NatWest Legal Entities).
- Consolidated BU/LE level financial reports, monthly flash, and IFRS-based statutory reporting for onward submission to management/CAD (Chief Accountant Division).
- Contributed to projects such as Oracle ledger implementation, IFRS 9 compliance, etc.
- Ensured processes adhere to appropriate policies and control environment (including SOX governance).
- Created monthly Business Performance Review reports that provided analytical support (margins, ratios, volume and rate analysis, new lending, etc.) on business performance to the Finance Director.
- Monitored business performance with insightful analytics on trends, drivers (like Net New Business and Assets under Management), and other non-financial information (lending pipeline, no. of deals, etc).
- Established a TB review and income projection model on operating income results for the Wealth Division, incorporating financial and trend analysis for each category of revenue to identify profitable products and rate/volume drivers impacting MoM movements.
- Extensive usage of MS Excel and Hyperion Essbase for retrieving divisional, legal entity results, putting controls, and reviewing team deliverables.
Assistant Manager – Financial Control
The Royal Bank of Scotland
10.2012 - 10.2014
- Led a team of eight people responsible for core ledger close, MI, and IFRS-based supplementary disclosure reporting of costs for RBS's Commercial and Private Banking division (RBS and NatWest Legal Entities).
- Consolidated BU/LE level financial reports, monthly flash, and IFRS-based statutory reporting for onward submission to management/CAD (Chief Accountant Division).
- Contributed to projects such as Oracle ledger implementation, IFRS 9 compliance, etc.
- Ensured processes adhere to appropriate policies and control environment (including SOX governance).
- Created monthly Business Performance Review reports that provided analytical support (margins, ratios, volume and rate analysis, new lending, etc.) on business performance to the Finance Director.
- Monitored business performance with insightful analytics on trends, drivers (like Net New Business and Assets under Management), and other non-financial information (lending pipeline, no. of deals, etc).
- Established a TB review and income projection model on operating income results for the Wealth Division, incorporating financial and trend analysis for each category of revenue to identify profitable products and rate/volume drivers impacting MoM movements.
- Extensive usage of MS Excel and Hyperion Essbase for retrieving divisional, legal entity results, putting controls, and reviewing team deliverables.
Assistant Manager – Business Intelligence
Hongkong & Shanghai Banking Corporation
12.2010 - 12.2012
- Prepared and maintained annual and rolling operating plans for various functional cost centers, ranging from risk, finance, to HR, etc. By performing end-to-end financial and trend analysis to identify cost savings, forecast next year's requirements, and make relevant budgetary allocations.
- Examined and published high-quality performance reports to functional heads, which enabled better management of the respective expense base.
- Provided volume and rate analytics on the specific drivers of spend in S&B, T&E, and other lines, and prepared presentations for management's review.
- Cognos TM1 cube management for HSBC Holdings.
Senior Financial Analyst – Corporate Planning & Analysis
American Express
10.2008 - 11.2010
- Ensured that the operating expenses incurred by the American Express Technology group are recognized appropriately per US GAAP for various technology organizations, prior to such charges being allocated to the business units monthly.
- Simplified management of technology expenses by the business units through analyzing and reporting a breakdown of their infrastructure and project-related costs incurred each period, with comments on the variance of actual costs versus forecast expenses submitted to various Tech Finance Leads.
- Primarily worked on Oracle ERP to book manual journals in the ledger, and used Hyperion Essbase for BU reporting of technology costs, customizing the interface per requirement.
Financial Analyst – Global Accounting
American Express
02.2006 - 09.2008
- Ensured that the operating expenses incurred by the American Express Technology group are recognized appropriately per US GAAP for various technology organizations, prior to such charges being allocated to the business units monthly.
- Simplified management of technology expenses by the business units through analyzing and reporting a breakdown of their infrastructure and project-related costs incurred each period, with comments on the variance of actual costs versus forecast expenses submitted to various Tech Finance Leads.
- Primarily worked on Oracle ERP to book manual journals in the ledger, and used Hyperion Essbase for BU reporting of technology costs, customizing the interface per requirement.
Education
Diploma - International Financial Reporting Standards
Association of Chartered Certified Accountants
01.2017
PMP - Project Management Professional
Project Management Institute
01.2011
CFA - Chartered Financial Analyst
The ICFAI University
01.2007
B. Com -
University of Delhi
01.2003
Skills
- Financial planning and analysis
- Business intelligence
- Financial control
- Data analytics
- IFRS financial statements
- Financial reporting
- Month-end and year-end closing
- SAP ERP systems
- Hyperion Essbase analytics
- Cognos TM1 reporting
- Budgeting strategies
- Forecasting and analysis
- Python programming
- SQL database querying
- DAX calculations
- PowerPivot data modeling
- Data visualization techniques
- Power BI dashboards
- Regulatory compliance reporting
- Disclosure documentation management
- Business partnering strategies
- Business process improvement initiatives
- Risk identification and assessment
- SOX governance compliance
- Team leadership skills
- Change management strategies
- Statutory audit management
- Project management expertise
Certification
Data Science, 04/01/24, Brain Station
Timeline
Principal Business Analyst – AR Governance
OpenText Corp
11.2024 - Current
Associate Vice President – Financial Control
The Royal Bank of Scotland
10.2016 - 09.2019
Assistant Manager – Financial Control
The Royal Bank of Scotland
10.2012 - 10.2014
Assistant Manager – Business Intelligence
Hongkong & Shanghai Banking Corporation
12.2010 - 12.2012
Senior Financial Analyst – Corporate Planning & Analysis
American Express
10.2008 - 11.2010
Financial Analyst – Global Accounting
American Express
02.2006 - 09.2008
Diploma - International Financial Reporting Standards
Association of Chartered Certified Accountants
PMP - Project Management Professional
Project Management Institute
CFA - Chartered Financial Analyst
The ICFAI University
B. Com -
University of Delhi
Similar Profiles
Hashim RazviHashim Razvi
Director, Technical Support at opentext CorporationDirector, Technical Support at opentext Corporation
Naveen Raj BNaveen Raj B
Senior Technical Writer at OpenText CorporationSenior Technical Writer at OpenText Corporation
Brijesh GopalBrijesh Gopal
Sr Manager, Software Engineering at OpenTextSr Manager, Software Engineering at OpenText
Padideh MasjediPadideh Masjedi
Graphic Designer (Contract-Remote) at Phoenix Contact Network Communications Inc.Graphic Designer (Contract-Remote) at Phoenix Contact Network Communications Inc.
Suki MakSuki Mak
ADMINSTRATIVE & SERVICE ASSISTANT at DA HU HOTPOTADMINSTRATIVE & SERVICE ASSISTANT at DA HU HOTPOT