SUMMARY:

• Solutions - Oriented Sr. Oracle Apps. Techno Functional Consultant with over 14 years+ of demonstrated experience in Design, Coding, Testing, Implementation, Customizations, Conversions and Interfaces of Oracle based business applications trouble-shooting skills in IT industry.
• Worked in Oracle Applications Release 11.5.3i, 11i, R12 consisting of Oracle Payables, Oracle Receivables, General Ledger, Order Management, Purchasing, Inventory, Service Contracts, Install Base, Sys Admin, XML Publisher, Alerts and Workflow modules. Strong technical skills in Oracle Forms 4.5/6i/9i, Reports 2.5/6i/9i, SQLPLUS, PL/SQL, and SQL*Loader. Experience in Oracle AIM technical documentation and familiar to Oracle 11i Upgrade and its Implementation. Very good in RICE/CEMLI.
• Possess exemplary skills in written and verbal communications, interpersonal relations, and time management. Reputation for ability to interact easily with co-workers of diverse backgrounds, cultures, professional and technical levels.
• Generated substantial customer satisfaction and goodwill by continuously meeting deliverables on time, exceeding targets and objectives for projects.
• Consistently present a high profile, professional demeanor, energized by challenges, steep learning curves and high pressure deadlines and complemented by a positive, "can-do" attitude. Self-starter and team player with excellent communication, problem solving skills, interpersonal skills, and good capacity for learning.
• Experience in working with Oracle Support to investigate and resolve critical problems with systems identified during system Implementation.
• Having immense & estimable knowledge base in Quote to Cash and Procure to Pay, SCM and Manufacturing moduels.
• Worked on Customer Data Hub(CDH)
• Managed and implemented BI projects by using Informatica, ODS, OBIA and OBIEE.

TECHNICAL SKILLS:

Operating Systems: AIX/ HP/SUN UNIX, Windows

Software: Oracle 7.x/8i/9i/10g, Developer 2000 (Forms 4.5/6i, Reports 2.5/6i), SQLPLUS, PL/SQL, SQL*Loader, Oracle Financials (Oracle Receivables, Oracle Payables and General Ledger), Purchasing, Order Management, Inventory, Service Contracts, Install Base, AOL, System Administration and workflow 2.6.3. Having excellent knowledge in Informatica, OBIA, OBIEE and Shareplex.

EXPERIENCE:

Confidential, Scotts Valley, CA

Techno Functional Lead

Responsibilities:

• Working as a techno functional lead for R12 reimplementation project from 11.5.10.
• Working on Financials modules customizations, issues and new extensions.
• Working on 11i to R12 upgrade issues on financial modules.
• Resolving CRP2, SIT and UAT issues by sitting with business users.
• Working with Oracle on Severity 1 SR’s.
• Working on SLA customizations like Subledger Accounting Method(SLAM), Application Accounting Definition(AAD), Journal Line Type(JLT), Journal Line Description(JLD), Application Derivation Rule(ADR) and Mapping Set.
• Changed all existing 11i reports in R12 by adding SLA data structure from AP -> GL, AR-> GL, FA->GL and PO->GL.
• Have good knowledge between source to target through SLA mappings.
• Changed REC and REV accounts from AR to SLA/GL by using SLA customization.
• Fixed all XML publisher existing reports as per R12 data structure.
• Worked on Intercompany reports.
• Created SIT test scenarios for Invoice to Cash flow.
• Participated Business SIT sessions with worldwide users and executed all SIT test scenarios.
• Worked on Credit Check API and Credit Management System.
• Gathering requirements from business and peparing BRD and Functional Designs.
• Worked on LaCie Customer Conversion by using CDH bulk load.

Confidential, San Jose, CA

Techno Functional Lead

Responsibilities:

• Worked as a techno functional lead for R12 upgrade project.
• Worked on Financials module issues.
• Worked on Service Contracts module upgrade issues.
• Worked on 11i to R12 upgrade issues across the modules.
• Managed Discoverer reports with the help of offshore team.
• Resolved UAT issues by sitting with business users.
• Worked with Oracle on Severity 1 SR’s.
• Worked on Tax rate codes issue. Updated expense account as liability account for UK tax rate codes.
• Worked on SLA customizations like Subledger Accounting Method(SLAM), Application Accounting Definition(AAD), Journal Line Type(JLT), Journal Line Description(JLD), Application Derivation Rule(ADR) and Mapping Set.
• Changed all existing 11i reports in R12 by adding SLA data structure from AP -> GL, AR-> GL, FA->GL and PO->GL.
• Have good knowledge between source to target through SLA mappings.
• Fixed all XML publisher existing reports as per R12 data structure.
• Worked on Customer Data Hub.

Confidential, San Jose, CA

Techno Functional Lead

Responsibilities:

• Worked and Managed HMU (Hosting, Migration and Upgrade) project.
• Working on both P2P and O2C modules.
• Working on Sales Orders Import Interface issues.
• Working on OEOH and OEL workflow issues.
• Working on Service Contracts and Install Base module issues.
• Working on Finance modules work orders.
• Extensively worked on manufacturing modules.
• Working on TCA API’s.
• Working on Custom Workflows
• Working on PO conversion issues.
• Worked on Contract Status update program by using API’s.
• Creating Test cases and test scripts for customizations.
• Working on entire BI projects(EBS->ODS->INFA->BI-DB->OBIEE)
• Working on day to day support issues on both BI and EBS system(Finance, PO,OM, SC and IB modules) issues
• Managed 15 offshore resources from two different vendors
• Successfully migrated 20 BI servers from PETALUMA data center to Santa Clara data center
• Successfully delivered 50 BI operational reports by using OBIA/OBIEE
• Working with 8 business groups users, super users and BPO’s.
• Implemented an interface between FRACAS->EBS->ODS->BI by using SQL, PLSQL, Informatica, OBIA and OBIEE.
• Worked and managed several cross functionality systems(Agile, Workday, EBS R12, PQO, JIRA,Syntellect, ODS, SFDC, Informatica and BI)
• Working on Challenging project Bookings Single Source of Truth(SSOT) by doing Sales Order Lines subject area customization in OBIA.
• Successfully convinced users to use one enterprise reporting tool ie;OBIEE
• Convinced business users to stop using different third party reporting tools.
• Integrated and built RMA interface between SFDC -> ODS -> EBS and then interfaced data into BI system for reporting purpose.
• Integrated and built Accounts and Contacts interface between SFDC -> ODS -> PQO and then interfaced data into BI system for reporting purpose.
• Having good knowledge on Boomi FTP tool
• Managed contract manufacturer daily files by using SQL*LOADER.

Confidential, Sunnyvale, CA

Senior Oracle Techno Functional Consultant

Responsibilities:

• Working on PVR workflow approval process.
• Working on Prebuild workflow approval process.
• Working on XML Templates.
• Working on daily defects.
• Working on MD070, TE020.
• Extensively worked on P2P modules.
• Developed Item Interface program to load items, items assignments, item categories, customer items, cross references into multiple inventory orgranizations.

Confidential Palo Alto, CA

Senior Oracle Techno Functional Consultant

Responsibilities:

• Worked on Service Contract Conversion daily issues.
• Worked on Sales Orders Import Interface issues.
• Worked on OEOH and OEL workflow issues.
• Worked on Install Base issues.
• Worked on TCA API’s and Customer Data Hub(CDH) Sync.
• Worked on PO Approval Workflow issues.
• Worked on PO Requisition Workflow issues.
• Worked on Custom Workflow for sending notifications to Saelsrep and employee hierarchy for expiring contracts in 0 days, 30 days and 60 days.
• Worked on CUSTOM.pll customization for calling a custom form from Service Contracts main form.
• Worked on QA Check customizations in Service Contracts.
• Worked on Contract Status update program by using API’s.
• Creating Test cases and test scripts for customizations.
• Worked on Forecasting and Booking reports.
• Worked on Project integration test scripts.

