PROFESSIONAL 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.
• 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 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 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 Analysis Projects, 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 SR’s 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 effective 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

Oracle Apps Technical Consultant

Responsibilities:

• As a Project Lead was responsible in Development Activities
• 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
• 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 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).
• 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.
• Involved in testing the Functionality on the application for all new change request and new Roll Outs
• 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.
• Data conversion of customers, suppliers, open AR transactions, GL balances, budgets and fixed assets

Application: Oracle EBS R12.2.6, Modules: GL, AR, AP OM, PO, BOM, WIP

Tools/Language: 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:

• 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
• Developed a Program to create the Customers, Accounts, party sites, Party Relationships, Account Relationships
• Developed a Program to create the Item Orderability, Po Modifiers & Qualifiers, BOM & Routings, and Sales Agreements
• Developed a Program to create the Billing References in R12.2.4 (User Defined Attributes)
• For CZECH site, Developed BOM Routings Interface
• Developed a Program to create the Move Orders for the Released Jobs.
• 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 TEMPthan 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.

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