Excel
MBA finance- 11 years of work experience is FP&A,
forecasting, Budgeting, Financial reporting, variance
analysis, Reconciliation of client custodial statement,
costing, Balance sheet analysis, with excellent
working Knowledge of MS office suit and proficient
in COGNOS tool, Advanced Excel, SQL, Power BI
and python, SAP knowledge. Seeking a challenging
role to leverage expertise and contribute to the
success of organization.
Budgeting /Forecast Preparation:
Pre-closure/Variance Analysis:
Referential validation/Mapping
Management accounting:
Audit:
Preparing all supporting documents for P&L and Balance sheet accounts to certify in tool and adhere with banking norms and Group control frameworks.
Dashboard using MS Excel for management reporting
Participates in quarterly forecast and annual budgeting process
· Works close with Financial Planning and Analysis lead and team to review and assess fiscal year projections
· Planning & Analysis tool – Anaplan
· Creates and generates monthly reporting packages and annual budget documentation
· Supports reporting and analysis needs of complex and fluid company
· Assist in ad hoc analysis and presentation for leadership
· Cost account and identifying various variance in cost elements and appropriate action for same
· Support leadership on key decision by providing data and recommendations to aid decision making with focus on revenue and profitability improvement actions
· Prepare overall Area level budgeting and forecasting and strategic financial analysis.
· Complete knowledge of SAP and data to-day financial reporting.
· Preparing and presenting financial results to leadership.
· Provide advice to help achieve targets
· Assist leaders in forecasting between operating group and growth platform for providing regular points of view for landing projections for sales, revenue and Client Controllable Income
· Budgeting and forecasting of Ocwen financials and analysis.
· Variance analysis and monitoring flow of funds from borrower to Investor by variances occurred in Custodial Accounts.
· Preparing financial reports and Reconciliation of accounts for investors and Management on monthly basis.
· Reconciliation of various complex Investors with Schedule and Actual logics by following required REGAB guidelines and timeliness.
· Work with Investor Reporting and other servicing departments to ensure all reconciling items are cleared within company guidelines.
· Settlement Activities at time of Mergers & Acquisitions.
· Documentation of cash flow and reconciliation reports for internal and external auditors of company.
· Settlement of Escrow, Escrow & Other Advance funds with Prior Servicer on newly boarded deals.
· Posting of Journal entries to complete cash flow to respective accounts & to Balance sheet.
Excel
Power BI
SQL
PYTHON
COGNOS
CITRIX,METRIX
Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Outlook Express, Access Queries
Certified training in Excel Advanced
Dancing
Astrology
Travelling
Animals lover