Confidential, Sunnyvale, CA

Senior Oracle Techno Functional Consultant

Responsibilities:

• Working on GL interface from external system ALOG to Oracle Applications by using GL Interface.
• Worked on O2C and P2P modules.
• Worked on Sales Orders Interface daily errors.
• Worked on reconciliation reports between Service Contracts and Receivables.
• Worked on Purchased Order Import issues.
• Worked on Service Contracts Main billing program.
• Worked on TCA API’s and Customer Data Hub(CDH) Sync.
• Worked on OEOH and OEL workflow issues.
• Worked on Manufacturing modules WIP, OM and BOM.
• Worked on Install Base Conversion from SND to 11i.
• Worked on Service Contracts Conversion from SND to 11i.
• Worked on daily interfaces(Customer/IB/Contracts) sync between SND to 11i.
• Created Test cases and test scripts for customizations.

Confidential, Sunnyvale, CA

Senior Oracle Techno Functional Consultant

Responsibilities:

• Worked on Customer Conversion from 11.5.9 to R12 by using TCA API’s.
• Worked on Sale Orders Coversion.
• Working on TCA API’s and Customer Data Hub(CDH) Sync.
• Worked on Customer conversion errors.
• Developed Item Interface program to load items, items assignments, item categories, customer items, cross references into multiple inventory orgranizations.
• Worked on PO conversion.
• Worked on Install Base Conversion from 11.5.9 to R12.
• Worked on Service Contracts Conversion from 11.5.9 to R12.
• Worked on Warranty Conversion in to R12 data is coming from Ship Serial third party system.
• Worked on daily interfaces (Customer/IB/Contracts) sync between 11i to R12.

Confidential, Mountain View, CA

Oracle 11i Applications Senior Principle Oracle Analyst

Responsibilities:

• Worked on PO Requisitions workflow customizations.
• Worked on PO Approval workflow customizations.
• Worked on Functional and Technical design documents.
• Worked on Unit test scripts and Test plan documents.
• Worked on Customer conversion TCA API’s.
• Created new PO requisition through iProcurement and tested the functionality up to creating the Purchase Order after requisition approval.
• Supported issues on PO Requisition approval process and PO approval process.
• Worked on new employee user responsibilities creation program.
• Created Test cases and test scripts for PO requisition, Standard Purchase Orders.

Confidential, Mountain View, CA

Oracle 11i Applications Senior Principle Business Analyst

Responsibilities:

• Worked on Altiris Customer Conversion Business Requirement Document(BRD).
• Worked on Functional Business Technical Review Document(FBTR).
• Worked on each phase Work Product Review Document(WPR’s) for design, coding and testing.
• Worked on O2C and P2P modules.
• Worked on Install Base and Service Contracts Conversions.
• Worked on D&B matching interface.
• Worked on Technical Design Document(TD).
• Worked on Customers Conversion in both 11i and R12.
• Resolved any sync issues between ERP and R12.
• Created Unit Test Cases and User Acceptance Test Plan Documents.
• Worked on Order Capture processing and also resolving issues related to Order Interface.
• Worked as an SME for Oracle Receivable, Product Data Hub(PDH) and Customer Data Hub(CDH).

Confidential, Mountain View, CA

Oracle 11i Applications Senior Principle Consultant

Responsibilities:

• Worked on Sales Orders Interface.
• Worked on PO interface
• Worked on 3.5 million customer conversion in to Customer Data Hub by using bulk import feature in release R12.
• Worked on Alerts and Workflow.
• Updated Customer contact information (Phones and Email) by using TCA API’s.
• Worked on Error Handling Implementation for all interfaces.
• Migrated all Custom Responsibilities, Menus, Request Groups from once instance to other instances by using standard FNDLOAD API’s in shell script.
• Developed new Oracle forms for defining workflow rules and workflow approval hierarchies by using TEMPLATE.fmb
• Reviewed MD050’s and meeting with Business Analysts for gathering high level designs.
• Worked with offshore folks to resolve technical issues and also gaps in MD050’s.
• Worked on CUSTOM.pll customization.
• Have created test cases and test scripts for testing the new GAP’s.
• Have prepared MD070, MD120 and TE020 documents.
• Have created migration scripts by using FNDLOAD’s in shell scripts. Migrated all the objects from DEV instance to QA. Migrated code in to UAT and PRG by using Confidential RTP team support.

