Pooja Bahl - Consultant at Deloitte Consulting

Consultant at Deloitte Consulting

Nationality

Indian

Work category

Banking Insurance and Financial Services

Education

Bachelor/Degree

Pooja Bahl's Professional Experience

2010 - Present

Deloitte Consulting - Consultant

- Calculation and valuations of liabilities for Pension Plans and other Post Retirement benefit plans in US and Australia.
- Various types of plans I have worked on includes FAE, Flat Dollar per month, Cash Balance & Career Average Plans.
- Developed several methods of coding different benefit components relating to the Pension Plans in ProVal.
- Live Valuation of Pension Schemes and Post-Retirement Health Benefits of US clients using ProVal and other Excel Tools.
- Performing Accounting Calculation like liability calculation (Coding the ProVal to ASC 715-30 results, Net periodic pension cost) for the pension plans.
- Worked on At-Risk liability calculation using ProVal and carried out complete analysis of sample lives in Excel.
- Valuation of the benefit Liabilities and Normal Cost for both Funding and Accounting Cycles as per the US laws.
- Analyzing and preparing data as required for the Valuation.
- Gain & Loss Analysis - studying experience Gain/Loss to gain or loss incurred due to assumption change.
- Asset and Funding Policy - including calculation of Minimum Required Contribution, Maximum Tax deductible contribution, Funding Shortfall, Carryover Balance & Pre funding balance, AVA Calculation.
- Asset Reconciliation.
- Generating the funding and accounting reports for the clients.
- Government filings for companies giving Post Retirement Benefits to its employees.
- Training the new recruits on ProVal & other Tools including MS-Excel and CMS on concepts mentioned above to help them become proficient in their work.

Conversion Projects - Conversions of US Pension and Medical plans from ACE (at Deloitte Consulting) to ProVal.
It involves a thorough knowledge of the plan document and the type of data that you are required to code.
Involves extensive test case checking between the outputs of two software so as to ascertain the type of discrepancy and thus reaching out for its resolution.

Software Skills :
- Proficiency in Microsoft Excel, Word, Power Point
- Actuarial Software : ProVal, ProAdmin and Deloitte’s internal Valuation software (ACE and CMS)
- Training in Statistical Analysis Software (SAS) version 9.0 including BASE SAS: SAS/Base, SAS/Macros, SAS-Analyst, SAS/Stat, SAS/GRAPH, SAS/ Plot, Warehousing

Key Skills
Accounting Expense and disclosures ACE cms data EXCEL Funding Valuation Gain Loss ProVal Reports
2008 - 2010

Aon - Actuarial Analyst

Worked on Defined Benefit pensions and Medicare Valuation for the clients across US using ProVaL and excel.

Acquainted with rules and regulations governing US Defined Benefit Plans (ERISA, PPA 2006 etc. under IRS).

Work involves :
- Funding and accounting calculations like liability calculation (Coding the ProVal to get Funding, FAS87 and FAS 35 results) for qualified, non-qualified and governmental pension plans.
- Determining actuarial Gain/loss - Liability Gain Loss (comprising demographic experience, gain loss due to plan changes and gain loss due to assumption changes)
- Asset and Funding Policy - including calculation of Minimum Required Contribution, Maximum Tax deductible contribution, Funding Shortfall, Carryover Balance & Pre funding balance, AVA Calculation.
- Performing Accounting Calculation like liability calculation (Coding the ProVal to ASC 715-30 results, Net periodic pension cost) for the pension plans.
- Data reconciliation and preparing data for the valuation purposes.
- Asset reconciliation
- Government Form filings (PBGC, 5500)
- Publishing the funding and accounting valuation report using ProVaL.

Conversion Projects : Conversions of US Pension and Medical plans from AonVal (at AON Consulting) to ProVal.
It involves a thorough knowledge of the plan document and the type of data that you are required to code.
Involves extensive test case checking between the outputs of two software so as to ascertain the type of discrepancy and thus reaching out for its resolution.

Proficient in ProVal (Winklevoss product for pension and OPEB plans) and Microsoft Office (Excel, word and power point).

Key Skills
Accounting Expense and disclosures data EXCEL Funding Valuation Gain Loss Lotus Notes Microsoft Office ProVal

Pooja Bahl's Education and Qualifications

2007

Bachelor/Degree - B.A. (Hons.), Economics

Shri Ram College of Commerce

Pooja Bahl's Additional Information