EXECUTIVE SUMMARY:

• Over 4 years of experience years of work experience as Oracle Application Techno functional Consultant (Oracle E Business Suit 11i, R12) with proven expertise in Implementation, enhancement, rollout and support Projects.
• I have worked with KPIT Technologies from May, 2013 to July, 2016 for Confidential client (BOLT Project)
• After KPIT I worked with Confidential Technology Solutions from August, 2016 to Feb, 2017 (Internal project & trainings)
• Strong development skills with Oracle SQL,PLSQL, Oracle Reports, Oracle Forms, Oracle Web ADI, BI Publisher(XML Publisher) and Oracle workflow as my role was as technical developer in the project.
• Using PLSQL developed many custom interfaces for data transfer, validation and oracle EBS seeded table insertion.
• Independently worked on WebADI solution development for AR - Invoice creation in R12 instance. For that I have worked on design, validation, development, testing, and migrations of WebADI.
• Extensive experience in working with Oracle Applications 11i/R12 Finance modules such as Oracle Payables (AP), oracle Receivables(AR), General Ledger(GL) and working experience in SCM modules such as Purchasing (PO), Order Management (OM), Inventory (INV).
• Contributed for various types of oracle Apps projects (Developments, Implementations & roll-outs, Support/Maintenance and Upgrade).
• Worked on Oracle iSetup for quality plans
• Expertise in Procure to Pay (P2P) and Order to Cash (O2C) .
• Expertise in developing RICEF components (Reports, Interfaces, API’s, Conversions, Workflow) in Oracle Applications E-Business suite 11i and R12.
• Profound Experience in development of Application Object Library (AOL) like registration of Concurrent Programs and Reports, Request Groups, Responsibilities, defining Profile & their values, Value Sets, Alert, lookup, Quality plans.
• Proficient in using SQL*Loader, PL/SQL and APIs for data Conversions and Validations worked on Stored Procedures, Functions, Packages, Database Triggers.
• Taking part in cut over plans to discuss the black out, code migration, set ups and other activities. I have worked on migrations & setups of custom interfaces and related objects on 50 instances.
• Good knowledge on Scheduler Appworx chain development, update.
• Good knowledge on customizing and personalizing forms.
• Good Experience in creating, maintaining and managing SR’s with Oracle Support via Metal ink.
• Proven ability to deliver the task on time with excellent quality and customer satisfaction.
• A good team player and leadership skills, capable of quickly adapting to new challenges and environments. Ability to work independently and lead teams.
• Insightful experience in all phases of the system development /implementation life cycle (SDLC).
• Prepare & Review Test plan, Test scope Documents and Test cases, Key resource in successful execution of - UT(Unit Testing),FIT(Functional Integration Test),SIT(Systems Integration Test) and CAT(Client Acceptance Test)
• Good working knowledge of all the stages of Applications Implementation Methodology (AIM). Worked on MD 50, MD 70 & MD 120.

TECHNICAL SKILLS:

ERP: Oracle Applications 11i, R12

Databases: Oracle 9i/10g/11g

Operating Systems: UNIX, Linux, Windows NT/ XP, 2003, 2007

Languages: Oracle SQL, PL/SQL

Oracle Tools: Oracle D2K Reports 10g, Oracle Forms, XML Publisher, SQL*Plus, Apex, XML publisher, TOAD, SQL Developer, Workflow builder, Remedy, Appworx, WebADI, Advance Queue and De queue technique & ODI Technique.

Other Tools: TOAD, WinSCP, Putty.

PROFESSIONAL EXPERIENCE:

Confidential, IN

Oracle Apps Technical consultant

Environment: Oracle Applications R12 (PO, AP, GL, AR, Oracle iSetup, INV, OM), Oracle 10g, Reports 10, XML Publisher, WebADI, Toad, Remedy, Appworx, Workflow, Advance queue and Dequeue.

Responsibilities:

• As being technical developer worked on Packages, procedures, functions, cursors, refcursors, triggers, dynamic SQLs, oracle provided seeded functions.
• Also worked on table, view objects.
• Worked on Bulk fetch operations and getting data in PLSQL tables (nested tables).
• Worked on insert, update & delete operations on tables through custom interface developed with PL SQLs. Worked on complex queries for reports and query tuning. Worked on PL SQL package performance tuning.
• Worked on SQL loader for loading data in tables from dat files.
• Contribution to Project Enhancements - Participated in Design, Construction, Testing, Pre -Implementation and Post -Implementation Activities.
• Worked on PO conversion
• Involved in Retrofitting activity 11i to R12
• Worked on different report development.
• Worked on new Appworx chain development & enhancements.
• Worked on Oracle iSetup for quality plan development.
• Worked on development, SIT, UAT testing & migrations.
• Migrated more than 500 objects (Concurrent, Report groups, Responsibilities, Forms, Reports, WebADI, Quality plans, profiles, alerts, value sets, lookups, etc.) on more than 50 SIT, UAT & prod instances.
• Worked on testing for PO, AP-Receipts, Match Invoice, AR-Invoices, GL Interface data transfer.
• While infant care support for different issues after go live
• Web ADI development, BNE registration (including preparing end to end solution document) worked direct with external client.
• Worked on solution design documents for new developments and enhancements.
• Understanding clients current business process and application
• Created Procedures, reports, webADI, Packages and registered them as concurrent Programs.
• Created excel based PLSQL reports.
• Created tables and registered them with AOL.
• Created technical specifications and the test cases as per the functionality
• Testing the Reports after up gradation Activity.
• Worked on Advance queue for AR-Invoice data outbound.
• Involved in discussion with the Client for the Requirements gathering.
• Involved in fixing the Defects and enhancements
• Gave training on WebADI to team members

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• As being technical team member worked on different objects.
• Worked on different AOL objects.
• Worked on Appworx job chain development & changes
• Worked on changes of existing custom inbound and outbound interfaces.
• Worked on form customization

Confidential

Oracle Apps Technical - Associate

Responsibilities:

• Creation of different AOL objects
• Development, Enhancement & Testing of custom interfaces
• Worked on migration of different objects and reconciliation of all the objects and their values migrated
• Worked on Quality plan creation.