SUMMARY

• 14+ years of extensive experience in Oracle Applications R12/11i EBS full life cycle implementations, business process analysis, evaluation, upgradation, rollouts, enhancements, data conversion and integrations of Oracle Financials and SCM modules wif third party applications.
• Experience in various business process like Order to Cash (O2C) & Procure to Pay (P2P)
• Hands on experience in Oracle EBS on requirement study, fit gap analysis, solution design, application setup and testing of Oracle financials and SCM modules.
• Highly skillful in Designing completely new system and troubleshooting teh legacy systems wif unique ability to deliver under critical time bound requirements.
• Expertise in Development of Inbound & Outbound Interfaces, Conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using SQL, PL/SQL, Data Load, SQL*Loader, PL/SQL and UTL File Utility for Outbound Interfaces.
• Customizations of Oracle Workflows, Oracle Reports using XML Publisher, and Oracle Forms & Reports, Form Personalization’s.
• TEMPHas expertise in Oracle Applications E - Business Suite on Oracle General Ledger ( GL ), Subledger Accounting (SLA), Accounts Receivables (AR), Accounts Payables (AP), Financial Accounting Hub (FAH), Oracle Order Management (OM), Oracle Inventory (Inv), Oracle Purchase Order ( PO ) and Confidential modules and TEMPhas Good Knowledge in Oracle Workflow Builder.
• Active Participation in different phases of CRP1, CRP2, SIT, UAT, Production Cutover, Cutover Support.
• Expertise in various Application Extensions, Conversions, and Process Re-engineering (RICE) and preparing Technical Document Design and Testing Documents developed through Oracle User Productivity Kit Professional (UPK) tool.
• Experienced in coordinating and translating teh information between Teh Client, Business users, Business Analysis Projects, End users and offshore developers wifin Project and Tech Mahindra.
• Complete understanding of teh Oracle Upgrade process involving in pre-upgrade analysis, pre-upgrade configurations, patch planning, post upgrade configurations, testing, CEMILI identification and migration and post upgrade support.
• Extensive working experience in Production support and Month End Support - Identifying issues, prioritization, performing root cause analysis, and providing solutions as needed.
• Proficient in creating SR’s wif Oracle Technical Support, coordinating and following on multiple issues based on priority including identifying bugs and follow-up wif Oracle Development as well as conducting Oracle Web Conference (OWC) sessions wif Oracle Support Team
• Hands on experience in writing test cases as part global GL period close which includes GL period closing activity including running revaluation, reporting currencies, translation, MRC, consolidation, reconciliation GL wif sub ledgers, SLA drill down reports and opening and closing GL periods
• Proven hands on experience in understanding various types of EBS interface testing requirements, designing TEMPeffective testing cycle, drill down to PLSQL validation, EBS open interface tables, writing SQL to match wif base table data.
• Working Experience wif onsite offshore model and managing offshore resources. Ability to adopt and master quickly new software technologies. Excellent team player wif good communication and interpersonal skills.

PROFESSIONAL EXPERIENCE

Confidential, Louisville, Kentucky

Oracle Apps Technical Consultant

Responsibilities:

• Requirement gathering, analyzing, documenting and designing teh solution.
• R12 Development - Create Technical designs documents and develop teh application as per Functional design.
• Dimensions of Data Quality
• GEA Suppliers Statement Report Using BI Publisher
• GEA Supplier Balance Confirmation Letter Using BI Publisher
• GEA VAT Sales Invoice Using BI Publisher
• GEA Customer Balance Report using BI Publisher
• Developed an AR Interface from a Legacy system called Orion
• Developed FA Periodic Mass copy Program
• As per teh New Enterprise Standards Chart of Account (ESCOA), Modified all teh existing Finance Related Reports and Interfaces (SSS GL, SSS CM, FA Periodic Mass copy)
• Developed MOR & GAP Rates Inbound Interface from Confidential Treasury Server
• Developed AR Invoices Inbound interface from third party system (Concur) for Poland Site
• Developed Web cash Interface for Payments (from R12 Oracle AP module to web cash server).
• Onsite team member at teh client and coordination wif offshore Technical, functional and testing team including working as liaison between business users, offshore team, helping offshore team to understand data conversions, customizations, integrations, execution of test cases across Financials.
• Involved in testing teh Functionality on teh application for all new change request and new Roll Outs
• Closely worked and coordinated and tested wif teh technical teams to deliver teh solutions as per teh functional designs.
• Designed and Performs detailed Validations on Inbound and outbound interfaces required to third party and Oracle EBS.
• Data conversion of customers, suppliers, open AR transactions, GL balances, budgets and fixed assets

