SUMMARY:

• Over 19 years of post - qualification experience which includes:
• Over 6 years of experience in the Advertising industry handling independently the finance function and MIS
• 5 years of experience in the field of Audit
• Over 8 years in Implementing and supporting ERP applications - JD Edwards EnterpriseOne - Finance Modules.
• Oracle certified JDE Functional Finance Consultant
• Worked on International and domestic clients like Confidential, GE Oil and Gas, Mallinckrodt, Kulicke & Soffa, Confidential and KEC International for JDE-Finance Module.
• Worked on Oracle assignment for creating an Accelerate solution for the Retail Industry in ASEAN market.
• Good interpersonal and communication skills, having dealt with diverse professionals, clients & team members.
• Vibrant team player with belief in taking positive approach towards issue resolution.

TECHNICAL SKILLS:

Basic Skills: Oracle s JD Edwards EnterpriseOne Functional Consultant in Financial modules

Modules handled: G/L, A/R, A/P, Fixed Assets and working

Versions worked: 1. EnterpriseOne 9.1, 8.11, ERP 8.0

PROFESSIONAL EXPERIENCE:

Confidential

Lead Consultant -JD Edwards (Finance)

Responsibilities:

• Business Process Mapping and data extraction for the migration for the enterprise system involving areas of manufacting, Sales and distribution and Finance.
• Building a conversion strategy for data cleanup and data mapping with business users and other IT teams.
• Conversion of all master data setup and data purge strategy and rollout.
• Site closure and post migration activities of support with interfaces.
• Adhoc triage by building queries for quick data analysis for business users.
• Dual responsibility of Finance functional lead and project management for offshore team deliverables.
• JDE Application Support:
• New Requirement Analysis, Feasibility study and development of the same.
• Functional JDE Support mainly Across 7 countries
• Analyze, Prioritize, and Address Problem Requests (PR) & Enhancements; and ensure Resolution per applicable SLA levels
• Sign off on Functional Specifications and Documents - Manuals, Cheat-Sheets, Logic Abstraction
• Work closely with business users and client CIO to understand the Strategy for IT
• Understand and resolve interface related issues - setup or data related
• Reports Development using World Writers and FASTRs.
• Functional Issues: G/L Batch correction, Account revisions etc.
• AAI and DMAAI set up, its maintenance and revisions.
• Integrity Report (Finance & Distribution) its analysis and solution.
• Month-end and Year-end operations.
• Support Finance team over month end and Quarter ends to close the books in JDE involving Batch Posting related errors and data reconciliation between JDE and Data warehouse.
• Support business users for any new functionality rolled out.
• Maintaining the performance and availability of existing application programs for business at higher priority.
• Prepare Application Support Manual for the Application after analyzing the above documents.
• Provide clarifications for onsite/business queries.
• Prepare plans/knowledge transfers for the newly inducted users.

Confidential

JD Edwards Functional Consultant (Finance)

Responsibilities:

• As a part of the Business process group for financial process, studying the business process of Mallinckrodt as the whole and then studying the set-up, processing options etc in totality in E1 and help them in improving the procedural flaw and improving the procedural controls.
• For system integration projects, developed future state process flows for business processes for Account Payable and coordinated user unit, regression, and end-to-end testing.
• Helped in documentation of the entire Account Payable process involving from Vendor setup process to AP voucher matching to AP payment process and AP month end closing process.
• For their Pre and post Go live for Mallinckrodt - Panama and Asia Pac ( Hongkong and Korea) helped in end-to-end testing in areas like Account, Receivable, Fixed Assets and Supply chain & Sales Order Management ( from accounting impact angle) and General ledger.
• Helped in documentation for addition to Chart of accounts.
• Study the issues listed by the users and find solutions/workaround without customization, as far as possible i.e. by providing the documentation of Exchange rate upload from excel to application P0015z1).
• As a Finance consultant for E1 Implementation team, helped in setting the AAI, DMAAI and Fixed asset setup for Chile and Colombia.
• Helped in CRP end user testing for Account Payable and Fixed Asset.

Confidential

JD Edwards Functional Consultant (Finance)

Responsibilities:

