Oracle Functional Consultant

Career Profile:

Over 19 years (Including 14+ years of Strong skills in Financials on Oracle Application) of experience in the finance and IT fields in international environment.
Able to manage full life cycle Implementation of Oracle Financials / Distribution projects with Strong skills in Oracle Applications (12.1.1/12.0.3/11i/11.0.3/10.7) - Involved in Release 12 Implementation
Firm ability to research, analyze and translate complex business and technical information to stakeholders and developers at all levels of the organization. - Extensive experience in handling client related process and mapped in terms of Oracle
Maintained proactive interaction with the client to understand business practices to aid in system configuration - Liaison between Business community, development team and cross functional Line of Businesses
Excellent Knowledge in Multiple Currencies and Multiple Reporting Currencies and Revenue recognition including Knowledge of LogicalApps and provided extended hands-on help to internal SOX audit team
Experienced in working within the realms of custom development and “off the shelf”
application configuration and customization. Experienced with working with in house, near-shore, and off-shore development teams.

• Summary:

Handled R12 implementation at Cortina systems as core functional consultant with hands on experience on SLA and E-Biz Tax
Hands on experience in preparing document starting from identifying business requirement till the end User manual based on custom functionality and also prepared document to handle Corporate Training
Worked on Oracle Applications related scoping and assessment (as-is and to-be analysis)
Designed customized reports, fit gap analysis and all documentation and deliverables.
Designed interface/conversion mapping, pre-production testing, post production validations, and related documentation and deliverables
EXperience:
Aug-2011 till date
Confidential, CA
Involved in Revenue and Classification Project
Design & develop solutions to meet SEC reporting requirement with regards to revenue and COGS account classification and reporting
Involved in analyzing impact of changes in existing customization and building business approach for achieving result relating new Item process, revenue recognition
Involved in review and co-ordinate activity relating new Item, Order management and revenue process
Managed users testing and involved in development of new customization
Understanding the requirement with regards to Inter-Divisional revenue process

• Environment: Oracle Applications 11.5.10, Oracle 10g

Feb-2011 – Jul-2011
Confidential, CA
Involved in Chart of Account Redesign Project
Design & develop solutions to meet requirement relating issue with existing accounting flexfield structure
Involved in analyzing impact of changes, business approach for process re-evaluation, testing of Oracle Modules (GL, AP, AR, FA, Rewriting FSG)
Successfully implemented changes without having impact in past financial data
Managed users testing with upstream and downstream system (Ariba, Workday, Concur, Serengeti, Essbase etc)
Involved in design document for Inventory and Asset Tracking requirement

• Environment: Oracle Applications 12.1.1, Oracle 10g

Jun-2009 – Feb-2011
Confidential, CA
Involved in support of Oracle Application module – GL, AP, iProcure, iExpense PO, AR and FA
Worked on Oracle support for resolve issues relating to customization
Provided recommendation to functional and technical team for cross functional area during rollout of Inter-Company accounting using functionality Treasury Module.
Delivered operational analysis, business process re-evaluation, user training, and testing of modules relating iExpense rollout for USA
Involved in application support, Identify issues and reach to solutions relating to customization as well as standard functionality for modules like GL, AP, PO, IProcurement. Order Management, and FA
Involved in application testing of Real Application Cluster environment
Involved in order and revenue process in controlled customized process based on Yahoo need

• Environment: Oracle Applications 11.510, Oracle 10g

Jan-2008 – Jun-2009
Confidential, CA
Involved as a Functional Consultant in LogicalApps and SOX audit Projects

• Worked as a lead for integration Project for Merger of newly acquired entity for GL, AP, FA, PO and GIS

Design & develop solutions to meet requirement relating to LogicalApps / Sox Customization
Involved in review and co-ordinate all activity relating to quarterly Sox Audit and testing LogicalApps solution
Conducting System & Integration testing & Troubleshoot system issues relating to production support
Involved in application support, Identify issues and reach to solutions relating to customization as well as standard functionality for modules like GL, AP, PO, Iprocurement and FA
Involved in Merger & Acquisition projects for integrating newly acquired company into Oracle ERP relating to Finance Modules for Implementation of Oracle Application module like GL, AP, GIS, IProcurement and FA which includes data gathering , mapping and application configuration

