Financial Analyst

9/2006 - Present

Individual Contributor

• • Involved in budget preparations of revenue and expense and also involved in Projects for operational planning. • Analyzed and uploaded key data in ITS on supply partner’s logistics, differentiating businesses locations and shipments tracking information for single or multiple shipment details. • Involved in calculation of Demurrage and Detention charges for Inbound and Outbound journeys. • Calculated total shipment cost from the port to destination and calculated cost per customer with various transportation methods. Also involved in calculating different costs like, Equipment rental cost, Freight tax cost, Transhipment commission cost, Reefer monitoring cost, and loading the same data in to oracle tables for Data ware housing (ETL) purpose. • Recorded all voyage related revenues, and expenses monitor open and work closely with other members of Shipping (e.g. Voyage Managers) to resolve voyage and billing issues. Analysis of Bank accounts and preparation of summaries for management review in Tokyo office. And prepared bank reconciliation statement and other account reconciliations as assigned. • Generated financial reports using Oracle. • Update finance statement on currency and booking Exchange rate tables monthly for financial analysis and also updating lookup tables accordingly. • Analyzed and resolved customer issues. • Analyzed the service calls to ensure that JSOX (Japanese Sarbanes Oxley) sign off requirements are met by obtaining global business project manager and other relevant approvals at different phases. • Created financial tables in Oracle using Toad / SQL Loader for loading the production data Which will be used to cleanse the business data using SQL queries in order to prepare the files for production load and also look for any dependencies

2/2005 - 8/2006

Alcoa Ltd

Individual Contributor

• • Generating financial reports and preparing bank reconciliations, using JD Edwards and Oracle Financials. • Presenting financial information in Pivot tables for management analysis and information. • Assisting in preparing Budgets, reports and financial forecasting, analysis of variances between budgeted and actual results, and providing timely corrective action. • Generation of financial and operational projections – Revenues per region and product, expenses per headcount, expenses per department and projects. • Monitored expenses to ensure compliance with budget by performing monthly variance analysis. • Coding and creation of customers, suppliers, and products in functional modules. • Generated monthly reports of Payroll summaries, sales, supplies and variances. • Month end reconciliations and closing, preparation of standard and special journal entries necessary for posting into general ledger using JD Edwards. • Using Oracle Financials for enquiries in Purchase Orders, Invoices, Payments and Receipts, ensuring Items have been received and paid for. • Processing the Freight Bills/Claims, and conducting appropriate follow-up. And also analyzing the Freight Expenses and determining the Accruals for the Month End Process • Responsible for the AR Collection and follow up for Shipments to Overseas. • Responsible for auditing Customs Invoices for accuracy on monthly Basis and ensure the Discrepancies are corrected on timely basis. • Updating Costs of the Items on regular basis using JD Edwards. • Generating Monthly A/R, A/P reports and performs filing for Managerial Review Using JD Edwards.

1/2004 - 12/2004

St. Joseph Health Care

Individual Contributor

• • Prepared standard and special journals necessary to generate monthly financial statements, as well as identified required financial data, and performed the processes required to collect data. • Analyzing and preparing financial schedules and reports for distribution to internal customers, as well as completed month-end schedules, including preparing GST returns. • Performed uploading financial and statistical data to the general ledger Using MS Access and Smart stream. • Downloading bank transaction details and preparing reconciliation statements. • Month end closings and journal entries postings and updating in general ledger. • Generating Reports for Managerial Review. • Analyzing various departmental expenses and providing analytical explanation as required

6/2002 - 12/2003

Cellfonz.Inc

Individual Contributor

• • Prepared financial statements (P&L and Balance sheet), budgets and variances, including performing in-depth analysis, handling purchases, sales, and Accounts Payable / Receivable. • Management of funds and cash flows. • Assisted Managers in the annual budgeting process and in the development of Strategic Plans. • Providing analytical explanation of actual to budget variances • Analyze departmental expenses and providing analysis for variations. • Performed accurate entry and coding of invoices, including appropriate recording of taxes, and processed stop payments, as well as cancelled checks and in addition performed month-end bank reconciliations, including reconciliations for prepaid raw materials, ensuring accurate receipt and expensing of items in a timely manner. • Maintained the shipping logs and Stock ledger. • Preparing month-end journal entries for month end closing. • Managed supplier inquiries in relation to invoices and invoice payments. • Provided consistent monitoring of credit file information, A/R lists, financial statements, updated bank and trade references, as well as checked information and obtained reports from Dun & Bradstreet. • Designed Customers and Vendors Database using Ms-Access.

1994

Master Degree

M.com

• Finance