SUMMARY:

• A result driven professional with 10+ years of experience in IT, of which mostly is in Oracle Applications (ERP) Design, Documentation and Implementation.
• Proficient in Oracle Financials Modules General Ledger (GL), Project Accounting (PA), Fixed Assets (FA), Oracle Payables, Purchasing, Inventory, Oracle Receivables and Cash Management (CM).
• Expert in Multi - Org, MRC (Multi Reporting Currency), Consolidation, Translation, Revaluation and Intercompany accounting. Proficient with AGIS and Legal Entity configuration and integration with other modules while Project Accounting.
• Implemented significant features of Project Accounting such as rate schedule, transaction control and auto-accounting rules and implementation of labor cost rate schedules, setup of Project templates, creating agreements and Project Funding.
• Good understanding of the Oracle application structure and proficient in versions R12, 11i.
• Expertise in the entire System Development Life Cycle and experienced in Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitating Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, Cut off, Go-live and Post-Implementation Support.
• Expertise performing Analysis, Design, implementation and support in Oracle R12 Financials and Projects.
• Extensive knowledge in implementing Oracle suit like Project costing, Project Billing, Project Management and Integration of other modules like Account Receivable (AR), Account Payables (AP), General Ledger (GL) and other modules to Project Accounting.
• Expertise in integrating Oracle Projects with Oracle Time and Labor (OTL) by using OTL for submitting the time card details in Projects.
• Involved in full lifecycle implementation of 11i and R12 release of Oracle Projects -- functional solution architecture, functional detail design, technical architecture, technical design, development, coding, testing, end-user training, post-implementation support and customization
• Good understanding of various Oracle developer tools including Oracle Forms, Reports, SQL, PLSQL, TOAD, UNIX, Oracle RDBMS Concepts, etc.,.
• Experience using workflow components like Workflow Builder and Workflow administrator.
• Performed numerous designs for Conversions and interfaces from legacy systems/third party systems into Oracle Applications.
• Well versed and extensive working knowledge in designing and developing Trading Community Architecture (TCA), for various entities including Supplier, Customer, Banks and Employees.
• Implemented various Self-Serv modules iExpense, iProcurement, iSupplier & iStore.
• Experienced in customization by extension and modification of the standard application suite using Application Object Library (AOL).
• Proficient in creating UPK’s for user training purposes in Oracle financial modules.
• Extensive experience in Conducting CRP’s and provided wide range of functional training to multiple business user groups and co-ordinate UAT sessions.
• Proficient in authoring various documentation (BP 80,RD20, BR30, BR 100, BR 150, MD 50, MD 70, CV 40, TE 50 &TE 40) using the Application Implementations methodology (AIM), which includes Business Functional Requirement analysis, Understanding AS-IS & TO-BE processes, Gap analysis and providing solution design and building RICE components as a part of fit gap analysis, System configuration, Project Accounting and testing.
• Strong problem solving, Analytical skills & ability to work in a time-constrained and team-oriented environment.

TECHNICAL SKILLS:

• Enterprise Resource Planning (ERP) Solutions
• Oracle Applications: Oracle Applications R12 (12.0.4/12.0.6/12.1.1/12, 13)/11i(11.0.3, 11.5.3, 11.5.8, 11.5.9, 11.5.10.2) General Ledger (GL), Project Accounting (PA), Oracle Time and Labor (OTL), Accounts Payables (AP), SLA, iExpense, Payments, Purchasing (PO), Sourcing, iProcurement, iSupplier, Contracts, Cash Management (CM), Accounts Receivables (AR), Fixed Assets (FA), Order Management (OM) and others.
• Fusion Applications, Fusion Release R10.
• PeopleSoft Version 9.2.
• RDBMS /Database: Oracle 11g/10g/9i.
• Languages/Scripting: SQL, PL\SQL, UNIX Shell, C++, JAVA.
• Operating Systems: Windows XP NT/ 2000, UNIX, AIX, LINUX, SOLARIS.
• Other Tools: Data Loader, TOAD, Visio, Microsoft Project, Web ADI, MS Office Suite.

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Senior Oracle Projects Functional Consultant

