SUMMARY:

• Over 16 years of experience with working extensively in Oracle applications having excellentfunctional skills in using Oracle Project Costing, Project Billing, EBS General Ledger, Accounts Receivables, Accounts Payables,Cash Management, Oracle Time & Labor, System AdministrationModules
• Highly skilled Oracle EBS Functional consultantwith 14+ years of hands on experience.
• Understanding data from the corporate perspective and representing the data so it can be understood uniformly throughout the company. Support multiple projects in building new data sets and data structures as required, and for managing the distribution, replication and archiving of data throughout the enterprise.
• Led team to plan, design, and implement applications and software.
• Collaborated with business analysts, developers to define project requirements and specifications.
• Designed, developed, and managed web - based applications, databases, network accounts, and programs.
• Launched complex recovery solutions to safeguard mission critical data.
• Expertise in Project Costing, Project Billing, General Ledger,Cash Management,Oracle Time & Labor
• Define formulas for Mass Allocation setup of options required to perform Mass Allocations
• Extensive experience in requirements gathering, fit-gap analysis, requirements mapping, application setup and functional designing
• Excellent Experience in leading implementation and testing teams, documenting Business Requirements, developing solution designs and prototypes, documenting functional specification of RICEW components, User training manuals and test cases.
• Strong experience in customizing applications using OAF, JTF, Java, JSP, ADF and JSF.
• Has very good experience in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions, custom PLL's, Forms Personalization's respectively.
• Expertise in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes.
• Experience in various development tools like SQL Developer, SQL*Loader, Oracle Jdeveloper 10g/9i, Forms 10g/6i, Reports 10g/6i.
• 10 years of experience in leading and managing Onsite and offshore model of project delivery.
• Excellent team player, analytical, interpersonal and communication skills.
• Self-motivated, Organized, detail oriented and a quick learner with positive “can do” attitude.
• Ability to work independently and as part of a team.
• 5 years working with Oracle Release 12 financials applications (Oracle Project Costing, Project Billing,, General Ledger, Accounts Receivables, Oracle Time&Labor, Order Management, Cash Management). Conceptual knowledge of Oracle Application technologies and methodologies
• Strong Exposure in preparation of high-level functional design documents for custom application development, Conversions, Interfaces & Reports
• Knowledge of Oracle’s self-service applications responsibility
• Knowledge of latest technologies towards development of e-Business Solutions
• Knowledge of Oracle Release Management (RLM) processes
• Experience in System Administration tasks related to Menus/Functions, Responsibilities and Users
• Excellent communication and user interaction skills, capacity to work harmoniously in a group with sincerity and dedication towards work and organization

TECHNICAL SKILLS:

Oracle E-Business Suite R12/11i Modules: General Ledger, Accounts Receivables, Cash Management,Project Costing, Project Billing and Oracle Time & Labor

Technological Environments: Microsoft Windows, Linux

Database Tools: Toad and SQL Developer for PLSQL

Office Applications: Microsoft Office Suite (MS Word, MS Excel, MS PowerPoint, MS Access, MS Outlook)

PROFESSIONAL EXPERIENCE:

Confidential

Functional Consultant

