SUMMARY:

• A dedicated Finance and Accounting professional seeking an opportunity in Bay - Area with professional growth, where I can leverage my Accounting, Finance and Oracle ERP knowledge & experience gained.
• Experience in the area of Accounting & Finance.
• Experience with System Administration (Sys Admin), General Ledger (GL), Account Payables (AP), Fixed Assets (FA), Account Receivables (AR), Cash Management (CE) and I-Expenses using R12 Oracle E-Business Suite.
• Working Knowledge in Procure 2 Pay (P2P) and Order 2 Cash (O2C) Cycles.
• Co-ordinate and follow with offshore team to accomplish the milestones as per project time line.

FUNCTIONAL SKILLS:

• Good insight into the functionality of Oracle General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Purchase Order (PO), Order Management (OM), Inventory (INV).
• Good functional expertise on Open Interfaces (inbound and outbound interfaces) in Oracle Financials.
• Exposure to Accounting Business Practices used in Oracle GL.
• Very good practice and experience in setting up and customizing Accounting Flex-field of General Ledger based on the Organization’s business setup.
• Adept in planning Security rules and Cross validations for GL, AR, AP Flex-fields.
• Experience in working with Enter Journals, Post Journals and Posting Programs, good understanding of Journal Entry Headers and Lines model.
• Insight into AR Transactions and Receipts process flows and setups.
• Proficient with the architecture of Global Descriptive Flex fields and various Common Country Features.

TECHNICAL SKILLS:

Oracle Application-E-Business SuiteR12: Oracle Application Modules- Oracle General Ledger (GL), Accounts Payables (AP), Account Receivables (AR), Fixed Assets (FA), Cash Management (CM), Order Management (OM) Purchasing (PO) and Reporting - FSG, Web ADI. SQL, PL/SQL, forms, reports, Discoverer, XML Publisher

EXPERIENCE:

Oracle ERP Functional Consultant Trainee

Confidential, Old Bridge, NJ

Responsibilities:

• Managed & Overlooked Finance & Administration division which includes Accounts Payable, Accounts Receivable, Cash management and Payroll. Financial Statement preparation with the CPAs for Tax purposes.
• Ensure an accurate and timely monthly, quarterly and year end close. Ensure the timely reporting of all monthly financial information. Ensure the accurate and timely processing of positive pay transactions. Ensure the monthly and quarterly Bank Compliance activities are performed in a timely and accurate manner.
• Co-ordinates the annual independent audit including preparing financial statements which are audited.
• Files reports necessary to comply with State and Federal law.

Confidential, Cranbury, NJ

Oracle Functional Analyst

Responsibilities:

• Involved in implementation of Oracle Applications Financial R12 GL, AP,AR and CM modules.
• Involved in requirement gathering and analysis and design of the application.
• Worked with the consulting team to make them understand the current Business Process.
• Created responsibilities assigned to users and set profile option.
• Configured GL, AP modules in R12 Environment.
• Responsible for the implementation of Receivables (AR) & E-Business Tax.
• Set-up of invoices, debit and credit memos, guarantees, deposit transaction types.
• Defined Tax Regimes, Taxes, Tax Status, Tax Jurisdictions, Tax Rates, Party Tax Profiles, Tax Zones in E-Business Tax (EB- Tax).
• Implemented Automatic Bank Reconciliation functionality in CM.
• Implemented Auto Lock box Functionality in AR.
• Configured Transaction types, Sources, Receipt classes, Sources, Banks and Bank Accounts
• Involved in development of test plans and scripts and conducted testing for quality assurance.
• Worked on requirements gathering, gap mappings, and various functionalities in General Ledger.
• Working on Payables and Cash Management setups and issues.
• Determined business requirements for integration, including review of Chart of accounts to ensure adequate coverage for financial and statutory reporting.
• Prepared Module design (MD050) Documents for Customizations.
• Worked on Setting up and customizing dunning letter, statement cycle in Accounts Receivable module.
• Developed FSG Reports in GL like (Income statement, Dept. Expenses, Inter Company Summary).

Environment: Oracle Application R12, Oracle General Ledger, Oracle Payables, Oracle Receivables, Cash Management & Fixed Assets,EBTax.

Confidential, Cranbury, NJ

Senior AR Analyst

Responsibilities:

• Managed and coordinated all activities of the Accounts Receivable / Collection departments.
• Implemented new procedures to increase the progress and efficiency of AR/AP departments..
• Posting all cash receipts, discounts, allowances, price difference, returns and other charge backs to customer accounts timely and accurately .Maintain up-to-date billing system.
• Follow up, collection and allocation of payments. Carry out billing, collection and reporting activities according to specific deadlines. Maintaining thorough, well organized accounts receivable customer files.
• Research and negotiate chargeback claims. Reconciliation of accounts. Monitoring customer account details for non-payments, delayed payments and other irregularities. Track and investigate deductions (charge backs) from customer payments.
• Process Debit Memos to invoice or re-invoice for any adjustment.
• Maintain accounts receivable customer files. Follow established procedures for processing receipts, cash etc. .Prepare bank deposits.
• .Ensure and maintain returns being processed in warehouse and make sure the chargeback amount does not exceed the total authorized amount. Investigate and resolve customer queries. Process adjustments.
• After warehouse generates the receiving reports, run the credit memos in the sales order module and make sure the credit amount is reflected on customer’s account.
• Perform other accounting duties as Requested. Organizing a recovery system and initiate collection efforts. Communicating with customers via phone, email, mail or personally.
• Gained solid understanding and Application of GAAP & SOX Requirements.

