SUMMARY

• Over 9 years of Extensive experience in ERP Development, Implementation, Enhancement and Support of different modules in Oracle E - Business Suite (EBS) with strong knowledge of Oracle Financials, Oracle Projects, Oracle Procurement, Oracle Time & Labor, System Administration, and working knowledge of Oracle Payroll and Oracle HRMS.
• Consummate in Implementing of Oracle Financials and Projects modules in R12 and Upgrading of Oracle EBS from 11i to R12 with core competencies include Business Requirements Gathering and Definition, Confidential Analysis, Data Analysis, Mapping, Systems and Environment Set-up, Testing, End-User Training, Post Production Support.
• Highly accomplished in identifying issues and areas of improvements ( Confidential analysis). Make clear recommendations of business process improvements and analysing ‘As-Is’ and documenting ‘To-Be’ processes that in corporate them into system redesign.
• Highly versatile in coordinate workshops and preparing Technical and Functional design documents and training manuals for end user training, customizations and conversions using ITIL change control procedures and AIM methodology.
• Experienced in 2 full life cycle implementations of Oracle Projects and Oracle Financial Modules having globally operated Multi Organization, Intercompany, Cross Charge, and Multiple Legal Entities with Multi Currency.
• Consummate in Purchase to Pay and Order to Cash processes.
• Highly effectuate in Oracle Reports and Forms development and Customization, Data Conversion, Version Upgrading and Interface Development.
• Nearly 3 years of experience in OBIEE 11g/10.1.3.x, which include building and configuring Repository, creating and managing OBIEE Intelligent Dashboards, OBIEE Answers, and OBIEE Delivers.
• Technically proficient in RICE (Reports, Interfaces, Conversions, Enhancements) methodologies including Implementation, Interfacing, Conversion, Data Migration and Data Conversion.
• System administration skills include creation and migration of concurrent programs, value sets, lookups, profiles, message, customization of Flex Fields (Descriptive, Key), application developer setups, etc.
• Facilitate User Acceptance Testing (UAT) and coordinate System Testing with the stakeholders and the business users,

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, Unix Shell Scripting, Java, XML

Databases: Oracle 9i / 10g/ 11g, SQL Server 2008

Operating Systems: Unix, Linux, Windows 2000/NT/XP/7 and MS-DOS

Tools: /Utilities: Business Analysis, AIM, Requirements Collecting and Analysis, SQL Developer (Oracle Raptor), Toad, Data Loader, BPMN, BPEL, Microsoft Office

Oracle Techstack: OBIEE 11g/10g, PL/SQL Developer, Reports 10g/6i, Forms 10g/6i, Project Partners, Oracle Designer 10g, Oracle Workflow Builder, XML Publisher, Oracle Discoverer 10g/11g,, OA Framework

Oracle E-Business Suite: Account Payables (AP), Receivables (AR), General Ledger (GL), Sub ledger Accounting (SLA), EBusiness Tax, Report Manager, Project Billing, Project Management, Project Costing, Project Contracts, System Administration, Fixed Assets (FA), Purchasing (PO), iProcurement, Inventory, Order Management, Human Resources (HRMS), and Oracle Time and Labor (OTL)

PROFESSIONAL EXPERIENCE

Confidential, Sanfrancisco, CA

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Working as a Consultant in upgrading of Oracle Financials from 11i to R12 and then implementation of the Oracle Projects module and Interfacing Projects module with Oracle Financials and Oracle Time and Labour modules.
• Performing onsite requirement analysis and developed functional specifications for the modules AP, AR, GL, CM, and PA (Project Billing, Costing, and Management) for customizing processes by conducting Business Process Review (BPR) and Confidential analysis to fulfil business requirements.
• Planning business analysis approach, deliverables, proposals, POC, activities and performing business requirements gathering on assigned projects under a strict delivery schedule.
• Managing stakeholder’s requirements and expectations in a rapidly and frequently changing environment dealing with stakeholders at different levels including CxO level stakeholders.
• Setup and implementation of Projects module especially in Project Costing, Billing and Management for Capital, Direct and Joint Venture Projects. Used Contracts for Project Tracking, Billing Initiation, Version Tracking, Funding etc.,
• Raising Service Requests with Oracle to fix the issues encountered after upgrade like invoicing and accounting issues in AP and AR Sub ledgers, E Business Tax, MOAC, Transferring journals to GL, etc.
• Interfacing and mapping data of the Oracle Projects module with AP, AR, GL, OTL, PO and HR modules by setting up Auto Accounting, Auto Invoicing, Calculating Cost and incorporating project related Chart of Accounts.
• Defining Project related setup options, Project Resource calendar and identified the Project organizations, Project types, Project Templates, Task related setup and Project related workflow and profiles,
• Setup of Cross charge, Intercompany Invoices, Implementation Options, Event Types, Bill Rate Schedules, etc.
• Writing Custom PL/SQL packages for the Project Costing and Billing extensions and developing various reports for Invoicing, Billing and Man-hour reports.
• Involved in customizing and developing Repositories (Physical, BMM, and Presentation Layer) and merging repositories using OBIEE administration tool.
• Created Analytics Reports including Charts and Pivot tables using OBIEE Analytics for the end users.
• Developing several RDF, Discoverer, and XML reports in various modules of AP, GL, AR, PO, PA, and OTL using Reports 10g, Discoverer 11g.
• Customizing Invoice entry Form to split the payment based on the pay group using Forms 10g.
• Providing training and conducting workshops to train end users on the new functionality of R12.
• Preparing various documents required under the AIM methodology like BRD100, MD50, TE50 etc., Test Scripts, Test Cases and End user Training material.

