SUMMARY

• Having 14+ years of experience in Oracle applications (Oracle EBS) as a techno functional consultant with strong exposure to oracle financials, project Accounting, and SCM modules. In that around 4 years of experience in OPM with MES, OPM Financials and Quality modules.
• Strong functional exposure to OPM - MES and Quality modules.
• Performed multiple OAF customizations on oracle MES screens.
• Developed custom OAF page for the simplified QA sample creation and test entry.
• Ability to create formulas, routings, recipe development, defining the process instructions in MES, defining the item specifications and quality samples.
• Very good exposure to oracle AME module.
• Developed multiple reports in OPM and quality modules.
• Strong development skills with oracle PLSQL, UNIX Programming, Oracle apps, Oracle reports, Oracle forms, OAF, Oracle Web ADI and Oracle workflow.
• Proficient in technical aspects of oracle applications customizations, interfaces and data conversions.
• Developed multiple oracle alerts as per the business/customer needs.
• Experience in conversions from legacy system to oracle modules INV, OM, PO, AP, AR, GL and OPM using PLSQL, SQL Loader.
• Worked on various types of oracle apps projects (11i Implementations, 11i Support/Maintenance, R12 Upgrade, R12 implementations).
• Travelled multiples times to New Zealand and Singapore to support SIT (System Integration Testing), UAT (User Acceptance testing), GO Live and Month end for EBS- R12 implementations (Financials and Supply Chain).
• Involved in writing functional specifications (MD050), Technical Specifications (MD070) and User Test plan.
• Classic Data loader Created/Used data loaders for the functional setup.
• Worked around 6 months as AR functional consultant in UK during onsite assignment.
• Experience with all phases of SDLC - Requirement Gathering, Application Development, Testing (Unit, Integration and User Acceptance), Performance Tuning, Deployment and Production Support.
• Created Web ADI integrators for the creation of authorization matrix (Creation of user Responsibilities) and Profile option values update.
• Developer Reports using BI Publisher tool (XML Publisher).
• Working Knowledge in Oracle Financials, Project Accounting, OPM, SCM and CRM modules.
• Have strong exposure to P2P (Procure to Pay) and O2C (Order to Cash) cycles.
• Experience in performance and tuning (PL/SQL) using Cursor Variable, Bulk Collect/Bind, Apply Index and Hints in queries after Analyze, Explain Plan, interpret trace files with TKPROF.
• Extensive experience in Application Object Library (AOL), System Administration for Registration of Forms, Reports, other concurrent programs.
• Handled the technical team more than 6 members.
• Strong analytical and problem-solving skills, Ability to work independently and lead teams.
• Ability to organize and coordinate multiple tasks, builds strong customer relationships, and communicates effectively with all levels of an organization.

TECHNICAL SKILLS

Programming: SQL, PL/SQL, Shell scripting

ERP: Oracle Applications R12 (12.1.3), 11i (11.5.10)

