SUMMARY

• TEMPHas 11 years of experience in design, development, customization, operation support, upgrade and implementation of Oracle ERP applications 11i, R12 and Oracle Cloud Cloud.
• Proficient in all phases of Oracle Applications R12/11i implementation wif major focus in Financials (AR), Oracle Supply Chain & Manufacturing Modules (PO, INV, OM, Advance Pricing, Shipping, PO, WIP), Oracle HRMS, Service Contracts, PA, AOL,TCA and System Administration module.
• Have worked Technical Related issues across all modules
• Have strong Technical skills on different noledge areas as Oracle Forms, Oracle Reports, XML Reports, Discoverer, HTML DB Reports, SQL and PL/SQL, Work flows. He TEMPhas very good project experiences on delivering different RICE components and noledge on OAF frame work.
• Involved custom module implementation and integrated wif ERP standard Modules
• Expertise in Customization of Workflows and Debugging Workflow related issues
• Good Knowledge in Performance Tuning and Code Reviews.
• Expertise in Design and Development of Interfaces & Conversions from legacy systems.
• Expertise in developing Concurrent Programs, Extensively used SQL*Loader for conversion and interface programs.
• Good SQL, PL/SQL and Unix Shell scripting skills. Proficient in writing Stored Procedures, Functions, Packages and Database Triggers.
• Involved in various stages of Analysis, Design, Development, Testing, and Implementation of application development.
• TEMPHas worked extensively on different version control and code migration tools such as PVCS, Kintana etc.
• Experience includes Application System Administration activities like application user setup, defining responsibilities, values sets, flex fields, reports, and concurrent programs and providing support to apps users for any technical or functional issues.
• Extensive experience in developing Functional Specifications (MD50), Technical Specification Documents (MD70), Conversion Specifications (CV70) in AIM Methodology standards.
• Experience in preparing Test Plan, Unit Testing, System Integration Testing and Documentation. Provided support all through SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Experience in Order to Cash (O2C) and Procure to Pay (P2P) business flows.
• Worked wif Offshore Technical team on Development, Testing and Migration of Objects.
• Experience in month end closing activities in Finance.
• Hands on experience in troubleshooting issues and resolving tickets on priority.

TECHNICAL SKILLS

ERP: Oracle Cloud, Oracle Applications R12, 11i

E - Business suite Modules: PO,PA, AR, SYSADMIN, INV, OM, PO, HRMS,TCA and Custom Modules

RDBMS: Oracle 10g, 9i, 8i

Operating Systems: LINUX, Sun-Solaris, Unix, Windows 9X/2K/XP

Languages: SQL, PL/SQL

Tools & Utilities: Forms 10g/6i, Reports 10g/6i, XML/BI Publisher, SQL*Plus, QL*Loader, Oracle Workflow Builder, TOAD, SQL Developer, Data Loader, WEBADI, WINSCP, Putty, HP Quality center, Microsoft word, excel, PowerPoint

Documentation: AIM Documentation (MD070, MD120, MD050, BR100, CV60, CV40)

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

Oracle Applications Technical Consultant (R12) and Cloud Technical Consultant

Responsibilities:

• Creating Oracle Applications concurrent programs for teh functional requirements of AR and Order Management modules.
• Interface Designing and Applications program development.
• Working on Acquisitions Team to get teh Requirements from team and Process as required.
• Worked on to modify RDF Reports and Pl/Sql Reports in R12.
• Worked on to developed interface as per business Requirements in R12.
• Responsible for Acquisitions Data load and Weekend Activities.
• Responsible for Import Customers and AR Information into ERP systems.
• Working on PROD bug fixes and Enhancements.
• Developed ADP Time Card Interface from 3rd Party Systems.
• Involved All Acquisition Related Issues.
• As part of conversion process, Imported data from legacy system to Oracle Apps tables using SQL*Loader and validate them using PL/SQL procedures.
• Developed Customer Conversion to load newly acquired company’s customer data into Oracle base tables.
• Used joins, indexes TEMPeffectively for Query optimization
• Worked on development of Oracle APIs using ERP data and API’s for development of custom application CFLi, developed for water.com call center.

Confidential - Atlanta, GA

Oracle Cloud Technical Consultant

Responsibilities:

• Worked on FBDI process in Customers, Suppliers and Employees.
• Worked on PO PDF Data model Customization in cloud.
• Development New Oracle Cloud BI Reports as per Business New Requirements.
• Customized Bill of Material and Pick slip Report in Cloud.
• Developed new Oracle BI Reports for month end close in Oracle Cloud
• Worked on FA Module Customizations in cloud.
• Worked on GL and GL Daily Interface in cloud
• Provided Required Support to Java team to find Web services names in cloud.
• Worked on WSDI files to identify teh Interface Process in cloud.

Confidential

Oracle Apps Techno Functional Consultant Lead

Responsibilities:

