SUMMARY

• Around 8 years of extensive experience in IT industry as Oracle applications technical and techno functional consultant. Very strong in Oracle financials and supply chain management modules and techno - functional experience in analyzing business requirements, translating to technical requirements.
• Worked on development all RICE components, troubleshooting RICE components. Good understanding on complete life cycle right from development, testing till deployment using various migration tools.
• Hands on experience in Oracle ERP Applications -
• Order Management(OM),Shipping(WSH),WIP,BOM, Cash Management, Oracle Payables, General Ledger, Pricing,Payables,Purchasing,Inventory(INV), Oracle Receivables, Oracle Alerts, exposure to Oracle HRMS.
• My responsibilities have exposed me to functional as well as technical aspects of enterprise applications.
• Worked with consulting companies like Accenture & Tech Mahindra formerly known as Satyam Computer services.
• Experienced in the design of System Requirement specifications, functional designs, Business Process re-engineering, Workflow, Test plan preparation, Peer Review, Unit testing, System Integration Testing and Documentation using AIM methodology.
• Good Technical Development skills in RICEW components (Reports, Interfaces, data Conversions, Extensions and Oracle Workflow) in the domain of Oracle Applications E- Business Suite using SQL,PL/SQL and Developer 2000.
• Expertise in suite of Oracle developing Tools including SQL, PL/SQL, Forms 4.5/6i, Reports 2.5/6i/10g, Discoverer 10g.
• Proficient in writing PL/SQL Packages, Stored Procedures, Functions, Database Triggers and SQL * Loader scripts.
• Expertise in Oracle Applications R12 and Order to cash cycle and Procure to pay cycle.
• Expertise in Entity/Relation Data Modeling using Informatica ETL, and Discoverer 3.x and 4i/9i.
• UNIX shell scripting; Windows NT, Linux
• Troubles hooted, fixed, and implemented bug fixes and enhancements within tight deadlines
• Exposure to ADF, SOA architecture, EAI technologies such as BPEL and XML technologies.

TECHNICAL SKILLS

Oracle Technologies: Oracle E-business Suite(11i/R12), E-service Bus(ESB),BPEL

Oracle Apps Modules: GL, AP, AR, PO, CM, OM, INV, BOM, IPayment, IProcurment, IExpenses, Advanced Pricing

Languages: SQL, PL/SQL, Java, HTML, BPEL, C, SQL * Plus

Oracle Tools: Discoverer, BI/XML Publisher, Toad, Forms, Reports, SQL* Loader, Appworx 6.0, Kintana.

Web/App Servers: ERP- Oracle Applications R12/ 11i (11.5.10, 11.5.9)

RDBMS: MS SQL Server 2005,Oracle 10g/9i/8.i, MS Access

OS: Unix, Windows-NT/2000, HP UX RISC.

PROFESSIONAL EXPERIENCE

Confidential, Glendale, CA

Oracle apps Consultant

Responsibilities:

• Involved in the Modules: General ledger, Account Payables, Receivables.
• Worked on Customers Extract And Customer Conversion for R12
• Developed PL/SQL APIs (functions, triggers, views, tables, table spaces, procedure) for various modules.
• Custom Programs are developed using PL/SQL and UNIX scripting
• Developer Unix script to get TAR files and developed Migration Scripts using FNDLOAD commands to download and upload LDTs which used to migrate all the objects from Dev. instance to test and production instances
• Developed custom program to run Auto lockbox report automatically.
• Client interaction through meetings & presentations
• Gathered requirements for various RICE elements from the Business users.

Environment: Oracle Applications R12,GL,AP,AR,SQL, PL/SQL,TOAD, XML publisher,Appworx, Unix scripting.,RICE

Confidential, Milpitas, CA

Oracle Apps RICE Developer (Rollout to 11i)

Responsibilities:

• Involved in the Modules: Order Management, Inventory, General ledger, Purchasing, Account Payables, Receivables, and IExpense, General Ledger, Install Base
• Involved in creating documents like (MD 50, MD70 and MD120) functional, technical and Installation documents for all CEMLIs.
• Gathered requirements for various RICE elements from the Business users and created functional technical design documents.
• Prepared design document (AIM) MD-50 & MD-70 for various RICE elements
• Communicating with Business users for understanding of the requirements based on Functional specification.
• Responsible for preparing the technical specification from the functional requirements Document, designing the program, unit testing and production migration.
• Customization of reports as per the client requirement. Creating the Service Requests with proper documentation and working with Oracle On Demand for migration of codes to respective instances
• Customizing of XRT Payments specific to Germany and France.
• Developing conversions and Interfaces for both I/B & O/B.
• Development of Reports 6I and XML reports.
• Performing the reviews for the other team member’s technical designs and code.
• Developing New B2B process for the France customers and scheduled the programs for every 5mins.
• Co-ordination with other teams including the Functional team, Sys admin, DBA and other third parties (Legacy Systems) for issue resolution.
• Developed a Custom Periodic Alert and automated the process.
• Migration Activities.
• Preparing the Test cases & User manuals documentation.
• Responsible for retrospective issues
• Worked on Sourcing Rules and Assignments Conversion
• Worked on Customers Conversion.
• Involved in AP Invoice Conversion
• Worked on sales order Extract and Conversion
• Developed Common code Utility package to reuse the functions for all conversions and interfaces.
• Worked on Purchase Order conversion program.
• Worked on complete procure to pay cycle.
• Developed below XML Publisher reports.
• Link Chain Index Calculation Report in Cost Management.
• Back Order, on/off Back Order Report.
• Developed PL/SQL APIs (functions, triggers, views, tables, table spaces, procedure) for various modules.
• Worked on creating Oracle Alerts.
• Custom Programs are developed using PL/SQL and UNIX scripting
• Developer Unix script to get TAR files .and ddeveloped Migration Scripts using FNDLOAD commands to download and upload LDTs which used to migrate all the objects from Dev. instance to test and production instances
• Client interaction through meetings & presentations

Environment: Oracle Applications 11i, OM, GL, AP, AR, INV, PO, Oracle Alerts, SQL, PL/SQL, TOAD, XML publisher, Discoverer Reports, Unix scripting, RICE

Confidential, Milpitas, CA

Oracle apps Techno Functional Consultant (Implementation)

Responsibilities:

• Involved in the Modules: Order Management, Inventory, GL Account payables, Purchasing, Receivables, IExpense.
• Customization of reports as per the client requirement.
• Development of Reports 6I and XML reports in AP, PO and GL.
• Fixing of errors and bugs in while user acceptance testing
• Created New Value sets, Concurrent Programs and Request Sets
• Decommissioning old programs are not running for many months
• Customizing new enhancements as per the client requirements.
• Responsible for preparing the technical specification from the functional requirements Document, designing the program, unit testing and production migration.
• Responsible for monitoring the production jobs and resolve production issues.
• Developed custom Packing slip report using XML Publisher.
• Worked on EDI supplier invoices interface based on that EDI supplier invoices (EDI 850/870 files) interface program creates an Invoice in Oracle EBS.
• Communicating with Business users for understanding of the requirements based on Functional specification.
• Responsible for preparing the technical specification from the functional requirements Document, designing the program, unit testing and production migration.
• Customization of reports as per the client requirement. Creating the Service Requests with proper documentation and working with Oracle On Demand for migration of codes to respective instances
• Migration Activities.
• Involved in creating documents like (MD 50, MD70 and MD120) functional, technical and Installation documents for all CEMLIs.
• Involved in creating Demantra functions
• Extended Controllers (CO) and made personalization’s to work aggregate spend transactions from within the standard iExpense flow.
• Worked on Compliance Tracking Audit report.
• Worked on Decommissioning jobs which are not running long time.
• Worked on change request for Purchase price variance discoverer report.
• Worked on change request for Item Roll Forward Report.
• Custom Programs are developed using PL/SQL and UNIX scripting
• Developer Unix script to get TAR files .and ddeveloped Migration Scripts using FNDLOAD commands to download and upload LDTs which used to migrate all the objects from Dev instance to test and production instances
• Client interaction through meetings & presentations
• Trouble shooting and Support - Assisted Client for User Acceptance Test.

Environment: Oracle Applications 11i, GL,AP,AR,FA,INV,PO,OM,Service Contracts,SQL, PL/SQL, Java, TOAD, XML publisher, Discoverer Reports, Unix scripting,Demantra,RICE