Environment: Oracle Workflow Builder, Chainsys Apploader, SQL*Loader, XML Publisher, Toad, SQL Developer, UTL File, SQL Trace, TKproof, Chainsys Loader for MDM Data.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Requirement gathering, analyzing, documenting and designing teh solution.
• R12 Development - Create Technical designs documents and develop teh application as per Functional design.
• Responsible for identifying, analyzing, and resolving technical problems wif Oracle Applications.
• Developed Global DR4 Interface of GL Module to be used across all teh sites (Poland, Mexico and Turkey)
• Design data migration strategy for day to day data, PO’s, Items, Suppliers, AP Open invoices.
• Developed a Program to create teh On-Hand Quantity in Inventory
• Developed a Program to create teh Customers, Accounts, party sites, Party Relationships, Account Relationships
• Developed a Program to create teh Item Orderability, Po Modifiers & Qualifiers, BOM & Routings, and Sales Agreements
• Developed a Program to create teh Billing References in R12.2.4 (User Defined Attributes)
• For CZECH site, Developed BOM Routings Interface
• Developed a Program to create teh Move Orders for teh Released Jobs.
• Developed Item On-Hand Report, Inventory Ageing Report, WIP Dispatch List Report
• Developed one of teh most challenging Report called LOT Genealogy report as per teh requirements and Developed more TEMPthan 20 Reports using XML Publisher
• Helping teh team for any technical issues and Coordinating wif team and project manager.
• Execute Test Scripts as per Shakedown and Regression test documents.
• Prepared teh training material for UAT and conducted web sessions to train teh business users.
• Cut-over planning and go-live activities, followed by production support.

Environment: Oracle R12 (Payables, GL, AR, FA, BOM INV, WIP), Oracle Workflow Builder, Report Builder, SQL Plus, SQL Developer, Toad, SQL Loader, Oracle Forms & Reports 6i

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Reviewing and analyzing teh MD60’s in teh project.
• Developing Interfaces based on teh Customer Requirements.
• Developed Internal Sales Order (ISO) Interface
• Developed Inbound Receipts Interface
• Preparing teh MD70 documents.
• Provided teh Support during teh testing phase
• Delegation of work to teh team.
• Helping teh team for any technical issues.
• Coordinating wif team and project manager.
• Responsible for end to end flow of various Testing Phases including and not limited to Unit Testing, Functional Testing, System Integration Testing of various business processes in Oracle Financials
• Prepared teh training material for UAT and conducted classroom/ web sessions to train teh business users.

Environment: Oracle R12 Financials (GL, Payables, Receivables)

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Requirement gathering, analyzing, documenting and designing teh solution.
• R12 Development - Create Technical designs documents and develop teh application as per Functional design.
• Responsible for identifying, analyzing, and resolving technical problems wif Oracle Applications.
• Design and develop Inbound and Outbound Interfaces to integrate wif 3rd party applications and Custom reports in XML Publisher and Conversion programs for Oracle Reports.
• Developed PO and PO Receipts Inbound Interface for Turkey Site
• Developed around 25 Reports using XML Publisher, also Includes Enhancements Change Requests.
• Support and fix bugs raised by customers during SIT, UAT and post go live support.
• Providing customized solutions as per customer CR’s and ER’s. Creating Reports, Interfaces, Configuration, and Enhancements (RICE) methodologies for requested Customers using Oracle standards.
• Specifically develop resolutions to technical issues wif Oracle software by setting up oracle test cases in replicated environments, analyzing data setups, applying patches and creating workaround solutions according to Oracle methodologies.
• Suggest a variety of Oracle based technical resolutions, and assist customers, developers and analysts in solving technical problems.
• Documenting, developing and testing Unit Test Plans.

Environment: Oracle Applications 12.2 (GL, AP, AR, CM), SQL, PL/SQL, HP Quality Center.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Developed teh Three fields (Country, State and City) in teh Confidential Page.
• Using LDT Files, Created teh dependent value sets for each field and also created teh country, state and city fields using FNDLOAD Utility.
• Developed teh reports for Each employee to pull teh base location and working hours of teh employee.

