SUMMARY

• A result - oriented Techno-Functional Consultant having 8 years of IT experience with strong and in-depth knowledge of Oracle Applications. Known as a team player that demonstrates initiative, self-reliance and a proactive behaviour. Have excellent verbal and written communications skills.
• Experience in implementing Oracle R12 application modules that support the processes which includes Order Management, Purchasing, Inventory, Advanced Pricing, and iSupplier.
• Excellent Requirement analysis and process mapping skills.
• Hands-on experience on 11i and R12.
• Experience in Application Implementation Methodologies (AIM).
• Prepared implementation documents like BP080, MD050, MD070 BR100, RD020, RD030, TE040 and the User Manuals.
• Responsible for user requirement gathering, working with business users, creating future business design documents, key business documents, “As is” Process, “To be” Process, functional & technical specifications, configuration & setup documents, test scenarios, user enhancement & change request documents, production release documents.
• Implementation Experience in Various Business Verticals like Infrastructure industry and MFG.
• Understands the Support Management SLA’s well and worked on ticketing tools.
• Hands on experience in customization and implementation of Oracle Reports, XML Reports and BI publisher.
• Overseeing application system administration involving creation of users, responsibility, menus, setting the profile options
• Experience includes Development and Customization of Reports, Forms and Interfaces. Proficient in Technical Analysis, Configuration and testing of new Development, customization of existing systems involving Technical expertise on SCM modules of Oracle ERP
• Worked on development of SQL Queries, procedures, functions and packages as per business requirement.
• Experience in the Creation of value sets and registering the concurrent programs in AOL.
• Involved in personalization of forms using Form Personalization feature in Apps.

TECHNICAL SKILLS

ERP: Oracle Applications 11i, R12

RDBMS: Oracle 9i, 10g, 11g

Operating Systems: Windows, UNIX

Languages: SQL, PL/SQL

Tools: TOAD, SQL Developer, SQL*Loader, WinScp, PuttyFTP

Modules: INV, PO, OM

PROFESSIONAL EXPERIENCE

Confidential

Oracle Application Consultant

Responsibilities:

• Design process flows for each functional area during the implementation of Oracle SCM Modules, carrying out requirement gathering, requirement analysis, gap analysis, setups and functional modifications.
• Complete set up activity in Oracle Purchasing and completion of BR100 Oracle Set up Document.
• Participated in creating application architecture functional documents (MD50) for custom reports and Interfaces to provide deliverables in line with architectural requirements.
• Create low level design artefacts independently and high level design artefacts with guidance and supports prototyping.
• Deliver high quality code deliverables and helping peers in quality checks such that design requirements are met.
• Coordinating with business stake holders and quality team for review and approvals of functional documents.
• Responsible for writing Test scenarios and getting sign off from business.
• Worked on Sourcing rules in purchasing module
• Support the creation of a repository of team s collective knowledge on technology, domain and process, seek information and leverage knowledge from other projects in order to drive higher efficiency and effectiveness and also to preserve organizational knowledge.
• Close monitoring and capturing the process of current legacy systems.
• Coordinating with Technical counterparts to move the solution into production system.
• Developed Functional Design document for EDI 865 PO Change Acknowledgement Interface program to import the data from the Supplier system in to the oracle EBS.
• Different flow cycles tested for the customizations.
• Tested P2P cycle to verify the set-ups.
• Tested different scenarios inQuality.
• Responsible for setting up Purchasing, Financial and Receiving options.
• Responsible for setting up Approval Hierarchy process for Approval of Purchasing Documents.
• Initiated ASL, Sourcing Rules and Assignment sets for Automation Process.
• Preparation of Technical Specification (MD.070) document from the Functional Design Document.
• Preparation of FND LOAD scripts to transfer data to Production Instance from Dev Instance.
• Developed Sales Order Interface to import the data from Legacy Systems into Oracle Application Base Tables.
• Worked on Customization of Forms.
• Used SQL *Loader control file and External Tables to import the customer information provided in the form of flat files into staging tables.
• Worked on Customization ofexistingReports.
• Developed Item Cost Comparison Report.
• Customized the Print Purchase Order Report based upon user requirements and added bitmap image of company logo to the report.

