 Budgeting, Planning & Forecasting of Sales, GP & Contribution.• Compiling revenue budgets from all profit centers and preparing first cut of Budget sheet.• Comparison and Analysis of revenue with previous year numbers.• Analysis of all revenue drivers.• Preparation of Direct Cost & Other Overheads Budget Sheet.• Submitting the Budget Sheet to Finance.• Preparing quarterly Forecast on the basis of Budget and Current Run rate. Monthly and Weekly Revenue… Show more  Budgeting, Planning & Forecasting of Sales, GP & Contribution.• Compiling revenue budgets from all profit centers and preparing first cut of Budget sheet.• Comparison and Analysis of revenue with previous year numbers.• Analysis of all revenue drivers.• Preparation of Direct Cost & Other Overheads Budget Sheet.• Submitting the Budget Sheet to Finance.• Preparing quarterly Forecast on the basis of Budget and Current Run rate. Monthly and Weekly Revenue Tracking• Preparing Weekly and Monthly Revenue Reports.• Gap Analysis in case of lesser Revenue.• Tracking Debtor provisions on monthly basis.• Compiling responses for Manual Adjustments in revenue. Weekly MIS• Sending Weekly MIS Report to PD"s of all BPS and DA service lines - Every Tuesday and Utilization report to Resource Management.• Preparation of Weekly Pipeline Dashboard for Strategy Function.• Preparation of Weekly MC Sales Call Report. Other Reports• Preparation of reports from CRM (e.g. TOP wins, Active Pipeline, Blu-sky etc.)• Preparation of periodic and ad-hoc reports / other requirements as per business needs for all SLs in MC.• Preparation of Cost Reports and identify areas of savings - eg: PMC, Occupancy Excel Automation• Prepared Automated Budget sheet with all Profit Centre• Prepared Automated Weekly Update revenue report.• Prepared Automated Weekly MIS Reports.• Prepared Auto mailer sheet to send Bulk Emails. Others• Supporting PM in MC with required Analysis / Report / Decks• Writing mails to all to get MC collection Commitment.• Prepared Automated Weekly MIS Reports.• Prepared Auto mailer sheet to send Bulk Emails. Show less

 Budgeting, Planning & Forecasting of Sales, GP & Contribution.• Compiling revenue budgets from all profit centers and preparing first cut of Budget sheet.• Comparison and Analysis of revenue with previous year numbers.• Analysis of all revenue drivers.• Preparation of Direct Cost & Other Overheads Budget Sheet.• Submitting the Budget Sheet to Finance.• Preparing quarterly Forecast on the basis of Budget and Current Run rate. Monthly and Weekly Revenue… Show more  Budgeting, Planning & Forecasting of Sales, GP & Contribution.• Compiling revenue budgets from all profit centers and preparing first cut of Budget sheet.• Comparison and Analysis of revenue with previous year numbers.• Analysis of all revenue drivers.• Preparation of Direct Cost & Other Overheads Budget Sheet.• Submitting the Budget Sheet to Finance.• Preparing quarterly Forecast on the basis of Budget and Current Run rate. Monthly and Weekly Revenue Tracking• Preparing Weekly and Monthly Revenue Reports.• Gap Analysis in case of lesser Revenue.• Tracking Debtor provisions on monthly basis.• Compiling responses for Manual Adjustments in revenue. Weekly MIS• Sending Weekly MIS Report to PD"s of all BPS and DA service lines - Every Tuesday and Utilization report to Resource Management.• Preparation of Weekly Pipeline Dashboard for Strategy Function.• Preparation of Weekly MC Sales Call Report. Other Reports• Preparation of reports from CRM (e.g. TOP wins, Active Pipeline, Blu-sky etc.)• Preparation of periodic and ad-hoc reports / other requirements as per business needs for all SLs in MC.• Preparation of Cost Reports and identify areas of savings - eg: PMC, Occupancy Excel Automation• Prepared Automated Budget sheet with all Profit Centre• Prepared Automated Weekly Update revenue report.• Prepared Automated Weekly MIS Reports.• Prepared Auto mailer sheet to send Bulk Emails. Others• Supporting PM in MC with required Analysis / Report / Decks• Writing mails to all to get MC collection Commitment.• Prepared Automated Weekly MIS Reports.• Prepared Auto mailer sheet to send Bulk Emails. Show less

 Budgeting, Planning & Forecasting of Sales, GP & Contribution.• Compiling revenue budgets from all profit centers and preparing first cut of Budget sheet.• Comparison and Analysis of revenue with previous year numbers.• Analysis of all revenue drivers.• Preparation of Direct Cost & Other Overheads Budget Sheet.• Submitting the Budget Sheet to Finance.• Preparing quarterly Forecast on the basis of Budget and Current Run rate. Monthly and Weekly Revenue… Show more  Budgeting, Planning & Forecasting of Sales, GP & Contribution.• Compiling revenue budgets from all profit centers and preparing first cut of Budget sheet.• Comparison and Analysis of revenue with previous year numbers.• Analysis of all revenue drivers.• Preparation of Direct Cost & Other Overheads Budget Sheet.• Submitting the Budget Sheet to Finance.• Preparing quarterly Forecast on the basis of Budget and Current Run rate. Monthly and Weekly Revenue Tracking• Preparing Weekly and Monthly Revenue Reports.• Gap Analysis in case of lesser Revenue.• Tracking Debtor provisions on monthly basis.• Compiling responses for Manual Adjustments in revenue. Weekly MIS• Sending Weekly MIS Report to PD"s of all BPS and DA service lines - Every Tuesday and Utilization report to Resource Management.• Preparation of Weekly Pipeline Dashboard for Strategy Function.• Preparation of Weekly MC Sales Call Report. Other Reports• Preparation of reports from CRM (e.g. TOP wins, Active Pipeline, Blu-sky etc.)• Preparation of periodic and ad-hoc reports / other requirements as per business needs for all SLs in MC.• Preparation of Cost Reports and identify areas of savings - eg: PMC, Occupancy Excel Automation• Prepared Automated Budget sheet with all Profit Centre• Prepared Automated Weekly Update revenue report.• Prepared Automated Weekly MIS Reports.• Prepared Auto mailer sheet to send Bulk Emails. Others• Supporting PM in MC with required Analysis / Report / Decks• Writing mails to all to get MC collection Commitment.• Prepared Automated Weekly MIS Reports.• Prepared Auto mailer sheet to send Bulk Emails. Show less

 Monthly accounts closing for reporting and annual accounts closing upto finalization.• Balance Sheet and Profit/Loss Statement with Schedules in Vision Excel.• Monthly MIS report preparation for management.• Monthly and annual provision entries preparation.• Monthly and annual schedule of each general ledger.• Comparing monthly & YTD Budget & Forecast with actuals.• Daily & Monthly Bank Reconciliation.• Department wise Budget & Actual Comparisons month on month for… Show more  Monthly accounts closing for reporting and annual accounts closing upto finalization.• Balance Sheet and Profit/Loss Statement with Schedules in Vision Excel.• Monthly MIS report preparation for management.• Monthly and annual provision entries preparation.• Monthly and annual schedule of each general ledger.• Comparing monthly & YTD Budget & Forecast with actuals.• Daily & Monthly Bank Reconciliation.• Department wise Budget & Actual Comparisons month on month for RO reporting.• Schedule preparation of advances/deposits and taking confirmations.• Ledger scrutiny and passing necessary rectification entries. • Foreign Income/Expenses, rent straight lining and other schedules for notes to accounts. Automation in MS Excel using VBA coding (Macro).• Auto daily Bank Reconciliation Statement preparation.• Data Entry form creation in MS excel using VB Macros.• Auto Fixed Deposit Schedule preparation with UDF FD interest.• Other auto MIS reports preparation using VBA Macro Banking, Cash Flow & FD Management• Cash flow statement preparation for FD placement on daily basis• Future cash flow statement preparation.• FD Investment and Divestment on maturity.• Monthly accrued interest calculation. Taxation and Foreign Remittance• Monthly TDS/WCT Payments.• Quarterly/Revised TDS return filing using TDS Pac.• Various documents preparation for Foreign Remittance. Other Routine Works. • Verification of expense accounting entries in system.• Preparation of Reports for Auditors in finalization.• Preparations of all other reports in excel using macros. Show less

 Implementation of Accounting & Finance System (Sun System).• Defining & Uploading the Master Values in the system.• Creation of Master Reports in Vision Excel (e.g. Schedule VI, Other MIS Reports)• Migration of back-dated Accounting Transactions. Monthly accounts closing and annual accounts upto finalization.• Balance Sheet and Profit/Loss Statement with Schedules in Vision Excel.• Cash flow preparation in both direct and indirect method.• Preparation of monthly… Show more  Implementation of Accounting & Finance System (Sun System).• Defining & Uploading the Master Values in the system.• Creation of Master Reports in Vision Excel (e.g. Schedule VI, Other MIS Reports)• Migration of back-dated Accounting Transactions. Monthly accounts closing and annual accounts upto finalization.• Balance Sheet and Profit/Loss Statement with Schedules in Vision Excel.• Cash flow preparation in both direct and indirect method.• Preparation of monthly and annual provision entries.• Monthly and annual schedules of each General Ledger.• Comparing monthly & YTD Budget & Forecast with Actual.• Daily & Monthly Bank Reconciliation.• Department wise Budget & Actual Comparisons month on month.• Maintaining Asset Register & Depreciation calculation every month. Automation in MS Excel using VBA coding (Macro).• Auto daily Bank Reconciliation Statement preparation.• Auto entry upload in Sun System using macros• Auto email sending of employee reimbursement advice.• Auto Fixed Deposit Schedule preparation with FD interest formula creation.• Auto Monthly TDS report to upload in TDS Pac Yearly Budget and Quarterly Forecast Reports• Preparation of Budgeted/Forecasted Balance Sheet, Profit/Loss Statement & Cash Flow Statement.• Department wise Budgeted/Forecasted Profit & Loss Statement.• Review of Budget/Forecast. Monthly Budgeted Cash Flow Report for Funding Requirements. Sun System Accounting • Costing & Allocation of Routine Expenses.• Development of New Templates to smooth the work.• Reconciliation of Ledger Accounts Other Routine Works • Preparation of Reports for Auditors in finalization.• Preparations of all other reports in excel using macros. Show less

 Processing of Contractors bill, payments & routine office exp. Payroll processing for all the branches.• Salary• Computation of Income of all employees.• Personal Claims, LTA, Medical etc. Weekly Cash Flow Statement Bank Reconciliation Statutories TDS Payments such as Salary, Contractors, Professional etc. Filing of Salary Returns FBT Calcluation and Payments. Payments of PT, PF, ESIC, MLWF etc. MIS Outstanding of contractors on… Show more  Processing of Contractors bill, payments & routine office exp. Payroll processing for all the branches.• Salary• Computation of Income of all employees.• Personal Claims, LTA, Medical etc. Weekly Cash Flow Statement Bank Reconciliation Statutories TDS Payments such as Salary, Contractors, Professional etc. Filing of Salary Returns FBT Calcluation and Payments. Payments of PT, PF, ESIC, MLWF etc. MIS Outstanding of contractors on weekly basis. Monthly Salary reports. Power & fuel, telephone, Electricity reports. Co-ordination in Finalization.• Preparing various reports as per requirement. Show less