thomas varughese

Experienced in Dynamic Dashboard from a huge database, Data analysis, KPI / MIS Reports, Payroll study reports, Inventory management, and all other customised template for data management. 

Backup with 21years of experience in consolidating financial statements plus other management reports and handling complete books of accounts independently up to completion with zero error tolerance. Manage financial planning, budgeting - cost analysis; implement cost control measures plus liaise with bankers and auditors. Generate financial models for cash flow management. Analyse business operations, trends, costs, revenues, financial commitments, and obligations as well as new ventures, to project future revenues, expenses or to provide any other advice. Implement financial procedures, cash cycle management, internal financial controls, and costing. Skilled in directing operational and financial audits that summarize the organization's financial position; manage audit - tax-related issues. Prepare income statements, monitor financial transactions, and enter to accounting system. Classify, maintain monthly balance sheets and financial statements along with quarterly reports. Develop financial forecast for capital budgeting, AR/AP, cost accounting systems, fixed assets ledger and capital expenditure. In-depth knowledge of inventory operations and procedures. Use specialized inventory control program to handle inventory, manage re-order and agency wise product analysis. Prepare project cash flow and tracking of its actual movement.

Project wise profitability study report. Work in progress report and future invoicing plan.

Preparing sales commission as per the company policy. Handle fixed assets portfolio. Carry out constant month – year end book of accounts closing including reconciling cash book, bank book, and supplier – debtors’ ledgers. Gained comprehensive knowledge and understanding of the entire flow of business operations, its documentation requirement and subsequent financial accounting and reporting. Secured company finances by preparing accurate financial accounts and resolved discrepancies. Carried out assigned workload with indefinable enthusiasm, commitment, honesty and dedication and drove towards contributing to continued business growth. Demonstrated professionalism and strong work ethics in execution of job profile.

Gained extensive experience in MIS reports on various scenarios. Database management using Advance Excel - Macros, Advance Filter, Functions & Formulas, Pivot table, Goal Seek, Importing & exporting data, validations, Develop Excel Templates.

Skill to an advanced Excel functions which able to seamlessly write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP formulas. Apart from knowing the formulas, advanced Excel users know how to debug them, audit them and how to use which formula for which occasion that brings faster and accurate reports

Maintain constant communication with internal departments - keeping track on various correspondences and office communications to ensure smooth office operations. Proficient in MS Office Suite (Excellent knowledge of Excel (Pivot tables, formulas, macros, conditional formatting, Data validation, V / H lookup, Developer, etc.).Develop financial models to support valuation, planning, and forecasting

The ability to create auto-updating Dashboard reports allows managers to get a high-level overview of the business. dashboards are power methods that can provide analysis, insight, and alert managers in a timely manner.

Create auto-generate a visual representation of data from a worksheet that can bring more understanding to the data than just looking at the numbers. A chart is a powerful tool that allows you to visually display data in a variety of different chart formats such as Bar, Column, Pie, Line, Area, Doughnut, Scatter, Surface, or Radar charts.

Can able to analyze the most complex questions by using advanced formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP formulas, and their combinations.

Build structure & present the data so that it looks impressive. A good understanding of Excel features like tables, cell styles, formatting options is necessary to make awesome Excel workbooks. 

Bachelor of Commerce, Management Information Studies (MIS & Flow Chart functions implementation), PGDCA ( System  Management ),