SUMMARY

• 13 Years of extensive experience in Analysis, Design, Development, Testing, Customization, Bug fixes, Enhancement, Support and Implementation of Oracle Applications 11i and R12.
• Experience as a Techno - Funcitional consultant/Architect in Oracle EBS with major focus on Financial & SCM modules General Ledger(GL), Accounts Payables(AP), Account Receivables(AR), Cash Management(CM), Fixed Assets (FA), Order Management (OM)Inventory (INV) Project Accounting(PA) and Procure to Pay (P2P) cycle, Record to Report (R2R) and Order to Cash Cyscles (O2C).
• Extensive experience in RICEW components, TAR support, UNIX, Oracle SQL/PLSQL, Workflow, Forms and Reports 6i and SQL Loader, Project assignements include Implementation, upgrade, conversion and support of Oracle Apps systems.
• Extensive experience in creating Discoverer Reports/ XML Publisher(BI Publisher) reports and OBIEE/OBIA using various templates to publish the reports as per user requirements
• Good experience in requirements gathering, Design, Development of custom applications in Oracle application framework (OAF).
• Extensive experience in Oracle Application Object Library (AOL) features like value sets, Flex fields, Concurrent Programs, Profile Options, parameters and standard request submissions in the process of development
• Having the good experience in all the Conversion/Interfacing activitieis using the API’s and open interfaces in R12 with the core subject of Trading Community Architecture (TCA).
• Expertise in inbound and outbound interfaces and creation of automated process using Application Program Interfaces (APIs).
• Completed the Project Management Professional(PMP) training and involved in workshops, involved in designing the white papers for the project orientation programs.
• Involved in designing the process flow for the legacy systems and creating the bridges between the legacy systems to oracle applications.
• Designed and developed the release process for the objects migration using the various tools and created the centralized documentation.
• Very strong experience in understanding the business, requirements, GAP analysis & Mapping and led the POC for several complex business processes and Data Integrations/CEMLI/RICEW/BI/OBIEE/OBIA.
• Hands on experience with Oracle Discoverer which includes report development, Discoverer Administration, configuring Discoverer and End User Layer (EUL).
• Managing the Sandbox and performed the DBA activities to create the user, roles etc., within the organization and Involved in the all the conversion activities from 11. migration as a part of Internal activities.
• Experience in Oracle Practice Presales, leading coordinated effort for bid management and related activities like solution creation and coordination, knowledge management, quality assurance, presentations, proposals etc in the Oracle practice areas.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows NT/95/98/2000 Advanced Server, MS-DOS

RDBMS: Oracle 11G/9.x/ 8.x/SQLServer7.0

Application Tools: Reports & Forms 6i, Discoverer 9i, XML/BI Publisher, SQL*Loader,Microsoft VISIO.

ERP: Oracle E-Business Suite EAM (AP/GL/AR/CM/PO/OM/INV/iReceivables, iProcurementiExpenses, HRMS/PAYROLL )

Languages: PL/SQL,Java,Java,Script,C

Internet Technologies: Java Script, JSP, HTML

Tools: xManager, TOAD, PVCS, CVS/SVN, Kintana, SQL Navigator, SQL*Loader, FTP, Putty, Filezilla

PROFESSIONAL EXPERIENCE

Confidential, SFO

Sr. Oracle Apps Techno functional Consultant/ Tech Lead Consultant

Responsibilities:

• Converting the existing reports to Cloud IO reports.
• Desinged and developed the integration b/w workday/documentum/DWH to Oracle Applications.
• Developing the generic Unix shell scripts for all the workday integrations using the SFTP functionality.
• Creating and and developing the daily alert mailer programs as a part of monitoring process.
• Preparing the Technicla design documents for the new enhancements for the Procure to Pay and Order to Cash modules.
• Created the new programs for the User/Resp assignments - AOL activities.
• Working with offshore in design/development on new enhancements with ETA’s.
• Developing the Technical design documents and working with offshore team in development activities.
• Prioritizing the Enhancements/Issues and working with team to complete based on the time lines.

Confidential, SFO

Sr. Oracle Apps Techno functional Consultant/ Tech Lead Consultant

Responsibilities:

