SUMMARY

• Extensive 10 Years of experience in Development, Customization, Support and Enhancement of Oracle Application R12 & 11i as Oracle Apps Techno Functional Consultant.
• Managed Onsite and Offshore teams as a part of the engagement process. Worked as team lead with high performance teams helping the unit work as a whole and achieve great results through team work, mentoring and coaching to achieve consistent results.
• Extensively worked on Oracle Applications Order To Cash (OM, INV, AR), Procure To Pay ( PO, INV, AP), Record To Report ( R2R) and CRM ( IB and Service Contracts)
• Strong Technical skills in Discoverer, XML publisher, Oracle Alerts, SQL, PL/SQL, Oracle Reports and Excel Printing Using XML Publisher, XML Bursting, SQL*Loader and Pentaho tool.
• Worked on Interfaces to load the legacy information system to release R12 & 11i which Includes AP, AR, PO, OM, CRM modules using PL/SQL, SQL*Loader and Pentaho tool.
• Involved in Functional setups and provided Support for O and Finance Modules.
• Experience with merger & acquisitions project in streamlining processes and systems transition
• Worked on Oracle EBS Upgrade projects.
• Worked on Out Bound Interfaces to transfer the data from Oracle application base tables into the Flat file. Interacted with all levels of business owners and users during the various stages of project lifecycle.
• Well versed with the AIM documentations of Functional (MD050), Technical (MD070), Installation documents (MD0120), Test cases (TE020), Conversion Functional (CV040) and Conversion Technical Design (CV060) and User Manual Documents.
• Raised Service Requests (SR) with Oracle and worked closely with them to resolve the issues and applied patches for the enhancements.
• A good team player with Strong interpersonal and negotiation skills and ability to articulate with people at all levels and Acquiring and implementing new Technologies easily.
• Delivering quality deliverables in timely manner.
• Worked extensively in onsite - offshore models for all projects following strict timelines
• Incorporated best practices in Development work environment in all the phases of project lifecycle to incorporate Company’s norms and coding standards.
• Strong interpersonal skills, team leading and decision making capabilities.

TECHNICAL SKILLS

ERP: Oracle 11i and R12

Modules: Order Management (OM), Account Receivables (AR), Inventory (INV), Purchasing (PO), Account Payables (AP), Install Base (IB), Service Contracts (SC), Depot Repair (DR), Bill of Materials (BOM), Work in Process (WIP), General Ledger (GL), Fixed Asset (FA)

Languages: PL/SQL, Html, Xml

Database: Oracle 10g, 11g,12C

Tools: SQL* Plus, SQL*Loader, Toad, Reports, XML Publisher, Discoverer, Pentaho, Forms

PROFESSIONAL EXPERIENCE

Confidential, Andover, MA

Responsibilities:

• Working as Oracle Techno Functional Lead for EBS Rollout projects.
• Coordination and managing Onsite and Offshore Teams for Development projects.
• Interacted with users in gathering all the requirement information
• Played Oracle Technical Lead role at Onsite and took responsibility for the entire delivery of the technical objects.
• Involving in Technical design meetings for the requirements and preparing solution design of the requirements
• Addressing the issues raised by business during Business testing
• PL/SQL Interface for loading Item and AR Invoices.
• Resolving Functional/Technical Issues, preparing move sheets to migrate the code across the instances
• Worked on OM, AR, INV, PO, AP, GL, IB, Depot Repair Modules.
• Involving Order Management and Receivable module setups.
• Providing On Going support on Order to Cash and Financials modules.
• Developed Supplier and Supplier Bank conversions.

Environment: Oracle E-Business Suite R12.1.3, Oracle11g, SQL*Loader, Toad, SQL/PLSQLXML Publisher, OM, AR, INV, PO, AP, GL, IB, DR, BOM

Confidential, Sunnyvale, CA

Responsibilities:

• Worked as Oracle Apps Techno Functional Consultant.
• Managed Onsite and Offshore teams for implementation on Oracle Application R12
• Coordination and managing Onsite and Offshore Teams
• Worked on OM, INV, AR, PO, AP, GL, IB, Service Contract and BOM Modules.
• Preparing documents as per AIM methodology
• Involved in Development of both Inbound/Outbound Interfaces.
• Go-live activities and post-implementation support. Supported production environments and users on a daily basis by responding to emergency requests
• Responsible for gathering user requirements, functional design, assistance to developers and testing customizations
• Provided Ongoing Support for Oracle E-business Suite.
• Performed the Functional Testing
• Registered reports, interfaces, and conversions with AOL
• Involved in the CRP1/CRP2/UAT Functional testing
• Reviewed the high-level technical architecture of the supply chain solution and Financials.
• Providing SOX compliance evidence to Internal/External auditor to review Monthly And Quarterly.
• Involved in design, development and testing and preparing migration document and testing
• Interacting with offshore and onsite Team Members daily
• Serial Number installed at location Automation
• Automated Oracle User creation and responsibility assignment process
• Item Load process.
• Developed and automated the Sales order Acknowledgement and back order details Process
• Developed Application interface Error report for AR,INV,OM,WIP and AOL Modules

