raunaq shah

*  Preparation of consolidated balance sheet, income statement and cash flow statement of company with revenue of $250 million as per U.S GAAP and Indian GAAP *  Assist in the Capex reporting, analysis and forecasting for manufacturing division *  Preparation of monthly net sales, cost of goods sold, inventory valuation, AR aging, and consolidated financial reports for disclosure to bank *  Preparation of monthly financial statement analysis and variance analysis of balance sheet, income statement and cash flow statement for the Board; actual against budget and forecast *  Extensively involved in implementation of Oracle for AR,AP, and GL/Financial reporting modules *  Liaison and co-ordinate quarterly collateral review audits with the financier *  Assisted GM finance in reconciliation of pending customer credit of worth $15 million *  Credit analysis of customers for charge backs, price difference, product returns, and shelf stock adjustments

 Educated students with computer related issues: MS Word, MS Excel, MS PowerPoint, MS Outlook, and Blackboard.  Researched and prepared manuals to educate users on SharePoint’s feature

*  Performed balance sheet analysis and interpreted financial statements of various public companies with market cap of more than Rs 250 crore *  Performed valuation analysis on public companies using discounted cash flow and dividend discount model *  Re-engineered and improved the Balance Sheet reconciliation Excel template to be more automated and robust with checks in place so less scope for errors *  Recorded, classified, and summarized financial transactions and events in accordance with Indian GAAP *  Assisted with financial planning by analyzing client’s current investment income, liabilities, and risk tolerance to provide advice on asset allocation *  Developed 3-year and 5-year pro-forma financial statements for forecasting, trending, and result analysis

*  Assisted in overview of credit review analysis, including examining loan structure, performing risk analysis, reviewing documentation, and evaluating financing alternatives *  Prepared of presentation slides for the monthly financial update and associated analysis on key metrics to senior management team and the Board *  Analyzed company’s financial needs and worked with management to raise capital of Rs100 crore *  Analyzed the impact of debt and equity financing on capital and ownership structure *  Prepared and finalized balance-sheet, profit & loss account and management reports for clients *  Reviewed cost and performed cost benefit analysis related to projects and programs

* Financial Planning and Analysis ( FP&A ) * Preparation of Operating budget/forecast and long term projections * Mis & Data submissions * Data to external agencies e.g. CEA, Planning commission * Preparation of regulatory data for submissions to CERC and GERC * Preparation annual and quaterly Regulatory P&L * Computation of quaterly FPPPA * Preparation of annual and quaterly financials * Analysis of variance in annual and quaterly financials * Advance Tax working