Environment: Oracle 11g, SQL, PL/SQL, Reports 10g/6i, OBIEE 11g, Discoverer 11g, XML Publisher, Project Partners, Unix, Data Loader Oracle Apps Modules: (R12) Financials (AP, AR, GL, CM), E Business Tax, Projects (Billing, Costing, Management, Contracts), PO, iProcurement, Inventory, OTL, and System Administration

Confidential, Atlanta, GA

Oracle Financials Consultant

Responsibilities:

• System setup audit has been done to ensure the system setups in R12 to meet the requirement in GL, AP, AR, FA, and CM modules.
• Review the R12 setups steps with the CFO, Financial Controller, Manager and users of respective modules/systems and updated the setup as per requirements.
• New functional changes like Sub Ledger Accounting (SLA), E Business Tax, MOAC and functionality changes in various modules are reviewed by CFO, Super users and Users of various business areas.
• System integration and regression test has been carried out to meet various functional scenarios.
• Customize and convert existing RDF reports that will run compatible as per the new multi-org structure and user requirement in R12.
• System tested to meet Procure to Pay and Order to Cash with matching and payment batch process in AP and AR sub ledgers respectively.
• System tested to meet invoice to cash process applying manual and Auto Lockbox receipts in Receivables.
• Liaising with business users, clients in Setup of Fixed Assets and Report Manager modules for various entities in the organization.
• Configured location based and VAT tax setups to meet the requirement.
• Cash Management system has been tested to the bank file reconciliation process.
• Developed XML template to print checks on the pre-printed paper in AP as well as PDF publisher. worked on Asset retirements and the proper recording of accounting transactions, including running the Calculate Gains and Losses program and reinstatements of retired assets
• Prepared BR100 and Developed test cases on various functional scenarios and provided to users and user training has been provided on the new R12 system.

Environment: Oracle 11g, SQL, PL/SQL, Reports 10g/6i, Discoverer 11g, XML Publisher Oracle Apps Modules: (R12) Financials (AP, AR, GL, FA, CM), EBusiness Tax, Report Manager, PO, Inventory, and System Administration

Confidential, Beaverton, OR

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Responsible for Projects requirements gathering, fit/ Confidential analysis, functional design, Projects application configuration and development of Work Breakdown Structure, system integration and user acceptance testing, user training and production support.
• Configuration of key areas in Project Costing, Project Billing, Project Management and suggesting suitable Business flow setups to the client and Interfacing Oracle Projects with AP, AR, and GL.
• Involved in setting up Project Costing module - expenditure category, revenue category, auto accounting, non-labour resource / cost rate, labour multiplier, rate schedule, etc.
• Setting up the Project and collecting the cost against Project Task through various sources like OTL, PO, and Inventory.
• Customized the Workflow process for the PO Approval.
• Involved in customizing the Project Accounting suite for reporting activities in order to record and see the monthly P&L by Project Number and conducting CRP in order to validate the system configured to meet the Business flow followed by the Organization.
• Developed and Customized various Forms and Reports in Oracle Projects and Financial Modules using Oracle Forms 10g, OA Extensions, Reports 10g and Discoverer 11g,
• Developed views and imported into Discoverer Admin. Created complex queries to develop reports in discoverer. Developed various reports using Discoverer desktop.
• Prepared the various documents required under the AIM methodology like MD 50 and TE 50.
• Providing Production support and helping users in the month end closing and to complete pending transactions.

Environment: Oracle 11g, Reports 10g, Forms 10g, OA Framework, UNIX, Workflow Builder, Discoverer 11g, SQL, PL/SQL Oracle Apps Modules: (R12) Projects (Project Billing, Costing, Management), Financials (AP, AR, GL, FA, CM), PO, iProcurement, Inventory, and System Administration

Confidential, Burnsville, MN

Oracle Financials Consultant

Responsibilities:

