Oracle Products/Tools/APIS: Oracle 11g/10g/9iForms 6i/9i/10g, Reports 10g/9i6i, Oracle Financials Accounts Payable AP /General Ledger GL Accounts Receivable AR Release 11i/R12, ORACLE INVENTORY , Oracle CRM Applications, TCA Trading Community Architecture, Oracle Federal Financials R12,Oracle Incentive Compensation OIC 11i, Oracle Customer Care/Teleservice 11i/R12 ,Oracle HRMS 11i/R12,Oracle Install Base 11i/R12 , Oracle OMS Order Management System 11i with Oracle Order Capture/istore ASO , Order Entry, Application Object Library, Concurrent Manager, Oracle Alerts, PL/SQL ,SQL Plus,Oracle Workflow Builder/Oracle Workflow, Jdeveloper, BC4J Business Components For java , UIX, Oracle 9ias oracle application server , XML publisher, JSP, Oracle BPEL, web services, FND Api's, Financials API's, Open Interfaces, HRMS Api's, TCA Api's,Forms Personalization, OAF/Form Personalizations,Custom.pll

Operating Systems: HP-UX, Ultrix, Sun O/S,Linux

Languages: C, Fortran, PL/SQL v2.0/2.3, Pro C, Java

HCL Consulting

Confidential

Modules : Oracle Purchasing/Payables/GL/Customized Receivables/Oracle TCA/ Service

Description:

• Performed the role of knowledge lead/team lead technical and functional for the team members to resolve critical issues of the system for entire life cycle of gap analysis, design, development, configuration and testing using Oracle EBS standards and guidelines for Oracle EBs upgrade of the system
• Performed design sessions, training sessions technical/EBS for key business holders to understand the system and the changes from 11i application to R12.
• Analysis and program modifications for performing the technical upgrade
• Changes included SLA for GL interfaces into general ledger, Oracle Payables TCA bank information fixes, Supplier TCA integration changes and building new Accounts Payable reports for invoices and purchase orders procure to pay , TCA Screens like party/account merge, relationship manager, Service Requests and Contact Center.
• Of existing 11i programs to Oracle Federal Financials R12 upgrade including Oracle Forms, Oracle Reports, Oracle XML reports, Oracle R12 financials configuration like value sets, custom views, tables, workflows, Profile Options, Descriptive Flexfieds/validations, personalizations etc.
• Responsibilities also included designing and developing new XML publisher SLA accounting reports, Accounts Payable payments reports, personalizing the contact center form for new TCA model.
• Designed and developed GL interface from the customized Receivables module to Oracle SLA and Journal Import.
• Documented and Designed the above solutions using client Software Life cycle methodology and Oracle's functional/technical configuration documents like BR100 and conversion/interfaces documents.
• Assisted in managed the Quality Center defect fixes in SIT testing and UAT
• Created Technical Design Documents according to Client's software lifecycle requirements covering design of custom components, customizations, enhancements and configurations.

Confidential

Modules : Oracle Inventory R12/Oracle Install Base R12

Description :

• Designed and developed XML Publisher/ Reports and Shell Scripts to schedule the reports for tracking the Orders along with the inventory details for specific calendar yrs and inventory orga units.
• Designed and developed interface for loading inventory items into the application using inventory open interface/workers processes.

Confidential

Oracle Financials Solutions Architect Description :

• -Created the strategy to upgrade/financial transformation of Existing Oracle 11i Suite of financial applications including all the business units in Mexico, Brazil, USA, Chile including financial transformation for the organization.
• -Designing the architecture for a single global R12 financials instance for NII including integration with 3rd party tax and billing systems.
• -Leading a team of onshore and offshore resources/techno functional analysts for analysis and technical design for Oracle EBS R12 financials.

Confidential

Oracle Applications Specialist

Description :