• SPOC for the business users/functional team in all the development activities, estimations/coordination/Leading the offshore team.
• Supporting for all the applications for US/EMEA regions.
• Involved in connection establishment b/w Oracle applications & JD Edwards for Sales Orders & Purching modules.
• Developing the Inboiund/Outbound Interfaces b/w Oracle & JD Edwards
• Developing the reports/Interfaces/.conversion/unix scripts/OAF pages/ADF pages in Oracle Applications R12.1.2 Financials & Supply chain modules.
• Developed the Shell scripts for the Integration activities.
• Preparing the BR100 documents for all the future enhancements & developing the Design plan.

Confidential, Sunnyvale, CA

Sr. Oracle Apps Techno functional Consultant/ Tech Lead Consultant

Responsibilities:

• Designing and developing the process for the all the oracle integrations (legacy systems).
• Developing he Unix scripts on FTP/SFTP processes and created the Generic script for all the Integration Scripts.
• Involved in designing and developing the custom interfaces for the Legacy systems in Purchaseing, Payables,Projects.
• Designed the process flow for the release activities and involved creating the centralized documentation.
• Developed the FA Automation Process with the following functionalities.
• Closing all the books at a time.
• Closing the books based on the Regions (APAC/AMER/EMEA).
• Consolidation reports once closing completed
• E-Mail Notifications to Group leaders for APAC/EMEA/AMER.
• Created the Shell scripts to create the directory for period wise and gathering all the report outputs.
• Created the Shell scripts for validating the report outputs and generating the status mail to business.
• Status of Errors in case of any book failed to close
• Developing and customization of the Reports, Interfaces, Workflow components (RICEW components) and Discoverer reports and SQL reports.
• Involved in designing the below integrations & Interfaces.
• Developed the design and documentation for dwh/workday/BI programs.
• Designing and developing the below reports.
• SPOC for the business users/functional team in all the development activities, estimations/coordination/Leading the offshore team.

Environment: Client server application written in Oracle running on UNIX. Oracle Apps 12i, SQL,PL/SQL,DEVELOPER 2000(FORMS-6i-10g,REPORTS-6i -10g, Discoverer, XML Publisher SQL * Loader, Toad 7.1.7.2 -9.0 , SVN Tortoise, CVS, D2K and Dev Suite 10g,BPEL,SOA, Connectivity VPN Client, Microsoft Office.

Confidential, WI

Sr. Oracle Apps Techno functional Consultant /Lead Consultant

Responsibilities:

• Developed the Reports in Purchasing using the XML Publisher.
• Developed the reports in Payables for the invoice amounts/debts for the critical customers.
• Developed the Customer Conversion using API’s.
• Developed the Custom program in Inventory on Item build for multiple palnts.
• Involved in customization of the OAF pages in Oracle receivables.
• Involved in all the below setups using the data loader.
• Sub inventory
• Shipping Networks
• Cycle count Aliases
• WIP Account Aliases
• Offshore activities: coordination with offshore team on the following.
• Supplier Conversion
• Invoice Conversion
• PO Conversion
• Customizing the Auto Invoic Import Program
• Reciepts interface/conversion.

Confidential - Houston,TX

Sr Oracle Apps Techno Functional Consultant- Lead Consultatnt

Responsibilities:

• Extensively worked on Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL), Order Management (OM).
• Involved in customization of the existing Open Invoice Import program (AP) using the 3rd party tool to dump the data in Oracle Applications.
• Created the New program for the Journal Import (GL) for the Journals data from legacy systems.
• Involved in designing and customizing the Workflow Notification process for the Project Approval Workflow for PA, PM and FA in Project Accounting (PA).
• Played the Major roles in implementing the Vertex/Sabrix Tax system in Oracle Receivables (AR) and creat ed the new tax programs for uploading the files from downloading vertex universal locator
• Worked on the third party Integrations such as IBS, Documentum, MES, and SSS for both Inbound and Outbound Interfaces in Purchase Order Module and Receivables Modules (PO and AR).
• Implemented Auto Lock Box by importing data into staging table by writing control file according to bank transmission format.
• Worked onrequirement gathering, designanddevelopmentof custom applicationSupervisor Information Management System(SIMS) inOAframework.
• Worked extensively in custom.pll and form personalization for the sales order, customer standard forms.
• Involved in development of new interfaces/reports/customization of the existing reports using the XML Publisher reports in P2P, Order to Cash (O2C).
• Created the lookups/DFFs/Valusets and uploaded the values to identify the critical customers based on the requirement in Inventory (Inv).
• Designed the custom program to cancel the sales order Booked/Pick Release statuses in Order Management and created the oracle alerts & Notifications on the order status for Booked/Pick release in OM.
• Extensively worked on Supporting activities ie Breakfixes/Enhancements and implemented the permenant fixes with repository documentation.