• Interacted with the Business and analyzed existing business practice and prepared business requirement document and identified Gaps.
• Configured multi-org business structure, Ledger Setup, Legal Entity, Establishment Setups, MOAC security and Multi Currency.
• Created Chart of Accounts, calendar and currency according to the business requirement and configured Global Consolidation System to consolidate balances.
• Involved in the setup of tax configuration using the Regime to Rate flow and setup the tax rules, Payment terms and Distribution sets.
• Worked on tax accounting process, including creating a tax book, adding assets to the tax book using Initial Mass Copy and Periodic Mass Copy, and adding assets manually.
• Performed end to end testing for the entire process flow for AP, FA and GL modules and documented the test results.
• Preparation of user training documents - prepared the training document (AP, FA, EB Tax and GL modules) for the users, specific to the clients business and covering their critical business process flows.

Environment: Oracle 11g, AP, FA, GL, EB Tax

Confidential

Oracle Applications Analyst

Responsibilities:

• Provided Technical and Functional support for all levels of users, key stakeholders on resolving issues in Oracle ERP modules and Business Intelligence solutions.
• Improved and optimized business processes throughout the complete project lifecycle including issues related to change management, project planning, project definition, and risk assessment.
• Designed, Customized and Support of Oracle Financials modules (AP, AR, GL, CM, FA) as per the requirements of Business Users.
• Involved in customizing the Project Accounting suite for reporting activities in order to record and see the monthly P&L by Project Number.
• Setup of Projects, WBS, Allocating Budget, Adding Resources, Creating Work plans and Financial Plans, etc. in Oracle Projects Module.
• Assisting, Training and Supporting the end users, key stakeholders in solving various Application issues, HR and Payroll issues, Data migration issues, Month-End and Year-End reconciliation issues and procedures.
• Support of Oracle Purchasing and Inventory modules to support the business in Purchase orders, Requisitions, Receipting, Counting, Order Management, Periods, etc.
• Worked on OBIEE meta-data development. Configure repository (Physical Layer, Business Logic and Mapping Layer and Presentation Layer) and development of reports and Dashboards.
• Day to day support in Oracle Time and Labour, Oracle Human Resources, Payroll, and System Administration.
• Customized existing OAF Screens and Forms as per business needs using OAF Substitutions, custom PLL's, Forms Personalization's respectively.
• Developed and Customized Reports in various EBS modules like Trail balance, GST, Account Analysis, AR Aging, Invoicing, Man hour, Purchase to Pay reports, etc.

Environment: Oracle 10g/11g, SQL, PLSQL, OBIEE 10g, Reports 6i, Forms 6i, OA Framework, Discoverer 10g, XML Publisher, CVS, and UNIX Oracle Apps Modules: (11i) Financials (AP, AR, GL, CM, FA), Projects (Project Billing, Project Costing, Project Management), PO, iProcurement, Inventory, OM, HRMS, Payroll, OTL, and System Administration

Confidential

Oracle Financials Analyst

Responsibilities:

• Involved in the post production support phase for trouble shooting issues and helped development team in bug fixing. Followed a strict change management process involving user tickets followed by problem analysis, development or bug fixes, unit testing and user acceptance testing with thorough documentation maintained at all stages. Raising TAR's and working with oracle support for escalating issues and finding resolutions.
• Supported Oracle Applications Finance modules (AP, PO, AR, CM and GL) to ensure smooth closure of the books in every month.
• Defined the natural account segment values and legal entity and management entity segment values and defining consolidation modifying cross validation rules.
• Customized FSG Financial reports, developing various financial reports using Oracle ADI and Oracle Reports.
• Conducted Oracle Apps. Knowledge sharing sessions in Financials modules -- AP, AR, CM, PO & GL.

Environment: Oracle 10g, Reports 6i, SQL, PL/SQL, XML Publisher, CVS, ADI Oracle Apps Modules: (11i) GL, AP, AR, iExpense, PO, Inventory, CM, and System Administration

Confidential

Oracle Developer

Responsibilities:

• Creating new responsibilities and defining the required system profile options.
• Developing and Customising various reports and forms in Oracle Financials using Oracle Reports 6i and Oracle Forms 6i.
• Worked on Oracle Financials and Oracle Purchasing Modules AP, AR, GL, PO and Inventory to provide support to the clients and solving the issues.
• Enabled and defined various Key Flex fields and Descriptive Flex fields.
• Creating the user, printers, responsibilities, request groups and creating value set and assigning its values.
• Using FNDLOAD for Messages and Responsibilities templates migration from one instances to other instances.

Environment: Reports 6i, Forms 6i, Oracle 9i/10g, SQL, PL/SQL, XML Publisher Oracle Apps Modules: (11i) AP, AR, GL, PO, Inventory and System Administrator