Sr. Finance Analyst (Oracle R.12)
Hassad Food
Total years of experience :28 years, 6 months
1) Understanding & documenting the business process for new companies
2) Implementing Oracle for new & existing non-oracle subsidiaries (Implemented for 6 operating units as a Project lead)
3) Conducting CRP / UAT & end user training with continuous post production support for 30 plus users to handle oracle independently
4) Support for monthly MIS reporting & consolidation
5) Monthly Sub-ledger reconciliations of AR/AP/FA & Inventory modules & resolving the differences
6) Master Data Maintenance (Customer/Supplier/Inventory Items/Setups/Options/Profiles)
7) Develop new report logic & get it placed in production, through in-house developer, after thorough testing
8) Ensure proper system controls in Oracle as per the standard benchmarks
9) Periodic Review of Oracle user responsibilities based on the role changes
10) Any time-to-time ad-hoc report analysis based on the management requirement
11) Costing analysis & update along with Sales & contribution review
12) Uploading & maintenance of yearly budgets for 6 companies & ensuring system budgetary controls (Advisory)
Responsible for implementing Oracle for six businesses (Flour, Feed, Poultry, Pasta, Pulses & Fruits) with 100% operational AR, AP, CE, FA, AGIS, GL, I-Exps, OM, OPM, EAM, Inventory & Procurement modules. Three stand-alone finance implementations done in second phase.
Implemented ERP setup in BaaN, under finance & distribution Module and finalizing various MIS reports in B.O
Responsible for monthly MIS finalization (HFM, Qlikview, Discoverer & OBIEE) along with Budgeting & Audit for 3 businesses (Flour, Feed & Poultry)
Monitoring AR, AP, Overhead analysis, Sales & Contribution analysis & budgetary variances
Monthly Sub-ledger reconciliations of AR/AP/FA & Inventory modules & resolving the differences
Providing training & support to 10 junior staffs reporting directly
Essayed a key role in the preparation of various MIS reports using Business Objects & Excel along with routine bank reconciliation, cash flow, etc.
Scrutiny of monthly J.V’s for accruals, prepayments & provisions and updating ERP Package (BaaN) along with integration log clearance.
Verification of WPS compliant salary calculation, overtime, factory production incentives (piece rates), final settlements, reimbursement & commission of various sales & support staff, as per HR policy, using ERP payroll package (HRNET & HRMS). (500 employees on roll).
• All Activities involved upto finalization of Trial Balance.
• Receiving, Tallying, Banking & Accounting of Daily Collections.
• Booking of Purchase & other Expenses.
• Receipts, Issues & Accounting of Inventory.
• Preparation of Various MIS as per H.O. requirement along with routine Monthly Stock Reconciliation, Bank Reconciliation, Fund Track Report etc.
• Preparation of Sales & Collection Analysis Report.
• Compilation of all Branch Trail Balance into Regional Trial Balance.
• Passing of necessary J.V’s & Provisions.
• Consolidation of Regional Bank Reconciliation & Stock Reconciliation.
• Preparation of Quarterly Folders for Stock, Bank, Expenses, Assets & Liabilities etc.
• Daily updation of various Integrated Online packages & Uploading the same on HO Server.
• Compliance of various Statutory payments such as Professional Tax, E.S.I.C, P.F, TDS & Sales Tax, by payment of Challans & submission of Returns in time.
• Debtors & Creditors control.
• Calculation of Salary, Reimbursement, Bonus & Commission of Various Sales & Support Staff as per policy with the help of Payroll package.
• Maintaining Statutory records such as Wages-Cum-Muster Register, Leave Register, Bonus Register, ESIC Register (Form 7) etc.
• Laisoning with Internal Auditors & Statutory Auditors.
• Compliance of Audit Observations.
• Looking after other administrative works related with Cost Control & smooth Supply & Maintenance of Inventory.
Post Graduate Diploma in Taxation (PGDT)
Accounting, Costing, Business Management, Auditing & Commercial Law
Audio & Video Electronics
Diploma in Computerized Office Management