Senior Financial Consultant - CA

Duties & Responsibilities

- Day to day accurate and timely posting of transactions in Tally (JV, Payment and Receipt Vouchers) 

- Preparing and posting Payment Vouchers for Vendors 

- Extracting of data into spreadsheet and preparing monthly consolidation of accounts under Indian GAAP using analytical and excellent spreadsheet skills 

- Preparation of monthly Financial MIS 

- Preparation of Annual Budgeting (Base Budgeting) and Re- Forecasting post updating actuals

- Designing and Implementing Reporting Systems, Front Ends and Dashboards using MS Excel, as well as complex data modeling for use in quantitative statistical analysis, often within these systems as well, or separately as ad hoc reports 

- Comparing Analytical monthly variance reports Budgets vs Actuals and applying analytical reasoning skills to identify reasons for variances 

Required Knowledge, Skills & Abilities - 

- Proven experience of working with voluminous data and on ground experience of Finance and Accounting 

- Excellent knowledge of Taxation and Statutory Levies with specific accounting calculations 

- Advanced Microsoft Excel user (candidates having knowledge of VBA applications, Power Query, BI -Business Intelligence and Financial & Data Modelling would be added advantage), PowerPivot, Scenario Analysis, KPIs and Dashboards 

- Excellent spreadsheet skills with working knowledge of Macros Superior analytical skills practiced at drilling down to Transaction/ Workflow Details Specialist in MS PowerPoint, Data Analytics 

- Candidate should have exposure into Microsoft Excel System-Lifecycle Design & Analysis, Project Management, incl. Business Systems Analysis, System Development & Design, Programming & Macro Automation, Pivot Tables, Lookups & External Imports/Exports

Experience & Qualification

- 3-5 Years at similar position.

- CA/ Pursuing CA(Article ship exp won- t be counted)/ MBA-Finance