• Environment: Oracle Applications 11i, Oracle 9

Oct 2007 – Jan-2008
Confidential
Worked as a Lead Finance consultant for Release 12 Implementation – General Ledger (GL), Payables (AP), Receivables (AR) and Fixed Assets (FA), Purchasing (PO) including Iprocurement, I-expenses and Oracle Payment
Involved in various implementation strategy including Conversion data from legacy system, Sub-Ledger Accounting and E-Biz Tax
Provides status reporting to management and internal / external clients
Design, develop solutions and interact with Finance super users to ensure alignment with the functional requirements to meet their different ledger requirement for legal requirement
Worked with Oracle support for resolve issues relating to Oracle bugs.
Provided recommendation to functional and technical team for cross functional area
Involved in system and User Acceptance testing and trained Business Users.
Involved in Vendor loading, Asset loading and GL open balance strategy and open invoices
Involved in designing and creating report with regards to Financial Statement (FSG) as per management and different reporting requirement.
Involved in first month end production support activity
Setup the Order Management, Shipping, modules, such as defining transaction types, system parameters, processing constraint, defaulting rule, shipping parameters, and release rules
Environment: Oracle Applications R12.0.3
Dec 2006 – Oct 2007
Good Technology Inc.
Involved in support of Oracle Application module - Oracle General Ledger (GL) and Fixed Assets (FA) and also involved in AR, AP and also for merger activity with Motorola
Design & develop solutions to meet Tax requirement
Involved in GL balance conversion strategy, Payables and Asset conversion
Involved in specific revenue reporting requirement based on number of days basis (recognizing revenue on daily basis only for GL reporting purpose)
Independently handled implementing Sales Tax for Receivables - understand business requirements, development and implementation using best practices and involved in Customization with respect to Tax reporting
Designed Item setup for Service Contract and Order Management Integration besides setting up defaulting rules, order types, accounting rules and pricing table requirements.
Troubleshoot system issues arising in Interfaces and Conversions and day to day production support

• Environment: Oracle Applications 11i, Oracle 9

Nov 2005 – Dec 2006
Confidential, CA
Involved in implementing and support of Oracle Application module - Oracle General Ledger (GL) and Fixed Assets (FA) and also involved in AR, AP
Design & develop solutions to meet global requirement
Directly interact with Finance super users to ensure alignment with the functional requirements
Involved in GL Open balance conversion strategy and Asset conversion
Involved in Customization with respect to functional specification to the technical person
Troubleshoot system issues arising in Interfaces and Conversions
Prepared Business requirement document and Functional specification to develop
Prepared User Test plans along with Test cases
Involved in initial production support activity
Environment: Oracle Applications 11i, Oracle 9, Sun Solaris
Feb 2005 – Oct 2005
Confidential. Dallas, TX
Project involved Implementation of Oracle Application module like Oracle General Ledger (GL), Oracle Payable (AP), and Oracle Receivable (AR).Oracle Purchasing (PO) and Order Management (OM)
Actively involved managing project and meeting milestone.
Understand and prepared Business requirement based on existing system and processes and develop required interfaces.
Managed a cross functional team encompassing functional and technical resources for the Client Implementation project
Involved in Vendor, Customer loading strategy and open invoices including EDI
Involved in Customization with respect to Payables and Receivables and preparing functional specifications
Involved in implemented Order Management module for managing simple order system
Involved in design, develop and implement FSG report
Troubleshoot system issues arising in Interfaces and Conversions and day to day production support
Prepared the functional specifications for the customizations and interfaces and also prepare User Test plans along with Test case based on business requirement
Environment: Oracle Applications 11i, Oracle 8, Sun Solaris
Aug 2004 - Jan 2005
Confidential, San Jose CA
Project involves up-gradation and implementing new functionality of Oracle Application module like Oracle General Ledger (GL), Oracle Payable (AP), Purchasing (PO), iProcurement and iexpenses etc.
Analyzing and Mapping to System and / or suggesting suitable customization as per business process need.
Involved in Customization with respect to functional specification to the technical person
Creating test scenario according to business processes
Streamline the approval process for iProcurement
Modified custom report as per business requirement
Environment: Oracle Applications 11i, Oracle 8i, Windows NT
Dec 2003 – July 2004
Confidential, GA (Sr. System Engineer)
Implemented Oracle Application modules like Oracle General Ledger (GL), Oracle Payable (AP), Oracle Receivable (AR), Inventory (INV), Order Management (OM), Purchasing (PO) etc.
Environment: Oracle Applications 11i, Oracle 8/8i, Windows NT

