SUMMARY

• Oracle Apps Techno Functional Lead in Purchasing, Inventory and Payables
• Over 15 years of Professional experience, which includes 10 years of Functional consulting experience in providing solutions for Development, support, maintenance and implementation of Oracle Applications E - Business Suite Releases 11i, Release 12
• Hands-on involvement on all phases including business requirements gathering, GAP analysis, design, configuration, development, Customizations, data migrations, Production cut over, User training, support and maintenance experience ofOracle applications.
• Well versed with AIM Methodology. Created the Standard Documents like BR100, MD050, TE040, BP040, and BP080.
• Involved in R12 SCM Implementation of the Procure to Pay in the recent project
• Involved in functional setups for modules like Purchasing, iProcurement and Inventory for R12 and R11
• Experience in iSetup tool for migrating AOL objects from one instance to another.
• Worked on Data migrations/conversions, Interfaces between legacy and Apps system - Items, POs, Receipts, Vendors, Banks, Invoices
• Extensive experience in PL/SQL and Unix programs development
• Responsible for preparation of Unit Test case documents and work with business users to get them tested
• Worked on support and maintenance projects to understand user issues and fix them on timely manner
• Worked on manufacturing domain projects with good understanding of business processes

TECHNICAL SKILLS

Functional Experience: Purchasing and iProcurement (PO), Inventory (INV), Payables (AP). AR, HRMS

Languages: PL/SQL, Unix, C, C++

Tools: iSetup, Toad, PVCS, SQL Developer, VSS

Databases: Oracle 10g/9i/8

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Oracle Techno Functional Lead

Responsibilities:

• Involved in Purchasing, iProcurement and Payables Modules.
• Responsible for creating functional setups - categories, UOMs, OU setups, locations etc.
• Worked on iSetup tool to migrate the OU setups, AOL objects and master objects from Dev to stage and then to production environment.
• Discuss with business users on new interface requirements and finalizing the design of the same.
• Lead the team to co-ordinate on the functional setups and delivery dates of various components.
• Worked on Data conversions which includes data cleaning, data validations and loading the data from various legacy systems to Oracle Apps environments: Purchase Orders, Categories, PO Receipts, Suppliers, Requisitions
• Developed interfaces for HR data, Requisitions, POs and Receipts import from legacy systems to Oracle Apps system.
• Providing quotes and scope documents for enhancement requests coming from the business users.
• Co-ordinating with other teams to handle quality management activities
• Taking care of project Tollgates for various deliverables and making sure of timely delivery of the products.
• Responsible for preparing Design documents, Unit test cases etc.
• Worked on end user support for production issues

Environment: Oracle EBS 12.1.3 and 11.5.10 (Purchasing, iProcurement, Inventory, Payables)

Confidential, Worthington, OH

Oracle Techno Functional Consultant

Responsibilities:

• Discussing with the end users and the functional groups to do the gap analysis for implementing Apps 11i
• Worked on Purchasing and inventory setups for the new implementation: Items, suppliers, banks, locations, sub inventories, locators, lockbox, Inventory Orgs etc.
• Worked on Data conversions which includes data cleaning, data validations and loading the data from various legacy systems to Oracle Apps environments: Items, Customers, Purchase Orders, PO Receipts, Banks/Bank Accounts and Suppliers.
• Maintenance and support of the Oracle Applications system in Inventory and Purchasing
• Developed the interfaces between Oracle E-Business suite and legacy systems for Items, Standard Costs, POs, PO Receipts, Vendors and customers.
• Creating the Autosys scheduling jobs for regular interfaces and monitoring them for any failures and fix issues if any.
• Responsible for supporting Legacy systems like GEMMS, Data warehouse, etc.
• Supporting manufacturing business processes and dealing with various site leaders on the floor to troubleshoot any system related issues.

Environment: Oracle Applications 11.5.10 (PO, INV, AP, AR), Oracle 7/8/9i, PL/SQL, UNIX, TOAD, VSS

Confidential

Oracle Developer and Team lead

Responsibilities:

• Responsible for supporting users for legacy system GEMMS and developing the interfaces between GEMMS, Data warehouse.
• Assigning the change requests to the team members and performing the code reviews.
• Preparing the unit test plans and perform unit testing.
• Handling project management activities and regular quality audits.
• Co-ordinating with the onsite team members in finalising the requirements for the new development requests and participating in user testing.
• Supporting manufacturing operations related system issues

Environment: GEMMS, PL/SQL, UNIX

Confidential

Oracle Developer

Responsibilities:

• Understanding the process of current purchasing systems of Confidential sites.
• Gathering the requirements for the new interfaces to replace the Plant & Equipment module.
• Preparing the functional and technical specifications for the new interfaces.
• Responsible for developing the codes for interfaces, preparing the test plans and performing unit testing.
• Co-ordinating with the team members to ensure proper integration testing is done.
• Monitoring the schedules autosys jobs

Environment: Oracle PL/SQL, UNIX