• Worked as a Senior Functional consultant for the implementation of Oracle Project Accounting (Costing & Billing) and integrated with other Oracle Applications such as Account Payables, Fixed Assets, Purchasing Order and Sub Ledger Accounting.
• Conducted requirements gathering, gap analysis, testing, documentation.
• Performed set ups accounting for costs in Oracle Sub-ledger Accounting and Oracle Projects Auto Accounting.
• Prepared and laid out the Auto Accounting rules based on the segments configured and Project number was also considered as one of the segment values.
• Implemented silent features of Project Accounting such as Rate Schedule, Transaction control and Implementation of Labor Cost Rate Schedules.
• Implemented Project costing Features like Non-labor Costing, Labor costing, Capital projects, Capitalized Interest, Allocations, burdening details related setup, and Project related workflow and profiles.
• Drafted project implementation documents like BR-100, BR035 (Gap Analysis).
• Worked on Billing events, Project costing, Budgeting and Project Management.
• Worked on Billing Extensions to Create Event Holds and used Contracts for Project Tracking, Funding, Project Change Control and project deliverables.
• Implemented Project Management features like Work plan and Progress management, Project deliverables, Forecasting, issue and change management, Microsoft Project Integration, Project Performance Reporting, Performance exceptions Reporting, Reporting Pack, Project Status Inquiry and Project Status Reporting.
• Enabled Work plan structure and Work plan Versioning. Set up Progress status values and defined work items, work plan change reasons.
• Worked on customizing the application for revenue recognition and added Accounting Rules for Auto accounting and creating Lookup sets.
• Maintained proactive interaction with the client to understand business practices to aid in system configuration.
• Addressed post-production issues and fix them accordingly and maintain issue log to track issues.
• Worked on resolving month end closing issues, resolving Priority one and show stopper issues and described the setup required for integration between project deliverables and supply chain applications like item setup, demand schedule setup, cost group setup, WIP accounting class setup, Project Parameters setup, Shipping and Procurement Setup
• Raised SRs (Service Requests) to Oracle support and aggressively followed up the issues for timely resolution.
• Performed the standard configuration and setups for project accounting.
• Setup of project templates and projects. Creating agreements and project Funding.
• Involved in setting up non-labor resource, billing cycle, event type etc.
• Setup of expenditure categories and expenditure types.
• Validated the Integration with Accounts Receivable: Project related Purchase Order and Integration with Payables and Oracle Internet Express: Import and Review Project Expense and then interfaced the Expense reports from Payables.
• Integrated with Oracle Purchasing and Oracle Payables and entered project-related requisitions, purchase orders, and supplier invoices.
• Managed Project-Related Supplier Costs in Oracle Purchasing and Payables
• Designed and configured Setup of Flex fields and conducted Demo of Contracts for Project Documentation, Deliverables, Billing Initiation and validated Project Information.
• Implemented Encumbrance Accounting in General Ledger, Payables.
• Prepared the various documents required under the AIM methodology like BR 100, BR 70, RD 50.
• Drafted the testing document (TE-050) for the project accounting (PA) module and participated in SIT and UAT testing.
• Conducted CRP testing, developed test scripts carried out integration testing.

Environment: Oracle Apps R12 (PA, Project Costing/Billing, AP, FA, PO, SLA) Implementation of Oracle Project Accounting Module in R12

Confidential, San Francisco, CA

Senior Oracle Projects Functional Consultant

