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 with 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.
• Significant experience in system implementation and production support including international (LATAM, EMEA, APAC) with a strong operational and finance background
• Highly skillful in Designing completely new system and troubleshooting the legacy systems with 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.
• Has expertise in Oracle Applications E - Business Suite on Oracle Order Management ( OM ), Advance Pricing, Oracle Purchase Order ( PO ), Oracle General Ledger ( GL ), Oracle Payables ( AP ), Oracle Receivables (AR), Oracle Bill of Materials ( BOM ), WIP, Oracle Inventory ( INV ), and OTL modules and has 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 the information between The Client, Business users, Business Analysts, End users and offshore developers within Project and Tech Mahindra.
• Complete understanding of the 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 SRs with Oracle Technical Support, coordinating and following on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) sessions with 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 with 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 with base table data.
• Working Experience with onsite offshore model and managing offshore resources. Ability to adopt and master quickly new software technologies. Excellent team player with good communication and interpersonal skills.

PROFESSIONAL EXPERIENCE

Confidential, Louisville, Kentucky

Oracle Apps Technical Consultant

Responsibilities:

• As a Team member was responsible for Activities of Master Data Management using Chain-Sys Loader (Sales Orders, Customers, Suppliers, Sourcing Rules, Sourcing Rule Assignment sets, Item Order ability, billing references, Sales Agreements, Po Modifiers & Qualifiers, Items, Item Cross References, Shipping Networks,)
• Requirement gathering, analyzing, documenting and designing the solution.
• R12 Development - Create Technical designs documents and develop the application as per Functional design.
• Dimensions of Data Quality
• Developed a Program to create the Customers, Accounts, party sites, Party Relationships, Account Relationships
• Developed a Program to create the Item Order ability, Price Lists, Po Modifiers & Qualifiers, BOM & Routings, and Sales Agreements, Sales Orders
• Developed a Program to create the Billing References in R12.2.4 (User Defined Attributes)
• Developed a Program to create the Stock Locators.
• Onsite team member at the client and coordination with 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.
• Closely worked and coordinated and tested with the technical teams to deliver the solutions as per the functional designs.
• Designed and Performs detailed Validations on Inbound and outbound interfaces required to third party and Oracle EBS.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• As a Project Lead was responsible in Development Activities and Support of the Project. Also monitoring the delegation of work to the team. Below are the few responsibilities.
• Requirement gathering, analyzing, documenting and designing the solution.
• R12 Development - Create Technical designs documents and develop the application as per Functional design.
• Responsible for identifying, analyzing, and resolving technical problems with Oracle Applications.
• Developed Global DR4 Interface of GL Module to be used across all the 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 the On-Hand Quantity in Inventory
• For CZECH site, Developed BOM Routings Interface
• Developed a Program to create the Move Orders for the Released Jobs.
• Developed an AR Interface from a Legacy system called Orion.
• Developed FA Periodic Mass copy Program.
• As per the New Enterprise Standards Chart of Account (ESCOA), Modified all the existing Finance Related Reports and Interfaces (SSS GL, SSS CM, FA Periodic Mass copy)
• Developed MOR & GAP Rates Inbound Interface from GE 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).
• Developed Item On-Hand Report, Inventory Ageing Report, WIP Dispatch List Report
• Developed one of the most challenging Report called LOT Genealogy report as per the requirements and developed more than 20 Reports using XML Publisher
• Helping the team for any technical issues and coordinating with team and project manager.
• Execute Test Scripts as per Shakedown and Regression test documents.
• Prepared the training material for UAT and conducted web sessions to train the 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:

• As a team member, was responsible for
• Reviewing and analyzing the MD60’s in the project.
• Developing Interfaces based on the Customer Requirements.
• Developed Internal Sales Order (ISO) Interface
• Developed Inbound Receipts Interface
• Preparing the MD70 documents.
• Provided the Support during the testing phase.
• Delegation of work to the team.
• Helping the team for any technical issues.
• Coordinating with 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 the training material for UAT and conducted classroom/ web sessions to train the business users.

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

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Requirement gathering, analyzing, documenting and designing the solution.
• R12 Development - Create Technical designs documents and develop the application as per Functional design.
• Responsible for identifying, analyzing, and resolving technical problems with Oracle Applications.
• Design and develop Inbound and Outbound Interfaces to integrate with 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 with 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.
• Developed the Three fields (Country, State and City) in the OTL Page.
• Using LDT Files, Created the dependent value sets for each field and also created the country, state and city fields using FNDLOAD Utility.
• Developed the reports for each employee to pull the base location and working hours of the employee.
• 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 with Functional and Technical Consultants. Initiated Oracle Service Requests for the issues arising during execution of the test scripts.
• Initiated DBA (ERP EDD team-GE Support Central) tickets for applying upgrade patches for different releases, creating DB links request for source and ASCP instance.
• Initiated tickets internally with Help Point (GE Support Central - Expert team) for resolving the issues in custom business scenarios and helped support Shared services APEX Team & Regression Testing in resolving the 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:

• Includes Enhancements in PO Interface
• 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 (dis 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: dis enhancement includes the logic to identify the invoice created for Traveler PO, if invoice created tan the program should not error out and should further process the Program as exists
• Includes Enhancements in Invoice Interface
• To show the TR numbers in the Attribute 5, Attribute 6 and Attribute 7 of the Credit Memo for the Travel Claim NO SHOW cases
• Includes Enhancement in Travel Authorization Report
• Dynamic Text to be displayed when the payment method is 'Traveler Check'
• '' Note: The amount paid to the traveler will be rounded to the nearest 50.''
• Responsible for preparing the technical specification from the functional requirements Document, designing the 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 that will inform the CSR when copying quote in case an item within the quote is discontinued or going to get discontinued before the quote expiration date (???) or their was any BOM change between the time the item was created and the system date at the time of the copy.
• When creating a quote or booking an order the CSR may need to get easy access to the Product Line information of the products their entering. dis solution is implemented by using an unused free format field in both OC and OM that could be used to populate with the Product Line information.

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