Environment: Oracle E-Business Suite R12.2.3, Oracle11g, SQL*Loader, Toad, SQL/PLSQLXML Publisher, Discoverer, OM, AR, INV, PO, AP, GL, SC, IB

Confidential

Technical Lead

Responsibilities:

• Worked as Technical Lead.
• Upgrade EBS application from 12.1.3 to 12.2.3
• Identified objects (interfaces, form personalization’s and custom objects) to modify as per the R12 requirement
• Involved in Pre-upgrade and Post-upgrade activities as per the cutover plan.
• Preparation of Technical Design Document and Checklist Documents
• Did Sanity Check and Unit Testing before Users get actually involved
• All custom reports, discoverer reports are verified to work without any issues.
• Created SR’s and worked with oracle support team for oracle issues until resolved

Environment: Oracle E-Business Suite R12.2.3, Oracle11g, SQL*Loader, Toad, SQL/PLSQLXML Publisher, Discoverer, OM, AR, INV, PO, AP, GL, IB, SC

Confidential

Responsibilities:

• Worked as Oracle Apps Techno Functional Consultant.
• Worked on OM, INV, AR, PO, AP, GL, IB, Service Contract and BOM Modules.
• Co-Ordinate with business user to get the requirements
• Provided Ongoing Support for Oracle E-business Suite.
• Developing RICE Objects
• Worked on mergers project and Responsible for integration of various functions including order-to-cash, pricing, inventory management, Install Base and Service Contracts technical processes data.
• Automated the business daily and weekly process.
• Preparing documents as per AIM methodology
• Worked on Subscription billing process
• Review the team codes and approve
• Involved in Solution Mappings for Global Business Requirements
• Involved in Development of both Inbound/Outbound Interfaces
• Providing SOX compliance evidence to Internal/External auditor to review Monthly and Quarterly.
• Helped in period closing activities
• Monthly Vertex Sales tax load
• ARENA Item Import automation
• Automated Expense Invoice creation
• Automated End customer registration process
• Automated Serial Number installed at location
• Automated Oracle to SFDC outbound automation
• Automated Price List loaded
• Automated Oracle to EDB outbound conversion.

Environment: Oracle E-Business Suite R12.1.3, Oracle11g, SQL*Loader, Toad, SQL/PLSQLXML Publisher, Discoverer, OM, AR, INV, PO, AP, GL, IB, SC

Confidential

Sr. Technical Consultant

Responsibilities:

• Worked as a Sr. Technical Consultant.
• Upgrade EBS application from 12.0.3 to 12.1.3
• Preparation of Technical Design Document and Checklist Documents
• Did Sanity Check and Unit Testing before Users get actually involved
• All custom reports, discoverer reports are verified to work without any issues.
• Created SR’s and worked with oracle support team for oracle issues until resolved

Environment: Oracle E-Business Suite R12.1.3, Oracle10g, SQL*Loader, Toad, SQL/PLSQLXML Publisher, Discoverer, OM, AR, INV, PO, AP, GL, IB, SC

Confidential

Technical Consultant

Responsibilities:

• Worked as a Technical Consultant.
• Managed the implementation of Oracle Application
• Worked on OM, INV, AR, PO, AP, GL, IB, Service Contract and BOM Modules.
• Development of new Reports and customization of existing reports
• Involved in Development of Conversions and Interfaces.
• Involved in design, development and testing and preparing migration document and testing
• Involved in workflow customizations
• Registered reports, interfaces, and conversions with AOL
• Involved in test case preparations
• Developed Customer Conversion.
• Developed Install Base Creation Interface.
• Developed Services Contract and Oracle IB Extract Program.
• Developed Install at location change program.
• Customized Sales Order Acknowledgement report
• Developed Apply Holds and Release Holds Program
• Developed Open Po report in Excel with Using XML Publisher.
• Developed Extron Extract Custom Program.
• Developed SOX Reports.
• Developed accurance Image Report.
• Customized Concur AP Invoice report.
• Customized Sales Order Exception Report
• Customized Item Attributes report.

Environment: Oracle E-Business Suite R12.0.3, Oracle10g, SQL*Loader, Toad, SQL/PLSQLXML Publisher, Discoverer, OM, AR, INV, PO, AP, GL, IB, SC

Confidential

Consultant

Responsibilities:

• Worked as Consultant
• Provided EBS application support.
• Provide support for the issues that arise in the .net applications.
• Coding, Testing and Deployment of Change Requests.
• Coordinate and Support the team.

Environment: Oracle E-Business Suite R12, SQL*Loader, Toad, SQL/PLSQLXML Publisher, OM, AR, INV, PO, AP