Confidential, Irvine, CA

Oracle 11i Applications Senior Consultant

Responsibilities:

• Worked on Sales Orders Interface.
• Worked on AP Invoices Interface.
• Worked on Customers Interface.
• Updated Customer contact information (Phones and Email) by using TCA API’s.
• Converted all SHIP TO’s and BILL TO’s, Contact Information(Email and Telephones) and Bank information from existing operating unit to new operating unit by using interface tables.
• Worked on Custom program to bring missing AR invoices from third party system to Oracle.
• Worked on Cash Receipts API for creating cash receipts and applying cash receipts against invoices.
• Worked on prepayment receipts API for creating prepayment receipts which are not being created because of hold.
• Worked on BAI2 interface
• Worked on Positive Pay Extract File for USA/CANADA/AUSTRALIA and UK.
• Worked on Error Handling Implementation for all interfaces.
• Migrated all Custom Responsibilities, Menus, Request Groups from once instance to other instances by using standard FNDLOAD API’s in shell script.
• Reviewed MD050’s and meeting with Business Analysts for gathering high level designs.
• Worked with offshore folks to resolve technical issues and also gaps in MD050’s.
• Worked on CUSTOM.pll customization.
• Have created test cases and test scripts for testing the new GAP’s.
• Have prepared MD070, MD120 and TE020 documents.
• Have created migration scripts by using shell scripts. Migrated all the objects from DEV instance to QA, UAT and PROD by using Arbonne DBA’s.

Confidential, Irvine, CA

Oracle 11i Applications Senior Consultant

Responsibilities:

• Worked on Sales Orders Interface.
• Worked on AP Invoices Interface.
• Worked on Customers Interface
• Worked on BAI2 interface
• Worked on PO document printing customization.
• Worked on PO Expected Receipts report.
• Designed Ship Confirm interface MD070.
• Worked on Positive Pay Extract File for USA
• Working on Error Handling Implementation for all interfaces.
• Reviewed MD050’s and meeting with Business Analysts for gathering high level designs.
• Worked with offshore folks to resolve technical issues and also gaps in MD050’s.
• Have created test cases and test scripts for testing the new GAP’s.
• Have prepared MD070, MD120 and TE020 documents.
• Have created migration scripts by using shell scripts. Migrated all the objects from DEV instance to QA, UAT and PROD by using Arbonne DBA’s.
• Have worked as an onsite coordinator to handly offshore IBM Team.

Confidential, Santa Ana, CA

Oracle 11i Application Consultant

Responsibilities:

• Worked on Workflow for Task Manager (JTFTASK) customization for sending noticiations to different approavals depending on task type.
• Worked on Quoting Approval Workflow (ASOAPPRV) customization.
• Developed new Oracle forms for defining workflow rules and workflow approval hierarchies by using TEMPLATE.fmb
• Reviewed MD050’s and meeting with Business Analysts for gathering high level designs.
• Worked with offshore folks to resolve technical issues and also gaps in MD050’s.
• Working on CUSTOM.pll customization.
• Have created test cases and test scripts for testing the new GAP’s.
• Have prepared MD070, MD120 and TE020 documents.
• Have created migration scripts by using shell scripts. Migrated all the objects from DEV instance to QA, UAT and PROD by using FARES DBA’s.
• Designed a workflow notification document after first shipment in Order Management through Alerts.
• Have designed JSP, JAVA custom form as per the clients requirement in Quoting module.
• Developed 4 custom reports by using reports 6i, XML Publisher.
• Interacted with super users, participating in discussions for collecting the required information and its analysis for the design and development of customizations with business analysts and also with functional folks.
• Helped offshore technical team and resolved critical open issues.