SUMMARY:

• Having 8 years of experience in Oracle Applications implementation, upgrading, supporting and involved in few full cycle implementations of several releases 11i/11.x/R12.
• Experience in Data mapping of Oracle functionality with Business requirements.
• Functional responsibilities: Interfacing with users, requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing guides, end users, and production support.
• Technical activities: identifying functional and technical gaps, estimating work, architecting system interactions, designing custom solutions, scheduling, producing documentation, user manual to users and providing production support.
• Delivered Conference Room Pilot (CRP’s) sessions and Trouble - shot users concerns, issues during CRP and UAT.
• Expertise in Multi Org and Multiple Reporting Currencies Setup.
• Expertise with Cross Validations Rules, Security Rules.
• Experience in Oracle AIM Methodology and Custom Implementation Methodology.
• Worked on SLA(Sub Ledger Accounting) rules to replace traditional transaction codes for generating multiple accounting representations for one business transaction.
• Designed & developed material and undertook for all levels of users on new functionalities configured.
• Experience in Test planning and Roll out Planning.
• Extensive experience in understanding and providing Gap and Fit analysis.
• Created users, custom menu and responsibility, key and descriptive flex-fields, request groups and request sets through System Administrator responsibility
• Have a good implementation and upgrade experience from Oracle 11i to R12
• Energetic, committed, diligent professional with solid work ethics.

TECHNICAL SKILLS:

ERP MODULES: Oracle Applications Financials R12/11i/11.0.3 Oracle Payables, Oracle Receivables, Oracle General Ledger,and Oracle Purchasing, Oracle GRCC.

RDBMS: Oracle Database and Access 2003/2007

Product/Tools: BMC Remedy, Kintana, PVCS, Toad, PL-SQL Developer, Mercury QC, Workflow Builder 2.6,XML/BI Publisher, STAT.

Languages: SQL,PL-SQL, Java

Operating Systems: UNIX, Windows-9x/XP, Linux

Documentation Tools: MS-Office, MS Project.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Consultant

Responsibilities:

• Oracle Solution Design for Ledgers and Multi-Org structure.
• Validation of Oracle Chart of Accounts designed.
• Review of business requirements for Oracle General Ledger and mapping to standard Oracle functionality, identification of Gaps, workarounds and custom requirements.
• Application setup for Oracle General Ledger in multiple environments.
• Conducting of Conference Room Pilots (CRP) sessions showcasing the proposed solutions and validating the business requirements.
• Review of System Test Scripts
• OUM documentation - AN010 Solution Design and Business Requirements Mapping, DS030 Configuration Documents, AN100 Functional Design Document for custom components.
• Coordinating and managing internal technical team for delivering the custom components and configuration in the lower environment.
• Providing day today support activities for the existing production environment.

Environment: Oracle E-business suite R12.1.3 Modules (GL, AP,FA,CM,AR, iExpenses),MS Window 7, Oracle RDBMS 11g, Toad.

Oracle Financials Functional Consultant

Confidential

Responsibilities:

• Involved in complete end to end business solutions designing BF045, RD 20 for their legacy.
• Performed effort estimation for design and development for custom reports and GAP’s.
• Conducted CRP and given hands on system s to business users.
• Involved in designing the financial reports to the Ministry of Finance and various other budget reporting.
• Managed technical team and testing team for delivering the custom components and various budget reports.

Environment: Oracle E-business suite R12.0.6 Modules (GL, AP,FA,CM),MS Window 7, Oracle RDBMS 11g, Toad.

Oracle Financials Functional Consultant

Confidential

Responsibilities:

• Involved in complete end to end testing of the finance process and GAP process flow for UAT.
• Involved in the preparation of test scripts for UAT, and prepared MD50 for GAP processes.
• Analysis of client’s requirements & designing the solution.
• Involved in testing and validating the logic of Customizations, Form Personalization & Reports.
• Performed end to end testing and validation of the reports in CRP and UAT instance.
• Performed effort estimation for design and development for data fixes, code fixes and change requests.

Environment: Oracle E-business suite R12.1.3 Modules (GL, AP,FA),MS Window 7, Oracle RDBMS 11g, Toad.

Oracle Financials Functional Consultant

Confidential

Responsibilities:

• Implementation of Financial Modules GL,AP, i-Expense and PSB in Oracle Applications EBS R12 for multiple operating units following the AIM Methodology.
• Conduct CRP Sessions & User .
• Involved in the Data Migration process.
• Involved in the preparation of documents like BR100, MD050, TE040 and BF45 as part of project deliverables & Preparing Business Process Flow diagrams with the use of MS-Visio.
• Configuration of Production, SIT, UAT, instance & Loading of Data with the use of Data Loader.
• Analysis of client’s requirements & designing the solution.
• Designing the logic of Customizations, Form Personalization & Reports.
• Validating the Customizations, Form Personalization & Reports.
• Fixing small code changes as an when raised during CRP’s and during post production support.
• Performed effort estimation for design and development for data fixes, code fixes and change requests.