Confidential, Bridgewater, NJ

Senior Financial Analyst

Responsibilities:

• Supporting the Alliance Evaluation Control Group regarding Royalty calculation, Preparing Fund Transfer Forms Monthly and Quarterly, as per Contract terms and conditions.
• Assisting in monthly closing activities including preparation of journal entries.
• Maintain Payment metrics and tracking systems for Wire Payment Agreements.
• Preparing Accounts Reconciliation for Different Accounts.
• Requesting Fund for Wire Transfer for Different Alliance Partners.
• Assist with special projects with Excel V-Lookup & Pivot table.

Confidential, Kenilworth, NJ

Senior Financial Analyst

Responsibilities:

• Assisting in monthly closing activities including preparation of journal entries, detailed summary reports and commentary for management’s review
• Interface with GIT, GSS and GSCM to coordinate and develop Requests for Proposal (RFPs) for outsourced services.
• Monitor ongoing Capital Expenditure Project related to various site.
• Monitor and evaluate budget variance report, and identify key areas for cost improvement. Assist in preparation of the annual operating budget with the oversight from the Global Support Functions’ managers.
• Participate in business partners’ staff and communication meetings as needed to facilitate understanding of performance business drivers and key operational issues.
• Assist Global Support Functions management with analysis of capital projects.

Confidential, Edison, NJ

Financial Sales Representative

Responsibilities:

• Responsibilities as includes calling policy holders to explain the terms and conditions of the policies, calculate premium, customize the insurance programs which also covers a variety of risks and helped the clients.
• Sell various types of insurance to individual or business.
• Developed and maintained the new accounts.
• Ensure that the requirements are fulfilled.
• Obtain and provide information when claims are made.
• Defined Set of books, accounting flex field structure.
• Setup Accounting Calendar; Allow Dynamic Inserts, Account Combination, and Ledger.
• Define Cross Validation Rules, Open Periods, Ledger Set, Data Access Set, Definition Access Set, Rollup Groups,
• Mass Allocation, Conversion Rates, Types of Journal, Journal Categories, Creating Journals, Journal Batch Creating Multiple Journal in a Batch
• Journal Source and Journal Import, Primary and Secondary Ledger, Revaluation and Translation.
• Steps to Process the AP Invoice,
• Setup Suppliers, Distribution Set, Tolerances Level.
• Hold and Release, Expense Reports, Itemization.
• Bank Setup, Bank Charge Calculations, Interest Rate, Payment Administration
• AP-AR Netting.
• Open Periods, Payment Terms, Transaction Types.
• Auto Invoice, Customer Profile Classes.
• Memo Lines, Invoicing and Accounting Rules, Receivable Activities.
• Application Rule Set, Auto Cash Rule Set, Distribution Set, Approval Limits.
• Auto Accounting, Revenue Recognition.
• Receipt Sources includes receipts Class, Payment Method, Bank Account.
• Lock Boxes, Collectors, Aging Periods
• Key setups like Flex fields, Organization, Inventory Parameters, UOM, Sub inventory, stock locator, Item Attribute control, Item Template and Transaction Type
• Established Item Category and Item Cataloging for their products.
• Defined a ABC Analysis and Cycle Count
• Established Customer Item and Customer Item Cross Reference
• Setup stores, Punch outs to suppliers, catalogs, mapping catalogs to purchasing categories, and defined expense account rules in I-Procurement
• Unit testing of Purchasing (P2P) cycle, I-Procurement, Inventory modules
• Shipping Parameters like picking rules, pick slip grouping rules, release sequence rules for Order Management
• Setup Modifiers and Qualifiers in Advance Pricing.
• Setup the pricing attributes in Advance Pricing
• Setup the Dynamic formulas for pricing in Advance Pricing.
• Setup the Attribute mapping in Advance Pricing
• Define the Approval Hierarchies in Purchasing module
• Worked on the Procure to Pay Business flow enhancements
• Worked on setting up the Document Control and Security
• Developed the Back to Back and Drop Ship Order process involving OM and PO
• Configured the Auto Create functionality in Purchasing
• Configured the Buyers Work center in Purchasing
• Worked on setting up a centralized receiving process in Purchasing.
• Defining Flex field, Profile options, System parameters, Document Sequences
• Set up Transaction Types, Applying & Releasing Holds, Credit Checking
• Advanced Pricing, Price List, Pricing Agreements, and Pricing Attributes
• Defining Modifiers, Qualifiers, GSA Price List, Pricing Formula
• Defining Standard, Internal, RMA and Drop shipment Orders
• Define Pick Release, Pick Release rules, Shipping Parameters
• ATO & PTO Models, ATP Checking, Availability & Reservation

Environment: GL, Accounts Payables, Order Management, Advance Pricing, Inventory, I-Procurement, Accounts Receivables, Purchasing module.