Environment: Client server application written in Oracle running on UNIX. Oracle Apps 12i,11i, SQL,PL/SQL,DEVELOPER 2000(FORMS-6i-10g,REPORTS-6i -10g, XML Publisher SQL * Loader, Sql Developer, SVN Tortoise Tool, CVS Tools, Confidential Libraries.

Confidential, Brea, CA

Sr.Oracle Applications Techno Functional Consultant/Architect/Lead Consultant

Responsibilities:

• Extensively worked on Order to Cash & Procure to Pay - Order Management, Inventory, Bill of Materials and Work in Process & Accounts Payables, Accounts receivables, General Ledger.
• Customized the existing interfaces in Order Managements.
• Sales Order Import program
• Receipts Interfaces
• Auto Invoice Import Program
• Customized the below reports in Order Management using the BI/XML Publisher report
• Sales Order Acknowledgement report
• Bill of Lading
• Pick Selection List Generation
• Pick Slip Report
• Shipping Execution reports
• Extensively worked on Procure to Pay (P2P), Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL), Cash Management (CM).
• Extensively worked on devolping/customized RICEW, XML/BI Publisher components in Procure to Pay (P2P), Order to Cash (O2C).
• Created the Shell Scripts to invoke mailer notifications for the standard/custom program for Monitoring activities.
• Involved in designing and developing the Bank Statement Import program in Cash Management (CM).
• Designed and developed the new interface for Kelly Open Invoice Import program (AP) from the Legacy system.
• Customized the reports ie Order Detail Report, Credit Order Summary Report, Orders by Item Report in Order management in oracle rdf and xml publisher.
• Designed and developed custom program to load EDI 850 inbound Orders into Order Management.
• Customized the Credit Analysis Report, Trucking Manifest and Pick Slip reports in Order Management OM.
• Involved in Performance tuning and explain paln to improve the performance by analyzing the trace file/tkprof.

Environment: Client server application written in Oracle running on UNIX. Oracle Apps 12i,11i, SQL,PL/SQL,DEVELOPER 2000(FORMS-6i-10g,REPORTS-6i -10g, XML Publisher SQL * Loader, Toad 7.1.7.2 -9.0 , D2K and Dev Suite 10g,BPEL,SOA, Connectivity VPN Client, Microsoft Office

Confidential, Santa Clara,CA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Involved in the folllwing data conversion activities
• Modifying the existing reports prior to converting to R12 based on the table and columns mappings.Involved in preparing the custom lookups and DFF’s to map the columns with target systems prior to loading.
• Personaliztion done for few of the Customer forms to plug the additional columns using the DFF’s and validating from PLSQL Package to accommodate the client changes.
• Involved in preparing the coding standard docuaments, delivery packages, repository documents etc.,

Environment: Client server application written in Oracle running on LINUX. Oracle Apps 12i,11i, Polar Application, SQL,PL/SQL,DEVELOPER 2000, GCN,Sun Specific tools, SQL * Loader, Toad etc.

Confidential, Santa Clara

Oracle Applications Technical Consultant

Responsibilities:

• Extensively worked on RICE components (Reports, Interfaces, and Conversions).
• Involved on this project and given the support for APAC region in the financial modules and Oracle Project Accounting (OPA).
• Involved developing the interfaces FFD, FEX, FPO, FEB in OPA 11.0.3
• Developed the tool i.e polar application to raise the requisitions for user friendly.
• Creating the object delivery package and creating the LDT scripts for the concurrent program and request group.
• Developed the and documented the time estimation report for all the objects development.
• Involved in developing the Mail program to transfer the all the purchase orders based on the business validations.

Environment: Client server application written in Oracle running on LINUX. Oracle Apps 12i,11i, 11.0.3, 10.7 Polar Application, SQL,PL/SQL,DEVELOPER 2000, REPORTS-6i -10g, XML Publisher SQL * Loader, GCN,Sun Specific tools, Toad, Putty etc.Client: Qatar Airways, Doha, UAE (R12 Implementation)