• Worked as a Senior Functional analyst for the implementation of projects (costing/billing).
• Interacted face to face with clients to understand the present business process and gathering of business requirements.
• Worked on AGILE Methodology and performed on site requirement analysis and developed functional specifications for the modules and customized processes.
• Implemented budgeting like creation of project budget and draft budget
• Creation of Project Accounting and General Ledger Period.
• Conducted Business Process Review (BPR) and fit gap analysis to fulfill business requirements.
• Prepared the various documents required under the AIM methodology like MD50, TE50 etc
• Involved in setting up project billing module -Auto-accounting, Event type, Implementation options, and Bill rate schedule.
• Familiar with tie-back programs and Project Status Inquiry (PSI) in which I have worked on defining derived and display columns, implemented commitments from external systems, custom reporting strategy, commitment changes extension and Project Status inquiry extension.
• Creation of expenditure types for interface supplier costs and miscellaneous transactions.
• Creation of projects and project status. Created various projects, tasks and sublevel tasks with in those projects.
• All the setups are done in Project Accounting like Project Class, project types and project templates etc
• Designed functional specifications for auto-accounting rules.
• Configuration of Oracle Project Costing Auto Accounting to standardize and streamline the account generation for material, labor and miscellaneous transactions.
• Implemented Budgeting like creation of project budget and draft budget
• Worked on costing, that is capturing cost, distribute cost and cost budget etc.
• Worked on Oracle Time and Labor (OTL) to get the cost interfaced to projects.
• Worked on Client Extensions which allows us to customize as per business requirements
• Configured descriptive flex-fields, defining values sets and value for each segment.
• Entered encumbrance entries in Purchasing, then worked on the set up like reviewing encumbrances, post encumbrances, relieve encumbrances and review the funds available.
• Assisted in the creation of user guides, reference manuals, and training materials as appropriate.
• Prepared the various documents required under the AIM methodology like MD50, TE50 etc
• Provided Post-Implementation Support for Project Accounting and supported on Month end closing. Assisted users in completing the transactions.
• Addressed post-production issues and fixed them accordingly and maintain issue log to track issues.
• Provided regular metrics on open, resolved and closed issues and participated in issue management meeting on a regular basis.
• Maintained historical records of problems solved to build a knowledge base for future issues.
• Coordinated with technical team and provided proper inputs for issue resolution.
• Design of test scripts and functionality testing of end to end scenarios.
• Involved in System Integration Testing (SIT) and UAT testing for the above mentioned modules.
• Conducted training sessions for users and gave support on Oracle Applications system.
• Keeping track of project status and technical & functional deliverables and Performed Assurance reviews and training of new consulting staff

Environment: Oracle Apps R12 (Project Accounting (PA), Project Costing/Billing, AR, PO) Implementation and Support of Oracle Project Accounting Module in R12

Confidential,Texas

Senior Oracle Projects Functional Consultant

• Worked as a Functional Consultant Lead for the R12 Global Implementation of Oracle Project Module.
• Successfully implemented Oracle Project Accounting module (PA) in 46 Countries for the Financial Module (GL), which included implementation of 46 Ledgers (44 Operating Units), 5 Consolidation Ledgers with one Global Consolidation Ledger.
• Managed the project through its lifecycle from project planning, through execution, to completion.
• Enabled and integrated Project structures such as work plan and financial structures for a template or for a project on the Structures page. Defined additional progress statuses, work items, work plan change reasons.
• Set up the Profile options Project Accounting such as Project members, work plan task default view and Implemented work plan work flow extension.
• Enabled Project Deliverables on Project templates, defined deliverable types, deliverable status and also implemented supply chain Integration and Project Billing Integration.
• Set up Project Budgeting and Forecasting with specialized features such as defined financial plan types, created additional period profiles, additional spread curves and defined planning resources along with resource breakdown structures.
• Defined budget change reasons, budget types and budget entry methods. Implemented budgetary controls, budget integration, integration with budget execution module, client extensions for budgeting and forecasting, workflow for Project budgeting and forecasting
• Set up Project Issue and Change Management with defining control item classifications, statuses, status lists, item types. Implemented control item document numbering extension and issue and change workflow extension.
• Implemented Microsoft Project Integration and set up Project Performance Reporting.
• Defined key performance areas, performance rules in Performance Exceptions Reporting. Configured email notifications for automated status reports along with scheduling of exceptions and notifications of scores.
• Worked on both Project Billing and Project Costing setups in Project Accounting module.
• Designed the Functional Document for GL Balances Conversion from Legacy to Oracle.
• Functionally designed the Chart of Accounts Report.
• Closely worked with Client for Training and providing Guidance. Prepared the Test Cases and BR100.
• Worked with TGCS through all the phases of Testing including CRP, SIT, UAT and Post Production Support including Month End Activities.
• Responsible for end-to-end Oracle Project applications implementation from Functional solution architecture to customization.
• Integrated Order Management with Depot Repair to create RMA and Sales Orders, validate customer accounts and invoice customer repairs.
• Defined AP and AR Payment Methods/Terms, Lookup/Quick Codes, Payable System Options and Financials Options.
• Worked on Encumbrance accounting on the modules like GL, AP and PO and Presentation of Financial Consolidation system to the Management.
• Used Accounting Rules to determine total revenue to be recognized (Revenue Recognition) in each accounting period and made a Setup Auto Accounting to recognize revenue based on Sales Order line.
• Provided functional review & impact analysis on proposed changes with the existing functionality.