• Providing daily support to different regions - Asia Pacific, Middle East and Europe for Finance module
• Providing support to the client during quarterly and yearly audits and solve issues such as trial balance mismatch, different integrities - AP/AR/FA etc, batch errors. Quarterly/ Yearly Reports mismatch
• Hands on experience on Service Rental Module and its interconnectivity with FA module
• Better understanding of Procurement and Sales modules
• Creating New Co. / Business unit and to complete the entire set ups.
• Resolving issues of third party software (Acorde, Ecnet etc) interfaced with JD Edwards.
• Providing solution through Showcase query & GL inquiry as per client requirement.
• Writing SQLs to update records when needed.

Confidential

Business Consultant

Environment: Platform: JD Edwards 8.12

Responsibilities:

• Understanding the retail business for Singapore market
• GL - Entire Company and business unit setup with address book update, constant setups, creating chart of accounts, AAIs, ledger setups, next numbering, document setups, multicurrency setup and currency restatement (both detailed and balance) and testing of the same.
• AR - Standard setups like customer master, address books update, setting constants, creating payment terms, setting AAIs, Manuals and Auto receipts and Credit and Collection Management process.
• AP - Standard setups like supplier master, address books update, setting constants, creating payment terms, setting AAIs, Automatic Payment Process and electronic fund transfers (EFT), payee control.
• Fixed Assets - Standard setups like setting constants, asset groups, setting ledger types, Depreciation rules, disposal rules, AAI’s setting, etc.
• Preparing the Process / Setup manuals and detail CRP scripts

Confidential

Finance Consultant

Environment: JD Edwards 8.10

Responsibilities:

• Solved various day-to-day support issues faced by the client.
• Worked on customizing Automatic Payment Process
• Created specifications for customizing various reports as per the business requirements given by the client.
• Worked on Documentation. Studied the company processes and prepared JD Edwards user manual on G/L, A/R, A/P and F/A modules giving detailed explanation of the applications.
• Solved integrity issues faced by the client that facilitated them to close the financial year.

Confidential

Finance Consultant

Environment: Platform: JD Edwards - Worldsoft

Responsibilities:

• Upload of HRPS (Payroll) data for multiple months.
• Upload of Open AP and AR for 3 Cos (SYSTIME India, SYSTIME UK and SYSTIME Japan).
• Created specifications for customizing various reports as per the business requirements (Financial Statements and VAT reports as per Statutory formats)
• Prepared the data to be uploading as per “Z”file format.
• Checked the validity of data to ensure that correct data was uploaded.
• Worked with the developers in the data upload and ensured that the data was correctly uploaded in tables F0911Z1, F0311Z1, F0411Z1, F0311, F0411 and F0911.

Confidential

Finance Consultant

Environment: Platform: JD Edwards 8.10

Responsibilities:

• Worked on G/L issues like making corrections to batches with errors, assisting user in various JD processes like voiding journal entries, running trial balance and other reports
• Resolving G/L integrity issues and also G/L to A/R, G/L to A/P and G/L to F/A integrity issues
• Creating functional specifications for new customized reports (Cash Flow Statement) and changes to existing reports
• Understanding the existing structure and solving the day-to-day issues for the client in Accounts Payable, Accounts Receivables, and General Accounting. Generating specific customized Reports
• Resolving G/L integrity issues and also G/L to A/R, G/L to A/P and G/L to F/A integrity issues
• Understanding the functional requirements
• Helped in purging of transaction tables related to Finance - General Ledger module, Account receivable module, Account payable module and Fixed asset module

Confidential

Sr. Accountant

Responsibilities:

• Monthly income finalization on all India level
• Handling independently all India level - job ( project ) costing, estimation, billings, analysis of job profitability
• Supplementing & complementing the Servicing teams in debtors management
• MIS for HLL /Mindshare - Fulcrum reporting (Estimated spends, RMS, & Unbilled for month ends)
• Meeting SOX requirements for Billings & Receivables
• Approval of project costs.(mainly creative cost & HLL)
• Assisting in Finalization of Accounts and Internal Audit
• Handling accounts of liasioning offices & ensuring that RBI guidelines are adhered toHandling Internal audit of companies like SHCIL, etc
• Handling NAV audit of Mutual fund like Indbank Offshore fund.