APPS Modules: Oracle Process manufacturing (OPM) with MES, OPM Financials, Oracle payables (AP), Oracle Receivables (AR), General Ledger (GL), Purchase Order (PO), iProcurement, Order Management (OM), Oracle Inventory (INV), Shipping Execution (WSH), Bills of Material (BOM, AOL, System and Workflow Administration

Databases: Oracle 11g/10g/9i

Tools: Developer 2000, TOAD, SQL Developer, SQL*Loader, Web ADI, XML/BI Publisher and Workflow Builder 2.6.3

Issue Log Applications: Microsoft SharePoint, Remedy 7.0

Change Management: MS VSS and Tortise SVN

Operating Systems: MS Windows 7/XP/2003, Unix

Migration: FNDLOAD, WFLOAD

PROFESSIONAL EXPERIENCE

Confidential, Bay Area, CA

Techno Functional Consultant

Responsibilities:

• Responsible for maintaining/supporting entire oracle applications.
• Implemented AME for QA sample notification for the OPM batch and Sales quote to Sales order creation.
• Enabled/implemented lot cost process and developed customization to trigger the lot cost process as soon the OPM batch completes.
• Created multiple report in OPM and QA modules.
• Developed reports in OM (Sales quote/order acknowledgment, packing slip and commercial invoice), PO (Po document) and Finance modules (AR Invoice document, AP and AR aging reports).
• Create oracles alert to send notifications when the QA sample got rejected and daily notifications (reminders) for the PR approvers.
• Gathering the requirements from the business users and translating the requirements to functional designs (MD050).
• Involved in code and document (Technical Specification, Test plans and migration documents) reviews.
• Development of Reports, forms, Extensions and Interfaces.
• Development of user test scripts.
• Providing the support on PROD issues related to OPM, MES, Financials and SCM.
• Implemented Order Management and Shipping Module in Oracle apps.
• Customized the requisition workflow to send the notification to the finance person for approval of the requisition amount is greater than or equal to 1000USD.
• Involved in the UAT and getting necessary approval from the business users to migrate the solutions into PROD.
• Providing end user training as required Dealt with variety of client issues related to system design as well as to business.
• Sharing the status report with the Client IT director and Business Super users on weekly basis.
• Build and maintain repository for deliverables & business development documents
• Worked on Enhancements and bug fixes
• Developed the code and Completed Unit testing for Interfaces and Reports as per business user requirements.

Confidential, NJ

Techno Functional Consultant

Responsibilities:

• Responsible for development (Changes requests)/Maintenance (Bug Fix, Enhancements) of custom objects in Service Contracts Module
• Knowledge transition to the offshore development team.
• Review offshore deliverables (Code and Documents)
• Gathering requirements from end users and translating the requirements into the functional documents.
• Involved in writing technical spec (MD070), Test plan (TE020) and migration documents (MD120).
• Preparing and executing the functional test scripts.

Confidential

Techno Functional Consultant

Responsibilities:

• Developed functional design document (MD050) for Purchase order conversion and Purchase order receipt interface.
• Involved in writing technical spec (MD070), Test plan (TE020) and migration documents (MD120).
• Developed Purchase orders, Price list and Modifiers conversions.
• Developed Purchase orders and Purchase orders receipts interface.
• Developed Receipt traveler report and PO Output for communication report
• Involved in the data conversion activities and developed the post load report template
• Provided technical support at onshore (New Zealand, Singapore) during SIT, UAT and GO Live phases.
• Acted as Single POC for the all the technical issues during the GO - Live and Month end support activities.
• Created data reconciliation queries and shared the results with the client IT team on daily basis for the interfaces during the post go live support.
• Automated the authorization matrix creation (Responsibility Creation) using Web ADI tool
• Provided Knowledge transition to the Client IT team about all the custom objects and the interface framework developed.
• Involved in the development interface framework and conversation post load report templates.
• Involved in code and document (Technical Specification, Test plans and migration documents) reviews.
• Involved in developing technical Proof of concepts (POC’s) for the form personalization, Forms customization using Custom PLL and the extension of the standard functionalities (Ex: Splitting of the PO Shipment Lines, Generating Excel document output with multiple worksheets using Excel Template).
• Helped the client IT team to validate the inbound data file format and involved in data cleansing activities.

Confidential

Techno Functional Consultant

Responsibilities:

• Involved in Requirement Analysis, Data Mapping and Client Interaction. Created functional design document (MD070) for AR Invoice interface.
• Involved in writing technical spec (MD070), Test plan (TE020) and migration documents (MD120).
• Responsible for all the technical deliverables to NZ.
• Developed Account Payables (AP) and Account Receivables (AR) conversions.
• Developed AP and AR interfaces.
• Modified the standard customer statement report to trigger the custom report.
• Customized AP Payments (iPayments) formats and direct debit receipts format for ANZ and BNZ banks.
• Created reconciliation queries/Scripts which is used for post conversion load data verification.
• Provided technical support at onshore (New Zealand) during SIT, UAT and GO Live phases.
• Developed various reports and customized reports according to business requirements using oracle report builder/XML Publisher reports.
• Performed UNIT testing on the codes developed and provided extensive support during the user acceptance and regression testing phases of the project.
• Perform code review, review MD70 and TE20, suggest code tuning, and participate in integration testing for components developed by team members.
• Provided the knowledge transition to the client IT team and created the Single document to track the all the custom objects and explained the troubleshooting techniques.
• Sending daily status report to the client team and offshore management on the production fixes/issues during warranty period.
• Involved in creating the technical POC’s
• Provide month end support for all the financial modules (iPayments, AR and GL)
• Involved in helping the functional team to finalize the data templates for both data conversions and interfaces.

Confidential

Technical Consultant - SCM and Financials

Responsibilities:

• Involved in writing technical spec (MD070), Test plan (TE020) and migration documents (MD120).
• Involved in code and document (Technical Specification, Test plans and migration documents) reviews
• Developed Suppliers Conversion.
• Developed AP Inbound invoice interface.
• Developed Sub inventory transfer (Both Inbound& Outbound) Interfaces.
• Provided the Post production support and single POC for all Technical issues related to financial modules.
• Developed Oracle form based application tool outbound interface utility which can generates the outbound interfaces of type UTL FILE, VIEW and Table with minimal effort.
• Created the data reconciliation scripts for the post conversion load verification.
• Performance Tuning of the code before delivery

Confidential

Technical Consultant - Financials

Responsibilities:

• Working on Enhancement requests of existing component/New Development involves discussion of technical aspects of the change request with the Functional / Business users, analysis of the Gap, design implementation of related work/changes, estimate complexity and effort, develop and deploy.
• Testing and Performance Tuning of custom components on their way to the Production instance.
• Developing the POC’s for the enhancements requests before proceeding to development.
• Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
• Resolving production issues and bug fixes in Financials modules (AP, AR, GL and Cash management).
• Registration of new programs in Oracle Applications as concurrent programs.
• Customized oracle forms using CUSTOM.PLL, extensively worked on form personalization.
• Actively involved in handling of many postproduction issues. Analyzed and fixed the data working in collaboration with Oracle Support.

Confidential

Technical Consultant - Project Accounting

Responsibilities:

• Write Technical Specification (MD70) from Functional Specification (MD50)
• Developed AP, AR inbound interfaces
• Personalized the Award form (Form Personalization) to restrict the access based on the roles associated to the user.
• Developed a new custom form to maintain the mapping between legacy payroll system and the oracle PTAEO (Project, Task, Award, Expenditure and Organization) code.
• Developed an extension to re-valuate the foreign currency outstanding obligations based on the rate of exchange (The program run on Monthly basis).
• Developed outbound interface to extract the Customer master details.
• Prepare Unit Test plans, test cases and documenting Executed Unit Test Plans.
• Registering all AOL components from tables to Reports/Custom Procedures/Value Sets into Oracle Applications
• Involved in the Assembly and integration testing.
• Involved in developing classic data loads to load the data for the functional setup.
• Involved in code and document (Technical Specification, Test plans and migration documents) reviews.
• Providing Post Go - Live Support