SUMMARY:

• 8 years of IT experience of Oracle Techno Functional on Oracle PO & AP modules, development and enhancement in Oracle Apps E - Business suite especially in Purchasing(PO),Accounts Payables(AP), iProcurement, iSupplier,SCM modules and I expenses Modules, Techno functional experience in XML Publisher report development and End to end ERP process testing
• Experience includes extensive application design and development with Oracle Apps Functional modules(PO Module and iProcurement module, I supplier) and R12 implementation, Ariba Implementation, PL/SQL & SQL,XML Publisher Report development in R12(New development and Oracle 11i to r12 report Migration)
• Oracle APPS Functional Modules (PO and iProcurement): Worked as a Testing Team member in Oracle Apps P2P(Procure to Pay) Entire cycle .Developed a master test plan and tested the Oracle Apps end to end Purchasing functionality and iProcurement.Cordinated testing team activities and updated client regarding the testing status in weekly meeting
• Worked as a code review team member. Review the Oracle PL Sql codes developed by development team member’s .Need to check the Oracle coding standards and Confidential customer requirements and approve the code to move to production instance.
• Worked as Oracle Techno/functional consultant on implementation team resolving tickets raised by clients for Oracle PO and AP modules
• Experience in Confidential . Coordinate with Confidential business clients and External suppliers and implement punch outs using oracle punch outs functionality
• Expertise in Implementing Oracle Ariba Punchout hub implementation for Confidential Business units. Worked as a senior team member in requirement gathering and successful implementation of Ariba punch out supplier Portal for 8 client business units
• Strong Knowledge and expertise in Confidential as per Confidential Business needs. Developed XML Publisher new reports and migrated reports from Oracle 11i to Oracle Release 12. As a Team leader actively coordinated business requirements and customize BI Publisher reports as per client requirements
• Providing Oracle Apps Techno/functional support to Business customers.
• Strong knowledge in Client process and Business cycle. Expertise in preparing test documents and DPMM (Digitized project Management methodology)creation, preparing MD 200 Documents for projects and presenting projects in Toll gate review process for Business reviews
• Expertise in Writing Business test cases based on Business requirements and coordinating SIT and UAT events with Business
• Very strong consulting and communication skills, developed over a number of years working in different countries, with various types of customers and business partners. Actively participated in Business meetings for requirement gathering, implementation phase and Post go live activities

TECHNICAL SKILLS:

ERP: Oracle Applications EBS (Versions 11.5.10.2/R12)

Modules: Purchasing (PO), iProcurement, Accounts Payables AP), iSupplier, SCM module, Application Object Library (AOL), Confidential

Processes: Procure to Pay, Oracle ERP testing, MD 50 Documents and BP 075 process document,MD 200 Documentation, DPMM methodology

Other Skills: Oracle Punchout, Ariba Implementations and XML publisher report development

Operating Systems: UNIX, Windows Vista/XP. Windows 7

Database: Oracle 9i / 10g

Tools: HP ALM,HP QTP, Data load Classic, XML Publisher, SQL * Loader, Toad, SQL *plus

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

PROFESSIONAL EXPERIENCE:

Oracle Functional lead

Confidential, Chicago, IL

Software/Technology/Tools used: HP ALM, PL/SQL developer, Oracle Data Load classic, Oracle Release 12

Responsibilities:

• Understand the Business process from Confidential IT and Business management
• Participated in project review meetings to understand the BP 075 process documents and understand the Business Process
• Developed Test scripts based on Business requirements, BP 075 Process document and MD 50s available for the Track
• Hosted Meetings with Business and IT team to review the test scenarios developed as per the requirements and MD 50 changes for getting feedbacks and suggestions.
• Hosted Meetings with Finance, Tax teams and other tracks to explain the Indirect Procurement test scenarios developed .Finance and Tax teams will review the scenarios and provide Finance AP steps and Tax Steps. Once those steps are provided by the respective teams will in corporate those steps with test cases developed for Indirect Procurement
• Attending weekly Indirect purchasing Business status calls, daily PMO calls and QA management status update calls
• Participating Dry Run testing prior to SIT1, SIT2 and UAT with Development team. Executing and coordinating test cases with IT team and track the scenario status and defects in ALM. Conducting defect triage calls to close the defects before Business testing Event
• Participating Business testing event SIT and UAT and coordinate the testing by Tracking in ALM. Providing status report to Business on Timely manner and coordinate with Different Business teams to close the scenarios in a timely manner. Conducted daily defect triage calls to check the status on defects and update Business on the defect status and coordinated with Development team to close the defects
• Expense account rules loading in T03 and production instance for 13 Confidential Confidential ’s using Data loader. Prepare master file for all the 13 Confidential ’s as per the data provided Business and load the details to Application via Data loader tool
• Approval Metrics loading in Production instance for 13 Confidential Confidential ’s using Data loader. Prepare master file for all the 13 Confidential ’s as per the data provided Business and load the details to Application via Data loader tool
• Preparing the responsibility Matrix for Users and Approvers participating in SIT and UAT and work with Application security team to get the responsibility assigned to the users and Approver’s prior to Business testing events
• Working with Application security team to reset the Password for SIT and UAT Requester’s, preparers and Approvers so that Business testers can login using the common PW and execute the test scenarios
• Tracking the Requirements based on Confidential ids and mapping the Confidential ids with test cases and make sure that the requirements are covered in testing by mapping the requirements in ALM against the test scenarios.
• Hosting daily calls with offshore team for updating the Track status and development and verifying the offshore tasks and activities
• Providing Weekly status Iprocurement task tracker and plan for coming week on weekly basis to Iprocurement IT lead
• Updating Business and IT management on tasks assigned and completion status by Business and IT leads
• Worked on Finance and Services Tracks as per Project requirements

