Direct reporting line and daily interaction with the company’s Chief Operating Officer and Vice president financial planning and analysis with the following responsibilities.
• Created automated invoice from VBA to excel for the analysis and presentation.
• Coordinates in the creation of the company’s comprehensive monthly reporting package using current and previous parameters.
• Intercompany reconciliation, journal entry (depreciation, prepaid expenses, accrued expenses)
• Actively manage the advertising spend on online lead generation accounts based on the company’s specifications
• Calculate the staff’s monthly bonus pools
• Maintaining accounts on Quickbook accounting software & analysing data for the purpose of budgeting and forecasting.
• Calculate and process customer rent increases
• Coordinates and manages the creating & forecasting of annual company budgets using current and previous parameters.
• Managing billing and due days for account payable for the vendor’s service used by the company.
• Perform ad-hoc analysis as per the company’s requirement including SEO analysis.
• Automating reports and analysis based on the requirement for the view of company’s high level executive people.
• Insurance reconciliation for the employees in the company.
• Posting, managing jobs on ziprecruiter portal of the company for the employee recruitment and manpower planning, budgeting and forecasting.
• Documenting SOW (statement of work) for employees and engaging them in their sphere of work.
• Strategy development for the price fixation, expense analysis and other key areas of the company.
• Attendance marking on Octane ERP.
• Employee master data updating on octane ERP.
• Data Analysis on the pricing for the company together with other competitor’s using various tools.
• Running oracle fusion for the reporting and analysis part.
• Cash flow maintenance for funds
• Documents saving related to Private equity investors funds
• Distribution and call analysis based on payment received
• Reviewing work of fund accountants
• Capital schedule maintenance
• Mark to Market maintenance and analysis
• Unrealized cost and gains analysis
• A/R and A/P Sheet maintenance
• Maintenance of accounts on E-Front ERP
• Data Analysis for the fund’s profit/losses and as per the fund invested by the company.
• Doing analysis of companies using fundamental & technical analysis:-
1. Ratio Analysis 2. Dow-theory
3. Peer analysis 4. Balance sheet inspection
5. Discounted Cash Flow 6. Financial Modeling
• Documentation and compliance for Import and export of the goods.
• Created and maintained precise and accurate models, charts and reports.
• Monitored organization's performance against competitors.
• Built and maintained database for forecasting future financial performance.
• Identify risks associated with projects, contract approvals and other client accounting issues.