SUMMARY

• Around 12 years of professional experience in Information Technology, Accounts, and Finance.
• Over 7 years of experience as a Financial Functional Consultant on Oracle Applications (ERP), this includes two full life cycle implementations at Newedge Financial and PEBS Pennar.
• Exposed to Report - to-Record, Procure-to-Pay, and Order-to-Cash modules apart from other financial modules.
• Experience with Requirement Gathering, Fit Gap Analysis, Data Migration, Testing, Support and Training services involved in Oracle EBS R12.
• Worked on various financial modules such as General Ledger (GL), Accounts Payable (AP), Accounts Receivables (AR), Cash Management(CM) and E-Business Tax (EB-Tax).
• Familiar with Application Implementation Methodology (AIM) in different phases i.e. Requirement gathering, Operation analysis, Solution Design, Build, Test, Training, Data Migration and Production.
• Designed and Implemented Payables Invoice Approvals using AME. Differentiated invoice approval process for 2-way matched invoices and 3-way matched invoices to meet complex business requirements.
• Well versed with creating employees, Jobs and Position (HRMS Module) as required for General Ledger Journal Approval process.
• Experience in defining users, responsibilities, custom menus, functions and request groups.
• Co-ordinated with Technical consultants in designing and developing customized applications.
• Experience in Test script generations, Integration testing, Training Super users and preparing Standard Operating Procedure documents.
• Well versed with Application Desktop Integrators (ADI) tools, Data Loader, and SQL (Toad).
• Excellent inter-personal and communication skills, team mentoring and leading skills, and self-motivated proactive.

TECHNICAL SKILLS

Oracle Application Modules: General Ledger, Oracle Payables, Oracle Receivable, Cash Management and E-Business Tax.

Oracle Applications: Release12

Methodologies: Application Implementation Methodology (AIM)

Oracle Tools: SQL Plus, Toad. MS Office, Visio, and Share Point.

PROFESSIONAL EXPERIENCE

Confidential, California

ERP Support Functional Consultant

Responsibilities:

• Functional Set up of a property in GL including set up cross validation rules and dynamic inserts. AP set ups like Bank, Bank Accounts, Payable documents, Supplier Set ups, and look up tables.
• Thorough testing of user issues in Test/UAT/Dev instance before moving it to production.
• Solving daily and month end issues in Procure-to-Pay cycle and General Ledger.
• Assisted users in month end closing process, reconciliation, and generating month end reports.
• Supervised the period close and quarter close processes by ensuring that all financial transactions have been accounted accurately and on a timely basis in Oracle GL.
• Led multiple initiatives to improve configurations and setups for current modules such as Accounts Payables, Accounts Receivable, and General Ledger.
• Resolved various data issues in OBIEE and Custom reports.
• Trained business users on month end process and reconciliations.
• End user training on Oracle Apps finance modules.
• Raised SRs with Oracle support as needed to resolve issues.
• Participated in weekly and monthly status review with the clients.
• Coordinated and managed the deliverables from on-site team.
• Production troubleshooting and working with Oracle Support Team.
• Monitoring of various interfaces like General Ledger Interface and Accounts Payable Invoices Interface.

Confidential, Chicago, Illinois

Responsibilities:

• Documented Process Flows (RD 20 and BP40), Process Catalogue and Key Artefacts.
• Conducted to be processed Design sessions (BP 80) to gather requirements and obtained sign-off from stakeholders.
• Completed configuration of Financial Modules in Dev instance and recreated all scenarios in Dev to demonstrate CRP. Created CRP scenarios and demonstrated CRP for client.
• Prepared BR100, MD50, Design Specs and Training documents as needed.
• Led training sessions for finance team explaining functionalities, features and demonstrating GL, AP, AR, and CM modules in Oracle.
• Prepared a template for gathering data mapping from legacy system to Oracle and explained to the Finance Controller and Manager how data needs to be mapped.
• Mapped Chart of Accounts from Legacy system to Oracle Chart of Accounts implemented in the current system.
• Conducted UAT Testing with Key Business Users.
• Modified Cross Validation rules in GL in order to add a new Confidential under existing company in test instance.
• Validated PO Matching Option, Invoice tolerances, Distribution Options, Terms, Holds, Setting up Payment methods, Banks, Payment format, Payments Manager, Recurring Invoices, and Expense Report Templates.
• Completed end-to-end process testing including creating suppliers, new check printing template using XML, setting up banks, making payments and posting to GL.
• Designed and Implemented Payables Invoice Approvals using AME. Differentiated invoice approval process for 2-way matched invoices and 3-way matched invoices to meet complex business requirements.
• Assisted in Month end close process as required. Resolved issues impacting month end close process and suggest to business the steps to be followed for resolution after testing in Test Instance.
• Resolve production issues in all finance modules.
• Raised SRs with Oracle support as needed to resolve issues.
• Work with Oracle Developer to resolve issues related to customizations to meet business needs.
• Responsible for writing functional specifications for reports and personalization.

