SUMMARY:

• Almost 9 years of experience in Oracle Applications Releases 11.5.10.2,12.0.6,12.1.3 and R12.2.4 as a technical consultant.
• Extensive experience in Implementation, Customization, Upgrade, Production Support of Oracle EBS.
• Extensive experience in all phases (SDLC) of Oracle EBS Implementation with major focus in Order Management, Purchasing, Advanced Pricing, Service Requests, Service Contracts, Install Base, Payables, Receivables, Fixed Assets, Oracle Budgets, General Ledger Modules.
• Extensive experience in Reports, Interfaces, Conversions and Extensions (RICE) and Configuration, Extensions and Integration
• Extensive experience in developing Interfaces/Conversion Programs using SQL, PL/SQL, SQL*Loader, APIs.
• Extensive experience in developing custom forms using forms 6i/10G.
• Extensive experience in customizing the forms functionality using Form Personalization, Logical apps rules and Custom.pll
• Extensive experience in developing custom reports and customizing standard reports using reports 6i /10G.
• Expertise in System Administrator functions like Registering Concurrent Programs, Forms, Form Functions, Menus, Request Groups, Value Sets, and Responsibilities etc.
• Expertise in Oracle XML Publisher and Discoverer reports.
• Knowledge on UNIX Shell Scripting.
• Extensive experience in creating Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Familiar with application development tools like PL/SQL Developer, SQL*Plus and TOAD
• Experience in customizing workflows
• Experience in creating Documentation using AIM methodology. Familiar with all the Standard Documents like MD.50, MD.70 and TE.20
• Involved in production support, development and migration activities.
• Experience in working with ITG Kintana/ HP PPM change management and migration tool.
• Worked in teams, involved in various responsibilities like Requirement gathering, development, Unit testing and UAT
• Experience in understanding the business requirement and coordinating with development team in implementing the same.
• Excellent analytical, problem solving and communication skills, detail oriented with ability to be an effective team player and work under severe time constraints
• Received many appreciations, s, prizes from client for identifying and fixing the production issues.

SKILLS:

Oracle Order Management

Oracle Purchasing

Oracle Pricing

Service Contracts, Service Requests

Install Base

Advanced Pricing

Account Payables

Account Receivables

Oracle Budgets

Fixed Assets

AOL concepts

Oracle Application Framework(OAF)

Oracle vertex system

Export on Demand

Oracle forms

Oracle Reports

Oracle Discoverer reports

XML Publisher Reports

Oracle workflow builder

TOAD

Oracle SQL Developer

JDeveloper for OAF

Oracle vertex system

Putty

SCP Client

PVCS

Kintana

Jira

Perforce

Data Loader

EXPERIENCE SUMMARY:

Confidential, San Diego

Technical Developer and Coordinator

Responsibilities:

• Coordinate with the Oracle production support team by providing solutions to business issues in Oracle applications, fixes and enhancements to custom components.
• Interacting with onsite for getting the requirements clarified and develop accordingly in the development environment.
• Application bug fixes, enhancements and customization Setting up the causal factors and working
• Development, maintenance, enhancement and customization of Oracle Reports and Forms.
• Maintenance, enhancement and customization of inbound and outbound data interface programs.
• Unit testing and system integration testing.
• Preparing technical specification document and test cases and test result documents.
• Coordinating for functional testing with functional team.
• Migration of components to TST environment by coordinating with quantum database team.
• Review for all offshore deliverables including: a. Technical specifications document review b. Code Review b. Unit test document review c. Migration details document review
• Involved in resolving the Production issues as part of current production support

Confidential, Dallas

Technical Developer and Coordinator

Responsibilities:

• Involved in preparing 11i environment to readily available for R12 patching by coordinating with admin team in running the readiness reports and fixing the issues raised by readiness reports.
• Involved in running Confidential tool to identify all the impacted custom objects that has to be retrofitted.
• Involved in re - implementing the personalization in OAF forms which are mandatorily changed to OAF.
• Coordinating with offshore team in compiling the custom forms and reports in 10g which are developed in 6i.
• Involved in arranging the sequence of objects for migration activities.
• Expertise in using the PVCS and Kintana tools for version control and migrating objects from instance to instance.
• Involved in resolving the Production issues as part of current production support

Confidential

Techno-functional consultant

Responsibilities:

• Involved in developing the sterling process (Inbound and outbound) for our suppliers to automatically create Payable Invoices in our system through inbound process and sending back the payment information through outbound process after payment completes.
• Involved in developing the AR Receipt Automation program to create the receipts for intercompany process and Confidential through flat file.
• Involved in creating the discoverer reports to assist the business for their reconciliation and verification process.
• Involved in maintaining the Oracle vertex system and owns it completely and creating exemptions according to business taxation process.
• Involved in the user to upload the customer s through ECM process.

Confidential

Techno-functional consultant

Responsibilities:

• Involved in merging the new Operating unit called “ Confidential ”.
• Involved in Development of Customers, Service Contracts, Subscription Contracts, Install Base, Advanced Pricing and Item Conversions.
• Involved in development of AR interface by making it flexible to upload the invoices/CM across all operating units.
• Involved in setting up the Intercompany transactions.
• Involved in developing the web ADI to upload the assets monthly.
• Involved in testing the interfaces to send the data (customers, products, Delivery) to Export on Demand.
• Involved in development of a custom program to migrate the responsibilities from one instance to other instance by changing the OU Name which is Value Addition for Confidential
• Involved in developing the new interface (From return to shipping) to fulfill the Canada GSM requirement.
• Involved in resolving the Production issues
• Converting the data required to Vertex, maintain the tax rates and updating them monthly with the data provided by vertex.
• Maintaining the Tax exemptions in oracle vertex system and involved in uploading the customer exemption s by the business user through ECM.

Confidential

Techno-functional consultant

Responsibilities:

• Involved in merging the new Operating unit called “ Confidential ”.
• Coordinating with the business users in understanding their business scenarios and working closely with the technical and functional team.
• Involved in Development of Customers, Advanced Pricing and Item Conversions.
• Involved in development of new interface to meet their business scenario especially.
• Coordinated with users to get the data and maintain data in the required format to use in conversions of oracle apps system.
• Involved in writing few test cases for different scenarios.
• Involved in designing the complete business process from Order management to Account receivables.
• Involved in resolving the issues for user in Oracle vertex system

Confidential

Techno-functional consultant

Responsibilities:

• Coordinate with the Oracle production support team by providing solutions to business issues in Oracle applications, fixes and enhancements to custom components
• Customers are ready to sign for the extended warranty of all the units they own in Install base.
• Developed a PL/SQL Executable type concurrent program to automate the whole service contract creation to Auto approval stage.
• Included all the service contracts APIs to create contract, contract line and sub line.
• Then Perform the QA check. Once the QA check is successful then submits the contract for approval. Once approved the contract becomes active.
• Interacting with onsite for getting the requirements clarified and develop accordingly in the development environment.
• Application bug fixes, enhancements and customization Setting up the causal factors and working
• Development, maintenance, enhancement and customization of Oracle Reports and Forms.
• Maintenance, enhancement and customization of inbound and outbound data interface programs.
• Unit testing and system integration testing.
• Preparing technical specification document and test cases and test result documents.
• Coordinating for functional testing with functional team.
• Migration of components to TST environment by coordinating with quantum database team.
• Review for all offshore deliverables including: a. Technical specifications document review b. Code Review b. Unit test document review c. Migration details document review
• Preparing weekly ITG Status Update Report
• Involved in writing the different interfaces and conversions.
• Involved in many conversions like Customer, Supplier, Sales Order, AR Invoice conversions.
• Developed many packages, procedures, functions using dynamic sql
• Involved in adding the extensions to the standard form through CUSTOM.pll, logical apps and form personalization.
• Involved in changing the invoice print templates.
• Developed automation process to send AR Invoices to Customer email addresses.
• Involved in Production support

Confidential

Technical lead at Onsite

Responsibilities:

• Involved in identifying the customizations that related to a particular operating unit in SCM and MFG modules.
• Involved in identifying the technical objects which relates to that particular customization and segregate the list and working with the respective teams.
• Involved in managing both the teams and worked closely with them by clarifying the issues.
• Involved and worked with the functional team in setting up the new instance and worked with them in completing the initial setup for new instance.
• Worked with the development teams to migrate the technical objects to different instances at different times.
• Worked with the functional team in developing the data loader scripts for data loading into Oracle application system.

Confidential, San Diego

Technical Developer

Responsibilities:

• Trade Export System Outbound Interface
• Used panaya tool to identify the affected objects from 11i to R12.
• Performed code retrofit of affected objects.
• Analyzing and suggesting the solutions to business to fill the gap between R12 features and business process.
• Worked on Inbound interface
• Worked on APIs for the Customer Creation process for BPEL integration.
• SQL queries performance tuning to improve the run time results.
• Collection Letter Print Program
• RMA Receipting Validation and Defaulting Rules
• Confidential Service Contracts Expiration Report
• Complete Development of Prepaid collection letter pdf program.
• Ability to Email the Collection Letter
• Development of PO Email Notification program for Purchase Orders.
• Developed Oracle report and XML publisher report for Quoting Module implementation based on the Quoting Sales Manager Responsibility.
• Major Customization in OM Module.
• HDCP Contract. (Developed three forms, also wrote utl script for the data loading into the new created tables. Applying a hold while booking the order for which a function has been added to the workflow.)
• Interacting with onsite for getting the requirements clarified and develop accordingly in the development environment.
• Developed the Oracle Alerts to satisfy the business requirements.
• Worked on Logical Apps Rules.
• Worked on Form Personalization and custom pll.
• Created AOL objects as per the project requirements
• Application bug fixes, enhancements and customization Setting up the causal factors and working
• Development, maintenance, enhancement and customization of Oracle Reports and Forms.
• Maintenance, enhancement and customization of inbound and outbound data interface programs.
• Unit testing and system integration testing.
• Preparing technical specification document and test cases and test result documents.
• Coordinating for functional testing with functional team.
• Migration of components to TST environment by coordinating with quantum database team.
• Review for all offshore deliverables including: a. Technical specifications document review b. Code Review b. Unit test document review c. Migration details document review
• Preparing weekly ITG Status Update Report
• Experience in creating Documentation using AIM Methodology.