Oracle Technical Consultant Resume
Richmond, VA
SUMMARY
- 14+ years of overall extensive IT experience in all aspects of Oracle Applications Analysis, Design, Development, Production Support, Testing, Migration, Conversion, Customization and Implementation and documentations.
- 8 years of work experience on Techno Functional knowledge on Oracle E - Business Suite Application in Supply Chain /CRM modules Order Management(OM), Pricing, Shipping, Purchasing(PO), Inventory(INV), BOM, WIP. Also, worked on Account Payables(AP) & GL custom solutions.
- Expertize in customization of Oracle Forms/Reports, Data Conversions, Real time Interfaces, Customizations, Extensions (RICE) on Oracle Applications R12 and 11i.
- Experience in Procure to Pay (P2P), Order to cash (O2C) life cycles.
- Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
- Experienced in Customizing Oracle Forms with Forms Personalization using Custom.pll and Zoom functionality.
- Experienced in Oracle Application upgrades from 11i to R12 releases.
- Experience working on complex applications using Oracle SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes, worked on Script development using UNIX and Shell Scripts.
- Knowledge of code migration tool Kintana (HP PPM), Clearcase, SVN and AIM Methodology.
- Onsite Site Post PROD Support, Enhancements & new solution development experience of Oracle Apps eBusiness Suite 11i & R12
- Participation in varied roles ranging from Team Lead, Techno Functional and Technical Consultant.
- Over 4 years of experience in managing and leading a team as a team leader and onsite-offshore coordinator.
- Expertise in preparing AIM(Application Implementation Methodology) Documents and User Manuals Functional Specification Document (MD050), Technical Design Document (MD070/CV060) and Conversion Mapping Document (CV040).
- Good experience in Oracle Applications Application Object library (AOL).
- Identified product gaps, coordinated with other Teams by creating Service Requests (SR) and obtained one-off fixes. Managed and monitored SRs for several P1 Issues. Provided on site solutions and resolved showstopper issues.
- Experience in Application System Administration activities like Managing Concurrent managers, Application User set up, Defining responsibilities, Value sets, Flex Fields, Registering menus and providing support to Apps end users.
- Good international experience of working in four different countries. USA, Malaysia, Singapore and India.
- Out-of-the-box thinking and creative problem solving.
- Excellent communication and interpersonal skills. Very good client relationship track. Good Leadership qualities with go-get abilities.
- Knowledge on TCA architecture.
TECHNICAL SKILLS
ERP: Oracle Application R12 and 11i (Order Management, Shipping Execution, Inventory, Purchasing, BOM, WIP, Oracle Workflow, iProcurement, AOL, SYSADMIN, XML Publisher Administrator, Integrated SOA Gateway, OIC and Account Payables
Programming Language: PL/SQL, SQL, Unix Shell Scripts
RDBMS: Oracle 9i, Oracle 10g, Oracle 11g and Oracle 12c
Development Tools: XML Publisher
Desktop Applications: PL/SQL Developer, SQL Developer, TOAD, SQL*Loader, Oracle Forms 6i and Reports 6i
Other Tools: Putty, SSH, WinSCP, PVCS, Clear Case, Kintana, SVN and Fiddler
PROFESSIONAL EXPERIENCE
Confidential, Richmond, VA
Oracle Sr. SCM Techno Functional Consultant
Responsibilities:
- Understand business requirement and prepare MD.070 document for enhancements to existing extensions
- Review the packages contents and ensure that change has properly done as per requested, tested and documented
- Explaining the action items to the offshore team
- Helping in closing related critical issues.
- Guiding team time to time whenever it is required and helping them out in case of any issue/bug
- Interacting directly to client by conf. call and Web-ex meeting.
- Taking the ownership of any object where it is required.
- Involved in all escalations call till issue resolutions, make sure to deliver the quality solutions on time, weekly status call with Customer/Stakeholders.
- Resolved multiple issues pertaining to Cancelled sales order and implemented the permanent solution for the same.
- Implemented a permanent solution to fix Preferred Access intermittent Automatic Reservation issue during Sales order booking.
- I was part of testing Preferred Access functionality for Oracle EBS Annual DR Exercise & also part of Q4 Patch testing.
- Also, Responsible for the Development/Enhancement of following Technical Components
Environment: Oracle Apps 12i (OM, INV, PO, and AP modules), PL/SQL procedures/Unix Shell Scripts, Oracle database 10g/11g/12c, TOAD, Oracle Reports, XML Publisher Reports, BMC Remedy UserTicketing tool, WinSCP and Putty
Confidential
Oracle Techno-Functional Consultant
Responsibilities:
- Involved in requirements gathering, analysis, development, QA and post-production support.
- Worked on Development/Enhancement of following Technical Components
- Used SQL* Loader and UTL FILE Packages for data conversion and interfaces.
Environment: Oracle Apps 12i (Modules -OM, INV, WSH, AP, PO and GL), PL/SQL procedures/Unix Shell Scripts, Oracle database 9i/10g, TOAD, Oracle Reports and BMC Ticketing tool and Putty
Confidential
Oracle OIC Technical Consultant
Responsibilities:
- MR Statement reports (Summary and Detail).
- Overlay/Rollup programs.
- GL Account Rate integration in OIC.
- Pay Plan Assignment Management Report.
- MR Accrual Report.
- Archiving Everest and SAP orders from Staging and Reference tables.
- Closed order logic added in Everest Order interface program.
Environment: Oracle Apps 12i (Modules -OM and OIC.), PL/SQL procedures, Oracle database 9i/10g, TOAD and OVSD Ticketing tool, Kintana, Clearcase, WinSCP and Putty.
Confidential
Oracle Techno-Functional Consultant & ON-SITE Co-Ordinator
Responsibilities:
- Reviewing CV60’s and Data Migration Codes and to make necessary changes required in technical documents and data migration codes.
- Was involved in coordinating with offshore Data migration Team for DM activities and helping them in resolving issues related to DM.
- Involved in optimize the performance and Enhancements of CEMLI objects.
- Involved in enhancement and testing of FedEX Interface.
- Involved in setup related change requests.
- Involved in Post Production Support of Technical issues of CEMLI objects till stabilization.
- Involved in all of the Test Cycles.
Environment: Oracle Apps 11i (Modules -INV, PO and OM), PL/SQL procedures, Oracle database 9i/10g, TOAD, SQL Developer, WinSCP, Putty, Kintana, Clearcase and OVSD ticketing tool.
Confidential
Oracle Technical Consultant
Responsibilities:
- This Task mainly involves the development of Extracts which would inturn be used for Data Conversions.
- Involved in the Upgradation Performed by the Avago from 11.5.5 to 11.5.10
- Involved in the development of following data conversions
- Item Pending Status and Item Cross References Conversions.
Environment: Oracle Apps 11i (Modules - Inventory, PO and OM.), PL/SQL procedures, Oracle database 9i/10g, PL/SQL Developer and SQL Loader.
Confidential
Oracle Technical Consultant
Responsibilities:
- Items Conversion.
- Conversion of item default locators.
- Customization Of PO Form TO Ensure No PO Is Created For Less Than US$1000.
- Custom Report For Purchase Orders With Matching Type By Supplier,By Period.
- Sales Orders And RMA Outbound Interface By Salesperson, By Customer.
Environment: Oracle Apps 11.5.7(Modules - INV, PO and OM), PL/SQL procedures, Oracle 9i, TOAD and SQL Loader.
Confidential
Oracle Technical Consultant
Responsibilities:
- Implement zoom in the sales order form to view the item definition information Passing Item As Parameter.
- Item ABC Codes Migration.
- Item Categories and category assignments conversion.
Environment: Oracle Apps 11i (INV, OM & PO), Reports 6i, TOAD, SQL Loader.