Jan 2002 – Dec 2003
Confidential (Sr. Business Analyst)
Involved in global Implementation of Oracle Applications and integration with their existing system GELS, MUST etc. The modules being implemented are Oracle Financials - General Ledger (GL), Accounts Receivable (AR) - Progress billing /Revenue recognition, Accounts Payable (AP), Purchasing (PO), Inventory (INV), Cost Management, and Order Management (OM).
Environment: Oracle Applications 11i, Oracle 8i, NT/Unix

Mar 2001 – Jan 2002
Confidential, UK (Consultant)
Implemented Oracle Application module like Oracle General Ledger (GL), Oracle Payable (AP), Oracle Receivable (AR) and Order Management (OM).
Environment: Oracle Applications 11i(GL, AP, AR, Sys Admin), Oracle 8/8i, Windows NT

Sep 2000 – Feb 2001
Confidential, UK (Programmer Analyst )

• Internal support for Single Instance on 11i for all the country and Supporting on day to day work for the I-procurement and Web Expense

Environment: Oracle Applications 11.03 - General Ledger, Purchasing, Accounts Payable and Accounts Receivable, I-procurement (SSP5)

Jun 2000 – Sep 2000
Confidential (Previously known as ICIL), Pune, - (System Analyst)
Involved in Implementation of Oracle Application module like Oracle General Ledger (GL), Oracle Payable (AP), Oracle Receivable (AR), Fixed Assets(FA)
Environment: Oracle, SQL*Loader, PL/SQL

Mar 1998 – May 2000
Confidential, Bombay. (ERP Consultant)
Project involves Implementation of Oracle Application module like Oracle General Ledger (GL), Oracle Payable (AP), Oracle Receivable (AR), Fixed Assets(FA)
Environment: Oracle Applications 11.03, Oracle 8, NT - General Ledger, Accounts Receivables, Accounts Payable and Fixed Assets

Oct 1996 – Mar 1998
Confidential, Bombay. (Manager-Accounts)

• Worked as one of the key player in setting up the textile project at the site & in development and installation of integrated accounting package for in-house use.

Apr 1993 – Sep 1996
Confidential, Bombay (Senior Executive-MBD, Project and Merchant Banking Division)

• As a member of merchant banking division, handled various issues/projects for raising funds from public/FI for implementing new/existing projects and also team conducted feasibility studies, sensitive analysis on different parameters like fiscal benefits for locating the industry in specific area and advising the clients on corporate laws.

Mar 1992 – Mar 1993
Confidential. (Accounts Executive)

• The scope of work involved supervising routine accounts, scrutiny of debtors, creditors and general ledgers, finalization of accounts, consolidating branch accounts and assisted in system analysis and data flow for the development of in-house accounting package.

Sep 1990 – Mar 1992
Confidential (Senior Assistant -Chartered Accountants)

• Handled independently various assignments for internal audits, preparation of tax audit reports, statutory audits, ensured internal control compliance.
• Education:

Bachelors in Commerce
Chartered Accountant (equivalent to Certified Public Accountant-CPA of USA) from the Institute of Chartered Accountants of

• Training:

Oracle Applications 11.0.3/10.7 training in Financials
Completed training for the Six Sigma green belt programme from the GE internal training dept

• Skills:

• Operating System

• Unix, Windows

• Databases

• Oracle 8.x/7.x

• oracle Applications

• 12 /11i/11.x/10.7, GL/ AP/ CM/ I-procurement (SSP5)/FA/Sys Admin

• Languages

• PL/SQL

• tools

• TOAD, ADI, and FSG