• This is an Oracle 11i/R12 teleservice / Shared HRMS/Oracle Inventory/Oracle install base/receivables implementation of Oracle Applications. The implemented application tracks and analyzes various interactions between call center and customers of client.
• Functionally analyzed new business requirements determining the most efficient and effective means of implementing them in the Oracle CRM, leading to technical and functional design for the product. The design consisted of conversion/interface strategy, error correction process and re executing the conversion/interface programs frquenetly.
• Developed/Designed and supported inbound process from legacy applications Conversion process to load customer information using Oracle Financials/TCA/Receivables API's. The customer information involved all the TCA/Financials information like Sites, Contact Points,Party Information, Financials customers accounts. The public financial API's used was mainly HZ PARTY PUB to load/maintain the customer information.
• Designed and developed conversion/interfaces for inventory items into Oracle inventory for tracking the call center interactions from the legacy system and integration with external systems.
• Also was involved in setting up of Lookup Flexfields using Oracle receivables configuration for site, site usages, location information, and customer profile data. Configured Receivables location descriptive flexfields using Oracle Receivables Setups Screens to capture site information in relation to plans a PBGC customer participated in along with various AR lookups.
• Designed and built reports using Oracle BI Publisher/XML Publisher for Oracle TCA/Receivables Module displaying all the customer information along with service module information from Receivables tables like HZ PARTIES,HZ CONTACT POINTS, HZ LOCATIONS, HZ PARTY SITES etc.
• Developed outbound interface using receivables TCA tables and RA CUSTOMERS views
• to sync information with the legacy application system. All the customer data change happening
• in the database using Oracle Receivables screens was updated constantly to legacy application tables to keep both systems in sync.
• Designed a BPEL process for integration of legacy applications with Oracle CRM R12 for processing special pension plans, which undergo continuous eligibility. This involved loading all the relationships between PBGC Plans and customers tracking using install base APIs and creating of Plans as inventory items. All the plans a customer was participating in was being tracked using install base application. The install base module was configured to populate the data in CSI ITEM INSTANCES table with all the flexfield information populated. The flexfield information in the install base table was the information highlighting the type of relationship between customer and the plans involved including payee status, start and end dates etc. . This also involved developing an interface between legacy client application and install base to store the relationship between pension plans and PBGC customers on daily basis leading to syncing the Oracle EBS instance with legacy applications.
• Maintained the BPEL processes integrating CRM with PBGC document archiving application and customer self-service applications.
• Designed and developed employee resource inbound interface for loading employee and organization information into Oracle HR and service application. A workflow process was developed to track the interface program results and performance. Also analyzed and documented the architecture of the interface using the employee information soap services PBGC's SOA architecture using BPEL to be invoked directly from the Oracle database to synchronize the HR information.
• Enhanced the VPD Virtual Private Database / RLSS Row Level Security security of Oracle 11i applications with new database policies and completed the modification of the existing database policies. The security of these policies was dependent upon various web services invoked using the SOA architecture BPEL Server hosted from the database to provide different levels of access to different users of the application.
• Analyzed the existing 11i requirements to perform the gap analysis and provide solutions for filling the gaps in 11i to the release 12 upgrade of the application. Supported the Oracle 11i production environment for PBGC, including issue resolutions, enhancements and handling of new business requirements. Designed and developed workflow process for integrating Oracle Email Center with Oracle Teleservice module. Designed and developed workflow process to notify the administrators of various pension plans when a customer creates a service request in the application.
• Tuned the outbound interface process responsible for updating the PBGC HR system from Oracle Service/HR module. Performed the task of deploying the programs and configuring the application in production for Oracle Teleservice module, utilizing the configuration of Service Requests/Interaction Tasks/Universal Work Queue UWQ . Designed and developed a workflow process in relation to the Business Event Subscription Model of Oracle 11i to deactivate existing contact information for Service Requests in Oracle Teleservice module.
• Designed and developed Oracle Reports and XML Publisher reports for tracking service requests, plans, relationship between plans and customers in inventory/install base
• Designed and customized JSP for printing Oracle Service Request's as per business requirements. Involved in the upgrade of Oracle eBusiness Application From 12.0 release to 12.1.2. Involved in production support of the application.
• Developed DEMO APEX screen for custom schemas for proof of concept along with Oracle OAF development and maintain VPD policies in the database.