SUMMARY

• Over 7+ years of IT experience as a Oracle Techno Functional Consultant in Oracle Applications Release 12 E - Business Suite(Implementations, Production Support, Enhancements, Development & Customizations)
• 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, Oracle Forms development
• 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.
• Working knowledge on ADF(Application Development Framework)
• Familiar with application development tools like PL/SQL Developer, SQL*Plus and TOAD
• Expertisein System Administrator functions like Registering Concurrent Programs, Forms, Form Functions, Menus, Request Groups, Value Sets, and Responsibilities etc.
• Extensively worked on AIM documents like MD050, MD070 & MD120.
• Experience in raising Service Requests (SR) and follow up with oracle team to resolve the application issues and bugs.
• Experience in working with HPPM Kintana, Tortoise SVN, PVCS version manager, Smart SVN, Trac and Serena Products
• Expertise in Unix Shell Scripting
• 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.

TECHNICAL SKILLS

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

Operating Systems: Windows 10, 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, WinSCP, PVCS Version Manager, Smart SVN, Kintana

Reporting Tools: Report Builder 10g and XML Publisher.

GUI: Forms10g, JDeveloper, Workflow Builder

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Oracle Applications Techno Functional Consultant

Environment: Applications 12.1.3

Responsibilities:

• Interacting directly with Business people and third party vendor to gather requirements.
• Modified the SFDC to Oracle Interface to accommodate Lynda Contracts.
• Developed a custom Interface to load settlements for new billing entity.
• Streamlined the Offline Credit Card Payment Process to achieve 91% customer charge success rate & reduced 55 hours of dev time per week.
• Created custom QA Check to support new functionality.
• Modified Wallet upload process from CSV file drop to rest.li through Advanced Queuing(AQ).
• Customization of Discoverer reports.
• Mapping of legacy data to Oracle for Customer and Transaction Conversions.
• Worked on creating custom business events.
• Facilitating UAT sessions with business users.
• Worked closely with cross functional teams to get the job done.
• Technical Design, Migration Document for the Objects developed
• Unit Testing, Code Review and Deploy objects to higher Instances

Confidential, Foster City, CA

Oracle Applications Techno Functional Consultant

Environment: Applications 12.1.1

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 to accommodate custom RMA changes.

Confidential, Columbus, OH

Oracle Applications Techno Functional Consultant

Environment: Applications 12.1.3

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 using shell scripts.
• Creating MD70's and updating as per the changes made.
• Modified quoting workflow
• Worked closely with BPEL team for integration & with QA team for testing.

Confidential, Wayne, PA

Oracle Applications Techno Functional Consultant

Environment: Applications 12.1.3

Responsibilities:

• Involved in Implementing Inventory, Account Receivables, and Order Management functional setups in 12.2.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.2.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.

Confidential, Indianapolis, IN

Oracle Applications Techno Functional Consultant

Environment: Applications 12.1.3

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

Environment: Applications 11.x, 12.x, SQL, PL/SQL, Forms 10g, SQL*Loader.

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.