Confidential

Oracle Applications Consultant

Responsibilities:

• Responsible for AOL and Sys Admin tasks like registering executables, concurrent programs, request sets, creation of menus, responsibilities, value sets and profile options. Also responsible for maintaining users and request groups.
• Prepared Functional documents for various phases.
• Developed procedures, functions, packages as per requirements.
• Completion of BR100 Oracle Set up Document
• Prepared the User and Responsibility Matrix Document at each phase of the Project SIT and UAT.
• Creation of Value sets in various modules of the application.
• Created different Profile Options and assigned values to the Profile Options.
• Developed Concurrent Programs and Value sets as per the business requirement.

Confidential

Oracle Applications Consultant

Responsibilities:

• Configured the Purchasing and Order Management modules.
• Involved in solution of Requirements and Completion of BP 080 TO BE document as per the Client Standard.
• Involved in preparation of MD50 (Functional Design) Document for Custom Reports and Interfaces.
• Involved in Demonstration and tested each and every Requirement at each phase of the Project CRP, SIT1, SIT2, and UAT.
• Prepared a detailed document TE-050 and Power Point documents, manuals for the Users for Future and for new comers in the Business. iSupplier is supplier Collaboration Tool. Have interacted with iSupplier team to test the Integration between Oracle and iSupplier. Have also trained few suppliers in using the iSupplier tool.
• Complete Testing of Drop Ship and Back to Back Process
• Helped the Business in preparation of Production Data. Have always worked closely with the end users to understand every minute requirement to map with Oracle.
• IR-ISO (Internal Requisition and Internal Sales Order) Process between Operating Units.
• Developed and tested customized reports and forms.
• Prepared Functional documents for various phases.
• Configure the setups in TEST, UAT and Production Instances.
• Created Min Max planning for the required items.
• Discussed with end users to ensure each and every requirement is met; all the AS IS Process is met well designed. Each process is well tested before ensuring sign OFF for smooth Transition at each Phase of the Project.
• Developed Purchase requisition interface to import the data from Legacy Systems into Oracle Application Base Tables.
• Designed and Developed the AP Invoice Conversion.
• Gathered requirements for various RICE elements from the Business Users and created technical design documents.
• Worked on Purchasing Documents Open Interface to import Standard PO, Blanket PO into the PO Module using SQL*Loader and PL/SQL.
• Performed some administrative work such as, creating users, menus, adding forms and functions to menus, assigning responsibilities etc.

Confidential

Oracle Applications Consultant

Responsibilities:

• Developed Outbound Interface Program to import the data from Oracle Application Base Tables into Legacy Systems.
• Customization of Commercial Invoice Report.
• Developed procedures, functions, packages as per requirements.
• Designed and Developed the Item Conversion.
• Developed custom reports for PO, AR and AP.
• Daily support activities, user interaction and getting the information to understand the issues.
• Analysis of the issues.
• Resolving and closing the tickets.
• Weekly status Reviews on issues with team and business.
• Creating SRs and updates the Service Request for speedy resolutions.
• Interacting with users for new requirements.
• Helped the Business in preparation of Testing Data. Have always worked closely with the end users to understand every minute requirement.
• Coordinating with Oracle Support Team for critical issues on severity basis.

Confidential

Oracle Applications Consultant

Responsibilities:

• As an Oracle Sourcing functional expert, my responsibility involves gathering business requirements, defining business processes, mapping requirements and process to Oracle standard functionality.
• End to end Implementation / Roll out and support in Sourcing Modules - INV and Purchasing.
• Complete set up activity in Oracle Inventory and Oracle Purchasing. Completion of BR100 Oracle Set up Document
• Gathering of Requirements and Completion of BP 080 TO BE document as per the standards.
• Demonstrated and tested each and every Requirement at each phase of the Project SIT, and UAT.
• Coordinating with Technical team on customizations.
• Configure the setups in TEST, UAT and Production Instances.
• Full cycle testing to verify the set-ups
• Testing of different scenarios inQuality
• Mapping the requirements with Test cases in HP Quality Centre
• Coordinating with the Testing Team to execute the Test Cases in HP Quality Center
• Interacting with the users on WebEx and phone calls for the new requirements.