• Being teh onsite team lead of teh instance, I is acting as teh single point of contact (SPC) for FOXTROT AERO Instance
• Presenting open case status during weekly review call wif Business TAR handling wif Oracle and communicating wif teh Oracle SDM (Support Development Manager) for quick resolution of teh TARs .
• Attending issue meetings wif teh business and to make sure wif teh team mates to strictly follow teh corrective action plans for teh issues
• Worked on Inbound and Outbound Interfaces like AR lock Box, OSC and custom Interfaces.
• Worked on 3 XML Reports as per business Requirements.
• Developed new interfaces as part of Enhancement Requests.
• Handled all type Sysadmin Activities
• Worked on Performance Tuning of existing custom Interfaces.
• Involved Customer Imports to AR module from various systems.
• Involved PO module wif Different Integrations.
• Developed Cost File Process into PA module
• PA client customization using client extensions procedure.
• Involved Accounting Rules Related to PA module customizations.
• Worked on Build complex Queries as per business Requirements.
• Worked on INV On hand Quantity Interface to send Daily quantity information to different systems.
• Worked on pricing information to load teh data in ERP instance from different system.
• Monitoring Critical Programs as part of month end activities.
• As onsite Lead Responsible for All End to End technical Issues and SME for Technical

Confidential

Oracle Apps Technical Consultant Lead

Responsibilities:

• As a team member, was responsible for
• Monitoring of production closing runs.
• Handled P1 issues in Quarter ends.
• Integration and Testing of different accounting structures coming from different SOB’s.
• Performing sanity checks etc.
• Involving weekly meetings to check teh status of teh new issues.

Confidential

Oracle Apps Technical Consultant Lead

Responsibilities:

• Code Fixes
• Data Fixes
• TAR Management
• Support for cutover Upgrades activities
• Minor Enhancements
• Process Standardization (Coding & review)
• RICE (Workflow, Reports, Interfaces, Conversions, Enhancements)
• Service call analysis and solution design
• Monitoring Custom workflows and standard workflows’ Process
• Responsible for all related workflow activities.
• Oracle SRs creation and follow ups.
• Scheduled concurrent programs monitoring
• Planning in teh process of developing new objects (Enhancements)

Confidential

Oracle Apps Technical Consultant Lead

Responsibilities:

• Handling teh service requests for issues relating to Purchasing Inventory.
• Handling Prod related Bolton’s such as WHO Registration Page, Goods, Services, Workflow Monitoring tool(dis tool be will be used to display status of transaction of all work flows such as PRT,TRL,HR and PAY).
• Handling bug fixes wifout customer escalations.
• Responding P1 issues wifin SLA given time.
• Exclusive responsibilities for handling teh interface issues relating to Requisitions, Receiving.
• Working closely wif teh functional team for contributing inputs as to teh data fix script, error table cleaning and fix movement to teh production instance.
• Preparation and review of teh user training documents on complex components.
• Preparation and review of teh updated technical FAQ documents used for technical support.
• Handling teh work allocation for teh Level 4 support team for Purchasing and Inventory.
• Contributing in road map for teh MLS requirements for teh roll outs where teh components are to be delivered in French language.
• Contributed to and reviewed MD.050 for enhancements relating to Purchase Order Acceptances.
• Exclusive responsibilities on effort estimations relating to enhancements.
• Exclusive responsibilities for approval and movement of fixes to LIVE instance.
• Leading teh enhancement team for procurement.
• No delay in delivering teh fixes.
• A very few regression issues making teh PRT code stable.
• Handled TA related tasks like Risk Free and Risk Prone.
• Involved in client side testing like such as PVCS and KINTANA tools.
• Maintain teh Process implementation and meeting deadlines in issue fixing/Resolution.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Understanding teh report functionality, analysis and review of High Level Documents mainly MD 050s.
• Designing MD 070 and Unit Test Cases.
• Designing MD 065 and Unit Test Cases.
• Code Migration from one database to another database using PVCS and Kintana Tools.
• Registration of Concurrent programs, Attaching concurrent programs to Request Groups, Creation of Value sets, placing teh reports and interfaces in teh AOL directory of teh server.
• Analysis of teh specifications provided by teh clients.
• Design & Customization of reports.
• Design & customization of Forms.
• Design & Development of Discoverer 10G Reports.
• Design & Development of XML reports.
• Development and support of interfaces.
• Application development for RICE components, Coding, testing etc.
• Functional & technical document Preparation as per AIM methodology.
• Adhering and Management of quality related issues as per SEI-CMM Level 5.
• Development of Conversion Strategy (CV.010) and Transition Strategy (PM.010)
• Review of Functional Design Documents for extension of standard Oracle Applications and Reports (MD.050 and MD.065). Instrumental in design, review and stability of teh WHO’s service procurement business and receiving function model.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Registration of Concurrent programs, Attaching concurrent programs to Request Groups, Creation of Value sets, placing teh reports and interfaces in teh AOL directory of teh server.
• Analysis of teh specifications provided by teh clients.
• Design & Customization of reports.
• Functional & technical document Preparation as per AIM methodology.
• Adhering and Management of quality related issues as per SEI-CMM Level 5.
• Understanding teh report functionality and Analysis and Review of High Level Documents mainly MD 065s.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Understanding teh report functionality and Analysis and Review of High Level Documents mainly MD 065s.
• Registration of Concurrent programs, Attaching concurrent programs to Request Groups, Creation of Value sets, placing teh reports and interfaces in teh AOL directory of teh server.
• Analysis of teh specifications provided by teh clients.
• Design & Customization of reports.
• Preparation of Technical Design document.
• Registration of forms and other objects in AOL.