Confidential, SFO, CA

Oracle apps Technical Consultant (11i to R12 Upgrade)

Responsibilities:

• Involved in the Modules: Account payables, Purchasing, GL and Inventory.
• Worked on XML templates in etext format for electronic and EFT payments.
• Creating bank check formats using XML publisher.
• Migration Activities.
• Performing the reviews for the other team member’s technical designs and code.
• Providing estimations to the new change requests
• Migrating 11i Reports into R12.
• Developing Reports.
• Fixing of errors and bugs in while user acceptance testing
• Involved in creating documents like (MD 50, MD70, and MD120) technical and Installation documents for all CEMLIs.
• Worked on integration process with external system (Connectship) to shipping modules for freight charges calculation and tracking number and shipped quantity updates.
• Responsible for retrospective issues
• Worked on EDI supplier invoices interface (UPS weekly sends invoice to BIC through Extol-Electronic invoice) based on that EDI supplier invoices (EDI 850/870 files) interface program creates a Invoice in Oracle EBS.
• Worked on Connectship exception report and Auto ship confirm exception report.
• Created Purchase Order conversion program.
• Customizing the reports for the specific country and languages
• Worked on Supplier conversion program.
• Worked in EDI PO attachment report to Sales order attachments.
• Developed PL/SQL APIs (functions, triggers, views, tables, table spaces, procedure) for various modules.
• Custom Programs are developed using PL/SQL and UNIX scripting
• Developer Unix script to get TAR files .and ddeveloped Migration Scripts using FNDLOAD commands to download and upload LDTs which used to migrate all the objects from Dev instance to test and production instances
• Client interaction through meetings & presentations
• Trouble shooting and Support - Assisted Client for User Acceptance Test.

Environment: Oracle Applications R12, AP,AR,INV,GL,PO,HRMS,BOM, SQL, PL/SQL,, TOAD, XML publisher, SQL Loader, Unix scripting

Confidential, Santa Clara, CA

Oracle Apps Developer (11i)

Responsibilities:

• Involved in the Modules: Account Payables, General Ledger, Order Management, Invenotry and Procurement.
• Customized Standard 6i reports to XML/BI Publisher Reports.
• Developed custom Packing slip report using XML Publisher..
• Developed PL/SQL APIs(functions, triggers, views, tables, tablespaces, procedure) for various modules (Order Management, HRMS)
• Customized Forms, Reports and also PL/SQL APIs to import data into custom tables from various base tables.
• Involved in developing custom Interface for extracting Employee (assignment information) and Vendor information from HR (11i) to R12.
• Involved in designing and developing MD050 and MD070 documentation for necessary requirements.

Environment: Oracle Applications 11i,,OM, INV,AR, GL,PO,AP, HRMS, Reports, SQL, PL/SQL, J TOAD, SQL Loader, Unix scripting, Form 6i/Reports 6i.

Confidential, CA

Oracle apps Finance Technical Developer (Rollout Project)

Responsibilities:

• Involved in the Modules: Account Payables, AR, INV, Cost Management, Order Management, General Ledger, Sub ledger Accounting and HRMS.
• Involved to develop Technical Design, UTP Documents and Installation documents for all components.
• Worked on sales order conversion
• Fixed Assets Mass editions Conversion
• AP Invoice Conversion and AR Invoice Conversion.
• Worked on custom report on prepayments that are permanent by supplier.
• Worked on Sales order conversion using Order Import program.
• Custom Inbound interface setup using PL/SQL packages, procedures and functions UNIX shell scripting, SQL Loader and Oracle API’s
• Worked on Extensions
• Developed GL daily rates conversion
• Customizing the reports for the specific country and languages
• Trouble shooting and Support - Assisted Client for User Acceptance Test.
• Developed FND Load Scripts to migrate the reports from one instance to other.
• Automated the process of migrating Data Definitions and Templates from Instance to Instance using FND scripts.
• Involved in preparation of various documents like MD070 documents.
• Responsible for troubleshooting, offshore team and resolving the day-to-day issues regarding XML output generation.

Environment: OracleApplications 11i (11.5.10.2 ),GL,AP,AR,INV,OM,PO,HRMS, CM,Ipayments,OracleWorkflowBuilder,AOL.