• Understanding data from the corporate perspective and representing the data so it can be understood uniformly throughout the company. Support multiple projects in building new data sets and data structures as required, and for managing the distribution, replication and archiving of data throughout the enterprise.
• Participate in the development process, with responsibilities as identifying the appropriate data uses and data structures required for analysis in the business or functional area.
• Cleans and maintains the data by removing and deleting old data in Stage tables, which are interfaced.
• Develops strategies for data acquisitions, archive recovery, and implementation of a database.
• Analyze client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
• Communicate client’s business requirements by constructing easy-to-understand data and process models.
• Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
• Engage client to gather software requirements/business rules, and ensure alignment with development teams
• Translate stakeholder requirements into over 10 different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagram
• Draft and maintain business requirements and align them with functional and technical requirements.
• Knowledge about the information required to support functional areas of the business. Participates in the project to ensure: 1) The right information is identified at the appropriate level of detail to assist in analysis of the business; and 2) Enables modes of accessing and analyzing data that are most conducive to fulfilling the objectives of the business. Spearheads data stewardship and data quality programs. And solicit support from others in the business organization..
• Coordinates development schedules, activities and staff across all project teams.
• Defines the structure including roles, responsibilities, accountabilities and authorities.
• Defines the architectural foundation of the program.
• Defines methods and techniques for use by all teams.
• Establishes training programs for the business users.
• Design, develop and test interface programs, reports, and forms using Oracle tools;
• Implement ERP applications/solutions and system integrations;
• Implement Revenue Automation solutions;
• Provide support to customer during project milestones CRP, UAT, Cut-Over and Post-Go-Live;
• Test and debug applications, ensure compliance of project specifications, compile documentation for describing programs.

Confidential, Schenectady, NY

Oracle Consultant

• Supporting the users in Project Costing, Project billing,Accounts Receivables, Accounts Payable,General Ledger modules
• Customization and enhancement for existing reports and interfaces in the modules of Project Accounting, Oracle receivables.
• Define structure, integrate, govern, store, describe, model, and maintain data in the enterprise for accuracy and usage maintaining current state
• Document data inventory and data flow diagrams to determine what can be measured, when and how
• Enhance the auto accounting with new liquidation Account changes and Functional Value Changes
• Make the changes in liquidation program and in corporate Granite employees Kronos (GE Time entry tool)
• Developed Custom OAF form to enable and disable user access to the Error Handling Application depending on the responsibility, application and the interfaces the user has access to.
• Played an active role in resolving the major issues at the time of period/quarter and year closing for Project Costing, Project Billing, Accounts Receivables and General Ledger
• Co-ordinating with the other teams, which are integrated with Oracle Projects billing/ Costing (Travel & Living, My Time, Accounts Payables, Receivable, General Ledger)
• Setting up Standard, Statistical & Recurring Journals, Suspense Account and Mass Allocation formulas.
• Expertise in development and personalization of Reports, Forms and Interfaces.
• Supported the interface issues and resolved the errors
• Supported the users in closing the books - helping with reconciliation issues, interface issues, adhoc reports needed to support reconciliation, etc.

Confidential

Oracle Functional Consultant

• Worked on 11. upgrade project, involving moving the finance modules - GL, AP, AR and PA to R12 version, which included data extraction, conversion and interfacing and validation of trial balances on these modules.
• Working as Oracle apps Finance functional lead consultant responsible retro fitment and Fit Gap analysis of various Financials modules like Accounts Payable, Accounts Receivables, General Ledger, modules between 11.5.10 and R12.2.4 version of Oracle Apps,
• Requirements gathering, fit gap analysis with Standard Oracle apps functionality
• MOAC Responsibility design
• Preparing Functional and solution design documents for Custom components
• Doing the Setup Related Changes for Oracle R12 Financial suite of products
• Wrote SQL scripts to assist in the identification of Projects revenue issues such as to verify the information contained in the PA-AR invoice interface
• Functional Testing for Configuration done for various changes for custom and standard oracle components
• Working with Oracle support for standard oracle related bug/issue resolution for Oracle R12 Upgrade Related issues
• Involved in UAT testing Cycles, with issue trackers and SME’s sign off.
• Assisting in developing and testing soft.
• Providing the application support for Project Accounting on regular basis and as well in PA closing time
• Import/Clear All Receivables interfaces.
• Ensure that the Create Accounting program in Receivables has successfully completed and resolving any issues that arise.
• Reviewing the Un-Posted Items reports to confirm that all items are posted to the General Ledger

Confidential

Oracle Functional Consultant