Senior ERP Developer

Confidential

Software/Technology/Tools used: Oracle XML Publisher Report developer, PL/SQL developer

Responsibilities:

• Developed report for withholding Tax for Confidential Mexico operating unit in R12 instance. Business requirement is to display the Withholding tax generated for invoices raised for the Business .This is a new report implementation in Oracle R12.
• Developed Employee supervisor end dated report .This is a global report which can be used for all Confidential Business units. Business requirement is to identify the employee supervisors which are end dated. This is a new report implementation in Oracle R12.
• Developed Employee Hierarchy Report. This is a global report which will display the employee Hierarchy up to 5 levels. Report will display employee supervisor till level 5 with supervisor job details. This is a new report implementation in Oracle R12.
• Successfully Migrated reports PO Assign Requisition report(Global Confidential report for identifying Requisitions raised above 15000 USD), GESSS PO Spend Report( Confidential global report for identifying total PO spend for a Business) Confidential report for identifying Purchase, GESSS Check Stock Report( Confidential global report for identifying invoice and check details for a Business) from Oracle 11i Instance to Oracle R12
• Developed Oracle XML reports in R12 like GESSS Unpaid Invoice Report, GESSS Check Stock report, GESSS PO Assign MR Report, GESSS Taiwan Withholding Tax Report as a new development in r12 as per client requirements
• Worked on GESSS Italy report Migration (5 reports) from Oracle 11i instance to Oracle R12. This report is for Confidential Italy Business units for displaying withholding tax details generated for Invoices based on different criteria’s
• Working on Adhoc report requirements raised by Confidential clients from different Operating units which needs to be delivered in 2 days period based on priority.
• Coordinating weekly status calls with different Confidential Business heads
• Coordinating requirement calls with Confidential clients
• Preparing monthly team’s work status tracker and Adhoc request counts and present to Confidential management

Confidential

Software/Technology used: Oracle Apps PO, IProcurement, PL/SQL Developer

Responsibilities:

• Worked up on requirement gathering and successful implementation of Ariba Punchout supplier Portal for 8 Confidential business units
• Ariba supplier Portal includes 9 different vendors globally. Coordinated with all the vendors for requirement gathering and successfully implemented Ariba punch outs to Oracle 11i Confidential instances. Confidential Business units including Confidential Capital, Confidential Corporate and Confidential Aviation are currently using the punch outs
• Coordinated Business testing and successfully migrated Ariba punch outs to production

Confidential

Software/Technology used: Oracle Apps 11i and R12, PL/SQL Developer, Oracle iSupplier

Responsibilities:

• Have successfully implemented DELL Punch outs for 5 different Confidential business units
• Got appreciation mails from client manager and Confidential top management and received Confidential certified certificate from Confidential top management for the successful completion of the project.
• Successfully completed 7 other implementations with suppliers like Misco, Monks and cranes, ATEA, Grainger, Xerox, Lingemann, Staples and many other vendors
• Newly Implemented 8 new Punchout integrations with Confidential healthcare business and got several appreciations.
• Migration of Atea Sweden Punchout from Oracle 11i to Oracle R12
• Coordinated Punchout and XML testing in development and testing ERP instances for Migrating punch outs from Oracle 11i to Oracle R12
• Supporting end to end business testing
• Oracle R12 migration and implementation of punch outs for different business orgs.
• Successfully migrated 20 Punchout suppliers into R12 instance on august -3rd 2012.
• Received client appreciation for the effort
• Successfully implemented implementing 25 different vendors in Oracle R12 for Confidential Business unit: Confidential Appliances
• Successfully migrated Confidential appliances business unit to R12 with 25 active Punchout setups
• Configuration of Confidential codes in R12 Confidential instance.
• I procurement end to end testing (non catalog and Punchout requisitions, PO creation and setups involved)
• Data gathering the designing the migration of all Confidential business unit to Oracle release 12(Purchasing and iProcurement)
• Configuring Confidential and Confidential in Oracle APPS
• End to End process testing of all the implemented punchouts

Test Lead

Confidential

Software/Technology used: Oracle Apps 11i and R12, PL/SQL Developer, Oracle 10g database

Responsibilities:

• Worked on around 100 test Scripts (more on Oracle Purchasing and iProcurement, Creation of Punchout requisitions, Internal catalog, Non-catalog requisitions, Purchase orders(Standard POs, Blanket POs)
• Auto create Requisitions to PO’s
• Creating POs without requisition’s
• Raising receipts for the POs created
• Preparing Technical, Test case and Migration Documents.
• Creating Confidential for projects in PO and AP modules
• Worked in Code review Team in parallel for Reviewing the Code and testing the code.