Confidential

ERP Financial Functional Consultant

Responsibilities:

• As-Is Discussions to understand the existing business process supported by the current systems in place.
• To-Be Capture all the information on how would be the future process of client on Oracle application.
• Setup and conduct CRP sessions with key business users to demonstrate the capabilities of the Oracle Applications in the GL functional area.
• Identify Fit Gaps to Oracle standard functionalities. Determine solution options and evaluate process improvement versus custom solutions. Conduct a CRP2 to finalize To-Be processes with an optimal mix of process improvements and custom solution based on Fit Gap analysis.
• Drill down into the detailed custom components based on the To-Be processes and come up with functional specifications for the custom components.
• Coordinate the design and development for custom components and devise test scenarios to enable unit testing for the same.
• Conduct user acceptance testing by coordinating with key functional super users.
• Enable user training by reviewing documentation for the standard and custom processes.
• Creation of Responsibilities and enabling different profile options.
• Build & Design of Financial Reports using Financial Statement Generator (FSG) tool.
• Preparation for go live by planning and executing data migration and other pre-go-live cutover activities.
• SPOC (Single Point of Contact) between the end users and the technical team and Oracle Global Product Support.
• Post Go-Live Support that includes activities like critical issue resolution in the production instance for stabilization of the new system.
• Monitor the system and its behavior post implementation.
• Providing support to users in Month-End-Closing Process, Reconciliation, and Generating Month-End-Reports.

Confidential

Oracle Application Support Consultant

Responsibilities:

• Driving resolution of production support issues in Procure to Pay and Record to Report cycle.
• Coordinating data integrity checks in production system after certain fixes and patches.
• Resolving complex issues and presenting the solution along with its impact to business process leads.
• Coordinating with Developers, Business Process Leads and Testing Team while implementing Change Requests and enhancements in the system.
• Carrying out ticket management using Sales Force and generating reports for weekly meetings.
• Working with Oracle Support on Service Requests for quick resolution of time critical issues.
• Supporting key business processes, interfaces and activities including Month end period closing.
• Preparing training and troubleshooting documents for users’ future reference.
• Monitoring of various interfaces like GL Interface, GL Exchange Rate Interface, and AP Invoices Interface.
• Knowledge transition planning and coordination to hand-over production support.
• Involved in estimation, design and development of Change Requests for new requirements on Approval Management Engine (AME).

Confidential

Oracle Applications End-User

Responsibilities:

• Preparing and Reviewing various activities:
• Inter-company reconciliations & other Inter-co transactions,
• Month-end activities
• PO based accrual entries
• Prepayment schedules and transactions.
• Various other month-end rectification transactions.
• Balance-sheet reconciliations.
• Various ad hoc transactions, etc.
• Working on SLAs, KPIs, RFT, Month-end Calendar Finalization, Work distribution, Resource Allocation and Leave Management.
• Developed various tracking systems and placed a control mechanism to stabilize the entire process.
• Coordinate with both offshore and onshore team to avoid non-value addition steps in various activities.
• Preparing new DPMs (Detailed Procedure Manuals) for newly offshore activities and updating existing DPMs for “change in process”.
• Scheduling Cross-Training for High-end Activities.
• Scheduling and Training new recruits to have hands on process knowledge and reviewing their work and also maintaining training tracker to get the status of improvement.
• Finalization of Monthly Rating of team members (Based-on PEP incentive model)
• Appraise the team members on a monthly basis and provide the feedback.
• Motivate the team members to ensure delivery of services as per TAT.
• Resolving day-to-day Onshore Queries.
• Attending Weekly Performance Call & Monthly Governance Call with Client