Environment: Oracle Applications R12 Project Management, Project Billing, Project Costing, Account Receivables (AR), Account Payables (AP), Order Management (OM), General Ledger (GL). R12 Global Implementation of Oracle Projects Module.

Confidential, NY

Senior Oracle Projects Functional Consultant

• Involved in Enhancing and supporting Oracle implementation as an EBS Finance R12 Project Functional Analyst for PA, AP, AR and GL modules, played a key role in IT Support Team for the client.
• Worked on setting up Third party Payments in Oracle Payables R12 for Suppliers in EBS.
• Implemented R12 Oracle Projects Costing, Oracle Project Billing using Oracle Accelerators for rapid implementation.
• Responsible for Projects requirements gathering, fit and gap analysis, functional design, Projects application configuration and development of Work Breakdown Structure, system integration and user acceptance testing, user training and production support.
• Prepared the various documents required under the AIM methodology like BR 100, BR 70, RD 50.
• Configuration of key areas in Project Costing, Project Billing, Auto Accounting, suitable Business flow setups to the client.
• Defined Project related setup options, Project calendar, Project Period and identified Project types, Project Templates, Task related setup and Project related workflow and profiles.
• Worked on setting up the Project rate Schedule for Labor and Non-Labor preferences for Oracle in order to facilitate the resources to enter their cost against the Project and Task number.
• Involved in customizing the Project Accounting suite for reporting activities and Prepared integrated test cases for each setup and End User training material on the Project Accounting module.
• Added Accounting Rules for Auto accounting, creating Lookup sets. Defining the work structure by defining General Ledger Calendar, General Ledger Currency, Project Accounting Calendar, Project Accounting Currency.
• Worked on Project Asset Assessment and Capitalization Configuration of Oracle Project Costing Auto Accounting to standardize and streamline the account generation for material, labor and miscellaneous transactions.
• Involved in setting up Project Costing module - expenditure category, revenue category, auto accounting, non-labor resource / cost rate, labor multiplier, rate schedule.
• Involved in setting up Project Billing module - auto accounting, event type, implementation options, bill rate schedule.
• Setting up the Project and collecting the cost against Project Task through various sources like Oracle Time and Labor (OTL), PO, and Inventory.
• In OTL, created different timecard layouts for each group of workers and rearrange the fields on the layouts, edit the lists of values, and rewrite the instruction text to make it easy for your workers to fill out their timecards quickly and accurately.
• Project Costing segments from the Cost Allocation flex-field are made available for entry on the Payroll and Exception Layout. The Change and Late Audit feature in OTL is setup which includes time entry rules to determine which time entries on workers' timecards requires auditing.
• Defined Request Sets with several reports and concurrent programs for GL manager such as Intercompany, Auto invoice, Costing and Accounting details for review and analysis.
• Supported Payables & Receivables users on a day to day basis on Payment and Billing related issues in Oracle R12.
• Involved in GL Ledger setups using ASM, LE configuration, Cross validation rules, security rules, COA segments, Currencies, Accounting Calendar and Operating Units.
• Worked along with DBA to update/assign User responsibilities in EBS and updating Responsibility definitions, functions and menus. Worked on several SR’s for Payables and Receivables.
• Used OUM methodology for documenting business requirements and design documents as per business needs.

Environment: Oracle Applications R12 Implementation and Support of Project Accounting Module (Project Billing, Project Costing, Project Management, Oracle Time and Labor (OTL), AR, AP,GL)

Confidential

Oracle Projects Functional Analyst

