PROFESSIONAL SUMMARY:

• Over 7+ years of IT experience as a Oracle Techno Functional Consultant in Oracle Applications Release 12 E - Business Suite
• Involved in implementations & Supporting Projects of Oracle Applications R12 &11i.
• Expertise in various RICE Components (Reports, Interfaces & Conversions).
• Expertise in Order to Cash(O2C) and Procure to Pay Cycle(P2P).
• Strong Technical and Functional knowledge of the SCM Modules (Order Management, Shipping, Purchasing, Inventory, Quoting) and Financial Modules (Account Payables, Account Receivables, General Ledger).
• Excellent skills in SQL, PL/SQL
• Expertise in Oracle Forms development using Oracle Form Builder 10g
• Involved in development of BI Publisher reports
• Involved in Development of OAF (Oracle Application Framework) pages.
• Extensive experience in customizing the forms functionality using Form Personalization and Custom.pll.
• Extensive experience in developing Interfaces/Conversion Programs using SQL, PL/SQL, SQL*Loader, APIs, ADI/Web ADI and EDI Interfaces.
• Strong knowledge on Trading Community Architecture (TCA).
• Working knowledge on ADF(Application Development Framework)
• Extensive experience in PL/SQL coding like Cursors, Ref Cursors, Dynamic SQL, Packages, Collections, file management using UTL FILE packages, Triggers, Stored Procedures and Functions.
• Familiar with application development tools like PL/SQL Developer, SQL*Plus and TOAD
• Expertise in System Administrator functions like Registering Concurrent Programs, Forms, Form Functions, Menus, Request Groups, Value Sets, and Responsibilities etc.
• Knowledge on Approvals Management Engine(AME)
• Design the Technical DOC. (like MD 070 and TE 040 DOCs) of respective Components, familiar with all Functional documents like MD50
• Worked with Oracle Applications Releases 11.5.10 and R12, and Upgradation from 11.5.10 to R12.
• Experience in raising Service Requests (SR) and follow up with oracle team to resolve the application issues and bugs.
• Experience in working with PVCS version manager, Smart SVN, Trac and Serena Products
• Expertise in Unix Shell Scripting
• Good knowledge in ADF forms development
• Good knowledge in customizing Workflows
• Extensive experience in all phases (SDLC) of Oracle E-Business Suite Implementation, experience in projects using agile methodology.
• A highly motivated, energetic individual and a team player with excellent analytical & problem solving skills, communication skills and interpersonal skills
• Collaborate well with project management, business analysts and department management teams.
• Exposure on Release 12i (R12i).

TECHNICAL SKILLS:

ERP: Oracle Applications E-Business Suite(EBS) 11i and R12 Order Management(OM), Inventory(INV), Quoting(ASO), Purchasing(PO), Shipping(WSH), Accounts Receivable(AR), Accounts Payables (AP), General Ledger (GL), AOL .

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

RDBMS: Oracle 8i/9i/10g/11g

Languages: SQL, PL/SQL, J2SE, JSP.

Utilities/Tools: Toad, SQL*Plus, SQL*Loader, PVCS Version Manager, Smart SVN

Reporting Tools: Report Builder 10g and XML Publisher. GUI: Forms10g,JDeveloper, Workflow Builder

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Interacting directly with Business people and third party vendor to gather requirements.
• Created MD50, MD70 documents.
• Collaborated well with other teams
• Developed EDI 180,812 interfaces
• Modified functional setups involving SCM modules.

Confidential, Columbus, OH

Oracle Applications Techno Functional Consultant

Responsibilities:

• Interacting directly with Business Analyst for requirement gathering
• Involving in Agile methodology by giving daily updates over stand-ups and talking through challenges faced during development
• Development of Custom Forms, Interfaces and XML Reports.
• Developing customizations in Quote to Cash Modules.
• Modified functional setups involving SCM modules.
• Created new & modified existing Forms Personalization's.
• Solving SDRs and migrating objects to higher instances.
• Creating MD70's and updating as per the changes made.
• Development of custom ADF Form
• Modified quoting workflow
• Worked closely with BPEL team for integration & with QA team for testing.

Confidential, Wayne, PA

Oracle Applications Techno Functional Consultant

Responsibilities:

• Involved in Implementing Inventory, Account Receivables, and Order Management functional setups in 12.1.3 instance.
• Researching the Service Contracts Module and knowing the functional life cycle of it.
• Creating Recurring billing for Contracts and invoicing it.
• Day to day interaction with customers.
• Performed end to end testing of Oracle Order to Cash, Procure to Pay modules in the newly implemented 12.1.3 instance.
• Functional Setups in Advanced Pricing
• Raised a service request with Oracle as the contract terms weren't printing on the contract.
• Giving frequent demos to the customer in showing the progress of POC.
• Requirement gathering and customizing as per the customer's needs.
• Created BR100 for the implemented modules.
• Data setup for Use Cases.
• Mapping of current business process with Standard Oracle Process.
• Developed the Item Interface

Confidential, Indianapolis, IN

Oracle Applications Techno Functional Consultant

Responsibilities:

• Solving Production Tickets
• Fixing issues in Forms, Reports, Packages
• Modifying various functional setups in OM, INV, AR modules
• Creating and modifying shell scripts.
• Involved in designing new packages for Interfaces.
• Fixing issues pertaining to custom sales order process.
• Quick delivery of production major tickets which doesn’t hinder clients business.
• Day to day interaction with users for requirement gathering on the raised tickets.
• Used Smart SVN to get the latest code from the server and ensuring that no one locked a particular object
• Used Trac to update the status of the tickets and assign back to customer for user testing.
• Created custom process to send PDF output as an email attachment to the users about the rings processed.
• Fixed various issues pertaining to custom sales order process.
• Working closely with DBA to ensure migration to QA and PROD instance happens without any issues.
• Developed various CSV reports from scratch.

Confidential, NYC, NY

Oracle Applications Techno Functional Consultant

Role & Responsibilities:

• Responsible for day to day activities which involve client meetings and status reporting of pending tasks.
• Supporting production system for 24/7.
• Reviewing the progress of issues with Project Manager.
• Supporting all the EDI transactions (846,850,856,810,753,754,869 and 870) transactions
• End to end life cycle implementation of Order to Cash and Procure to Pay Modules
• Various customizations in O2C & P2P modules.
• Supporting the custom ship confirm process which is developed using the standard API’s.
• Developed a new Packing routing using the shipping API’s based on the retail chain packing requirements.
• Involved in various Cost related setups
• Worked on Cost Accounting.
• Developed and EDI 850 pre process screen so the end users can review the 850 data before they are loaded as sales orders.
• Developed Out bound extraction using UTL File. Involved in customizing Shell Scripts for different EDI processes.
• Developed pl/sql package to validate order details before processes to sales order.
• Registration of Concurrent programs, attaching concurrent programs to Request Groups.
• Creation of Value sets, Flex fields for all modules and done Registrations like Reports, PLSQL Stored Procedures and SQL*Loader files.
• Developed & customized several reports and interfaces in modules PO, OM, INV, AP and AR.
• Design the Technical DOC. (like MD 070 and TE 040 DOCs) of respective Components.
• Good understanding of AIM methodology
• Developed and Customized Conversions and Interfaces.
• Involved in the development of Stored Procedures and PL/SQL Packages.
• Involved in Development of plsql scripts using API’s.
• Involved in defining of various functional setups.
• Involved in developing various custom forms (Regal 850 form, Regal Landed Cost, Regal Customer allowance).
• Involved in developing OAF forms (Service Request).
• Involved in client discussions and gathered information directly with client.