Environment: Oracle E-business suite R12.1.3 Modules (GL, AP,iExpenses,Projects,PSB), SQL* Loader, MS Window 7, Oracle RDBMS 11g, Toad.

Oracle Financials Functional Consultant

Confidential

Responsibilities:

• Coordinating and participating in meetings with business users to solve issues faced in the application and gather requirements for enhancements.
• Coordinate and communicate with the on-site, business customers and also liaise with the third party business provider (Oracle).
• Identifying user requirements and propose solutions on analyzing the business logic for any production issues.
• Performed effort estimation for design and development for data fixes, code fixes and change requests.
• Developed High-Level and Low-Level design documents for the system.Prepared test cases and test data required for unit and system testing.
• Participated in code reviews and walkthroughs.
• Participated in development activities for the project using Oracle EBS and TCS tools.
• Participated in Quality Assurance activities.
• Coordinated the deployments on production and lower environments.
• Provided Post- Implementation support for every ongoing deliverable.
• Adhere to the processes laid for Change Management, Incident management

Environment: Oracle E-business suite R11.5.10.2 Modules (GL, AP, AR, FA), SQL* Loader, MS Window 7, Oracle RDBMS 11g, Toad, STAT.

Oracle Financials Functional Consultant

Confidential

Responsibilities:

• Requirement Analysis of Motorola NA and EMEA business Process.
• Prepared Project Plan, conducted Kick off meetings, and designed commodity for new region Roll out.
• Planned, Designed, Proposed Solution Design Presentations for business users of Motorola corporation.
• Devised a Plan for Global Consolidation and presented it to the Financial Controllers and IT Director.
• Prepared FD and TD for GAPS Configured the following modules GL,AP,AR,OM,PO,Inv.
• Tested the Entire Order to Cash and Procure to Pay Life Cycle.
• Conducted UAT for Corporate Users and End Users.
• Work on bug fixing with Oracle Support.
• Understood their OPM process and made small fixes in the setup.
• Deep understanding in B2B and DS process.
• Conduct user s for financial modules and create material for them.
• Bug analysis for the CR raised through MQC and assigning and tracking for its resolution.
• Involved in the support role for the implementation.

Environment: Oracle E-business suite R12.1.2.3 Modules (EBTax, GL, AP, AR and FA), Reports 10g, SQL* Loader, MS Windows 2003, Oracle RDBMS 9i/10g, Oracle Developer, BI Publisher.

Oracle Financials EBS R12 Functional Consultant

Confidential

Responsibilities:

• Joined the Team during the Go-Live Crisis, Did Entire preparation in respect to lag in Go-Live Check List.
• Developed and Delivered Oracle Financials materials.
• Understanding and analyzing the business requirements which are being raised as a part of enhancements and support issues.
• Developed Security Matrix in consultation with Department Managers and Super Users.
• Developed the Testing scenarios for User and Responsibility testing.
• Created UAT for Excel Upload Web Template, Also Tested the entire functionality of Excel Upload.
• Analyzed and worked with the Technical Developer to build the entire Desktop Integrator functionality for Journal Upload.
• Developed Specification for Audit Balance Sheet Report and worked closely with the developer.
• Configured all the Department Menus, Responsibilities and Users.
• Worked and Re configured the Procure to Pay Life cycle from payable(AP) area.
• Validated Financial Accounting Hub Module setups with the business.
• Responsible for Entire GL walk thru for CRP -3 .Worked closely in forecasting and work allocation with the project manager.
• Worked in the entire lifecycle of this reports development like Foreign Bank account and Financial Accounts, Revenue by location, Related Party Locations.
• Provided Project leadership and functional expertise in a Oracle ERP Environment.
• Prepared BR100 for Master/Detail Level financial Budgeting.
• Maintained Strong internal Consulting relationships with Managers and end users in Finance Area.
• Prepared materials and provided to new users in AP, AR, GL modules.

Environment: Oracle Applications R12.0.6 Modules (GL, AP, AR), Reports 10g, SQL* Loader, MS Windows 2003, Oracle RDBMS 9i/10g, Oracle Developer.

Oracle Apps Technical Consultant

Confidential

Responsibilities:

• Understanding and analyzing their business domain.
• Developed program for converting journals from legacy to Oracle through open Interface.
• Developed program for converting Invoices from legacy to Oracle receivables through open Interface table.
• Personalized and customized few forms based on the business requirements.
• Creation of Control File to for Importing of Item Master from legacy system to staging table.
• Revisited the Journals, MTL and customer interfaces programs.
• Customized few reports in XML publisher and Oracle Reports based on the current business needs.
• Customized work flow process.
• Bug analysis for the SR's raised through MQC and assigning and tracking for its resolution.
• Developed Thread Testing Cases and Unit Testing Cases.
• Supported Client during month end process.
• Identified and resolved issues in Procure to pay cycle.
• Created Various User Test Cases.
• Coordination with Onshore team.
• Effectively communicating with client facilitating the query resolution process.
• Implemented EDS Quality Policies and Practices.

Environment: Oracle E-business suite 11.5.10.2 - AP, AR, GL,PA,SQL, PL/SQL, TOAD