EXPERIENCE SUMMARY:

• 8+ 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 Procure to Pay & Order to Cash (PO, AP, AR, GL, OM, INV, BOM, WIP), iProc, iSuppliers, iPayments, iExpenses.
• 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. and Alert Manager and invoking them from the different applications.
• 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) and developing theEDI & WebADI’s to import the data from flat files.
• Involved in designing the process flow for the legacy systems and creating the bridges between the legacy systems to oracle applications.
• Having the strong experience in OLTP (On-Line Transaction Processing) and OLAP (On-Line Analytical Processing)
• 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/Mulesoft/Workday.
• 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.5.10 to R12 migration as a part of Internal activities.
• Having the good experience in developing in developing the FSG (Financial Statement Generator Reporting (FSG).

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/ OPA/OTL/CM/PO/OM/INV,iReceivables, iProcurementiExpenses, HRMS/PAYROLL ), Hyperion

Languages: PL/SQL,J2EE, C, C++

Internet Technologies: Java Script, JSP, HTML,PythonTools xManager, TOAD, PVCS, CVS/SVN,Panaya, Athena, Kintana, SQL Navigator, SQL*Loader, FTP, Putty, Filezilla

PROFESSIONAL EXPERIENCE:

Confidential, CA

Sr. Oracle Apps Techno functional Consultant

Responsibilities:

• Involved in developing and customizations in Procurement to Pay & Order to Cash (PO/AP/AR/GL/CM/OM)
• Conversions from the Legacy systes for the AP/GL/PO.
• Analysis/Design/development on Integrations with 3rd party systesms. Integrations/Development activtiies
• Involved in designing and developing the database for the the Supplier Connect 3rd party application and also integrated with EBS.
• Involved in designing and developing the iBank 3rd party application which source for all the transactions in EBS.
• Involved in merging the legacy applications with iProcurement and developed the interfaces for the requisition/PO interfaces on schedule manner.
• Created the generic shell script by replacing all the shell scripts from P2P.
• Developed the mailer notifications based on the customer language for the following.
• Supplier onboarding
• Supplier Login Access related
• On creation of Banks/Sites or Both

Confidential

Sr. Oracle Apps Techno functional Consultant/ Solution Architect

Responsibilities:

• As a part of Implementation and supporting involvoved in the Financials/SCM/HRMS.
• 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 (HRMS) using the SFTP functionality.
• Creating and and developing the daily alert mailer programs as a part of monitoring process.
• Involved in developing the reports in OBIEE for the external systems data(ETL).
• Preparing the Technicla design documents for the new enhancements for the Procure to Pay and Order to Cash modules.
• Involved in developing the Dashboars in OBIA
• Created the new programs for the User/Resp assignments - AOL activities.
• Involved in designing and developing the New reports in Suppli Chain (SCM).
• Designed and developed the Concur Integration /Workday Integrations with Oracle EBS R12.
• Working with Concur team in designing and developing the data feed mapping.
• SFTP ssh key adding/ developing the shell script for the integration.
• Developing the PLSQL Package and Invoice Import programs.-Financials
• Mailer program with the status of the Imported invoices data and failure records with validation errors.
• Working with offshore in design/development on new enhancements with Confidential ’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

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.
• Integration and Item Master Conversion/Import Process
• Customization of Auto Invoice Import Program
• Sales Order/Invoice Processes using EDI Integrations
• Preparing the BR100 documents for all the future enhancements & developing the Design plan.

Confidential, Sunnyvale, CA

Sr. Oracle Apps Techno functional Consultant

Responsibilities:

• Involved in P2P/O2C(SCM) and HRMS following are the responsibilities for the same.
• 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.
• Consolidation reports once closing completed
• E-Mail Notifications to Group leaders
• 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.
• Daily Rates Interface
• Bank statement Import
• Invoice Interface
• Developed the design and documentation for dwh/workday/BI programs.
• Designed and developed the Concur Integration with Oracle EBS R12.
• Working with Concur team in designing and developing the data feed mapping.
• Developing the daily/weekly/monthly expense reports in EBS. Scheduling and pointing the SFTP location.
• Importing the data from the GL Currency converstion rates.
• Developing the Prevalidation and Journal Import program to upload in EBS.
• Mailer programs with status and validation reports.
• Designing and developing the below reports.

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

Responsibilities:

• Involved in P2P & O2C (Financials & SCM/HCM) extensively worked on the RICEW & Unix components.
• 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
• Supplier Conversion
• Invoice Conversion
• PO Conversion
• Customizing the Auto Invoic Import Program
• Reciepts interface/conversion.

Confidential, Houston,TX

Sr Oracle Apps Techno Functional Consultant

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

Oracle Application Technical Consultant

Responsibilities:

• Involved in Financials/SCM & HRMS
• 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 Financials/SCM and HRMS Modules
• 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.