Environment: Oracle Applications R12 SQL, PL/SQL, Oracle Database 10g, Reports 10g, TOAD, SQL*Loader, Putty, WinSCP

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Executing Functional & Technical Test Scripts in Manufacturing (BOM, WIP) and SCM modules (INV, PO and OM) also custom test scripts as required. Was coordinating activities wif Functional and Technical Consultants. Initiated Oracle Service Requests for teh issues arising during execution of teh test scripts.
• Initiated DBA (ERP EDD team- Confidential Support Central) tickets for applying upgrade patches for different releases, creating DB links request for source and ASCP instance. Initiated tickets internally wif Help Point ( Confidential Support Central - Expert team) for resolving teh issues in custom business scenarios and helped support Shared services APEX Team & Regression Testing in resolving teh issues pertaining to their area.

Environment: Oracle Applications 11i (BOM, WIP, INV), Oracle Database 10g/11g, SQL, PL/SQL

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Expenditure Item date for all PO distributions should be TR - first departure Date.
• GL date for all PO distributions should be, highest of PO Creation Date (SYSDATE) or Biennium start date (this is derived based on Project Start Date).
• If multiple Projects are involved, GL date on distribution line should be derived from respective Project Start Date
• TR revisions: This enhancement includes teh logic to identify teh invoice created for Traveller PO, if invoice created then teh program should not error out and should further process teh Program as exists Includes Enhancements in Invoice Interface
• To show teh TR numbers in teh Attribute 5, Attribute 6 and Attribute 7 of teh Credit Memo for teh Travel Claim NO SHOW cases Includes Enhancement in Travel Authorization Report
• Dynamic Text to be displayed when teh payment method is 'Traveler Check'

Environment: ERP Applications Oracle EBS 11i (PO, GL, TR)

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Responsible for preparing teh technical specification from teh functional requirements Document, designing teh program, programming and production migration.
• Responsible for preparing procedures, functions, packages as per requirement.
• Involved in unit testing, solving issues during integration testing and acceptance testing.
• Involved in migrating components to instances.
• Preparing Code reviews and test scripts.
• Using Form personalization and provided an alert mechanism dat will inform teh CSR when copying quote in case an item wifin teh quote is discontinued or going to get discontinued before teh quote expiration date (???) or their was any BOM change between teh time teh item was created and teh system date at teh time of teh copy.
• When creating a quote or booking an order teh CSR may need to get easy access to teh Product Line information of teh products they’re entering. This solution is implemented by using an unused free format field in both OC and OM dat could be used to populate wif teh Product Line information.

Environment: Oracle Applications 11i (OM), SQL Loader, UTL File Utility, Workflow Builder, Toad, Forms 6i & Reports 6i

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Purchase Agreement validation on Order Capture: Validation is implemented using Oracle Forms personalization; Validation is triggered when teh quote status changes from “Draft” to “Bid” and custom message is populated
• Brazil Flex field validation: Validation is implemented using Oracle Forms personalization, validated teh site globalized flexfields dat are linked to teh Bill To site on teh order record and if any of teh globalized flexfields are NULL, then a Popup window should be populated wif message “Bill to Address: Customer ID is not complete. Contact CMD to has it populated.”

Environment: ERP Applications Oracle EBS 11i (PO, AR)

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Developed a New Workflow Process, This Workflow will route e-mail notifications based on certain criteria
• A concurrent Program “Agilent PO Accrual Notifications” is developed which would be responsible for sending out notification for each eligible validated record in teh Custom notification table
• Developed teh Body content of teh for each different Notification

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Automation of PO Auto Closure: - Enhanced teh code logic for all PO dat TEMPhas past 90 days or more from teh promised/needed by date, Notification would be sent dat teh PO will be finally closed in teh next 90 days, Another Notification will be sent on teh 150 days or more from teh promised/needed by date dat teh PO would be finally closed in teh next 30 days.
• EMG market Segmentation: Customer Industry, Lifecycle and Distribution data needed to be pre-populated in Oracle as one of a fixed lists of choices. Teh data is provided for population in teh form of an excel file list of Customer-Ship-To-Site-Code wif three assigned data fields, developed teh coding to populate teh data in oracle and Enabled teh DFF segments for Customers using atrtributes9,10qnd 11
• Deliver design documents, (MD070’s), Unit Test Results (TE30), Release Notes