• Worked as a functional consultant for the implementation of Projects Accounting (PA) module (Project Costing/Project Billing).
• Provided a complete, integrated project billing solution which comprises of Oracle Project Billing together with Oracle Project Costing.
• Set up the Projects Billing Revenue and Invoicing where Receivables System Options, Payment terms, rate schedules, invoice formats are defined. Implemented billing extensions, billing cycle extensions, retention billing extension, automatic invoice approve/release extension, revenue based cost accrual extension and cost accrual billing extension.
• Defined agreement types, templates, prepayment receivable activities and implemented funding revaluation factor extension and advance required extension in Project Billing Agreements and Funding.
• Project Accounting for revenue and billing in Oracle Projects Auto Accounting has been set up by defining accounting for labor revenue, expense report revenue, burden transaction revenue, realized gains/losses and for invoice write-offs.
• Oracle Inter-Project billing has been set up by defining internal supplier, customer and billing implementation options. Set up tax for internal Oracle Receivables invoice and configured for each provider operating unit. Also set up tax for internal Oracle Payables invoices and configured for each receiver Operating Unit.
• Implemented Payables open interface workflow and Inter-Project Extensions.
• Set up a customer billing retention by defining retention invoice format and accounting for unbilled retention.
• Integrated with Oracle Receivables by installing and implementing Oracle Receivables, defined transaction types, Automatic Accounting, set profile options for project invoices and implemented Receivables installation override extension.
• Worked on various client business process designs like Delivery status notification, EDI configuration for third party Sales Order transitions, Work flow Business events setup for notifying and publishing across inter companies when a new customer account is created etc.,
• Designed and configured iStore Custom Extension for publishing items with iStore categories to the stores/sites automatically upon any updates to the new store items or the inventory items.
• Worked in various phases of project from process design, development to unit testing, performance testing, regression testing, UAT, pre-production and post-go live support.
• Given 24/7 support to the team during the go live phase for meeting deadlines with complete documentation and testing.
• Involved in defect fixing of custom workflows like OM export compliance, OM RMA notification and credit management.
• Performed extensive defect fixing and support during the client pre-production testing phase, identifying the problem tickets through HP quality center.
• Worked with Kintana for code/setup migrations between test instances, for concurrent programs, forms personalization, menus, responsibilities, value sets and other AOL objects.

Environment: Oracle Applications R12 (12.1.2) (PA, Project Billing, GL, AR, PO, AGIS, iStore, AOL), Workflow Administrator.

Confidential

Oracle Projects Functional Analyst

• Worked as a functional consultant for the implementation of Projects (Costing/Billing) Contracts.
• Set up one Set of Books for each set of products that share a common chart of accounts, calendar and currency.
• Defined Locations, Organizations, Organization Hierarchies, Jobs and Employees, Customers. Implemented Options and Project Accounting Period.
• Set up Project Expenditure by defining Expenditure Categories, Revenue Categories, Units, Expenditure Types and Transaction Sources.
• Set up Project Non-Labor Costing with defined Cost rates for expenditure types and usage Cost Rate Overrides.
• Project Labor Costing is setup with defined Compensation rules, Employee Cost rates, Labor cost multiplier, Labor costing extensions, Labor Transaction Extensions and implemented Over time Processing.
• Project Burden Costing is setup with Burden Cost codes, Burden structures and schedules.
• Project Billing is done by defining billing cycles, bill rate schedules, credit types and event types and implemented billing cycle extension, labor billing extension and AR transaction type extension.
• Implemented Budget calculation extension, budget verification extension, budget workflow extension in Project Budget Setup.
• Defined Budget types, Budget entry methods and Budget change reasons.
• Defined Project Statuses, class categories, project role types, project types, Project templates and implemented Project verification extension, Project workflow Extension and verify organization change extensions.
• Project Status setup is completed by defining derived columns, displayed columns and implemented commitments from external systems.
• Auto Accounting for Labor Costs, expense report cost, supplier invoice adjustment costs, total burdened costs is set up.
• Auto Accounting for Project Revenue and Billing is completed by setting up labor revenue, expense report revenue, usage revenue, burden transactions revenue, inventory revenue and unbilled receivables, unearned revenue and receivables.
• Co-ordinated with offshore technical team and provided proper inputs for issue resolution.
• Conducted training sessions for users on Oracle Applications system and Keeping track of project status and technical & functional deliverables.
• Provided Post Production support and helped users in the month end closing and to complete pending transactions.

Environment: Oracle Apps 11.5.10.2 (PA, Project Costing/Billing, Sub ledger Accounting (SLA), AR) Implementation of Oracle Applications 11.5.10.2 Project Accounting Module