• Gathering the client requirements and preparing the documents using AIM methodology
• Analysis of the current system by interacting with business and cross-functional team
• Mapping the client requirements with Oracle standard functionality and finding the gaps and delivering the solutions in terms of workarounds, re-engineering and form personalization
• Implemented Oracle Loans for R12 release. Documented B.R.10, B.R.30 and B.R.100.
• Performed setups for Oracle Accounting Rules, Loan Types and Loan Event Actions - this included workflow.
• Documented AR and AP B.R.100 and M.D.50s Loans for disbursement to Invoice Interface.
• Business Requirement gathering, Business AS-IS process documentation for accounting for booking and billing of principle and interest in Oracle Loans module.
• Understood Business requirements illustrated by the client and Prepared BR100 - Application Set-up Document.
• Actively participated in collecting current business process documents.
• Preparing BP40 - Mapped Business Data, CV40 - Conversion Data Mapping and MD50 - Application Extensions Functional Design for RICE components.
• Involved in setting up the configuration for CRP 2, Test Instance and UAT.
• Requirements gathering, fit gap analysis with Standard Oracle apps functionality
• Preparing Functional and solution design documents for Custom components
• Doing the Setup related Changes for Oracle R12 Financial suite of products
• Functional Testing for Configuration done for various changes custom and standard oracle components
• Working with Oracle support for standard oracle related bug/issue resolution
• Providing Month end period close support
• Trained end users to get familiar with the Web-ADI tool to upload day-to-day adjusting journal entries.
• Functional Assistance in Development of deployment documents for data fixes.
• Provided the support for the custom integrations like Kronos and Oracle Time and Labor
• Involved actively in resolving the major issues at the time of period/quarter and year closing
• Working on the issues to find out the root cause and providing the resolutions/workarounds through mail/phone
• Strong expertise in Oracle Financials (Web ADI)
• Providing the application support for Project Accounting on regular basis and as well in PA closing time

Environment: Oracle Apps R12,11i, PL/SQL

Confidential

Oracle Functional Consultant

• Requirements gathering, functional gap analysis, application design, configuration, module setup, Test script generation, writing training guides, training end users and Production Support
• Maintained proactive interaction with the client to understand business practices to aid in system configuration
• Prepared the BR100 - Setup document for PA
• Prepared Test scripts -TE40
• Prepared MD50 for custom reports
• Provided regular status updates and monitoring progress on CRs as per client requirements. Multi Org setup for New Operating Unit - Strong in analysis, design, issues resolution and create new reports
• Integration of Sun’s financial systems into Oracle’s Global Single Instance
• As part of integration team, involved in IBIS Projects implementation setups Pre and Post Migration.
• Reconciled converted Financials for 27 countries across the globe which included revenue, invoices, costs, budgets, agreements and funding transactions encompassing both financial and non-financial
• Setups which includes Project Templates creation / Auto Accounting / Assigning Rules and more.
• Auto Accounting, Assigning Rules and more responsible of trouble shooting for Financial Data during Data Load.
• Worked with SUN Financial Auditors for Country signoff on Financial Reconciliation

Environment: Oracle Apps 11.0.3, 11i, PL/SQL

Confidential

Oracle Functional Consultant

• Strong working Experience gained in System Administration as I am solely responsible to create new responsibilities and functionalities during IBIS Implementation
• Involved in UAT and given the Training to Users on iExpenses
• Accepting the Calls and providing the solutions ASAP and Attending the Meetings and review calls
• Giving the month end support for all financial modules for 20 operating units and worked on shifts to address all operating unit issues and Helped the users through screen share to fix the issues

Environment: Oracle Apps 11.0.3, PL/SQL

General Motors

Accounts Associate

• Responsible for preparing Monthly Pivot table on Errors, Reconciliations and Comparative Error Analysis over the Months.
• Responsible to conduct Quality Sessions, keeping in view the errors committed during Booking Invoices / Credit Memos and Contributing to Improving Quality in the process.
• Solely Responsible for Payment Proposal for Cash and Collections of Cars Payments.
• Expert knowledge in Account payables, FI and Material Management Modules.